Troubleshooting
Problem
New Install of Control Center 6.2.0 using Microsoft 2019 Database
The web portal is unavailable on port 58082 (non-secure) and 58083 (secure). Seeing an HTTP 503 ERROR - Service unavailable.
There is something called hibernate.instance as an error in the ccweb_<date>.log that seems suspicious. SQL Server 2019 is case-sensitive, so if CCM is trying to reference something called 'hibernate.sequence' instead of HIBERNATE.SEQUENCE then that explains the error. This error seems to coincide with an attempted login.
Symptom
Can not reach the Web Console.
Cause
The Microsoft Database was created with the wrong collation setting.
The collation required is SQL_Latin1_GenealCP1_CI_AS which is not case sensitive
Environment
Microsoft Database Server 2019
Diagnosing The Problem
Engine Logs show INFO JDBCService - Database is case sensitive
ccweb logs show SQL Error: 208, SQLState: S0002 Invalid object name 'hibernate_sequence'.
Resolving The Problem
Recreate the Database with the correct Collation Setting
Related Information
Document Location
Worldwide
[{"Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS9GLA","label":"IBM Control Center"},"ARM Category":[{"code":"a8m0z000000cwVwAAI","label":"DATABASE"}],"ARM Case Number":"TS005288375","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]
Was this topic helpful?
Document Information
Modified date:
26 March 2021
UID
ibm16436869