Patch-ID# 118093-04 Keywords: pivot table pdf Synopsis: N1 Grid Engine 6.0: maintenance patch Date: Apr/28/2005 Install Requirements: Additional instructions may be listed below Solaris Release: 7 8 9 10 SunOS Release: 5.7 5.8 5.9 5.10 Unbundled Product: N1 Grid Engine Unbundled Release: 6.0 Xref: NOTE: See patch matrix below Topic: Relevant Architectures: all BugId's fixed with this patch: 5059680 5069875 5069881 5073716 5078872 5085393 5090714 5095932 5099402 5099452 5107410 5107953 6209967 6211775 6212102 6213343 6225529 6225531 6225533 6226254 6240032 6240658 6242230 6243374 6244256 6244259 6244843 6251217 6251219 6251223 6251224 6254007 6254013 6254501 6256463 6260585 Changes incorporated in this version: 5069881 5099402 6209967 6213343 6225529 6225531 6225533 6226254 6240032 6240658 6242230 6243374 6244256 6244259 6244843 6251217 6251219 6251223 6251224 6254007 6254013 6254501 6256463 6260585 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/arco_common.jar /dbwriter/lib/dbwriter.jar /dbwriter/lib/jaxb-impl.jar /dbwriter/lib/postgresql-7.4.2.jar /dbwriter/util/dbwriter.conf_template /dbwriter/util/sgedbwriter_template /reporting/WEB-INF/lib/JimiProClasses.jar /reporting/WEB-INF/lib/arco_common.jar /reporting/WEB-INF/lib/jaxb-impl.jar /reporting/WEB-INF/lib/jcommon-0.9.7.jar /reporting/WEB-INF/lib/jfreechart-0.9.21.jar /reporting/WEB-INF/lib/reporting.jar /reporting/WEB-INF/web.xml /reporting/arcorun /reporting/database/example_queries /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 /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/dbpwd /reporting/html/en/version.txt /reporting/html/en/versionDate.txt /reporting/html/style.css /reporting/images /reporting/images/logo.gif /reporting/images/logo_sge.gif /reporting/inst_reporting /reporting/inst_util.sh /reporting/js /reporting/js/arco.js /reporting/js/browserVersion.js /reporting/js/stylesheet.js /reporting/jsp/arcomodule/Error.jsp /reporting/jsp/arcomodule/Index.jsp /reporting/jsp/arcomodule/IndexPageTitle.xml /reporting/jsp/arcomodule/IndexQueryTable.xml /reporting/jsp/arcomodule/IndexResultTable.xml /reporting/jsp/arcomodule/LateBinding.jsp /reporting/jsp/arcomodule/Options.jsp /reporting/jsp/arcomodule/Query.jsp /reporting/jsp/arcomodule/Result.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/pdf_firstpage.xsl /reporting/xslt/pdf_master.xsl /reporting/xslt/pdf_pivot.xsl /reporting/xslt/result2csv.xsl Problem Description: 6260585 db_writer does not start on sol-amd64 with java 1.5 6256463 Installation of dbwriter and reporting fails due the file permission problems 6254501 dbwriter install script is broken in special case 6254013 arcorun does not include the default table in HTML output 6254007 HTML Output never includes the SQL query 6251224 installation should check for SGE_ROOT 6251223 exported PDF does not contain N1GE logo 6251219 Query "Job Log" creates weird pivot table in pdf output 6251217 Consolebased html export broken 6244843 "format error" in pdf exported table 6244259 pivot table - add row/data should set type to row/data 6244256 pdf creation results in empty pdf on now advanced query 6243374 dbwriter installation only accepts java 1.4 6242230 dbwriter does not startup if the password of the database user contains a $ 6240658 Installation of dbwriter fails on SuSE 9.0 64-bit. 6240032 dbwriter installation script should query the spool directory 6226254 inst_dbwriter should install sgedbwriter init script by default 6225533 cannot create a simple xy chart from two columns of a table 6225531 Simple Query: Adding a field to the query output deletes the configuration 6225529 Simple query: The where condition can only be built from fields that are selected for output 6213343 sorting incorrect in resultview (always uses ascii sorting) 6209967 Simple Query: Improvements for specifying the sort order. 5099402 PDF export of table always contains all columns of a query 5069881 dbwriter should reread changed rules for derived values and deletion (from 118093-03) 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 . is usually your 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 original 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 # gzip -dc / | 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 # util/setfileperm.sh Files to be deleted ------------------- The following files and directories of the original packages are obsolete and should to be deleted after the installation of the patch which upgrades the ARCo package to N1 Grid Engine 6.0 Update 4 (6.0u4): 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/dbwriter.conf_template dbwriter/lib/mysql-connector-java-3.0.9-stable-bin.jar dbwriter/lib/pg73jdbc2.jar reporting/WEB-INF/lib/i18n.jar reporting/WEB-INF/lib/jcommon-0.9.3.jar reporting/WEB-INF/lib/jfreechart-0.9.18.jar reporting/app.xml reporting/cmdln_conf.xml reporting/cmdln_config.dtd reporting/config.dtd reporting/config.xml.template reporting/database/example_queries/results reporting/database/example_queries/results/dummy reporting/doc/cmdln_conf.xml reporting/html/en/example_app.html reporting/images/poppel.png reporting/jsp/error.jsp reporting/jsp/reportingmodule reporting/jsp/reportingmodule/Acro.jsp reporting/jsp/reportingmodule/AdvancedQuery.jsp reporting/jsp/reportingmodule/ChangeDialog.jsp reporting/jsp/reportingmodule/Error.jsp reporting/jsp/reportingmodule/Export.jsp reporting/jsp/reportingmodule/LateBinding.jsp reporting/jsp/reportingmodule/ResultList.jsp reporting/jsp/reportingmodule/ResultView.jsp reporting/jsp/reportingmodule/SaveQuery.jsp reporting/jsp/reportingmodule/SaveResult.jsp reporting/jsp/reportingmodule/SimpleQuery.jsp reporting/jsp/reportingmodule/ViewConfiguration.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 4 (N1GE 6.0u4). The "-help" output of most commands will print a version string "N1GE 6.0u4" after applying the patch. All packages of a N1 Grid Engine 6 distribution must have the same patch level (exception for ARCo - see below under "Installation note for ARCo patches"). Please refer to the patch matrix below which updates the distribution to most recent patch level. It is not supported and possible to mix different patch levels of binaries and the "common" package in a single N1 Grid Engine cluster. 1. Patches for packages in Sun pkgadd format -------------------------------------------- Package name* OS* Architecture* Patch-Id ----------------------------------------------------------------- SUNWsgee Solaris, Sparc, 32bit sol-sparc 118094-04 SUNWsgeex Solaris, Sparc, 64bit sol-sparc64 118130-04 SUNWsgeex Solaris x86 sol-x86 118131-04 SUNWsgeec all common 118132-04 SUNWsgeea all arco 118133-04 *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-04 Solaris, Sparc, 64bit sol-sparc64 118083-04 Solaris, x86 sol-x86 118084-04 Linux kernel2.4/2.6, x86 lx24-x86 118085-04 Linux kernel2.4/2.6, AMD64 lx24-amd64 118086-04 IBM AIX 4.3 aix43 118087-04 IBM AIX 5.1 aix51 118088-04 Apple MAC OS/X darwin 118089-04 HP HP-UX 11 hp11 118090-04 SGI Irix 6.5 irix65 118091-04 all common 118092-04 all arco 118093-04 Installation note for ARCo patches 118133 or 118093 --------------------------------------------------- With N1 Grid Engine 6 Update 4 (or higher) the look&feel of ARCo has been updated to use the native Sun Web Console (SWC) 2.2 GUI controls. The installation of the ARCo patch requires a new installation of SWC 2.2. You may not install the ARCo patch unless you can install SWC 2.2. SWC 2.2 is bundled with the N1 Grid Engine 6 Update 4 CDROM or can be downloaded with the full N1GE 6.0u4 distribution from Sun Download Center (SDLC). Please contact your Sun Microsystems account manager how to get access to N1GE 6.0u4 for no additional license fees if you have a valid support contract. The distribution also contains a new version of the manuals which describe the installation and use of ARCo. You can install all other N1GE6 patches without updating ARCo to the most recent patch level, however you cannot make a new installation of older ARCo packages of N1GE 6.0/6.0u1/6.0u2/6.0u3 once you installed the N1GE 6.0u4 binary and "common" patches. 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. ARCo patch 118133-04 (pkgadd format) or 118093-04 (tar.gz format) or higher requires Sun Web Console (SWC) 2.2 or higher. Please do not try to install this patch unless you have access to this version of SWC. Please contact your account manager to get more information how to get access to a supported version of SWC for this patch. 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 Installation of SWC 2.2 ----------------------- - A previous version of SWC does not need to be un-installed. The installation of SWC 2.2 or higher will upgrade an older version. - unpack the tar file of the SWC package in a temporary location as user root, e.g. to unpack SWC version 2.2.3 for Solaris x86 enter # tar xvpf /swc-solx86_2.2.3.tar - as user root install SWC from the directory where you unpacked the SWC package # ./setup Patch installation ------------------ The ARCo patch now should be installed as outlined in the "Patch Installation" section above. Required steps after patch installation --------------------------------------- 1. Delete old log files and the dbwriter startup script The spool directory of dbwriter is configured in the file //common/dbwriter.conf Delete the old dbwriter log files in //dbwriter.* and the old dbwriter startup script (the new startup script will be located in a different directory, see below) /dbwriter/bin/sgedbwriter 2. Reinstall dbwriter as user root # cd /dbwriter # ./inst_dbwriter 3. Start dbwriter The new dbwriter startup script has a new location and is installed by default in /etc/init.d # //common/sgedbwriter start or # /etc/init.d/sgedbwriter start 4. Reinstall the ARCo reporting module as user root Existing ARCo queries are not deleted when the reporting module is being reinstalled. # cd /reporting # ./inst_reporting.sh New functionality delivered since version 6.0 --------------------------------------------- 1. Installation improvements --------------------------- The installation of ARCo has been improved. Dbwriter Installation --------------------- - the database model will be checked and updated automatically - manual execution of the supplied SQL scripts is no longer necessary - the dbwriter spool directory can be specified during installation - the dbwriter startup script can be automatically installed in /etc/init.d that dbwriter is started upon machine boot. 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') } - the ARCo reporting module now requires SWC 2.2 or higher - the ARCo GUI now uses SWC components. The GUI is now compliant with the SWC look&feel. The GUI performance has been improved. - the following report diagram types have been added: 3D Bar Chart 3D Pie Chart Stacked Bar Chart - table cell values can be formatted - the graphical presentation of data series provides more flexibility to display graphs README -- Last modified date: Thursday, April 28, 2005