BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

BODS 4.2 SP11 Communication Error after Mainframe IPL


 
Search this topic... | Search Data Integrator... | Search Box
Register or Login to Post    Forum Index -> Data Integrator  Previous TopicPrint TopicNext Topic
Author Message
Ratboy
Forum Member
Forum Member



Joined: 23 Oct 2019

Posts: 1



PostPosted: Wed Oct 23, 2019 1:09 pm 
Post subject: BODS 4.2 SP11 Communication Error after Mainframe IPL

On a monthly basis, we IPL the mainframe and every time our nightly extract job fails in the same spot with the same error. The job kicks off prior to the IPL as it is waiting for a trigger file to be place on the network. The file is placed on the network after the IPL. I cannot find anything that the extract job is in contention with on the mainframe. I did make sure that everything for DB2 was up and running.

Here is the SQL from within a script:
sql('DB2_DS', 'SELECT COUNT(*) FROM ' || $LV_Alias || '.ARCH_HLD_KEYS WHERE OWNER_CD = ' || [$$VehDriver] ). The columns are all character in the table.
The weird thing about it, it only fails the first time this code is executed. We restart the job and the next time and it runs fine.

Here is the error:
Function call <sql ( DB2_DS, SELECT COUNT(*) FROM SEC.ARCH_HLD_KEYS WHERE OWNER_CD = 'PVEHDRVR' ) > failed, due to error <70404>: <SQL submitted to ODBC data source <SECDB2P>
resulted in error <[IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS".
Location where the error was detected: "172.18.100.200". Communication function detecting the error: "send". Protocol specific error code(s): "10053", "*", "*". SQLSTATE=08001

It is almost like the job needs to be primed like a pump and then it is fine.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0268 seconds using 17 queries. (SQL 0.0022 Parse 0.0008 Other 0.0237)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo