KC 16 - Oracle Error: Establishing a connection to .. failed: The operation is not valid for the state of the transaction

Hey All,

 

Time to time we are running to an issue where our WCF service call to the InfoShareWS (for example API20/DocumentObj/CreateOrUpdate) is timed out.

I started to dig into it and in the Infoshare WS log I found out that this is not really a timeout rather there was an exception on the WCF backend.

InfoshareAuthorApp_....log:

Oracle.DataAccess.Client.OracleException ORA-02051: another session or branch in same transaction failed or finalized at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
at Trisoft.InfoShare.Configuration.Database.DatabaseCommandOracle.ExecuteCommand(String commandStatement, DatabaseParameters parameters, Int32 commandTimeOut, CommandType commandType, String comment, Boolean logException) [[]]

 

InfoShareWS_....log_

14:59:10.8991 Error 80 01708 na:: API20/DocumentObj/CreateOrUpdate InfoShareWS.Wcf.API20.ErrorHandlers.ErrorHandler.LogFaultContract (InfoShareErrorNumber=[-3],Origin=[Trisoft.InfoShare.WSCOMClient],Description=[No connection could be made to the database. Establishing a connection to "dita_user" failed: The operation is not valid for the state of the transaction.]) []

 

Usually (but not all the time) it happens when we create new language objects in our WritePlugins.

 

Do anyone have an idea according to this?

 

Thanks a lot,

Attila