RockHouse
Technical User
- Apr 26, 2013
- 11
I am re-opening a restaurant with an existing Micros 3700 system. I would like to get rid of the old menu items.. When I attempt to delete a menu item I get the following error:
Key Violation. [Sybase][ODBCdriver][Adaptive Server Anywhere][Integrity constrant violation]Primary key for Row in Table'mi_def' is General SQL error. referenced in another table.
I read in another post of this forum ( that I am getting the error because I need to purge the sales for the old menu items. So I followed the instructions I found in another post
( and tried to create a puging autosequence.
When I run the autosequence, I get the following error after about 10 minutes, and I still cannot delete the menu items...
---- STARTING - PURGE HISTORICALS
==============================================
Sequence # 10001 Step # 1 <STORED PROCEDURE>
Purge Historical Totals
Sequence # 10001 Step # 1 Stored Procedure Step Error.
Error executing stored procedure.
==============================================
---- DID NOT COMPLETE ----
Thank You
Key Violation. [Sybase][ODBCdriver][Adaptive Server Anywhere][Integrity constrant violation]Primary key for Row in Table'mi_def' is General SQL error. referenced in another table.
I read in another post of this forum ( that I am getting the error because I need to purge the sales for the old menu items. So I followed the instructions I found in another post
( and tried to create a puging autosequence.
When I run the autosequence, I get the following error after about 10 minutes, and I still cannot delete the menu items...
---- STARTING - PURGE HISTORICALS
==============================================
Sequence # 10001 Step # 1 <STORED PROCEDURE>
Purge Historical Totals
Sequence # 10001 Step # 1 Stored Procedure Step Error.
Error executing stored procedure.
==============================================
---- DID NOT COMPLETE ----
Thank You