BIR server checked report data failed

Hi, team!

It's nice to meet you!

This post describes how to deal with the problem that the BIR server checked report data failed.

Issue Description

After run some times, the BIR server checked report data failed.

Handling Process

1. Get BIR server log, but we can not find any wrong information.
   

2. Get Datastation log, find that ICD_SERVICE tablespace full that result in bill written into DB failed.

   
   

   

   
   

3. Checks the ICD_SERVICE tablespace data table information, the first second largest detailed table are T_HPS_BILL_CALLHIS、T_HPS_CALL_DETAIL_RECORD. 

   
   

   

Root Cause

After the eSpace  CC server run a long time,  there will be a large data in the DB, some data are very old, if not need you can delete them.  Also if you do not need the HPS report function, you can close it.

Solution

If the customer does not need HPS report function, you can close this, follow the  steps as below:

1. Stop inserting the HPS bill to uidb.

   1. Log into AgentManagement as sysadmin user(Default password is Huawei@123).
      

   2. Click Component Setting on the top menu.
      

   3. Click the Report Service on the left menu.
      

   4. Change the Outbound CDR to OFF.
      

   5. Click Save.
      

   6. Restart Agent Management.
      

2. Stop the HPS daily jobs.
   

   1. Query the job id of the P_HPS_DAYLOG_CURSOR, Execute the following script:
      

      SELECT JOB FROM USER_JOBS WHERE UPPER(WHAT)='P_HPS_DAYLOG_CURSOR;';
      

   2. Stop the JOB of the P_HPS_DAYLOG_CURSOR by the above result.
      

      Execute the following script:
      

      /*for example 800 is the job id*/
      

      EXEC DBMS_JOB.BROKEN(800, TRUE);
      

      COMMIT;
      

   3. Stop the other HPS daily jobs by referring above steps.
      

      P_HPS_DAYLOG_AGENTDISP_REDO
      

      P_AGGR_HPS_D
      

      P_AGGR_HPS_M

This is all, thanks for reading!