• 1 reply
  • Latest Post - ‏2012-01-20T16:13:30Z by yangling
28 Posts

Pinned topic Impromptu Report error

‏2012-01-04T08:51:19Z |
Hi All,
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>.

Any suggestions.

Thanx in advance.

Updated on 2012-01-20T16:13:30Z at 2012-01-20T16:13:30Z by yangling
  • yangling
    38 Posts

    Re: Impromptu Report error

    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...