cancel
Showing results for 
Search instead for 
Did you mean: 

error reading from salesforce adapter [BODS]

former_member186160
Contributor
0 Kudos

i have a requirement to read data from salesforce to SQL database.

ETL being BODS.

BODS job is very simple: direct mapping of source to target fields.

the job loads successfully in DEV. but only in QTY, the job fails most of the times with below error message.

error message from the job monitor:

Error reading from <SALESFORCE_SOURCE_TABLE>:

<Could not read data for session 67, operation 66 (Adapter: 'SalesForce')>

but when our basis team checks the salesforce adapter logs,

there are no error messages.

also the salesforce adapter is in green and stable status.

settings for salesforce adapter in DEV is : 1GB

settings for salesforce adapter in QTY is : 2GB

please suggest your views.

Accepted Solutions (1)

Accepted Solutions (1)

former_member187605
Active Contributor
0 Kudos

I am afraid you're hitting some resource (memory?) limits. Have you tried loading part of the data? Does that work?

If it does, you could add a filter to the extraction to retrieve data in parts, and build a loop over it.

former_member186160
Contributor
0 Kudos

Hi Dirk,

no, i dint add a filter on the source.

the source is actually a salesforce table, and i couldnt find any option to filter from it.

former_member187605
Active Contributor
0 Kudos

I don't have access to salesforce, cannot test myself. But can you add a simple where-clause to the 1st query transform in your data flow? Just wondering if the condition is pushed down to the source.

former_member186160
Contributor
0 Kudos

hi Dirk,

yes i tried adding filter in the query transform.

but the issue is still occuring in the first extraction step from the source [this step is extracting all of the source data]

Former Member
0 Kudos

check if you have following parameters exists in %DS_COMMON_DIR%\conf\DSConfig.txt file under [int[ section

AdapterRetryInterval = 15000

AdapterStartTimeout = 90000

AdapterDataExchangeTimeout = 10800000

former_member186160
Contributor
0 Kudos

Manoj,

AdapterDataExchangeTimeout has a lesser value only in qty system [this is where we have issue].

Our Basis team will be updating this value tomorrow.


AdapterStartTimeout : we dont have this parameter in any of our systems : DEV/QTY/PROD.

could this affect the load?

Former Member
0 Kudos

yes, AdapterStartTimeout is required else the operation will timeout and you will get the session related error, please have your basis team add this missing parameter on Job Server machine, also add this on your Designer machine , from which you import SFDC tables

Answers (0)