SAP Knowledge Base Article - Public

2979452 - An exception occurred in one of the data sources. SAP BI Add-in has disconnected all data sources [1e04-3ff5-15]

Symptom

When accessing Analysis Office and trying to go to menu File -> Analysis -> Customize Analysis -> and clicking on "Options", the system is throwing the following error message:

  • An exception occurred in one of the data sources. SAP BI Add-in has disconnected all data sources
    [1e04-3ff5-15] Nested exception. See inner exception below for more details

    Details:
    An exception occurred in one of the data sources.

    SAP BI Add-in has disconnected all data sources.
    If you want to restart, press Restart button below. (ID-111006)

Then in the trace you have:

  • >> General .NET Exception [1e04-3ff5-15]:
    InvalidArgument=Value of '-13' is not valid for 'SelectedIndex'.

Environment

SAP Analysis for Microsoft Office All versions

Reproducing the Issue

  1. Open your Analysis for Office
  2. Go to menu "File"
  3. Click on "Analysis"
  4. Choose option "Customize Analysis"
  5. Click on "Options" 

Cause

When the application is uninstalled, the uninstall process does NOT clear the Cof directory out of %APPDATA%

Resolution

After uninstalling Analysis Office from your landscape, access folder "%APPDATA%\SAP\Cof" and remove the whole content inside of it.

Once this is done, install again the latest Analysis Office available and the issue will be gone.

See Also

Keywords

An exception has occurred in one of the data sources, [1e04-3ff5-15], Cof, APPDATA, SAP BI Add-in has disconnected all data sources, Nested exception, See inner exception below for more details, (ID-111006), upgrade, General, InvalidArgument=Value of '-13' is not valid for 'SelectedIndex'. , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions