The following error might occur when exporting a dimension in SAS Financial Management Studio if the DDS or StageDDS libraries are not assigned to the SASMain server in the metadata:
com.sas.solutions.SASSolutionsException: An error occurring while attempting to export members.
at com.sas.solutions.finance.app.metadata.commands.ExportDimensionCommand.onConstruct(ExportDimensionCommand.java:69)
at com.sas.solutions.finance.app.commands.FinanceCommand.construct(FinanceCommand.java:296)
at com.sas.solutions.app.util.SwingWorker.construct(SwingWorker.java:50)
at com.sas.solutions.app.util.AbstractSwingWorker$2.run(AbstractSwingWorker.java:113)
at java.lang.Thread.run(Thread.java:534)
Caused by: 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.finance.app.metadata.commands.ExportDimensionCommand.onConstruct(ExportDimensionCommand.java:66)
... 4 more
Caused by: com.sas.solutions.etl.client.ETLException: export() - u:CFO - Error during export of Dimensional Metadata.
at com.sas.solutions.etl.metadata.ejb.DimensionExportManagerBean.handleAndRethrow(DimensionExportManagerBean.java:1908)
at com.sas.solutions.etl.metadata.ejb.DimensionExportManagerBean.export(DimensionExportManagerBean.java:246)
at com.sas.solutions.etl.metadata.ejb.DimensionExportManager_30r3sm_ELOImpl.export(DimensionExportManager_30r3sm_ELOImpl.java:46)
at com.sas.solutions.etl.metadata.ejb.ExecuteMessageDrivenBean.onMessage(ExecuteMessageDrivenBean.java:185)
at weblogic.ejb20.internal.MDListener.execute(MDListener.java:370)
at weblogic.ejb20.internal.MDListener.onMessage(MDListener.java:262)
at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:2678)
at weblogic.jms.client.JMSSession.execute(JMSSession.java:2598)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:219)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:178)
Caused by: com.sas.solutions.data.client.DataException: com.sas.solutions.SASSolutionsException: java.io.IOException
at com.sas.solutions.data.client.ConnectionDelegate.getConnectionProperties(ConnectionDelegate.java:33)
at com.sas.solutions.data.locator.ConnectionLocator.getConnection(ConnectionLocator.java:92)
at com.sas.solutions.data.locator.ConnectionLocator.getConnection(ConnectionLocator.java:73)
at com.sas.solutions.etl.metadata.util.ETLHelper.getConnection(ETLHelper.java:93)
at com.sas.solutions.etl.metadata.ejb.DimensionExportManagerBean.openConnections(DimensionExportManagerBean.java:1689)
at com.sas.solutions.etl.metadata.ejb.DimensionExportManagerBean.export(DimensionExportManagerBean.java:195)
... 8 more
Caused by: com.sas.solutions.SASSolutionsException: java.io.IOException
at com.sas.solutions.data.ejb.DataManagerBean.getConnectionProperties(DataManagerBean.java:70)
at com.sas.solutions.data.ejb.DataManager_g1ddsg_EOImpl.getConnectionProperties(DataManager_g1ddsg_EOImpl.java:46)
at com.sas.solutions.data.client.ConnectionDelegate.getConnectionProperties(ConnectionDelegate.java:29)
... 13 more
Caused by: java.io.IOException
at com.sas.solutions.data.cache.OMRTableMetaDataCache.getTableMetaData(OMRTableMetaDataCache.java:359)
at com.sas.solutions.data.cache.OMRDataSourceCache.getDataSourceName(OMRDataSourceCache.java:125)
at com.sas.solutions.data.cache.OMRDataSourceCache.getConnectionProperties(OMRDataSourceCache.java:86)
at com.sas.solutions.data.ejb.DataManagerBean.getConnectionProperties(DataManagerBean.java:66)
... 15 more
Follow these steps to determine if an incorrect assignment is the cause of the error:
Product Family | Product | System | Product Release | SAS Release | ||
Reported | Fixed* | Reported | Fixed* | |||
SAS System | SAS Financial Management | Microsoft Windows 2000 Advanced Server | 4.4 | 9.1 TS1M3 SP4 | ||
Microsoft Windows 2000 Datacenter Server | 4.4 | 9.1 TS1M3 SP4 | ||||
Microsoft Windows 2000 Server | 4.4 | 9.1 TS1M3 SP4 | ||||
Microsoft Windows 2000 Professional | 4.4 | 9.1 TS1M3 SP4 | ||||
Microsoft Windows NT Workstation | 4.4 | 9.1 TS1M3 SP4 | ||||
Microsoft Windows Server 2003 Datacenter Edition | 4.4 | 9.1 TS1M3 SP4 | ||||
Microsoft Windows Server 2003 Enterprise Edition | 4.4 | 9.1 TS1M3 SP4 | ||||
Microsoft Windows Server 2003 Standard Edition | 4.4 | 9.1 TS1M3 SP4 | ||||
Microsoft Windows XP Professional | 4.4 | 9.1 TS1M3 SP4 | ||||
Windows Vista | 4.4 | 9.1 TS1M3 SP4 | ||||
64-bit Enabled AIX | 4.4 | 9.1 TS1M3 SP4 | ||||
64-bit Enabled Solaris | 4.4 | 9.1 TS1M3 SP4 |
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2010-02-15 11:33:35 |
Date Created: | 2010-02-10 13:43:55 |