Error Message :
U00003592 UCUDB - Status: '42000' Native error: '1757' Msg: 'Column 'UC_MSGT.MSGT_Type' is not of same collation as referencing column 'MSG.MSG_MSGT_Type' in foreign key 'FK_MSG_MSGT'.'
When using MS SQL Server for the Automation Engine (AE) and attempting to load the initial data using the DB Load Utilities, if the following error messages are seen in the logs (Logfile of the DB load utility) it indicates that the collation is not set correctly. There is a different collation setting between the first initial data load and the following load which causes the error.
This error message appears during the initial data load.
Root Cause: Invalid collation setting on MS SQL Server.
OS Version: N/A
As this is not a defect or a faulty design in Automic's products and is caused within the scope and perimeter of the MS SQL Server product settings, the issue needs to be addressed by the MS SQL Server Database Administrator.
Fix Status: No Fix