InForm Server Adapter stops processing with unique constraint (<trial name>.PFEX_TRANSACTIONXML_IDX1) violated ORA-06512 (Doc ID 1529314.1)

Last updated on JUNE 10, 2014

Applies to:

Oracle Health Sciences InForm Adapter - Version 1.3.0 to 1.3.6 [Release 1.3.0]
Information in this document applies to any platform.

Symptoms

 InForm Server Adapter stops processing transactions.  Error appears in the event log:

Event Type: Error
Event Source: InFormServerAdapterService
Event Category: None
Event ID: 0
Description:
<date time> [7500] ERROR InFormAdapter.ServerAdapter.Service.ServerAdapterService An error occurred while detecting transactions in InForm.
Exception: InFormAdapter.Framework.Common.Resources.InFormAdapterException
Message: A General Error Occurred
Source: InFormAdapter.ServerAdapter.Service
   at InFormAdapter.ServerAdapter.Service.InFormServerAdapterImpl.EnumerateTransactions(String trialName, String firstTransactionGuid, EnumerateTransactionsDelegate onTransaction) in D:\InformAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 324
   at InFormAdapter.ServerAdapter.Service.TransactionCache.UpdateTrialCache(String trialName) in D:\InformAdapter\ServerAdapter\Service\TransactionCache.cs:line 66
   at InFormAdapter.ServerAdapter.Service.TransactionCache.UpdateCache(String trialName) in D:\InformAdapter\ServerAdapter\Service\TransactionCache.cs:line 126
   at InFormAdapter.ServerAdapter.Service.ServerAdapterService.UpdateCacheProc(Object stateInfo) in D:\InformAdapter\ServerAdapter\Service\ServerAdapterService.cs:line 135

Nested Exception

Exception: InFormAdapter.Framework.Common.Resources.InFormAdapterException
Message: Failed to create InForm Object Inform.PFTransaction. Please make sure Service or Trial '<trialname>' has started
Source: InFormAdapter.ServerAdapter.Service
   at InFormAdapter.ServerAdapter.Service.InFormServerAdapterImpl.EnumerateTransactions(String trialName, String firstTransactionGuid, EnumerateTransactionsDelegate onTransaction) in D:\InformAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 307

Nested Exception

Exception: Platform.Storage.Exceptions.DBProviders.Messages.DbProviderException
Message: ExecuteNonQuery() Failed. Internal Exception : Oracle.DataAccess.Client.OracleException ORA-00001: unique constraint (<trialname>.PFEX_TRANSACTIONXML_IDX1) violated    
   at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
   at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src)
   at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
   at Platform.Storage.Providers.CommandProxy.ExecuteNonQuery() in E:\ICEPlatform\AppServer\Storage\Providers\CommandProxy.cs:line 59
   at Platform.Storage.DBProvider.ExecuteNonQuery(IDbCommand cmd) in E:\ICEPlatform\AppServer\Storage\Providers\DBProvider.cs:line 901. DB Command Text : INSERT INTO
    PFEX_TRANSACTIONXML (EXTERNALGUID, XMLNODE, LARGEXMLNODE, XMLID)
VALUES
    (:guid, :xml, :largexml, PFEX_TRANSACTIONXML_SEQUENCE.nextval)
.
Source: Platform.AppServer
   at Platform.Storage.DBProvider.ExecuteNonQuery(IDbCommand cmd) in E:\ICEPlatform\AppServer\Storage\Providers\DBProvider.cs:line 924
   at InFormAdapter.Framework.Common.DataUtilities.ExecuteNonQuery(IDBProvider provider, IDbTransaction transaction, IDbCommand cmd) in D:\InformAdapter\Framework\Common\DataUtilities.cs:line 222
   at InFormAdapter.ServerAdapter.Database.TransactionXmlTable.InsertTransaction(String guid, String xml) in D:\InformAdapter\ServerAdapter\Database\TransactionXmlTable.cs:line 220
   at InFormAdapter.ServerAdapter.Service.TransactionCache.OnEnumerateTransaction(String guid, String xml) in D:\InformAdapter\ServerAdapter\Service\TransactionCache.cs:line 143
   at InFormAdapter.ServerAdapter.Service.InFormServerAdapterImpl.EnumerateTransactions(String trialName, String firstTransactionGuid, EnumerateTransactionsDelegate onTransaction) in D:\InformAdapter\ServerAdapter\Service\InformServerAdapterImpl.cs:line 288

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms