Symptom
- A CI-DS task fails with the following error:
- RES-20116 |SESSION XXXXX|DATAFLOW XXXXX|STATEMENT <GUID::'XXXXX' QUERY XXXXX> Could not find column <XXXXX> that contains the value looked up in the specified table <XXXXX.csv>. Ensure that the lookup table has this column defined and the column name has been spelled correctly.
- The lookup function is called correctly.
- The file called in the lookup function has the correct structure and metadata maintained in the file format datastore.
that contains the value looked up in the specified table
Environment
SAP Cloud Integration for data services
Product
SAP Cloud Integration for data services 1.0
Keywords
CI-DS, cids, task, fail, error, find, column, contains, value, looked, up, lookup, specified, table, cache, datastore, atl, correct, structure, metadata , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , Problem
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.
SAP Knowledge Base Article - Preview