ClearCompanies script error message

(0) Share

Report

Posted on by Richard Wheeler

75,848 Moderator

I have dealt with before and one of the fixes is to truncate the DYNAMICS..syDeployedReports table.

Error message when running ClearCompanies script for Microsoft Dynamics GP: "Error: Conversion failed when converting the varchar value 'ABC' to data type int."

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?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Derek Albaugh on at

Like (1)

Report

We have a blog on this actually:

community.dynamics.com/.../error-message-when-running-clearcompanies-script-for-microsoft-dynamics-gp-error-conversion-failed-when-converting-the-varchar-value-abc-to-data-type-int

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

Was this reply helpful? Yes No