Skip to Main Content
Forums

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Time Out Error while waiting for response from DB Procedure

832350Jun 9 2011 — edited Jul 7 2011
Hi Gurus,

We are encountering a problem in our production environment. The system is implemented using AIA foundation pack 2.5 on SOA suite 10.1.3.4.

We have a BPEL process A which calls an ESB Service which inturn calls BPEL Process B. In process B, we have a DB procedure call which waits for a response from
a DB procedure. The procedure doesn't reply on time and Process B remains in waiting state to get the response from DB Procedure wherein Process A errors out by showing as "Timed Out Error".

This issue is intermittent and we have already increased transaction-time outs in transaction-manager.xml to 7200 and ejb-orion-jar.xml to 3600.

When we encountered this problem, we found out that there are too many connections open and when we bounced the server, everything was restored to nornal but as it is a production env. we can't do it over and over again.

We have 2 nodes each having max connections as 100 and min. as 0.

Is there a limit to max no. of connections or can we do something in DB side to ensure that it doesn't happen again ?

Please suggest.

Thanks,
Vikas Manchanda

Comments

843830
Refer to csqzaw05.pdf of Documentation set of MQSeries.
843830
Hi joecherian

Which implementation of JMS are you using..? That would help me answer you probably because I have once integrated MQSeries 5.2 with a JMS provider.

thanks
Bob
843830
Hi
I am using MQSeries 5.2 and i am using IBM java classes for JMS
843830
Hi..

I have integrated FioranoMQ recently with MQSeries using their Bridge support, if you need information on that, I can let you know. I am unfamiliar with IBM java classes.
As far as other vendors are concerned, I dont think Nirvana has support for this, and am unaware of other vendors

thanks
Bob
843830
Did you read csqzaw05.pdf. It should explain everything you need. Are you still having a problem? The chances are its a configuration in the jmsadmin.config file - this duplicates the functionality of a jndi.properties file - it tells the jmsadmin.bat file where your jndi implementation is, what classes to use etc etc.
843830
Hello.

thanks for ur help.. if you come across anyone who is well versed in IBM java classes for MQSeries application , do refer him to me as i am in urgent need of such a person for clarifuing my doubts..
843830
Hi Joe,
i would suggest you that instead of going through the complex java classes support of MQSeries, you better use the JMS wrapper for MQSeries. If you do not use JMS Wrapper, you are losing the main benefits that JMS is providing. The simple API and the platform(or vendor) independence it provides is really great. You just have to install the JMS Wrapper which comes in the installation package of WebsphereMQ 5.3. and then you can go to its JMS administration shell called "JMSAdmin" to create the administered objects. For publish subscribe support you will need to install a broker. And all will be ready for you. So, best of luck with using the JMS above MQSeries.
cheers and regards,
Anurag Parashar
Pramati Technologies.
843830
Hi Joe,
IBM\WebSphere MQ\Java\bin\JMSAdmin.config file has some entries which you need to edit before you start JMSAdmin.bat to make the JMSAdmin get connected with any Naming service i.e. LDAP or any one you have. If any exception is coming starting JMSAdmin, try connecting the naming service with the same properties through a standalone java client.

after that there are some commands with which you have to bind the administered object and there you will be ready to use the jms samples provided along with it.

these articles may be of a great help to you
http://www-106.ibm.com/developerworks/ibm/library/it-farrell1/index.html

http://www-106.ibm.com/developerworks/ibm/library/it-farrell2/index.html

Anurag Parashar
Pramati Technologies

843830
Hi,
I am planning to use JMS with Websphere 4..04,AIX 5.1,MQSeries 5.2 to get a XA(2PC) commit. Right now I am using only a single machine having Websphere 4.0.4.I am in the testing mode.
My Production system has 2 machines servers but doesnt have LDAP configured on the Production.Can I use the JMS Resources like Destinations etc in a system which doesnt have LDAP or LDAP is a necessary
1 - 9
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 4 2011
Added on Jun 9 2011
#soa-process-management, #soa-suite-discusssions
6 comments
3,610 views