Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..
1161 views

Error executing SQL statement - Cannot bulk load

We are using RM 8.3.0.9088 and SQL Server 2012 R2.

We are trying to a copy of our production dataset thru the RMES and it fails with the following error:

Error executing SQL statement: Cannot bulk load because the file "\\QSV-TRIM-EVT01\Training\TSACCESSCO_TES00000.dat" could not be opened. Operating system error code 5(Access is denied.).

\\QSV-TRIM-EVT01\Training was the bulk loader directory.

We believe that our security is correct.

Any reason as to the error.

Thanks.

RD

 

 

 

 

0 Likes
5 Replies
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: Error executing SQL statement - Cannot bulk load

When you execute it, it’ll be saving to the path using the SQL service account (which is usually local system). Either change the path to not be a UNC path (ie use “f:\temporary export” (which must be a valid path on the sql server), or update the share permissions so that everyone can read/write.
---------
Erik
0 Likes
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: Error executing SQL statement - Cannot bulk load

We are creating a copy of a dataset in a RMES thru one of our workgroup servers.  Though  sql statements are run in creating copying the dataset,  the bulk loader path is on the workgroup Server and not the sql server.  Are you saying the path should be on the sql Server?  I don’t see how this is possible.

0 Likes
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: Error executing SQL statement - Cannot bulk load

We did as suggested and it still fails.

0 Likes
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: Error executing SQL statement - Cannot bulk load

To resolve this error you need to create a share off the SQL Server (with permission set to "Everyone").  The SQL Server service will not have permission to write to your workgroup server share.  So much depends on your DB configuration it's hard to give you a concrete example.  For instance, you need to have a blank database available in order to use it when creating the copy.  Though the user you're using to perform the copy (via the Enterprise Studio) must also have bulkadmin permissions, ownership of the destination database, and read/write permission to the bulk load share.

---------
Erik
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: Error executing SQL statement - Cannot bulk load

Did you ever sort this out?  I just added a post on my blog about this topic.... maybe it will help?

---------
Erik
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.