Architecting, installing and maintaining your SAS environment

Error in SAS Jobs

Reply
Occasional Contributor
Posts: 18

Error in SAS Jobs

Hi All,

 

We have scheduled Data Integration studio jobs in SMC and they are running daily well. Suddenly today jobs failed due to below error:

 

ERROR: The Bridge Protocol Engine Socket Access Method was unable to connect to host metadata, port 8561.
ERROR: The TCP/IP tcpSockConnect() support routine failed with error 10060 (The connection has timed out.).

 

When I checked SAS services, they are up and running fine. And, if I run manually it is working fine. 

 

Could anyone pls guide me what does the above error means?

 

Thanks for your help in advance..!

 

Regards,

Sundeep

Super User
Posts: 6,936

Re: Error in SAS Jobs

[ Edited ]

The environment where your batch runs seems to be different from the one where you are doing your manual tests.

Maybe something happened to (personal) firewall settings?

 

And please supply some information about your SAS landscape (server operating system(s), client access, affected userID's etc.)

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 18

Re: Error in SAS Jobs

Hi,

 

Thanks for your prompt reply..!

 

Server OS: Windows Server 2008 R2

client: DI studio

User ID: sasdemo

 

After the execution of jobs, logs will be generated in particular folder. Last week, we had the similar problem. And, the following day jobs went well. 

 

That error will occur twice in a week. There is no change in firewall setting.

 

Regards,

Sundeep

Regular Contributor
Posts: 241

Re: Error in SAS Jobs

 

Is it happening for all jobs or for particular one job?

Super User
Posts: 6,936

Re: Error in SAS Jobs

Do all jobs fail at a given time, or just some of the jobs?

You might have a condition where the server becomes congested because of a load of jobs running in parallel, and the metadata server therefore being too slow to respond.

 

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 18

Re: Error in SAS Jobs

Hi Kurt,

 

Jobs are running in a sequential order. Assume jobs are scheduled in the below manner:

 

a-->b--->c--->d-->e-->f-->g

 

At point 'e', the job is getting failed.

 

 

Super User
Posts: 6,936

Re: Error in SAS Jobs

Is this behaviour repeatable?

And do jobs "a" to "d" need to be finished before "e" starts?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 18

Re: Error in SAS Jobs

Yes

##- Please type your reply above this line. Simple formatting, no
attachments. -##
Super User
Posts: 6,936

Re: Error in SAS Jobs

Hmm. Could you post the complete log of the step that fails?

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 18

Re: Error in SAS Jobs

ERROR: The Bridge Protocol Engine Socket Access Method was unable to connect to host metadata, port 8561.
ERROR: The TCP/IP tcpSockConnect() support routine failed with error 10060 (The connection has timed out.).

ERROR: SQL View WORK.WSFQC2D2 could not be processed because at least one of the data sets, or views, referenced directly (or
       indirectly) by it could not be located, or opened successfully.

Super User
Posts: 6,936

Re: Error in SAS Jobs

This is not the complete log, just the ERROR messages. We need to see the code that caused the messages.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Regular Contributor
Posts: 241

Re: Error in SAS Jobs

I think this problem is related to the particular job e.

 

As I said earlier job e is trying to update table metadata. Check with developer of this job.

Regular Contributor
Posts: 241

Re: Error in SAS Jobs

[ Edited ]

See the resolution in the below link.

http://support.sas.com/kb/14/819.html

 

Do check if your job uses Transpose transformation. It might be trying to UPDATE TABLE METADATA and causing issue. 

Super User
Posts: 5,256

Re: Error in SAS Jobs

Complete means including the SAS code.
Data never sleeps
Ask a Question
Discussion stats
  • 13 replies
  • 624 views
  • 0 likes
  • 4 in conversation