on 05-28-2015 2:49 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.