Home » Developer & Programmer » Data Integration » Query server error
Query server error [message #93438] Wed, 12 January 2005 23:32 Go to next message
Messages: 57
Registered: March 2000
When I run a cognos impromptu report it shows the
error as
Query Server Error

ORA-04063 has errors

Error number -239:

DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'.
DMS-E-GENERAL, A general exception has occurred during operation 'prepare request'.
ORA-04063: has errors

No ETL tool has used . The data is directly retrived from Oracle 9i to impromptu report.

How to solve it
Re: Query server error [message #93439 is a reply to message #93438] Thu, 13 January 2005 03:31 Go to previous message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member

Call your DBA for assiatance:

$ oerr ora 4063
04063, 00000, "%s has errors"
// *Cause:  Attempt to execute a stored procedure or use a view that has
//          errors.  For stored procedures, the problem could be syntax errors
//          or references to other, non-existent procedures.  For views,
//          the problem could be a reference in the view's defining query to
//          a non-existent table.
//          Can also be a table which has references to non-existent or
//          inaccessible types.
// *Action: Fix the errors and/or create referenced objects as necessary.

Best regards.

Previous Topic: minimal requirements - urgent
Next Topic: Business Objects
Goto Forum:

Current Time: Fri Dec 03 18:41:17 CST 2021