The Billing probe does not work

Document ID : KB000116690
Last Modified Date : 08/10/2018
Show Technical Document Details
Issue:
The Billing probe does not work anymore, it used to work but does not work any more.
Environment:
- OS: Microsoft Windows 2008
- UIM Version: 8.2.x or higher
- usage_metering v9.02 or higher
 
Cause:
The billing probe is no longer required with the latest version of usage_metering.
Resolution:
There is a new usage_metering probe v9.02 available. This new version does NOT require the billing probe. And it does not require more than 1 usage_metering probe to be deployed (just the one on the Primary Hub). The new version will query the back end database and it does not need to contact every robot and hub in the environment.

https://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/usage_metering-usage-metering/usage_metering-usage-metering-release-notes

The probe requires specific minimum versions of storage server monitoring probes for capacity based metering. For more information, see the CA NM - Storage Pack section in usage_metering and CA UIM Probe Packs. Use usage_metering v9.02 or higher.
 
1. Close any open instances of the usage_metering and/or billing probe GUI.
2. Deactivate the existing usage_metering probe and the billing probe. In IM use Tools->Find and search for any/all usage_metering/billing probes that may existing your environment and deactivate them.
 - optionally backup the
current usage_metering.h2.db for later restore
3. Rt-click and delete the probe from the Primary hub and any other hubs where a usage_metering/billing probe was installed.
4. Go to the filesystem location(s) where the usage_metering probe sits and delete the usage_metering folder, e.g.,               C:\Program Files (x86)\Nimsoft\probes\service
5. Navigate to the %temp%/util/ directory of each system where you access the probe GUI interface. Delete all the files in that directory. Delete all the conf_usage_metering* or conf_billing* exe files in that directory.
 
6. Then download usage_meteringv9.20 version and deploy it to the Primary hub.

               http://support.nimsoft.com/Files/Archive/00208/usage_metering_probe_zip-9.2.0.zip
 
7. After is is installed double-click usage_metering to open the GUI.

usage_metering_scan

8. Click Run Scan Now. Then when prompted, Click Ok.
9. Click the Calculation Tab
10.
Enter the Year and the Month, e.g., 2018 and 10.
11. Then click Run and Ok.

Let the scan run for a while. Larger environments may take longer to complete the scan. You can check the log and/or click the refresh button and see if the reports display, or simply wait about 30 minutes and then click the refresh button to see if the reports have been generated.

billing_calc_reports

 
Note that you don’t need to have the webgtw installed to get the usage_metering probe up and running but if you don’t you may notice some webgtw error messages, but they can be ignored.

Here is an example of a usage_metering log extract post startup and scan run.

Oct 01 16:43:19:296 INFO  [main, com.nimsoft.nimbus.NimProbe] ****************[ Starting ]****************
Oct 01 16:43:19:296 INFO  [main, com.nimsoft.nimbus.NimProbe] 9.20
Oct 01 16:43:19:296 INFO  [main, com.nimsoft.nimbus.NimProbe] CA UIM
Oct 01 16:43:19:297 INFO  [main, com.nimsoft.nimbus.NimProbe] port=48019
Oct 01 16:43:19:300 INFO  [main, com.nimsoft.nimbus.service.probe.usage_metering.UsageMeteringProbe] login override called.
Oct 01 16:43:19:300 INFO  [main, com.nimsoft.nimbus.NimSessionBase] Has already a SID
Oct 01 16:43:19:300 DEBUG [pool-13-thread-1, com.nimsoft.util.UMBUtil] update thread started.
Oct 01 16:43:19:301 INFO  [main, com.nimsoft.nimbus.NimProbeBase] Login to NimBUS is OK
Oct 01 16:43:19:301 DEBUG [main, com.nimsoft.nimbus.service.probe.usage_metering.UsageMeteringProbe] postLoginInit enter.
Oct 01 16:43:19:301 DEBUG [main, com.nimsoft.nimbus.service.probe.usage_metering.UsageMeteringProbe] postLoginInit exit.
Oct 01 16:43:19:525 DEBUG [pool-13-thread-1, com.nimsoft.util.UMBUtil] Successfully created webgtw probe client reference.
Oct 01 16:43:19:751 DEBUG [pool-13-thread-1, com.nimsoft.util.UMBUtil] Webgtw info retrieved successfully
Oct 01 16:43:19:753 INFO  [pool-13-thread-1, com.nimsoft.query.jdbc.QueryExecutor] New connection is successful.Provider=h2;Data Source=./usage_metering;Initial Catalog=null;User ID=null;Port=null;Network Library=null;Language=null;Integrated Security=null
Oct 01 16:43:19:753 INFO  [pool-13-thread-1, com.nimsoft.query.jdbc.QueryExecutor] Executing query with access id retrieveSelectedReportData query is
                       select
                       id,create_time,start_time,end_time,report_type,path,origin_name,flag
                       from um_report_data where report_type='onpremise' and flag like ? and ORIGIN_NAME='All Origin' order by id desc
              
Oct 01 16:43:19:755 INFO  [pool-13-thread-1, com.nimsoft.query.jdbc.QueryExecutor]  Number of records for access id retrieveSelectedReportData : 0
Oct 01 16:43:19:755 INFO  [pool-13-thread-1, com.nimsoft.query.jdbc.QueryExecutor] Executing query finished with access id retrieveSelectedReportData
Oct 01 16:43:19:757 INFO  [pool-13-thread-1, com.nimsoft.nimbus.service.probe.usage_metering.device_metering.DeviceMeteringCallback] Retrieving device usage from '09/01/2018 00:00:00' to '09/30/2018 23:59:59'
Oct 01 16:43:19:759 DEBUG [pool-13-thread-1, com.nimsoft.usage_metering.common.db.provider.H2DBProviderBase] Successfully created connection to H2 database.
Oct 01 16:43:19:759 DEBUG [pool-13-thread-1, com.nimsoft.query.jdbc.QueryExecutor] Packs.xml File absolute path is C:\Program Files (x86)\Nimsoft\probes\service\usage_metering\packs.xml
Oct 01 16:43:19:878 DEBUG [pool-13-thread-1, com.nimsoft.util.UMBUtil] Successfully created webgtw probe client reference.
Oct 01 16:43:20:104 DEBUG [pool-13-thread-1, com.nimsoft.util.UMBUtil] Webgtw info retrieved successfully
Oct 01 16:43:20:107 INFO  [pool-13-thread-1, com.nimsoft.query.jdbc.QueryExecutor] New connection is successful.Provider=h2;Data Source=./usage_metering;Initial Catalog=null;User ID=null;Port=null;Network Library=null;Language=null;Integrated Security=null
Oct 01 16:43:20:107 INFO  [pool-13-thread-1, com.nimsoft.query.jdbc.QueryExecutor] Executing query with access id selectForOnPremReport query is
                       SELECT
                       cs_id,origin,GROUP_CONCAT(ip) as
                       ip,GROUP_CONCAT(name) as name,GROUP_CONCAT(probe_name) as
                       probe_name,GROUP_CONCAT(FQDN) as fqdn,GROUP_CONCAT(ROBOT) as
                       robot,GROUP_CONCAT(total_size) as
                       total_size,GROUP_CONCAT(monitored_size) as monitored_size
                       FROM
                       UM_DEVICE_DATA
                       Where CREATE_DATE between ? and ?
                       group by cs_id,origin
              
Oct 01 16:43:20:108 INFO  [pool-13-thread-1, com.nimsoft.query.jdbc.QueryExecutor] Executing query finished with access id selectForOnPremReport
Oct 01 16:43:20:108 INFO  [pool-13-thread-1, com.nimsoft.query.jdbc.QueryExecutor] Executing query with access id selectForOnPremReport query is
                       SELECT
                       cs_id,origin,GROUP_CONCAT(ip) as
                       ip,GROUP_CONCAT(name) as name,GROUP_CONCAT(probe_name) as
                       probe_name,GROUP_CONCAT(FQDN) as fqdn,GROUP_CONCAT(ROBOT) as
                       robot,GROUP_CONCAT(total_size) as
                       total_size,GROUP_CONCAT(monitored_size) as monitored_size
                       FROM
                       UM_DEVICE_DATA
                       Where CREATE_DATE between ? and ?
                       group by cs_id,origin
              
Oct 01 16:43:20:109 INFO  [pool-13-thread-1, com.nimsoft.query.jdbc.QueryExecutor] Executing query finished with access id selectForOnPremReport
Oct 01 16:43:20:109 DEBUG [pool-13-thread-1, com.nimsoft.util.UMBUtil] update thread finished.
Additional Information:
You can also deploy the webgtw probe and set

Refer to this link for the webgtw setup:
https://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/webgtw-web-gateway

Note that the parameter-> terms_of_use_accepted_flag

must be set to true.

Information on configuring webgtw can be found here:
https://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/how-to-articles/set-up-automated-usage-metering-and-billing