Pushkar Mahamuni

Hello All,
I have below problem
1. In my project we are using ESB (IIB 9.0 Message broker) and IBM HTTP Server.
2. When we are invoking the HTTP server directly through REST Client/ Mozile Firefox , then request is reaching to the HTTP Server and it is proceeding it to WAS server and ESB receivs 200 (Success)as HTTP as response code.
3. But when the ESB is sending the request to the HTTP server it is giving response code as 400 (Bad request)
4. So we have tried to check the access and error logs, then something is shown in the below logs..

Access logs :
HostName 0 - - [13/Aug/2014:07:21:23 +0000] "POST /**/**/BackendURL HTTP/1.1" 200 55 "-" "Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Firefox/31.0" --Request hit from mozile
HostName 0 - - [13/Aug/2014:07:23:22 +0000] "POST /**/**/BackendURL HTTP/1.1" 400 189 "-" "-" --Request hit from ESB

Error logs :
[Wed Aug 13 07:23:23 2014] [error] [client */*/*] ZSRV_MSG0034: HTTP/1.1 request without hostname. URI is /**/**/BackendURL --Request hit from ESB

So question here is IBM HTTP server is not getting some parameter from ESB (IIB 9.0 Message broker) which it is receiving from Mozile browser ?

Hello All,
There is one devloped java code in which the code is interacting with As400 Db and drivers used are JT400(version 8.2). The method used to connect to Db is getjdbctype4connection() ,statement and result set are used to interact DB queries. So is there any possible way to set connection pool size,max wait time for connection through code? if yes then what changes do I need to do in current code?

Hello Guys,
Has anyone gone through the link _http://doctorjw.wordpress.com/2010/05/18/jdbc-and-the-jt400-jar/ which explains that the issue lies with the Database AS400 and the drivers. I have set the socket timeout parameter in mqsiconfigproperties. It is working well. Can someone please throw some more light on the article?

i did telent then it was asking the user id ,password,procedure name. What exactly I need to ask DB admin?

I have pinged the server and getting correct reponse,what else I can try. I am using Jt400.jar version 8.2. If there is issue with Client's firewall setting then how can I proove it?

Flow description: The msgflow is invoked after every 120 second and the JCN inserts or update the data to the table.It was working fine previously,not sure what has haapned. I have commeted the conn() statement as msg broker closes the connection by itself. Below are the details of error

09 Jun 2014 13:58:56,941 INFO [MsgFlowname] Broker excpetion[BIPmsgs:6233]BIP6233E: An error occurred in node: Thread 'Thread[Thread-11,5,main]' There was a problem establishing a connection to the given database URL: jdbc:as400://XXX.XXX.XX;naming=system;prompt=false;transaction isolation=none;user=XXXX;password=xxxxxxxx; Exception details: error message: The application requester cannot establish the connection. (connect timed out), SQLState value: 08001, vendor's error code: -99999, stack trace: [com.ibm.as400.access.JDError.throwSQLException(JDError.java:561)
com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:3342)
com.ibm.as400.access.AS400JDBCDataSource.getConnection(AS400JDBCDataSource.java:720)
com.ibm.as400.access.AS400JDBCDataSource.getConnection(AS400JDBCDataSource.java:693)
com.ibm.as400.access.AS400JDBCXADataSource.getXAConnection(AS400JDBCXADataSource.java:145)
com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection.createXAConnection(JDBCType4Connection.java:244)
com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection.getT4NodeConnection(JDBCType4Connection.java:1242)
com.ibm.broker.jdbctype4.localtrxn.JDBCType4SinglePhaseTrxnHandler.getConnection(JDBCType4SinglePhaseTrxnHandler.java:296)
com.ibm.broker.jdbctype4.localtrxn.JDBCType4SinglePhaseTrxnHandler.getConnection(JDBCType4SinglePhaseTrxnHandler.java:154)
com.ibm.broker.jdbctype4.connfact.JDBCType4ConnectionFactory.getConnection(JDBCType4ConnectionFactory.java:163)
sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:602)
com.ibm.broker.plugin.MbNode.getJDBCType4Connection(MbNode.java:1564)
xx.xxxx.xxxx.JCNMethod(javaMethod.java:46)
com.ibm.broker.javacompute.MbRuntimeJavaComputeNode.evaluate(MbRuntimeJavaComputeNode.java:281)
com.ibm.broker.plugin.MbNode.evaluate(MbNode.java:1480)]

