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
  • 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Microsoft have a hotfix for Windows systems that will improve application that uses UTC dates and times - including Outlook, the Windows Event Viewer and many third-party applications. Most date and time stamps that are created and displayed in W…
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 …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now