V8_SCHEDULELOG Table Is Not Getting Updated After Scheduled Jobs Run

(Doc ID 2384280.1)

Last updated on APRIL 24, 2018

Applies to:

Hyperion BI+ - Version 11.1.2.3.500 and later
Information in this document applies to any platform.

Symptoms

After every successful scheduled job run, a row is inserted into the V8_SCHEDULELOG table.  This corresponds to what is seen in the Consolidated job status page in Workspace.

Customer has a custom setup where there is an insert trigger on table V8_SCHEDULELOG.
Once a record is inserted in the V8_SCHEDULELOG table, the trigger runs and it creates a command file on server.
This command file has instructions to send the output file to their various clients via NDM process.

As there is no insert happening in V8_SCHEDULELOG table, no command file is generated and hence output files are not getting sent automatically to clients.

Changes

 

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