My Oracle Support Banner

All ICSR R3 Reports Cannot Be Generated (Doc ID 2865786.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Safety - Version 8.2.3.1 and later
Information in this document applies to any platform.

Symptoms

After upgrading from 8.2.2 to 8.2.3.1, the following error is occurring when generating ICSRs R3 via the AG Service.

ERROR
The batch_generation_queue table:
Error while generating the HL7 message, refer ERROR_LOG for more details


CMN_REG_REPORTS and ERROR_LOG reflect the following:

HL7Report::GetHL7Report - Argus Login Failed.
  at Relsys.Argus.Service.Implementations.Common.UserLogin.ValidateSafetyUser(IDAL dal, String userName, String enterpriseID, Int64& userId)
  at Relsys.Argus.Service.Implementations.Common.UserLogin.ValidateUser(IDAL dal, String userName, String enterpriseID, Int64& userId)
  at Relsys.Argus.Service.Implementations.Common.UserLogin.SetUserContext(String databaseName, String databaseUserName, TokSecurer databaseUserTok, String databaseSessionId, String enterpriseID, String userName, Boolean globalRequest, Boolean noSessionRequired)
  at Relsys.ESM.HL7.HL7Report.GetHL7Report(Int64 reportFormId, Int64 esmReportId, Int64 regReportId, Int64 agencyId, Int64 caseId, String sUserName, Boolean DraftReport, String DBUserName, TokSecurer DBPassword, String DBName, Int64 DbSessionId, Int64 lEnterpriseID, String stempFolder)

AGProc.log shows following:

[EnterpiseID: ] 19-Apr-2022, 00:06:14:312, [1], UserId: System, Argus Login Failed to the User - oagsvc_batch_gen_worker_1 Error Id - 6 Exception DetailsMessage
Argus Login Failed.
Stack Trace


[EnterpiseID: ] 19-Apr-2022, 00:06:14:374, [1], UserId: System, Reg Rpt ID: 1529574 ESM Rpt ID: 21868097: HL7Report::GetHL7Report - Argus Login Failed.
  at Relsys.Argus.Service.Implementations.Common.UserLogin.ValidateSafetyUser(IDAL dal, String userName, String enterpriseID, Int64& userId)
  at Relsys.Argus.Service.Implementations.Common.UserLogin.ValidateUser(IDAL dal, String userName, String enterpriseID, Int64& userId)
  at Relsys.Argus.Service.Implementations.Common.UserLogin.SetUserContext(String databaseName, String databaseUserName, TokSecurer databaseUserTok, String databaseSessionId, String enterpriseID, String userName, Boolean globalRequest, Boolean noSessionRequired)
  at Relsys.ESM.HL7.HL7Report.GetHL7Report(Int64 reportFormId, Int64 esmReportId, Int64 regReportId, Int64 agencyId, Int64 caseId, String sUserName, Boolean DraftReport, String DBUserName, TokSecurer DBPassword, String DBName, Int64 DbSessionId, Int64 lEnterpriseID, String stempFolder)
Exception DetailsMessage
Argus Login Failed.
Stack Trace
  at Relsys.Argus.Service.Implementations.Common.UserLogin.ValidateSafetyUser(IDAL dal, String userName, String enterpriseID, Int64& userId)
  at Relsys.Argus.Service.Implementations.Common.UserLogin.ValidateUser(IDAL dal, String userName, String enterpriseID, Int64& userId)
  at Relsys.Argus.Service.Implementations.Common.UserLogin.SetUserContext(String databaseName, String databaseUserName, TokSecurer databaseUserTok, String databaseSessionId, String enterpriseID, String userName, Boolean globalRequest, Boolean noSessionRequired)
  at Relsys.ESM.HL7.HL7Report.GetHL7Report(Int64 reportFormId, Int64 esmReportId, Int64 regReportId, Int64 agencyId, Int64 caseId, String sUserName, Boolean DraftReport, String DBUserName, TokSecurer DBPassword, String DBName, Int64 DbSessionId, Int64 lEnterpriseID, String stempFolder)

 




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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.