BookmarkSubscribeRSS Feed
Slash
Quartz | Level 8

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 ]

7 REPLIES 7
Madelyn_SAS
SAS Super FREQ

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
Quartz | Level 8

Thanks! I try that tomorrow! Smiley Happy

PaulHomes
Rhodochrosite | Level 12

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
Quartz | Level 8

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

Slash
Quartz | Level 8

I directly access the library

twocanbazza
Quartz | Level 8

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
Quartz | Level 8

Thanks, I would like try that!

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 2321 views
  • 0 likes
  • 4 in conversation