[2023-05-01 Mon 21:57:33] : *********************** START **************************
[2023-05-01 Mon 21:57:33] : select id, status_code from status_code where status='Active'
[2023-05-01 Mon 21:57:33] : Status Code Result: 2
[2023-05-01 Mon 21:57:33] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2023-05-01 Mon 21:57:33] : App Info Result: 1
[2023-05-01 Mon 21:57:33] : <<<<<<<<<<<<<<<<<<<<START App Info Loop (Unet Enterprise Banking and Apple I Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:57:33] : Batch ID: 2023-05-01 21:57:33#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking
[2023-05-01 Mon 21:57:33] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:57:33] : APP_VERSION
[2023-05-01 Mon 21:57:35] : 1.0.7
[2023-05-01 Mon 21:57:35] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (6,2,'1.0.7','2023-05-01 21:57:33#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking','2023-05-01','2023-05-01 21:57:33','2023-05-01 17:57:33','get-app-info.php')
[2023-05-01 Mon 21:57:35] : 1
[2023-05-01 Mon 21:57:35] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:57:35] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:57:35] : APP_LAST_UPDATE
[2023-05-01 Mon 21:57:37] : 2023-01-09
[2023-05-01 Mon 21:57:37] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (6,5,'2023-01-09','2023-05-01 21:57:33#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking','2023-05-01','2023-05-01 21:57:33','2023-05-01 17:57:33','get-app-info.php')
[2023-05-01 Mon 21:57:37] : 1
[2023-05-01 Mon 21:57:37] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:57:37] : <<<<<<<<<<<<<<<<<<<<END App Info Loop (Unet Enterprise Banking and Apple I Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:57:37] : Connection closed
[2023-05-01 Mon 21:57:37] : ************************ END ***************************
[2023-05-01 Mon 21:58:07] : *********************** START **************************
[2023-05-01 Mon 21:58:07] : select id, status_code from status_code where status='Active'
[2023-05-01 Mon 21:58:07] : Status Code Result: 2
[2023-05-01 Mon 21:58:07] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2023-05-01 Mon 21:58:07] : App Info Result: 6
[2023-05-01 Mon 21:58:07] : <<<<<<<<<<<<<<<<<<<<START App Info Loop (Unet and Google Play Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:07] : Batch ID: 2023-05-01 21:58:07#Google Play Store#AppInfoId_1#AppName_Unet
[2023-05-01 Mon 21:58:07] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:07] : APP_VERSION
[2023-05-01 Mon 21:58:09] : 3.25
[2023-05-01 Mon 21:58:09] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (1,2,'3.25','2023-05-01 21:58:07#Google Play Store#AppInfoId_1#AppName_Unet','2023-05-01','2023-05-01 21:58:07','2023-05-01 17:58:07','get-app-info.php')
[2023-05-01 Mon 21:58:09] : 1
[2023-05-01 Mon 21:58:09] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:09] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:09] : APP_LAST_UPDATE
[2023-05-01 Mon 21:58:12] : 2023-03-18
[2023-05-01 Mon 21:58:12] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (1,5,'2023-03-18','2023-05-01 21:58:07#Google Play Store#AppInfoId_1#AppName_Unet','2023-05-01','2023-05-01 21:58:07','2023-05-01 17:58:07','get-app-info.php')
[2023-05-01 Mon 21:58:12] : 1
[2023-05-01 Mon 21:58:12] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:12] : <<<<<<<<<<<<<<<<<<<<END App Info Loop (Unet and Google Play Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:12] : <<<<<<<<<<<<<<<<<<<<START App Info Loop (UClick and Google Play Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:12] : Batch ID: 2023-05-01 21:58:07#Google Play Store#AppInfoId_2#AppName_UClick
[2023-05-01 Mon 21:58:12] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:12] : APP_VERSION
[2023-05-01 Mon 21:58:14] : 1.0.0.6
[2023-05-01 Mon 21:58:14] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,2,'1.0.0.6','2023-05-01 21:58:07#Google Play Store#AppInfoId_2#AppName_UClick','2023-05-01','2023-05-01 21:58:07','2023-05-01 17:58:07','get-app-info.php')
[2023-05-01 Mon 21:58:14] : 1
[2023-05-01 Mon 21:58:14] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:14] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:14] : APP_LAST_UPDATE
[2023-05-01 Mon 21:58:16] : 2022-09-27
[2023-05-01 Mon 21:58:16] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,5,'2022-09-27','2023-05-01 21:58:07#Google Play Store#AppInfoId_2#AppName_UClick','2023-05-01','2023-05-01 21:58:07','2023-05-01 17:58:07','get-app-info.php')
[2023-05-01 Mon 21:58:16] : 1
[2023-05-01 Mon 21:58:16] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:16] : <<<<<<<<<<<<<<<<<<<<END App Info Loop (UClick and Google Play Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:16] : <<<<<<<<<<<<<<<<<<<<START App Info Loop (Unet Enterprise Banking and Google Play Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:16] : Batch ID: 2023-05-01 21:58:07#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking
[2023-05-01 Mon 21:58:16] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:16] : APP_VERSION
[2023-05-01 Mon 21:58:18] : 1.0.10
[2023-05-01 Mon 21:58:18] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (3,2,'1.0.10','2023-05-01 21:58:07#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking','2023-05-01','2023-05-01 21:58:07','2023-05-01 17:58:07','get-app-info.php')
[2023-05-01 Mon 21:58:18] : 1
[2023-05-01 Mon 21:58:18] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:18] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:18] : APP_LAST_UPDATE
[2023-05-01 Mon 21:58:20] : 2023-03-18
[2023-05-01 Mon 21:58:20] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (3,5,'2023-03-18','2023-05-01 21:58:07#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking','2023-05-01','2023-05-01 21:58:07','2023-05-01 17:58:07','get-app-info.php')
[2023-05-01 Mon 21:58:20] : 1
[2023-05-01 Mon 21:58:20] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:20] : <<<<<<<<<<<<<<<<<<<<END App Info Loop (Unet Enterprise Banking and Google Play Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:20] : <<<<<<<<<<<<<<<<<<<<START App Info Loop (UCB Unet and Apple I Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:20] : Batch ID: 2023-05-01 21:58:07#Apple I Store#AppInfoId_4#AppName_UCB Unet
[2023-05-01 Mon 21:58:20] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:20] : APP_VERSION
[2023-05-01 Mon 21:58:31] : 2.2.7
[2023-05-01 Mon 21:58:31] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,2,'2.2.7','2023-05-01 21:58:07#Apple I Store#AppInfoId_4#AppName_UCB Unet','2023-05-01','2023-05-01 21:58:07','2023-05-01 17:58:07','get-app-info.php')
[2023-05-01 Mon 21:58:31] : 1
[2023-05-01 Mon 21:58:31] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:31] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:31] : APP_LAST_UPDATE
[2023-05-01 Mon 21:58:34] : 2023-01-26
[2023-05-01 Mon 21:58:34] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,5,'2023-01-26','2023-05-01 21:58:07#Apple I Store#AppInfoId_4#AppName_UCB Unet','2023-05-01','2023-05-01 21:58:07','2023-05-01 17:58:07','get-app-info.php')
[2023-05-01 Mon 21:58:34] : 1
[2023-05-01 Mon 21:58:34] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:34] : <<<<<<<<<<<<<<<<<<<<END App Info Loop (UCB Unet and Apple I Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:34] : <<<<<<<<<<<<<<<<<<<<START App Info Loop (UClick and Apple I Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:34] : Batch ID: 2023-05-01 21:58:07#Apple I Store#AppInfoId_5#AppName_UClick
[2023-05-01 Mon 21:58:34] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:34] : APP_VERSION
[2023-05-01 Mon 21:58:36] : 1.0.6
[2023-05-01 Mon 21:58:36] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,2,'1.0.6','2023-05-01 21:58:07#Apple I Store#AppInfoId_5#AppName_UClick','2023-05-01','2023-05-01 21:58:07','2023-05-01 17:58:07','get-app-info.php')
[2023-05-01 Mon 21:58:36] : 1
[2023-05-01 Mon 21:58:36] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:36] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:36] : APP_LAST_UPDATE
[2023-05-01 Mon 21:58:42] : 2022-09-29
[2023-05-01 Mon 21:58:42] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,5,'2022-09-29','2023-05-01 21:58:07#Apple I Store#AppInfoId_5#AppName_UClick','2023-05-01','2023-05-01 21:58:07','2023-05-01 17:58:07','get-app-info.php')
[2023-05-01 Mon 21:58:43] : 1
[2023-05-01 Mon 21:58:43] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:43] : <<<<<<<<<<<<<<<<<<<<END App Info Loop (UClick and Apple I Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:43] : <<<<<<<<<<<<<<<<<<<<START App Info Loop (Unet Enterprise Banking and Apple I Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:43] : Batch ID: 2023-05-01 21:58:07#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking
[2023-05-01 Mon 21:58:43] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:43] : APP_VERSION
[2023-05-01 Mon 21:58:44] : 1.0.7
[2023-05-01 Mon 21:58:44] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (6,2,'1.0.7','2023-05-01 21:58:07#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking','2023-05-01','2023-05-01 21:58:07','2023-05-01 17:58:07','get-app-info.php')
[2023-05-01 Mon 21:58:44] : 1
[2023-05-01 Mon 21:58:44] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:44] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:44] : APP_LAST_UPDATE
[2023-05-01 Mon 21:58:46] : 2023-01-09
[2023-05-01 Mon 21:58:46] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (6,5,'2023-01-09','2023-05-01 21:58:07#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking','2023-05-01','2023-05-01 21:58:07','2023-05-01 17:58:07','get-app-info.php')
[2023-05-01 Mon 21:58:46] : 1
[2023-05-01 Mon 21:58:46] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:46] : <<<<<<<<<<<<<<<<<<<<END App Info Loop (Unet Enterprise Banking and Apple I Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 21:58:46] : Connection closed
[2023-05-01 Mon 21:58:46] : ************************ END ***************************
[2023-05-01 Mon 22:23:13] : *********************** START Data Parsin Error Checker**************************
[2023-05-01 Mon 22:23:13] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2023-05-01'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2023-05-01 Mon 22:23:13] : Total Record Fetch: 14
[2023-05-01 Mon 22:23:39] : *********************** START Data Parsin Error Checker**************************
[2023-05-01 Mon 22:23:39] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2023-05-01'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2023-05-01 Mon 22:23:39] : Total Record Fetch: 14
[2023-05-01 Mon 22:23:39] : Nothing to Process
[2023-05-01 Mon 22:23:39] : Nothing to Process
[2023-05-01 Mon 22:23:39] : Nothing to Process
[2023-05-01 Mon 22:23:39] : Nothing to Process
[2023-05-01 Mon 22:23:39] : Nothing to Process
[2023-05-01 Mon 22:23:39] : Nothing to Process
[2023-05-01 Mon 22:23:39] : Nothing to Process
[2023-05-01 Mon 22:23:39] : Nothing to Process
[2023-05-01 Mon 22:23:39] : Nothing to Process
[2023-05-01 Mon 22:23:39] : Nothing to Process
[2023-05-01 Mon 22:23:39] : Nothing to Process
[2023-05-01 Mon 22:23:39] : Nothing to Process
[2023-05-01 Mon 22:23:39] : Nothing to Process
[2023-05-01 Mon 22:23:39] : Nothing to Process
[2023-05-01 Mon 22:23:45] : Mail sent on 2023-05-01 22:23:39
[2023-05-01 Mon 22:23:45] : Connection closed
[2023-05-01 Mon 22:23:45] : ************************ END ***************************
[2023-05-01 Mon 22:24:16] : *********************** START Data Parsin Error Checker**************************
[2023-05-01 Mon 22:24:16] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2023-05-01'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2023-05-01 Mon 22:24:16] : Total Record Fetch: 14
[2023-05-01 Mon 22:24:16] : APP_LAST_UPDATE
[2023-05-01 Mon 22:24:43] : *********************** START Data Parsin Error Checker**************************
[2023-05-01 Mon 22:24:43] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2023-05-01'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2023-05-01 Mon 22:24:43] : Total Record Fetch: 14
[2023-05-01 Mon 22:24:43] : APP_LAST_UPDATE
[2023-05-01 Mon 22:24:43] : APP_VERSION
[2023-05-01 Mon 22:26:01] : *********************** START Data Parsin Error Checker**************************
[2023-05-01 Mon 22:26:01] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2023-05-01'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2023-05-01 Mon 22:26:01] : Total Record Fetch: 14
[2023-05-01 Mon 22:26:01] : APP_LAST_UPDATE
[2023-05-01 Mon 22:26:01] : APP_VERSION
[2023-05-01 Mon 22:27:08] : *********************** START Data Parsin Error Checker**************************
[2023-05-01 Mon 22:27:08] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2023-05-01'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2023-05-01 Mon 22:27:08] : Total Record Fetch: 14
[2023-05-01 Mon 22:27:08] : APP_LAST_UPDATE
[2023-05-01 Mon 22:27:08] : APP_VERSION
[2023-05-01 Mon 22:29:05] : *********************** START **************************
[2023-05-01 Mon 22:29:05] : select id, status_code from status_code where status='Active'
[2023-05-01 Mon 22:29:05] : Status Code Result: 2
[2023-05-01 Mon 22:29:05] : select id, app_store, app_name, app_url from app_info where scheduler_status='Active' and status='Active'
[2023-05-01 Mon 22:29:05] : App Info Result: 6
[2023-05-01 Mon 22:29:05] : <<<<<<<<<<<<<<<<<<<<START App Info Loop (Unet and Google Play Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:05] : Batch ID: 2023-05-01 22:29:05#Google Play Store#AppInfoId_1#AppName_Unet
[2023-05-01 Mon 22:29:05] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:05] : APP_VERSION
[2023-05-01 Mon 22:29:06] : 3.25
[2023-05-01 Mon 22:29:06] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (1,2,'3.25','2023-05-01 22:29:05#Google Play Store#AppInfoId_1#AppName_Unet','2023-05-01','2023-05-01 22:29:05','2023-05-01 18:29:05','get-app-info.php')
[2023-05-01 Mon 22:29:06] : 1
[2023-05-01 Mon 22:29:06] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:06] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:06] : APP_LAST_UPDATE
[2023-05-01 Mon 22:29:08] : 2023-03-18
[2023-05-01 Mon 22:29:08] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (1,5,'2023-03-18','2023-05-01 22:29:05#Google Play Store#AppInfoId_1#AppName_Unet','2023-05-01','2023-05-01 22:29:05','2023-05-01 18:29:05','get-app-info.php')
[2023-05-01 Mon 22:29:08] : 1
[2023-05-01 Mon 22:29:08] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:08] : <<<<<<<<<<<<<<<<<<<<END App Info Loop (Unet and Google Play Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:08] : <<<<<<<<<<<<<<<<<<<<START App Info Loop (UClick and Google Play Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:08] : Batch ID: 2023-05-01 22:29:05#Google Play Store#AppInfoId_2#AppName_UClick
[2023-05-01 Mon 22:29:08] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:08] : APP_VERSION
[2023-05-01 Mon 22:29:09] : 1.0.0.6
[2023-05-01 Mon 22:29:09] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,2,'1.0.0.6','2023-05-01 22:29:05#Google Play Store#AppInfoId_2#AppName_UClick','2023-05-01','2023-05-01 22:29:05','2023-05-01 18:29:05','get-app-info.php')
[2023-05-01 Mon 22:29:09] : 1
[2023-05-01 Mon 22:29:09] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:09] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:09] : APP_LAST_UPDATE
[2023-05-01 Mon 22:29:10] : 2022-09-27
[2023-05-01 Mon 22:29:10] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (2,5,'2022-09-27','2023-05-01 22:29:05#Google Play Store#AppInfoId_2#AppName_UClick','2023-05-01','2023-05-01 22:29:05','2023-05-01 18:29:05','get-app-info.php')
[2023-05-01 Mon 22:29:10] : 1
[2023-05-01 Mon 22:29:10] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:10] : <<<<<<<<<<<<<<<<<<<<END App Info Loop (UClick and Google Play Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:10] : <<<<<<<<<<<<<<<<<<<<START App Info Loop (Unet Enterprise Banking and Google Play Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:10] : Batch ID: 2023-05-01 22:29:05#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking
[2023-05-01 Mon 22:29:10] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:10] : APP_VERSION
[2023-05-01 Mon 22:29:13] : 1.0.10
[2023-05-01 Mon 22:29:13] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (3,2,'1.0.10','2023-05-01 22:29:05#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking','2023-05-01','2023-05-01 22:29:05','2023-05-01 18:29:05','get-app-info.php')
[2023-05-01 Mon 22:29:13] : 1
[2023-05-01 Mon 22:29:13] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:13] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:13] : APP_LAST_UPDATE
[2023-05-01 Mon 22:29:15] : 2023-03-18
[2023-05-01 Mon 22:29:15] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (3,5,'2023-03-18','2023-05-01 22:29:05#Google Play Store#AppInfoId_3#AppName_Unet Enterprise Banking','2023-05-01','2023-05-01 22:29:05','2023-05-01 18:29:05','get-app-info.php')
[2023-05-01 Mon 22:29:15] : 1
[2023-05-01 Mon 22:29:15] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:15] : <<<<<<<<<<<<<<<<<<<<END App Info Loop (Unet Enterprise Banking and Google Play Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:15] : <<<<<<<<<<<<<<<<<<<<START App Info Loop (UCB Unet and Apple I Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:15] : Batch ID: 2023-05-01 22:29:05#Apple I Store#AppInfoId_4#AppName_UCB Unet
[2023-05-01 Mon 22:29:15] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:15] : APP_VERSION
[2023-05-01 Mon 22:29:16] : 2.2.7
[2023-05-01 Mon 22:29:16] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,2,'2.2.7','2023-05-01 22:29:05#Apple I Store#AppInfoId_4#AppName_UCB Unet','2023-05-01','2023-05-01 22:29:05','2023-05-01 18:29:05','get-app-info.php')
[2023-05-01 Mon 22:29:16] : 1
[2023-05-01 Mon 22:29:16] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:16] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:16] : APP_LAST_UPDATE
[2023-05-01 Mon 22:29:17] : 2023-01-26
[2023-05-01 Mon 22:29:17] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (4,5,'2023-01-26','2023-05-01 22:29:05#Apple I Store#AppInfoId_4#AppName_UCB Unet','2023-05-01','2023-05-01 22:29:05','2023-05-01 18:29:05','get-app-info.php')
[2023-05-01 Mon 22:29:17] : 1
[2023-05-01 Mon 22:29:17] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:17] : <<<<<<<<<<<<<<<<<<<<END App Info Loop (UCB Unet and Apple I Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:17] : <<<<<<<<<<<<<<<<<<<<START App Info Loop (UClick and Apple I Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:17] : Batch ID: 2023-05-01 22:29:05#Apple I Store#AppInfoId_5#AppName_UClick
[2023-05-01 Mon 22:29:17] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:17] : APP_VERSION
[2023-05-01 Mon 22:29:19] : 1.0.6
[2023-05-01 Mon 22:29:19] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,2,'1.0.6','2023-05-01 22:29:05#Apple I Store#AppInfoId_5#AppName_UClick','2023-05-01','2023-05-01 22:29:05','2023-05-01 18:29:05','get-app-info.php')
[2023-05-01 Mon 22:29:19] : 1
[2023-05-01 Mon 22:29:19] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:19] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:19] : APP_LAST_UPDATE
[2023-05-01 Mon 22:29:22] : 2022-09-29
[2023-05-01 Mon 22:29:22] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (5,5,'2022-09-29','2023-05-01 22:29:05#Apple I Store#AppInfoId_5#AppName_UClick','2023-05-01','2023-05-01 22:29:05','2023-05-01 18:29:05','get-app-info.php')
[2023-05-01 Mon 22:29:22] : 1
[2023-05-01 Mon 22:29:22] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:22] : <<<<<<<<<<<<<<<<<<<<END App Info Loop (UClick and Apple I Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:22] : <<<<<<<<<<<<<<<<<<<<START App Info Loop (Unet Enterprise Banking and Apple I Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:22] : Batch ID: 2023-05-01 22:29:05#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking
[2023-05-01 Mon 22:29:22] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:22] : APP_VERSION
[2023-05-01 Mon 22:29:23] : 1.0.7
[2023-05-01 Mon 22:29:23] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (6,2,'1.0.7','2023-05-01 22:29:05#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking','2023-05-01','2023-05-01 22:29:05','2023-05-01 18:29:05','get-app-info.php')
[2023-05-01 Mon 22:29:23] : 1
[2023-05-01 Mon 22:29:23] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_VERSION --> 2)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:23] : <<<<<<<<<<<<<<<<<<<<START Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:23] : APP_LAST_UPDATE
[2023-05-01 Mon 22:29:25] : 2023-01-09
[2023-05-01 Mon 22:29:25] : INSERT INTO app_info_status (app_info_id, status_code_id, status_value, batch_id, executed_date, executed_at_bd_time, executed_at_server_time, which_script) VALUES (6,5,'2023-01-09','2023-05-01 22:29:05#Apple I Store#AppInfoId_6#AppName_Unet Enterprise Banking','2023-05-01','2023-05-01 22:29:05','2023-05-01 18:29:05','get-app-info.php')
[2023-05-01 Mon 22:29:25] : 1
[2023-05-01 Mon 22:29:25] : <<<<<<<<<<<<<<<<<<<<END Status Code wise Info Fetch(APP_LAST_UPDATE --> 5)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:25] : <<<<<<<<<<<<<<<<<<<<END App Info Loop (Unet Enterprise Banking and Apple I Store)>>>>>>>>>>>>>>>>>>>>
[2023-05-01 Mon 22:29:25] : Connection closed
[2023-05-01 Mon 22:29:25] : ************************ END ***************************
[2023-05-01 Mon 22:36:08] : *********************** START Data Parsin Error Checker**************************
[2023-05-01 Mon 22:36:08] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2023-05-01'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2023-05-01 Mon 22:36:08] : Total Record Fetch: 12
[2023-05-01 Mon 22:36:08] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-26<br />
[2023-05-01 Mon 22:36:08] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.2.7<br />
[2023-05-01 Mon 22:36:08] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-29<br />
[2023-05-01 Mon 22:36:08] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.6<br />
[2023-05-01 Mon 22:36:08] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-09<br />
[2023-05-01 Mon 22:36:08] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.7<br />
[2023-05-01 Mon 22:36:08] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-27<br />
[2023-05-01 Mon 22:36:08] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.0.6<br />
[2023-05-01 Mon 22:36:08] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:36:08] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.25<br />
[2023-05-01 Mon 22:36:08] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:36:08] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.10<br />
[2023-05-01 Mon 22:36:20] : Mail sent on 2023-05-01 22:36:08
[2023-05-01 Mon 22:36:20] : Connection closed
[2023-05-01 Mon 22:36:20] : ************************ END ***************************
[2023-05-01 Mon 22:37:20] : *********************** START Data Parsin Error Checker**************************
[2023-05-01 Mon 22:37:20] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2023-05-01'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2023-05-01 Mon 22:37:20] : Total Record Fetch: 12
[2023-05-01 Mon 22:37:20] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-26<br />
[2023-05-01 Mon 22:37:20] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.2.7<br />
[2023-05-01 Mon 22:37:20] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-29<br />
[2023-05-01 Mon 22:37:20] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.6<br />
[2023-05-01 Mon 22:37:20] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-09<br />
[2023-05-01 Mon 22:37:20] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.7<br />
[2023-05-01 Mon 22:37:20] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-27<br />
[2023-05-01 Mon 22:37:20] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.0.6<br />
[2023-05-01 Mon 22:37:20] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:37:20] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.25<br />
[2023-05-01 Mon 22:37:20] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:37:20] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.10<br />
[2023-05-01 Mon 22:37:26] : Mail sent on 2023-05-01 22:37:20
[2023-05-01 Mon 22:37:26] : Connection closed
[2023-05-01 Mon 22:37:26] : ************************ END ***************************
[2023-05-01 Mon 22:39:38] : *********************** START Data Parsin Error Checker**************************
[2023-05-01 Mon 22:39:38] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2023-05-01'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2023-05-01 Mon 22:39:38] : Total Record Fetch: 12
[2023-05-01 Mon 22:39:38] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-26<br />
[2023-05-01 Mon 22:39:38] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.2.7<br />
[2023-05-01 Mon 22:39:38] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-29<br />
[2023-05-01 Mon 22:39:38] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.6<br />
[2023-05-01 Mon 22:39:38] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-09<br />
[2023-05-01 Mon 22:39:38] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.7<br />
[2023-05-01 Mon 22:39:38] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-27<br />
[2023-05-01 Mon 22:39:38] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.0.6<br />
[2023-05-01 Mon 22:39:38] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:39:38] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.25<br />
[2023-05-01 Mon 22:39:38] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:39:38] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.10<br />
[2023-05-01 Mon 22:39:42] : Mailer Error: SMTP Error: The following recipients failed: mamun@infosec4all.co: Verification failed for <fatch.alert@ucb.com.info>
The mail server does not recognize fatch.alert@ucb.com.info as a valid sender.
Sender verify failed
tomamuns@gmail.com: Sender verify failed

