3155743 - RUN-051015: You cannot select directly from timestamp column - SAP Data Intelligence

Symptom

When using 'SQL Consumer' operator query Oracle database, if there is any column of 'timestamp' type in the source table, graph fails with error:

Group: default; Messages: Graph failure: structuredfileproducer1 failed with the following error:
RUN-051015: You cannot select directly from timestamp column . Using a timestamp column in SQL transform may cause this error. See documentation.DBS-054003: |Reader SQL SELECT query failed. The database error message is . Using a timestamp column in SQL transform may cause this error. See documentation.>. SELECT query <*****> failed. The database error message is <*****>. DBS-054003: |Reader SQL SELECT query failed. The database error message is . Using a timestamp column in SQL transform may cause this error. See documentation.>. | error with process "":
Process(es) terminated with error(s). restartOnFailure==false
Breakpoints (0 out of 0)

Environment

SAP Data Intelligence both onPrem and Cloud

Product

SAP Data Intelligence all versions

Keywords

KBA , CA-DI , Data Intelligence , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.