Patch-ID# 118093-03
Keywords: pivot table pdf
Synopsis: N1 Grid Engine 6.0: maintenance patch
Date: Jan/19/2005


Install Requirements: Additional instructions may be listed below                      
                      
Solaris Release: 7 8 9

SunOS Release: 5.7 5.8 5.9

Unbundled Product: N1 Grid Engine

Unbundled Release: 6.0

Xref: See patch matrix below

Topic: 

Relevant Architectures: all

BugId's fixed with this patch: 5059680 5069875 5073716 5078872 5085393 5090714 5095932 5099452 5107410 5107953 6211775 6212102

Changes incorporated in this version: 6211775 6212102

Patches accumulated and obsoleted by this patch: 

Patches which conflict with this patch: 

Patches required with this patch: 

Obsoleted by: 

Files included with this patch: 

<install_dir>/dbwriter/database/oracle/dbdefinition.xml
<install_dir>/dbwriter/database/postgres
<install_dir>/dbwriter/database/postgres/dbdefinition.xml
<install_dir>/dbwriter/database/postgres/dbwriter.xml
<install_dir>/dbwriter/database/postgres/drop.sql
<install_dir>/dbwriter/inst_dbwriter
<install_dir>/dbwriter/inst_util.sh
<install_dir>/dbwriter/lib/dbwriter.jar
<install_dir>/dbwriter/lib/jaxb-impl.jar
<install_dir>/dbwriter/lib/postgresql-7.4.2.jar
<install_dir>/dbwriter/util/sgedbwriter_template
<install_dir>/reporting/WEB-INF/lib/jaxb-impl.jar
<install_dir>/reporting/WEB-INF/lib/reporting.jar
<install_dir>/reporting/arcorun
<install_dir>/reporting/database/example_queries/oracle/Accounting_per_User.xml
<install_dir>/reporting/database/example_queries/oracle/Average_Job_Turnaround_Time.xml
<install_dir>/reporting/database/example_queries/oracle/Number_of_Jobs_completed.xml
<install_dir>/reporting/database/example_queries/postgres/Accounting_per_Project.xml
<install_dir>/reporting/database/example_queries/postgres/Accounting_per_User.xml
<install_dir>/reporting/database/example_queries/postgres/Average_Job_Turnaround_Time.xml
<install_dir>/reporting/database/example_queries/postgres/Average_Job_Wait_Time.xml
<install_dir>/reporting/database/example_queries/postgres/Number_of_Jobs_completed.xml
<install_dir>/reporting/database/example_queries/postgres/Statistics.xml
<install_dir>/reporting/html/en/version.txt
<install_dir>/reporting/html/en/versionDate.txt
<install_dir>/reporting/images
<install_dir>/reporting/images/logo.gif
<install_dir>/reporting/images/logo_sge.gif
<install_dir>/reporting/images/poppel.png
<install_dir>/reporting/inst_reporting
<install_dir>/reporting/inst_util.sh
<install_dir>/reporting/jsp/reportingmodule/SaveQuery.jsp
<install_dir>/reporting/util/app-2.0.xml
<install_dir>/reporting/util/app-2.1.xml
<install_dir>/reporting/util/app-2.2.xml
<install_dir>/reporting/util/config.xml.template
<install_dir>/reporting/xslt/result2csv.xsl

Problem Description:

6211775   dbwriter's auto derived rules do not work for oracle
6212102   dbwriter's deletion rules for oracle do not work
 
(from 118093-02)
5090714 grid engine install relies on location of lockhart jars to be fixed 
5095932 Deleting outdated records with dbwriter does not work 
5099452 Missing newlines in the csv export of query results 
5107410 dbwriter generated incorrect derived values 
5107953 Export of results with null values fails 
 
(from 118093-01)
5059680 inst_dbwriter: database check (PostgreSQL) fails with empty passwd
5069875 can't specify late binding parameters with advanced query
5073716 Several predefined queries are not working ("Sorry - No Data")
5078872 Queries on view_job_times doesn't return any data, queries on view_accounting re
5085393 cannot export pivot tables in PDF

