[Shared Memory]General network error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Rajneesh1990
Participant
Posts: 6
Joined: Fri Nov 18, 2011 3:19 am
Location: Delhi

[Shared Memory]General network error

Post by Rajneesh1990 »

Hi All,

One of my job is aborting from last two days and giving the error:
[Microsoft][ODBC SQL Server Driver][Shared Memory]
General network error. Check your network documentation.


I am Executing SQL Server Procedure by using DRS Stage and the
Job is taking more than two hours to complete everyday but last two
Days it is failing and giving above mentioned Error.

Can anyone help me to resolve the Issue?

Regards,
Rajneesh.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

It is failing after two hours with the indicated error or right away? Have you taken the issue to your DBA or SysAdmin to see if they can help?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Rajneesh1990
Participant
Posts: 6
Joined: Fri Nov 18, 2011 3:19 am
Location: Delhi

Post by Rajneesh1990 »

Job Fails After 5 min from starting it and first line of Error is :

[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionRead (recv()) and above mentioned error as second line.
However I am running the same procedure in SQL SERVER manually then it runs fine without any problem.

I asked about the issue but did't get any resolving answer.
Post Reply