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;] |
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 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. |
Hi greensky, Sorry about the second error. We have a fix in the preview version and it's ready for you to install. Version 7.0.4.24 https://www.poweradmin.com/products/file-sight/downloads/preview/ Thanks 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. |
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 |