rec JDBC - data not inserted to DB

[Former Member]

Hi,

In Proxy to JDBC scenario, data is not inserted to DB (Sqlserver).

From proxy, xi could able to get data; in moni it is showing success flag. But data is not inserted to DB. Connectivity is there from XI to DB.

We are using SP to insert the data.

When checking in Message monitoring, it is showing as success but when checking in CC monitoring, the channel status is showing as Functioning. No other data is provided.

Please share your ideas where it went wrong.

Regards,

Anil.

[Former Member]

HI Satish,

I am also working proxy-xi-jdbc scenarios.But our interface are working fine.U need to check some steps.

1) instead of SP ,u can use UPDATE_insert.

2) Check in ques (SMQ1 and SMQ2).

3)Check the permisition from Database administrator.

4)Cancel the system errormessages from message monitoring.

Thanks

Ravi

[Former Member]

Hi

Ur target structure should be like this for SP - Is it the same?

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

http://help.sap.com/saphelp_erp2004/helpdata/en/d2/bab440c97f3716e10000000a155106/frameset.htm

Use asinput and type

Instead of SP u can directly use the INSERT action and table name which will also serve the same purpose.

chirag

[Former Member]

Hi,

Also Check the messaging system level..if there are any details for your message id...

go to http://host:port/MessagingSystem/ ...

Check if the audit logs of your message id...

HTH

Rajesh

[Former Member]

hi,

in RWB, in Message Monitoring, just check under option integration engine what error it is showing.

reg,