The node was unable to establish a connection to the given database URL.

Contact your IBM Integration Bus administrator. : Problem encountered obtaining JDBC connection 2014-06-09 13:58:41.935

We have a msg flow in which we have used the http input and http reply node. The flow runs with no problem,but sometimes it after giving response the msg again come back to http nodes error or catch node.
any posible reason and possible solutions?

Thanks all for your replies. But it did not solved the problem perfectly.
1.Another problem which I have found whenver the coomunication link failure issue occurs after that the msg flow thead hungs ,so if you any transaction after that it wont respond. So we have to stop and start the Execution group,then only it will work for next transactions.Unfortuanately we can't predict when it can happen.
2. For above problem I have appied the below solution:
Solution: We are using AS400Db and JDBC connection. I came accros the link link _http://doctorjw.wordpress.com/2010/05/18/jdbc-and-the-jt400-jar/., which explians that the issue is with socket timeout and the version of drivers. So currently I have used latest 8.2 version of Jtopen drivers and set the socket timeout parameter in mqsicreateconfigproperites.
3. So how can we do connection pool release in case we came accross stale connection/communication link failure and avoid restarting the Execution group?

I am facing below error. Scenario explained below
1) In the message flow we are receving the JSON request through HttpInput node
2) The Java compute node is checking wether the request is present in the Db or not. If present then update and if not insert.
3) We are testing this component byJava module which inject instruction after every click.
4) To serve above reason we have deployed the 9 additional instances of the flow.Th number connection pool in the configrable property is increaed to 10.
5) As a result of above the first two instruction getting failed and after third request the connection getting estblished and works fine. Below is the error received -->
Communication link failure. (Read timed out), SQLState value: 08S01, vendor's error code: -99999,
6) I tried increasing the flow instances and increasing connection pool size.But No luck.
We are using JDBC Type-4 driver.. Below is the detailed eror log
03 Mar 2014 08:07:03,803 INFO [com.xxxx.customer.createUpdate.XXXX_CUS_SYNCCUSTOMER_TMS] Code: 5000 ResponseMessage : Unable to Connect to the database [BIPmsgs:6233]BIP6233E: An error occurred in node: Broker 'some_broker'; Execution Group 'some exec group'; Message Flow 'com.xxxx.customer.createUpdate.XXXX_CM_SYNCCUSTOMER'; Node 'some_node'; Node Type 'XXXX_CUS_CreateUpdateCustomer_JavaCompute There was a problem establishing a connection to the given database URL: jdbc:as400://xxxxx.xxxx.com;naming=system;prompt=false;transaction isolation=none;user=xxxxxx;password=xxxxxxxx; Exception details: error message: Communication link failure. (Read timed out), SQLState value: 08S01, vendor's error code: -99999, stack trace: [com.ibm.as400.access.JDError.throwSQLException(JDError.java:528)
com.ibm.as400.access.AS400JDBCConnection.sendAndReceive(AS400JDBCConnection.java:2646)
com.ibm.as400.access.AS400JDBCConnection.sendAndReceive(AS400JDBCConnection.java:2559)
com.ibm.as400.access.JDTransactionManager.setAutoCommit(JDTransactionManager.java:539)
com.ibm.as400.access.AS400JDBCConnection.setAutoCommit(AS400JDBCConnection.java:2692)
com.ibm.as400.access.AS400JDBCConnectionHandle.setAutoCommit(AS400JDBCConnectionHandle.java:1108)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:76)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:602)
com.ibm.broker.jdbctype4.connpool.ConnectionPoolWorker.run(ConnectionPoolWorker.java:573)]

The node was unable to establish a connection to the given database URL.

