Primary Key information without having the DB access thru Receiver JDBC Channel

[Former Member]

Hello Experts,

Could you please help me regarding below my query.

In Production Support, I don’t have the DB access and message is failed with unique constraint issue in Java Stack . Here PI is trying to inserting 100’s of records to DB, Hence I could not  able to find out the duplicate value in payload.

My question is, is there any way to find out the Primary Key information without having the DB access thru Receiver JDBC Channel ? if so please address me.

Regards,

Sami.

[Dimitri · Accepted solution]

Hi,

I guess you need to contact your DB admin for this

Kind regards,

Dimitri

[iaki_vila]

Hi Shamiullah,

When i develop a jdbc scenarios, sometime i prepare a SOAP - JDBC to be used only for me in order to can do Select or another operation by myself for maintenance purpose. You can do a mapping that copies the message without modification and in this way you can write in SOAPui all the sentences in SAP XML JDBC format as you want. I always ask to the client about this possibility to improve the issues response time in this kind of scenarios.

Regards.