My Oracle Support Banner

Transmitted Report Stuck Due to 'Value column of table CFG_ESM_PROFILE contain blank or NULL entry" Error (Doc ID 2537324.1)

Last updated on JULY 13, 2023

Applies to:

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

Symptoms

In Argus 8.1.2

PROBLEM DESCRIPTION
=====================

A case was transmitted from Reports->Bulk Reporting screen

When checking the status from the Worklist->Bulk ICSR Transmit screen the report is stuck in the transmit stage and failing with the following error in the ESM LOG files.

ERROR
------------
24-Apr-2019 10:22:52 AM: ========== Start Transmit Process ==========
24-Apr-2019 10:22:53 AM: ESM Service Login to '<SID>' Database with UserID 'esm_owner' Successfully
24-Apr-2019 10:22:53 AM: Value column of table CFG_ESM_PROFILE contain blank or NULL entry for section = 'DATABASE' and key = 'DATABASE_IDENTIFIER'. Please use ESMMapping Utility to create this entry.
24-Apr-2019 10:22:53 AM: ========== Finish Transmit Process ==========

The above error appears is all ESM Log files:

ESM_E2BTransmission_XXX.txt
ESM_StatusCheck_XXX.txt
ESM_GatewayStatusCheck_XXX.txt
ESM_AckTransmission_XXX.txt
ESM_AttachmentTransmission_XXX.txt

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
Cause
Solution
References


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