Patch Installation Instructions:
--------------------------------
 
tar.gz Patch Installation:
--------------------------
 
   See the patch installation instructions below before installing this
   patch!
 
   Patches in 'tar.gz' format cannot be installed with 'patchadd' on Solaris
   systems. The patch is installed by unpacking the 'tar.gz' file(s) in this
   directory in <install_dir>. <install_dir> is usually your <sge_root>
   directory. The installation of this patch later is not visible with the
   "showrev -p" command on Solaris.
 
   This patch cannot be backed out. You may want to make a backup copy of the
   files  before installing this patch since the files will be overwritten.
 
   Please read "Install Instructions" later in this file and carry out all
   steps before you unpack the 'tar.gz' file(s) included in this patch.
 
   This patch in 'tar.gz' format should not be installed if the original
   package has been installed with 'pkgadd' on Solaris. If the orginal 
   installation used packages ('pkgadd') utility, install the available 
   patches for N1 Grid Engine 6; refer to the patch matrix below.
 
   The patch is installed by user root by unpacking the file(s) in the
   directory where the original package has been installed:
 
      # cd <install_dir>
      # gzip -dc <patchid>/<targzfile> | tar xvpf -
 
   After installing the patch, you should correct the file permissions if
   your Sun Grid Engine installation is installed as an "admin user" system:
 
      # cd <sge_root>
      # util/setfileperm.sh <sge_root>
 
 
Files to be deleted
-------------------
 
   The following files of the original packages are obsolete and should to
   be deleted after the installation of the patch:
 
   1.1 6.0 -> 6.0u1
   ----------------
 
   dbwriter/database/oracle/privileges.sql
   dbwriter/database/oracle/setup.sql dbwriter/database/oracle/view.sql
   dbwriter/database/postgres/privileges.sql
   dbwriter/database/postgres/setup.sql dbwriter/database/postgres/view.sql
   dbwriter/lib/pg73jdbc2.jar
 
   1.2 6.0u1 -> 6.0u2
   ------------------
 
   dbwriter/updatedb.sh
   dbwriter/lib/dbwriter.conf_template
   dbwriter/lib/mysql-connector-java-3.0.9-stable-bin.jar
   reporting/app.xml
   reporting/cmdln_conf.xml
   reporting/cmdln_config.dtd
   reporting/config.dtd
   reporting/config.xml.template
   reporting/WEB-INF/lib/i18n.jar
   reporting/database/example_queries/results
   reporting/doc/cmdln_conf.xml
   reporting/html/en/example_app.html
   reporting/jsp/error.jsp
 
 
Patch requirements and patch matrix for N1 Grid Engine 6 packages
-----------------------------------------------------------------
 
   The patches below update a N1 Grid Engine 6 distribution to N1 Grid
   Engine 6 Update 2. The "-help" output of most commands will print a
   version string "N1GE 6.0u2" after applying the patch.
 
   All packages of a N1 Grid Engine 6 distribution must have the same patch
   level. Refer to the patch matrix below which updates the distribution to
   most recent patch level. It is not supported to mix different patch
   levels in a single Grid Engine cluster. Also, make sure to update the
   "common" and "arco" packages.
 
   1. Patches for Packages in Sun pkgadd format
   --------------------------------------------
 
      Package name*   OS*                    Architecture*    Patch-Id
      -----------------------------------------------------------------
      SUNWsgee        Solaris, Sparc, 32bit  sol-sparc        118094-03
      SUNWsgeex       Solaris, Sparc, 64bit  sol-sparc64      118130-03
      SUNWsgeex       Solaris x86            sol-x86          118131-03  
      SUNWsgeec       all                    common           118132-03
      SUNWsgeea       all                    arco             118133-03
 
      *Package Name = see pkginfo(1) 
      *OS           = Operating system
      *Architecture = N1 Grid Engine binary architecture string or
                      "common" = architecture independent packages
                      "arco"   = Accounting and Reproting console
 
   2. Patches for packages in tar.gz format
   ----------------------------------------
 
      OS*                        Architecture     Patch-Id
      -----------------------------------------------------
      Solaris, Sparc, 32bit      sol-sparc        118082-03
      Solaris, Sparc, 64bit      sol-sparc64      118083-03
      Solaris, x86               sol-x86          118084-03
      Linux kernel2.4/2.6, x86   lx24-x86         118085-03
      Linux kernel2.4/2.6, AMD64 lx24-amd64       118086-03
      IBM AIX 4.3                aix43            118087-03
      IBM AIX 5.1                aix51            118088-03
      Apple MAC OS/X             darwin           118089-03
      HP HP-UX 11                hp11             118090-03
      SGI Irix 6.5               irix65           118091-03
      all                        common           118092-03
      all                        arco             118093-03

