Oracle Enterprise Manager (OEM) Adapter fails with the error message "Object reference not set to an instance of an object

[#1]

Summary

Oracle Enterprise Manager (OEM) Adapter fails with the error message "Object reference not set to an instance of an object

Symptoms

When using the OEM adapter to generate the Oracle Inventory tnsNames.ora file that can be imported into FNMS this will fail with the following error, even though all of the steps in the install guide for the adapter have been completed and all of the pre-requisites have been installed.

Error:

?ERROR OEMAdapter.Library.Logger - Object reference not set to an instance of an object.
System.NullReferenceException: Object reference not set to an instance of an object.
at OEMAdapter.Library.ConfigurationReader.GetDBConnectionString()
at OEMAdapter.Library.TNSFileGenerator.GetData()
at OEMAdapter.Library.TNSFileGenerator.GenerateFile()
at OEMAdapter.Program.Main(String[] args)?

Cause

The error is caused by an additional tag that was added to the connection string, the following connection string is listed in the adapter documentation as of Nov 14 which contains the tags that cause the issue:

"connectionStrings>
<clear></clear>
<add name="OEMConn" connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<Host Name>)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=OEMREP)));User Id=<UserName>;Password=<Password>"></add>
</connectionStrings>"

The incorrect tags listed are:

"<clear></clear> "

Resolution

To resolve the issue the additional tags can be removed, the connection string should be as follows:
"connectionStrings>
<add name="OEMConn" connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<Host Name>)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=OEMREP)));User Id=<UserName>;Password=<Password>"></add>
</connectionStrings>"

The following issue has been logged to have the documentation for the adapter updated, FNMS-20754.

Additional Information

For additional information on using the OEM Adapter please refer to the Install Guide that is downloaded with the Adapter.