Vital Signs Patches for 1.5

Patch 1.5 to 1.5.22

Overview

- Added support for custom TB Escrow aggregation

- Fixed bad character data in Spectrum_Data_Change

- Fixed HPUX job overlapping

- Fixed missing teller auto definitions in Transaction_Analysis

- Improved Member Charts Trial Balance reconciliation to PGNTB

- Improved ftp functionality / verbosity

- Improved Vital Signs listener logic for handling timeouts on busy servers

Instructions for applying patch 1.5 to 1.5.22

Download the patch file: vs_patches-15_to_1522_patches.zip

Username : Customer

Password : 2012release

Unzip vs_patches-15_to_1522_patches.zip

Place the following files from the unzipped folder on HPUX:

jobs\* into /ASKPLUS/vsdata/jobs/
scripts\* into /ASKPLUS/vsdata/scripts/

Place the following files from the unzipped folder on Windows:

bin\* into vitalsigns\bin\

Add the following into /ASKPLUS/vsdata/custom/live/vsmacdef on HPUX:

** Added for Trial Balance extracts:
Macro VS-TRBAL-SHARE = (SHARE-FILE.BALANCE <> 0 OR SHARE-FILE.CONTROL-FLAGS(21) <> " ")
Macro VS-TRBAL-LOAN = (LOAN-FILE.BALANCE <> 0 OR LOAN-FILE.CREDIT-LIM > 0)
*** Use the following macros if you want to include non-zero escrow balance loans in the trial bal chart
*** - The macros with the same names (below) MUST be disabled with comments.
*Macro VS-TRBAL-INC-ESCTOTS = 1
*Macro VS-TRBAL-ESCROW-LINK = link l1, account splice "-" splice !format("99", suffix) :: esctots.acctsfx-key
*Macro VS-TRBAL-ESCROW-MBR = (!range((LOAN-ADDENDUM.BALANCE <> 0, $MISSING), "1/"))
*Macro VS-TRBAL-ESCROW-LN = (ESCTOTS.ESCROW_BALANCE <> 0, $MISSING)
*** Use the following macros if zero balance escrow loans Should NOT be included
*** - The macros with the same names (above) MUST be disabled with comments.
Macro VS-TRBAL-INC-ESCTOTS = 0
Macro VS-TRBAL-ESCROW-LINK = * No Link
Macro VS-TRBAL-ESCROW-MBR = ($FALSE)
Macro VS-TRBAL-ESCROW-LN = ($FALSE)

Review the vitalsigns/yourcu/data/config/vitalsigns.xls file and confirm the 4 tabs contain the following VS_VARNAME entries with your custom values :

GlobalVars sheet:

Membership sheet:

Transaction sheet:

DataChng sheet:

Testing the Patchwork for patch 1.5 to 1.5.22

Test the Vital Signs listener with a fast reload :

Login as bolive
/VSJOBS/JVSRELOAD Transaction_Analysis

Run through a full test of the nightly HIST extract :

/VSJOBS/JVSLOAD_HIST

Run through a full test of the nightly Member, Share and Loan extract :

/VSJOBS/JVSLOAD_MBRSHLN

If there are no errors during these tests, the patches are successfully in place.