Verifying the Asset Analytic Process configuration

Use the following steps to locate errors in the Asset Analytic Process configuration.

1. Check what fact data is retrieved for processing.
   1. Click Sustainability > Set Up > Analytics > Rule Engine and then open the Asset Analytic record.
   2. Verify the following values in the Fact section:

      Module

      triMetricFact

      BO

      Asset Analytic Hourly(triAssetAnalyticHFact)

      Group By Field

      triDimAssetTX

      Timestamp Field

      triCapturedDT

      The workflow constructs a query to retrieve the data that will be analyzed. The fields in the Fact section define the target table, how data is grouped, and what field defines the timestamp. If these fields are not specified or are specified incorrectly, the workflow fails to retrieve the fact data and a warning is created in the Work Flow Instance tab.

      For example, if you enter an invalid field name in the Timestamp field and run the asset analytic process, no data is retrieved. Click the Work Flow Instance tab to view the workflow and find the failure, which in this case is on the Retrieve Hourly Devices task. Click View Error to show that the invalid field name does not exist.

   3. In the Control section, verify that the values in the Period End, Periods, and Period Duration Mins fields are defined to match the rule.
      For example, an Asset Analytic Process that includes a rule that analyzes 2 hour periods should have the value in the Periods field set to 2.
      Remember: The Analytic Process Periods cannot be smaller then the value in the number of periods set in the rule conditions. For example, if the period value for the Asset Analytic Process is set to 1 and the rule condition is set to expect two periods of data, a warning will be listed in the Workflow Instance tab. Click on the workflow to view the error in the Call Workflow Task, which states that not enough results were found.
   4. If there is a value in the Criteria Query Name field, verify that the value is valid by checking for a warning listed in the Workflow Instance tab.
      You can verify the value by checking that the system report query name exists at My Reports > System Reports.
2. Check if the rules that are listed are active.
   Asset Analytic Processes do not call Engine Rule Workflows for rules that are not active. There are no warnings for rules that are not active.
3. Check the number of rows and objects that are retrieved.
   1. To activate the Retrieved Custom task log, log in to the TRIRIGA® Admin Console, in Managed Object select Platform Category, in Add Manual Category enter com.tririga.platform.fact.FactDataQueryServiceImpl, and click OK.
   2. Run the Asset Analytic Process.
   3. Find the server.log file in the TRIRIGA Admin Console under Error Logs.
   4. Review the log information, which includes the executing SQL and the number of rows and objects that were retrieved.
   5. Find “com.tririga.platform.fact.FactDataQueryServiceImpl” in the server.log file.
      The Custom Task uses the query to retrieve the fact data but it will only include data for objects that have the specified number of periods.
   6. Run the executing SQL statement against the database and verify that the Asset Analytic Process retrieves the data that you want to analyze.
      For example, the server.log below shows that two rows (periods) for one object (asset) were retrieved from the fact table.

      executing SQL: Sql[SQL=select * from T_TRIASSETANALYTICHFACT T1 where  
      triCapturedDT > 1375254000000 and triCapturedDT <= 1375261200000 and 
      ( T1.triDimSpecificationCla = 'Refrigeration Units' ) order by 
      triDimAssetTXObjId, triCapturedDT desc ,DB transaction ID=(None)]
      
      2013-12-02 12:55:41,042 DEBUG 
      [com.tririga.platform.fact.FactDataQueryServiceImpl]
      (http-0.0.0.0-14001-2) com.tririga.platform.fact.FactDataQueryServiceImpl 
      processed 2 rows for 1 objects in 32 milliseconds.