Active Directory - Save to Database


Article ID: 196201


Updated On:


CA Identity Manager CA Identity Governance CA Identity Portal CA Identity Suite


When trying to perform an import from Active Directory into Identity Governance the below error is show:

21/07/2020 12:09:19 CTaskList::ExecuteTasks starting
21/07/2020 12:09:19 Bulk insert options: Line Delimiter - [|]; Field Delimiter - [ ]

21/07/2020 12:09:19 Writing Resource DB 'E:\data\gm\res.rdb' to SQL Server 'SQLMTEST7' Database 'EIMGOVObjectsDB'
21/07/2020 12:09:19 CExportDBTask::ExecuteStep starting
21/07/2020 12:09:19 DB Error: Cannot bulk load because the file "\\eimgovdemo\gm\BulkTempDirectory\EurekifySage_BulkInsert_jd4529_20200721_120919_DataTypesTmp.tbl" could not be opened. Operating system error code 5(Access is denied.). (80040E14)
Query: SET DATEFORMAT dmy BULK INSERT DataTypes FROM '\\eimgovdemo\gm\BulkTempDirectory\EurekifySage_BulkInsert_jd4529_20200721_120919_DataTypesTmp.tbl'  WITH ( KEEPIDENTITY, FIELDTERMINATOR = ' ', ROWTERMINATOR = ',', CODEPAGE = '1252')
21/07/2020 12:09:19 Failed to write table 'DataTypes' data from BULK INSERT file '\\eimgovdemo\gm\BulkTempDirectory\EurekifySage_BulkInsert_jd4529_20200721_120919_DataTypesTmp.tbl'
21/07/2020 12:09:19 Task Done
21/07/2020 12:09:19 Total Time Elapsed: 30 ms
21/07/2020 12:09:19 Bulk Insert Time: 22 ms; Bulk Size: 10000
21/07/2020 12:09:19 CTaskList::ExecuteTasks ended


Release : 14.3

Component : GovernanceMinder(Role & Compliance Manager)


Error: Operating system error code 5(Access is denied.). (80040E14)

This error appears when you are using SQL Server Authentication and SQL Server is not allowed to access the bulk load folder. You will need to grant the SQL server access to the directory.

Go to the folder right click ->properties->Security tab->Edit->Add(on the new window) ->Advanced -> Find Now. Under the users list in the search results, find something like SQLServerMSSQLUser$UserName$SQLExpress and click ok, to all the dialogs opened.

You can try the above as well as review the below Microsoft document.

Any further questions will need to be followed up with Microsoft on how to resolve this issue on their end.