I have a impromptu report and suddenly it has started throwing error in production.
After report request has been introduced and initiated, message appears stating " Your report is running " but a while later an error message pops ups which reads :
The report request failed.
The execution of this report at 01/03/12 04:40:00 failed due to the following reason:
Error number -239: DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'. DMS-E-RPR_BAD_PARAM_TYPE, Incompatible types for parameter number <1> in the function <trunc>.
Thanx in advance.
yangling 0600018QDQ38 Posts
Re: Impromptu Report error2012-01-20T16:13:30ZThis is the accepted answer. This is the accepted answer.Go to Report | Query | Profile | SQL, copy and past the SQL code into your database developer tool (such as TOAD, or SQL Developer if you are on Oracle) to see if you can get the data resultset successfully.
This will help you troubleshoot the issue...