[2025-11-05 10:04:52] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":100} []
[2025-11-05 10:04:52] vat-sync.INFO: Created sync lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock with PID: 16704 [] []
[2025-11-05 10:04:52] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2025-11-05 10:04:52] vat-sync.INFO: Connecting to source database... [] []
[2025-11-05 10:04:52] vat-sync.INFO: Source database connected successfully [] []
[2025-11-05 10:04:52] vat-sync.INFO: Connecting to target database... [] []
[2025-11-05 10:04:52] vat-sync.INFO: Target database connected successfully [] []
[2025-11-05 10:04:52] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2025-11-05 10:04:52] vat-sync.INFO: DataSyncService initialized successfully [] []
[2025-11-05 10:04:52] vat-sync.INFO: Starting sync cycle 1/100 [] []
[2025-11-05 10:04:52] vat-sync.INFO: Starting data sync process [] []
[2025-11-05 10:04:52] vat-sync.INFO: No pending records found [] []
[2025-11-05 10:04:52] vat-sync.INFO: Sync cycle 1 completed successfully - No pending records found [] []
[2025-11-05 10:04:52] vat-sync.INFO: Waiting 5 seconds before next sync [] []
[2025-11-05 10:04:57] vat-sync.INFO: Starting sync cycle 2/100 [] []
[2025-11-05 10:04:57] vat-sync.INFO: Starting data sync process [] []
[2025-11-05 10:04:57] vat-sync.INFO: No pending records found [] []
[2025-11-05 10:04:57] vat-sync.INFO: Sync cycle 2 completed successfully - No pending records found [] []
[2025-11-05 10:04:57] vat-sync.INFO: Waiting 5 seconds before next sync [] []
[2025-11-05 10:05:03] vat-sync.INFO: Starting sync cycle 3/100 [] []
[2025-11-05 10:05:03] vat-sync.INFO: Starting data sync process [] []
[2025-11-05 10:05:03] vat-sync.INFO: No pending records found [] []
[2025-11-05 10:05:03] vat-sync.INFO: Sync cycle 3 completed successfully - No pending records found [] []
[2025-11-05 10:05:03] vat-sync.INFO: Waiting 5 seconds before next sync [] []
[2025-11-05 10:07:34] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":100} []
[2025-11-05 10:07:34] vat-sync.INFO: Removed stale lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock [] []
[2025-11-05 10:07:34] vat-sync.INFO: Created sync lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock with PID: 27272 [] []
[2025-11-05 10:07:34] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2025-11-05 10:07:34] vat-sync.INFO: Connecting to source database... [] []
[2025-11-05 10:07:35] vat-sync.INFO: Source database connected successfully [] []
[2025-11-05 10:07:35] vat-sync.INFO: Connecting to target database... [] []
[2025-11-05 10:07:35] vat-sync.INFO: Target database connected successfully [] []
[2025-11-05 10:07:35] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2025-11-05 10:07:35] vat-sync.INFO: DataSyncService initialized successfully [] []
[2025-11-05 10:07:35] vat-sync.INFO: Starting sync cycle 1/100 [] []
[2025-11-05 10:07:35] vat-sync.INFO: Starting data sync process [] []
[2025-11-05 10:07:35] vat-sync.INFO: Fetched record data {"vb_ID":"450aab9d-f1b0-4a7f-9037-61ec01fd9e7e","VATTaxNumberID":"NULL","NameEng":"chengdushiruilaishangmaoyouxiangongsi","BusinessCode":"tuk03"} []
[2025-11-05 10:07:35] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e, VATTaxNumberID: , starting processing... [] []
[2025-11-05 10:07:35] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Processing attachment files: 5b8c16c3-e6cf-42b2-9fb8-3a15524dcb98 [] []
[2025-11-05 10:07:35] vat-sync.INFO: Found attachment files for ID 5b8c16c3-e6cf-42b2-9fb8-3a15524dcb98 {"paths":{"path1":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251104/dae22db5-a6f2-4876-91ab-c30d6e404353.pdf","path2":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251104/30a70ab8-141b-413f-8dff-cd49f96859d0.pdf","path3":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251104/488cfda1-7542-4855-8ab4-00767cb41ad4.pdf"},"types":{"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"}} []
[2025-11-05 10:07:35] 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-11-05 10:07:35] vat-sync.INFO: Removed existing country code 86 from phone number [] []
[2025-11-05 10:07:35] vat-sync.INFO: Formatted China phone number: +86-12365498541 -> 8612365498541 (digits only for target DB) [] []
[2025-11-05 10:07:35] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Starting data validation... [] []
[2025-11-05 10:07:35] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Data validation passed [] []
[2025-11-05 10:07:35] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Creating registration email... [] []
[2025-11-05 10:07:35] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat36@usaeu.com","post_data":{"email":"registrationvat36@usaeu.com","password":"meiou@2025","active":1}} []
[2025-11-05 10:07:35] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat36@usaeu.com","active":1,"uname":"registrationvat36","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat36.20251105"}}} []
[2025-11-05 10:07:35] vat-sync.INFO: Email created successfully {"email":"registrationvat36@usaeu.com","sequence":36} []
[2025-11-05 10:07:35] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Email created successfully {"email":"registrationvat36@usaeu.com","sequence":36} []
[2025-11-05 10:07:35] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - File types being saved {"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"} []
[2025-11-05 10:07:35] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Inserting new record into target database... [] []
[2025-11-05 10:07:35] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - BusinessCode value for INSERT: tuk03 [] []
[2025-11-05 10:07:35] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - UK company check {"original_country":"中国","english_country":"China","is_uk_company":"false","uk_postcode":null} []
[2025-11-05 10:07:35] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - INSERT parameters {"business_code":"tuk03","reg_number":"915203654120135AQ","company_name":"chengdushiruilaishangmaoyouxiangongsi"} []
[2025-11-05 10:07:35] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Target database insertion successful [] []
[2025-11-05 10:07:35] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Updating source email information... [] []
[2025-11-05 10:07:35] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Source email info updated successfully {"email":"registrationvat36@usaeu.com"} []
[2025-11-05 10:07:35] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Updating status to 2 [] []
[2025-11-05 10:07:35] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Status update successful [] []
[2025-11-05 10:07:35] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - All steps completed successfully, status set to 2 (processing) [] []
[2025-11-05 10:07:35] vat-sync.INFO: Sync cycle 1 completed successfully - VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e [] []
[2025-11-05 10:07:35] vat-sync.INFO: Waiting 5 seconds before next sync [] []
[2025-11-05 10:07:40] vat-sync.INFO: Starting sync cycle 2/100 [] []
[2025-11-05 10:07:40] vat-sync.INFO: Starting data sync process [] []
[2025-11-05 10:07:40] vat-sync.INFO: Fetched record data {"vb_ID":"450aab9d-f1b0-4a7f-9037-61ec01fd9e7e","VATTaxNumberID":"NULL","NameEng":"chengdushiruilaishangmaoyouxiangongsi","BusinessCode":"tuk03"} []
[2025-11-05 10:07:40] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e, VATTaxNumberID: , starting processing... [] []
[2025-11-05 10:07:40] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Processing attachment files: 5b8c16c3-e6cf-42b2-9fb8-3a15524dcb98 [] []
[2025-11-05 10:07:40] vat-sync.INFO: Found attachment files for ID 5b8c16c3-e6cf-42b2-9fb8-3a15524dcb98 {"paths":{"path1":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251104/dae22db5-a6f2-4876-91ab-c30d6e404353.pdf","path2":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251104/30a70ab8-141b-413f-8dff-cd49f96859d0.pdf","path3":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251104/488cfda1-7542-4855-8ab4-00767cb41ad4.pdf"},"types":{"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"}} []
[2025-11-05 10:07:40] vat-sync.INFO: Removed existing country code 86 from phone number [] []
[2025-11-05 10:07:40] vat-sync.INFO: Formatted China phone number: +86-12365498541 -> 8612365498541 (digits only for target DB) [] []
[2025-11-05 10:07:40] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Starting data validation... [] []
[2025-11-05 10:07:40] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Data validation passed [] []
[2025-11-05 10:07:40] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Creating registration email... [] []
[2025-11-05 10:07:40] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat37@usaeu.com","post_data":{"email":"registrationvat37@usaeu.com","password":"meiou@2025","active":1}} []
[2025-11-05 10:07:41] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat37@usaeu.com","active":1,"uname":"registrationvat37","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat37.20251105"}}} []
[2025-11-05 10:07:41] vat-sync.INFO: Email created successfully {"email":"registrationvat37@usaeu.com","sequence":37} []
[2025-11-05 10:07:41] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Email created successfully {"email":"registrationvat37@usaeu.com","sequence":37} []
[2025-11-05 10:07:41] vat-sync.INFO: Found existing record in target database {"source_record_id":"450aab9d-f1b0-4a7f-9037-61ec01fd9e7e","target_id":6,"current_registration_status":"1"} []
[2025-11-05 10:07:41] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - File types being saved {"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"} []
[2025-11-05 10:07:41] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Updating existing record in target database (target ID: 6, current status: 1)... [] []
[2025-11-05 10:07:41] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - BusinessCode value for UPDATE: tuk03 [] []
[2025-11-05 10:07:41] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - UK company check {"original_country":"中国","english_country":"China","is_uk_company":"false","uk_postcode":null} []
[2025-11-05 10:07:41] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - UPDATE parameters {"business_code":"tuk03","reg_number":"915203654120135AQ","company_name":"chengdushiruilaishangmaoyouxiangongsi"} []
[2025-11-05 10:07:41] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Target database insertion successful [] []
[2025-11-05 10:07:41] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Updating source email information... [] []
[2025-11-05 10:07:41] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Source email info updated successfully {"email":"registrationvat37@usaeu.com"} []
[2025-11-05 10:07:41] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Updating status to 2 [] []
[2025-11-05 10:07:41] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Status update successful [] []
[2025-11-05 10:07:41] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - All steps completed successfully, status set to 2 (processing) [] []
[2025-11-05 10:07:41] vat-sync.INFO: Sync cycle 2 completed successfully - VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e [] []
[2025-11-05 10:07:41] vat-sync.INFO: Waiting 5 seconds before next sync [] []
[2025-11-05 10:29:43] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":100} []
[2025-11-05 10:29:43] vat-sync.INFO: Removed stale lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock [] []
[2025-11-05 10:29:43] vat-sync.INFO: Created sync lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock with PID: 19032 [] []
[2025-11-05 10:29:43] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2025-11-05 10:29:43] vat-sync.INFO: Connecting to source database... [] []
[2025-11-05 10:29:44] vat-sync.INFO: Source database connected successfully [] []
[2025-11-05 10:29:44] vat-sync.INFO: Connecting to target database... [] []
[2025-11-05 10:29:44] vat-sync.INFO: Target database connected successfully [] []
[2025-11-05 10:29:44] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2025-11-05 10:29:44] vat-sync.INFO: DataSyncService initialized successfully [] []
[2025-11-05 10:29:44] vat-sync.INFO: Starting sync cycle 1/100 [] []
[2025-11-05 10:29:44] vat-sync.INFO: Starting data sync process [] []
[2025-11-05 10:29:44] vat-sync.INFO: Fetched record data {"vb_ID":"450aab9d-f1b0-4a7f-9037-61ec01fd9e7e","VATTaxNumberID":"NULL","NameEng":"chengdushiruilaishangmaoyouxiangongsi","BusinessCode":"tuk03"} []
[2025-11-05 10:29:44] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e, VATTaxNumberID: , starting processing... [] []
[2025-11-05 10:29:44] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Processing attachment files: 5b8c16c3-e6cf-42b2-9fb8-3a15524dcb98 [] []
[2025-11-05 10:29:44] vat-sync.INFO: Found attachment files for ID 5b8c16c3-e6cf-42b2-9fb8-3a15524dcb98 {"paths":{"path1":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251104/dae22db5-a6f2-4876-91ab-c30d6e404353.pdf","path2":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251104/30a70ab8-141b-413f-8dff-cd49f96859d0.pdf","path3":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251104/488cfda1-7542-4855-8ab4-00767cb41ad4.pdf"},"types":{"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"}} []
[2025-11-05 10:29:44] 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-11-05 10:29:44] vat-sync.INFO: Removed existing country code 86 from phone number [] []
[2025-11-05 10:29:44] vat-sync.INFO: Formatted China phone number: +86-12365498541 -> 8612365498541 (digits only for target DB) [] []
[2025-11-05 10:29:44] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Starting data validation... [] []
[2025-11-05 10:29:44] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Data validation passed [] []
[2025-11-05 10:29:44] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Creating registration email... [] []
[2025-11-05 10:29:44] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat38@usaeu.com","post_data":{"email":"registrationvat38@usaeu.com","password":"meiou@2025","active":1}} []
[2025-11-05 10:29:44] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat38@usaeu.com","active":1,"uname":"registrationvat38","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat38.20251105"}}} []
[2025-11-05 10:29:44] vat-sync.INFO: Email created successfully {"email":"registrationvat38@usaeu.com","sequence":38} []
[2025-11-05 10:29:44] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Email created successfully {"email":"registrationvat38@usaeu.com","sequence":38} []
[2025-11-05 10:29:44] vat-sync.INFO: Found existing record in target database {"source_record_id":"450aab9d-f1b0-4a7f-9037-61ec01fd9e7e","target_id":6,"current_registration_status":"3"} []
[2025-11-05 10:29:44] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - File types being saved {"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"} []
[2025-11-05 10:29:44] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Updating existing record in target database (target ID: 6, current status: 3)... [] []
[2025-11-05 10:29:44] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - BusinessCode value for UPDATE: tuk03 [] []
[2025-11-05 10:29:44] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - UK company check {"original_country":"中国","english_country":"China","is_uk_company":"false","uk_postcode":""} []
[2025-11-05 10:29:44] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - UPDATE parameters {"business_code":"tuk03","reg_number":"915203654120135AQ","company_name":"chengdushiruilaishangmaoyouxiangongsi"} []
[2025-11-05 10:29:44] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Target database insertion successful [] []
[2025-11-05 10:29:44] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Updating source email information... [] []
[2025-11-05 10:29:44] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Source email info updated successfully {"email":"registrationvat38@usaeu.com"} []
[2025-11-05 10:29:44] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Updating status to 2 [] []
[2025-11-05 10:29:45] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Status update successful [] []
[2025-11-05 10:29:45] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - All steps completed successfully, status set to 2 (processing) [] []
[2025-11-05 10:29:45] vat-sync.INFO: Sync cycle 1 completed successfully - VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e [] []
[2025-11-05 10:29:45] vat-sync.INFO: Waiting 5 seconds before next sync [] []
[2025-11-05 10:41:51] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":100} []
[2025-11-05 10:41:51] vat-sync.INFO: Created sync lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock with PID: 11432 [] []
[2025-11-05 10:41:51] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2025-11-05 10:41:51] vat-sync.INFO: Connecting to source database... [] []
[2025-11-05 10:41:51] vat-sync.INFO: Source database connected successfully [] []
[2025-11-05 10:41:51] vat-sync.INFO: Connecting to target database... [] []
[2025-11-05 10:41:51] vat-sync.INFO: Target database connected successfully [] []
[2025-11-05 10:41:51] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2025-11-05 10:41:51] vat-sync.INFO: DataSyncService initialized successfully [] []
[2025-11-05 10:41:51] vat-sync.INFO: Starting sync cycle 1/100 [] []
[2025-11-05 10:41:51] vat-sync.INFO: Starting data sync process [] []
[2025-11-05 10:41:51] vat-sync.INFO: Fetched record data {"vb_ID":"450aab9d-f1b0-4a7f-9037-61ec01fd9e7e","VATTaxNumberID":"NULL","NameEng":"chengdushiruilaishangmaoyouxiangongsi","BusinessCode":"tuk03"} []
[2025-11-05 10:41:51] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e, VATTaxNumberID: , starting processing... [] []
[2025-11-05 10:41:51] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Processing attachment files: 5b8c16c3-e6cf-42b2-9fb8-3a15524dcb98 [] []
[2025-11-05 10:41:51] vat-sync.INFO: Found attachment files for ID 5b8c16c3-e6cf-42b2-9fb8-3a15524dcb98 {"paths":{"path1":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251104/dae22db5-a6f2-4876-91ab-c30d6e404353.pdf","path2":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251104/30a70ab8-141b-413f-8dff-cd49f96859d0.pdf","path3":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251104/488cfda1-7542-4855-8ab4-00767cb41ad4.pdf"},"types":{"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"}} []
[2025-11-05 10:41:51] 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-11-05 10:41:51] vat-sync.INFO: Removed existing country code 86 from phone number [] []
[2025-11-05 10:41:51] vat-sync.INFO: Formatted China phone number: +86-12365498541 -> 8612365498541 (digits only for target DB) [] []
[2025-11-05 10:41:51] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Starting data validation... [] []
[2025-11-05 10:41:51] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Data validation passed [] []
[2025-11-05 10:41:51] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Creating registration email... [] []
[2025-11-05 10:41:51] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat39@usaeu.com","post_data":{"email":"registrationvat39@usaeu.com","password":"meiou@2025","active":1}} []
[2025-11-05 10:41:51] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat39@usaeu.com","active":1,"uname":"registrationvat39","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat39.20251105"}}} []
[2025-11-05 10:41:51] vat-sync.INFO: Email created successfully {"email":"registrationvat39@usaeu.com","sequence":39} []
[2025-11-05 10:41:51] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Email created successfully {"email":"registrationvat39@usaeu.com","sequence":39} []
[2025-11-05 10:41:51] vat-sync.INFO: Found existing record in target database {"source_record_id":"450aab9d-f1b0-4a7f-9037-61ec01fd9e7e","target_id":6,"current_registration_status":"1"} []
[2025-11-05 10:41:51] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - File types being saved {"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"} []
[2025-11-05 10:41:51] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Updating existing record in target database (target ID: 6, current status: 1)... [] []
[2025-11-05 10:41:51] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - BusinessCode value for UPDATE: tuk03 [] []
[2025-11-05 10:41:51] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - UK company check {"original_country":"中国","english_country":"China","is_uk_company":"false","uk_postcode":""} []
[2025-11-05 10:41:51] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - UPDATE parameters {"business_code":"tuk03","reg_number":"915203654120135AQ","company_name":"chengdushiruilaishangmaoyouxiangongsi"} []
[2025-11-05 10:41:51] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Target database insertion successful [] []
[2025-11-05 10:41:51] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Updating source email information... [] []
[2025-11-05 10:41:51] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Source email info updated successfully {"email":"registrationvat39@usaeu.com"} []
[2025-11-05 10:41:51] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Updating status to 2 [] []
[2025-11-05 10:41:51] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Status update successful [] []
[2025-11-05 10:41:51] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - All steps completed successfully, status set to 2 (processing) [] []
[2025-11-05 10:41:51] vat-sync.INFO: Sync cycle 1 completed successfully - VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e [] []
[2025-11-05 10:41:51] vat-sync.INFO: Waiting 5 seconds before next sync [] []
[2025-11-05 10:52:47] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":100} []
[2025-11-05 10:52:47] vat-sync.INFO: Removed stale lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock [] []
[2025-11-05 10:52:47] vat-sync.INFO: Created sync lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock with PID: 23912 [] []
[2025-11-05 10:52:47] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2025-11-05 10:52:47] vat-sync.INFO: Connecting to source database... [] []
[2025-11-05 10:52:47] vat-sync.INFO: Source database connected successfully [] []
[2025-11-05 10:52:47] vat-sync.INFO: Connecting to target database... [] []
[2025-11-05 10:52:47] vat-sync.INFO: Target database connected successfully [] []
[2025-11-05 10:52:47] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2025-11-05 10:52:47] vat-sync.INFO: DataSyncService initialized successfully [] []
[2025-11-05 10:52:47] vat-sync.INFO: Starting sync cycle 1/100 [] []
[2025-11-05 10:52:47] vat-sync.INFO: Starting data sync process [] []
[2025-11-05 10:52:47] vat-sync.INFO: Fetched record data {"vb_ID":"450aab9d-f1b0-4a7f-9037-61ec01fd9e7e","VATTaxNumberID":"NULL","NameEng":"chengdushiruilaishangmaoyouxiangongsi","BusinessCode":"tuk03"} []
[2025-11-05 10:52:47] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e, VATTaxNumberID: , starting processing... [] []
[2025-11-05 10:52:47] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Processing attachment files: 5b8c16c3-e6cf-42b2-9fb8-3a15524dcb98 [] []
[2025-11-05 10:52:47] vat-sync.INFO: Found attachment files for ID 5b8c16c3-e6cf-42b2-9fb8-3a15524dcb98 {"paths":{"path1":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251104/dae22db5-a6f2-4876-91ab-c30d6e404353.pdf","path2":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251104/30a70ab8-141b-413f-8dff-cd49f96859d0.pdf","path3":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251104/488cfda1-7542-4855-8ab4-00767cb41ad4.pdf"},"types":{"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"}} []
[2025-11-05 10:52:47] 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-11-05 10:52:47] vat-sync.INFO: Removed existing country code 86 from phone number [] []
[2025-11-05 10:52:47] vat-sync.INFO: Formatted China phone number: +86-12365498541 -> 8612365498541 (digits only for target DB) [] []
[2025-11-05 10:52:47] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Starting data validation... [] []
[2025-11-05 10:52:47] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Data validation passed [] []
[2025-11-05 10:52:47] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Creating registration email... [] []
[2025-11-05 10:52:47] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat40@usaeu.com","post_data":{"email":"registrationvat40@usaeu.com","password":"meiou@2025","active":1}} []
[2025-11-05 10:52:47] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat40@usaeu.com","active":1,"uname":"registrationvat40","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat40.20251105"}}} []
[2025-11-05 10:52:47] vat-sync.INFO: Email created successfully {"email":"registrationvat40@usaeu.com","sequence":40} []
[2025-11-05 10:52:47] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Email created successfully {"email":"registrationvat40@usaeu.com","sequence":40} []
[2025-11-05 10:52:47] vat-sync.INFO: Found existing record in target database {"source_record_id":"450aab9d-f1b0-4a7f-9037-61ec01fd9e7e","target_id":6,"current_registration_status":"1"} []
[2025-11-05 10:52:47] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - File types being saved {"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"} []
[2025-11-05 10:52:47] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Updating existing record in target database (target ID: 6, current status: 1)... [] []
[2025-11-05 10:52:47] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - BusinessCode value for UPDATE: tuk03 [] []
[2025-11-05 10:52:47] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - UK company check {"original_country":"中国","english_country":"China","is_uk_company":"false","uk_postcode":""} []
[2025-11-05 10:52:47] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - UPDATE parameters {"business_code":"tuk03","reg_number":"915203654120135AQ","company_name":"chengdushiruilaishangmaoyouxiangongsi"} []
[2025-11-05 10:52:47] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Target database insertion successful [] []
[2025-11-05 10:52:47] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Updating source email information... [] []
[2025-11-05 10:52:47] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Source email info updated successfully {"email":"registrationvat40@usaeu.com"} []
[2025-11-05 10:52:47] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Updating status to 2 [] []
[2025-11-05 10:52:47] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Status update successful [] []
[2025-11-05 10:52:47] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - All steps completed successfully, status set to 2 (processing) [] []
[2025-11-05 10:52:47] vat-sync.INFO: Sync cycle 1 completed successfully - VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e [] []
[2025-11-05 10:52:47] vat-sync.INFO: Waiting 5 seconds before next sync [] []
[2025-11-05 11:02:21] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":100} []
[2025-11-05 11:02:21] vat-sync.INFO: Removed stale lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock [] []
[2025-11-05 11:02:21] vat-sync.INFO: Created sync lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock with PID: 22684 [] []
[2025-11-05 11:02:21] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2025-11-05 11:02:21] vat-sync.INFO: Connecting to source database... [] []
[2025-11-05 11:02:21] vat-sync.INFO: Source database connected successfully [] []
[2025-11-05 11:02:21] vat-sync.INFO: Connecting to target database... [] []
[2025-11-05 11:02:21] vat-sync.INFO: Target database connected successfully [] []
[2025-11-05 11:02:21] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2025-11-05 11:02:21] vat-sync.INFO: DataSyncService initialized successfully [] []
[2025-11-05 11:02:21] vat-sync.INFO: Starting sync cycle 1/100 [] []
[2025-11-05 11:02:21] vat-sync.INFO: Starting data sync process [] []
[2025-11-05 11:02:21] vat-sync.INFO: Fetched record data {"vb_ID":"450aab9d-f1b0-4a7f-9037-61ec01fd9e7e","VATTaxNumberID":"NULL","NameEng":"chengdushiruilaishangmaoyouxiangongsi","BusinessCode":"tuk03"} []
[2025-11-05 11:02:21] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e, VATTaxNumberID: , starting processing... [] []
[2025-11-05 11:02:21] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Processing attachment files: 5b8c16c3-e6cf-42b2-9fb8-3a15524dcb98 [] []
[2025-11-05 11:02:21] vat-sync.INFO: Found attachment files for ID 5b8c16c3-e6cf-42b2-9fb8-3a15524dcb98 {"paths":{"path1":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251104/dae22db5-a6f2-4876-91ab-c30d6e404353.pdf","path2":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251104/30a70ab8-141b-413f-8dff-cd49f96859d0.pdf","path3":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251104/488cfda1-7542-4855-8ab4-00767cb41ad4.pdf"},"types":{"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"}} []
[2025-11-05 11:02:21] 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-11-05 11:02:21] vat-sync.INFO: Removed existing country code 86 from phone number [] []
[2025-11-05 11:02:21] vat-sync.INFO: Formatted China phone number: +86-12365498541 -> 8612365498541 (digits only for target DB) [] []
[2025-11-05 11:02:21] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Starting data validation... [] []
[2025-11-05 11:02:21] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Data validation passed [] []
[2025-11-05 11:02:21] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Creating registration email... [] []
[2025-11-05 11:02:21] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat41@usaeu.com","post_data":{"email":"registrationvat41@usaeu.com","password":"meiou@2025","active":1}} []
[2025-11-05 11:02:21] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat41@usaeu.com","active":1,"uname":"registrationvat41","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat41.20251105"}}} []
[2025-11-05 11:02:21] vat-sync.INFO: Email created successfully {"email":"registrationvat41@usaeu.com","sequence":41} []
[2025-11-05 11:02:21] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Email created successfully {"email":"registrationvat41@usaeu.com","sequence":41} []
[2025-11-05 11:02:21] vat-sync.INFO: Found existing record in target database {"source_record_id":"450aab9d-f1b0-4a7f-9037-61ec01fd9e7e","target_id":6,"current_registration_status":"1"} []
[2025-11-05 11:02:21] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - File types being saved {"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"} []
[2025-11-05 11:02:21] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Updating existing record in target database (target ID: 6, current status: 1)... [] []
[2025-11-05 11:02:21] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - BusinessCode value for UPDATE: tuk03 [] []
[2025-11-05 11:02:21] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - UK company check {"original_country":"中国","english_country":"China","is_uk_company":"false","uk_postcode":""} []
[2025-11-05 11:02:21] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - UPDATE parameters {"business_code":"tuk03","reg_number":"915203654120135AQ","company_name":"chengdushiruilaishangmaoyouxiangongsi"} []
[2025-11-05 11:02:21] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Target database insertion successful [] []
[2025-11-05 11:02:21] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Updating source email information... [] []
[2025-11-05 11:02:21] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Source email info updated successfully {"email":"registrationvat41@usaeu.com"} []
[2025-11-05 11:02:21] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Updating status to 2 [] []
[2025-11-05 11:02:21] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Status update successful [] []
[2025-11-05 11:02:21] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - All steps completed successfully, status set to 2 (processing) [] []
[2025-11-05 11:02:21] vat-sync.INFO: Sync cycle 1 completed successfully - VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e [] []
[2025-11-05 11:02:21] vat-sync.INFO: Waiting 5 seconds before next sync [] []
[2025-11-05 11:10:10] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":100} []
[2025-11-05 11:10:10] vat-sync.INFO: Removed stale lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock [] []
[2025-11-05 11:10:10] vat-sync.INFO: Created sync lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock with PID: 19188 [] []
[2025-11-05 11:10:10] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2025-11-05 11:10:10] vat-sync.INFO: Connecting to source database... [] []
[2025-11-05 11:10:10] vat-sync.INFO: Source database connected successfully [] []
[2025-11-05 11:10:10] vat-sync.INFO: Connecting to target database... [] []
[2025-11-05 11:10:10] vat-sync.INFO: Target database connected successfully [] []
[2025-11-05 11:10:10] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2025-11-05 11:10:10] vat-sync.INFO: DataSyncService initialized successfully [] []
[2025-11-05 11:10:10] vat-sync.INFO: Starting sync cycle 1/100 [] []
[2025-11-05 11:10:10] vat-sync.INFO: Starting data sync process [] []
[2025-11-05 11:10:10] vat-sync.INFO: Fetched record data {"vb_ID":"450aab9d-f1b0-4a7f-9037-61ec01fd9e7e","VATTaxNumberID":"NULL","NameEng":"chengdushiruilaishangmaoyouxiangongsi","BusinessCode":"tuk03"} []
[2025-11-05 11:10:10] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e, VATTaxNumberID: , starting processing... [] []
[2025-11-05 11:10:10] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Processing attachment files: 5b8c16c3-e6cf-42b2-9fb8-3a15524dcb98 [] []
[2025-11-05 11:10:10] vat-sync.INFO: Found attachment files for ID 5b8c16c3-e6cf-42b2-9fb8-3a15524dcb98 {"paths":{"path1":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251104/dae22db5-a6f2-4876-91ab-c30d6e404353.pdf","path2":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251104/30a70ab8-141b-413f-8dff-cd49f96859d0.pdf","path3":"http://testfile.usaeu.com/14c9f59c-dfb2-4389-b5d7-330f6235d241/20251104/488cfda1-7542-4855-8ab4-00767cb41ad4.pdf"},"types":{"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"}} []
[2025-11-05 11:10:10] 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-11-05 11:10:10] vat-sync.INFO: Removed existing country code 86 from phone number [] []
[2025-11-05 11:10:10] vat-sync.INFO: Formatted China phone number: +86-12365498541 -> 8612365498541 (digits only for target DB) [] []
[2025-11-05 11:10:10] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Starting data validation... [] []
[2025-11-05 11:10:10] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Data validation passed [] []
[2025-11-05 11:10:10] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Creating registration email... [] []
[2025-11-05 11:10:11] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat42@usaeu.com","post_data":{"email":"registrationvat42@usaeu.com","password":"meiou@2025","active":1}} []
[2025-11-05 11:10:11] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat42@usaeu.com","active":1,"uname":"registrationvat42","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat42.20251105"}}} []
[2025-11-05 11:10:11] vat-sync.INFO: Email created successfully {"email":"registrationvat42@usaeu.com","sequence":42} []
[2025-11-05 11:10:11] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Email created successfully {"email":"registrationvat42@usaeu.com","sequence":42} []
[2025-11-05 11:10:11] vat-sync.INFO: Found existing record in target database {"source_record_id":"450aab9d-f1b0-4a7f-9037-61ec01fd9e7e","target_id":6,"current_registration_status":"1"} []
[2025-11-05 11:10:11] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - File types being saved {"type1":"national identity card.pdf","type2":"credit card statement.pdf","type3":"bank statement.pdf"} []
[2025-11-05 11:10:11] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Updating existing record in target database (target ID: 6, current status: 1)... [] []
[2025-11-05 11:10:11] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - BusinessCode value for UPDATE: tuk03 [] []
[2025-11-05 11:10:11] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - UK company check {"original_country":"中国","english_country":"China","is_uk_company":"false","uk_postcode":""} []
[2025-11-05 11:10:11] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - UPDATE parameters {"business_code":"tuk03","reg_number":"915203654120135AQ","company_name":"chengdushiruilaishangmaoyouxiangongsi"} []
[2025-11-05 11:10:11] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Target database insertion successful [] []
[2025-11-05 11:10:11] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Updating source email information... [] []
[2025-11-05 11:10:11] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Source email info updated successfully {"email":"registrationvat42@usaeu.com"} []
[2025-11-05 11:10:11] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Updating status to 2 [] []
[2025-11-05 11:10:11] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - Status update successful [] []
[2025-11-05 11:10:11] vat-sync.INFO: VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e - All steps completed successfully, status set to 2 (processing) [] []
[2025-11-05 11:10:11] vat-sync.INFO: Sync cycle 1 completed successfully - VATBusinessRecord.ID: 450aab9d-f1b0-4a7f-9037-61ec01fd9e7e [] []
[2025-11-05 11:10:11] vat-sync.INFO: Waiting 5 seconds before next sync [] []