Solved

ACT 11 - upgrade issues - graded bad for the Wizard down south - should'a been a A rather than B - still working on it!

Posted on 2008-10-21
8
582 Views
Last Modified: 2010-04-21
Hi there - new to this - I think that I closed the issue rather fast - the expert advise is really brilliant - an "A" rather than the B indicated - (I still hadn't solved the problem) - I have gone through the link, and have attemtpted to rebuold/repair the database (Stage 1 of the solution posted) - I have got the error -
"cannot find either column "dbo" or the user-defined function or aggregate "dbo.FNC_CONVERT_INITIALCAPS", OR THE NAME IS AMBIGUOUS.
Tranasaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count + 0, current count = 1.

Any more help would be great -  PLEASE - thanks v much
0
Comment
Question by:Craiglnf
  • 5
  • 3
8 Comments
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 22770123
Then you'll need to try the 2nd part...

This is a procedure I wrote to get the most clean install possible:
Uninstall any version of ACT! from Windows Control Panel | Add/Remove Programs
Use the Uninstaller.exe from the ACT! KB 19338 (the exe, not the manual uninstall)
Make sure you select to also remove the ACT! SQL instance as this is likely where the issue is
Uninstall .Net Framework (all versions) - this does NOT apply to Vista users as .Net 2.0 is part of the OS and can't be uninstalled
Uninstall any MS SQL items from the Control Panel if still there
Uninstall MSXML 6 Services from Control Panel if it's still there
Perform a Selective restart with MSCONFIG as per ACT! KB 14499
Install .Net 2.0 Framework (only 2.0 for ACT! 9/10/11) as per KB 19628 (only XP, not Vista)
Install ACT! 11.0 full install
Restore from Selective Startup Mode with MSCONFIG
Reboot

Takes time, but will give the cleanest and most stable install.

For the KB numbers, go here http://tinyurl.com/34xq94 - put the number in "Search Text" and change "Search By" to Answer ID

If that doesn't help, will need to wait for tomorrow as I'm off to bed.

But, if need more... what version was the ACT! you're upgrading from? On what OS?
Also, please post the contents of the error log described in the first post
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 22770139
Not an issue now... but for future reference, if asking a question that's urgent or difficult you should usually set 500 points
0
 

Author Comment

by:Craiglnf
ID: 22770197
Thank you very much - will give it a go and get back to you - all your help is greatly appreciated - thanks - I should think by the time you wake I will have got through that list! - But I am sure it will do the job - thanks
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 22770321
Where are you based? I might be able to recommend someone local who can help with this as it's a bit complex.

As I said previously - MAKE SURE you have a backup
0
 

Author Comment

by:Craiglnf
ID: 22770787
I am UK - Gloucestershire - Near Cirencester - any suggestions of some local help would be great - asap - as would like to get ity resolved today/tomorrow - thanks v much -
0
 
LVL 30

Accepted Solution

by:
Mike Lazarus earned 50 total points
ID: 22771023
From the list here - http://www.sage.co.uk/PDF/ACT_ACC_Listing_2009.pdf

The only one I know well is Rainer Hoffmueller... he was pretty good last time I saw work from him.

Even if he's not nearby, he should be able to remote into your system. Tell him I said hi.
0
 

Author Closing Comment

by:Craiglnf
ID: 31508490
Thank you v much  will try first thing tomorrow am - and let you know - thanks for all your help - Craig
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 22771150
Ranier might not remember my company (GL Computing)... my name is Mike Lazarus :-)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

ACT LINK FOR PEACHTREE WON’T LINK PROBLEM       It always seems that when you upgrade Act or Peachtree Quantum in versions 2009, 2010, 2011, or 2012 then try to relink them it fails. Following the linking instructions-  Go to the peachtree tab in …
Article by: Dermot
The life of crime is over for 22 year-old Christian Ian Salvador, a student from Isabela State University in the Philippines.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question