Hi,
I am running BOXI R2 Sp2 against an Oracle 10.2.0.03 database and have recently started to encounter an error when a specific report is modified to have an additional parameter added.
The error is:
Query 1 - Performance Indicators
Database error: ORA-00600: internal error code, arguments: [qernsRowP], [1], [], [], [], [], [], []
. Contact your Business Objects administrator or database supplier for more information. (Error: WIS 10901)
The driving table the report is based on is range partitioned by financial years and utilises a number of bitmapped, normal and function indexes.
The standard parameters for the report are Area, Name, Transaction type and Month and the standard report does not cause the error no matter what parameters are entered. All these columns are bitmapped indexed. When the report is modified and Transaction identifier (text) is added (which is function indexed NVL("TRANSACTION_ID",'Not entered') and the report is run for a single month the error occurs. This seems to occur only when the month is April 2009 and only for selected transaction ids, some work fine. Running the SQL generated from Business Objects through Sqlplus also causes the error.
Has anyone else encountered this issue ? If so did you find a solution ?
Any help is appreciated,
Pat.