Patch-ID# 118133-03 Keywords: pivot table pdf Synopsis: N1 Grid Engine 6.0: maintenance patch Date: Jan/19/2005 Install Requirements: None 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: /dbwriter/database/oracle/dbdefinition.xml /dbwriter/database/postgres /dbwriter/database/postgres/dbdefinition.xml /dbwriter/database/postgres/dbwriter.xml /dbwriter/database/postgres/drop.sql /dbwriter/inst_dbwriter /dbwriter/inst_util.sh /dbwriter/lib/dbwriter.jar /dbwriter/lib/jaxb-impl.jar /dbwriter/lib/postgresql-7.4.2.jar /dbwriter/util/sgedbwriter_template /reporting/WEB-INF/lib/jaxb-impl.jar /reporting/WEB-INF/lib/reporting.jar /reporting/arcorun /reporting/database/example_queries/oracle/Accounting_per_User.xml /reporting/database/example_queries/oracle/Average_Job_Turnaround_Time.xml /reporting/database/example_queries/oracle/Number_of_Jobs_completed.xml /reporting/database/example_queries/postgres/Accounting_per_Project.xml /reporting/database/example_queries/postgres/Accounting_per_User.xml /reporting/database/example_queries/postgres/Average_Job_Turnaround_Time.xml /reporting/database/example_queries/postgres/Average_Job_Wait_Time.xml /reporting/database/example_queries/postgres/Number_of_Jobs_completed.xml /reporting/database/example_queries/postgres/Statistics.xml /reporting/html/en/version.txt /reporting/html/en/versionDate.txt /reporting/images /reporting/images/logo.gif /reporting/images/logo_sge.gif /reporting/images/poppel.png /reporting/inst_reporting /reporting/inst_util.sh /reporting/jsp/reportingmodule/SaveQuery.jsp /reporting/util/app-2.0.xml /reporting/util/app-2.1.xml /reporting/util/app-2.2.xml /reporting/util/config.xml.template /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 118133-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 118133-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: -------------------------------- For Solaris 7, 8, and 9 releases, refer to the man pages for instructions on using 'patchadd' and 'patchrm' scripts provided with Solaris. Any other special or non-generic installation instructions should be described below as special instructions. The following example installs a patch to a standalone machine: example# patchadd /var/spool/patch/104945-02 The following example removes a patch from a standalone system: example# patchrm 104945-02 For additional examples please see the appropriate man pages. See the "Special Install Instructions" section below before installing this patch. 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 /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 % cd /dbwriter % ./inst_dbwriter 2. Start the dbwriter % /dbwriter/bin/sgedbwriter start 3. Reinstall the ARCo reporting module as user root # cd /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{ ;; } must be a valid column of the query a SQL operator (e.g. = < > in .. ) 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 /images. 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://:6789/reporting/images/. Delete this URL from the queries and the default image will be displayed. README -- Last modified date: Wednesday, January 19, 2005