This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.
Summary
HPOO Central is not working
DATABASECHANGELOGLOCK = 1
Question
HPOO Central is not working after it was working previously.
DATABASECHANGELOGLOCK = 1
Answer
1- Stop the OO service
2- Open your database
3- Find the table named 'Databasechangeloglock' (Select * from DATABASECHANGELOGLOCK)
4- Check the content of the Locked column.
5- If it is set to '1' in that case the error: “Could not acquire change log lock. Currently locked by…” will be thrown.
6- Please try setting it to '0' and set content of the 'LOCKGRANT' and 'LOCKEDBY' to “null”, then start the service and try to open central after 10 min
7- UPDATE databasechangeloglock SET locked=0, lockgranted=null, lockedby=null where id=1;
2- Open your database
3- Find the table named 'Databasechangeloglock' (Select * from DATABASECHANGELOGLOCK)
4- Check the content of the Locked column.
5- If it is set to '1' in that case the error: “Could not acquire change log lock. Currently locked by…” will be thrown.
6- Please try setting it to '0' and set content of the 'LOCKGRANT' and 'LOCKEDBY' to “null”, then start the service and try to open central after 10 min
7- UPDATE databasechangeloglock SET locked=0, lockgranted=null, lockedby=null where id=1;