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.
This topic has been locked.
1 reply Latest Post - 2012-01-20T16:13:30Z by yangling
Pinned topic Impromptu Report error
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-01-20T16:13:30Z at 2012-01-20T16:13:30Z by yangling
yangling 0600018QDQ38 PostsACCEPTED ANSWER
Re: Impromptu Report error2012-01-20T16:13:30Z in response to mistrydGo 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...