cancel
Showing results for 
Search instead for 
Did you mean: 

DB table not updated

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (5)

Answers (5)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

hi suresh

check whether you have given correct DATABASE table name or not

also check this threads

<removed by moderator>

regards

kummari

Edited by: Mike Pokraka on Jul 24, 2008 1:07 PM

Former Member
0 Kudos

did u check inbound Message in SXI_MONI ????