Patch-ID# 104715-01 Keywords: Solstice Job Scheduler Pro bug fixes Oracle Synopsis: SJSP 3.3: Jumbo patch - misc. bug fixes - Oracle version Date: Aug/05/97 Solaris Release: SunOS Release: HP/UX Release: 9.0 10.0 Unbundled Product: Solstice Job Scheduler Pro Unbundled Release: 3.3 Xref: This patch is available with Sybase support as patch 104398 Relevant Architectures: BugId's fixed with this patch: Changes incorporated in this version: 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: For Oracle support: ./autosys/bin/auto_remote ./autosys/bin/auto_verify ./autosys/bin/autoflags ./autosys/bin/autoping ./autosys/bin/chase ./autosys/bin/chk_auto_up ./autosys/bin/clean_files ./autosys/bin/event_demon ./autosys/bin/hostscape ./autosys/bin/jobscape ./autosys/bin/timescape ./autosys/install/.VERSION Problem Description: (rev 01) Bug ID xxx1 Summary: auto_delete: 0 not reported as part of job definition by autorep -q. Bug ID xxx2 Summary: The chase command changes the status to FAILURE for jobs on machines that have lost their connection to the network. Bug ID xxx3 Summary: Check Auto Up does not reflect correct configuration after TakeOver. Bug ID xxx4 Summary: clean_files reports that Machine Cleaner started when it is not running. Bug ID xxx5 Summary: Problems with clean_files have been fixed. Bug ID xxx6 Reported on: Sybase Summary: Daylight Savings - Fall - AIX does not run start_mins during first bogus hour while Solaris, Sun OS and HP do. Bug ID xxx7 Summary: Exclude Calendar doesn't work. Jobs are scheduled and run on exclude_calendar days. Bug ID xxx8 Reported on: Platforms requiring tli interface / Sybase Summary: auto_db_rename is broken - it still looks for sybtli and we now use autotli. Bug ID xxx9 Summary: Machine list checking bad. Bug ID xxx10 Summary: Monitor/Browser - still broken for "Box with its Jobs" in "Job Filter" of job. Bug ID xxx11 Reported on: Solaris 2.4 / Sybase 4.9.2 Summary: AutoSys ignores sourced variable when also using AutoSys global variable. Bug ID xxx12 Reported on: HP/UX 10.0 / Oracle Summary: autocal does not save the calendar even if you click on `save' button. Bug ID xxx13 Reported on: AIX 3.2.5 / Sybase 10.0 Summary: Add a `go' to the remaining procs that currently do not have them. Bug ID xxx14 Summary: Installation problem, Dual Servers, from scratch. Bug ID xxx15 Reported on: Solaris / Sybase Summary: Force start box inside another (non-running) box does not work. Bug ID xxx16 Summary: Setting the n_retrys attribute greater than 0 breaks box_terminator. Bug ID xxx17 Reported on: All / Oracle 7.1 Summary: archive_events -j produces "ORA-00933: SQL command not properly ended" errors. Bug ID xxx18 Reported on: Solaris 2.4 / All Summary: dbspace displays expr error message. Bug ID xxx19 Summary: File Watcher fills up /tmp file system. Bug ID xxx20 Summary: Combining global variables and environment variables in the same jil parameter does NOT work. Bug ID xxx21 Summary: autorep only shows part of long job names. Bug ID xxx22 Reported on: Solaris / Sybase Summary: NIS+ installation fails. Bug ID xxx23 Reported on: SunOS 4.1.3 / Sybase 4.9.2 Summary: autorep -J -r terminates when running on a box with new jobs. Bug ID xxx24 Reported on: Solaris / Sybase Summary: The chase command returns the spurious message "array index is out of range" Bug ID xxx25 Reported on: Solaris 2.3 / Sybase Summary: config_unix uses incorrect pathname $AUTOSYS/data/install. Bug ID xxx26 Summary: Examples in the config.ACE file should be more correct. Bug ID xxx27 Reported on: SunOS 4.1.3 / Sybase 4.9.2 Summary: The new index on job(box_joid) in 3.3 changes the sorting order in autorep. Bug ID xxx28 Reported on: Solaris 2.3 / Oracle 7.0.16 Summary: $AUTOSYS/code/test_api is broken (for Oracle only). Bug ID xxx29 Reported on: Sybase 10.0 Summary: Box that is ON_ICE succeeds or fails when a job within the box is force started. Bug ID xxx30 Reported on: HP/UX / Sybase Summary: Closing the Alarm Manager dialog using the window manager `control menu icon' causes a core dump. Bug ID xxx31 Summary: archive_events -A -j puts garbage in the archived_job_runs* file. Bug ID xxx32 Reported on: AIX 4.1 / Oracle Summary: AutoSys/Xpert HostScape only puts host names in two boxes. Bug ID xxx33 Reported on: Solaris 2.4 / Sybase Summary: Starting a job when hosts file (NIS) is unavailable causes the job to go into QUE_WAIT state. Bug ID xxx34 Summary: cron2jil will not accept a 6th field (command) in a crontab. Bug ID xxx35 Summary: Cannot execute a sendevent to change a job priority to 0 from the Operator Console. Bug ID xxx36 Reported on: Solaris 2.4 / Sybase Summary: AutoSys/Xpert HostScape is dumping core during invocation. Bug ID xxx37 Reported on: SunOS 4.1.3 / Sybase Summary: The chase command incorrectly reports that a job is not running when in fact it is running. Bug ID xxx38 Reported on: SunOS 4.1.3 / Sybase Summary: The chase command sent a FAILURE to a job that had already succeeded. Bug ID xxx39 Reported on: HP/UX / Sybase Summary: archive_event -J causes a core dump when job_runs table is very large. Bug ID xxx40 Summary: not equals (!=) does not work when using global variables in job. Bug ID xxx41 Reported on: Solaris / Sybase Summary: Having an exclude calendar on a job that is in a box prohibits the box from running to completion. Bug ID xxx42 Reported on: Sybase Summary: AutoSys 3.1/3.2 to 3.3 upgrade fails when upgrading a database. Bug ID xxx43 Reported on: Sybase Summary: sendevent -T is broken. Bug ID xxx44 Reported on: HP-UX 9.0.4 / Sybase Summary: event_demon grabs over 95% of the cpu, even when no events are being processed. Bug ID xxx45 Summary: Creating a calendar with a 10-year range causes an error and the calendar cannot be loaded. Bug ID xxx46 Reported on: Solaris 2.4 / Sybase Summary: AutoSys/Xpert interfaces will only display a maximum of 16 machines in the Job Selection window. Bug ID xxx47 Reported on: Solaris 2.4 / Sybase 4.9.2 Summary: A job defined on virtual machine goes into QUE_WAIT state when that machine is down. Bug ID xxx48 Reported on: AIX 3.2.5 / Sybase 10.0 Summary: Operator Console buttons do not work. Bug ID xxx49 Summary: Cannot change the Job Name field in the Send Event dialog. Bug ID xxx50 Summary: autocons -x does not return the revision level of the executable. Bug ID xxx51 Reported on: Solaris 2.5 / Sybase 10.0 Summary: archive_events -l causes core dumps. Bug ID xxx52 Summary: If the crontab has an environment variable in the command line, like $PATH, we receive a syntax error when running cron2jil. The $ is not getting parsed correctly. Bug ID xxx53 Reported on: HP/UX / Sybase Summary: monbro "beeps" in 3.1, does not in 3.2 or 3.3. Bug ID xxx54 Reported on: Solaris 2.4 / Sybase 4.9.2 Summary: When a calendar is defined (new) and saved using the "Save" option, not the "Save As" option (i.e., saving without naming the calendar), all jobs with date conditions reschedule. This only seems to occur the first time a save is done from the Graphical Calendar facility. Bug ID xxx55 Reported on: Solaris 2.4 / Sybase 10.02 Summary: archive_events -J starts but then core dumps without making any changes to the database. Bug ID xxx56 Summary: JIL and/or event_demon dumps core for jobs with time zones. Bug ID xxx57 Reported on: AIX / Sybase Summary: EP_ROLLOVER alarms do not happen when the Shadow Event Processor takes over. Bug ID xxx58 Reported on: SunOS 4.1.3 / All Summary: Secondary groups are ignored by auto_remote. Bug ID xxx59 Reported on: Sybase Summary: Checking for the DIBS file triggers an EP_HIGH_AVAIL alarm. Bug ID xxx60 Summary: Bogus cross-instance condition causes database errors and causes the Event Processor to shut down. Bug ID xxx61 Summary: Deleting a job does not remove external dependency events. Patch Installation Instructions: - Login as root - cd to install directory of Solstice Job Scheduler Pro (/opt/SUNWsjs) - preserve the changed files - select database support required (sybase or oracle) NOTE: the database version can be determined by viewing the file /opt/SUNWsjs/autosys/install/.VERSION. This patch is for Oracle only - uncompress and untar patch tar file For example, the sybase version of the patch: cd /opt/SUNWsjs # create list of patched file uncompress oracle.tar.Z tar -tf /var/spool/patch/104715-01/oracle.tar > patched_files # create a tar file of original files cat patched_files | xargs tar -cvf 104715_backout.tar # install the new files tar -xvf /var/spool/patch/104715-01/oracle.tar