JDBC Receiver Could not execute statement

[former_member650236]

Hi Experts,

Currently am working on Production support getting below error when monitoring in RWB.

Can anyone help me how to avoid this type of system errors.

Could not execute statement for table/stored proc. "Reciept_Master" (structure "StatementName1") due to com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__Reciept_Master'. Cannot insert duplicate key in object 'dbo.Reciept_Master'. The duplicate key value is (155150091585).

JDBC Message processing failed, due to Error processing request in sax parser: Error when executing statement for table/stored proc. 'Reciept_Master' (structure 'StatementName1'): com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__Reciept_Master'. Cannot insert duplicate key in object 'dbo.Reciept_Master'. The duplicate key value is (155150091585).

Any help would be appreciated.

Regards,

Shaik

[azharshaikh · Accepted solution]

Hi Shaik,

Seems you are trying to post data with same primary key value..155150091585

There might already an entry with this value..Please check DB and ask the sender to resend data with correct values

Regards,

Azhar

[former_member650236 · Accepted solution]

Hi Azhar,

Not only with one value am getting.please see below am getting with different value number.

Could not execute statement for table/stored proc. "Reciept_Master" (structure "StatementName1") due to com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK__Reciept_Master'. Cannot insert duplicate key in object 'dbo.Reciept_Master'. The duplicate key value is (155150091583).

I need to inform the DB team or the user who is inserting the number is an duplicate value ? what is the next step i need to take.

Regards,

Shaik

[azharshaikh · Accepted solution]

Yes, please check with DB team if these values already exists in DB & inform the sender to post valid data

[vishnu_pallamreddy]

Hi Valli,

Please check the DB whether you mentioned values are all ready exists in DB table/SP or not?

[Former Member]

And the field is I guess "Receipt_Master"

[Former Member]

Hello Shaik,

In your stored procedure, there is an insert/update statement which is feeding duplicate value for one of your primary keys of the SQL table at the receiver end.

Regards,

Souvik