Skip to Content

Excel - IBP Login: Value cannot be null. Parameter name: key


When I login in my planning Area I get this error:

Value cannot be null. Parameter name: key

Detailed log:

2017-04-27 11:19:35,290|ERROR|UILayer|?.?||||||1|SOPRibbonExtension.DLL time stamp: 15-Mar-17 13:58:54#
2017-04-27 11:19:35,326|ERROR|UILayer|?.?||||||1|SOPRibbonExtension.DLL version: 1702.4.0#
2017-04-27 11:20:02,663|ERROR|UILayer|SOPRibbonExtension.RibbonImplementation.ManageInitialSettings|Marc Laberge|||||1|SOP CatchAll ManageInitialSettings: Value cannot be null.
Parameter name: key  Stack Trace:    at System.Collections.Generic.Dictionary`2.FindEntry(TKey key)
   at SOPRibbonExtension.Object.ScenarioPermittedObject.PermissionToReadInScenario(String scenarioId) in D:\SOPFND_v65_REL\src\SOPRibbonExtension\SOPRibbonExtension\Object\MasterData.cs:line 185
   at SOPRibbonExtension.Object.MasterData.AddFavorite(String name, ServiceFilter filter, ServiceFilter settings) in D:\SOPFND_v65_REL\src\SOPRibbonExtension\SOPRibbonExtension\Object\MasterData.cs:line 1639
   at SOPRibbonExtension.RibbonImplementation.ManageInitialSettings(InitialLoad initialLoad, String productFileVersionFromAssembly) in D:\SOPFND_v65_REL\src\SOPRibbonExtension\SOPRibbonExtension\RibbonImplementation.cs:line 2657#

This only happen on my User, on any PC but for only one Planning Area.

Anyone has an idea what my issue is ?



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 28, 2017 at 09:18 PM

    Hi Marc,

    As this error message is specific for your user, it seems that some data in the database got inconsistent and a manual intervention would be needed. Probably system is throwing this error because the deleted version is not available anymore. Please create an incident in the Support Portal to have it addressed.

    Best regards,


    Add comment
    10|10000 characters needed characters exceeded

  • Apr 27, 2017 at 03:17 PM

    Sorry but how your question is related to EPM add-in for Excel? Please remove the tag.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 27, 2017 at 07:54 PM

    Hi Marc

    Can you confirm your user has access to the required planning area?

    If yes, can you re-create the connections for the given planning area by deleting the old one? Try this if you have not done already.

    Also if possible share screen shot of your connections going in edit mode.



    Add comment
    10|10000 characters needed characters exceeded

    • Hi, still have the same error.

      I have access, I can do all the normal things after I skip the message.

      My user & My connection settings were not changed and this starting to happen.

      My only guess, is that I have deleted a version and then it started happening, it's the just for my user part that is weird to me.