on 01-23-2014 10:27 AM
Hi Experts,
We have created an interface by using JDBC adapter.
Scenario is SS to PI(7.31) to ECC.
Where the PI will fetch the data from SS (Scheduling System it is Database system) by using Select and Update query for every 180 sec.
This interface is working fine.
But sometimes interface struck in production system and showing as processing started with
Green and not completing the processing finished successfully and not fetching data from SS.
And I have stopped and started the Channel and it is working fine later.
What may be the issue and how can we avoid this kind of issue in future.
Please suggest.
Thanks,
Rathan.
HI Rathan
This is a known issue and there isn't a unique solution, you should read carefully the suggestions in this SAP article 1666377 - Workaround for File/JDBC/Mail Adapter not polling
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
Goto rwb -> Component Monitoring -> Adapter Engine -> Engine Status (Under status tab)
Under additional tab check if all thread getting consumed under JDBC abapter.If yes increase the Configuring consumer threads for JDBC adapter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rathan- May be you can try with the below setting which works sometimes.
under the advanced mode, enable the option for -
Disconnect from Database After Processing Each Message
https://scn.sap.com/thread/1492086
However have a look at the below note which may not fix your issue but i hope it helps in notifying about it. (avoids manual monitoring)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Sekhar,
Not sure about any one solution. But hope the below blog might helps
https://scn.sap.com/thread/2054803
thanks and regards,
Praveen T
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.