IM Transform Task Fails with "No current row in the ResultSet" (Doc ID 2054458.1)

Last updated on OCTOBER 12, 2015

Applies to:

Oracle Knowledge - Version 8.2 to 8.2.3.7 [Release 8.2]
Information in this document applies to any platform.

Symptoms

The IM Transform task fails with the following errors:

[14713 Local Workclient-default-taskrun (38)] UNKNOWN MESSAGE ID "Entering processUpdateContentDim" called with: "class com.inquira.analytics.im.Log2Star"
[14714 Local Workclient-default-taskrun (38)] UNKNOWN MESSAGE ID "SQL Error!!" called with: "class com.inquira.analytics.im.Log2Star"
[14715 Local Workclient-default-taskrun (38)] UNKNOWN MESSAGE ID "Processing Aborting, cannot continue" called with: "class com.inquira.analytics.im.Log2Star"
[14716 Local Workclient-default-taskrun (38)] UNKNOWN MESSAGE ID "Star Connection Properties: Analytics" called with: "class com.inquira.analytics.im.Log2Star"
[14717 Local Workclient-default-taskrun (38)] UNKNOWN MESSAGE ID "ODS Connection Properties: Analytics" called with: "class com.inquira.analytics.im.Log2Star"
[14718 Local Workclient-default-taskrun (38)] UNKNOWN MESSAGE ID "OLTP Connection Properties: InfoMgr" called with: "class com.inquira.analytics.im.Log2Star"
[14719 Local Workclient-default-taskrun (38)] UNKNOWN MESSAGE ID "SQL Error Message: No current row in the ResultSet." called with: "class com.inquira.analytics.im.Log2Star"
[14720 Local Workclient-default-taskrun (38)] UNKNOWN MESSAGE ID "SQL State: 24000" called with: "class com.inquira.analytics.im.Log2Star"
[14721 Local Workclient-default-taskrun (38)] UNKNOWN MESSAGE ID "SQL Error Code: 0" called with: "class com.inquira.analytics.im.Log2Star"
[14722 Local Workclient-default-taskrun (38)] UNKNOWN MESSAGE ID "Failed on SQLStatement: SELECT COUNT(*), CONTENTID, LOCALEID, MAJORVERSION, DESCRIPTION FROM MS_IM_ACCESS_ACTIVITY_FACT WHERE CONTENTID = ? AND LOCALEID = ? AND MAJORVERSION = ?GROUP BY CONTENTID, LOCALEID, MAJORVERSION, DESCRIPTION " called with: "class com.inquira.analytics.im.Log2Star"
[14723 Local Workclient-default-taskrun (38)] UNKNOWN MESSAGE ID "SQL Parameters passed: 123410930b205e02014ecb665b07007ee8 " called with: "class com.inquira.analytics.im.Log2Star"
[14724 Local Workclient-default-taskrun (38)] UNKNOWN MESSAGE ID "Error in loading log tables: " called with:
[14724 Local Workclient-default-taskrun (39)] Workclient IM ETL handled exception for task IM Transform. Exception: Local Workclient
[14725 Local Workclient-default-taskrun(38)] Event(Code=RECEIVE_EVENT, id=#2B2I38P-1) with User Review ended at 8/12/15 2:38 PM after 163,877 ms: Received event 7b95ed1c-4120-11e5-87d7-80c702ee2563#2B1I37P36 from scheduler to Local Workclient.
[14726 Scheduler(29)] SCHEDULER_RUN_JOB resumed at 8/12/15 2:38 PM: Job 'IM ETL'.
[14727 Scheduler(36)] SCHEDULER_RUN_TASK resumed at 12/31/69 6:59 PM: Task [IM ETL/IM Transform] assigned to workclient Local Workclient.
[14728 Scheduler(40)] Event(Code=SCHEDULER_TASK_FAILURE, id=#2B141I40P-1) with Error occurred at 8/12/15 2:38 PM: Task [IM ETL/IM Transform] completed with errors.

 

 

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