SAS FM Dimension export error.

[deleted_user]

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

[GertNissen]

Have a look at http://support.sas.com/kb/38/690.html