Home » discuss » Public forums » iMIS Community

Error Message when inserting Activity/ creating invoice from Order

Posted March 31st, 2010 by JCaron
|

This is the message i get when trying to insert a new activity to Manage Committees and when converting an order to an invoice.  I am not sure if this is the proper place to post it or if is is related to the SQL server or something else.
WinIO/63 2627
23000:[Microsoft][ODBC SQL Server dirver] [SQL Server]Violation of PRIMARY KEY contraint ‘pkActivitySEQN’.
Cannot insert duplicate key in object’dbo.Activity’. 01000:[Microsoft][ODBC SQUL Server Driver] [SQUL Server]The statement has been terminated.

‹ Exchange Settings Clarification RequestiMIS Global.asax ›
login or register to post comments | printer friendly version

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

it looks like a Counter table mismatch

On March 31st, 2010 Henry Huey says:

Try running this SQL against your database; the two values should match.

 

SELECT MAX([SEQN]) FROM [Activity]

SELECT [LAST_VALUE] FROM [Counter] WHERE [COUNTER_NAME] = 'Activity'

 

login or register to post comments