Support #3374
SCP ID# 607 : KFH June 2013 (TAC) - NOT tally
Status: | Closed - End of life cycle | Start date: | July 31, 2013 | ||
---|---|---|---|---|---|
Priority: | Normal | Due 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.
History
#1 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 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 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 Updated by Ahmad Hazri about 11 years ago
- File table_export.xls added
- File table_export.csv added
#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 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.