Act Pro 2012 fails in database upgrade

[gmartin]

Jguykema,

On a side note - what browser (and version/build of it) are you using?

So we can test and try to determine why there is no attachment option presented.

[abrierrose]

I have the same issue and cannot seem to get past it. Here is the error log:

Changed database context to 'ScottsdaleArtAuction'.
*********** Schema Update failed **************
*********** Exception message follows *********
System.Data.SqlClient.SqlException: Incorrect syntax near '100'.
Setting Database Compatibility Level...
 
   at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

Schema Update failed.

[tvyas]

Can you provide us what is version of database from previous version ?

Also can you try to upgrade database from previous version like demo to ACT 2012 and see if we getting same results ?

Thanks,

Tushar Vyas

ACT! Database Services

[keith]

That doesn't look like the entire log file.

[rxry2011]

same problem here

from Act 2009 database

Win 7, 64bit OS

error:

Changed database context to xxxxxx'.
*********** Schema Update failed **************
*********** Exception message follows *********
System.Data.SqlClient.SqlException: Incorrect syntax near '100'.
Setting Database Compatibility Level...
 
   at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

Schema Update failed.

[abrierrose]

It is the entire log file and i am upgrading from 2009. I tried on the Demo and got the same result, same log file.

[StanleyM]

Issue: Changed database context to 'XXXX'.

*********** Schema Update failed **************

*********** Exception message follows *********

System.Data.SqlClient.SqlException: Incorrect syntax near '100'.

Setting Database Compatibility Level...

   at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

I had the same error, found SQL 2005 was shown in the actdiag for 2012, I did see in the configuration manager had the act7 instance running as well as the browser.  in the end I had to pull 2005 and 2008, reinstall 2008 then reattach back to ACT using SecurityCmdLnApp.exe.

Schema failed.PNG ‏55 KB

[chriso1]

I'm also having this problem, below is my error message.  Would be great to fix, otherwise I cannot access my database.

Changed database context to 'Main'.
*********** Schema Update failed **************
*********** Exception message follows *********
System.Data.SqlClient.SqlException: Incorrect syntax near '100'.
Setting Database Compatibility Level...
 
   at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

Schema Update failed.

[chriso1]

Hi Stanley

Are you able to advise your steps for the process you did to fix your problem??

Thanks heaps

Chris

[rxry2011]

I determined that the same thing was wrong with mine. Win 7 Home premium had set up my adminstrator user as multiple and Act installation only allows one primary administrator to change setting in Act7.I needed to make a new user as Administrator, remove net 2005 and net2008, re install 2008 and attach to act database. It was frustrating enough to have to call support and let a nice chap from South India do a remote go at it as I ate lunch and watched cursor pong.