Community
Showing results for 
Search instead for 
Do you mean 
Reply

Failed upgrade from ACT 2008 Premium to ACT 2014 Premium with "Exceptions occurred while executing the database schema update script."

Accepted Solution Solved
Copper Contributor
Posts: 10
Country: USA
Accepted Solution

Failed upgrade from ACT 2008 Premium to ACT 2014 Premium with "Exceptions occurred while executing the database schema update script."

Trying to get a client's database upgraded to the latest 2014 database.  The ACT10 Demo database from 2008 on their existing system upgrades without issue.  The process I've used for upgrading is backing up and restoring to the new 2014 server.  The client's ACT database fails to upgrade with:

 

Exceptions occurred while executing the database schema update script.

 

You can view the entire log file here: Log File

 

Here are the last 5 lines of the log are:

 

*********** Schema Update failed **************
*********** Exception message follows *********

PRC_REPORT_MAKE_OLEDBFUNCTIONS: ERROR OCCURRED TRYING TO CREATE/ALTER BASE FUNCTION FNR_CONTACT
PRC_REPORT_MAKE_OLEDBFUNCTIONS: ERROR OCCURRED TRYING TO REMOVE FUNCTION METADATA FOR FNR_CONTACT
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.

Schema Update failed.

 

I've attempted the upgrade several times, I even performed every single ACTDIAG maintenance task before upgrading on the new server.  I also ran a database check and repair in ACT 2008 before generating the backup and it still failed.

 

Any thoughts?


Accepted Solutions
Solution
Accepted by topic author waldrondigital
‎09-25-2015 03:20 AM
Copper Contributor
Posts: 10
Country: USA

Re: Failed upgrade from ACT 2008 Premium to ACT 2014 Premium with "Exceptions occurred while executing the database schema update script."

To make a long story short, Swiftpage repaired our file for us at no charge.  Database schema fixes are free.

 

Contact: actdbrepair@swiftpage.com

 

Problem solved!

View solution in original post


All Replies
Platinum Elite Contributor
Posts: 6,662
Country: USA

Re: Failed upgrade from ACT 2008 Premium to ACT 2014 Premium with "Exceptions occurred while executing the database schema update script."

It would appear that there is database corruption that will require database repaor service.

 

Swiftpage and several ACCs (including Techbenders) can provide that service. You should be able to get an evaluation at no charge.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 10
Country: USA

Re: Failed upgrade from ACT 2008 Premium to ACT 2014 Premium with "Exceptions occurred while executing the database schema update script."

[ Edited ]

This database was professionally repaired when we moved from 6.0 to 2008 back in 08 by an ACT specialist, as like this instance the database would not upgrade from 6.0 to 10.  So you are saying that  we will have to pay to have the previously repaired database repaired again?   We purchased ACT 2014 in mid January and I'd like to avoid having to re-repair this database at additional cost.

Copper Contributor
Posts: 29
Country: Germany

Re: Failed upgrade from ACT 2008 Premium to ACT 2014 Premium with "Exceptions occurred while executing the database schema update script."

Hallo,

 

perhaps you do not need a full repair, I have an idea, but need the backup of the database to check if it is working.

If you are interessed please submit a ticket on http://support.crmaddon.com

then you will get theinfo how to send the database - we handle all data with care -

 

best regards Susanne

Bronze Elite Contributor
Posts: 1,426
Country: United_Kingdom

Re: Failed upgrade from ACT 2008 Premium to ACT 2014 Premium with "Exceptions occurred while executing the database schema update script."

This error is a pain and does normally need an expert and some SQL repair software but just to check that you have tried the repair for this error in ACTDIAG under database rebuild. Woth a try befre spending money.

Bronze Elite Contributor
Posts: 1,426
Country: United_Kingdom

Re: Failed upgrade from ACT 2008 Premium to ACT 2014 Premium with "Exceptions occurred while executing the database schema update script."

Just to say I had not seen that you has already tried the ACTDIAG repairs when I gave the reply above.

Copper Contributor
Posts: 10
Country: USA

Re: Failed upgrade from ACT 2008 Premium to ACT 2014 Premium with "Exceptions occurred while executing the database schema update script."

Susanne I opened up a ticket. Thx
Solution
Accepted by topic author waldrondigital
‎09-25-2015 03:20 AM
Copper Contributor
Posts: 10
Country: USA

Re: Failed upgrade from ACT 2008 Premium to ACT 2014 Premium with "Exceptions occurred while executing the database schema update script."

To make a long story short, Swiftpage repaired our file for us at no charge.  Database schema fixes are free.

 

Contact: actdbrepair@swiftpage.com

 

Problem solved!