on 05-25-2007 9:46 AM
hi all
At a client side i am required to configure IDOC - JDBC scenario.
i.e my scenario is :
as soon as master data at R/3 side will be created / updated , IDOC will be triggered and will be passed to XI. XI will create this master data in the clients ORACLE database.
I am trying to anayze all the possible runtime errors that meight occur while running this scenario live , so that i can handle them using alerts ,
Few errors that i know are
- database shutdown - no reciver found
- The record already present at oracle
- error in mapping
please suggest me all such more errors .
Regards
Sheetal
I check the following OSS note
<a href="https://service.sap.com/sap/support/notes/831162">831162</a>
for more possible errors
regards
krishna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
See the SAPNote : JDBC Adapter: Note 831162 for JDBC errors and (around 25 qs and ans) solutions given by SAP.
Regards
Chilla
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sheetal ,
List of possible JDBC adapter errors
1>You will get error if you specified incorrect data type ( i. e you specify action as element instead of specifiying as attribute .
2> The connection string is not properly defined ( i,.e connection type is not specified as cluster )
3> In case of insert you can get primary key violation error if you try to insert duplicate
4>Also in case of insert/update if pass incorrect data type of or data of longer length than what is specified in DB you will get data truncation error .
5> In case of update stmt if your table has got composite primary key then you should specify all the fields which forms a coposite key under Key section in your inbound data type .
Thanks ,
Suvarna
Pls award pts if you find this answer userful which will motivate me to answer your further queries .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Below are few common errors while working with JDBC:
1. Error: Accessing database connection
2. 'jdbc:microsoft:sqlserver://<ip add>:1433;DatabaseName=XXXXX;' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://<ip add>:1433;DatabaseName=XXXXX;':
3. SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot open database requested in login 'vendor'. Login fails.
4. If there is any typo error in the path.
5. SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
Regards,
Subhasha Ranjan
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.