75,730
In this case ABC is a valid company and truncating the syDeployedReports does prevent this message. ABC only existed in the CompanyID field which not defined as int. What field is actually causing this message?
We have a blog on this actually:
In it, there is a script that you can modify with the string value causing the error, in this example it would be 'ABC' and the script will show those table/columns that have 'ABC' in them, when run against the DYNAMICS/system database.
As the blog mentions, "the ClearCompanies script throws this error message when it encounters a value in the CMPANYID, companyID, and related table columns/fields it is looking at, as those values should all be integer values".
I just wanted to mention this, even if you've already resolved the error.
Thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (