***JDBC ADAPTER

[Former Member]

Hello Experts,

The secenario is JDBC(PP)--XI---IDOC(SAP) in Prod environment.

The problem is that the DATA is sent from PP is not received by XI ,We asked to check if the data is send as per the SQL Select and Update Statements.When verified we found 2 records to be valid andshould create 2 Idocs.But This is not happening.Thsi scenario ran sucessfully till 12/21.we checked the RWB->component Monitor->AE->CC monitor,There are no errors seen here,The message here is "Process Started" since 22/12,Checked message monitor,there are no messages or errors related to this interface.

We replicated the same in the QA enviroment and found that 2 Idocs are created in SAP

Can Any one throw light ,what needs to be done?

Thanks,

Srinivasa

.

[Former Member · Accepted solution]

Hi,

Have you tried after stopping and starting the Sender CC in RWB. Make sure there were no changes made recently at your side firewall settings or at JDBC side.

Regards,

Sarvesh

[Former Member · Accepted solution]

Yes I stopped the CC and restarted it.There were no changes made in XI side and People from JDBC side also confirmed that there are no changes made from their end.

If it is the issue with firewalls why did the scenario ran in QA,also other JDBC scenarios in Prod are working fine.

[former_member181985 · Accepted solution]

May be JDBC adapter is locked.

check this thread: [|]

Regds,

Praveen

[Former Member · Accepted solution]

Yeh that's tue if other JDBC interfaces are working fine then it is not a firewall problem. I hope by this time must have tried with refreshing the cache too. Try make some dummy change in your CC and then try.

[prateek · Accepted solution]

Goto Visual Admin -> Service -> JDBC service. Restart this service and the problem should be solved.

Regards,

Prateek

[Former Member · Accepted solution]

Hello Srinivas,

Is the issue still pending? (I mean , did JDBC adapter pulls the data from database or not). Please provide the information of the Channel Monitoring page(about the JDBC channels which are not pulling the data from the database). what is the state of those channels? If they are in "Processing Started" for long time then check the Locking Adapter service in VisualAdministrator(for PI 7.0) or else looking into same service in NWA.

There could be locking issue occured. To overcome this, remove/delete the locks that are visible in this service. For root cause analysis, look into the thread dumps. Mostly the problem with the hanging situation(where lock will be acquired by one of the JDBC threads and got stuck at some place either in the network or driver level). So check the problem at network level or driver level. Hope this information solves your problem.

Regards,

Soorya.

[Former Member]

Potharaju ,

1. Can you see the records in RWB using logSQL statement ?

2. hope your trace level is 3 .

3. what is your transaction isolation ?

Regards ,

[Former Member]

Hello Santosh,

The use of logSQLStatement at sender doesnt have any effect. It is useful only in the receiver side processing. The basic functionality of that parameter is to get the SQL statement out of the input XML file after parsing. As the SQL statements(SELECT & UPDATE) are already provided in the sender JDBC channel, you can get that information from the configuration itself.

regards,

Soorya

[Former Member]

Hi,

Refresh the cache once again . once you finish your settings.

with regards,

Surya

[sunil_singh13]

Hi Srini,

Can u ask u r Basis to ping to the JDBC server from the XI server using Telnet <Ip Address of Databse Server> <Port> if they are able to connect (need to be done by OS level logging of XI Server) , It will make sure that there is no firewall related problem.

If it working fine in Quality u can Migrate the whole scenario once again to Production.

Thanks,

Sunil Singh