<html><head><meta name="color-scheme" content="light dark"></head><body><pre style="word-wrap: break-word; white-space: pre-wrap;">OBSOLETE Patch-ID# 118093-04

NOTE:
***********************************************************************
READ THE TERMS OF THE AGREEMENT ("AGREEMENT") IN THE LEGAL_LICENSE.TXT
FILE CAREFULLY BEFORE USING THIS SOFTWARE. BY USING THE SOFTWARE, YOU
AGREE TO THE TERMS OF THIS AGREEMENT. IF YOU DO NOT AGREE TO ALL OF THE
TERMS, PROMPTLY DESTROY THE UNUSED SOFTWARE.
***********************************************************************

Keywords: pivot table pdf
Synopsis: Obsoleted by: 118093-05 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: 

&lt;install_dir&gt;/dbwriter/database/oracle/dbdefinition.xml
&lt;install_dir&gt;/dbwriter/database/postgres
&lt;install_dir&gt;/dbwriter/database/postgres/dbdefinition.xml
&lt;install_dir&gt;/dbwriter/database/postgres/dbwriter.xml
&lt;install_dir&gt;/dbwriter/database/postgres/drop.sql
&lt;install_dir&gt;/dbwriter/inst_dbwriter
&lt;install_dir&gt;/dbwriter/inst_util.sh
&lt;install_dir&gt;/dbwriter/lib/arco_common.jar
&lt;install_dir&gt;/dbwriter/lib/dbwriter.jar
&lt;install_dir&gt;/dbwriter/lib/jaxb-impl.jar
&lt;install_dir&gt;/dbwriter/lib/postgresql-7.4.2.jar
&lt;install_dir&gt;/dbwriter/util/dbwriter.conf_template
&lt;install_dir&gt;/dbwriter/util/sgedbwriter_template
&lt;install_dir&gt;/reporting/WEB-INF/lib/JimiProClasses.jar
&lt;install_dir&gt;/reporting/WEB-INF/lib/arco_common.jar
&lt;install_dir&gt;/reporting/WEB-INF/lib/jaxb-impl.jar
&lt;install_dir&gt;/reporting/WEB-INF/lib/jcommon-0.9.7.jar
&lt;install_dir&gt;/reporting/WEB-INF/lib/jfreechart-0.9.21.jar
&lt;install_dir&gt;/reporting/WEB-INF/lib/reporting.jar
&lt;install_dir&gt;/reporting/WEB-INF/web.xml
&lt;install_dir&gt;/reporting/arcorun
&lt;install_dir&gt;/reporting/database/example_queries
&lt;install_dir&gt;/reporting/database/example_queries/oracle/Accounting_per_User.xml
&lt;install_dir&gt;/reporting/database/example_queries/oracle/Average_Job_Turnaround_Time.xml
&lt;install_dir&gt;/reporting/database/example_queries/oracle/Number_of_Jobs_completed.xml
&lt;install_dir&gt;/reporting/database/example_queries/postgres
&lt;install_dir&gt;/reporting/database/example_queries/postgres/Accounting_per_Project.xml
&lt;install_dir&gt;/reporting/database/example_queries/postgres/Accounting_per_User.xml
&lt;install_dir&gt;/reporting/database/example_queries/postgres/Average_Job_Turnaround_Time.xml
&lt;install_dir&gt;/reporting/database/example_queries/postgres/Average_Job_Wait_Time.xml
&lt;install_dir&gt;/reporting/database/example_queries/postgres/Number_of_Jobs_completed.xml
&lt;install_dir&gt;/reporting/database/example_queries/postgres/Statistics.xml
&lt;install_dir&gt;/reporting/dbpwd
&lt;install_dir&gt;/reporting/html/en/version.txt
&lt;install_dir&gt;/reporting/html/en/versionDate.txt
&lt;install_dir&gt;/reporting/html/style.css
&lt;install_dir&gt;/reporting/images
&lt;install_dir&gt;/reporting/images/logo.gif
&lt;install_dir&gt;/reporting/images/logo_sge.gif
&lt;install_dir&gt;/reporting/inst_reporting
&lt;install_dir&gt;/reporting/inst_util.sh
&lt;install_dir&gt;/reporting/js
&lt;install_dir&gt;/reporting/js/arco.js
&lt;install_dir&gt;/reporting/js/browserVersion.js
&lt;install_dir&gt;/reporting/js/stylesheet.js
&lt;install_dir&gt;/reporting/jsp/arcomodule/Error.jsp
&lt;install_dir&gt;/reporting/jsp/arcomodule/Index.jsp
&lt;install_dir&gt;/reporting/jsp/arcomodule/IndexPageTitle.xml
&lt;install_dir&gt;/reporting/jsp/arcomodule/IndexQueryTable.xml
&lt;install_dir&gt;/reporting/jsp/arcomodule/IndexResultTable.xml
&lt;install_dir&gt;/reporting/jsp/arcomodule/LateBinding.jsp
&lt;install_dir&gt;/reporting/jsp/arcomodule/Options.jsp
&lt;install_dir&gt;/reporting/jsp/arcomodule/Query.jsp
&lt;install_dir&gt;/reporting/jsp/arcomodule/Result.jsp
&lt;install_dir&gt;/reporting/util/app-2.0.xml
&lt;install_dir&gt;/reporting/util/app-2.1.xml
&lt;install_dir&gt;/reporting/util/app-2.2.xml
&lt;install_dir&gt;/reporting/util/config.xml.template
&lt;install_dir&gt;/reporting/xslt/pdf_firstpage.xsl
&lt;install_dir&gt;/reporting/xslt/pdf_master.xsl
&lt;install_dir&gt;/reporting/xslt/pdf_pivot.xsl
&lt;install_dir&gt;/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 &lt;install_dir&gt;. &lt;install_dir&gt; is usually your &lt;sge_root&gt;
   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 &lt;install_dir&gt;
      # gzip -dc &lt;patchid&gt;/&lt;targzfile&gt; | 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 &lt;sge_root&gt;
      # util/setfileperm.sh &lt;sge_root&gt;
 
 
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&amp;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
 
   # &lt;sge_root&gt;/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 &lt;dir&gt;/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
 
           &lt;sge_root&gt;/&lt;cell&gt;/common/dbwriter.conf
 
      Delete the old dbwriter log files in 
 
           &lt;dbwriter-spooldir&gt;/&lt;dbwriter-host&gt;/dbwriter.*
 
      and the old dbwriter startup script (the new startup script will be
      located in a different directory, see below)
 
           &lt;sge_root&gt;/dbwriter/bin/sgedbwriter
 
   2. Reinstall dbwriter as user root
 
      # cd &lt;sge_root&gt;/dbwriter
      # ./inst_dbwriter
 
   3. Start dbwriter
 
      The new dbwriter startup script has a new location and is installed by
      default in /etc/init.d
 
      # &lt;sge_root&gt;/&lt;cell&gt;/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 &lt;sge_root&gt;/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{ &lt;column&gt;;&lt;operator&gt;;&lt;default value&gt; }
 
               &lt;column&gt;    must be a valid column of the query
               &lt;operator&gt;  a SQL operator (e.g. = &lt; &gt; in .. )
               &lt;value&gt;     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&amp;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:  Tuesday, December 6, 2005

</pre></body></html>