Special Install Instructions:
-----------------------------
 
   This patch for the Accounting and Reporting Console (ARCo) should
   be installed with the corresponding binary patches and patches for the
   "common" package. See the patch matrix above and the patch installation
   instructions in the README files of the binary patches and "common" patch
   for more information.
 
 
Stopping the Accounting and Reporting Console
---------------------------------------------
 
   1. Stop the Sun Web Console[TM]
 
   /usr/sbin/smcwebserver stop
 
   2. Stop the dbwriter daemon
 
   <sge_root>/dbwriter/bin/sgedbwriter stop
 
 
Patch installation
------------------
 
   The patch now should be installed as outlined in the "Patch Installation"
   section above
 
Required steps after patch installation
---------------------------------------
 
   1. Reinstall the dbwriter as user <admin_user>
 
   % cd <sge_root>/dbwriter
   % ./inst_dbwriter
 
   2. Start the dbwriter
 
   % <sge_root>/dbwriter/bin/sgedbwriter start
 
   3. Reinstall the ARCo reporting module as user root
 
   # cd <sge_root>/reporting
   # ./inst_reporting.sh
 
New functionality delivered with this patch
-------------------------------------------
 
   1. Installation improvments
   ---------------------------
 
   The installation of ARCo has been improved. During the installation of
   the dbwriter, the version of the database model will be checked and
   updated. The manual execution of the supplied SQL scripts is no longer
   necessary. This obsoletes the following steps in the N1GE6 Installation
   guide:
 
      - page 92 step 4 and 6
      - page 93 steps 4, 5 and 6
 
 
   2. New features
   ---------------
 
   5085393: Pivot Tables can now be exported in PDF documents.
 
   5069875: The late binding mechanism for advanced queries is now
            implemented.
 
            The syntax for the late bindings in advanced queries is:
 
               LATEBINDING{ <column>;<operator>;<default value> }
 
               <column>    must be a valid column of the query
               <operator>  a SQL operator (e.g. = < > in .. )
               <value>     default value (e.g. 'localhost' )
 
            Examples:
            ---------
 
               select hostname
               from sge_host
               where LATEBINDING{hostname, like, 'a%'}
 
               select hostname
               from sge_host
               where LATEBINDING{hostname, in, ('localhost', 'foo.bar') }
 
  - ARCo reporting module now supports SWC 2.0.3, 2.1 and 2.2
 
     Even though the Sun Web Console, version 2.0.3, is delivered with the N1[TM]
     Grid Engine 6, the reporting module also works with Version 2.1 and 2.2.
 
  - Display images with relative imageURLs
 
     Image URLs can now be defined relative to <WEB_APP_ROOT>/images.
     <WEB_APP_ROOT> depends on the Sun Web Console Version:
 
           SWC 2.0.x:   /usr/share/webconsole/reporting/images
           SWC 2.1.x:   /var/opt/webconsole/reporting/images
           SWC 2.2:     /var/opt/webconsole/reporting/images
 
     If no imageURL is defined for a query a default image will be displayed. 
     The example queries which have been delivered with N1GE6.0 and N1GE6.0u1
     have default imageURLs which point to
     https://<host>:6789/reporting/images/. Delete this URL from the queries
     and the default image will be displayed.

README -- Last modified date:  Wednesday, January 19, 2005

