CSC Indexing Fails With Database Errors ORA-01013 and DRG-50857 (Doc ID 2057322.1)

Last updated on SEPTEMBER 21, 2015

Applies to:

Oracle Commerce Service Center - Version 11.0 and later
Information in this document applies to any platform.

Symptoms

When indexing was manually begun for order or profile indexing in Commerce Service Center, it appeared to freeze at the step "Merging staging table tokens". After about an hour, the indexing job exits without completing and  some errors are logged:

 

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