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

 

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

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

Suggested Solutions

As owner of GL Computing, I have worked with CRM products since 1984 and with Act! since 1987.  GL Computing provides training and technical support to Act! Consultants, resellers and add-on developers around the world. One of the problems we not…
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 …
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

863 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