WRS cannot open the data which from oracle database

[Slash]

Hi, guys!

     I have a big problem! I defined a Oracle Library in SMC, and use Information Map Studio to create a Information Map. So I want to use it in the WRS.

But When I open the WRS, select the data, the error display:

But EG and DI Studio both can access the library, except the WRS. (I use the same account!)

Can anybody give some help??? Thank you very much!

The Log: "SASWebReportStudio4.3.log" (%SAS_CONFIG%\Lev1\Web\Logs\SASWebReportStudio4.3.log)

This exception is being sent to the USER's BROWSER...

Root Cause:   com.sas.iquery.execution2.ExecutionException: 提交 SAS 代码时出错。

1          options Locale=zh_CN;

ERROR: Could not load /bam_olap/sas/SAS92/SASFoundation/9.2/sasexe/sasora (37 images loaded)

ERROR: ld.so.1: sas: fatal: /export/app/oracle/product/10.2.0/client_1/lib/libclntsh.so.10.1: Permission denied

2          LIBNAME DMLIB ORACLE  ADJUST_NCHAR_COLUMN_LENGTHS=NO DBCLIENT_MAX_BYTES=1 DBSERVER_MAX_BYTES=1  PATH=bamrac  SCHEMA=dm

2        ! USER=etl  PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ;

ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: 找到了映像“SASORA  ”，但不可加载。

ERROR: LIBNAME 语句出错。

  at com.sas.iquery.execution.instructions.SASSubmitHandler.execute(SASSubmitHandler.java:207)

  at com.sas.iquery.execution.instructions.AbstractSASSubmitInstruction.submitLanguageInstructions(AbstractSASSubmitInstruction.java:109)

  at com.sas.iquery.execution.instructions.AbstractSASSubmitInstruction.execute(AbstractSASSubmitInstruction.java:44)

  at com.sas.iquery.execution.instructions.AllocationInstruction.execute(AllocationInstruction.java:73)

  at com.sas.iquery.execution.instructions.ExecutionBlock.execute(ExecutionBlock.java:44)

  at com.sas.iquery.execution.ExecutionProcessor.execute(ExecutionProcessor.java:71)

  at com.sas.iquery.strategies.sas.oma.AbstractStrategy.prepareData(AbstractStrategy.java:219)

  at com.sas.iquery.strategies.sas.oma.AbstractStrategy.retrieveQueryResultMap(AbstractStrategy.java:278)

  at com.sas.iquery.strategies.sas.oma.AbstractStrategy.retrieveResultSet(AbstractStrategy.java:307)

  at com.sas.iquery.dataretrieval.QueryExecutor.execute(QueryExecutor.java:36)

  at com.sas.iquery.dataretrieval.SimpleQueryConnector.processIQI(SimpleQueryConnector.java:200)

  at com.sas.iquery.dataretrieval.QueryConnector.processIQI(QueryConnector.java:79)

  at com.sas.iquery.dataretrieval.SimpleQueryConnector.generateAndExecuteQuery(SimpleQueryConnector.java:166)

  at com.sas.iquery.dataretrieval.SimpleQueryConnector.retrieveQueryResultMap(SimpleQueryConnector.java:127)

  at com.sas.iquery.dataretrieval.SimpleQueryConnector.retrieveQueryResultMap(SimpleQueryConnector.java:189)

  at com.sas.report.render.models.data.ReportDataModel.performQuery(ReportDataModel.java:230)

  at com.sas.report.render.models.data.ReportDataModel.retrieveModel(ReportDataModel.java:221)

  at com.sas.report.render.models.data.ReportDataModel.retrieveModel(ReportDataModel.java:163)

  at com.sas.report.render.models.data.ReportDataModel.retrieveModel(ReportDataModel.java:319)

  at com.sas.report.render.models.data.ReportDataModel.retrieveModel(ReportDataModel.java:329)

  at com.sas.report.render.models.data.ReportDataModel.retrieveQueryResultMap(ReportDataModel.java:293)

  at com.sas.report.render.data.provider.ByGroupQueryConnectorDecorator.retrieveQueryResultMap(ByGroupQueryConnectorDecorator.java:44)

  at com.sas.storage.iquery.BusinessQueryAdapter.init(BusinessQueryAdapter.java:177)

  at com.sas.storage.iquery.BusinessQueryToTableModelAdapter.getColumnCount(BusinessQueryToTableModelAdapter.java:398)

  at com.sas.servlet.tbeans.tableview.BaseTableView.createDefaultColumnsFromModel(BaseTableView.java:416)

  at com.sas.servlet.tbeans.tableview.BaseTableView.setModel(BaseTableView.java:269)

  at com.sas.servlet.tbeans.tableview.html.TableViewComposite.setModel(TableViewComposite.java:361)

  at com.sas.report.render.view.html.adapters.table.TableAdapter.prepareData(TableAdapter.java:1183)

  at com.sas.apps.citation.view.tbeans.html.adapters.CitationTableAdapter.prepareData(CitationTableAdapter.java:43)

  at com.sas.report.render.view.html.adapters.table.TableAdapter.write(TableAdapter.java:1231)

  at com.sas.apps.citation.view.tbeans.html.adapters.WRSAjaxTableAdapter.writeCoreContent(WRSAjaxTableAdapter.java:36)

  at com.sas.apps.citation.view.tbeans.html.adapters.WRSAjaxAdapterHelper.doTrackedWrite(WRSAjaxAdapterHelper.java:265)

  at com.sas.apps.citation.view.tbeans.html.adapters.WRSAjaxAdapterHelper.writeCoreContent(WRSAjaxAdapterHelper.java:158)

  at com.sas.apps.citation.model.report.DataProvider$ViewElementProvider.doWriteContent(DataProvider.java:828)

  at com.sas.apps.citation.model.report.DataProvider.processData(DataProvider.java:454)

  at com.sas.apps.citation.model.report.DataProvider.getData(DataProvider.java:429)

  at com.sas.apps.citation.model.report.DataProvider.provideNonBatchData(DataProvider.java:167)

  at com.sas.apps.citation.model.report.ContentProvider$ViewElementProviderTask.run(ContentProvider.java:875)

  at com.sas.apps.citation.util.progress.AsyncCancellableHelper$MyRunnable.run(AsyncCancellableHelper.java:560)

  at com.sas.apps.citation.util.thread.WorkerThread.doCurrentWorkNow(WorkerThread.java:260)

  at com.sas.apps.citation.util.thread.WorkerThread.run(WorkerThread.java:307)

