on 10-06-2014 12:51 PM
Hello Experts,
Here is the scenario:
Loading data from DB2 source to SQL Server 2008 R2 through data services. Job failed to load the target with the below error message.
---- Error Message from Log File ----
error message for operation <SQLExecute>: <[Microsoft][SQL Server Native
Client 10.0]TCP Provider: The semaphore timeout period has expired.
[Microsoft][SQL Server Native Client 10.0]Communication link failure>.
Job server and DB server both are on Windows only.
Not able to find any related information for this semaphore error. I am not sure whether it is a Network related error, or OS related or any other autorizations, or from Data Base side.
able to ping from DB server to Job server and vice versa, all ports are open and job use to run successfully prior to this run, its a weeekly load, Last load failed on 28th Sep, 2014.
Regards,
Raj
I came here with similar issue connecting to SAP HANA, and resolved by restarting my VPN (cisco connection).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hhi Raj,
I have the same problem in my Production sytem now. can you please tell me if you have already found the cause?
thanks,
ASk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raj,
After Seeing your error i think it might be a problem with opearting system only. Because Semaphore is a variable which is used for the resource sharing when multiple process are running on the opearating system. I think their might be any deadlock kind of situation that is the reason for this error..
To resolve this: can you please try by killing all the applications running on the operating system and also all kill the queries which are running on the database.. please let me know if i am wrong and if you got any solution on this error
Thanks,
R.Sumanth.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.