This fix resolves issues with the sychronization process between Application Center and LSF so that it takes less time and the PMC_ROLE_PERMISSION table no longer has too many records after the sychronization task is complete.

Readme file for IBM Spectrum LSF Application Center 9.1.4.2 Fix 474919 including installation-related instructions, prerequisites and co-requisites, and list of fixes.
This fix resolves the following issues:
- The synchronization process between Application Center and LSF is time-consuming.
- Too many records in the PMC_ROLE_PERMISSION table after the synchronization task is complete.

Readme file for: IBM® Spectrum LSF Application Center
Product/Component Release: 9.1.4.2
Update Name: Fix 474919
Fix ID: pac9.1.4.2-build474919
Publication date: 25 November 2017
Last modified date: 25 November 2017

• 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#: P102342

• Download location

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

• Affected components

  - System & Settings
  - Users & Groups
  - Roles & Permissions
  - Database

• System requirements

  Linux_x86_64

• Installation and configuration
  • 5.1  Before installation
    • Log on to the IBM Spectrum LSF Application Center server host as root.
    • Set your IBM Spectrum LSF Application Center environment.
      For csh or tcsh:
      % source /opt/pac/cshrc.platform
      For sh, ksh, or bash:
      $ . /opt/pac/profile.platform
    • Determine the location of your existing IBM Spectrum LSF Application Center installation.
      rpm -q --queryformat "%{INSTPREFIXES}\n" pcc-appcenter
    • Check and record the version and build number of your existing installation of IBM Spectrum LSF Application Center in case you need to roll back the fix.
      pmcadmin -V
    • Stop all IBM Spectrum LSF Application Center services.
      perfadmin stop all
      pmcadmin stop
    • Back up your existing installation.
      For example:
      cp -rfp /opt/pac /opt/pac.bak
      
    • Back up your existing databases.
      For example:
      /usr/bin/mysqldump -u root -p pac > /opt/PAC-Backup.sql
      
  • 5.2  Installation steps for IBM Spectrum LSF Application Center 9.1.4.2

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

    • As root, log on to your IBM Spectrum LSF Application Center 9.1.4.2 host.
    • Extract pac9.1.4.2_standard_linux-x64.tar.Z.
      tar -xzvf pac9.1.4.2_standard_linux-x64.tar.Z
    • Enter the extracted directory.
      cd pac9.1.4.2_standard_linux-x64
    • Set your IBM Spectrum LSF Application Center environment.
      For csh or tcsh:
      % source /opt/pac/cshrc.platform
      For sh, ksh, or bash:
      $ . /opt/pac/profile.platform
    • Install the Fix Pack
      rpm -Uvh --prefix ${PAC_TOP} --nopreun pcc-appcenter-9.1.4.2-474919.x86_64.rpm
      Note: Replace ${PAC_TOP} with your actual installation directory.
    • Extract pcc-appcenter-9.1.4.2-dbschema.tar
      tar -xvf pcc-appcenter-9.1.4.2-dbschema.tar
    • Update the database
      /usr/bin/mysql --user=root --password=${MYSQL_ROOT_PASSWORD} -e "use ${DBNAME}; source DBschema/MySQL/Patch/removeUnusedRolePermissionRecords.sql;"
      Note: Replace ${MYSQL_ROOT_PASSWORD} with your database password for root and replace ${DBNAME} with your actual database name.
    • Start IBM Spectrum LSF Application Center services.
      perfadmin start all
      pmcadmin start
• Uninstallation
  • 6.1  Before uninstallation

    Stop all IBM Spectrum LSF Application Center services:

    perfadmin stop all
    pmcadmin stop
  • 6.2  Roll back the fix

    The following steps assume IBM Spectrum LSF 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 Spectrum LSF Application Center environment:
      For csh or tcsh:
      % source /opt/pac/cshrc.platform
      For sh, ksh, or bash:
      $ . /opt/pac/profile.platform
    • Install the IBM Spectrum LSF Application Center RPM package. For example:
      rpm -Uvh --prefix ${PAC_TOP} --oldpackage --nopreun pcc-appcenter-9.1.4.2-123456.x86_64.rpm
    • Roll back the database
      /usr/bin/mysql -u root -p ${DBNAME} < /opt/PAC-Backup.sql
      Note: Replace backup sql file with your actual backup sql file and replace ${DBNAME} with your actual database name.
    • If you have made any customizations, reapply your customizations from the backup directory.
    • Start IBM Spectrum LSF Application Center services
      perfadmin start all
      pmcadmin start
    • Clear your browser cache before logging in to IBM Spectrum LSF Application Center.
      This is required on every browser that accesses IBM Spectrum LSF Application Center. Otherwise, IBM Spectrum LSF Application Center does not work properly.
• List of files
  

  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/spring-security-pac.xml
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/framework/security/action/UserRoleAction.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/framework/security/action/UsersGroupsAction$1.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/framework/security/action/UsersGroupsAction$2.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/framework/security/action/UsersGroupsAction.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/framework/security/dao/ResourcePermissionDao.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/framework/security/dao/RolePermissionDao.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/framework/security/dao/impl/ResourcePermissionDaoImpl.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/framework/security/dao/impl/RolePermissionDaoImpl.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/framework/security/service/ResourcePermissionService.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/framework/security/service/impl/ResourcePermissionServiceImpl.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/framework/security/service/impl/RolePermissionServiceImpl.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/pa/security/resource/WorkbookResourceProvider.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/pa/service/WorkbookService$1.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/pa/service/WorkbookService$2.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/pa/service/WorkbookService$3.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/pa/service/WorkbookService.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/pac/application/util/ApplicationTemplateACLUtil.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/pac/pacwebservice/WSPermissionUtil.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/pac/security/resource/ApplicationTemplatesResourceGroupProvider.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/pac/security/resource/CustomSubmissionFormResourceGroupProvider.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/pac/security/resource/FlowDefResourceGroupProvider.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/pac/security/resource/FlowInsResourceGroupProvider.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/pac/security/resource/JobsResourceGroupProvider.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/pac/security/resource/ServiceResourceGroupProvider.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/pac/security/sync/MixedSynchronizeServiceImpl.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/WEB-INF/classes/com/platform/gui/pac/security/sync/ResourceSynchronizeServiceImpl.class
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/framework/security/editRolePermission.jsp
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/framework/security/userRolePermission.jsp
  $PMC_TOP/gui/3.0/wlp/usr/servers/platform/apps/platform.war/framework/security/js/userRoleList.js
  $PMC_TOP/gui/DBschema/MySQL/init.sql
  $PMC_TOP/gui/DBschema/MySQL/Patch/removeUnusedRolePermissionRecords.sql
  $PMC_TOP/gui/DBschema/Oracle/init.sql
  $PMC_TOP/gui/DBschema/Oracle/Patch/removeUnusedRolePermissionRecords.sql
  $PMC_TOP/gui/DBschema/PostgreSQL/init.sql
  

• Copyright and trademark information

  ©Copyright IBM Corporation 2017
  
  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