Devart Forums

We are regularly experiencing the following errors with our DEVART connector for Salesforce. My DBA would like to know what this means:

Here are the errors we are seeing:
1. SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Devart Salesforce Destination" (23) failed with error code 0x80131500 while processing input "input" (34). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
2. Executed as user: CHB\SqlBi01$Agent. ...(E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Catastrophic failure (Exception from HRESUL... The package execution fa... The step failed.

1. Were there any more specific error messages?

2. Are you running your package via Visual Studio or SQL Server Agent job?

3. Please follow these steps to debug the Devart Salesforce Destination component (via Visual Studio):
a) right click on the designer surface of your Data Flow Task > Edit Breakpoints and set a break point for the OnPreExecute event
b) Start Debugging (F5), the execution will stop on the break point
c) open another instance of Visual Studio (2nd):
* go to Tools->Options...->Debugging, and disable the Enable Just My Code (Managed Only) check box. Then go to Debug->Exceptions and enable Common Language Runtime Exceptions check box. These actions will allow you to catch the inner exception and a detailed call stack
* navigate to Debug->Attach to Proccess and attach to the DtsDebugHost.exe (T-SQL, Managed...) process
d) switch to the 1st instance of Visual Studio and press F5 to continue execution
e) now you will be able to catch all exceptions in the 2nd Visual Studio. Skip unimportant exceptions until you find the Devart exception with its details

1. That is the exact error message received from the system

2. it is being run by a SQL Agent Job

I will pass on your suggestion to our DBA