JDBC Sender Adapter - NOT FETCHING RECORDS -PROCESSING STARTED

[Former Member]

Hello all,

I have set up a JDBC sender adapter .With polling interval as 30 Seconds. Polling is done successfully

but it does not fetch the records .

Valid Data is present in the tables.In the Communication Channel Monitoring log shows :

"Processing Started"

after each poll interval.

Adding to this , it was working fine with the same parameters two days back.

I have enabled the Driver Trace but didnot get any information from Trace.

How to resolve this issue?Any help

Regards

Ganga Prasad

[Former Member]

Hi,

As you mentioned 2 days back it was working fine and now it does not...so better to look for this options:-

1. Check the connectivity of XI with Database.

2. Check the authorization

3. Check the Select querry..also try to run the same in the DB

4. Check th status in SXMB_MONI....some time its happen RWB shows results after dealy.

5. At last try to make the adapter inactive and activate it..then again make it active and activate it.

6. Do the adapter cache refresh.

thanks

Farooq.

[Former Member]

Hello Farooq,

Thanks i have checked all the steps u specified all are fine.

I got a not may be it is because of Adapter getting Locked.Iam checking out

My problem got resolved .It was because the JDBC adapter got locked.

I have checked in the Visual Admin >Cluster> "LOCKING ADAPTER"

we get a option of Display Locks .Check for an entry with

NAME : $XIDBAD.JDBC2XI

reset the locks and restart the CC ,now it works fine.

Note 1083488 - XI FTP/JDBC sender channel stop polling indefinitely(04/04S)

regards

prasad

Edited by: prasad chintala on Feb 5, 2008 9:23 AM

[Former Member]

great and thanks for sharing important information

[Former Member]

Hi Ganga Prasad,

I am facing a similar kind of problem.Can u please tell me how can i restart the CC for an file adapter.

Thanks,

Sudhansu

[chitti_prakash]

Hi Sudhansu,

To stop the File Adapter CC, please go to RWB and monitor the spefic channel and perform the admin action i.e., stopping the channel and starting the channel manually. this will help you.

For File adapter also please follow the same SAP Note no 1083488 - XI FTP/JDBC sender channel stop polling indefinitely(04/04S).

Hope this information will help you in solving your problem.

Regards,

Soorya

[Former Member]

Hi Prasad,

May be there is no data which is changed/ New.

May be there is no record to fetch.

Check with u database & update query........... Try with simple Query for test.

Thanks,

Maheshwari.

[Former Member]

Hello maheshwari,

Valid Data is there & many records are there to be fetched.

One more thing Normally in the Communication Channel Monitoring

for an JDBC adapter even if there are no records to fetch we get the Log information in detail that :

Polling interval started.

Processing finished successfully

Processing started

Polling interval started.

Processing finished successfully

Processing started

But here in my case am getting only : (polling interval : is 60 Seconds)

2/5/08 8:29:19 AM Processing started

2/5/08 8:28:19 AM Processing started

2/4/08 3:34:54 PM Processing started

2/4/08 3:33:54 PM Processing started

One more observation is that my poll interval is 60 seconds but now it is polling after every 120sec

2/5/08 11:17:31 AM Processing started

2/5/08 11:15:31 AM Processing started

2/5/08 11:13:31 AM Processing started

2/5/08 11:11:31 AM Processing started

I have tried refreshing Cache but no change .

Regards

Prasad

[Former Member]

check with your select query in JDBC adapter.

Try to execute same query on corresponding database if at all you have access

[Former Member]

Hello Mugdha,

Thanks for reply.

Yes, Query works fine and fetches the data.

Regards

Prasad

[Former Member]

Hi,

Check some links on JDBC,it may help u out.

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 - File to JDBC

JDBC - http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

multiple tables with JDBC - http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

JDBC Response /people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous

JDBC RECEIVER ADAPTER

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

Regards,

Phani

Reward points if helpful