on 06-07-2010 3:14 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.