Error When Importing EMA R3 Case - ORA-00936: missing expression
(Doc ID 2824219.1)
Last updated on DECEMBER 23, 2024
Applies to:
Oracle Life Sciences Argus Interchange - Version 8.1.1 and laterInformation in this document applies to any platform.
Symptoms
Unable to import EMA R3 XML using the shipped our of the box profile, import fails with below warning in the ESM import logs (located in ESM\Logs directory on Interchange server):
ERROR
-----------------------
28-Oct-2021 09:32:07 AM XXX : ========== Finish Receive Process ==========
28-Oct-2021 09:40:57 AM: ========== Start Receive Process ============
28-Oct-2021 09:40:57 AM XXX : ========== Start Receive Process for File : C:\ESM\IN\ICHICSR-XXXX_XXXXUS_v1.xml ==========
28-Oct-2021 09:41:02 AM XXX : No Attachments
28-Oct-2021 09:41:04 AM XXX : ======== IsSafeXml ==========
28-Oct-2021 09:41:04 AM XXX : ======== IsProxyEnable_ValidateDTD ==========
28-Oct-2021 09:41:08 AM XXX : System Error has occurred in E2bReceive.CreateMessageHeader Fn, Error#: 5,Desc.: Contact your system administrator,Source: Relsys.Persistence.DataAccess
28-Oct-2021 09:41:08 AM XXX : The inbound status not found for file name ICHICSR-XXXX_XXXXUS_V1.XML
28-Oct-2021 09:41:08 AM XXX : ========== Finish Receive Process ==========
-----------------------
28-Oct-2021 09:32:07 AM XXX : ========== Finish Receive Process ==========
28-Oct-2021 09:40:57 AM: ========== Start Receive Process ============
28-Oct-2021 09:40:57 AM XXX : ========== Start Receive Process for File : C:\ESM\IN\ICHICSR-XXXX_XXXXUS_v1.xml ==========
28-Oct-2021 09:41:02 AM XXX : No Attachments
28-Oct-2021 09:41:04 AM XXX : ======== IsSafeXml ==========
28-Oct-2021 09:41:04 AM XXX : ======== IsProxyEnable_ValidateDTD ==========
28-Oct-2021 09:41:08 AM XXX : System Error has occurred in E2bReceive.CreateMessageHeader Fn, Error#: 5,Desc.: Contact your system administrator,Source: Relsys.Persistence.DataAccess
28-Oct-2021 09:41:08 AM XXX : The inbound status not found for file name ICHICSR-XXXX_XXXXUS_V1.XML
28-Oct-2021 09:41:08 AM XXX : ========== Finish Receive Process ==========
Also the below warning is noted in the E2BReceive logs (These are normally located on the Interchange Server in directory similar to C:\Temp\ArgusLogs\Interchange)
[EnterpiseID: ] 02-Nov-2021, 11:37:05:828, [1], UserId: , Exception DetailsMessage
ORA-00936: missing expression
Stack Trace
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 Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteNonQuery(DbCommand command)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command)
at Relsys.Persistence.DataAccess.DataAccess.ExecuteNonQuery(DbCommand dbCommand)
ORA-00936: missing expression
Stack Trace
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 Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteNonQuery(DbCommand command)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command)
at Relsys.Persistence.DataAccess.DataAccess.ExecuteNonQuery(DbCommand dbCommand)
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |