AnsweredAssumed Answered

Projects locked

Question asked by donkoller1319120 on May 8, 2012
Latest reply on May 9, 2012 by Chris_Shaffer_hcsc
Hi,

The issue we are trying to resolve is projects being locked by an ID that is associated with jobs that process. The best we can determine, it’s Investment Allocations. This is the job that is owned by ID that ran at the time of one of the locks. Could the process select the projects and while it was processing lost connectivity to the database. The Investment Allocation job completed successfully. The projects remained locked after the job completed. Is this feasible?

The bg-niku log file displays the following messages:
ERROR 2012-05-08 09:12:57,645 [Dispatch Thread-39670 : bg@ahpws330] persistence.PersistenceControllert (none:none:none) Exception due to DB Connection failure
ERROR 2012-05-08 09:12:57,645 [Dispatch Thread-39670 : bg@ahpws330] niku.xql2 (none:none:none) Lock error
com.niku.union.persistence.DBConnectionException: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver]No more data available to read.

ERROR 2012-05-08 09:12:57,676 [Dispatch Thread-39670 : bg@ahpws330] persistence.PersistenceControllert (none:none:none) Exception due to DB Connection failure
ERROR 2012-05-08 09:12:57,676 [Dispatch Thread-39670 : bg@ahpws330] niku.xql2 (none:none:none) checklock error
com.niku.union.persistence.DBConnectionException: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver]No more data available to read.

ERROR 2012-05-08 09:12:57,739 [Dispatch Thread-39670 : bg@ahpws330] persistence.PersistenceControllert (none:none:none) Exception due to DB Connection failure
ERROR 2012-05-08 09:12:57,739 [Dispatch Thread-39670 : bg@ahpws330] niku.xql2 (none:none:none) Unlock error
com.niku.union.persistence.DBConnectionException: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver]Software caused connection abort: socket write error

ERROR 2012-05-08 09:12:57,739 [Dispatch Thread-39670 : bg@ahpws330] niku.xql2 (none:none:none) Lock prImportExport not unlocked code -3 user 5000003 table SRM_PROJECTS id 5100368
ERROR 2012-05-08 09:12:57,801 [Dispatch Thread-39670 : bg@ahpws330] persistence.PersistenceControllert (none:none:none) Exception due to DB Connection failure


ERROR 2012-05-08 09:12:57,801 [Dispatch Thread-39670 : bg@ahpws330] niku.xql2 (none:none:none) checklock error
com.niku.union.persistence.DBConnectionException: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver]Software caused connection abort: socket write error

Thanks for your help in advance,
Don

Outcomes