JDBC Communication Channel locked!!

[former_member745782]

hello everybody!

i have a terrible problem

In my PI 7.0 i have some interface jdbc (oracle)->PI->SAP

Sometimes database Oracle crash and we need restart server.

When appen this situation the Ccomunication Channell tstill locked.

We tried to stop and start CC from CC monitor and we tried to modify (description) CC config and activate it.

But no result.

We always need to create a copy of CC and use it.

Customer is not happy about this situation!

someone know where is the problem? and where is solution?

thanks

Alex

[former_member200962 · Accepted solution]

Check this note....this is a manual task and has to be done each time the channel/ adapter is locked: 1083488

Disconnect from Database After Processing Each Message option needs to be used carefully.....as it may degrade the performance.

Regards,

Abhishek.

[former_member745782 · Accepted solution]

ok i try

thanks!

[former_member745782 · Accepted solution]

i'm sorry but i write wrong version of PI.

We are working with 7.1 and not 7.0.

Note 1083488 it's only valid until version 7.0

:(((((

[rodrigoalejandro_pertierr · Accepted solution]

Hi

as mentioned above, select the property Disconnect From DataBase After Processing Each Message", you can found if in the Advance tab-->Advance Mode in your sender Communication Channel.

Take in mind if you pool to the data base with small range of time, the performance will be affected.

Thank

RP

[Shabarish_Nair]

try using the option Disconnect from Database After Processing Each Message in you Sender CC.

This will ensure that it will create a new connection every polling interval.