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 Reason:
The column ReceiptHeader & ReceiptFooter will affect the process when upgrade AutoCount Version 1.9 to AutoCount Version 2.0.
Solution:
1) Go to SQL Management Studio and choose the selected database that need to upgrade from Version 1.9 to Version 2.0. Then expand the Database and expand the Tables.
2) Expand the table name ‘dbo.TMCS_iPhoneSetting’, then expand the Constraints. There were 2 constraints for DF_TCMS_IPhon_Recei_XXXXXXXX.
3) Select the first constraints name ‘DF_TCMS_IPhon_Recei_XXXXXXXX’, right click and select Script Constraint as > CREATE To > New Query Editor Window.
Continue to do the same step for the second constraints ‘DF_TMCS_Iphone_Receip_XXXXXXXX’.
Do not close that two new query editor windows for now, you will need to use it.
4) Right click on first the constraint and select Delete and repeat the same step for the second constraint.
5) Then, upgrade AutoCount version 1.9 to version 2.0.
6) After successfully upgraded, click on Execute for the two new query editor windows.
7) You may request from your software dealer (if needed) the version 2 iAutoCount plug in.
--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.116 : Prompted Message: Change Item UOM rate error – Invalid object name ‘Sync’
Question: When I change item uom rate, system prompted an error: “Unknown Sql Exception (Number = 208, Message = Invalid object name ‘Sync’.). Why? Possible Reason: The registry value failed to upgrade properly when upgrading the database. Solution: ...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.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 : ...A1.97 : Prompted Message: Import Member error - Object reference not set to an instance of an object
Question : When I click on Paste from Clipboard at Import Member, error message prompted 'Object reference not set to an instance of an object'. Why? Possible Reason : This is a known bug and is fixed in version 2.0.15.138. Solution (1) : Update to ...