on 05-23-2007 12:28 PM
Scenario: JDBC - XI - R3
I am using select query to pick up the data from database, but i am not updating the database through sender JDBC adapter. Database is updated once proper response from R/3 is received. Polling interval is very high. Still JDBC is picking up the records many times. Could anyone provide the reason for that
Thanks,
Greg
Hi,
General Solution for this is to use temp database table and delete content after sending data (since in many cases you can't add update flag into database tables).
You can use triggers for replicating data in this new database table and in sender JDBC adapter after selecting record simply delete data from table.
Aslo do the transaction handling to make sure integrity of data.
Regards,
Gourav
Message was edited by:
Gourav Khare
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Greg,
Could you brief your JDBC Sender channel configuration?
Thanks,
Beena
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
PLZ CLEAR 1 DOUBT
JDBC sender
polling interval - 24hrs
after select query if i dont update it at that time, how many msgs in sxmb_moni, will i get??/
Right now i am getting around 100 messages with same payload
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- It depends on everytime you start/activate communication channel.
for example you changed something in communication channel and then restarted then it will poll database again (in this communication channel won't remember when last time it polled database).
Same situation is in case of stop/start of communication channel.
Just check in visual admin that you have only a single instance of J2EE nodes active.
This might solve the prob
Mudit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
See in general,
Select query is used to pick up the data / execute the query and to avoid the second time execution of the set of records we have an option to update the table with some field change the flag to 0 1 or similar kind of flag..
so does your database table has this field??
check inthis manner and check the query is picking the correct result set or not..
also see below
Q: After configuring a large amount of JDBC Adapter sender channels, the J2EE Engine becomes very slow and some services start to block. How can I solve this issue?
A: Up to and including XI 3.0 SP13 each JDBC Adapter sender channel permanently consumes a J2EE application thread. To solve this issue, increase the number of configured J2EE application threads using the SAP J2EE Engine Config Tool ("cluster-data" -> "Global server configuration" -> "managers" -> "ApplicationThreadManager" -> "MaxThreadCount").
Starting with XI 3.0 SP14 application threads are allocated on demand by the JDBC Adapter and returned to the thread pool after it has finished the polling sequence, so thread shortage situations will typically occur much more rarely than with earlier SPs.
Regards
Chilla
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>>I am using select query to pick up the data from database, but i am not updating the database through sender JDBC adapter. Database is updated once proper response from R/3 is received.
Are you using a BPM here? Is the data base getting updated from the BPM?
I fear this is not happening, check the Communication channel monitoring, if you are not finding any errors in SXMB_MONI.
Regards,
Jai Shankar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
><i>Database is updated once proper response from R/3 is received.</i>
How is this being done?
Regards
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
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.