This fix resolves the following issues: 1. When IBM Platform Application Center is integrated with IBM Platform Analytics, a blank page is displayed when users click the Subscribed Users tab in a report. 2. The RESTful web service APIs to modify and assign user roles(/platform/ws/roles, /platform/ws/roles/assign) do not work. 3. After upgrading to version 9.1.4.2, duplicate roles exist for Administrator of user group group_name. 4. When IBM Platform Application Center is integrated with IBM Platform Analytics and HTTPS is enabled in Tableau, IBM Platform Application Center cannot load workbooks from the Tableau server.

Readme documentation for IBM Platform Application Center 9.1.4.2 Fix 386891 including installation-related instructions, prerequisites and co-requisites, and list of fixes.
This fix resolves the following issue:
- When IBM Platform Application Center is integrated with IBM Platform Analytics, a blank page is displayed when users click the Subscribed Usersstrong> tab in a report.
- The RESTful web service APIs to modify and assign user roles(/platform/ws/roles, /platform/ws/roles/assign) do not work.
- After upgrading to 9.1.4.2, duplicate roles exist for Administrator of user group group_name.
- When IBM Platform Application Center is integrated with IBM Platform Analytics and HTTPS is enabled in Tableau, IBM Platform Application Center cannot load workbooks from the Tableau server.

• List of fixes
• Download location
• Products or components affected
• System requirements
• Installation and configuration
• Uninstallation
• List of files
• Copyright and trademark information

• List of fixes

  APAR#: P101589 P101676 P101678 P101693

• Download location

  Download Fix 386891 from the following location: http://www.ibm.com/eserver/support/fixes/

• Affected components:

  - Reports.
  - RESTful web service.
  - Roles and Permissions.

• System requirements

  Linux_x86_64

• Installation and configuration
  • 5.1  Before installation

    Check and record the version and build number of IBM Platform Application Center. this is in case of rolling back the fix.

    pmcadmin -V
    

    Stop all IBM Platform Application Center services:

    perfadmin stop all
    pmcadmin stop
  • 5.2  Installation steps

    The following steps assume IBM Platform Application Center is installed in /opt/pac.
    Replace with your actual installation directory.

    • Installation steps for IBM Platform Application Center 9.1.4.2.
      • Determine the location of your existing IBM Application Center installation.
        #rpm -q --queryformat "%{INSTPREFIXES}\n" pcc-appcenter
      • Back up the existing:
        #cp -rfp /opt/pac /opt/pac.bak
      • Download the fix file: pac9.1.4.2_standard_linux-x64.tar.Z.
      • Extract pac9.1.4.2_standard_linux-x64.tar.Z.
      • As root, log on to your IBM Platform Application Center 9.1.4.2 host.
      • Set your IBM Platform Application Center environment:
        For csh or tcsh:
        % source /opt/pac/cshrc.platform
        For sh, ksh, or bash:
        $ . /opt/pac/profile.platform
      • Install the fix.
        rpm -Uvh --prefix ${PAC_TOP} --nopreun pcc-appcenter-9.1.4.2-386891.x86_64.rpm
        Note: Replace ${PAC_TOP} with your actual installation directory.
      • Delete duplicate role in database.
        • MySQL:

          /usr/bin/mysql --user=root --password=PASSWORD pac < $PMC_TOP/gui/DBschema/MySQL/removeDuplicateRoleData.sql

        • Oracle: logon oracle database using client, for example sqlplus.
          SQL > @$PMC_TOP/gui/DBschema/MySQL/removeDuplicateRoleData.sql

  • 5.3  Start IBM Platform Application Center services.

    perfadmin start all
    pmcadmin start

• Uninstallation
  • 6.1  Before uninstallation

    Stop all IBM Platform Application Center services:

    perfadmin stop all
    pmcadmin stop
  • 6.2  Roll back the fix

    The following steps assume IBM Platform Application Center is installed in /opt/pac.
    Replace with your actual installation directory.

    • Determine the location of your existing IBM Application Center installation.
      #rpm -q queryformat %{INSTPREFIXES}\n pcc-appcenter
    • Download the RPM package for a version previous to the Fix, for example, pcc-appcenter-9.1.4.2-123456.x86_64.rpm.
    • Set your IBM Platform Application Center environment:
      For csh or tcsh:
      % source /opt/pac/cshrc.platform
      For sh, ksh, or bash:
      $ . /opt/pac/profile.platform
    • Install the IBM Platform Application Center RPM package. For example:
      #rpm -Uvh --prefix ${PAC_TOP} --oldpackage --nopreun --noscripts pcc-appcenter-9.1.4.2-123456.x86_64.rpm.
    • If you have made any customizations, reapply your customizations from the backup directory.
    • Start IBM Platform Application Center services
      perfadmin start all
      pmcadmin start
    • Clear your browser cache before logging into IBM Platform Application Center.
      This is required on every browser that will access IBM Platform Application Center. Otherwise, IBM Platform Application Center will not work properly.
• List of files
  

  $PAC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/pa/js/wbReportSubUsers.js
  $PAC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/pws/webservice/impl/RBACWebServieImpl.class
  $PAC_TOP/gui/DBschema/MySQL/Patch/pac912_to_913.sql
  $PAC_TOP/gui/DBschema/MySQL/Patch/removeDuplicateRoleData.sql
  $PAC_TOP/gui/DBschema/Oracle/Patch/pac912_to_913.sql
  $PAC_TOP/gui/DBschema/Oracle/Patch/removeDuplicateRoleData.sql
  

• Copyright and trademark information

  ©Copyright IBM Corporation 2016
  
  U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
  
  IBM®, the IBM logo and ibm.com® are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml