KBI 311718 Many .BAD Files In SQL Bulk Insert Folder
Version
Argent Advanced Technology – All versions
Date
Monday, 8 October 2018
Summary
Many .BAD files were found in the SQL Bulk Insert Folder
Technical Background
After further examining the logs, it was discovered that the Argent Service Account did not have the right permissions
The following lines were found in the Argent Service Log:
05 Oct 2018 00:05:11.355 ARGENTSERVER DOMAIN\Argent ***** ERROR ***** An error condition has been detected by ArgSoft_DAL.cpp
(D6190_Execute_SQL_With_Error) at line 4413: ODBC Exception.
Microsoft Error Code =
You do not have permission to use the bulk load statementResolution
The Argent Service Account must have dbowner privileges or the ‘bulkadmin’ database role to be able to execute bulk insert statements
In SQL Management Studio -> Object Explorer, navigate to ‘Security’ -> ‘Logins’ -> Select the Argent Service Account and right click and select ‘Properties’
Under ‘Server Roles’ ensure that the bulkadmin role is checked