BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hello, we recieve an unknown error when trying to export dimension into a SAS Base Engine library.

Here is the screenshot of error message:
http://img25.imageshack.us/img25/5605/fmerrorfs4.jpg

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
1 REPLY 1
LinusH
Tourmaline | Level 20
I believe SAS tech support is a better choice for solving these kind of issues.

Regards,
Linus
Data never sleeps

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 851 views
  • 0 likes
  • 2 in conversation