POL00001500
POL00001500
Peak Incident Management System
Deleted User -- MSU-Indt Mgt
KEL obenge3120K
PC0175821
Reported In -- T86
Live Incidents/Defects
Deleted Contact
Speen
B -- Business restricted
Closed -- Solicited Known Error
Call reference PCO176680_
SSCKEL KEL obenge3120K
OCP OCP 21918
a
r:Claire Drake
‘Date:19-Feb-2009 12:28:09
SCALL PCO175821 opened
Details entered are:
isunmary:Branch 382137 - TPSC254 - Harvester Exception
call Typ
(call Priority:B
Warget Release: T36
Routed to:MSU-Indt Mgt - Claire Drake
ser:Claire Drake
sed on 18/02/2009.
Date:19-Feb-2009 12:28:09
§pSC254 - Harvester Exception report pro
Branch shows 5 new harvester exceptions.
Error message reads: ‘Could not update database: Updating table TMS_RX_BDC_TRANSACTIONS, ORA-02290: check constraint
[(orssres. BI7A_MARGIN PRODUCT CHK) violated"
elevant reports attached. KEL obengc3120K is relevan
I
‘Date:19-Feb-2009 12:28:20 User:Claire Drake
kReference Added: SSCKEL obengc3120K
Date:19-Feb-2009 12:28:36 User:Claire Drake
Added -
Date:19-Feb-2009 12:29:49 User:Claire Drake
21847 has been raised. Sending to EDSC for progression
While returning call, please include the POLFS and POLMIS file names, as given by the
script confirmtiprepair.
‘pate:19-Feb-2009 12:29:54 user:Mik Peach
21847 Approved
19-Feb-2009 12:30:00 User:Claire Drake
‘he Call record has been transferred to the team: EDSC
the Call record has been assigned to the Team Member: Catherine Obeng
Date:19-Feb-2009 17:39:40 User:Catherine Obeng
Where are two sides to the problem relating to these txns. The first is where all five SC txns missing core data as described
in the above mentioned KEL. Second is absence of equal but opposite [i.e. settlement] lines. See PCO152014 for a similar
Problem and now problem was resolved.
or the first problem, I have used the TR to insert the missing data i.e. Region, Margin, Margin Product and EffectiverxRate.
dl
Date:19-Feb-2009 18:03:01 User:Catherine Obeng
TL am on leave tomorrow and I believe the 2nd part of this call needs to be looked af fairly quickly. Lorraine please reassign
q
Date
ine
19-Feb-2009 18:03:12 User:Catherine Obeng
all record has been transferred to the team: ED:
F/485/1
POL00001500
POL00001500
(Date:20-Feb-2009 07:49:05 User:Lorraine Elliott
‘The Call record has been assigned to the Team Member: Garrett Simpson
Date:20-Feb-2009 10:15:00 User:Claire Drake
s discussed Garrett, this branch is appearing on the TPSC257 report dated
coday, 19/02/2009.
I have attached it for reference.
any thanks.
Date:20-Feb-2009 10:17:25 User:Claire Drake
Evidence Added - TPSC257 ~ 19/02/2009
Date:20-Feb-2009 10:56:27 Uscr:Garrett Simpson
[Start of Response]
Following the investigation shown in PC0152014 I analysed TPS_POL_FS_Summaries_Incomp where article_id='USD".
I found seven rows.
inree rows had Mode=RISP with total value=£-1940.64.
"Two rows had Mode-ROSP with total value=£2319.06.
Whe difference between these two figures is £378.42 but the total non-zero value for this branch is £989.96 so I have not
found the proper exception.
[End of Response]
Response code to call type L as Category 40 -- Pending ~~ Incident Under Investigation
Date:20-Feb-2009 11:42:57 User:Garrett Simpson
[Start of Response]
Using the ViewDBInfo tool ("virtual Martin") I found that session 44-382137-1-122871-1 had a net balance of £989.96 so this is
clearly the one I want.
This session involved ProductNo:5132 (Canada Dollar) £8.40, ProductNo:5128 (Euro) £282.64, ProductNo:5238 (Poland New Zloty)
£136.11 and ProductNo:5129 (USA Dollar) £562.81. There was also, in the afternoon, a reversal for the Canada Dollar currency.
ihe first four of these have a total value of £989.96. There was no settlement message written - hence the non-zero sum.
I will assume that the settlement was in cash - ProductNo:1.
This maps to ArticleID="Prcs'.
PS POL FS Summaries Incomp has one row where Article id='PICS' and its value is £-1086.89. I think I need to reduce this by
£989.96 giving £-2076.85
[End of Response]
Response code to call type L as Category 40 -- Pending -- Incident Under Investigation
jours spent since call received: 2 hours
Date:20-Feb-2009 13:22:46 User:Garrett Simpson
Defect cause updated to 14: Development - Code
Date:20-Feb-2009 14:05:57 User:Garrett Simpson
[start of Response]
ion noted earlier has three currencies sold with <Mode:SC> but no corresponding settlement line. I proposed adding cash
ico the summaries incomplete table to make it sum to zero.
Cheryl said it is easier to sort out the aftereffects if I adjust the three currencies instead. She is investigating further.
[End of Response]
Response code to call type
as Category 40 ~~ Pendir Incident Under Investigation
Date:20-Feb-2009 15:17:55 User:Garrett Simpson
[Start of Response]
ProductNo:5132 maps to Article ID='CAD'. This article has six rows in summaries incomplete: three have Mode:RISP with values
36.51, -72.27 and -8.40. Two have Mode:ROSP and values 72.27 and 72.27. The final one has Mode:SC and value £0.00.
[End of Response]
sponse code to call type L as Category 40 -- Pending -- Incident Under Investigation
Date:20-Feb-2009 16:02:57 User:Garrett Simpson
[Start of Response]
After discussion with Cheryl and David I think the situation was this:-
1) The session at 11:52 had four Mode:SC transactions for different currencies. Each one of these messages was missing
andatory fields so the harvester rejected them. These messages added up to £989.96.
) The harvester rejections caused the whole day's transactions to go to the incomplete summaries table - without the four
messages rejected by the harvester.
5) The session at 11:52 was missing its settlement message. Its value would have been £-989.96.
M) The result so far is that the summaries incomplete table is short of five messages but its value totals zero.
5) Catherine used the TRT to repair four messa
6) These four messages were sent to POLMIS in file W_049800.
7) The same four messages were now added to the summaries incomplete table so that now has a sum of £989.96. This will now not
0 to POLFS.
Looking at the summaries incomplete table I see 40 rows inserted on 18-Feb and 4 rows inserted on 19-Feb.
[End of Response]
Response code to call type L as Category 40 -- Pendir
jours spent since call received: 3 hours
- Incident Under Inve:
tigation
F/485/2
POL00001500
POL00001500
ate:20-Feb-2009 16:04:45 Uscr:Garzett Simpson
‘The Call record has been assigned to the Team Member: Catherine obeng
ep
GB
te:23-Feb-2009 11:42:23 User:Garrett Simpson
Start of Response]
ether comment :
3s I reported at 11:42 on 20-Feb, the Canada Dollar transaction of £8.40 was reversed later in the day. Therefore my point (4)
f 16:02 on 20-Feb was wrong. The total values in the incomplete summaries table was £8.40.
See evidence file Summ_Incomp.txt
[End of Response]
esponse code to call type L as Category 40 -- Pendini
Hours spent since call received: 0.5 hours
pg
2
- Incident Under Investigation
Date:23-Feb-2009 11:43:05 User:Garrett Simpson
Evidence Added - Summary of Incomplete Summaries table
‘Date:23-Feb-2009 12:20:37 User:Anne Chambers
l[start of Response]
{I tried to contact the PM (who has raised 2 calls but been sent to the NBSC) to say it was a system problem. Not available
funtil tomorrow, The branch has a loss of just under £1000.
This is even more complicated than described above. The set of SC transactions was almost certainly written when a s
reversal (RISP) was initiated (via a barcode scan) before thé
set
nd pouch
first was complete. Instead of writing the set of RISP messages,
tled to the ‘currency in pouches’, it wrote a set of badly formed SC messages with no settlement at all.
hese had the sign on the Pgty attribute opposite to the sign on the SaleValue (so the stock quantity was reduced but the
tock value increased). When they balanced on 19th Feb, the quantity was corrected via a DDN (and converted to a cash loss) and
there was a large revaluation up. This data has already been fed into POLFS.
[End of Response]
Response code to call type L as Category 40 -- Pending -- In
cident Under Investigation
‘Date:02-Mar-2009 10:12:22 User:Anne Chambers
Evidence Added - Email trail including go-ahead from POL
Date:02-Mar-2009 17:33:04 User:Catherine Obeng
cR_21847 actioned
‘Date:03-Mar-2009 09:49:51 User:Anne Chambers
Evidence Added - Messages prepared for insertion and after insertion
‘Date:03-Mar-2009 16:58:31 User:Catherine Obeng
[Start of Response]
The four txns were sent to POLFS in file IF20090302065.BLE. POLMIS file ref is W_049800.7P.
[End of Response]
esponse code to call type L as Category 40 -- Pending -- Incident Under Investigation
Date:06-Mar-2009 10:25:29 User:Anne Chambers
Reference Added: Call reference PCO1I6680
‘Date:06-Mar-2009 10:26:24 User:Anne Chambers
[I[start of Response]
Whe correction caused a further set of harvester exceptions and incomplete summary lines, which have been dealt with under
1PC0176680.
i[Bnd of Response]
Tesponse code to call type L as Category 40 -- Pending -- Incident Under Investigation
ate:06-Mar-2009 10:30:40 User:Anne Chambers
[Start of Response]
‘Whe branch rolled over on 4th March, with the expected R&P mismatch but not the gain they should have had. Further
investigation found that the clerk had declared currency to match the system figures and not actually the currency on hand.
POL contacted the manager and on 5th March they did another balance with the correct declarations. They currently have a net
jgain of £10.85.
[End of Response]
sponse code to call type L as Category 40 -- Pendin
Incident Under Investigation
Date:06-Mar-2009 10:32:29 User:Anne Chambers
Reference Added: ocr 21918
bate: 13-Mar-2009 14:43:39 User:Catherine Obeng
[[start of Response]
[POL agreed to SSC taking corrective measures by inserting messages which caused an equal but opposite effect. Office produced a
IBT statement on 11-03-2009 which confirm all is right again i.e. no R&Ps mismatch. There should be no further problems
aresulting from these corrective actions. Please see the attached emails for the contacts in POL who agreed to this work to be
karried out.
4
Routing back to MSU for final closure.
‘[End of Response]
esponse code to call type L as Category 40 ~~ Pending -- Incident Under Investigation
F/485/3
POL00001500
POL00001500
Catherine Obeng
teal
erred to
[Start of Respon
‘hank you.
I have issued a BIMS to POL for audit purposes.
ponse]
de to call type L as Category 67 ~~ Final -- Solicited Known
Routing to Call Logger following Final Progress update.
2 User:Claire Drake
CALL PCO175821 closed: Category 67 Type L
evelopment - Code
eleted User - MSU-Indt ‘Mat
POSS & DeskTop -- Balancing (version unspecified)
eleted User -- MSU-Indt ‘Mgt -
20-Mar-2009 11:41 -- Claire Drake
F/485/4