ORA-00600 Error When Trying to Query Data in a Worksheet (Doc ID 1321720.1)

Last updated on JUNE 15, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.3.0 and later
Information in this document applies to any platform.
***Checked for relevance on 11-Dec-2013***

Symptoms


On 7.3.0 version, Technical

When attempting to query data in a worksheet
the following error occurs in the worksheet window:

ERROR
-----------------------
"com.demantra.applicationServer.appServerExceptions.ApplicationServerException: java.sql.SQLException: ORA-00600: internal error code, arguments: [19004],....."
"Selected page item has no data"


The Collaborator.log file shows the following:

ERROR query.run: ODPM-70016: Error loading query from Application
Server:com.demantra.applicationServer.appServerExceptions.FailedToExcuteBatch: java.sql.BatchUpdateException: error occurred during batching: ORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], [], [], [], [], [] com.demantra.applicationServer.appServerExceptions.ApplicationServerException: com.demantra.applicationServer.appServerExceptions.FailedToExcuteBatch: java.sql.BatchUpdateException: error occurred during batching: ORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], [], [], [], [], []


The Java Console log may also post the above error.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open a worksheet and query for the data.
2. Receive the error.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Cannot query data in the worksheet.

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