Record not saved error in SQL Server

Asked By homer briones 10 points N/A Posted on - 02/26/2012

Hi, I keep getting this error when I try to save an Incident. 

This comes up every time I click on “Save”, whether I did update any field or not.

Though I don’t think it’s a BR, I’d appreciate if you can give me an easy way to disable all BR’s so I can be sure it’s not one.  I’m thinking that SDE is trying to write a row that contains a sequence that is already in the _SMDBA_._TELDETAI_ table. Then again, I’m not quite sure.  Hope you can help.

Error:

VBScript:BMC Service Desk Express

(1000) Record Not Saved:This was most likely caused by one of the following:

1.Attempting to create a record with an existing ID.

2.A required field has been placed on the form through form customization.

[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK TELDETAI'.Cannot insert duplicate key in object 'SMDBA.TELDETAI'. 

• Status: Open
• Question Views: 1299
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Michelle Bang 55 points N/A #100391

Record not saved error in SQL Server

The cause of the error is written in the error itself. If you can look closely, there are two reasons that you might have done wrong that is causing this issue.

1. Seeing the first type of error, go to your database and the respective table.
2. Open the table and see if there is any matching ID to something that you are trying to create at the run time or any trigger is trying to create an ID which is already made in the database.
3. Come to the second error.
4. Clear all the checks from the attributes now start putting the checks one by one.
5. First put one check, save the table, run it.
6. No errors, move on to second check. Keep doing it until you get to the point which is causing the issue.

About Michelle Bang

Questions
2

Answers
515

Best Answers
73

• Vote Up 0 Vote Down

• Posted on - 03/12/2012
• Question Category: MS SQL Server