# Errors on BCP Failure

The page discusses the errors that arise in OpManager when bulk copy program (BCP) failure occurs and the relevant solutions. There are four types of errors and OpManager notifies the user with a red banner message when an error occurs.

- [BCP_Files_Missing](https://www.manageengine.com/network-monitoring/help/error-codes.html#bcp-files-missing)
- [BCP_Not_Running](https://www.manageengine.com/network-monitoring/help/error-codes.html#bcp-not-running)
- [Windows_Authentication_Fails](https://www.manageengine.com/network-monitoring/help/error-codes.html#windows-authentication-fails)
- [BCP_Version_Mismatch](https://www.manageengine.com/network-monitoring/help/error-codes.html#bcp-version-mismatch)

## BCP_Files_Missing

This error occurs when the Bulk Copy Program (BCP) utility used for bulk data processing in SQL database, is missing in the instance.

**Solution:**

- **For Windows:** Copy the `bcp.exe` and `bcp.rll` files available in the MSSQL installation directory (Files can be found in the subfolders of `MSSQLHOME\Client SDK\ODBC` in SQL installed server).
- **For Linux:** Copy the `bcp` and `bcp.rll` files from the subfolders of `/opt/mssql-tools/` directory. If the files are missing in the mssql-tools folder, or the folder itself is missing, please refer to [this link](https://www.manageengine.com/network-monitoring/help/hardware-and-software-requirements.html#bcp-linux).
- Paste them under `OpManagerHome\bin` directory.
- Restart OpManager service.

**Note:** ODBC driver should be installed in the OpManager installed server for Linux setups.

## BCP_Not_Running

This error occurs when BCP for bulk data processing in SQL database fails to run.

**Solution:**

Check if `bcp.exe`, or `bcp` is blocked by your firewall in the OpManager installed server, for Windows and Linux respectively.

- Grant the required permissions for `bcp.exe` (Windows) or `bcp` (Linux) file in your firewall.
- If the native client is not installed in the local system, install the suitable native client for the MSSQL server in the local system.
- If the issue still persists, open command prompt/terminal with the Run as administrator/root user option and execute `bcp.exe` (Windows) / `bcp` (Linux) from `OpManagerHome\bin` directory, take a screenshot of the output and contact support.

## Windows_Authentication_Fails

When login authentication in a Windows system fails it may cause BCP failure. As a result, the bulk data processing in SQL server may fail to occur.

**Solution**

Make sure the domain user (provided for SQL database's Windows authentication in OpManager) has the login permission to access the SQL server.

- Provide [Log in access](https://www.manageengine.com/network-monitoring/how-to/resolving-loginerror-bcpcommands.html?utm_source=inproduct) to OpManager service with the user account which has access to MSSQL DB.
- Restart OpManager service.

## BCP_Version_Mismatch

This type of error occurs when the BCP version used in the instance is incompatible.

**Solution:**

- Copy the `bcp.exe` and `bcp.rll` files available in the MSSQL installation directory (Files can be found in the subfolders of `MSSQLHOME\Client SDK\ODBC\` in SQL installed server).
- Ensure to copy the correct version of BCP files with respect to the version of database server. (Use `bcp -v` command to check the version).
- Paste them under `OpManagerHome\bin` directory.
- Restart OpManager service.