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
• BCP_Not_Running
• Windows_Authentication_Fails
• 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 missing in the mssql-tools folder, or the folder itself is missing, please refer this link.

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

• Paste them under OpManagerHome\\bin directory.
• Restart OpManager service

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 fail 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 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 ofMSSQLHOME\\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