Diagnosing ODI package errors and performance for Oracle Knowledge Analytics

(Doc ID 1961796.1)

Last updated on MARCH 29, 2018

Applies to:

Oracle Knowledge - Version and later
Information in this document applies to any platform.


ODI batch processing will sometimes fail.  There are ways to check the ODI processes - packages to see how they are running.  After a patch they could fail, there could be failures from testing data at startup, and something can happen to the resources needed by ODI that could cause it to fail.

The ODI component is a set of packages that run internally to ODI to move data from the staging table DW_STAGE.DW_STG_DATA table to the reporting tables.  These tables can be in the same database or different databases.

The Analtyics Admin Guide is located here.


Some important points to consider.  A email notification process can be set up to monitor the ODI behavior.  It is recommended that you verify that the email process from the ODI is running correctly. This will require access from the ODI server to your SMTP server. Settings are stored in the DW_WORK.ANALYTICS_PROPERTIES table. (If you have combined DW_WORK and DW_REPORTING, then it will be in the DW_REPORTING schema)

Trouble shooting Tips:

If you see that the JMS Queues are receiving messages, but no data is making it to DW_STAGE.DW_STG_DATA, then verify that your Deployments are in an active state.  Queues can be found in the weblogic admin console at
Domain Structure -> Services -> Messaging -> JMS Servers -> <Choose a JMS Server from list> -> Monitoring Tab.

If the data is making it to the staging tables then it is time to look at the ODI processing.

If the ODI processing is going unusally slow it could be because there is old data in DW_STAGE.DW_STG_DATA or the resource allocation for ODI is too low.


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