Getting different error for different user

[sgoydani]

Hi All,

I am getting the following error while trying to run a list report:
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'. DPR-ERR-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2015-01-07-10:06:56.987-#39

While trying to run the same report as Admin getting the following error:
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'. UDA-SQL-0107 A general exception has occurred during the operation "prepare". ORA-00600: internal error code, arguments: [kkoipt:invalid aptyp],
,
, [], [], [], [], [], [], [], [], []

Can someone please help me with the error.

Thanks in Advance

[Raghuvir]

Hi,

are you using SQL statements to pull the data or just refering to data items from the framework manager package to build the report ?

Regards

[BigChris]

Looks like you're running over an Oracle database which isn't really my area of knowledge. The sort of thing I'd try would be to see if the SQL query the report generates will run successfully directly on the database.

[MFGF]

Hi All,

I am getting the following error while trying to run a list report:
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'. DPR-ERR-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2015-01-07-10:06:56.987-#39

While trying to run the same report as Admin getting the following error:
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'. UDA-SQL-0107 A general exception has occurred during the operation "prepare". ORA-00600: internal error code, arguments: [kkoipt:invalid aptyp],
,
, [], [], [], [], [], [], [], [], []

Can someone please help me with the error.

Thanks in Advance

Hi,

I think when you are logged in as the Admin you are getting the complete message, whereas the message is being suppressed under your "normal" ID. I strongly suspect it's the exact same issue.

The crux appears to be ORA-00600 coming back from Oracle. I just googled it, and it's a nasty one, by the looks of things - often caused by an issue somewhere in the deepest bowels of the Oracle database. Take a look at the link below:

http://www.orafaq.com/wiki/ORA-00600

I think you might have to log this with Oracle support.

MF.