Description of ERROR: Failed to refresh lock for store '$sys.nonfailsafe', [ERRSTR = org.hibernate.exception.SQLGrammarException: could not load an entity: [com.tibco.tibems.tibemsd.internal.db.HBLock#1] ]

Description of ERROR: Failed to refresh lock for store '$sys.nonfailsafe', [ERRSTR = org.hibernate.exception.SQLGrammarException: could not load an entity: [com.tibco.tibems.tibemsd.internal.db.HBLock#1] ]

book

Article ID: KB0094216

calendar_today

Updated On:

Products Versions
TIBCO Enterprise Message Service -
Not Applicable -

Description

Resolution:
Description:
= = = = = = =

ERROR: Failed to refresh lock for store '$sys.nonfailsafe',
[ERRSTR = org.hibernate.exception.SQLGrammarException: could not load an entity: [com.tibco.tibems.tibemsd.internal.db.HBLock#1] ]

Environment:
= = = = = = =

ALL

Description:
= = = = = = =

ERROR: Failed to refresh lock for store '$sys.nonfailsafe',
[ERRSTR = org.hibernate.exception.SQLGrammarException: could
not load an entity: [com.tibco.tibems.tibemsd.internal.db.HBLock#1] ]

Resolution:
= = = = = =

The EMS server periodically refreshes the database locks. In case of Fault Tolerant [FT] EMS servers, the refresh interval of the database lock by the active server is the same as that of the ft_heartbeat interval and so is tunable. But in the case of a stand alone EMS server, the refresh interval is 30 seconds and is not tunable. If the EMS server is not able to access the database when it is trying to refresh the lock, the above error will be thrown.  Make sure that database server is up and is accessible by the EMS server, otherwise the refresh lock error will occur.

We would also expect to see this error on the EMS server side when it loses its connection to the database; either the corresponding database was not running or there was some intermittent network problem between the machine running the database server and the machine running the EMS server.

Issue/Introduction

Description of ERROR: Failed to refresh lock for store '$sys.nonfailsafe', [ERRSTR = org.hibernate.exception.SQLGrammarException: could not load an entity: [com.tibco.tibems.tibemsd.internal.db.HBLock#1] ]