FUJ00172241
FUJ00172241
Peak Incident Management System
Call Reference PC0211833 Call Logger Deleted User -- Security Ops
Release Targeted At -- HNG-X 04.37 Top Ref AUDIT QUERIES 0437_D020-D019
Call Type Live (Non-RefData) Data Updates Priority A -- Immediate
Contact Deleted Contact Call Status Closed -- Completed
Target Date 11/08/2011 Effort (Man Days) 1.00
Summary Audit Retrieval for ARQ Returns Missing Reversal Indicator
All References Type Value
Release PEAK PC0211891
Product Baseline AUDIT_QUERIES_0437_D020-D019
Product Baseline AUDIT_QUERIES _0437_V020-V019
Product Baseline AUDIT QUERIES 0437_V020
Impact
Si aia : User Date
Unknown 05-Aug-2011 09:06:34
SERVICE ON STODP.............ARQ retums for HNGX transaction records must stop until resolution.
Analysis must identify returns which may require re-retrieval.
Progress Narrative
date:05-Aug-2011 08
9:32 User:Penny Thomas
udit Retrieval for ARQ Returns Missing Reversal Indicator
call type:¥
call Priori
ffarget Rele.
routed to:
:HING-X R4
urity Ops - Penny Thomas
Jbate:05-Aug-2011 09:03:13 User:Penny Thomas
dit Development
le have found that our ARQ returns do not identify transaction reversals. Initially we need to:-
Update our queries
Identify all returns to date where HNG-X records have been returned.
Please could you provide assistance.
lbate:05-Aug-2011 09:06:33 User:Penny Thomas
lA new Business been added:
SERVICE ON STOP............. ARQ returns for HNGX transaction records must stop until resolution. Analysis must identify returns
which may require re-retrieval.
JDate:05-Aug-2011 09:
the Call record has
team: Audit-Dev
lDate:05-Aug-2011 10:04:23 User:Gerald Barnes
fhe Call record has been transferred to the team: Audit-Dev
JDate:05-Aug-2011 10:04:43 :Gerald Barnes
fhe Call record has been assigned to the Team Member: Gerald Barnes
JDate:05-Aug-2011 15:02:23 Uscr:Penny Thomas
serald, we need to find the migration dates for the following outlets:-
Hadleigh 79140
Bethnal Green 154002
Bishops Hull 157549
felsonby 279309
could you please forward this call to $8C as I believe they can acc
penny
this info.
FUJ00172241
FUJ00172241
bate: 05-Aug-2011 15:
[Start of Response]
For the attention of Anne Chambers to find the missing migration date:
[End of Response]
Response code to call type ¥ as Category 2 ~~ Pending -- Progress update
Hours spent since call received: 6 hours
JDate:05-Aug-2011 15:21:48 Uscr:Gerald Barnes
[fhe Call record has been transferred to the team: EDSC
Date: 05-Aug-2011 15:24:14 User:Anne Chambers
[the Call record has been assigned to the Team Member: Anne Chambers
jate:05-Aug-2011 15:26:52 Uscr:Anne Chambers
31/08/2010 Hadleigh 79140
09/09/2010 Bethnal Green 154002
31/08/2010 Bishops Hull 157549
[this date was the last day on Horizon, they then migrated overnight.
jelsonby 279309: never migrated to HNGx.
oate:05-Aug-2011 15:56:35 User:Anne Chambers
the Call record has been transferred to the team: Security Ops
fhe Call record has been assigned to the Team Member: Penny Thomas
Date: 05-Aug-2011 16:17:25 User:Penny Thomas
[the Call record has been transferred to the team: Audit-Dey
[the Call record has been assigned to the Team Member: Gerald Barnes
bate:05-Aug-2011 16:21:04 Uscr:Gerald Barnes
Product HNG-X Platforms -~ Audit Server (ARC) (version unspecified) added.
Oate:05-Aug-2011 16:33:05 User:Gerald Barnes
Target Date/Time updated: new value is 03/08/2011 08:59
Development Cost updated: new cost is 1 (Man Days)
[Start of Response]
DEVELOPMENT IMPA
OF FIX:
SPECIFY THE HNG-X PLATFORMS IMPAC’
the platform has been specified and it is the Audit Server.
[TECHNICAL SUMMARY:
fhe spreadsheets pre: tions at court miss out an indication as
reversal.
sented in support of proseci
tS? OF KNOWN DIMENSIONS DES
GN PARI
'S AFFECTED BY THE
JAUDIT_QUERIES
DEPENDENCIES:
There are no particular dependencies.
DEPLOYMENT DEATL:
[these are just replacement files; no reboot is required.
DEV EFFORT IN MANDAYS:
h man day
IMPACT ON USER
[there is no particular user benefit.
IMPACT ON OPERATIONS:
Spreadsheets supplied by the prosecution team miss out an
]ZAVE RELEVANT KELS BEEN CREATED OR UPDATED?
the prosecution team are well aware of the problem; we hope to have a release out in a few days; a KEL is therefore not required.
IMPACT ON TEST:
IThey just need to run FASTARQs with all the various queries and check that the HNGx spreadsheets all now have a revereal column.
to whether a transaction is a reversal.
to whether or not a transa:
FUJ00172241
FUJ00172241
IRISKS (of releasing and of not releasing proposed fix):
here are few risks with this fix. It must be got out or prosecution evidence is incomplete.
LIST OF LIKELY DELIVERABLES:
lux _AuthCds.xql
lix BQIOPPANBarcodes.xql
ix Bureau.xql
lix Events. xql
ix Events Num.xql
lax TOP .xqi
lx TOPDVLA. xql
lix_1OPDVLAAddi tional. xql
lix_10PMailService.xql
lix_I0PMailServiceSDAddress.xql
lix_TOPMLabel .xql
lix_TOPPANBarcodes.xql
l#x_ToPPouchId. xql
lix TOP _Num.xql
lax 1oP TITO.xql
lix_ Remit tancePouches.xql
lix_SecurityEvents.xql
lux _Signons.xql
lix_StockDeclarations.xql
{End of Res
Response code to call type ¥ as Category 51 -- Pending -- Waiting business imp:
fours spent since call received: 2 hours
Date: 05-Aug-2011 16:33:44 User:Gerald Barnes
[the call Target Release has been moved to Proposed For -- HNG-X 04.37
Jbate:05-Aug-2011 16:35:04 Uscr:Gerald Barnes
ction placed on Team:RelMngmntForum
Jbate:05-Aug-2011 17:20:56 User:Victoria Hancock
[fhe call Target Release has been moved to Targeted At =~ Target missed need to re-target
Date:05-Aug-2011 17:22:14 User:Victoria Hancock
[this needs to go before the next Audit target of 5.16.
d.37 has been applied to Live.
IkM will target appropriately on Monday
Jat ¢:05-Aug-2011 17:27:25 Uscr:Victoria Hancock
the Call record has been transferred to the team: RelMngmntForum
bate:08-Aug-2011 07:27:08 User:dohn Boston
[the call Target Release has been moved to Targeted At -- HNG-X 04.37
Date: 08-Aug-2011 07:28:18 User:John Boston
ffargeted for 04.37. This is a post 04.37 Hot Fix to deliver immediatly.
[Dat €:08-Aug-2011 07:28:21 User:John Boston
ction has been removed from the call
Date: 08-Aug-2011 07:28:38 User:John Boston
the Call record has been transferred to the team: Audit-Dev
jDate:08-Aug-2011 10:45:04 Uscr:PIT Automated User
Reference Added: Product Baseline AUDIT QUERIES 0437_vo20
Reference Added: Product Baseline AUDIT QUERIES 0437 V020-V019
bate: 08-Aug-2011 1
[Start of Response]
Itt turns out the queries that need updating are only -
0:19 User:Gerald Barnes
lax _AuthCds.xql
ix BQTOPPANBarcodes.xql
FUJ00172241
FUJ00172241
fix Bureau-xql
fix TOP. xql
lux TOPDVLA. xql
lix_TOPDVLAAddit ional .xql
ix 1OPMLabel .xql
lix_IOPMailService.xql
lix 10PMailServiceSDAddress.xql
lix_TOPPANBarcodes.xql
lix_10PPouchId. xql
lx _TOP_Num.xql
ix TOP TTTO.xql
See email attached as evidence - "Queries to be changed”.
[End of Response)
Response code to call type Y as Category 2 -- Pending -~ Progress update
iours spent since call received: 3 hours
jDate:08-Aug-2011 10:51:55 Uscr:Gerald Barnes
evidence Added - Queri
© be changed
bate: 08-Aug-2011 1
[Start of Response]
It tested each changed query and confirmed that the reversal indicator was shwon in the final
las evidence labelled "Test Report".
[End of Response]
Ikesponse code to call type ¥ as Category 2 -~ Pending -- Progress update
tours spent since call received: 1 hours
8:50 User:Gerald Barnes
spreadsheet.
I attach a test report
bate:08-Aug-2011 1
evidence Added - 1
9:20 User:Gerald Barnes
Report
Date: 08-Aug-2011 11:01:10 User:Gerald Barnes
[Start of Response]
Fixed by new queries delivered in workset AUDIT QUERIES _0437_V020-V019.
[End of Response]
Response code to call type ¥ as Category 2 -- Pending -- Progress update
[Dat e:08-Aug-2011 11:01:41 User:Gerald Barnes
Ibefect cause updated to 14: Development - Code
JDate:08-Aug-2011 11:01:48 Us
[fhe Call record has been tran
or:Gerald Barnes
ferred to the team: Dev-Int-Rel
bate:08-Aug-2011 11:10:03 User:PIT Automated User
lkeference Added: Product Baseline AUDIT QUERIES 0437 D020-D019
loate:08-Aug-2011 1.
[Start of Response]
Assigning to Integrator
[End of Response]
Response code to call type as Category 48 ()
[the incident has been transferred to the Team: Dev-Int-Rel
[fhe incident has been assigned to the Team Member: Geoff Inglis
6:54 User:PIT Automated User
JDate:09-Aug-2011 07:48:52 User:John Boston
Reference Added: 1
ldate:09-Aug-2011 1
[Start of Response]
Peak has been test installed in Integration. Moving to holding stack awaiting release
{End of Response]
Response code to call type as Category 47 ()
fhe incident has been transferred to the Team: Int-Rel
6:58 User:PIT Automated User
Date:09-Aug-2011 12:31:56 User:PIT Automated User
[Start of Response]
Integration testing complete, routing peak back to source.
{End of Response}
Response code to call type ¥ as Category 15 (Completed)
ffarget Date updated: new value is 11/08/2011 18:30
outing to Call Logger following Final Progress update.
Date:22-Aug-2011 15:52:35 User:dohn Boston
jpplied successfully to live Audit Servers 22/08/11. This fault peak can be closed.
FUJ00172241
FUJ00172241
bate:24-Aug-2011 12:53:41 User:Penny Thomas
[Start of Response]
lrix deployed; all appears to operating as required. Closing call.
lany thanks to all, Penny
[End of Response}
Response code to call type ¥ as Category 15 -- Final -- Completed
Routing to Call Logger following Final Progress update.
Date: 24-Aug-2011 12:53:47 User:Penny Thomas
lcaLL PC0211833 closed: Category 15 Type Y
Root Cause Development - Code
Logger Deleted User -- Security Ops
Subject Product General/Other/Misc -- Unknown General/Other/Misc (version unspecified)
Assignee Deleted User -- Security Ops
Last Progress 24-Aug-2011 12:53 -- Penny Thomas