The SAS Output Delivery System and reporting techniques

SAS FM Dimension export error.

Reply
N/A
Posts: 0

SAS FM Dimension export error.

Hello, we recieve an unknown error when trying to export dimension into a SAS Base Engine library.


Here is the full trackback of the error:
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:SAS Demo User - 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:103)
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:1693)
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.getSASLibraryConnectionProperties(OMRTableMetaDataCache.java:637)
at com.sas.solutions.data.cache.OMRDataSourceCache.getConnectionProperties(OMRDataSourceCache.java:99)
at com.sas.solutions.data.ejb.DataManagerBean.getConnectionProperties(DataManagerBean.java:66)
... 15 more
SAS Employee
Posts: 160

Re: SAS FM Dimension export error.

Ask a Question
Discussion stats
  • 1 reply
  • 192 views
  • 0 likes
  • 2 in conversation