can't get data from Salesforce with dotConnector

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Cloud Applications
Post Reply
light_wt
Posts: 2
Joined: Sat 24 Mar 2012 14:01

can't get data from Salesforce with dotConnector

Post by light_wt » Sat 24 Mar 2012 14:57

In connection manager, a connection is created and passed testing to connect to Salesforce.com (sfdc).

In Data flow, an ADO source is created to connect to sfdc to get the Contacts. the data then go to a Union All.

On execution, the following error is generated. How to fix it?


TITLE: Package Validation Error
------------------------------

Package Validation Error

------------------------------
ADDITIONAL INFORMATION:

Error at Data Flow Task [ADO NET Source [1]]: An error occurred executing the provided SQL command: "select * from "Contact"". INVALID_SESSION_ID: Invalid Session ID found in SessionHeader: Illegal Session. Session not found, missing session key: 00Dd0000000dzLR!AR4AQBF6Ws1QpH1.Art2qYGpMlpqaN901Z7_5QADpkbkLyhHHzWf5aWWfarHjgu1yqp.52bh8C2SwoDhHIICvkU4U2Ls57pZ

Error at Data Flow Task [SSIS.Pipeline]: "component "ADO NET Source" (1)" failed validation and returned validation status "VS_ISBROKEN".

Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.

Error at Data Flow Task: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)

------------------------------
BUTTONS:

OK
------------------------------

Shalex
Site Admin
Posts: 9305
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 29 Mar 2012 14:15

Thank you for your report. We have reproduced intermittent INVALID_SESSION_ID error in our environment. We will post here about the results of our investigation.

Shalex
Site Admin
Posts: 9305
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 30 Mar 2012 11:29

The INVALID_SESSION_ID error went away in our test environment and we cannot reproduce it any more. Please give us the following information:
1) is this error constant or intermittent in your environment?
2) make sure that your Internet connection is stable and cannot be the reason of the problem;
3) send us a test SSIS package. If necessary, also provide us the corresponding DDL/DML scripts for SQL Server and Salesforce.

Shalex
Site Admin
Posts: 9305
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 12 Apr 2012 14:27

If you are using proxy connection in your environment, please set the proxy options in your connection string (Proxy Host, Proxy Port, Proxy User, Proxy Password).

Shalex
Site Admin
Posts: 9305
Joined: Thu 14 Aug 2008 12:44

Re: can't get data from Salesforce with dotConnector

Post by Shalex » Wed 08 Aug 2012 09:27

The bug with processing the situation when Session ID becomes invalid is fixed. We will post here when the corresponding build of dotConnect for Salesforce is available for download.

Shalex
Site Admin
Posts: 9305
Joined: Thu 14 Aug 2008 12:44

Re: can't get data from Salesforce with dotConnector

Post by Shalex » Fri 10 Aug 2012 10:15

New build of dotConnect for Salesforce 1.2.171 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/salesf ... nload.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=38&t=24675 .

Post Reply