OBIEE 11g|12c: Agents Send Emails To Incorrect Recipients When Master Trigger Agent Is Present

(Doc ID 2119485.1)

Last updated on APRIL 06, 2018

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.150714 and later
Information in this document applies to any platform.

Symptoms

There is a random event noticed by users that their agents deliver incorrect report to members of other child agents.  Upon further investigation they have been able to determine from Job Manager Tables that incorrect recipients have indeed been sent email intended for other recipients.  This has only seen to happen when there is master agent present and there is trigger or chain concept.

Scenario Example (10 is just an example):

Master Agents has 10 Child Agents

Each Child Agent has 10 Email Recipients

All 10 Child Agents run in parallel

There have been 2 symptoms which have been consistent in all cases that have happened so far:

1. select * from S_NQ_ERR_MSG where INSTANCE_ID=<incorrect delivery instance number> --> when compared with delivery list as seen on Agent "Recipients" tab --> you will observe a mis-match

2. Agent Log for the instance which reported incorrect delivery will not be generated unless debug option is set to true for Agent Logs

 

Changes

 No changes have been made.

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