BusinessObjects Board

SF Job failed in DS 4.2 SP8

dataservices realtime
#1

Hi,

We have recently migrated to DS 4.2 SP8 from DS 4.1.

While running the Salesforce based jobs in 4.2 we are facing some issues.

22172 20068 RUN-058107 5/8/2017 5:08:21 AM Error reading from : <Invalid field. Salesforce.com message is
22172 20068 RUN-058107 5/8/2017 5:08:21 AM Inactive__c FROM Account Account WHERE (CLIENT_SEQ_NO__c != 99999)
22172 20068 RUN-058107 5/8/2017 5:08:21 AM ^
22172 20068 RUN-058107 5/8/2017 5:08:21 AM ERROR at Row:1:Column:515
22172 20068 RUN-058107 5/8/2017 5:08:21 AM value of filter criterion for field ‘CLIENT_SEQ_NO__c’ must be of type string and should be enclosed in quotes>.

Not sure about this issue.

Any help is appreciated.

Thank you.

vasanthasuresh (BOB member since 2011-07-28)

#2

you should do two things, Check that field in available in target sfdc table. Reimport the table and look for field.

If the field is available, ask you sfdc team to validate the authorizations of that field for your integration user.

once both are looking good, please use the string or varchar datatype in filter condition you have.

sfdc - salesforce

Ram18 (BOB member since 2013-08-16)