Column missing in Salesforce Source Connector

110 views
Skip to first unread message

DW Developer

unread,
Jan 10, 2017, 3:55:32 PM1/10/17
to COZYROC
We are using CozyRoc 1.6, 64 bit Salesforce Source and OLEDest to MS SQL server for Data Flow Task. Using SalesForce data loader I see a field in the Salesforce object. But that field is not pulled by the SF CozyRock connector. When I open the component's editor I see the field "LastReferencedDate" available  in "Column Mappings", and "Input and Output Properties". 

When I run the DataFlow Task I get the error message: "No such column 'LastReferencedDate' on entity 'xxxxxxxxxxxxxx'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names."

After opening the SalesForce Source component and doing the Refresh All, this "LastReferenceDate" field disappears. And the Data Flow Task runs successfully for other fields in Account object. I am wondering what could be the reason that this particular field is not recognized by the Salesforce source component. As I said I could see the field is available in Salesforce Data Loader tool.

Advance thanks and appreciation for your reply.

Razzakul Chowdhury

DW Developer

unread,
Jan 10, 2017, 7:53:46 PM1/10/17
to COZYROC
We got it resolved. We were calling the wrong API to Sales Force. Once we fixed that the problem is resolved. Thanks.

Razzakul Chowdhury (Raz)
Reply all
Reply to author
Forward
0 new messages