Integrate > Oracle Enterprise Manager > Troubleshoot > Known Issues and Workarounds

Known Issues and Workarounds

Events from Cloud Control 12c are forwarded with a delay

Symptom

When Ops Connector for OEM is integrated with OEM Cloud Control 12c to collect events (alerts), these events reach Operations Connector with a noticeable delay.

Action

To resolve or alleviate the problem, log on to your Oracle Enterprise Manager Console, enable the Retry option in the Ops Connector for OEM configuration, and then set the expiration time to 1 hour. See the corresponding step in Setting Up Actions for Cloud Control 12c topic.

Metric output file contains strings ############## instead of actual values

Symptom

Identification of the root cause for missing metric values in OMi reveals the ############## strings in the output file instead of actual metric values. If logging of local metric records is enabled in the Operations Connector policy for OEM metrics, inspection of the Operations Connector's <OvDataDir>/log/OpC/opcmsglg file reveals there are related errors logged in it.

Action

The symptom indicates that the number of digits in some acquired metric values exceeds the preconfigured limit. Ops Connector for OEM by default allows up to 15 digits in whole parts of numbers that represent metric values. You can change this limit.

To increase the number of digits allowed in a metric value, proceed as follows:

  1. Locate the applicable SQL query file. For more information, see Metric Integration SQL Query topic.

  2. Open the SQL query file in a plain text editor.

  3. To increase the number of the allowed digits in the whole part of the number to 20, change the line

    to_char(em_metric_value_access(v.met_values, c.column_index), \
    '999999999999990.99') AS metric_value

    to

    to_char(em_metric_value_access(v.met_values, c.column_index), \
    '99999999999999999990.99') AS metric_value

    To allow more digits, add more 9 characters to the 99999999999999999990.99 string in the same line.

  4. Save the change.

Some expected metrics are not present in the metric output file

Symptom

Inspection of the metric output file for identifying the root cause of missing metric values in OMi reveals the metrics are also missing in the output file.

Action

The SQL query that Ops Connector for OEM uses does not collect all metrics that are available in OEM. The root cause might be a metric collection interval that is too small for your OEM-managed environment.

To increase the predefined metric collection interval, proceed as follows:

  1. Open the metric database policy based on the OEM version.

  2. In the source subsection, increase the value of the polling interval option. It defines the time period (in seconds) of the intervals at which data is acquired from the OEM database.

  3. Save the change.

  4. Restart the metric integration as described in Restarting the Services topic.

Before Contacting Software Support

If you cannot solve your issue, report it. Before contacting Software Support, ensure that:

  • You have performed the general checks. See General Troubleshooting Guidelines topic.

  • You have verified your problem is not described in this topic. See Known Issues and Workarounds topic.

  • You have collected relevant data that might be required to send to Software Support: a description of your problem, characteristics of your environment, related entries logged in the operating system event log or in the Ops Connector for OEM log files.

Software Support personnel will then provide you with further instructions. Among other things, you may be asked to change the Ops Connector for OEM logging severity level, to repeat or perform particular operations in your Ops Connector for OEM environment, and to collect specific data from your system and send them to Software Support.

To contact Software Support, see the web site at https://softwaresupport.softwaregrp.com.

Related topics

Setting Actions for OEM Cloud Control 12c or 13c

Metric Integration SQL Query

Restarting the Integrations

General Troubleshooting Guidelines

Known Issues and Workarounds