Cognos Impromptu 7.4 - Error number -239:

[ckearney123]

Error number -239:

DMS-E-GENERAL, A general exception has occurred during operation 'prepare request with options'.
DMS-E-RBI_COLUMN, Column c29 was not found.

I've got the above error - I'm trying to filter from a running count summary.

thanks,

 

[CognosProfessional]

Look in the SQL Profile tab to see what C29 column is, because it is not reading correctly.
Look in the data definition of each item and find that column that doesn't exist. When you find that you will find your problem.
If you are filtering from a running count, you may have to create a separate column to read the running count first and then filter on it.

CP