IM Analytics Log Loading fails (even after repeated tries) with Error "ODS database already has data." (Doc ID 1040036.1)

Last updated on MAY 14, 2017

Applies to:

Oracle Knowledge - Version 8.0.x to 8.4.7.1 [Release 8.0 to 8.4]
Information in this document applies to any platform.
Information in this document applies to any platform.

Symptoms

IM Analytics Log Loading fails (even after repeated tries)


The following messages will be seen in the indexer log.  The IMODS table still has data in it that needs to be transformed. You will see the message ODS database already has data. Please run "Scheduler run Analytics -imm" command to load existing IMODS data to STAR schema.

[483 Local Workclient-default-taskrun (111)] The datasource (analytics) is creating a connection for user analytics with url [jdbc:oracle:thin:@RICHDB:1521:PROD05] and properties {}
[484 Local Workclient-default-taskrun (111)] UNKNOWN MESSAGE ID "Performing update stats on a couple of staging tables2013-01-08 10:21:10.460" called with: "com.inquira.analytics.im.OptimizeStagingTables"
[485 Local Workclient-default-taskrun (111)] UNKNOWN MESSAGE ID "Completed update stats on a couple of staging tables2013-01-08 10:21:10.553" called with: "com.inquira.analytics.im.OptimizeStagingTables"
[486 Local Workclient-default-taskrun (111)] UNKNOWN MESSAGE ID "Database Type Found for OLTP: oracle" called with: "class com.inquira.analytics.im.IMLoad"
[487 Local Workclient-default-taskrun (111)] The datasource (analytics) is creating a connection for user analytics with url [jdbc:oracle:thin:@RICHDB:1521:PROD05] and properties {}
[488 Local Workclient-default-taskrun (111)] UNKNOWN MESSAGE ID "rep_user_dim already has data in rep_user_dim" called with:
[489 Local Workclient-default-taskrun (111)] UNKNOWN MESSAGE ID "ODS database already has data. Please run "Scheduler run Analytics -imm" command to load existing ODS data to STAR first. " called with:
[490 Local Workclient-default-taskrun (111)] Task [Analytics/IM Log Load] was forced to failure by workclient Local Workclient.
[491 Local Workclient-default-taskrun(111)] Event(Code=RECEIVE_EVENT, id=#1B59I111P-1) ended at 1/8/13 10:21 AM after 594ms: Received event cd005a84-59ae-11e2-9ced-8769cdbb488c#1B58I109P108 from scheduler to Local Workclient.
[492 Scheduler(107)] SCHEDULER_RUN_JOB resumed at 1/8/13 10:21 AM: Job 'Analytics'.
[493 Scheduler(108)] SCHEDULER_RUN_TASK resumed at 12/31/69 5:59 PM: Task [Analytics/IM Log Load] assigned to workclient Local Workclient.


 

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