on 02-05-2008 6:35 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
check with your select query in JDBC adapter.
Try to execute same query on corresponding database if at all you have access
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.