Support #3374

Avatar?id=1733&size=50

SCP ID# 607 : KFH June 2013 (TAC) - NOT tally

Added by Ahmad Hazri about 11 years ago. Updated almost 11 years ago.

Status:Closed - End of life cycleStart date:July 31, 2013
Priority:NormalDue date:
Assignee:Nor Shuhaida Subri% Done:

60%

Category:-Spent time:-
Target version:-

Description

Reported by Norsurianie

The below TAC info was not reflected in BVMC TAC Issuance Report for the month of June 2013.
Could you please check and revert whether the below TAC info was captured at our end or not.

Doc1.docx (177 KB) Ahmad Hazri , July 31, 2013 11:51

table_export.xls (3.21 MB) Ahmad Hazri , July 31, 2013 12:19

table_export.csv Magnifier (1.95 MB) Ahmad Hazri , July 31, 2013 12:19

History

#1 Avatar?id=1733&size=24 Updated by Ahmad Hazri about 11 years ago

  • File Doc1.docx added
  • Status changed from New - Begin Life Cycle to Development / Work In Progress

#2 Avatar?id=1733&size=24 Updated by Ahmad Hazri about 11 years ago

Updated by Shuhaida but result is empty

Please run this query under PRODUCTION TABLE SCHEMA BVUSERPRD

1) SELECT * FROM SMS_TABLE WHERE SMS_GUID='f598ef83a8e347b4900a3ac0e2096928';

2) SELECT * FROM SMS_TABLE WHERE SMS_GUID='4067df84d8eb42d989775f6c66c7b2a2';

3) SELECT * FROM SMS_TABLE WHERE SMS_GUID='02da1b8c761545b9a7e8becfcf4280f8';

4) SELECT * FROM SMS_TABLE WHERE SMS_GUID='a29131352977452c8e72cc1a0d8e9022';

5) SELECT * FROM SMS_TABLE WHERE SMS_GUID='81da080dbede4dccbe3245b6f48ab5a6';

6) SELECT * FROM SMS_TABLE WHERE SMS_GUID='ed2c416195c0443b97f54a0e4730d0dd';

7) SELECT * FROM SMS_TABLE WHERE SMS_GUID='5ca9c7eb800d4e4f80856b8c56393c0b';

8) SELECT * FROM SMS_TABLE WHERE SMS_GUID='28cc9e55f59b4629b5e99995cb9e82b9';

9) SELECT * FROM SMS_TABLE WHERE SMS_GUID='d242a0928ffb49a891a0aee427092942';

10) SELECT * FROM SMS_TABLE WHERE SMS_GUID='485d99b0e4fc4124b8b58b62250c2e26';

11) SELECT * FROM SMS_TABLE WHERE SMS_GUID='411dca8daa7441d0959bf6be29bb1416';

12) SELECT * FROM SMS_TABLE WHERE SMS_GUID='29a055f4d9744e99a46083e04bc0607a';

13) SELECT * FROM SMS_TABLE WHERE SMS_GUID='3c6b589bd6ed44ccb3ea4ca3527faf3c';

14) SELECT * FROM SMS_TABLE WHERE SMS_GUID='dd31a57462904f7d917ae66d30e62669';

15) SELECT * FROM SMS_TABLE WHERE SMS_GUID='5fb9af97a73f427f8da983a5065a0466';

#3 Avatar?id=1733&size=24 Updated by Ahmad Hazri about 11 years ago

Updated by Shuhaida

Please run below script under Production BVUSERPRD schema and revert us the ouput  in CSV and TXT file

select * from sms_table where sms_createstamp between to_date('01/06/2013', 'dd/MM/yyyy') and to_date('30/06/2013', 'dd/MM/yyyy');

awaiting the customer reply

#4 Avatar?id=1733&size=24 Updated by Ahmad Hazri about 11 years ago

#5 Updated by Nor Shuhaida Subri about 11 years ago

i need data in TXT file also

#6 Updated by Nor Shuhaida Subri about 11 years ago

Hi Chooi,

Please provide report on June for:-
1) TAC Issuance Report
2) SMS Report

#7 Updated by Norhaidah Md Dasuki almost 11 years ago

  • % Done changed from 0 to 60

Hi Shuhaida,
You may retrieve the TAC & SMS Reports from the following share folder:
\\10.20.8.124\Shared\LOG\31072013_TAG&SMSreports

Please assist to confirm that this issue has been resolved or not. Thank you.

#8 Updated by Norhaidah Md Dasuki almost 11 years ago

  • Subject changed from KFH June 2013 (TAC) - NOT tally (SCP ID : 607) to SCP ID# 607 : KFH June 2013 (TAC) - NOT tally

#9 Avatar?id=1733&size=24 Updated by Ahmad Hazri almost 11 years ago

  • Status changed from Development / Work In Progress to Closed - End of life cycle

Closing this case. The fix for this issue has been released on April 18,2013.
Email sent by Vincent to Chooi with Subject: Gental Reminder: KFH Production Issues & Pending Items.
But yet to deploy in production.

Also available in: Atom PDF