JDBC Receiver doesn't work (and doesn't show any error msg)

[Former Member]

Hi all,

I'm now trying to test a file to JDBC scenario. After many msgs sent, I'm checking at sxmb_moni and the file sender is ok, the msg mapping is ok, and the JDBC receiver is ok - the status is "processed successfully".

But... in my database (Oracle9i), the row I tried to insert is not there. No error message and no data inserted in database... I read many posts here about the constring, and I have already tried with all constrings suggested... Can anyone suggest me what can I do to try to discover what is wrong?

thanks!

roberti

[moorthy · Accepted solution]

HI,

Did you check RWB->Message Monitoring->message Display Tool->Audit Log ? If not have look into that.

Also check the JDBC adapter monitoring

If not able to find the error, then check in the Visual Admin->Log viewer and check the status.

Hope this helps to analyse the errors.

Regards,

Moorthy

[Former Member · Accepted solution]

Thanks Krishna!

I found it at RWB (after mutch work!

The path is not exactly the same as yours, I think because de WAS version (ours is 7.00), but i find the problem in the audit log.

thanks again for your help!

cheers!

roberti