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)
Read more...
Environment
SAP Data Intelligence both onPrem and Cloud
Product
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.