Error number -239

[naveenshindhe]

hi,
i am running a report and getting error like this.
Error number -239:

DMS-E-GENERAL, A general exception has occurred during operation 'prepare
request'.
DMS-E-SS_PARSER, An error was detected during processing of the SQL request.
DMS-E-SS_INCONS_LOGICAL, An inconsistent logical operation was specified.

anybody has idea regarding this.
regards
naveen.

 

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