Lookup_PaymentIn: [IIS-CONN-TERA-005011] Field ARGFIN is unreferenced in the SQL statements (CC_TeraDBRecordDataSetConsumer::setDataSetDef, file CC_TeraDBRecordDataSetConsumer.cpp, line 620)
Although its there in the SQL which i have specified i am not sure why is it saying the field is not being referenced.
Any help on this please?
thanks!
Great. There were two fields defined as keys in the lookup stage one of which was ARGFIN. Although it was not being used in the SQL itself because a hardcoded value had to be passed there for it. So the solution you provided worked for this error. And to make it work for the given scenario so that it can use a hardcoded value, i had to remove it from the
lookup stage ?... works now but gives a warning.
Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
There is another way to get rid of that error that says, "Field ARGFIN is unreferenced in the SQL statements". As you discovered, the problem was that your lookup key contained field ARGFIN, but your SQL did not contain ORCHESTRATE.ARGFIN. In the connector properties, there is a property called "Unused field action". Its default is Abort, which means the connector should abort if an input column is not referenced in the SQL. You can change it to one of the other values (Drop, Warn, or Keep) to get rid of the error.
But ray.wurlod I am getting same error in when I am Insert into target table. I am getting below issue
[IIS-CONN-TERA-005011] Field xxxx is unreferenced in the SQL statements (CC_TeraDBRecordDataSetConsumer::setDataSetDef, file CC_TeraDBRecordDataSetConsumer.cpp, line 655). Can u help with this. How to clear error. my insert statment is insert into ABC(A,B,C)values(243, current_timestamp, orchestrate.xxxx);
Thanks In advance..
Barath