Troubleshooting database issues

Last Updated : Nov 29, 2022 |
Prolog information
Metadata
Keywords:
If there are issues with your reporting data, troubleshoot the typical database issues using the commands in this procedure. For example, if an ETL process stops running, data stops moving to External Data Mart (EDM).
  1. Log in to the Cluster Control Manager (CCM) console as the customer user.
  2. Switch to being the root user by entering the command su.
  3. To run the Analytics Administration script, use the following command:
    ADDITIONAL INFORMATION:
    ccm release orca analytics
  4. Select Troubleshooting by pressing the corresponding number.
  5. Select Database by pressing the corresponding number.
  6. To check the running process table, select the Check the running process table option by entering the corresponding number.
    STEP RESULT:
    If a process is running, clear the running process.
  7. Return to the previous page by entering b.
  8. Quit the current page by entering q.
  9. Return to the main menu by entering m.
  10. To clear the running process table, select the Clear the running process table option by entering the corresponding number.
    STEP RESULT:
    This step restarts any running processes, and the ETL process gets enabled.
  11. Return to the previous page by entering b.
  12. Quit the current page by entering q.
  13. Return to the main menu by entering m.
  14. To check the status of the ETL process, select the Check if scheduled ETL process is enabled option by entering the corresponding number.
    STEP RESULT:
    If the ETL process is not enabled, data stops moving to EDM. You must check if there is a process running, and clear the running process by using the Enable Scheduled ETL Process option, if required.
    Alternatively, if you want to disable an ETL process, use the Disable Scheduled ETL Process option.
  15. Return to the previous page by entering b.
  16. Quit the current page by entering q.
  17. Return to the main menu by entering m.
  18. To check the Interval Data loads, select the Check interval data loads option by entering the corresponding number.
    STEP RESULT:
    The page displays the latest data that was sent to EDM for each metric. If the data is not updated for more than one interval, you must troubleshoot the issue by checking the ETL process.
  19. Return to the previous page by entering b.
  20. Quit the current page by entering q.
  21. Return to the main menu by entering m.
  22. To check the CDR data loads, select the Check CDR data loads option by entering the corresponding number.
    STEP RESULT:
    The page displays the latest data that was sent to EDM for each metric. If the data is not updated for more than one interval, you must troubleshoot the issue by checking the ETL process.
  23. Return to the previous page by entering b.
  24. Quit the current page by entering q.
  25. Return to the main menu by entering m.
  26. To check the Dimension data loads, select the Check Dimension data loads option by entering the corresponding number.
    STEP RESULT:
    The page displays the latest data that was sent to EDM for each metric. If the data is not updated for more than one interval, you must troubleshoot the issue by checking the ETL process.
  27. To check disk space of pgdata, select the Check disk space of pgdata option by entering the corresponding number.
    ADDITIONAL INFORMATION:
    Note:
    You can check the disk space only if the service crunchy-primary-service-orca-dbmgr-0 is in a ready or running state before continuing.
  28. Return to the previous page by entering b.
  29. Quit the current page by entering q.
  30. Return to the main menu by entering m.
  31. Select Deployment by pressing the corresponding number.
  32. To select the GDPR option, enter the corresponding number.
  33. To view the current settings for the Call Originator Redaction feature, select the Show current GDPR configuration option, enter the corresponding number.
    STEP RESULT:
    Depending on whether the Call Originator Redaction feature is enabled or disabled, the screen displays the following:
    • Call Originator Redaction is currently enabled: The Personally identifiable information (PII) is removed from the Analytics logs, which enables the Automatic encryption.
    • Call Originator Redaction is currently disabled:The Personally identifiable information (PII) is not removed from the Analytics logs, which disables the Automatic encryption.
  34. Return to the previous page by entering b.
  35. Quit the current page by entering q.
  36. Return to the main menu by entering m.
  37. To enable the Call Originator Redaction feature, select the Enable GDPR configuration option, enter the corresponding number.
  38. In the Proceed with disabling GDPR for Historical and Realtime reporting value field, type Y or N to cancel the operation.
    ADDITIONAL INFORMATION:
    Other:
    Setting the GDPR value requires Input Adaptor pod(s) and CDR pod(s) restart.
  39. To disable the Call Originator Redaction feature, select the Disable GDPR configuration option, enter the corresponding number.
  40. In the Proceed with disabling GDPR for Historical and Realtime realtime reporting value field, type y.Entering n cancels the operation.
    ADDITIONAL INFORMATION:
    Other:
    Setting the GDPR value requires Input Adaptor pod(s) and CDR pod(s) restart.
  41. Return to the previous page by entering b.
  42. Quit the current page by entering q.
  43. Return to the main menu by entering m.