Problem

Installed Interchange with MSSQL server 2012. While starting Interchange very first time, it throws error-

WARN [HeartbeatUpdater] (HeartbeatUpdater.updateHeartbeat:101) - Error updating heart beat
java.sql.SQLException: Invalid column name 'NODENAME'.

FATAL [Startup] (ClusterMaintenanceManager.halt:134) - Fatal error while performing schema maintenance
java.sql.SQLException: There is already an object named 'InstalledComponents' in the database.

Resolution

Please check the value of database parameters "Collation" while creation on MSSQL server. We have options in MSSQL server to specify the objects case sensitive/insensitive. Use Latin1_General_100_CI_AS_SC. Or similar to this.

We can explicitly select case insensitivity by specifying _CI in these parameters.