Solved

ACT Verison 11 - upgrade issue - Exceptions occurred

Posted on 2008-10-21
5
688 Views
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
0
Comment
Question by:Craiglnf
  • 3
  • 2
5 Comments
 
LVL 30

Accepted Solution

by:
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 - 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.
0
 

Author Closing Comment

by:Craiglnf
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 -
0
 
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
0
 

Author Comment

by:Craiglnf
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
0
 
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
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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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 …
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…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

743 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

12 Experts available now in Live!

Get 1:1 Help Now