$TXT Created by NABER,DAVID A at DEVCUR.FO-SLC.MED.VA.GOV (KIDS) on FRIDAY, 04/05/02 at 07:23 ============================================================================= Run Date: APR 05, 2002 Designation: OR*3*145 Package : OR - ORDER ENTRY/RESULTS REPORTING Priority: EMERGENCY Version : 3 SEQ #128 Status: Released ============================================================================= Associated patches: (v)OR*3*138 <<= must be installed BEFORE `OR*3*145' Subject: Update to post-init for patch OR*3*138 Category: - Routine Description: ============ Patch OR*3*138, which fixed a number of POE related problems, contained a post-init to clean up the database. A few sites have reported a problem with the post-init crashing before completing the clean up. This patch contains a modified version of the post-init that will fix the relatively rare problem that is causing the post-init from patch OR*3*138 to crash. The cause of this problem will be fixed in another patch as it is not causing any problems with the database on a day to day basis. The new clean up routine, ORY145, will be the only routine included in this patch. As most sites will have installed patch OR*3*138 without a problem, most sites WILL NOT have to do anything once this patch is installed. However, if your site experienced problems with the post-init in patch OR*3*138 you will have to manually run routine ORY145 to clean up your database. NOTE: Do the following ONLY if your site experienced problems with the post-init in patch OR*3*138. From programmer's mode run ORY145. Select the time for the job to run in the background. An example follows. DEV,CUR>D ^ORY145 Database clean up routine ORY145. This routine will run in the background and will fix any known database errors. It will then send a mail message to the initiator indicating what was changed. Requested Start Time: NOW// (APR 04, 2002@10:50:24) ORY145 queued to background as task number 5046582. NOIS ==== CIN-0402-40499 ERROR OR*3.0*138 POST-INIT ALT-0402-20490 ERROR WHEN INSTALLING PATCH 138 MAR-0402-20498 UNDEF DQ^ORY138 HEH-0402-40505 ABORT WBP-0402-20510 Error running post-init routine BIL-0402-30522 post init error CPH-0402-40536 OR*3*138 erroring out on post init SAJ-0402-70692 Error during cleanup Patch 138 CHA-0402-30694 Patch OR*3*138 error on clean up MIN-0402-40678 Patch 138 errors out with UNDEFINED CHKACT+4~ORY138 REN-0402-60602 CLEANUP ERROR The above listed NOIS all concern problems encountered while running the post-init for patch OR*3*138. ROUTINE SUMMARY: ================ The following is a list of the routine(s) included in this patch. The second line of each of these routine(s) will look like: ;;3.0;ORDER ENTRY/RESULTS REPORTING;**[patch list]**;Dec 17, 1997 CHECK^XTSUMBLD results Routine name Before Patch After Patch Patch List ============ ============ =========== ========== ORY145 N/A 22598099 145 INSTALLATIONS INSTRUCTIONS: =========================== This patch should be loaded during non-peak hours to minimize disruption to users who can remain on the system during installation. Installation will take approximately 1 minute. Systems with heavy user loads or performance problems may take longer. NOTE: This patch contains only one routine, ORY145. This routine will need to be run manually from programmer's mode ONLY if your site experienced a problem with the post-init for patch OR*3*138. If your site DID NOT experience any problems with patch OR*3*138 then no action is required after installation of this patch. 1. Use the INSTALL/CHECK MESSAGE option on the PackMan menu. 2. From the Kernel Installation and Distribution System (KIDS) Menu, select the Installation menu. 3. From this menu, you may elect to use the following options (when prompted for INSTALL NAME, enter OR*3.0*145): a. Backup a Transport Global b. Compare Transport Global to Current System c. Verify Checksums in Transport Global 4. Use the Install Package(s) option and select patch OR*3.0*138. 5. When prompted 'Want KIDS to INHIBIT LOGONS during install? YES//', respond "NO". 6. When prompted 'Want to DISABLE Scheduled Options, Menu Options, and Protocols? YES//', respond NO. 7. From programmer's mode, type D ^ORY145 and select the time you would like the job to run in the background. DO THIS ONLY IF YOUR SITE HAD PROBLEMS WITH THE POST INIT IN PATCH OR*3*138. 8. Routine ORY145 may be deleted after successful completion of the back ground job. Routine Information: ==================== Routine Name: - ORY145 Routine Checksum: ============================================================================= User Information: Entered By : NABER,DAVID A Date Entered : APR 04, 2002 Completed By: GREEN,JOANN Date Completed: APR 05, 2002 Released By : TASTROM,JOSEPH E Date Released : APR 05, 2002 ============================================================================= Packman Mail Message: ===================== $END TXT