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;]

asked 29 Nov '17, 07:46

greensky's gravatar image

greensky
523
accept rate: 0%


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.

link

answered 30 Nov '17, 14:12

Quinn's gravatar image

Quinn ♦♦
14.4k3925
accept rate: 35%

edited 01 Dec '17, 11:08

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
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.

link

answered 29 Nov '17, 11:33

Quinn's gravatar image

Quinn ♦♦
14.4k3925
accept rate: 35%

edited 29 Nov '17, 11:34

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

link

answered 30 Nov '17, 01:52

greensky's gravatar image

greensky
523
accept rate: 0%

edited 30 Nov '17, 02:18

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

link

answered 01 Dec '17, 04:14

greensky's gravatar image

greensky
523
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×23
×1

Asked: 29 Nov '17, 07:46

Seen: 5,882 times

Last updated: 01 Dec '17, 11:08