2013-02-13 - 4994.300 - Break Fix - Improve Error Handling in ECALC. #POLCAApplication

2013-02-13-4994.300- Break Fix - Improve Error Handling in ECALC

Problem Summary Description

Intermittent failures in ECalc are being reported and need better error handlng
1. Currently source files could get overwritten if not processed within wilcom->Ecalc FTP window (30 mins).
2. When job fails, errors are not trapped and so cannot analyze the cause of failure

Admin Info

Purpose	4994.300 - New Process for ECALC
Requested by	Denise Sirianni
Issue Date	12-28-2012
Resolved by	Rajesh.K, Venkat.A
Resolved Date	12-21-2012
Document Status	Complete

Detailed Description

1. Currently source files could get overwritten if not processed within wilcom->Ecalc FTP window (30 mins).
2. When job fails, errors are not trapped and so cannot analyze the cause of failure

Analysis and Recommendations

1. Risk of current source files being overwritten:
This can be addressed by adding a NEW package to do the following

Copy Input files to a PENDING folder.
Add Date time stamp to end of file e.g. Derby_02152013-073004
Execute every 30 mins before ECALC package

2. Error Handling when job fails.
This will be addressed by MODIFYING the current ECALC package as follows

Package will only run if
- Prior run is complete successfully (per PROCESSING STATUS FLAG discussed below), otherwise wait till prior process is completed
- Files exist in PENDING
Input files will be taken from PENDING folder based on earlier timestamp and renamed without timestamp for ECALC processing as before
Process ECALC. Add logic to capture errors when failures occur.
Once processing is finished, input files will be moved to an ARCHIVE folder with date timestamp as before (i.e. delete from PENDING and COPY to ARCHIVE)
Set PROCESSING STATUS FLAG to complete
Update log with all key events as shown in flow below (start of job, end of job, errors if any)

Resolution

Update ECALC to re process the failed set of files and also implementing the exception handling.