[2023-05-01 Mon 22:39:42] : Connection closed
[2023-05-01 Mon 22:39:42] : ************************ END ***************************
[2023-05-01 Mon 22:40:20] : *********************** START Data Parsin Error Checker**************************
[2023-05-01 Mon 22:40:20] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2023-05-01'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2023-05-01 Mon 22:40:20] : Total Record Fetch: 12
[2023-05-01 Mon 22:40:20] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-26<br />
[2023-05-01 Mon 22:40:20] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.2.7<br />
[2023-05-01 Mon 22:40:20] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-29<br />
[2023-05-01 Mon 22:40:20] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.6<br />
[2023-05-01 Mon 22:40:20] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-09<br />
[2023-05-01 Mon 22:40:20] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.7<br />
[2023-05-01 Mon 22:40:20] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-27<br />
[2023-05-01 Mon 22:40:20] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.0.6<br />
[2023-05-01 Mon 22:40:20] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:40:20] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.25<br />
[2023-05-01 Mon 22:40:20] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:40:20] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.10<br />
[2023-05-01 Mon 22:40:26] : Mail sent on 2023-05-01 22:40:20
[2023-05-01 Mon 22:40:26] : Connection closed
[2023-05-01 Mon 22:40:26] : ************************ END ***************************
[2023-05-01 Mon 22:42:38] : *********************** START Data Parsin Error Checker**************************
[2023-05-01 Mon 22:42:38] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2023-05-01'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2023-05-01 Mon 22:42:38] : Total Record Fetch: 12
[2023-05-01 Mon 22:42:38] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-26<br />
[2023-05-01 Mon 22:42:38] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.2.7<br />
[2023-05-01 Mon 22:42:38] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-29<br />
[2023-05-01 Mon 22:42:38] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.6<br />
[2023-05-01 Mon 22:42:38] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-09<br />
[2023-05-01 Mon 22:42:38] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.7<br />
[2023-05-01 Mon 22:42:38] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-27<br />
[2023-05-01 Mon 22:42:38] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.0.6<br />
[2023-05-01 Mon 22:42:38] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:42:38] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.25<br />
[2023-05-01 Mon 22:42:38] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:42:38] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.10<br />
[2023-05-01 Mon 22:42:44] : Mail sent on 2023-05-01 22:42:38
[2023-05-01 Mon 22:42:44] : Connection closed
[2023-05-01 Mon 22:42:44] : ************************ END ***************************
[2023-05-01 Mon 22:43:08] : *********************** START Data Parsin Error Checker**************************
[2023-05-01 Mon 22:43:08] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2023-05-01'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2023-05-01 Mon 22:43:08] : Total Record Fetch: 12
[2023-05-01 Mon 22:43:08] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-26<br />
[2023-05-01 Mon 22:43:08] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.2.7<br />
[2023-05-01 Mon 22:43:08] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-29<br />
[2023-05-01 Mon 22:43:08] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.6<br />
[2023-05-01 Mon 22:43:08] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-09<br />
[2023-05-01 Mon 22:43:08] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.7<br />
[2023-05-01 Mon 22:43:08] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-27<br />
[2023-05-01 Mon 22:43:08] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.0.6<br />
[2023-05-01 Mon 22:43:08] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:43:08] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.25<br />
[2023-05-01 Mon 22:43:08] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:43:08] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.10<br />
[2023-05-01 Mon 22:43:20] : Mail sent on 2023-05-01 22:43:08
[2023-05-01 Mon 22:43:20] : Connection closed
[2023-05-01 Mon 22:43:20] : ************************ END ***************************
[2023-05-01 Mon 22:48:52] : *********************** START Data Parsin Error Checker**************************
[2023-05-01 Mon 22:48:52] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2023-05-01'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2023-05-01 Mon 22:48:52] : Total Record Fetch: 12
[2023-05-01 Mon 22:48:52] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-26<br />
[2023-05-01 Mon 22:48:52] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.2.7<br />
[2023-05-01 Mon 22:48:52] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-29<br />
[2023-05-01 Mon 22:48:52] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.6<br />
[2023-05-01 Mon 22:48:52] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-09<br />
[2023-05-01 Mon 22:48:52] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.7<br />
[2023-05-01 Mon 22:48:52] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-27<br />
[2023-05-01 Mon 22:48:52] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.0.6<br />
[2023-05-01 Mon 22:48:52] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:48:52] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.25<br />
[2023-05-01 Mon 22:48:52] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:48:52] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.10<br />
[2023-05-01 Mon 22:49:00] : Mail sent on 2023-05-01 22:48:52
[2023-05-01 Mon 22:49:00] : Connection closed
[2023-05-01 Mon 22:49:00] : ************************ END ***************************
[2023-05-01 Mon 22:49:19] : *********************** START Data Parsin Error Checker**************************
[2023-05-01 Mon 22:49:19] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2023-05-01'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2023-05-01 Mon 22:49:19] : Total Record Fetch: 12
[2023-05-01 Mon 22:49:19] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-26<br />
[2023-05-01 Mon 22:49:19] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.2.7<br />
[2023-05-01 Mon 22:49:19] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-29<br />
[2023-05-01 Mon 22:49:19] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.6<br />
[2023-05-01 Mon 22:49:19] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-09<br />
[2023-05-01 Mon 22:49:19] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.7<br />
[2023-05-01 Mon 22:49:19] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-27<br />
[2023-05-01 Mon 22:49:19] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.0.6<br />
[2023-05-01 Mon 22:49:19] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:49:19] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.25<br />
[2023-05-01 Mon 22:49:19] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:49:19] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.10<br />
[2023-05-01 Mon 22:49:24] : Mail sent on 2023-05-01 22:49:19
[2023-05-01 Mon 22:49:24] : Connection closed
[2023-05-01 Mon 22:49:24] : ************************ END ***************************
[2023-05-01 Mon 22:51:09] : *********************** START Data Parsin Error Checker**************************
[2023-05-01 Mon 22:51:09] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2023-05-01'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2023-05-01 Mon 22:51:09] : Total Record Fetch: 12
[2023-05-01 Mon 22:51:09] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-26<br />
[2023-05-01 Mon 22:51:09] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.2.7<br />
[2023-05-01 Mon 22:51:09] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-29<br />
[2023-05-01 Mon 22:51:09] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.6<br />
[2023-05-01 Mon 22:51:09] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-09<br />
[2023-05-01 Mon 22:51:09] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.7<br />
[2023-05-01 Mon 22:51:09] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-27<br />
[2023-05-01 Mon 22:51:09] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.0.6<br />
[2023-05-01 Mon 22:51:09] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:51:09] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.25<br />
[2023-05-01 Mon 22:51:09] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:51:09] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.10<br />
[2023-05-01 Mon 22:51:20] : Mail sent on 2023-05-01 22:51:09
[2023-05-01 Mon 22:51:20] : Connection closed
[2023-05-01 Mon 22:51:20] : ************************ END ***************************
[2023-05-01 Mon 22:52:38] : *********************** START Data Parsin Error Checker**************************
[2023-05-01 Mon 22:52:38] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2023-05-01'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2023-05-01 Mon 22:52:38] : Total Record Fetch: 12
[2023-05-01 Mon 22:52:38] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-26<br />
[2023-05-01 Mon 22:52:38] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.2.7<br />
[2023-05-01 Mon 22:52:38] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-29<br />
[2023-05-01 Mon 22:52:38] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.6<br />
[2023-05-01 Mon 22:52:38] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-09<br />
[2023-05-01 Mon 22:52:38] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.7<br />
[2023-05-01 Mon 22:52:38] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-27<br />
[2023-05-01 Mon 22:52:38] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.0.6<br />
[2023-05-01 Mon 22:52:38] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:52:38] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.25<br />
[2023-05-01 Mon 22:52:38] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:52:38] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.10<br />
[2023-05-01 Mon 22:52:43] : Mail sent on 2023-05-01 22:52:38
[2023-05-01 Mon 22:52:43] : Connection closed
[2023-05-01 Mon 22:52:43] : ************************ END ***************************
[2023-05-01 Mon 22:54:11] : *********************** START Data Parsin Error Checker**************************
[2023-05-01 Mon 22:54:11] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2023-05-01'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2023-05-01 Mon 22:54:11] : Total Record Fetch: 12
[2023-05-01 Mon 22:54:11] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-26<br />
[2023-05-01 Mon 22:54:11] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.2.7<br />
[2023-05-01 Mon 22:54:11] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-29<br />
[2023-05-01 Mon 22:54:11] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.6<br />
[2023-05-01 Mon 22:54:11] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-09<br />
[2023-05-01 Mon 22:54:11] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.7<br />
[2023-05-01 Mon 22:54:11] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-27<br />
[2023-05-01 Mon 22:54:11] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.0.6<br />
[2023-05-01 Mon 22:54:11] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:54:11] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.25<br />
[2023-05-01 Mon 22:54:11] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:54:11] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.10<br />
[2023-05-01 Mon 22:54:15] : Mailer Error: SMTP Error: The following recipients failed: mamun@infosec4all.co: Verification failed for <fatch.alert@ucb.info.bd>
The mail server does not recognize fatch.alert@ucb.info.bd as a valid sender.
Sender verify failed
tomamuns@gmail.com: Sender verify failed

