Trying to import 2 records in our Test database (used to work before the environment is rebuilt/reimaged)
What could be stopping us if this is the error:
\DATAPORTEXPORTIMPORT23april16March2015\Import - Records - 8th attempt access to everyone given now.dpproj) 22.214.171.12460 23/04/2015 10:29:12 AM Import started 23/04/2015 10:29:12 AM Running process as Location: Joe Bloke 23/04/2015 10:29:12 AM Data source:\\COMPANY\EMPNumber\Desktop\DATAPORTEXPORTIMPORT23april16March2015
23/04/2015 10:29:12 AM 4 Warning Update on duplicate was enabled but no unique identifier was mapped. Setting update on duplicate to false. 23/04/2015 10:29:12 AM Loading Record - ID: 1 23/04/2015 10:29:13 AM Loading Record - ID: 2
23/04/2015 10:29:14 AM 4 Error Import batch: 1 bulk data load error: Processing accumulated data failed. No data from this batch will be processed. TrimException: Exception Source: HP.HPTRIM.SDK, - Exception Message: Function request (Add document) for HP Records Manager Workgroup Server 'TEST159' failed.
Error executing SQL statement: Cannot bulk load because the file "\\TRIMCOMPANYTEST\Dataportshare\0000000000000H\TSRECORD_17.dat" could not be opened. Operating system error code 5(Access is denied.). Details: Extended SQL Error Information: Number = 0x80040e14 Source = Microsoft OLE DB Provider for SQL Server Description = Cannot bulk load because the file "\\TRIMCOMPANYTEST\Dataportshare\0000000000000H\TSRECORD_17.dat" could not be opened. Operating system error code 5(Access is denied.).
SQLState = 42000 NativeError = 4861 SQL command: BULK INSERT TSRECORD FROM '\\TRIMCOMPANYTEST\Dataportshare\0000000000000H\TSRECORD_17.dat' WITH ( DATAFILETYPE = 'char', CODEPAGE = 'RAW', ROWS_PER_BATCH = 2, FIELDTERMINATOR = ']~*[', ROWTERMINATOR = ']&&[', KEEPNULLS , MAXERRORS = 1, ORDER (uri ASC)) 23/04/2015 10:29:14 AM Starting final pass processing
23/04/2015 10:29:14 AM Completed data import: Records Items processed: 2 Error: 2 Warning: 1 Updated: 0 Created: 0
Where is \\TRIMCOMPANYTEST\Dataportshare\ located? I have had trouble in the past with the server hosting the file share. The theory goes that the import software (TrimPort/DataPort) needs to access the file share as well as the SQL server running the Bulk Insert.
The problem occurs when the SQL Server account cannot access the file share. Hosting the file share on the SQL Server itself gives the most reliable results. Giving access to Everyone and work your way back. This article has some more details and links on the security aspects.