September 20, 2010 at 6:24 am
We upgraded to a new version of our ERP software and the new version added 'Menu Config' tables. In order to speed up the 'Go Live' I had run the app before and added the records into the tables in a Test version of the data, then, during the switch over ran SQL statements to create output 'INSERT into menu_config_header...' for each of the records. After updating the database I ran the saved output statements to insert the records. All seemed to work OK.
Now, when I run the ERP software app to add a new Menu Config (record) I get an error:
Here's the Error Message:
Microsoft SQL Server:2627[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_menu_config_header'. Cannot insert duplicate key in object 'dbo.menu_config_head
Here's the SQL Statement:
insert into menu_config_header ( menu_config_id, menu_config_name, is_deleted ) values ( :nNextMenuConfigID, :sMenuConfigName, 'N' )
In SSMS I have drilled down to the indexes and clicked to Rebuild the PK... index. Still get the error message.
Help. :w00t:
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
September 20, 2010 at 7:54 am
I found information about Reseed a SQL Servier identity column.
In a query window:
DBCC CHECKIDENT
(
menu_config_header
, RESEED
)
I ran this and tried adding using the application - got the same error message.
Dang! I was hoping this would resolve the issue.
Still looking for help.
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
September 20, 2010 at 8:01 am
CORRECTION - I just scrutinized the table and noticed menu_config_id is NOT an Identity!
Any suggestions where to look for the 'seed value' the app is using?
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
September 20, 2010 at 9:33 am
EdA ROC (9/20/2010)
CORRECTION - I just scrutinized the table and noticed menu_config_id is NOT an Identity!Any suggestions where to look for the 'seed value' the app is using?
I would call the vendor and research vendor's KB if they have one.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.September 20, 2010 at 11:00 am
I would call the vendor and research vendor's KB if they have one.
Thanks. There isn't much in their KB, no hits. I have a call into their support - they don't always respond in a timely manner, so, I posted here to see if I could get a quicker solution.
I saw a reference to pk_dtproperties and I've been poking around trying to view what's in there. No success yet, I don't know how to burrow into that part of the realm.
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
September 20, 2010 at 2:44 pm
Have you validated that the variable, :nNextMenuConfigID is being incremented when you run the insert statement?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 20, 2010 at 2:55 pm
Issue Resolved: Customer Support got back to us and informed us about a table of 'counters' (all those Next Numbers). We updated the value and everything is OK.
Thank you everyone for your help. Appreciate it.
[font="Verdana"]"The Road To Success Is Always Under Construction."[/font]
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy