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