Topic
1 reply Latest Post - ‏2012-01-20T16:13:30Z by yangling
mistryd
mistryd
28 Posts
ACCEPTED ANSWER

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.

Regards,
Mistry
Updated on 2012-01-20T16:13:30Z at 2012-01-20T16:13:30Z by yangling
  • yangling
    yangling
    38 Posts
    ACCEPTED ANSWER

    Re: Impromptu Report error

    ‏2012-01-20T16:13:30Z  in response to mistryd
    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...