RE: HELP: Error MSSQL and ACID

["Michael Steele" <michaels () winsnort com>]

John,

It looks like its trying to insert a key that has already been inserted. I
don't know much about MSSQL but you might try either removing or renaming
that key. Backup your database prior to altering.

If you are not sure how then do a search on Google.

Found This:

You can run DBCC CHECKIDENT to correct this error. This error sometimes
occurs when you insert new rows.

This is the description of DBCC CHECKIDENT from the SQL Server 6.5 BOL:

DBCC CHECKIDENT [(table_name)] Checks the current identity value and
compares it with the maximum value in the identity column. If the current
identity value is invalid, it will be reset using the maximum value in the
identity column. Invalid identity information can cause SQL Server message
2627 when a PRIMARY KEY or UNIQUEKEY constraint exists on an identity
column.


You can make stored procedure, which will check the identity field and make
this sp as startup (by using the sp_makestartup stored procedure). This is
the test example:

use master
go
CREATE PROCEDURE sp_checkident AS
EXEC ('use pubs       
DBCC CHECKIDENT (jobs)')
go
sp_makestartup sp_checkident
go
 

Kindest regards,
Michael...

WINSNORT.com Management Team Member
--
Pick up your FREE Windows or UNIX Snort installation guides      
mailto:support () winsnort com
Website: http://www.winsnort.com
Snort: Open Source Network IDS - http://www.snort.org

________________________________________
From: snort-users-admin () lists sourceforge net
[mailto:snort-users-admin () lists sourceforge net] On Behalf Of Kromodimedjo,
John
Sent: Friday, April 02, 2004 4:32 AM
To: snort-users () lists sourceforge net
Subject: [Snort-users] HELP: Error MSSQL and ACID

Hi all,

This is my second (from scratch) installation and I still get this error
message on the command line – I know that it try to add a record with a
duplicate key but I not sure it should do that.
I use SNORT/ACID/MSSQL200 using Windows 2003 and IIS6 and have followed
exactly as specified in the WinSNORT installation Guide.

Can somebody help, I am really lost.

Thanks a million

John Kromodimedjo
UNAIDS-Geneva

-------Error message-----


D:\applications\snort\bin>snort -c d:\applications\snort\etc\snort.conf -l
d:\ap
plications\snort\log -i1
-*> Snort! <*-
Version 2.1.1-ODBC-MySQL-MSSQL-FlexRESP-WIN32 (Build 24)
By Martin Roesch (roesch () sourcefire com, www.snort.org)
1.7-WIN32 Port By Michael Davis (mike () datanerds net,
www.datanerds.net/~mike)
1.8 - 2.1 WIN32 Port By Chris Reid (chris.reid () codecraftconsultants com)
database: SQL Server message 2627, state 1, severity 14:
        Violation of PRIMARY KEY constraint 'PK__event__78B3EFCA'. Cannot
insert
 duplicate key in object 'event'.
Server 'GE-3E-06', Line 1
database:  The above error was caused by the following statement:
INSERT INTO event (sid,cid,signature,timestamp) VALUES ('1', '1', '1',
'2004-04-
02 14:11:32.191')
database: SQL Server message 3621, state 0, severity 0:
        The statement has been terminated.
Server 'GE-3E-06', Line 1
database:  The above error was caused by the following statement:
INSERT INTO event (sid,cid,signature,timestamp) VALUES ('1', '1', '1',
'2004-04-
02 14:11:32.191')
database: DB-Library error:
        General SQL Server error: Check messages from the SQL Server.
database:  The above error was caused by the following statement:
INSERT INTO event (sid,cid,signature,timestamp) VALUES ('1', '1', '1',
'2004-04-
02 14:11:32.191')

________________________________
John Kromodimedjo
Network Administrator
UNAIDS / ONUSIDA
Phone: +41.22.791.4707
FAX: +41.22.791.4187
Email: KromodimedjoJ () unaids org



-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id70&alloc_id638&op=click
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users