ACT Verison 11 - upgrade issue - Exceptions occurred

Posted on 2008-10-21
Medium Priority
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 150 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 - http://tinyurl.com/5tnwqq

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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

A lot of users new to ACT!, especially those who don't get the benefit of a consultant, seem confused between when to share on a network and when to sync ... or, in fact, how to do either. So I thought I would attempt to explain the various options …
As most of my regular readers and followers know, I do a lot of on-line technical support as well as providing support services to our resellers and ACT! Certified Consultants and one of the things I notice is that I regularly need to ask users the …
Starting up a Project
Suggested Courses

609 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