Troubleshooting

Refer to the table below to identify and resolve issues discovered in the Add-in:

Error/Issue

Solution

Receiving the exception at runtime:

[System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC

This exception is caused by changing the separators within Excel under “Options > Advanced > Use system separators” after login.

To resolve, either close excel and reopen or revert the setting change that was made.

Receiving error at the point of login:

[042915_125729799][oracle.xdo.servlet.XDOCookie][EXCEPTION] java.lang.RuntimeException: Failed to retrieve data from Presentation ServerCould not connect to OBI Presentation Service

This is a result of the user’s username changing after accessing BI Publisher reports via the Oracle Cloud UI or through BI Report webservices. Refer to Oracle Support Doc ID 1998643.1 for more information:

There are two options available to the Administrator in this scenario:

  1. The username can be reverted in OIM to match that being used in BI. This will restore BI functionality without any further changes being required. A new user can then be defined in OIM with the correct username.

  2. The user account created in BI can be modified or dropped using either the renameAccounts or forgetAccounts utilities respectively. In cases where the old and new username are both known a renameAccounts command can be issued to update the username stored in the BICatalog, bringing it in line with that now being passed from OIM. If this information is not available, then all references to the existing account can be dropped from the BICatalog using the forgetAccounts command but if the user has created content this will be lost as the account is dropped unless backed up by a BI Administrator.

Refer to Doc ID 2621628.1 on Oracle support for steps.