cancel
Showing results for 
Search instead for 
Did you mean: 

Sender JDBC Adapter Issue.

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

iaki_vila
Active Contributor
0 Kudos

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.

Answers (3)

Answers (3)

Former Member
0 Kudos

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

former_member184720
Active Contributor
0 Kudos

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)

1808222 - Trigger alerts if channel stops polling

praveen_sutra
Active Contributor
0 Kudos

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