MSSQL- Last hour report showing unaccounted for Application, source and destination.

MSSQL- Last hour report showing unaccounted for Application, source and destination.

Steps for version 12:

Regarding the issue last hour report showing unaccounted, Please make sure you have done following steps:

1. Stop the OpManager service.

2. From the installed MSSQL SERVER, copy the files bcp.exe and bcp.rll to <OpManager_Home>/bin/  folder.

3. Go to the services window on the server where MSSQL is installed. Please make sure that "SQL browser" service is running.

4. If the NetFlow Analyzer and MSSQL database is on the different server, Download the same version of MSSQL server Native client and install it on the NetFlow Analyzer server. This is needed for NetFlow Analyzer to communicate remote database server. After installing the Native client, please restart the NetFlow Analyzer server.

5. Make sure that the database user for OpManagerDB has "sys admin" permission.

6. Start the OpManager service and check.



Steps for till version 11001:

1. Stop the NetFlow Analyzer service.

2. From the installed MSSQL SERVER, copy the files bcp.exe and bcp.rll to <NetFlow_Home>/bin/  folder.

3. Go to the services window on the server where MSSQL is installed. Please make sure that "SQL browser" service is running.

4. If the NetFlow Analyzer and MSSQL database is on the different server, Download the same version of MSSQL server Native client and install it on the NetFlow Analyzer server. This is needed for NetFlow Analyzer to communicate remote database server. After installing the Native client, please restart the NetFlow Analyzer server.

5. Make sure that the database user for OpManagerDB has "sys admin" permission.

6. Start the NetFlow Analyzer service and check.

          • Related Articles

          • Fix for Cisco ASA showing 0.0.0.0.0.0 for source and Destination for build 9900

            Thank you for your time during the call. Please follow the below steps and check on the issue: 1) Stop the NetFlow Analyzer Service. 2) Open Command prompt as administrator and navigate to NetFlow_Home/bin and execute startDB.bat two times for ...
          • DST changes-NFA reports one hour behind.

            Daylight Savings Time changes affects Java applications and make them to report one hour behind to the actual time. Customers facing this issue please follow the steps below to fix the issue. Please follow the below steps and check on the issue: 1. ...
          • MSSQL database migration in v12

            Kindly follow the below steps to migrate the SQL DB, 1. Take a backup of "customer-config.xml" file from the location "ManageEngine\OpManager\conf". 2. Take a SQL backup of OpManagerDB from the old server via SQL Management Studio. 3. Create a new DB ...
          • MSSQL Server migration

            1. Stop the NetFlow Analyzer service.  2. Backup the old Netflow DB and restore on to the new DB server (Connect MSSQL client using SQL Server Management Studio and backup netflow database and restore it new server). 3. From the New MSSQL SERVER, ...
          • MSSQL Database shrink.

            To reduce the MSSQL database size, please follow the below steps. 1. Stop the NetFlow Analyzer service. 2.Open a command prompt as administrator(Right click and run as administrator) Navigate to <NetFlow_Home\troubleshooting\>. 3. Execute the ...