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 detailsDetails:
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
- Open your Analysis for Office
- Go to menu "File"
- Click on "Analysis"
- Choose option "Customize Analysis"
- 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
- Analysis Office Installation and Update
- 1518359 - SAP BusinessObjects Analysis Office & BIP Add On Release schedule
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