IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

Getting Broken Pipe Exception while trying to open TN in 6.1?

  • 1.  Getting Broken Pipe Exception while trying to open TN in 6.1?

    Posted Mon June 18, 2007 08:10 AM

    While trying to open the TN (in 6.1),its giving the error of Broken Pipe exception.The full error is given below:

    Error querying documents: java.sql.SQLException: [wm-cjdbc33-0069][Oracle JDBC Driver]Broken pipe. Original SQL: SELECT
    d.DocID,
    d.DocTimestamp,
    t.TypeName,
    s.CorporationName AS SenderCorp,
    s.OrgUnitName AS SenderUnit,
    r.CorporationName AS ReceiverCorp,
    r.OrgUnitName AS ReceiverUnit,
    d.RoutingStatus,
    d.UserStatus,
    d.NativeID,
    d.GroupID,
    d.ConversationID
    FROM
    BizDocTypeDef t,
    Partner s,
    Partner r,
    BizDoc d
    WHERE
    d.DocTypeID = t.TypeID AND
    d.SenderID = s.PartnerID AND
    d.ReceiverID = r.PartnerID AND
    d.DocTimestamp > {ts ‘2007-06-17 00:00:00.0’} AND
    d.DocTimestamp < {ts ‘2007-06-18 00:00:00.0’}
    ORDER BY d.DocTimestamp DESC
    (0) java.sql.SQLException: [wm-cjdbc33-0069][Oracle JDBC Driver]Broken pipe
    (1) java.sql.SQLException: [wm-cjdbc33-0069][Oracle JDBC Driver]Broken pipe

    Can anyone please suggest a solution for the above problem?


    #webMethods
    #B2B-Integration
    #Integration-Server-and-ESB


  • 2.  RE: Getting Broken Pipe Exception while trying to open TN in 6.1?

    Posted Mon June 18, 2007 06:45 PM

    I had similar error when the TN database was down. test it from the JDBC Pools page.


    #Integration-Server-and-ESB
    #webMethods
    #B2B-Integration