Database error - SQL Exec Failed duplicate keys

greensky 8
Viewed 0

Program: FileSight, v7.04 b23 Watching MS DFS - File server -- System Error Detected: Database error

SQLExecDirect failed with [[ODBC Error: state=23000, nativeErr=2601, err=[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cannot insert duplicate key row in object 'dbo.FileSightSeenClients' with unique index 'Ind_FileSightSeenClients_UserIP'. The duplicate key value is (domainuserID|IP-address).]

[ODBC Error: state=01000, nativeErr=3621, err=[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The statement has been terminated.] [ODBC - no error records. htype=2, h=062F8D40] , ret=-1] for SQL=[SET NOCOUNT ON; BEGIN TRAN; INSERT INTO FileSightSeenClients (UserIP, SeenTime) VALUES (N'domainuserID|ip-address', {ts N'2017-11-29 12:26:16' }); INSERT INTO FileSightSeenClients (UserIP, SeenTime) VALUES (N'domainuserID|ip-address', {ts N'2017-11-29 12:24:53' });

COMMIT TRAN;]

duplicate-key sql
4 Answers
Quinn2713

Have upgraded to v7.0.4.24 The SQL ODBC error is still displaying a lot of times:

System Error Detected: Database error

SQLExecDirect failed with [[ODBC Error: state=23000, nativeErr=2601, err=[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cannot insert duplicate key row in object 'dbo.FileSightSeenClients' with unique index 'Ind_FileSightSeenClients_UserIP'. The duplicate key value is (domain\userID|IP-address).]

[ODBC Error: state=01000, nativeErr=3621, err=[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The statement has been terminated.] [ODBC - no error records. htype=2, h=062C8318] , ret=-1] for SQL=[SET NOCOUNT ON; BEGIN TRAN; INSERT INTO FileSightSeenClients (UserIP, SeenTime) VALUES (N'Domain\UserID|IP-address', {ts N'2017-11-30 06:35:39' });

COMMIT TRAN;]

Sent from PA File Sight on FILE-Server Ver 7.0.4 (Build 26) Rule: Internal error detected in monitoring service

greensky8

Hi greensky,

Another great catch, thank you! There is another fix being pushed up. When build 7.0.4.29 is there go a head and install it.

https://www.poweradmin.com/products/file-sight/downloads/preview/

Thanks
Quinn

Please make sure to mark your questions accepted when you have your answer by clicking the gray check mark to the left of the answer.

Quinn2713

No error longer. Pls. remove [1] from the link, it gave me downloade problem.

greensky8
Related