Oracle Data Collection fails due to 'Unspecified Error'

Products

• Control Compliance Suite Databases Oracle
• Control Compliance Suite Windows

Issue/Introduction

If you are collecting data on the Oracle platform, the error 'Unspecified Error' occurs, and data collection fails.

The following are the scenarios when this error occurs.

• When you add an asset manually and fields such as DB version, IPaddress, Oracle_Home, and Service names are left blank.

• When you run an ad hoc query ORACLE_SERVER_CONFIGURATION and do not specify the asset properties 'Operating System' and 'Operating System Version' for an Oracle asset.

Resolution

Refer to the following table to troubleshoot when the error occurs.

Problem	Solution
When you add an asset manually and fields such as DB version, IPaddress, Oracle_Home, and Service name are left blank, the 'Unspecified Error' message is displayed and Oracle Data Collection fails.	Enter values in the fields such as DB version, IPaddress, Oracle_Home, and Service name, when you add an asset manually.
When you run an adhoc query ORACLE_SERVER_CONFIGURATION and do not specify the 'Operating System' and 'Operating System Version' for an oracle asset, the 'Unspecified Error' message is displayed and Oracle Data Collection fails.	You must specify the 'Operating System' and 'Operating System Version' for an Oracle asset before you run the adhoc query.