A1.95 : Prompted Message: Error during upgrade to 2.0-Error while installing SQL functions and Stored Procedures
Question : When upgrade database from 1.9 to version 2.0, error message prompted: Error while installing SQL functions and Stored Procedures…. Why?
Possible Reason :
You are using older SQL Server version such like SQL 2005 or SQL 2008.
Solution :
For AutoCount Version 2.0, the requirement for SQL Server is SQL Server 2012 or above.
You need to upgrade your current SQL server to SQL Server 2012 or above. After that, please login to complete the upgrade of database.
If you do not wish to upgrade the current SQL server, you may install SQL Server 2012 in another instance name, restore your database to the new SQL instance, then upgrade this new restored book to Version 2.0.
Note : Please seek assistance from your software dealer if the problem still persists after performing the suggested steps.
--Source from AutoCount Wiki --
Related Articles
A1.96 : Prompted Message: Error upgrade to 2.0-Unknow Sql Exception… Invalid object name ‘Settings’
Question : When upgrade database from 1.9 to version 2.0, error message prompted: ‘Unkonw Sql Exception (Number=208, Message=Invalid object name ‘Setting’.) Inner Exception Message: Invalid object name ‘Settings’. Why? Possible Reason : This is a ...A1.113 : Prompted Message: Error during upgrade to 2-Invalid Data Definition Language Statement and ALTER TABLE dbo.ADVQT…Guid
Question: When upgrade database from 1.9 to version 2.0, error message prompted “Invalid Data Definition Language Statement, error message is Column already has a DEFAULT bound to it”. After click OK, another message prompted “ALTER TABLE ...A1.112 : Prompted Message: Error during upgrade to 2.0-The object ‘DF TMCS IPho Recei XXXXXXXX’ is dependent on column ‘ReceiptHeader’
Question: When upgrade AutoCount Version 1.9 to Version 2.0 for user who use iAutoCount, error prompted “Invalid Data Defination Language Statement… The object ‘DF_TMCS_IPho_Recei_XXXXXXXX’ is dependent on column ‘ReceiptHeader’. Why? Possible ...A1.99 : Prompted Message: Unable to create new account book, error message-Unknown SQL Exception.Invalid object name Setting
Question: When I try to create new account book, error message prompted: "Unknown Sql Exception (Number =208, Message=Invalid object name ‘Setting’.)”. Why? Possible Reason : This is a known bug in version 2.0.17.154 and is fixed in version ...A1.117 : Prompted Message: Error during upgrade to 2.0-Invalid Data Definition Language Statement, error message is Violation of PRIMARY KEY constraint … The duplicate key value is (CR Default)
Question: When upgrade database from 1.9 to 2.0, error message prompted “Invalid Data Definition Language Statement, error message is Violation of PRMIARY KEY constraint … The duplicate key value is (CR Default). Why? After clicking OK, another ...