[2025-10-30 08:58:49] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":1000} []
[2025-10-30 08:58:49] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2025-10-30 08:58:49] vat-sync.INFO: Connecting to source database... [] []
[2025-10-30 08:58:49] vat-sync.INFO: Source database connected successfully [] []
[2025-10-30 08:58:49] vat-sync.INFO: Connecting to target database... [] []
[2025-10-30 08:58:50] vat-sync.INFO: Target database connected successfully [] []
[2025-10-30 08:58:50] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2025-10-30 08:58:50] vat-sync.INFO: DataSyncService initialized successfully [] []
[2025-10-30 08:58:50] vat-sync.INFO: Starting sync cycle 1/1000 [] []
[2025-10-30 08:58:50] vat-sync.INFO: Starting data sync process [] []
[2025-10-30 08:58:50] vat-sync.INFO: Fetched record data {"vb_ID":"30e97994-b35e-4eb8-92a8-2c60678ea892","VATTaxNumberID":"NULL","NameEng":"shenzhenroujieshangmaoyouxiangongsi","BusinessCode":"tuk01"} []
[2025-10-30 08:58:50] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892, VATTaxNumberID: , starting processing... [] []
[2025-10-30 08:58:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Processing attachment files: 59fc5737-ca9f-4091-a4cb-09930c08ad3d [] []
[2025-10-30 08:58:50] vat-sync.INFO: Found attachment files for ID 59fc5737-ca9f-4091-a4cb-09930c08ad3d {"paths":{"path1":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/9d926e8f-b24b-4a6f-b138-a12bc0a03131.pdf","path2":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/c9f6660e-ce6e-46a8-887c-af03fa75d184.pdf","path3":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/cf3f252d-c80e-4836-b674-005e5bc656b2.pdf"},"types":{"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"}} []
[2025-10-30 08:58:50] vat-sync.INFO: Country cache loaded from file {"byCode":48,"byName":48,"byEnglish":48,"dialCodes":48,"file":"E:\\ou\\meiou-app\\uk_vat_reg\\src\\Services/../../country_cache_test.json"} []
[2025-10-30 08:58:50] vat-sync.INFO: Removed existing country code 86 from phone number [] []
[2025-10-30 08:58:50] vat-sync.INFO: Formatted China phone number: +86-18795859105 -> 8618795859105 (digits only for target DB) [] []
[2025-10-30 08:58:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Starting data validation... [] []
[2025-10-30 08:58:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Data validation passed [] []
[2025-10-30 08:58:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Creating registration email... [] []
[2025-10-30 08:58:50] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat23@usaeu.com","post_data":{"email":"registrationvat23@usaeu.com","password":"meiou@2025","active":1}} []
[2025-10-30 08:58:50] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat23@usaeu.com","active":1,"uname":"registrationvat23","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat23.20251030"}}} []
[2025-10-30 08:58:50] vat-sync.INFO: Email created successfully {"email":"registrationvat23@usaeu.com","sequence":23} []
[2025-10-30 08:58:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Email created successfully {"email":"registrationvat23@usaeu.com","sequence":23} []
[2025-10-30 08:58:50] vat-sync.INFO: Found existing record in target database {"source_record_id":"30e97994-b35e-4eb8-92a8-2c60678ea892","target_id":4,"current_registration_status":"1"} []
[2025-10-30 08:58:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - File types being saved {"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"} []
[2025-10-30 08:58:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating existing record in target database (target ID: 4, current status: 1)... [] []
[2025-10-30 08:58:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - BusinessCode value for UPDATE: tuk01 [] []
[2025-10-30 08:58:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - UPDATE parameters {"business_code":"tuk01","reg_number":"12346","company_name":"shenzhenroujieshangmaoyouxiangongsi"} []
[2025-10-30 08:58:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Target database insertion successful [] []
[2025-10-30 08:58:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating source email information... [] []
[2025-10-30 08:58:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Source email info updated successfully {"email":"registrationvat23@usaeu.com"} []
[2025-10-30 08:58:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating status to 2 [] []
[2025-10-30 08:58:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Status update successful [] []
[2025-10-30 08:58:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - All steps completed successfully, status set to 2 (processing) [] []
[2025-10-30 08:58:50] vat-sync.INFO: Sync cycle 1 completed successfully - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 [] []
[2025-10-30 08:58:50] vat-sync.INFO: Waiting 5 seconds before next sync [] []
[2025-10-30 11:09:24] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":1000} []
[2025-10-30 11:09:24] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2025-10-30 11:09:24] vat-sync.INFO: Connecting to source database... [] []
[2025-10-30 11:09:24] vat-sync.INFO: Source database connected successfully [] []
[2025-10-30 11:09:24] vat-sync.INFO: Connecting to target database... [] []
[2025-10-30 11:09:24] vat-sync.INFO: Target database connected successfully [] []
[2025-10-30 11:09:24] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2025-10-30 11:09:24] vat-sync.INFO: DataSyncService initialized successfully [] []
[2025-10-30 11:09:24] vat-sync.INFO: Starting sync cycle 1/1000 [] []
[2025-10-30 11:09:24] vat-sync.INFO: Starting data sync process [] []
[2025-10-30 11:09:24] vat-sync.INFO: Fetched record data {"vb_ID":"30e97994-b35e-4eb8-92a8-2c60678ea892","VATTaxNumberID":"NULL","NameEng":"shenzhenroujieshangmaoyouxiangongsi","BusinessCode":"tuk01"} []
[2025-10-30 11:09:24] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892, VATTaxNumberID: , starting processing... [] []
[2025-10-30 11:09:24] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Processing attachment files: 59fc5737-ca9f-4091-a4cb-09930c08ad3d [] []
[2025-10-30 11:09:24] vat-sync.INFO: Found attachment files for ID 59fc5737-ca9f-4091-a4cb-09930c08ad3d {"paths":{"path1":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/9d926e8f-b24b-4a6f-b138-a12bc0a03131.pdf","path2":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/c9f6660e-ce6e-46a8-887c-af03fa75d184.pdf","path3":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/cf3f252d-c80e-4836-b674-005e5bc656b2.pdf"},"types":{"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"}} []
[2025-10-30 11:09:24] vat-sync.INFO: Country cache loaded from file {"byCode":48,"byName":48,"byEnglish":48,"dialCodes":48,"file":"E:\\ou\\meiou-app\\uk_vat_reg\\src\\Services/../../country_cache_test.json"} []
[2025-10-30 11:09:24] vat-sync.INFO: Removed existing country code 86 from phone number [] []
[2025-10-30 11:09:24] vat-sync.INFO: Formatted China phone number: +86-18795859105 -> 8618795859105 (digits only for target DB) [] []
[2025-10-30 11:09:24] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Starting data validation... [] []
[2025-10-30 11:09:24] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Data validation passed [] []
[2025-10-30 11:09:24] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Creating registration email... [] []
[2025-10-30 11:09:24] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat24@usaeu.com","post_data":{"email":"registrationvat24@usaeu.com","password":"meiou@2025","active":1}} []
[2025-10-30 11:09:25] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat24@usaeu.com","active":1,"uname":"registrationvat24","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat24.20251030"}}} []
[2025-10-30 11:09:25] vat-sync.INFO: Email created successfully {"email":"registrationvat24@usaeu.com","sequence":24} []
[2025-10-30 11:09:25] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Email created successfully {"email":"registrationvat24@usaeu.com","sequence":24} []
[2025-10-30 11:09:25] vat-sync.INFO: Found existing record in target database {"source_record_id":"30e97994-b35e-4eb8-92a8-2c60678ea892","target_id":4,"current_registration_status":"1"} []
[2025-10-30 11:09:25] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - File types being saved {"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"} []
[2025-10-30 11:09:25] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating existing record in target database (target ID: 4, current status: 1)... [] []
[2025-10-30 11:09:25] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - BusinessCode value for UPDATE: tuk01 [] []
[2025-10-30 11:09:25] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - UPDATE parameters {"business_code":"tuk01","reg_number":"12346","company_name":"shenzhenroujieshangmaoyouxiangongsi"} []
[2025-10-30 11:09:25] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Target database insertion successful [] []
[2025-10-30 11:09:25] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating source email information... [] []
[2025-10-30 11:09:25] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Source email info updated successfully {"email":"registrationvat24@usaeu.com"} []
[2025-10-30 11:09:25] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating status to 2 [] []
[2025-10-30 11:09:25] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Status update successful [] []
[2025-10-30 11:09:25] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - All steps completed successfully, status set to 2 (processing) [] []
[2025-10-30 11:09:25] vat-sync.INFO: Sync cycle 1 completed successfully - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 [] []
[2025-10-30 11:09:25] vat-sync.INFO: Waiting 5 seconds before next sync [] []
[2025-10-30 11:21:38] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":1000} []
[2025-10-30 11:21:38] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2025-10-30 11:21:38] vat-sync.INFO: Connecting to source database... [] []
[2025-10-30 11:21:38] vat-sync.INFO: Source database connected successfully [] []
[2025-10-30 11:21:38] vat-sync.INFO: Connecting to target database... [] []
[2025-10-30 11:21:38] vat-sync.INFO: Target database connected successfully [] []
[2025-10-30 11:21:38] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2025-10-30 11:21:38] vat-sync.INFO: DataSyncService initialized successfully [] []
[2025-10-30 11:21:38] vat-sync.INFO: Starting sync cycle 1/1000 [] []
[2025-10-30 11:21:38] vat-sync.INFO: Starting data sync process [] []
[2025-10-30 11:21:38] vat-sync.INFO: Fetched record data {"vb_ID":"30e97994-b35e-4eb8-92a8-2c60678ea892","VATTaxNumberID":"NULL","NameEng":"shenzhenroujieshangmaoyouxiangongsi","BusinessCode":"tuk01"} []
[2025-10-30 11:21:38] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892, VATTaxNumberID: , starting processing... [] []
[2025-10-30 11:21:38] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Processing attachment files: 59fc5737-ca9f-4091-a4cb-09930c08ad3d [] []
[2025-10-30 11:21:39] vat-sync.INFO: Found attachment files for ID 59fc5737-ca9f-4091-a4cb-09930c08ad3d {"paths":{"path1":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/9d926e8f-b24b-4a6f-b138-a12bc0a03131.pdf","path2":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/c9f6660e-ce6e-46a8-887c-af03fa75d184.pdf","path3":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/cf3f252d-c80e-4836-b674-005e5bc656b2.pdf"},"types":{"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"}} []
[2025-10-30 11:21:39] vat-sync.INFO: Country cache loaded from file {"byCode":48,"byName":48,"byEnglish":48,"dialCodes":48,"file":"E:\\ou\\meiou-app\\uk_vat_reg\\src\\Services/../../country_cache_test.json"} []
[2025-10-30 11:21:39] vat-sync.INFO: Removed existing country code 86 from phone number [] []
[2025-10-30 11:21:39] vat-sync.INFO: Formatted China phone number: +86-18795859105 -> 8618795859105 (digits only for target DB) [] []
[2025-10-30 11:21:39] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Starting data validation... [] []
[2025-10-30 11:21:39] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Data validation passed [] []
[2025-10-30 11:21:39] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Creating registration email... [] []
[2025-10-30 11:21:39] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat25@usaeu.com","post_data":{"email":"registrationvat25@usaeu.com","password":"meiou@2025","active":1}} []
[2025-10-30 11:21:39] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat25@usaeu.com","active":1,"uname":"registrationvat25","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat25.20251030"}}} []
[2025-10-30 11:21:39] vat-sync.INFO: Email created successfully {"email":"registrationvat25@usaeu.com","sequence":25} []
[2025-10-30 11:21:39] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Email created successfully {"email":"registrationvat25@usaeu.com","sequence":25} []
[2025-10-30 11:21:39] vat-sync.INFO: Found existing record in target database {"source_record_id":"30e97994-b35e-4eb8-92a8-2c60678ea892","target_id":4,"current_registration_status":"1"} []
[2025-10-30 11:21:39] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - File types being saved {"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"} []
[2025-10-30 11:21:39] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating existing record in target database (target ID: 4, current status: 1)... [] []
[2025-10-30 11:21:39] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - BusinessCode value for UPDATE: tuk01 [] []
[2025-10-30 11:21:39] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - UPDATE parameters {"business_code":"tuk01","reg_number":"12346","company_name":"shenzhenroujieshangmaoyouxiangongsi"} []
[2025-10-30 11:21:39] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Target database insertion successful [] []
[2025-10-30 11:21:39] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating source email information... [] []
[2025-10-30 11:21:39] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Source email info updated successfully {"email":"registrationvat25@usaeu.com"} []
[2025-10-30 11:21:39] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating status to 2 [] []
[2025-10-30 11:21:39] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Status update successful [] []
[2025-10-30 11:21:39] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - All steps completed successfully, status set to 2 (processing) [] []
[2025-10-30 11:21:39] vat-sync.INFO: Sync cycle 1 completed successfully - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 [] []
[2025-10-30 11:21:39] vat-sync.INFO: Waiting 5 seconds before next sync [] []
[2025-10-30 12:18:45] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":1000} []
[2025-10-30 12:18:45] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2025-10-30 12:18:45] vat-sync.INFO: Connecting to source database... [] []
[2025-10-30 12:18:45] vat-sync.INFO: Source database connected successfully [] []
[2025-10-30 12:18:45] vat-sync.INFO: Connecting to target database... [] []
[2025-10-30 12:18:45] vat-sync.INFO: Target database connected successfully [] []
[2025-10-30 12:18:45] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2025-10-30 12:18:45] vat-sync.INFO: DataSyncService initialized successfully [] []
[2025-10-30 12:18:45] vat-sync.INFO: Starting sync cycle 1/1000 [] []
[2025-10-30 12:18:45] vat-sync.INFO: Starting data sync process [] []
[2025-10-30 12:18:46] vat-sync.INFO: Fetched record data {"vb_ID":"30e97994-b35e-4eb8-92a8-2c60678ea892","VATTaxNumberID":"NULL","NameEng":"shenzhenroujieshangmaoyouxiangongsi","BusinessCode":"tuk01"} []
[2025-10-30 12:18:46] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892, VATTaxNumberID: , starting processing... [] []
[2025-10-30 12:18:46] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Processing attachment files: 59fc5737-ca9f-4091-a4cb-09930c08ad3d [] []
[2025-10-30 12:18:46] vat-sync.INFO: Found attachment files for ID 59fc5737-ca9f-4091-a4cb-09930c08ad3d {"paths":{"path1":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/9d926e8f-b24b-4a6f-b138-a12bc0a03131.pdf","path2":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/c9f6660e-ce6e-46a8-887c-af03fa75d184.pdf","path3":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/cf3f252d-c80e-4836-b674-005e5bc656b2.pdf"},"types":{"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"}} []
[2025-10-30 12:18:46] vat-sync.INFO: Country cache loaded from file {"byCode":48,"byName":48,"byEnglish":48,"dialCodes":48,"file":"E:\\ou\\meiou-app\\uk_vat_reg\\src\\Services/../../country_cache_test.json"} []
[2025-10-30 12:18:46] vat-sync.INFO: Removed existing country code 86 from phone number [] []
[2025-10-30 12:18:46] vat-sync.INFO: Formatted China phone number: +86-18795859105 -> 8618795859105 (digits only for target DB) [] []
[2025-10-30 12:18:46] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Starting data validation... [] []
[2025-10-30 12:18:46] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Data validation passed [] []
[2025-10-30 12:18:46] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Creating registration email... [] []
[2025-10-30 12:18:46] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat26@usaeu.com","post_data":{"email":"registrationvat26@usaeu.com","password":"meiou@2025","active":1}} []
[2025-10-30 12:18:46] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat26@usaeu.com","active":1,"uname":"registrationvat26","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat26.20251030"}}} []
[2025-10-30 12:18:46] vat-sync.INFO: Email created successfully {"email":"registrationvat26@usaeu.com","sequence":26} []
[2025-10-30 12:18:46] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Email created successfully {"email":"registrationvat26@usaeu.com","sequence":26} []
[2025-10-30 12:18:46] vat-sync.INFO: Found existing record in target database {"source_record_id":"30e97994-b35e-4eb8-92a8-2c60678ea892","target_id":4,"current_registration_status":"1"} []
[2025-10-30 12:18:46] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - File types being saved {"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"} []
[2025-10-30 12:18:46] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating existing record in target database (target ID: 4, current status: 1)... [] []
[2025-10-30 12:18:46] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - BusinessCode value for UPDATE: tuk01 [] []
[2025-10-30 12:18:46] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - UPDATE parameters {"business_code":"tuk01","reg_number":"12346","company_name":"shenzhenroujieshangmaoyouxiangongsi"} []
[2025-10-30 12:18:46] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Target database insertion successful [] []
[2025-10-30 12:18:46] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating source email information... [] []
[2025-10-30 12:18:46] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Source email info updated successfully {"email":"registrationvat26@usaeu.com"} []
[2025-10-30 12:18:46] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating status to 2 [] []
[2025-10-30 12:18:46] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Status update successful [] []
[2025-10-30 12:18:46] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - All steps completed successfully, status set to 2 (processing) [] []
[2025-10-30 12:18:46] vat-sync.INFO: Sync cycle 1 completed successfully - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 [] []
[2025-10-30 12:18:46] vat-sync.INFO: Waiting 5 seconds before next sync [] []
[2025-10-30 14:02:11] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":1000} []
[2025-10-30 14:02:11] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2025-10-30 14:02:11] vat-sync.INFO: Connecting to source database... [] []
[2025-10-30 14:02:11] vat-sync.INFO: Source database connected successfully [] []
[2025-10-30 14:02:11] vat-sync.INFO: Connecting to target database... [] []
[2025-10-30 14:02:11] vat-sync.INFO: Target database connected successfully [] []
[2025-10-30 14:02:11] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2025-10-30 14:02:11] vat-sync.INFO: DataSyncService initialized successfully [] []
[2025-10-30 14:02:11] vat-sync.INFO: Starting sync cycle 1/1000 [] []
[2025-10-30 14:02:11] vat-sync.INFO: Starting data sync process [] []
[2025-10-30 14:02:11] vat-sync.INFO: Fetched record data {"vb_ID":"30e97994-b35e-4eb8-92a8-2c60678ea892","VATTaxNumberID":"NULL","NameEng":"shenzhenroujieshangmaoyouxiangongsi","BusinessCode":"tuk01"} []
[2025-10-30 14:02:11] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892, VATTaxNumberID: , starting processing... [] []
[2025-10-30 14:02:11] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Processing attachment files: 59fc5737-ca9f-4091-a4cb-09930c08ad3d [] []
[2025-10-30 14:02:11] vat-sync.INFO: Found attachment files for ID 59fc5737-ca9f-4091-a4cb-09930c08ad3d {"paths":{"path1":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/9d926e8f-b24b-4a6f-b138-a12bc0a03131.pdf","path2":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/c9f6660e-ce6e-46a8-887c-af03fa75d184.pdf","path3":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/cf3f252d-c80e-4836-b674-005e5bc656b2.pdf"},"types":{"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"}} []
[2025-10-30 14:02:11] vat-sync.INFO: Country cache loaded from file {"byCode":48,"byName":48,"byEnglish":48,"dialCodes":48,"file":"E:\\ou\\meiou-app\\uk_vat_reg\\src\\Services/../../country_cache_test.json"} []
[2025-10-30 14:02:11] vat-sync.INFO: Removed existing country code 86 from phone number [] []
[2025-10-30 14:02:11] vat-sync.INFO: Formatted China phone number: +86-18795859105 -> 8618795859105 (digits only for target DB) [] []
[2025-10-30 14:02:11] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Starting data validation... [] []
[2025-10-30 14:02:11] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Data validation passed [] []
[2025-10-30 14:02:11] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Creating registration email... [] []
[2025-10-30 14:02:11] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat27@usaeu.com","post_data":{"email":"registrationvat27@usaeu.com","password":"meiou@2025","active":1}} []
[2025-10-30 14:02:11] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat27@usaeu.com","active":1,"uname":"registrationvat27","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat27.20251030"}}} []
[2025-10-30 14:02:11] vat-sync.INFO: Email created successfully {"email":"registrationvat27@usaeu.com","sequence":27} []
[2025-10-30 14:02:11] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Email created successfully {"email":"registrationvat27@usaeu.com","sequence":27} []
[2025-10-30 14:02:11] vat-sync.INFO: Found existing record in target database {"source_record_id":"30e97994-b35e-4eb8-92a8-2c60678ea892","target_id":4,"current_registration_status":"1"} []
[2025-10-30 14:02:11] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - File types being saved {"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"} []
[2025-10-30 14:02:11] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating existing record in target database (target ID: 4, current status: 1)... [] []
[2025-10-30 14:02:11] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - BusinessCode value for UPDATE: tuk01 [] []
[2025-10-30 14:02:11] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - UPDATE parameters {"business_code":"tuk01","reg_number":"12346","company_name":"shenzhenroujieshangmaoyouxiangongsi"} []
[2025-10-30 14:02:12] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Target database insertion successful [] []
[2025-10-30 14:02:12] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating source email information... [] []
[2025-10-30 14:02:12] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Source email info updated successfully {"email":"registrationvat27@usaeu.com"} []
[2025-10-30 14:02:12] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating status to 2 [] []
[2025-10-30 14:02:12] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Status update successful [] []
[2025-10-30 14:02:12] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - All steps completed successfully, status set to 2 (processing) [] []
[2025-10-30 14:02:12] vat-sync.INFO: Sync cycle 1 completed successfully - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 [] []
[2025-10-30 14:02:12] vat-sync.INFO: Waiting 5 seconds before next sync [] []
[2025-10-30 14:27:48] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":1000} []
[2025-10-30 14:27:48] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2025-10-30 14:27:48] vat-sync.INFO: Connecting to source database... [] []
[2025-10-30 14:27:48] vat-sync.INFO: Source database connected successfully [] []
[2025-10-30 14:27:48] vat-sync.INFO: Connecting to target database... [] []
[2025-10-30 14:27:48] vat-sync.INFO: Target database connected successfully [] []
[2025-10-30 14:27:48] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2025-10-30 14:27:48] vat-sync.INFO: DataSyncService initialized successfully [] []
[2025-10-30 14:27:48] vat-sync.INFO: Starting sync cycle 1/1000 [] []
[2025-10-30 14:27:48] vat-sync.INFO: Starting data sync process [] []
[2025-10-30 14:27:48] vat-sync.INFO: Fetched record data {"vb_ID":"30e97994-b35e-4eb8-92a8-2c60678ea892","VATTaxNumberID":"NULL","NameEng":"shenzhenroujieshangmaoyouxiangongsi","BusinessCode":"tuk01"} []
[2025-10-30 14:27:48] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892, VATTaxNumberID: , starting processing... [] []
[2025-10-30 14:27:48] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Processing attachment files: 59fc5737-ca9f-4091-a4cb-09930c08ad3d [] []
[2025-10-30 14:27:48] vat-sync.INFO: Found attachment files for ID 59fc5737-ca9f-4091-a4cb-09930c08ad3d {"paths":{"path1":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/9d926e8f-b24b-4a6f-b138-a12bc0a03131.pdf","path2":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/c9f6660e-ce6e-46a8-887c-af03fa75d184.pdf","path3":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/cf3f252d-c80e-4836-b674-005e5bc656b2.pdf"},"types":{"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"}} []
[2025-10-30 14:27:48] vat-sync.INFO: Country cache loaded from file {"byCode":48,"byName":48,"byEnglish":48,"dialCodes":48,"file":"E:\\ou\\meiou-app\\uk_vat_reg\\src\\Services/../../country_cache_test.json"} []
[2025-10-30 14:27:48] vat-sync.INFO: Removed existing country code 86 from phone number [] []
[2025-10-30 14:27:48] vat-sync.INFO: Formatted China phone number: +86-18795859105 -> 8618795859105 (digits only for target DB) [] []
[2025-10-30 14:27:48] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Starting data validation... [] []
[2025-10-30 14:27:48] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Data validation passed [] []
[2025-10-30 14:27:48] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Creating registration email... [] []
[2025-10-30 14:27:48] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat28@usaeu.com","post_data":{"email":"registrationvat28@usaeu.com","password":"meiou@2025","active":1}} []
[2025-10-30 14:27:49] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat28@usaeu.com","active":1,"uname":"registrationvat28","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat28.20251030"}}} []
[2025-10-30 14:27:49] vat-sync.INFO: Email created successfully {"email":"registrationvat28@usaeu.com","sequence":28} []
[2025-10-30 14:27:49] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Email created successfully {"email":"registrationvat28@usaeu.com","sequence":28} []
[2025-10-30 14:27:49] vat-sync.INFO: Found existing record in target database {"source_record_id":"30e97994-b35e-4eb8-92a8-2c60678ea892","target_id":4,"current_registration_status":"1"} []
[2025-10-30 14:27:49] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - File types being saved {"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"} []
[2025-10-30 14:27:49] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating existing record in target database (target ID: 4, current status: 1)... [] []
[2025-10-30 14:27:49] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - BusinessCode value for UPDATE: tuk01 [] []
[2025-10-30 14:27:49] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - UPDATE parameters {"business_code":"tuk01","reg_number":"12346","company_name":"shenzhenroujieshangmaoyouxiangongsi"} []
[2025-10-30 14:27:49] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Target database insertion successful [] []
[2025-10-30 14:27:49] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating source email information... [] []
[2025-10-30 14:27:49] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Source email info updated successfully {"email":"registrationvat28@usaeu.com"} []
[2025-10-30 14:27:49] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating status to 2 [] []
[2025-10-30 14:27:49] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Status update successful [] []
[2025-10-30 14:27:49] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - All steps completed successfully, status set to 2 (processing) [] []
[2025-10-30 14:27:49] vat-sync.INFO: Sync cycle 1 completed successfully - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 [] []
[2025-10-30 14:27:49] vat-sync.INFO: Waiting 5 seconds before next sync [] []
[2025-10-30 14:42:33] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":1000} []
[2025-10-30 14:42:33] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2025-10-30 14:42:33] vat-sync.INFO: Connecting to source database... [] []
[2025-10-30 14:42:33] vat-sync.INFO: Source database connected successfully [] []
[2025-10-30 14:42:33] vat-sync.INFO: Connecting to target database... [] []
[2025-10-30 14:42:33] vat-sync.INFO: Target database connected successfully [] []
[2025-10-30 14:42:34] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2025-10-30 14:42:34] vat-sync.INFO: DataSyncService initialized successfully [] []
[2025-10-30 14:42:34] vat-sync.INFO: Starting sync cycle 1/1000 [] []
[2025-10-30 14:42:34] vat-sync.INFO: Starting data sync process [] []
[2025-10-30 14:42:34] vat-sync.INFO: Fetched record data {"vb_ID":"30e97994-b35e-4eb8-92a8-2c60678ea892","VATTaxNumberID":"NULL","NameEng":"shenzhenroujieshangmaoyouxiangongsi","BusinessCode":"tuk01"} []
[2025-10-30 14:42:34] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892, VATTaxNumberID: , starting processing... [] []
[2025-10-30 14:42:34] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Processing attachment files: 59fc5737-ca9f-4091-a4cb-09930c08ad3d [] []
[2025-10-30 14:42:34] vat-sync.INFO: Found attachment files for ID 59fc5737-ca9f-4091-a4cb-09930c08ad3d {"paths":{"path1":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/9d926e8f-b24b-4a6f-b138-a12bc0a03131.pdf","path2":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/c9f6660e-ce6e-46a8-887c-af03fa75d184.pdf","path3":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/cf3f252d-c80e-4836-b674-005e5bc656b2.pdf"},"types":{"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"}} []
[2025-10-30 14:42:34] vat-sync.INFO: Country cache loaded from file {"byCode":48,"byName":48,"byEnglish":48,"dialCodes":48,"file":"E:\\ou\\meiou-app\\uk_vat_reg\\src\\Services/../../country_cache_test.json"} []
[2025-10-30 14:42:34] vat-sync.INFO: Removed existing country code 86 from phone number [] []
[2025-10-30 14:42:34] vat-sync.INFO: Formatted China phone number: +86-18795859105 -> 8618795859105 (digits only for target DB) [] []
[2025-10-30 14:42:34] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Starting data validation... [] []
[2025-10-30 14:42:34] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Data validation passed [] []
[2025-10-30 14:42:34] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Creating registration email... [] []
[2025-10-30 14:42:34] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat29@usaeu.com","post_data":{"email":"registrationvat29@usaeu.com","password":"meiou@2025","active":1}} []
[2025-10-30 14:42:34] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat29@usaeu.com","active":1,"uname":"registrationvat29","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat29.20251030"}}} []
[2025-10-30 14:42:34] vat-sync.INFO: Email created successfully {"email":"registrationvat29@usaeu.com","sequence":29} []
[2025-10-30 14:42:34] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Email created successfully {"email":"registrationvat29@usaeu.com","sequence":29} []
[2025-10-30 14:42:34] vat-sync.INFO: Found existing record in target database {"source_record_id":"30e97994-b35e-4eb8-92a8-2c60678ea892","target_id":4,"current_registration_status":"1"} []
[2025-10-30 14:42:34] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - File types being saved {"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"} []
[2025-10-30 14:42:34] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating existing record in target database (target ID: 4, current status: 1)... [] []
[2025-10-30 14:42:34] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - BusinessCode value for UPDATE: tuk01 [] []
[2025-10-30 14:42:34] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - UPDATE parameters {"business_code":"tuk01","reg_number":"12346","company_name":"shenzhenroujieshangmaoyouxiangongsi"} []
[2025-10-30 14:42:34] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Target database insertion successful [] []
[2025-10-30 14:42:34] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating source email information... [] []
[2025-10-30 14:42:34] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Source email info updated successfully {"email":"registrationvat29@usaeu.com"} []
[2025-10-30 14:42:34] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating status to 2 [] []
[2025-10-30 14:42:34] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Status update successful [] []
[2025-10-30 14:42:34] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - All steps completed successfully, status set to 2 (processing) [] []
[2025-10-30 14:42:34] vat-sync.INFO: Sync cycle 1 completed successfully - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 [] []
[2025-10-30 14:42:34] vat-sync.INFO: Waiting 5 seconds before next sync [] []
[2025-10-30 14:57:50] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":1000} []
[2025-10-30 14:57:50] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2025-10-30 14:57:50] vat-sync.INFO: Connecting to source database... [] []
[2025-10-30 14:57:50] vat-sync.INFO: Source database connected successfully [] []
[2025-10-30 14:57:50] vat-sync.INFO: Connecting to target database... [] []
[2025-10-30 14:57:50] vat-sync.INFO: Target database connected successfully [] []
[2025-10-30 14:57:50] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2025-10-30 14:57:50] vat-sync.INFO: DataSyncService initialized successfully [] []
[2025-10-30 14:57:50] vat-sync.INFO: Starting sync cycle 1/1000 [] []
[2025-10-30 14:57:50] vat-sync.INFO: Starting data sync process [] []
[2025-10-30 14:57:50] vat-sync.INFO: Fetched record data {"vb_ID":"30e97994-b35e-4eb8-92a8-2c60678ea892","VATTaxNumberID":"NULL","NameEng":"shenzhenroujieshangmaoyouxiangongsi","BusinessCode":"tuk01"} []
[2025-10-30 14:57:50] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892, VATTaxNumberID: , starting processing... [] []
[2025-10-30 14:57:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Processing attachment files: 59fc5737-ca9f-4091-a4cb-09930c08ad3d [] []
[2025-10-30 14:57:50] vat-sync.INFO: Found attachment files for ID 59fc5737-ca9f-4091-a4cb-09930c08ad3d {"paths":{"path1":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/9d926e8f-b24b-4a6f-b138-a12bc0a03131.pdf","path2":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/c9f6660e-ce6e-46a8-887c-af03fa75d184.pdf","path3":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/cf3f252d-c80e-4836-b674-005e5bc656b2.pdf"},"types":{"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"}} []
[2025-10-30 14:57:50] vat-sync.INFO: Country cache loaded from file {"byCode":48,"byName":48,"byEnglish":48,"dialCodes":48,"file":"E:\\ou\\meiou-app\\uk_vat_reg\\src\\Services/../../country_cache_test.json"} []
[2025-10-30 14:57:50] vat-sync.INFO: Removed existing country code 86 from phone number [] []
[2025-10-30 14:57:50] vat-sync.INFO: Formatted China phone number: +86-18795859105 -> 8618795859105 (digits only for target DB) [] []
[2025-10-30 14:57:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Starting data validation... [] []
[2025-10-30 14:57:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Data validation passed [] []
[2025-10-30 14:57:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Creating registration email... [] []
[2025-10-30 14:57:50] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat30@usaeu.com","post_data":{"email":"registrationvat30@usaeu.com","password":"meiou@2025","active":1}} []
[2025-10-30 14:57:50] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat30@usaeu.com","active":1,"uname":"registrationvat30","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat30.20251030"}}} []
[2025-10-30 14:57:50] vat-sync.INFO: Email created successfully {"email":"registrationvat30@usaeu.com","sequence":30} []
[2025-10-30 14:57:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Email created successfully {"email":"registrationvat30@usaeu.com","sequence":30} []
[2025-10-30 14:57:50] vat-sync.INFO: Found existing record in target database {"source_record_id":"30e97994-b35e-4eb8-92a8-2c60678ea892","target_id":4,"current_registration_status":"1"} []
[2025-10-30 14:57:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - File types being saved {"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"} []
[2025-10-30 14:57:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating existing record in target database (target ID: 4, current status: 1)... [] []
[2025-10-30 14:57:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - BusinessCode value for UPDATE: tuk01 [] []
[2025-10-30 14:57:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - UPDATE parameters {"business_code":"tuk01","reg_number":"12346","company_name":"shenzhenroujieshangmaoyouxiangongsi"} []
[2025-10-30 14:57:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Target database insertion successful [] []
[2025-10-30 14:57:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating source email information... [] []
[2025-10-30 14:57:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Source email info updated successfully {"email":"registrationvat30@usaeu.com"} []
[2025-10-30 14:57:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating status to 2 [] []
[2025-10-30 14:57:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Status update successful [] []
[2025-10-30 14:57:50] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - All steps completed successfully, status set to 2 (processing) [] []
[2025-10-30 14:57:50] vat-sync.INFO: Sync cycle 1 completed successfully - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 [] []
[2025-10-30 14:57:50] vat-sync.INFO: Waiting 5 seconds before next sync [] []
[2025-10-30 15:25:52] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":1000} []
[2025-10-30 15:25:52] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2025-10-30 15:25:52] vat-sync.INFO: Connecting to source database... [] []
[2025-10-30 15:25:52] vat-sync.INFO: Source database connected successfully [] []
[2025-10-30 15:25:52] vat-sync.INFO: Connecting to target database... [] []
[2025-10-30 15:25:52] vat-sync.INFO: Target database connected successfully [] []
[2025-10-30 15:25:52] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2025-10-30 15:25:52] vat-sync.INFO: DataSyncService initialized successfully [] []
[2025-10-30 15:25:52] vat-sync.INFO: Starting sync cycle 1/1000 [] []
[2025-10-30 15:25:52] vat-sync.INFO: Starting data sync process [] []
[2025-10-30 15:25:52] vat-sync.INFO: Fetched record data {"vb_ID":"30e97994-b35e-4eb8-92a8-2c60678ea892","VATTaxNumberID":"NULL","NameEng":"shenzhenroujieshangmaoyouxiangongsi","BusinessCode":"tuk01"} []
[2025-10-30 15:25:52] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892, VATTaxNumberID: , starting processing... [] []
[2025-10-30 15:25:52] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Processing attachment files: 59fc5737-ca9f-4091-a4cb-09930c08ad3d [] []
[2025-10-30 15:25:52] vat-sync.INFO: Found attachment files for ID 59fc5737-ca9f-4091-a4cb-09930c08ad3d {"paths":{"path1":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/9d926e8f-b24b-4a6f-b138-a12bc0a03131.pdf","path2":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/c9f6660e-ce6e-46a8-887c-af03fa75d184.pdf","path3":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/cf3f252d-c80e-4836-b674-005e5bc656b2.pdf"},"types":{"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"}} []
[2025-10-30 15:25:52] vat-sync.INFO: Country cache loaded from file {"byCode":48,"byName":48,"byEnglish":48,"dialCodes":48,"file":"E:\\ou\\meiou-app\\uk_vat_reg\\src\\Services/../../country_cache_test.json"} []
[2025-10-30 15:25:52] vat-sync.INFO: Removed existing country code 86 from phone number [] []
[2025-10-30 15:25:52] vat-sync.INFO: Formatted China phone number: +8618795859105 -> 8618795859105 (digits only for target DB) [] []
[2025-10-30 15:25:52] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Starting data validation... [] []
[2025-10-30 15:25:52] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Data validation passed [] []
[2025-10-30 15:25:52] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Creating registration email... [] []
[2025-10-30 15:25:52] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat31@usaeu.com","post_data":{"email":"registrationvat31@usaeu.com","password":"meiou@2025","active":1}} []
[2025-10-30 15:25:53] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat31@usaeu.com","active":1,"uname":"registrationvat31","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat31.20251030"}}} []
[2025-10-30 15:25:53] vat-sync.INFO: Email created successfully {"email":"registrationvat31@usaeu.com","sequence":31} []
[2025-10-30 15:25:53] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Email created successfully {"email":"registrationvat31@usaeu.com","sequence":31} []
[2025-10-30 15:25:53] vat-sync.INFO: Found existing record in target database {"source_record_id":"30e97994-b35e-4eb8-92a8-2c60678ea892","target_id":4,"current_registration_status":"3"} []
[2025-10-30 15:25:53] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - File types being saved {"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"} []
[2025-10-30 15:25:53] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating existing record in target database (target ID: 4, current status: 3)... [] []
[2025-10-30 15:25:53] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - BusinessCode value for UPDATE: tuk01 [] []
[2025-10-30 15:25:53] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - UPDATE parameters {"business_code":"tuk01","reg_number":"954135477ZXXQW4698","company_name":"shenzhenroujieshangmaoyouxiangongsi"} []
[2025-10-30 15:25:53] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Target database insertion successful [] []
[2025-10-30 15:25:53] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating source email information... [] []
[2025-10-30 15:25:53] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Source email info updated successfully {"email":"registrationvat31@usaeu.com"} []
[2025-10-30 15:25:53] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating status to 2 [] []
[2025-10-30 15:25:53] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Status update successful [] []
[2025-10-30 15:25:53] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - All steps completed successfully, status set to 2 (processing) [] []
[2025-10-30 15:25:53] vat-sync.INFO: Sync cycle 1 completed successfully - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 [] []
[2025-10-30 15:25:53] vat-sync.INFO: Waiting 5 seconds before next sync [] []
[2025-10-30 16:10:55] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":1000} []
[2025-10-30 16:10:55] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2025-10-30 16:10:55] vat-sync.INFO: Connecting to source database... [] []
[2025-10-30 16:10:55] vat-sync.INFO: Source database connected successfully [] []
[2025-10-30 16:10:55] vat-sync.INFO: Connecting to target database... [] []
[2025-10-30 16:10:55] vat-sync.INFO: Target database connected successfully [] []
[2025-10-30 16:10:55] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2025-10-30 16:10:55] vat-sync.INFO: DataSyncService initialized successfully [] []
[2025-10-30 16:10:55] vat-sync.INFO: Starting sync cycle 1/1000 [] []
[2025-10-30 16:10:55] vat-sync.INFO: Starting data sync process [] []
[2025-10-30 16:10:55] vat-sync.INFO: Fetched record data {"vb_ID":"30e97994-b35e-4eb8-92a8-2c60678ea892","VATTaxNumberID":"NULL","NameEng":"shenzhenroujieshangmaoyouxiangongsi","BusinessCode":"tuk01"} []
[2025-10-30 16:10:55] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892, VATTaxNumberID: , starting processing... [] []
[2025-10-30 16:10:55] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Processing attachment files: 59fc5737-ca9f-4091-a4cb-09930c08ad3d [] []
[2025-10-30 16:10:55] vat-sync.INFO: Found attachment files for ID 59fc5737-ca9f-4091-a4cb-09930c08ad3d {"paths":{"path1":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/9d926e8f-b24b-4a6f-b138-a12bc0a03131.pdf","path2":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/c9f6660e-ce6e-46a8-887c-af03fa75d184.pdf","path3":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251029/cf3f252d-c80e-4836-b674-005e5bc656b2.pdf"},"types":{"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"}} []
[2025-10-30 16:10:55] vat-sync.INFO: Country cache loaded from file {"byCode":48,"byName":48,"byEnglish":48,"dialCodes":48,"file":"E:\\ou\\meiou-app\\uk_vat_reg\\src\\Services/../../country_cache_test.json"} []
[2025-10-30 16:10:55] vat-sync.INFO: Removed existing country code 86 from phone number [] []
[2025-10-30 16:10:55] vat-sync.INFO: Formatted China phone number: +8618795859105 -> 8618795859105 (digits only for target DB) [] []
[2025-10-30 16:10:55] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Starting data validation... [] []
[2025-10-30 16:10:55] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Data validation passed [] []
[2025-10-30 16:10:55] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Creating registration email... [] []
[2025-10-30 16:10:55] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat32@usaeu.com","post_data":{"email":"registrationvat32@usaeu.com","password":"meiou@2025","active":1}} []
[2025-10-30 16:10:55] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat32@usaeu.com","active":1,"uname":"registrationvat32","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat32.20251030"}}} []
[2025-10-30 16:10:55] vat-sync.INFO: Email created successfully {"email":"registrationvat32@usaeu.com","sequence":32} []
[2025-10-30 16:10:55] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Email created successfully {"email":"registrationvat32@usaeu.com","sequence":32} []
[2025-10-30 16:10:55] vat-sync.INFO: Found existing record in target database {"source_record_id":"30e97994-b35e-4eb8-92a8-2c60678ea892","target_id":4,"current_registration_status":"3"} []
[2025-10-30 16:10:55] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - File types being saved {"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"} []
[2025-10-30 16:10:55] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating existing record in target database (target ID: 4, current status: 3)... [] []
[2025-10-30 16:10:55] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - BusinessCode value for UPDATE: tuk01 [] []
[2025-10-30 16:10:55] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - UPDATE parameters {"business_code":"tuk01","reg_number":"954135477ZXXQW4698","company_name":"shenzhenroujieshangmaoyouxiangongsi"} []
[2025-10-30 16:10:55] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Target database insertion successful [] []
[2025-10-30 16:10:55] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating source email information... [] []
[2025-10-30 16:10:55] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Source email info updated successfully {"email":"registrationvat32@usaeu.com"} []
[2025-10-30 16:10:55] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating status to 2 [] []
[2025-10-30 16:10:55] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Status update successful [] []
[2025-10-30 16:10:56] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - All steps completed successfully, status set to 2 (processing) [] []
[2025-10-30 16:10:56] vat-sync.INFO: Sync cycle 1 completed successfully - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 [] []
[2025-10-30 16:10:56] vat-sync.INFO: Waiting 5 seconds before next sync [] []
[2025-10-30 16:51:52] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":1000} []
[2025-10-30 16:51:52] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2025-10-30 16:51:52] vat-sync.INFO: Connecting to source database... [] []
[2025-10-30 16:51:52] vat-sync.INFO: Source database connected successfully [] []
[2025-10-30 16:51:52] vat-sync.INFO: Connecting to target database... [] []
[2025-10-30 16:51:52] vat-sync.INFO: Target database connected successfully [] []
[2025-10-30 16:51:52] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2025-10-30 16:51:52] vat-sync.INFO: DataSyncService initialized successfully [] []
[2025-10-30 16:51:52] vat-sync.INFO: Starting sync cycle 1/1000 [] []
[2025-10-30 16:51:52] vat-sync.INFO: Starting data sync process [] []
[2025-10-30 16:51:52] vat-sync.INFO: Fetched record data {"vb_ID":"e26c76f2-5501-4c31-90e9-ef5ae3080d64","VATTaxNumberID":"NULL","NameEng":"chengduyoushiguojimaoyiyuxiangongsi","BusinessCode":"tuk02"} []
[2025-10-30 16:51:52] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: e26c76f2-5501-4c31-90e9-ef5ae3080d64, VATTaxNumberID: , starting processing... [] []
[2025-10-30 16:51:52] vat-sync.INFO: VATBusinessRecord.ID: e26c76f2-5501-4c31-90e9-ef5ae3080d64 - Processing attachment files: 809a62a2-5ffe-49b4-a74d-236e03f0cf66 [] []
[2025-10-30 16:51:52] vat-sync.INFO: Found attachment files for ID 809a62a2-5ffe-49b4-a74d-236e03f0cf66 {"paths":{"path1":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251030/7afcfd8b-69d8-48fc-9363-63c2f53ca7b8.pdf","path2":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251030/2c1d8448-c189-4153-a656-b8547cd255f4.pdf","path3":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251030/cce1fd3d-432a-4b87-b0a8-1c47eabcba07.pdf"},"types":{"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"}} []
[2025-10-30 16:51:52] vat-sync.INFO: Country cache loaded from file {"byCode":48,"byName":48,"byEnglish":48,"dialCodes":48,"file":"E:\\ou\\meiou-app\\uk_vat_reg\\src\\Services/../../country_cache_test.json"} []
[2025-10-30 16:51:52] vat-sync.INFO: Removed existing country code 86 from phone number [] []
[2025-10-30 16:51:52] vat-sync.INFO: Formatted China phone number: +86-13541563551 -> 8613541563551 (digits only for target DB) [] []
[2025-10-30 16:51:52] vat-sync.INFO: VATBusinessRecord.ID: e26c76f2-5501-4c31-90e9-ef5ae3080d64 - Starting data validation... [] []
[2025-10-30 16:51:52] vat-sync.INFO: VATBusinessRecord.ID: e26c76f2-5501-4c31-90e9-ef5ae3080d64 - Data validation passed [] []
[2025-10-30 16:51:52] vat-sync.INFO: VATBusinessRecord.ID: e26c76f2-5501-4c31-90e9-ef5ae3080d64 - Creating registration email... [] []
[2025-10-30 16:51:52] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat33@usaeu.com","post_data":{"email":"registrationvat33@usaeu.com","password":"meiou@2025","active":1}} []
[2025-10-30 16:51:52] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat33@usaeu.com","active":1,"uname":"registrationvat33","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat33.20251030"}}} []
[2025-10-30 16:51:52] vat-sync.INFO: Email created successfully {"email":"registrationvat33@usaeu.com","sequence":33} []
[2025-10-30 16:51:52] vat-sync.INFO: VATBusinessRecord.ID: e26c76f2-5501-4c31-90e9-ef5ae3080d64 - Email created successfully {"email":"registrationvat33@usaeu.com","sequence":33} []
[2025-10-30 16:51:52] vat-sync.INFO: VATBusinessRecord.ID: e26c76f2-5501-4c31-90e9-ef5ae3080d64 - File types being saved {"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"} []
[2025-10-30 16:51:52] vat-sync.INFO: VATBusinessRecord.ID: e26c76f2-5501-4c31-90e9-ef5ae3080d64 - Inserting new record into target database... [] []
[2025-10-30 16:51:52] vat-sync.INFO: VATBusinessRecord.ID: e26c76f2-5501-4c31-90e9-ef5ae3080d64 - BusinessCode value for INSERT: tuk02 [] []
[2025-10-30 16:51:52] vat-sync.INFO: VATBusinessRecord.ID: e26c76f2-5501-4c31-90e9-ef5ae3080d64 - INSERT parameters {"business_code":"tuk02","reg_number":"95413547AAXXQW4698","company_name":"chengduyoushiguojimaoyiyuxiangongsi"} []
[2025-10-30 16:51:52] vat-sync.INFO: VATBusinessRecord.ID: e26c76f2-5501-4c31-90e9-ef5ae3080d64 - Target database insertion successful [] []
[2025-10-30 16:51:52] vat-sync.INFO: VATBusinessRecord.ID: e26c76f2-5501-4c31-90e9-ef5ae3080d64 - Updating source email information... [] []
[2025-10-30 16:51:52] vat-sync.INFO: VATBusinessRecord.ID: e26c76f2-5501-4c31-90e9-ef5ae3080d64 - Source email info updated successfully {"email":"registrationvat33@usaeu.com"} []
[2025-10-30 16:51:52] vat-sync.INFO: VATBusinessRecord.ID: e26c76f2-5501-4c31-90e9-ef5ae3080d64 - Updating status to 2 [] []
[2025-10-30 16:51:52] vat-sync.INFO: VATBusinessRecord.ID: e26c76f2-5501-4c31-90e9-ef5ae3080d64 - Status update successful [] []
[2025-10-30 16:51:52] vat-sync.INFO: VATBusinessRecord.ID: e26c76f2-5501-4c31-90e9-ef5ae3080d64 - All steps completed successfully, status set to 2 (processing) [] []
[2025-10-30 16:51:52] vat-sync.INFO: Sync cycle 1 completed successfully - VATBusinessRecord.ID: e26c76f2-5501-4c31-90e9-ef5ae3080d64 [] []
[2025-10-30 16:51:52] vat-sync.INFO: Waiting 5 seconds before next sync [] []
[2025-10-30 17:21:04] vat-sync.INFO: VAT Data Sync Service started {"environment":"prod","sync_interval":5,"max_cycles":1000} []
[2025-10-30 17:21:04] vat-sync.INFO: Initializing DataSyncService {"environment":"prod"} []
[2025-10-30 17:21:04] vat-sync.INFO: Connecting to source database... [] []
[2025-10-30 17:21:09] vat-sync.ERROR: Database connection failed during DataSyncService initialization {"environment":"prod","error":"Source database connection failed: SQLSTATE[08001]: [Microsoft][ODBC Driver 18 for SQL Server]因为在登录之前握手期间出现错误，所以客户端无法建立连接。最常见原因包括客户端试图连接到不受支持的 SQL Server 版本、服务器太忙无法接受新连接或服务器上的资源受到限制(内存或允许的最大连接数)。"} []
[2025-10-30 17:21:09] vat-sync.ERROR: Failed to initialize DataSyncService: Database connection failed: Source database connection failed: SQLSTATE[08001]: [Microsoft][ODBC Driver 18 for SQL Server]因为在登录之前握手期间出现错误，所以客户端无法建立连接。最常见原因包括客户端试图连接到不受支持的 SQL Server 版本、服务器太忙无法接受新连接或服务器上的资源受到限制(内存或允许的最大连接数)。 {"environment":"prod","exception":"[object] (RuntimeException(code: 0): Database connection failed: Source database connection failed: SQLSTATE[08001]: [Microsoft][ODBC Driver 18 for SQL Server]因为在登录之前握手期间出现错误，所以客户端无法建立连接。最常见原因包括客户端试图连接到不受支持的 SQL Server 版本、服务器太忙无法接受新连接或服务器上的资源受到限制(内存或允许的最大连接数)。 at E:\\ou\\meiou-app\\uk_vat_reg\\src\\Services\\DataSyncService.php:57)\n[previous exception] [object] (PDOException(code: 0): Source database connection failed: SQLSTATE[08001]: [Microsoft][ODBC Driver 18 for SQL Server]因为在登录之前握手期间出现错误，所以客户端无法建立连接。最常见原因包括客户端试图连接到不受支持的 SQL Server 版本、服务器太忙无法接受新连接或服务器上的资源受到限制(内存或允许的最大连接数)。 at E:\\ou\\meiou-app\\uk_vat_reg\\src\\Database\\Connection.php:39)"} []