[2023-05-01 Mon 22:54:15] : Connection closed
[2023-05-01 Mon 22:54:15] : ************************ END ***************************
[2023-05-01 Mon 22:54:33] : *********************** START Data Parsin Error Checker**************************
[2023-05-01 Mon 22:54:33] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2023-05-01'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2023-05-01 Mon 22:54:33] : Total Record Fetch: 12
[2023-05-01 Mon 22:54:33] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-26<br />
[2023-05-01 Mon 22:54:33] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.2.7<br />
[2023-05-01 Mon 22:54:33] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-29<br />
[2023-05-01 Mon 22:54:33] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.6<br />
[2023-05-01 Mon 22:54:33] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-09<br />
[2023-05-01 Mon 22:54:33] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.7<br />
[2023-05-01 Mon 22:54:33] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-27<br />
[2023-05-01 Mon 22:54:33] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.0.6<br />
[2023-05-01 Mon 22:54:33] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:54:33] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.25<br />
[2023-05-01 Mon 22:54:33] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:54:33] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.10<br />
[2023-05-01 Mon 22:54:37] : Mailer Error: SMTP Error: The following recipients failed: mamun@infosec4all.co: Verification failed for <fatch.alert@ucb.info>
The mail server does not recognize fatch.alert@ucb.info as a valid sender.
Sender verify failed
tomamuns@gmail.com: Sender verify failed

