Hi,

I am receiving this error quite frequently. One more thing I observed is if I referesh the adapter, then it will run for a day. But in the next day when we run the first insert, it fails again with this error. Is there any fix for this or how do I refresh the adapter before insert.
Please help

Error:

(08S01/0) [Microsoft][SQLServer 2000 Driver for JDBC]Broken pipe"
[Microsoft][SQLServer 2000 Driver for JDBC]Broken pipe

Thanks & Regards,
Srivats

This indicates that socket connection from adapter to SQL Server gets killed. Check SQL Server log for possible reasons of why sessions get terminated.

Gregory Kanevsky

Hi Greg,

Is it something to do with SQL Server or wM JDBC Adapter ? I could insert the data after the first failure in a day. It looses connectivity after some idle time when there is no activity with SQL Server. Is any setting needs to be performed on SQL Server.

Thanks for your help,

Srivats

Are your SQL server connections configured on the Windows side to timeout after a period of inactivity?

Hello experts,
I am also facing same problem with JDBC adapter and the flow service is getting hung at adapter step. I tried killing the thread. But it is appearing again and again. Finally server is restarted to fix this. But cannot restart production server every time.

This was working from past one year. But this error occurred twice in past 15 days.

Need your help to handle this problem.

Thank you.

All,

I am also getting the same error on our prod 7.1 environment.

ADA.1.208] Cannot disconnect from the database. "
(17002) Io exception: Broken pipe"
Io exception: Broken pipe

Sometimes the error does not present itself but at times the frequency of this error increases and adapter reload or server restart are the ways to get over it. After seeing the posts it looks like this is a common error in webMethods.

can the experts throw some light on this issue.

Thanks and Regards,
Rajkumar

if you have a firewall between application and DB, it may cutting the connection after period of inactive. check with your network team.
you can write a ping service to run every minutes to keep the connection alive.

I am receiving this error on DB TO DB connection. I observed with this error message it try select query on the first time. then i accept this message button, and then try again select query, it run normally.
Please help

2015-06-05 09:58:24 KST SM.DSSC_DB_RCV.flows_woos:DSSC_DB_RCV_SrcWOOS_AR_TgtSM SM.DSSC_DB_RCV.flows_woos:DSSC_DB_RCV_SrcWOOS_S_AR

SM.DSSC_DB_RCV.flows_woos:DSSC_DB_RCV_SrcWOOS_AR_TgtSM(/0)

[ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service SM.DSSC_DB_RCV.flows_woos:DSSC_DB_RCV_SrcWOOS_S_AR.

[ADA.1.316] Cannot execute the SQL statement "SELECT t1.ITEM_TYPE,t1.DEMANDER_CD,t1.C_ORDER_CD,t1.ORG_DATE,t1.ORG_TIME,t1.HSTEEL_ORD_NO,t1.HSTEEL_ORD_DTL,t1.GOODS_NO,t1.GOODS_NO_DTL,t1.HKMC_PLNT_CD,t1.ITEMNAME_CD,t1.SPEC_ABBSYM,t1.ORD_THK,t1.ORD_WID,t1.GAL_PTR_CD,t1.ORD_GW_FRN_BAK,t1.HKMC_ITM_NO,t1.COIL_YN,t1.KND_CD,t1.PART_NAME,t1.SLP_CD,t1.ORD_GP,t1.DIST_MOD_GP,t1.AR_MOD_GP,t1.STK_WT,t1.ISSUE_WORD_DATE,t1.AR_DATE,t1.PRE_AR_CD,t1.PRESS_VDR_CD,t1.PRESS_VDR_NM,t1.PROCESS_YN,t1.ORD_ERR_CONTENTS,t1.ISSUE_WORD_NO,t1.ISSUE_WORD_LN FROM DCR_SND.DM_B2B_DSSC_GOODS_AR t1 WHERE (t1.PROCESS_YN = ’ ’ OR t1.PROCESS_YN IS NULL) ". "

(08006/17002) IO ??: Broken pipe"

IO ??: Broken pipe

Stack trace data … f5904ca0-0b1d-11e5-825d-ef162ee461bf f5904ca0-0b1d-11e5-825d-ef162ee461bf f78c1ca0-0b1d-11e5-8345-c30c1a7e169a

2015-06-05 09:58:24 KST SM.DSSC_DB_RCV.flows_woos:DSSC_DB_RCV_SrcWOOS_S_AR [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service SM.DSSC_DB_RCV.flows_woos:DSSC_DB_RCV_SrcWOOS_S_AR.

[ADA.1.316] Cannot execute the SQL statement "SELECT t1.ITEM_TYPE,t1.DEMANDER_CD,t1.C_ORDER_CD,t1.ORG_DATE,t1.ORG_TIME,t1.HSTEEL_ORD_NO,t1.HSTEEL_ORD_DTL,t1.GOODS_NO,t1.GOODS_NO_DTL,t1.HKMC_PLNT_CD,t1.ITEMNAME_CD,t1.SPEC_ABBSYM,t1.ORD_THK,t1.ORD_WID,t1.GAL_PTR_CD,t1.ORD_GW_FRN_BAK,t1.HKMC_ITM_NO,t1.COIL_YN,t1.KND_CD,t1.PART_NAME,t1.SLP_CD,t1.ORD_GP,t1.DIST_MOD_GP,t1.AR_MOD_GP,t1.STK_WT,t1.ISSUE_WORD_DATE,t1.AR_DATE,t1.PRE_AR_CD,t1.PRESS_VDR_CD,t1.PRESS_VDR_NM,t1.PROCESS_YN,t1.ORD_ERR_CONTENTS,t1.ISSUE_WORD_NO,t1.ISSUE_WORD_LN FROM DCR_SND.DM_B2B_DSSC_GOODS_AR t1 WHERE (t1.PROCESS_YN = ’ ’ OR t1.PROCESS_YN IS NULL) ". "

(08006/17002) IO ??: Broken pipe"

IO ??: Broken pipe

Stack trace data … f5904ca0-0b1d-11e5-825d-ef162ee461bf f78c1ca0-0b1d-11e5-8345-c30c1a7e169a f78f7800-0b1d-11e5-8346-bb13fd6b9559

2015-06-05 09:58:24 KST SM.DSSC_DB_RCV.flows_woos:DSSC_DB_RCV_SrcWOOS_S_AR [ADA.1.316] Cannot execute the SQL statement "SELECT t1.ITEM_TYPE,t1.DEMANDER_CD,t1.C_ORDER_CD,t1.ORG_DATE,t1.ORG_TIME,t1.HSTEEL_ORD_NO,t1.HSTEEL_ORD_DTL,t1.GOODS_NO,t1.GOODS_NO_DTL,t1.HKMC_PLNT_CD,t1.ITEMNAME_CD,t1.SPEC_ABBSYM,t1.ORD_THK,t1.ORD_WID,t1.GAL_PTR_CD,t1.ORD_GW_FRN_BAK,t1.HKMC_ITM_NO,t1.COIL_YN,t1.KND_CD,t1.PART_NAME,t1.SLP_CD,t1.ORD_GP,t1.DIST_MOD_GP,t1.AR_MOD_GP,t1.STK_WT,t1.ISSUE_WORD_DATE,t1.AR_DATE,t1.PRE_AR_CD,t1.PRESS_VDR_CD,t1.PRESS_VDR_NM,t1.PROCESS_YN,t1.ORD_ERR_CONTENTS,t1.ISSUE_WORD_NO,t1.ISSUE_WORD_LN FROM DCR_SND.DM_B2B_DSSC_GOODS_AR t1 WHERE (t1.PROCESS_YN = ’ ’ OR t1.PROCESS_YN IS NULL) ". "

(08006/17002) IO ??: Broken pipe"

IO ??: Broken pipe

Stack trace data … f5904ca0-0b1d-11e5-825d-ef162ee461bf f78c1ca0-0b1d-11e5-8345-c30c1a7e169a f78f7800-0b1d-11e5-8346-bb13fd6b9559

2015-06-05 09:58:24 KST SM.DSSC_DB_RCV.flows_woos:DSSC_DB_RCV_SrcWOOS_S_AR IO ??: Broken pipe

Hi There,

This could be several reasons but make sure of the below points:

Check network, firewall rules, DB outages.

The underlying issue was a lost or broken TCP/IP connection, shown by the messages regarding TCP/IP broken pipe.

Change Minimum Pool from current value to 0

SAG always recommends to apply latest fixes on IS and also for JDBC adapter.

Hi,
Did you involve Networking team to fix this ? What’s the latest news on this ?

Thanks,