Production Ticket(ST) #11253
Goldcrest Hotline - hi, user MCJ unable restore database
Based on our stimulation , the path is di table is not same as actual table , this is because in actual table we it is taking UTC time therefore it is take one day before. suppose to be 20 but in the database is 19th of march
already confirm with shu ern she claimed that this issue already fix and pending deployment
root cause- data does not flow from di_table to actual table cause of UTC
None
History
#1 Updated by Muhammed Azhar Mohamed Maideen 6 months ago
- Status changed from Assigned To to Support In Progress
#2 Updated by Muhammed Azhar Mohamed Maideen 6 months ago
- Status changed from Support In Progress to Pending Client Verification
- Resolution updated (diff)
select top 1 * from di_mobile_database where login_id= 'mcj' order by created_date desc
select top 1 * from txn_mobile_database where login_id= 'mcj' order by created_date desc
-- GOLDCREST/RealmDatabase/2024-03-20/2c9e40b5f5904775b71192b8fd8b71ad/2c9e40b5f5904775b71192b8fd8b71ad/GOLDCREST-MCJ-2024032004030453.zip
-- /GOLDCREST/MobileUpload/RealmDatabase/2024-03-19/2c9e40b5f5904775b71192b8fd8b71ad/2c9e40b5f5904775b71192b8fd8b71ad/GOLDCREST-MCJ-2024032004030453.zip
-- it is UTC time
--select * into DMS_EcoSystem_backup_table.dbo._txn_mobile_database_20240320
--from DMS_EcoSystem.dbo.txn_mobile_database
-- UPDATE txn_mobile_database
--SET database_path = '/GOLDCREST/MobileUpload/RealmDatabase/2024-03-20/2c9e40b5f5904775b71192b8fd8b71ad/2c9e40b5f5904775b71192b8fd8b71ad/GOLDCREST-MCJ-2024032004030453.zip'
-- , updated_date = '2024-03-20 04:03:06.210'
--WHERE member_id = '2c9e40b5f5904775b71192b8fd8b71ad'
--and id= '8F4D37A6-F99B-432A-93CE-7CE63B244994'
-- ;
#3 Updated by Muhammed Azhar Mohamed Maideen 6 months ago
- Status changed from Pending Client Verification to Ticket Resolved
- Type set to Support Request
- Actual Initial Response set to 21/03/2024