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
574 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
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

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…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

757 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

22 Experts available now in Live!

Get 1:1 Help Now