Which Caused: com.sas.apps.citation.webreport.RendererException: 呈现报表时出错 [ java.lang.IllegalStateException: 生成结果集时出错 [ com.sas.iquery.intelligentquery.IntelligentQueryException: 无法检索查询结果。 [ com.sas.report.render.models.DataConnectionException: 无法检索查询结果。 [ com.sas.iquery.dataretrieval.DataRetrievalException: 提交 SAS 代码时出错。

1          options Locale=zh_CN;

ERROR: Could not load /bam_olap/sas/SAS92/SASFoundation/9.2/sasexe/sasora (37 images loaded)

ERROR: ld.so.1: sas: fatal: /export/app/oracle/product/10.2.0/client_1/lib/libclntsh.so.10.1: Permission denied

2          LIBNAME DMLIB ORACLE  ADJUST_NCHAR_COLUMN_LENGTHS=NO DBCLIENT_MAX_BYTES=1 DBSERVER_MAX_BYTES=1  PATH=bamrac  SCHEMA=dm

2        ! USER=etl  PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ;

ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: 找到了映像“SASORA  ”，但不可加载。

ERROR: LIBNAME 语句出错。 [ com.sas.iquery.execution2.ExecutionException: 提交 SAS 代码时出错。

1          options Locale=zh_CN;

ERROR: Could not load /bam_olap/sas/SAS92/SASFoundation/9.2/sasexe/sasora (37 images loaded)

ERROR: ld.so.1: sas: fatal: /export/app/oracle/product/10.2.0/client_1/lib/libclntsh.so.10.1: Permission denied

2          LIBNAME DMLIB ORACLE  ADJUST_NCHAR_COLUMN_LENGTHS=NO DBCLIENT_MAX_BYTES=1 DBSERVER_MAX_BYTES=1  PATH=bamrac  SCHEMA=dm

2        ! USER=etl  PASSWORD=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ;

ERROR: The SAS/ACCESS Interface to ORACLE cannot be loaded. ERROR: 找到了映像“SASORA  ”，但不可加载。

ERROR: LIBNAME 语句出错。 ]  ]  ]  ]  ]

  at com.sas.apps.citation.model.report.ContentProvider.getViewElementContent(ContentProvider.java:799)

  at com.sas.apps.citation.model.report.RenderedReportModel.getRenderedViewElement(RenderedReportModel.java:491)

  at com.sas.apps.citation.model.report.WebReportRenderer.renderViewElement(WebReportRenderer.java:1290)

  at com.sas.apps.citation.controller.action.report.ReportControllerAction._processDrawElementCommand(ReportControllerAction.java:868)

  at com.sas.apps.citation.controller.action.report.ReportControllerAction.doPerform(ReportControllerAction.java:386)

  at com.sas.apps.citation.controller.action.CitationAction._execute(CitationAction.java:191)

  at com.sas.apps.citation.controller.action.CitationAction.execute(CitationAction.java:166)

  at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)

  [ 57 lines suppressed ]

[Madelyn_SAS]

Web Report Studio is  using the pooled workspace server credentials to access the data. Typically this is the log in for the SAS General Servers Group (sassrv). So, you need to give sassrv permissions to access the data.

[Slash]

Thanks! I try that tomorrow!

[PaulHomes]

As BIC_USER_3@SAS mentioned processing of a relational information map will be done in a SAS Pooled Workspace Server which is typically launched using the operating system identity sassrv (as directed during installation). You might also want to check the permissions on the Oracle client with respect to sassrv and it's operating system groups. From the error it looks like they are getting access denied when trying to open the shared library /export/app/oracle/product/10.2.0/client_1/lib/libclntsh.so.10.1

[twocanbazza]

When using EG, can you access the data using the information map or are you accessing the data/library directly... 

[Slash]

I directly access the library

[twocanbazza]

Then you are not testing like for like, try accessing through the information map from EG, as your information map may be using another server etc which may not have the same SAS products installed

[Slash]

Thanks, I would like try that!