[2023-05-01 Mon 22:54:37] : Connection closed
[2023-05-01 Mon 22:54:37] : ************************ END ***************************
[2023-05-01 Mon 22:55:15] : *********************** START Data Parsin Error Checker**************************
[2023-05-01 Mon 22:55:15] : SELECT ai.id, ai.app_name, ai.app_store, ai.app_org, sc.status_code, sc.status_code_desc, ais.status_value, ais.batch_id, 
ais.executed_at_bd_time AS timestamp_bd, ais.executed_at_server_time AS timestamp_server 
FROM app_info ai LEFT OUTER JOIN app_info_status ais ON ai.id=ais.`app_info_id` 
LEFT OUTER JOIN status_code sc ON ais.`status_code_id`=sc.`id` 
WHERE ais.`status`='Active' AND ais.`executed_date` = '2023-05-01'
ORDER BY ai.`app_store`, ai.`app_name`, sc.`status_code`, ais.`executed_at_bd_time` DESC
[2023-05-01 Mon 22:55:15] : Total Record Fetch: 12
[2023-05-01 Mon 22:55:15] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-26<br />
[2023-05-01 Mon 22:55:15] : 2023-05-01 22:29:05 -->UCB Unet -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->2.2.7<br />
[2023-05-01 Mon 22:55:15] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-29<br />
[2023-05-01 Mon 22:55:15] : 2023-05-01 22:29:05 -->UClick -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.6<br />
[2023-05-01 Mon 22:55:15] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-01-09<br />
[2023-05-01 Mon 22:55:15] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Apple I Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.7<br />
[2023-05-01 Mon 22:55:15] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2022-09-27<br />
[2023-05-01 Mon 22:55:15] : 2023-05-01 22:29:05 -->UClick -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.0.6<br />
[2023-05-01 Mon 22:55:15] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:55:15] : 2023-05-01 22:29:05 -->Unet -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->3.25<br />
[2023-05-01 Mon 22:55:15] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_LAST_UPDATE -->App Last Update Date -->2023-03-18<br />
[2023-05-01 Mon 22:55:15] : 2023-05-01 22:29:05 -->Unet Enterprise Banking -->Google Play Store -->United Commercial Bank PLC -->APP_VERSION -->App Version -->1.0.10<br />
[2023-05-01 Mon 22:55:19] : Mail sent on 2023-05-01 22:55:15
[2023-05-01 Mon 22:55:19] : Connection closed
[2023-05-01 Mon 22:55:19] : ************************ END ***************************