on 07-22-2008 11:42 AM
Hi Experts,
I am working on file 2 JDBC scenario, the database table is not updated.What could be the possible troubleshooting steps.
Thanks,
Suresh.
Hi Suresh.
-Check the login details provided in receiver jdbc C.C is correct.
-check the table name in mapping is correct.
-check the data type structure you are declaring the fields are exactly the same as present in database.
-check whether all the drivers have been correctly configured.
Thanks & Regards,
Bharath.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I think you require to check Database Auto-Commit-Enabled in advanced mode of JDBC receiver communication channel parameters.
and
Check the JDBC receiver Communication Channel in RWB.
Regards,
Venu V
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Suresh,
Check the SXMB_MONI .
if the message is processed succesfully then check the Communication Channel Monitoring for JDBC Receiver adapter
Detailed information is present in the Audit log.If any error has occured it is displayed here.
First identify where the error has occured.
Regards
Prasad
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Suresh,
1. Check your target structure have created that properly or not. Like table name is case sensitive.
2. What ever the query you are generating thru mapping, execute the same query on database manuvally and check that the record is inserting into db or not.
3. Is the communication channel is functioning well or any errors are showing. If it is in error try to fix the same.
Cheers
Veera
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
did u check inbound Message in SXI_MONI ????
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.