Query server error [message #93438] |
Wed, 12 January 2005 23:32 |
Raja
Messages: 57 Registered: March 2000
|
Member |
|
|
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
Note:
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 |
Frank Naude
Messages: 4581 Registered: April 1998
|
Senior Member |
|
|
Hi,
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.
Frank
|
|
|