Query Server Error 239

[89a677]

I have been running a report for several months and just recently started receiving the following error:

DMS_E_GENERAL, A general exception has occurred during operation'prepare request'.

Once I cancel the report, close it and open it again, it works fine. The problem is that I have automated the report so it won't work running from the script

 

[sathishg]

Error number -239:

DMS-E-GENERAL, A general exception has occurred during operation 'prepare request'.
DMS-E-SS_INCONS_LOGICAL, An inconsistent logical operation was specified.

Solution:

Check the data types for the columns involved in the join. In this particular case the columns were defined as 'number' and 'number(10)'. Switching the data types so that they are the same (i.e. 'number(10)' and 'number(10)' can resolve this issue.