Data is not updating in DB Table

[Former Member]

Hi...All

we have done the RFC-JDBC Synchronous scenario, we are getting the success messages into SXMB_MONI ,in the CCM also it was showing success. but data is not updating in to the Database Table. client want to see the response data in the Database Table only.

pls help me this is very urgent.

Regards,

Pasi.

[Former Member · Accepted solution]

Hi,

If everything is working fine in XI there is some problem in database end only while query gets executed. Try debuging the sql query which you have by giving log statement and see what the query generated is.

Got to your receiver jdbc communication chalnnel , Advance mode > Additional parameters,

Enter logSQLStatement in the name column and true in the value column

To view the SQL log Click on the message ID of the communication channel monitoring.

or, alternatively, in Runtime workbench, click your message> details> audit log tab.

Run the interface once more. Check the communication channel now. It will show the actual insert statement which is trying to insert into the DB and then you can figure out what is the query being fired to database and see if it is fine.

Copy the same query and run in databse. you will be able to find the exact problem.

thanks

amit

reward point if answer is useful

[Former Member]

Hi,

Rather checking CCM, check Message Monitoring in RWB and see if you have successfully send the data to your target system or it's gone into system error, waiting, holding etc...

if you found everything ok in message monitoring then check once again in you mapping that you have given table name as it is (case sensitive) as in database. aslso check if your target structure is in correct format see the below blog for correct target structure.

Regards,

Sarvesh

[Former Member]

Hi evrybody !

i want to know how to get the exact number of the updating datas in a specific table after having done an UPDATE in the abap specific program .

Is there any abap system variable that contains this value?

Thank you.

[rodrigoalejandro_pertierr]

hi,

go to RWB-- component monitoring-->communication channel monitoring --> check if there any error in CC.

thanks

Rodrigo

PS: Reward points if useful