Exporting a dimension from SAS® Financial Management might fail if the SASMeta - Workspace server is selected before the SASAPP pooled workspace, workspace, and stored process servers in SAS Management Console Object Spawner Server properties.

In this case, the following error is displayed in the SAS Financial Management client.log:

02-15 15:23:18,089 [main][ERRORExportDimensionWizard] - com.sas.solutions.etl.client.ETLException:
at com.sas.solutions.etl.metadata.client.JMSDelegate.sendToServer(JMSDelegate.java:120)
at com.sas.solutions.etl.metadata.client.JMSDelegate.export(JMSDelegate.java:131)
at com.sas.solutions.etl.metadata.client.DimensionExportManagerDelegate.export(DimensionExportManagerDelegate.java:48)
at com.sas.solutions.rcp.dimensions.internal.ui.wizards.ExportDimensionWizard.finish(ExportDimensionWizard.java:123)
at com.sas.solutions.rcp.dimensions.internal.ui.wizards.ExportDimensionWizard$1.run(ExportDimensionWizard.java:88)
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
Caused by: com.sas.solutions.etl.client.ETLException: export() - u:sasadmfin - Error during export of Dimensional Metadata.
at com.sas.solutions.etl.metadata.ejb.DimensionExportManagerBean.handleAndRethrow(DimensionExportManagerBean.java:1955)
at com.sas.solutions.etl.metadata.ejb.DimensionExportManagerBean.export(DimensionExportManagerBean.java:283)
at com.sas.solutions.etl.metadata.ejb.DimensionExportManager_30r3sm_ELOImpl.export(DimensionExportManager_30r3sm_ELOImpl.java:63)
at com.sas.solutions.etl.metadata.ejb.ExecuteMessageDrivenBean.onMessage(ExecuteMessageDrivenBean.java:191)
at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:466)
at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:371)
at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:327)
at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4547)
at weblogic.jms.client.JMSSession.execute(JMSSession.java:4233)
at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3709)
at weblogic.jms.client.JMSSession.access$000(JMSSession.java:114)
at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5058)
at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:516)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
Caused by: java.sql.SQLException: Unable to establish a connection: Unable to return workspace. The application could not log on to the server "SASCWA:8591".
at com.sas.rio.MVALocalizedError.throwLocalizedException(MVALocalizedError.java:196)
 

To correct this problem:

1. Log in to SAS Management Console as the unrestricted user, typically sasadm@saspw.
2. Expand Server Manager.
3. Right-click Object Spawner and select Properties.
4. Select the Server tab.
5. Using the left arrow de-select SASMeta - Workspace Server to move it to the Available Servers list.
6. Using the right arrow select SASMeta - Workspace Server to move it to the bottom of the Selected Servers list.
7. Re-start the SAS Object Spawner.

Operating System and Release Information