ACT Verison 11 - upgrade issue - Exceptions occurred

Posted on 2008-10-21
Last Modified: 2012-06-27
Naive, but trying - to get the new version of ACT to work - as we have had so many problems with Outlook in the past - I have installed it on the Server (and the two computers -( 2 user license) - cant get hold of the support team - (for which I pay - so much for 24/7) - the error on the server is - " Exceptions occured while executing Db Schema Update Script. Check the errors in C:\Documents and Settings\All Users\Application Data\Sage Software, Inc ..................

I have seen this before on the forum, and just like the last guy - I am trying to get this done before tomorrow, and yet it is after hours at Sage/Act and although I have paid my money - I cant get the support to sort it -

It maybe something simple, we are a very small eductaional business, and I could not be considered the It department for a second - so any and all help would be greatly appreciated - thank you - Craig
Question by:Craiglnf
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 30

Accepted Solution

Mike Lazarus earned 50 total points
ID: 22769509
I don't think Sage has a 24/7 support offering for ACT!

Before anything else... make sure you have a backup. If not, as you can't open the db, stop the SQL services (Start | Run | Services.msc and stop SQLAGENT$ACT7 and MSSQL$ACT7 - don't worry if the first one isn't there) then make a copy of the ACT! database folder and restart the services

Then try this -

If that doesn't help, are you using the Premium version and/or installed SQL manually?

If so, it might be that you manually installed SQL Server using the "SQL_Latin1_General_CP1_CI_AS" collation - there was a step missed following the KB Article instructions for manual SQL installs.  Our standard collation uses Windows collation, "Latin1_General_CI_AS".  If you uninstall the SQL ACT7 instance then re-install either using the ACT! CD or manually, ensure you choose the correct collation if installing manually.

The database collation is correct, Latin1_General_CI_AS.  The database collation is independent of the server (master db) collation.  The database files can be hosted (attached to) either Express or Standard (or Enterprise, Developer or Workgroup) Edition of SQL Server.

I would uninstall the SQL ACT7 instance, then re-install taking care to choose the Windows Latin1_General_CI_AS collation (Case-insensitive, Accent-sensitive).

If not that... then post the contents of the error log file it mentioned in the error.

Author Closing Comment

ID: 31508402
Thank you very much - let me give it all a try - it will take me a while - thank you very much for all your help - let me see what happens and I will come back to you as soon as I can -
LVL 30

Expert Comment

by:Mike Lazarus
ID: 22769813
Only a grade B for all that info? You're tough...

BTW: for your on-going support, you'll nearly always be better off getting a support contact from an ACC (ACT! Certified Consultant) rather than Sage

Author Comment

ID: 22769969
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
LVL 30

Expert Comment

by:Mike Lazarus
ID: 22770096
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

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

For the KB numbers, go here - 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

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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

With users like the Professional Sales Road Warriors that made up much of ACT!'s early user base to field service technicians, trades-people, telecommuters who work from home, remote offices and others who need access to their data while out of the …
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 …

726 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