TagInformation Delivery Portal

Fix for a [SanitizingRequestFilter] error in the SAS Information Delivery Portal

saslogo.gifI recently deployed the SAS Enterprise Business Intelligence Server on a brand-new AIX LPAR.  During my validation of the platform, I created a new stored process portlet and added it to my home page.  My test portlet then displayed the following error:

Error 500: javax.servlet.ServletException: Filter [SanitizingRequestFilter]: could not be initialized.

Here’s how it looked in the portlet:

9-24-2014 6.43.16 AM

I searched for the error at support.sas.com and found a Problem Note about an error very similar to mine.  This error can arise when SAS BI portlets (the stored process portlet is one of these) are deployed to a WebSphere application server.  During the configuration phase of my deployment, I specified that SAS should automatically deploy the web applications to WebSphere.  Configuration did complete successfully, creating two WebSphere profiles and an application server (SASServer1), and deploying all of the web applications.  An important file for the SAS BI portlets (sas.portlet.container.runtime.extensions.jar) did not get copied to WebSphere, however, and required manual intervention.

The fix is easy enough:

  1. Stop the SASServer1 application server
  2. Using the SAS installer account, copy the sas.portlet.container.runtime.extensions.jar file from the [SASCONFIG-DIR]/Lev1/Web/Staging/Exploded/sas.biportlets4.X.ear/lib directory to the [WEBSPHERE-HOME]/lib directory of the IBM WebSphere Application Server
  3. Start SASServer1

I logged back in to the Information Delivery Portal and my stored process portlet was happy and ready for a stored process:
A happy stored process portlet
Here are a couple of notes from the Problem Note:

  • These manual steps are required because of a limitation in the WebSphere application server
  • In UNIX operating environments, the JAR file must be copied using the same account that is used to install the WebSphere application server

SAS also provided a more time consuming fix which fixes the issue in the Problem Note if someone preferred to use the WebSphere Integrated Solutions Console.

I have run into this issue in versions 7.0.0.15, 8.5.0.2, and 8.5.5.3 of WebSphere.  I am running SAS EBI 9.3 Maintenance Release 2 with BI portlets 4.3.  I would also like to note that the steps I listed above were also included in the Instructions.html document located at [SASCONFIG-DIR]/Lev1/Documents directory in my environment.  It is created after a successful installation and configuration of the EBI environment.

Email this to someoneTweet about this on TwitterShare on LinkedInPin on PinterestShare on Google+Share on FacebookPrint this page

Locating the Log Files for the SAS 9.3 Middle Tier

SASI have been doing some maintenance recently on one of our SAS EBI installations and needed to review the logs generated by the middle tier.  At some point any BI administrator will have to do this, so here are the default locations, directly from SAS:

The log files for the SAS 9.3 middle tier are located in the following directories:

Application Servers

Red Hat JBoss

  • /JBoss-home-directory/server/SAS-JBoss-server/log/server.log
  • /JBoss-home-directory/server/SAS-JBoss-server/log/boot.log

Oracle WebLogic

  • If WebLogic is started as a service, a UNIX daemon, or a batch process, the location is
    /WebLogic-home-directory/user_projects/domains/domain/servers/managed-server/logs/server.log.
  • If WebLogic is started using the Node Manager, the location is
    /WebLogic-home-directory/user_projects/domains/domain/servers/managed-server/logs/server.out.

IBM WebSphere

  • /WebSphere-home-directory/AppServer/logs/server/SystemOut.log
  • /WebSphere-home-directory/AppServer/logs/server/SystemErr.log

WebDAV Server

  • SAS Content Server:
    /SAS-configuration-directory;/Lev1/Web/Logs/SASContentServer9.3.log

