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

Make a backup of the /ASKPLUS/vsdata directory i.e.(vsdata-20130403)

Place the following files from the unzipped folder on HPUX:

jobs\* into /ASKPLUS/vsdata/jobs/
scripts\* into /ASKPLUS/vsdata/scripts/
chmod 644 /ASKPLUS/vsdata/scripts/VSLOAD-ESCTOTS

Make a backup of the vitalsigns\bin directory i.e. (bin-20130403)

Place the following files from the unzipped folder on Windows:

bin\* into vitalsigns\bin\

Paste 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)

Open task manager and end the python.exe *32 process

Browse to vitalsigns\yourcu\data\config and double click the start_vsigns_srv.vbs

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.

Close out the batch window on the Windows Server.

Restart the Vital Signs listener on the Windows Server (if 2008 just restart the Scheduled Task, if 2003 reboot the server)