on 04-13-2010 4:10 AM
Hi Experts,
we have proxy to JDBC synchronous scenario, currently the messages are sitting in delivering status for long time.
SAP Note 1078420 - based on this note i need to configure the following parameters
driver:oracle.jdbc.ReadTimeout 1000
driver:oracle.net.CONNECT_TIMEOUT 1000
sqlquerytimeout
these parameters for Oracle, i am connecting to MSSQL2005 so can anyone please tell me what are the parameters for MSSQL2005 ????
Kind Regards,
kwangmo ku
Hi,
We havent seen mentioned parameter working & their behaviour is strange.
One parameter which is supported by JDBC adapter for all DB is taskTimeout. Its value is in milliseconds & it works for both sender & receiver JDBC adapter.
Regards
Sushil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Flok,
Check the queues using transactions SMQ1 (outbound)/SMQ2 (inbound). Resolve the displayed errors. You can cancel the messages from SXMB_MONI. Execute LUW if necessary and avoid deleting entries manually.
Regards,
Ravi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Can u pls check in Queues(SMQ2).If u find any thing in queues u have to activate/delete it.
Thanks
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.