SAS Web Applications

  • SAS Admin:
    /SAS-configuration-directory/Lev1/Web/Logs/SASAdmin9.3.log
  • SAS BI Dashboard:
    /SAS-configuration-directory/Lev1/Web/Logs/SASBIDashboard4.3.log
    /SAS-configuration-directory/Lev1/Web/Logs/SASBIDashboardEventGen4.3.log
  • SAS BI Portlets:
    /SAS-configuration-directory/Lev1/Web/Logs/SASBIPortlets4.3.log
    /SAS-configuration-directory/Lev1/Web/Logs/SASJSR18RemotePortlets4.3.log
  • SAS BI Web Services:
    /SAS-configuration-directory/Lev1/Web/Logs/SASBIWebServicesforJava9.3.log
  • SAS Information Delivery Portal:
    /SAS-configuration-directory/Lev1/Web/Logs/SASPortal4.3.log
  • SAS Logon Manager:
    /SAS-configuration-directory/Lev1/Web/Logs/SASLogon9.3.log
  • SAS Package Viewer:
    /SAS-configuration-directory/Lev1/Web/Logs/SASPackageViewer4.3.log
  • SAS Preferences:
    /SAS-configuration-directory/Lev1/Web/Logs/SASPreferences9.3.log
  • SAS Remote Services:
    /SAS-configuration-directory/Lev1/Web/Logs/RemoteServices.log
  • SAS Shared Apps:
    /SAS-configuration-directory/Lev1/Web/Logs/SASSharedApps9.3.log
  • SAS Stored Processes Web Application:
    /SAS-configuration-directory/Lev1/Web/Logs/SASStoredProcess9.3.log
  • SAS Web Report Studio:
    /SAS-configuration-directory/Lev1/Web/Logs/SASWebReportStudio4.3.log
    Note: Beginning with the second maintenance release for SAS 9.3 (TS1M2), the log is named SASWebReportStudio.log
  • SAS Web Infrastructure Platform Client Access:
    /SAS-configuration-directory/Lev1/Web/Logs/SASWIPClientAccess9.3.log
  • SAS Web Infrastructure Platform Services:
    /SAS-configuration-directory/Lev1/Web/Logs/SASWIPServices9.3.log
  • SAS Web Infrastructure Platform SOAP Services:
    /SAS-configuration-directory/Lev1/Web/Logs/SASWIPSoapServices9.3.log
  • SAS Workflow Services:
    /SAS-configuration-directory/Lev1/Web/Logs/SASWorkflowServices9.3.log

In my case, I was looking for my Websphere application server logs.  And as I should have suspected, my System Admin did not have the application servers or the log directories installed in the typical locations, so I had to do a little hunting.

Email this to someoneTweet about this on TwitterShare on LinkedInPin on PinterestShare on Google+Share on FacebookPrint this page

ActiveX Graphs not Active in SAS Information Delivery Portal when Viewed with Internet Explorer

SAS Institute Inc.We are still running Internet Explorer version 6.0 in our organization.  When we open our dashboards that we have built in SAS Information Delivery Portal 1.1, the ActiveX graphs do not display detail information when we mouse over them.  The dashboards are running stored processes that output the graphs.  The easy solution is to left-click on the graph to activate it.  This is easy enough if you have one or two graphs on a page, but some of our dashboards include six or seven graphs, which isn’t hard either, it just leaves you thinking that you shouldn’t have to be doing it.  The graphs work perfectly when using Mozilla Firefox, which unfortunately is not our organization standard.  The problem is caused by one or more security patches that Microsoft has made available for Internet Explorer.  SAS Usage Note 17565 explains this in more detail:

Usage Note 17565: ACTIVEX, JAVA, and JAVAMETA graphs may not be active by default when displayed via Internet Explorer

After application of one or more Microsoft security patches/updates, ACTIVEX, JAVA, and JAVAMETA graphs are no longer active by default when displayed via Internet Explorer. This means that the pop-up options menu will not display when you right-mouse button on the graph.

The Microsoft security patches related to this issue include KB912812 and KB912945.

To activate the graph, left-mouse click on the graph. This will activate the current graph and enable use of the right-mouse button. Once the graph is active, flyover data tips will also now display correctly.

Email this to someoneTweet about this on TwitterShare on LinkedInPin on PinterestShare on Google+Share on FacebookPrint this page

© 2017 Technoleros

Theme by Anders NorénUp ↑