Contact your IBM Integration Bus administrator. : Problem encountered obtaining JDBC connection2014-03-03 08:07:03.569
03 Mar 2014 08:07:12,663 INFO [com.xxxx.customer.createUpdate.XXXX_CUS_SYNCCUSTOMER_TMS] Customer Id : '95743 , Id : 350 , 2014-03-03 08:07:12.663
03 Mar 2014 08:07:12,663 INFO [com.xxxx.customer.createUpdate.XXXX_CUS_SYNCCUSTOMER_TMS] ResponseCode: 5000 ResponseMessage : Unable to Connect to the database [BIPmsgs:6233]BIP6233E: An error occurred in node: Broker 'some_broker'; Execution Group 'some exec group'; Message Flow 'com.xxxx.customer.createUpdate.XXXX_CM_SYNCCUSTOMER'; Node 'some_node'; Node Type 'XXXX_CUS_CreateUpdateCustomer_JavaCompute There was a problem establishing a connection to the given database URL: jdbc:as400://xxxxxx.xxxx.com;naming=system;prompt=false;transaction isolation=none;user=xxxxx;password=xxxxxxxx; Exception details: error message: Communication link failure. (Read timed out), SQLState value: 08S01, vendor's error code: -99999, stack trace: [com.ibm.as400.access.JDError.throwSQLException(JDError.java:528)
com.ibm.as400.access.AS400JDBCConnection.sendAndReceive(AS400JDBCConnection.java:2646)
com.ibm.as400.access.AS400JDBCConnection.sendAndReceive(AS400JDBCConnection.java:2559)
com.ibm.as400.access.JDTransactionManager.setAutoCommit(JDTransactionManager.java:539)
com.ibm.as400.access.AS400JDBCConnection.setAutoCommit(AS400JDBCConnection.java:2692)
com.ibm.as400.access.AS400JDBCConnectionHandle.setAutoCommit(AS400JDBCConnectionHandle.java:1108)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:76)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:602)
com.ibm.broker.jdbctype4.connpool.ConnectionPoolWorker.run(ConnectionPoolWorker.java:573)]

The node was unable to establish a connection to the given database URL.

Contact your IBM Integration Bus administrator. : Problem encountered obtaining JDBC connection2014-03-03 08:07:12.663
03 Mar 2014 08:07:16,866 INFO [com.xxxx.customer.createUpdate.XXXX_CUS_SYNCCUSTOMER_TMS] Customer Id : '95743 , Id : 350 , 2014-03-03 08:07:16.866
03 Mar 2014 08:07:17,335 INFO [com.xxxx.customer.createUpdate.XXXX_CUS_SYNCCUSTOMER_TMS] ResponseCode: 1001 ResponseMessage : Successfull 2014-03-03 08:07:16.866
03 Mar 2014 08:28:58,109 INFO [com.xxxx.customer.createUpdate.XXXX_CUS_SYNCCUSTOMER_TMS] Customer Id : '95743 , Id : 350 , 2014-03-03 08:28:58.109
03 Mar 2014 08:28:58,516 INFO [com.xxxx.customer.createUpdate.XXXX_CUS_SYNCCUSTOMER_TMS] ResponseCode: 1001 ResponseMessage : Successfull 2014-03-03 08:28:58.109
03 Mar 2014 08:50:49,275 INFO [com.xxxx.customer.createUpdate.XXXX_CUS_SYNCCUSTOMER_TMS] Customer Id : '18385 , Id : 110 , 2014-03-03 08:50:49.213
03 Mar 2014 08:50:51,099 INFO [com.xxxx.customer.createUpdate.XXXX_CUS_SYNCCUSTOMER_TMS] ResponseCode: 1001 ResponseMessage : Successfull 2014-03-03 08:50:49.213
03 Mar 2014 08:50:52,658 INFO [com.xxxx.customer.createUpdate.XXXX_CUS_SYNCCUSTOMER_TMS] Customer Id : '18385 , Id : 110 , 2014-03-03 08:50:52.658
03 Mar 2014 08:51:08,506 INFO [com.xxxx.customer.createUpdate.XXXX_CUS_SYNCCUSTOMER_TMS] ResponseCode: 5001ResponseMessage :Communication link failure. (Read timed out) 2014-03-03 08:50:52.658