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
581 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
pxactplugin? 6 524
Act 6 asking for a user/password - It never did before. 1 702
Deleting Outlook Appointment freeze-crash Outlook 10 196
Act 16 install problem 2 264
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…
With users like the Professional Sales Road Warriors that made up much of ACT!'s early user base to field service technicians, trades-people, telecommuters who work from home, remote offices and others who need access to their data while out of the …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

809 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