Why OK ODI ETL failed with "BatchUpdateException: ORA-01461" after Recommendation (with Description >4000 Characters) was Submitted from Infocenter? (Doc ID 1596791.1)

Last updated on JANUARY 05, 2016

Applies to:

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

Symptoms

OK ODI ETL failed with below exception after Recommendation (with Description >4000 Characters) was submitted from Infocenter:

...
SEVERE: Exception while logging  with query:[INSERT INTO DW_STG_DATA (DATA_ID, ACTION_EVENT, CASELINK_NAME, CHANNEL_ID, COMMENTS, CONTENT_ID, DOCUMENT_ID, EVENT_NAME, ID, LOCALE_ID, PRIORITY, REPOSITORY_ID, SESSION_ID, SUBMITTED_USER_ID, TIMESTAMP, TIMESTAMP_STR) VALUES (DW_STG_DATA_SEQ.NEXTVAL, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)],  Loggable: {"id":"562e83f8e9f54706a5940e9663be896d","action":"SUBMITTED","submittedUserId":"9109df0873da45e6b7ded8bfcfd5ed8b","completedUserId":"N/A","channelId":"592247ad2aa747c69f9d300810e6d23b","contentId":"N/A","documentId":"N/A","localeId":"en_US","priority":1,"comments": ....
...

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