GLMGT200 - Profit & Loss errors Database Vendor Code: 468 Error
Problem
GLMGT200 - Profit & Loss report may produce an error if the default database collation differs from the database collation. This can occur when a database is backed up on one server and restored on another server with a later version of SQL installed.
When running the report from Jiwa, the error will appear as:
---------------------------
Crystal Report Windows Forms Viewer
---------------------------
Failed to retrieve data from the database.
Details: [Database Vendor Code: 468 ]
Failed to retrieve data from the database.
Error in File GLMGT200 - Profit & Loss 23416_4520_
{E745A936-B05D-4A11-931F-33F3D4EB63A2}
.rpt:
Failed to retrieve data from the database.
Details: [Database Vendor Code: 468 ]
---------------------------
OK
---------------------------
Solution
Run the attached SQL script to modify the stored procedure to handle this situation.