Problem Note 42907: "SAS Workspace is not usable" exception might occur in the SAS® Add-In for Microsoft Office when running a task on PivotTable data
When you attempt to run a task on PivotTable data using the SAS Add-in for Microsoft Office, you might receive an exception such as the following:
An unexpected error occurred in the task.
[Details]
System.Exception: SAS Workspace is not usable! ---> SAS.EG.SDS.SDSException:
Class not registered
---> System.Runtime.InteropServices.COMException: Class not registered
at SASObjectManager.ObjectFactoryMulti2Class.CreateObjectByServer(String
Name, Boolean synchronous, ServerDef pIServerDef, String LoginName, String
Password)
at SAS.EG.SDS.Model.Server.Connect(ConnectionInfo connInfo)
--- End of inner exception stack trace ---
at SAS.EG.SDS.Model.Server.Connect(ConnectionInfo connInfo)
at SAS.EG.SDS.Model.Server.SASWorkspace()
at SAS.Tasks.Toolkit.SasServer.ConnectToWorkspace()
--- End of inner exception stack trace ---
at SAS.Tasks.Toolkit.SasServer.ConnectToWorkspace()
at SAS.Tasks.Toolkit.Data.SasLibrary..ctor(String server, String libref)
at SAS.EG.Tasks.TaskSDK.TaskModel.ProcessInputData(FilterSettings
filterSettings)
at SAS.EG.Tasks.TaskSDK.TaskModel.Connect(ISASTaskConsumer consumer)
at SAS.Shared.AddIns.Management.AddInProxy.Connect(ISASTaskConsumer Consumer)
at SAS.OfficeAddin.Task.PrepareEGTask(EGTaskInfo taskInfo, Boolean
showDialog, Boolean delayProxyCleanup)
This error might occur when you are unable to connect to your server. This error also can occur when the PivotTable data is being retrieved from a server other than your default server. In either case, ensure that your server is running and accessible.
Operating System and Release Information
| SAS System | SAS Add-in for Microsoft Office | Microsoft® Windows® for x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 for x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows XP Professional | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Enterprise 32 bit | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Enterprise x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Home Premium 32 bit | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Home Premium x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Professional 32 bit | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Professional x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Ultimate 32 bit | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows 7 Ultimate x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows Vista | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Windows Vista for x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2011-04-13 13:13:11 |
| Date Created: | 2011-04-11 13:36:58 |
