WRS cannot open the data which from oracle database

Slash — Wed, 26 Feb 2014 07:27:14 GMT

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 ]

Re: WRS cannot open the data which from oracle database

Madelyn_SAS — Wed, 26 Feb 2014 14:12:58 GMT

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.

Re: WRS cannot open the data which from oracle database

Slash — Wed, 26 Feb 2014 14:21:55 GMT

Thanks! I try that tomorrow!

Re: WRS cannot open the data which from oracle database

PaulHomes — Wed, 26 Feb 2014 23:21:41 GMT

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

Re: WRS cannot open the data which from oracle database

twocanbazza — Thu, 27 Feb 2014 20:59:45 GMT

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

Re: WRS cannot open the data which from oracle database

Slash — Sat, 01 Mar 2014 12:42:09 GMT

I directly access the library

Re: WRS cannot open the data which from oracle database

twocanbazza — Sun, 02 Mar 2014 21:13:48 GMT

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

Re: WRS cannot open the data which from oracle database

Slash — Tue, 04 Mar 2014 04:51:18 GMT

Thanks, I would like try that!

topic Re: WRS cannot open the data which from oracle database in SAS Web Report Studio

WRS cannot open the data which from oracle database

Re: WRS cannot open the data which from oracle database

Re: WRS cannot open the data which from oracle database

Re: WRS cannot open the data which from oracle database

Re: WRS cannot open the data which from oracle database

Re: WRS cannot open the data which from oracle database

Re: WRS cannot open the data which from oracle database

Re: WRS cannot open the data which from oracle database