Traditional web-based reporting with SAS BI tools

WRS cannot open the data which from oracle database

Reply
Contributor
Posts: 55

WRS cannot open the data which from oracle database

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:

QQ截图20140226151031.jpg

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 ]

SAS Super FREQ
Posts: 381

Re: WRS cannot open the data which from oracle database

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.

Contributor
Posts: 55

Re: WRS cannot open the data which from oracle database

Thanks! I try that tomorrow! Smiley Happy

Super Contributor
Posts: 364

Re: WRS cannot open the data which from oracle database

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

Super Contributor
Posts: 356

Re: WRS cannot open the data which from oracle database

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

Contributor
Posts: 55

Re: WRS cannot open the data which from oracle database

I directly access the library

Super Contributor
Posts: 356

Re: WRS cannot open the data which from oracle database

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

Contributor
Posts: 55

Re: WRS cannot open the data which from oracle database

Thanks, I would like try that!

Post a Question
Discussion Stats
  • 7 replies
  • 1498 views
  • 0 likes
  • 4 in conversation