AnsweredAssumed Answered

PAM DB Crash Issue

Question asked by Priyanka.vijay on Oct 22, 2015
Latest reply on Oct 28, 2015 by Andy_Thompson

Hi All,


First of all I would like to mention that I am very new to PAM. We recently had an issue where PAM all PAM process stopped and it gave DB connection error. On Investigation, we concluded to restore previous day DB backup and start PAM. And I worked.  However, I need your help to understand what would have went wrong. Since we had no error on DB side. We could only see below error on PAM logs




“2015-10-20 18:36:34,717 WARN [org.hibernate.util.JDBCExceptionReporter] [ Thread-6024] SQL Error: 0, SQLState: null”

“2015-10-20 18:36:34,717 ERROR [com.optinuity.c2o.persistence.RuntimeDatabaseManager] [ Thread-6024] updateDatasetAsLocked ..... Transaction will rollback“

2015-10-20 18:36:34,717 ERROR [org.hibernate.util.JDBCExceptionReporter] [ Thread-6024] Unable to get managed connection for RuntimeLibDS; - nested throwable: (javax.resource.ResourceException: Unable to get managed connection for RuntimeLibDS)

2015-10-20 18:36:34,717 ERROR [com.optinuity.c2o.persistence.RuntimeDatabaseManager] [ Thread-6024] updateDatasetAsLocked.....Exception while setting true in database for dataset with path



Can you suggest here to avoid future issues.

Thanks in advance