Problem Note 32448: Custom repository can return an exception when attempting to open a stored processes in the SAS Add-in for Microsoft Office
 |  |  |  |  |
A custom repository can return an exception when attempting to open a stored process in the SAS® Add-in for Microsoft Office. This will most likely happen if your custom repository contains a folder name identical to a folder name in the Foundation repository. When you have this situation and attempt to open a stored process through SAS→Reports, you will receive the following error:
Unexpected exception occured in SAS® Add-in for Microsoft Office. Please report this error to your site administrator. System.ArgumentException: Item has already been added. Key in dictionary: 'SAS Folders\BIP Tree' Key being added: 'SAS Folders\BIP Tree' at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add) at System.Collections.Hashtable.Add(Object key, Object value) at SAS.EG.SDS.Metadata.BIPTree.PopulateTreeLevel(ArrayList objects, String parentPath) at SAS.EG.SDS.Metadata.BIPTree.PopulateTreeLevel(ArrayList objects, String parentPath) at SAS.EG.SDS.Metadata.BIPTree.Populate() at SAS.EG.SDS.Metadata.BIPTree..ctor(OMSRepository iRep) at SAS.EG.SDS.Metadata.OMSRepository.GetObjects(Type type, Type parentType, String parm) at SAS.EG.SDS.Metadata.MetadataManager.GetObjects(Type type, Type parentType, String parentName) at SAS.EG.SDS.Model.Broker.PopulateFromMetadata(Collection collection) at SAS.EG.SDS.Model.Broker.PopulateCollection(Collection collection) at SAS.EG.SDS.Model.Collection.DoPopulate() at SAS.EG.SDS.Model.Collection..ctor(String name, Type itemType, Object itemData, Base parent, eNodeType nodeType, Boolean fCaseInsensitive, Boolean fDefer) at SAS.EG.SDS.Model.OMFolder.get_Folders() at SAS.OfficeAddin.ManageFavoritesForm.PopulateRepositoryTreeView() at SAS.OfficeAddin.ManageFavoritesForm.InitializeTreeView(RegistryKey settingsKey) at SAS.OfficeAddin.ManageFavoritesForm..ctor(IOfficeAddin addin, ContentMode mode) at SAS.OfficeAddin.OfficeAddinBase.ManageFavoritesDialog(ContentMode mode) at SAS.OfficeAddin.UIManager.ButtonClickHandler(CommandBarButton sender, Boolean& bHandled)
To circumvent this problem, rename the duplicate folder name to a new name. When you do this, the SAS® Add-in will open the reports without errors.
A fix is available that will prevent this exception. This fix does not allow the use of duplicate folder names. If you wish to use a stored process in a duplicate folder, you will still need to rename the folder. To apply the fix and avoid the exception, click the Hot Fix tab in this note.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Add-in for Microsoft Office | Microsoft® Windows® for x64 | 2.1 | 4.2 | 9.2 TS2M0 | |
| Microsoft Windows 95/98 | 2.1 | |||||
| Microsoft Windows 2000 Advanced Server | 2.1 | |||||
| Microsoft Windows 2000 Datacenter Server | 2.1 | |||||
| Microsoft Windows 2000 Server | 2.1 | |||||
| Microsoft Windows 2000 Professional | 2.1 | |||||
| Microsoft Windows NT Workstation | 2.1 | |||||
| Microsoft Windows Server 2003 Datacenter Edition | 2.1 | 4.2 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 2.1 | 4.2 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Standard Edition | 2.1 | 4.2 | 9.2 TS2M0 | |||
| Microsoft Windows XP Professional | 2.1 | 4.2 | 9.2 TS2M0 | |||
| Windows Millennium Edition (Me) | 2.1 | |||||
| Windows Vista | 2.1 | 4.2 | 9.2 TS2M0 | |||