MQSeries.net :: View topic - Failure of messages with ORACLE database problem

gnan

Hi,

We are having a problem related to "Maximum No. of Sessions has been reached" with the External ORACLE Database from a Message Flow. The Transaction Mode is set to the following default values.

Input Node -> Yes
Compute Node -> Automatic
Output Node -> Automatic

We are having this problem with the database around 30 min. The database has been restarted after increasing the maximum no. of sessions. The first message which is failed has to update that external database. And surprisingly all the messages recieved after this are also failed even though they uses different sub flows which do not interact with the database.

What coud be the reason for the failure of the messages which do not interact with the database in that 30 min. span of database problem?

OS is HP-UX

Thanks