FUJ00172183
FUJ00172183
Peak Incident Management System
Call Reference PC0200468 Call Logger Deleted User -- Security Ops
Release Targeted At -- HNG-X 02.07.10.00 Top Ref AUDIT EXTRACT SVR_0207_D051-D050
Call Type Live Incidents Priority B -- Business restricted
Contact Deleted Contact Call Status __ Closed -- Fix Released to Call Logger
Target Date 26/08/2010 Effort (Man Days) 4.00
Summary Horizon Audit Spreadsheet Producing Duplicate Transactions
All References Type Value
Product Baseline AUDIT_EXTRACT_SVR_0207_V051-V050
Product Baseline AUDIT EXTRACT SVR_ 0207 D051-D050
Release PEAK PC0201352
DeviIntRel-Director ITU SV&I
Impact
cn ey ae
Unknown 23-Jun-2010 19:44:16
From Penny - In a nut shell the HNG-X application is not removing duplicate transactions (which may have
been recorded twice on the Audit Server) and they are appearing in the ARQ returns. For the old Horizon
application Riposte automatically removed duplicate entries. An initial analysis shows that one third of all
ARQ returns (since the new application has been in play) have duplicated transactions
Progress Narrative
foate:21-dun-2010 12:22:48 User:Penny Thomas
CALL PC0200468 opened
Details entered are:-
summary:Horizon Audit Spreadsheet Producing Duplicate Transactions
call Type:1
call Priority:a
target Release: HNG-X Rel. Ind.
outed to:QFP - Unassigned _
jDate:21-Jun-2010 12:22:48 Uscr:Penny Thomas
[Start of Response]
#orizon Audit Spreadsheet Producing Duplicate Transactions.
hile performing an audit retrieval for branch 072128 duplicate transactions have been found on 3 June 09. Initial analysis shows
that duplicate records are held in 2 different audited TMS files.
lan Holmes has details.
FAO Audit Dev
[End of Response]
Response code to call Live Incidents/Defects(L) as Potential Problem Identified(38)
jDate:24-dun-2010 12:37:04 User:Lionel Higman
fhe Call record has been transferred to the team: Audit-Dev
Date:24-Jun-2010 14:08:29 Uscr:Andrew Mansfield
[the Call record has been assigned to the Team Member: Gerald Barnes
Oate:22-Jun-2010 10:18:36 Uscr:Gerald Barnes
{Start of Response]
[the processing is done by QueryDIL.dll. The way it works is that it processes all the results in a given file building up an
internal table of transaction sequences for that file. Then at the very end of processing the file it dumps the internal table to
the RFIQueryFileSequence table. It does not cross check the transactions in one file against those in another file.
two solutions are possible.
Ihe “easy solution".
@ each transaction is processed a check is made in the RFIQueryFileSequence table and if it is already there the transaction is
ignored writing a warning to the query log. The problem with this solution is that a query needs to be made to the database for
levery transaction.
the "more difficult solution".
FUJ00172183
FUJ00172183
fhe Internal table which at the moment is built up on a per file basis is changed to being built up on @ per query basis, The
check for duplicate transactions is then done within the internal table. This is a much more thorough approach but will take much
jore work.
[End of Response]
esponse code to call type L as Category 40 -- Pending -- Incident Under Investigation
fours spent since call received: 5 hours
Jbate:22-Jun-2010 10:19:58 Uscr:Gerald Barnes
Product HNG-X Platforms -- ARC = Audit Server (version unspecified) added.
pate:22-Jun-2010 10:40:21 User:Gerald Barnes
flarget Date/Time updated: new value is 28/06/2010 12:22
Development Cost updated: new cost is 4 (Man Days)
(Start of Response]
DEVELOPMENT IMPACT OF FIX:
SPECIFY THE HNG-X PLATFORMS IMPACTS!
[the platform is the “Audit Server" and that has been entered.
IECHNICAL SUMMARY:
his change will affect QueryDLL.dll on the audit servers.
LIST OF KNOWN DIMENSIONS DESIGN PARTS AFFECTED BY THE CHANGE:
IAUDIT_EXTRACT_SVR
IARE ANY OF THESE DESIGN PARTS AFFECTED BY APPROVED CPs/PEAKS in HNGX Release 2:
Yes. They are affected by CP0336. If the fix is targeted pre Release 2 then the PEAK will need to be cloned for a Release 2 fix
too.
RELEASE 2 IMPACT:
ves - see above.
DEPENDENCIES:
here are no particular dependencies.
DOES THE FIX REQUIRE ANY MANUAL, DEPLOYMENT BASELINES:
[fhe integration team will be able to turn this delivery into a fully automatic deployment.
DEV EFFORT IN MANDAYS:
two solutions have been identified and explained in my previous response. The “easy solution" would take 2 days. The "more
j4ifficult solution" will take 4 days. It is a matter of whether performance will be acceptable for the "easy solution” which
involves querying a database table for every single transaction. A test will need to be performed to see how long the database
jauery would take.
IMPACT ON USER:
ccasionally duplicate transactions are listed in the spreadsheets produced and presented to court for prosecution cases. These
can give the defence team grounds to question the evidence.
IMPACT ON OPERATIONS:
[there is no particular operational impact.
AVE RELEVANT KELS BEEN CREATED OR UPDATED?
jo KELs have been created for this since we Intend to fully resolve the issue shortly.
IMPACT ON HORIZON TO HNGX BRANCH MIGRATIONS
here is no particular migration effect.
IMPACT ON TEST:
loueries and filtering need to be done using TMS files with duplicate transactions within them.
InISKS (of releasing and of not releasing proposed fix):
if we do not fix this problem our spreadsheets presented in court are liable to be brought into doubt if duplicate transactions
are spotted.
I.ISt OF LIKELY DELIVERABLES:
loueryDiL.d11
List OF THE ABOVE ALREADY DELIVERED FOR THE PROPOSED RELEASE:
jone
LIST OF THE ABOVE ALREADY DELIVERED TO A RELEASE LATER THAN THAT PROPOSED:
FUJ00172183
FUJ00172183
ueryDun.dnT
LIST OF THE ABOVE LIKELY TO BE REDELIVERED INTO THE PROPOSED OR A LATER RELEASE:
QueryDLL.dll is a recent component introduced for HNGx and has not yet fully bedded down and so it is likely to change as
jproblems such as this one are spotted.
[End of Response]
Response code to call type L as Category 55 -- Pending -- Live Fix Impact Supplied
Hours spent since call received: 1 hours
Date:22-Jun-2010 10:40:43 Uscr:Gerald Barnes
[fhe call Target Release has been moved to Proposed For -~ HNG-X 01.23
JDate:22-un-2010 10:41:10 Uscr:Gerald Barnes
the Call record has been transferred Eo the team: RelMngmntForum
Date: 23-dun-2010 09:30:43 User:Penny Thomas
[initial analysis of all ARQ returns since the HNG-X application has been implemented identifies approximately one third (of all
lreturns) have duplicate entries. This is now extremely urgent.
Penny
pate:28-Jun-2010 16:15:17 User:Gerald Barnes
[Start of Response]
1 work is complete. I attach test materials and a zip of the source. It is ready to go at Release 1. For Release 2 the fix will
Inced merging into the current Release 2 source.
[End of Response]
Response code to call type L as Category 46 -- Pending -- Product Error Fixed
Hours spent since call received: 28 hours
[Date:28-dun-2010 1
evidence Added - Tes
jbate:28-dun-2010 16
Jsvidence Added = Sourc
jDate:29-un-2010 11:07:11 User:Christopher Hammond
EMF:
waiting confirmation of business workaround from Penny Thomas
Date:06-Jul-2010 10:33:46 User:Christopher Hammond
the call Target Release has been moved to Targeted At -- HNG-X 02.07.10.00
jbate:06-dul-2010 11:20:21 Uscr:Tyrone Cozens
[the Call record has been transferred to the team: Audit-Dev
jbate:06-Jul-2010 14:05:38 Uscr:Gerald Barnes
[fhe Call record has been assigned to the Team Member: Gerald Barnes
bate:07-dul-2010 13:39:00 User:Gerald Barnes
lkeference Added: Product Baseline AUDIT EXTRACT SVR_0207_v051-v050
jbate:07-dul-2010 13:41:51 User:Gerald Barnes
[Start of Response]
Fixed by QueryDLL.dll Version 2.0.0.8 delivered in workset AUDIT EXTRACT SVR 0207 v051-v050.
jote that details of any duplicate transactions found are listed in Querylandler.log.
[End of Response]
Response code to call type L as Category 46 -- Pending -- Product Error Fixed
Hours spent since call received: 4 hours
Date:07-Jul-2010 13:42:15 User:Gerald Barnes
[the Call record has been transferred to the team: Dev-Int-Rel
ldate:07-dul-2010 14:49:11 Uscr:PIT Automated User
[Start of Response]
Assigning to Integrator
{End of Response]
response code to call type L as Category 48 (Fix Released to PIT)
lhe incident has been transferred to the Team: Dev-Int-Rel
FUJ00172183
FUJ00172183
ffhe Incident has been assigned to the Team Mambo:
Geert Inglis
Jbate:07-dul-2010 17:19:13 User:PIT Automated User
lkeference Added: Product Baseline AUDIT EXTRACT SVR_0207_D051-D050 (TOP Reference)
loate:07-dul-2010 1
[Start of Response]
Peak has been test installed in Integration. Moving to holding stack awaiting release
{End of Response]
kesponse code to call type L as Category 47 (Fix Processed by PIT)
fhe incident has been transferred to the Team: Int-Rel
9:13 User:PIT Automated User
jDate:09-dul-2010 11:13:52 User:Lionel Higman
fhe call Priority has been changed from A to B
ne of 51 ''A'’ priority calls being downgraded to B in response to:
Lionel,
sheila [Bamber] and I have had to review the attached peaks as part of the readiness review for LST release 2. We have had a look
land agree that none of them are true A priorities. Can you downgrade them all to B?s for us?
cheers
Pat. [Lywood]
jDate:09-gul-2010
Reference Added:
Tyrone Cozens
Jbate:12-gul-2010
[Start of Response]
[this baseline was released via manual release note.
[End of Response]
response code to call type L as Category 49 -- Pending -- Fix Available for IndependentTest
‘Vijesh Pandya
Jbate:12-Jul-2010 16:25:39 User:Vijesh Pandya
{the Call record has been transferred to the team: Live Supp.Test
bate: 30-gul-2010 0
[Start of Response]
[this peak has been tested in LST and fix will be released with Release 2 data centre
[End of Response]
lkesponse code to call type L as Category 60
1:59 User:Sheila Bamber
jbate:30-dul-2010 09:56:18 User:Jdohn Rogers
testing successfully completed and documented in L
Test Script 157
Joate:23-Aug-2010 13:45:58 Uscr:PIT Automated User
[Start of Response]
Iseing processed as part of UNKNOWN
[End of Response]
lkesponse code to call type L as Category 48 (Fix Released to PIT)
ffarget Date updated: new value is 25/08/2010 18:30
lOate:24-Aug-2010 08:11:06 Uscr:PIT Automated User
[Start of Response]
lseing processed as part of UNKNOWN
[End of Response]
Response code to call type L as Category 48 (Fix Released to PIT)
target Date updated: new value is 26/08/2010 18:30
jbate:01-Sep-2010 13:17:14 User:Penny Thomas
[Start of Response]
ix successfully deployed, closing call.
Penny
[End of Response]
Response code to call type L as Category 71
routing to Call Logger following Final Progr
Defect cause updated to 14 -- Development - Code
Fix Released to Call Logger
FUJ00172183
FUJ00172183
Date:01-Sep-2010 13:17:24 Uscr:benny Thomas
CALL PCO200468 closed: Category 71 Type L
Root Cause Development - Code
Logger Deleted User -- Security Ops
Subject Product Estate Management -- Audit (version unspecified)
Assignee Deleted User -- Security Ops
Last Progress 01-Sep-2010 13:17 -- Penny Thomas