I am pretty sure the issue is with multi threading because examining the log shows that the error occurs on the first simultaneous threaded Bulk Insert.
First the working one:
Code: Select all
[size=50]
7/10/2018 6:44:44 PM 0.000 Bulk (1|$2A48) INSERT INTO FOLDERACCESSLIST values (533940, 'S-1-5-32-544', 'A', 4294967294, 2032127) Complete
7/10/2018 6:44:44 PM 0.000 Bulk (1|$207C) INSERT INTO FOLDERACCESSLIST values (533941, 'S-1-5-21-1252972849-895940921-1336054014-500', 'A', 4294967294, 2032127) Complete
7/10/2018 6:44:44 PM 0.000 Bulk (2|$2A48) INSERT INTO FOLDERACCESSLIST values (533940, 'S-1-1-0', 'A', 19, 2032127) Complete
7/10/2018 6:44:44 PM 0.000 Bulk (2|$207C) INSERT INTO FOLDERACCESSLIST values (533941, 'S-1-1-0', 'A', 19, 2032127) Complete
7/10/2018 6:44:44 PM 0.000 Bulk (3|$2A48) INSERT INTO FOLDERACCESSLIST values (533940, 'S-1-5-32-544', 'A', 16, 2032127) Complete
7/10/2018 6:44:44 PM 0.000 Bulk (4|$2A48) INSERT INTO FOLDERACCESSLIST values (533940, 'S-1-3-0', 'A', 27, 2032127) Complete
7/10/2018 6:44:44 PM 0.000 Bulk (3|$207C) INSERT INTO FOLDERACCESSLIST values (533941, 'S-1-5-21-1252972849-895940921-1336054014-500', 'A', 16, 2032127) Complete
7/10/2018 6:44:44 PM 0.000 Bulk (5|$2A48) INSERT INTO FOLDERACCESSLIST values (533940, 'S-1-5-21-1252972849-895940921-1336054014-513', 'A', 16, 1179817) Complete
7/10/2018 6:44:44 PM 0.000 Bulk (4|$207C) INSERT INTO FOLDERACCESSLIST values (533941, 'S-1-3-0', 'A', 27, 2032127) Complete
7/10/2018 6:44:44 PM 0.000 Bulk (6|$2A48) INSERT INTO FOLDERACCESSLIST values (533940, 'S-1-3-1', 'A', 27, 1179817) Complete
7/10/2018 6:44:44 PM 0.000 Bulk (5|$207C) INSERT INTO FOLDERACCESSLIST values (533941, 'S-1-5-21-1252972849-895940921-1336054014-513', 'A', 16, 1179817) Complete
7/10/2018 6:44:44 PM 0.000 Bulk (7|$2A48) INSERT INTO FOLDERACCESSLIST values (533940, 'S-1-5-21-1252972849-895940921-1336054014-512', 'A', 19, 1245631) Complete
7/10/2018 6:44:44 PM 0.000 Bulk (6|$207C) INSERT INTO FOLDERACCESSLIST values (533941, 'S-1-3-1', 'A', 27, 1179817) Complete
7/10/2018 6:44:44 PM 0.000 Bulk (8|$2A48) INSERT INTO FOLDERACCESSLIST values (533940, 'S-1-5-21-1252972849-895940921-1336054014-514', 'A', 19, 1179817) Complete
7/10/2018 6:44:44 PM 0.000 Bulk (7|$207C) INSERT INTO FOLDERACCESSLIST values (533941, 'S-1-5-21-1252972849-895940921-1336054014-512', 'A', 19, 2032127) Complete
7/10/2018 6:44:44 PM 0.000 Bulk (9|$2A48) INSERT INTO FOLDERACCESSLIST values (533940, 'S-1-5-32-544', 'A', 19, 2032127) Complete
7/10/2018 6:44:44 PM 0.000 Bulk ($2A48) FOLDERACCESSLIST.Execute(9) Complete
7/10/2018 6:44:44 PM 0.000 SQL Execute: INSERT INTO FOLDERACCESSLIST values (:FOLDERID, :USERGROUPSID, :ACCESS, :ACEFLAGS, :MASK)
.. irrelevant parts removed..
7/10/2018 6:44:44 PM 0.000 Bulk (8|$207C) INSERT INTO FOLDERACCESSLIST values (533941, 'S-1-5-21-1252972849-895940921-1336054014-513', 'A', 19, 1245631) Complete
7/10/2018 6:44:44 PM 0.000 Bulk ($207C) FOLDERACCESSLIST.Execute(8) Complete[/size]
Now the first collision using 7.3.8:
Code: Select all
[size=50] 7/10/2018 6:12:14 PM 0.000 Bulk (1|$120C) INSERT INTO FOLDERACCESSLIST values (533641, 'S-1-5-32-544', 'A', 4294967294, 2032127) Complete
7/10/2018 6:12:14 PM 0.000 Bulk (1|$22BC) INSERT INTO FOLDERACCESSLIST values (533639, 'S-1-1-0', 'A', 3, 2032127) Complete
7/10/2018 6:12:14 PM 0.000 Bulk (2|$120C) INSERT INTO FOLDERACCESSLIST values (533641, 'S-1-1-0', 'A', 19, 2032127) Complete
7/10/2018 6:12:14 PM 0.000 Bulk (3|$120C) INSERT INTO FOLDERACCESSLIST values (533641, 'S-1-5-32-544', 'A', 16, 2032127) Complete
7/10/2018 6:12:14 PM 0.000 Bulk (2|$22BC) INSERT INTO FOLDERACCESSLIST values (533639, 'S-1-3-0', 'A', 11, 2032127) Complete
7/10/2018 6:12:14 PM 0.000 Bulk (4|$120C) INSERT INTO FOLDERACCESSLIST values (533641, 'S-1-3-0', 'A', 27, 2032127) Complete
7/10/2018 6:12:14 PM 0.000 Bulk (3|$22BC) INSERT INTO FOLDERACCESSLIST values (533639, 'S-1-3-1', 'A', 11, 1179817) Complete
7/10/2018 6:12:14 PM 0.000 Bulk (5|$120C) INSERT INTO FOLDERACCESSLIST values (533641, 'S-1-5-21-1252972849-895940921-1336054014-513', 'A', 16, 1179817) Complete
7/10/2018 6:12:14 PM 0.000 Bulk (4|$22BC) INSERT INTO FOLDERACCESSLIST values (533639, 'S-1-5-21-1252972849-895940921-1336054014-512', 'A', 3, 2032127) Complete
7/10/2018 6:12:14 PM 0.000 Bulk (6|$120C) INSERT INTO FOLDERACCESSLIST values (533641, 'S-1-3-1', 'A', 27, 1179817) Complete
7/10/2018 6:12:14 PM 0.000 Bulk (5|$22BC) INSERT INTO FOLDERACCESSLIST values (533639, 'S-1-5-21-1252972849-895940921-1336054014-513', 'A', 3, 1245631) Complete
7/10/2018 6:12:14 PM 0.000 Bulk ($22BC) FOLDERACCESSLIST.Execute(5) Complete
7/10/2018 6:12:14 PM n/a SQL Execute: INSERT INTO FOLDERACCESSLIST values (:FOLDERID, :USERGROUPSID, :ACCESS, :ACEFLAGS, :MASK)
.. irrelevant parts removed..
7/10/2018 6:12:14 PM 0.000 Bulk (7|$120C) INSERT INTO FOLDERACCESSLIST values (533641, 'S-1-5-21-1252972849-895940921-1336054014-512', 'A', 19, 1245631) Complete
7/10/2018 6:12:14 PM 0.000 Bulk (8|$120C) INSERT INTO FOLDERACCESSLIST values (533641, 'S-1-5-21-1252972849-895940921-1336054014-514', 'A', 19, 1179817)Error: Incorrect syntax near '-'.[/size]