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
584 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
[X]
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
  • 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
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.

 
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
 

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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

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 …
Progress
Introduction to Processes

728 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