IBM Support

DMS-E-SS_SYNTAX, A syntax error was detected near ''TIMESTAMP''.

Technote (troubleshooting)


Unable to convert the datetime column in the main query to a date using the datetime-to-date function when joining a sub-report to the main report on a datetime column.

Error Message -

Error number -239:

DMS-E-GENERAL, A general exception has occurred during operation 'prepare request'.
DMS-E-SS_SYNTAX, A syntax error was detected near 'TIMESTAMP'.

Resolving the problem

1. Remove the datetime-to-date function from the date column in the main query.
2. Run the report to ensure the error does not occur.
3. Remove the filter on the sub-report joining the sub-report to the main query.
4. Add the datetime-to-date function to the datetime in the main query.
5. Run the report again.
6. Add filter back into the sub-report.
7. Run the report again.

Cross reference information
Segment Product Component Platform Version Edition
Business Analytics Cognos Series 7 Impromptu Web Reports

Historical Number


Document information

More support for: Cognos Series 7

Software version: Impromptu 6.0, Impromptu Web Reports 7.3

Operating system(s): Platform Independent

Reference #: 1349267

Modified date: 12 September 2014