Resolve Database Collation Conflicts

Users may receive messages while working in AVEVA Electrical indicating that there is a database collation conflict issue. For example: "Cannot resolve collation conflict at column 2 in order by statement".

Such conflicts can be resolved in Electrical Security Manager by selecting Tools > Resolve DB Collation.

If multiple users are connected to the selected database, the following error message will be displayed:

Follow the instructions and select the Resolve DB Collation option again.

When the conflict is successfully resolved, the following message is displayed:

Whether it was successful or unsuccessful, a log entry will be generated for the operation in the Windows Event Viewer, which may be useful for future analysis of the issue.