What meaning are the "Error 1 on update, insert or delete done" and the "Error 16 on inserting row."

book

Article ID: 40170

calendar_today

Updated On:

Products

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Question:

The following 2 errors returned when the below command was ran against the usp_lrel_attachments_requests table to load the data.

Command :

pdm_load -i -v -f <filename>


Error :

Error 1 on update, insert or delete done.
Error 16 on inserting row.
The inserted row conflicts with existing data.

The stdlog says as follows
Duplicate row. ORA: 1  Message: ORA-00001: unique constraint (MDBADMIN.USP_LREL_ATTACHMENTS_REQUES_X3) violated

 

What do the above "Error 1" and "Error 16" mean?

 

Answer:

The attmnt and the cr columns are key of the usp_lrel_attachemnts_request table. They are configured in the SQL Server Management Studio -> dbo.usp_lrel_attachmetns_requests -> indexes -> usp_lrel_attachments_requests_X3.

Since it tried to load the duplicated key record, the error was occurred.


The "Error 16" was returned when the record that has the duplicated key.
The "Error 1" was returned because the Error 16 occurred. Error 1 will be indicated when the Error 16 was returned.

Environment

Release: SDMU0M99000-14.1-Service Desk Manager-Full License
Component: