Unable to execute stmnt for table or stored procedure. ORA-00001: unique constraint (a_PK) violated

[asangidevaraj]

Unable to execute statement for table or stored procedure. SAP_Import_Material (Structure StatementName3) due to java.sql.SQLException: ORA-00001: unique constraint (LINCAPP.SAPIMTL_PK) violated

JDBC message processing failed; reason Error processing request in sax parser: Error when executing statement for table/stored proc. SAP_Import_Material (structure StatementName3): java.sql.SQLException: ORA-00001: unique constraint (LINCAPP.SAPIMTL_PK) violated

MP: exception caught with cause com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. SAP_Import_Material (structure StatementName3): java.sql.SQLException: ORA-00001: unique constraint (LINCAPP.SAPIMTL_PK) violated

Exception caught by adapter framework: Error processing request in sax parser: Error when executing statement for table/stored proc. SAP_Import_Material (structure StatementName3): java.sql.SQLException: ORA-00001: unique constraint (LINCAPP.SAPIMTL_PK) violated

[jerryjanda]

Welcome to the SAP Community! Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Second, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

Now for some specific suggestions on how you might improve your question:

* Outline what steps you took to find answers (and why they weren't helpful) -- so members don't make suggestions that you've already tried.

* Share screenshots of what you've seen/done, as images always helps our members better understand your problem.

* Make sure you've applied the appropriate tags -- because if you don't apply the correct tags, the right experts won't see your question to answer it.

Should you wish, you can revise your question by selecting Actions, then Edit.

The more details you provide, the more likely it is that members will be able to respond. As it stands, I believe you've chosen the wrong tag, and I'm not sure if members will understand what you're asking. So please consider revising your question because I'd really like to see you get a solution to your problem!

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

Kind regards,

--Jerry

[JamesZ]

ORA-00001 means duplicate violated, means we want to insert and update the same key, and the key values already in database.
Using dba_constraints.table_name, and dba_constraints.constraint_name could find the table involved.
If you know the sql statement that caused ORA-00001, then it is better.