[2025-10-29 18:31:32] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":1000} []
[2025-10-29 18:31:32] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2025-10-29 18:31:32] vat-sync.INFO: Connecting to source database... [] []
[2025-10-29 18:31:32] vat-sync.INFO: Source database connected successfully [] []
[2025-10-29 18:31:32] vat-sync.INFO: Connecting to target database... [] []
[2025-10-29 18:31:32] vat-sync.INFO: Target database connected successfully [] []
[2025-10-29 18:31:32] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2025-10-29 18:31:32] vat-sync.INFO: DataSyncService initialized successfully [] []
[2025-10-29 18:31:32] vat-sync.INFO: Starting sync cycle 1/1000 [] []
[2025-10-29 18:31:32] vat-sync.INFO: Starting data sync process [] []
[2025-10-29 18:31:32] vat-sync.INFO: No pending records found [] []
[2025-10-29 18:31:32] vat-sync.INFO: Sync cycle 1 completed successfully - No pending records found [] []
[2025-10-29 18:31:32] vat-sync.INFO: Waiting 5 seconds before next sync [] []
[2025-10-29 18:32:44] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":1000} []
[2025-10-29 18:32:44] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2025-10-29 18:32:44] vat-sync.INFO: Connecting to source database... [] []
[2025-10-29 18:32:44] vat-sync.INFO: Source database connected successfully [] []
[2025-10-29 18:32:44] vat-sync.INFO: Connecting to target database... [] []
[2025-10-29 18:32:44] vat-sync.INFO: Target database connected successfully [] []
[2025-10-29 18:32:44] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2025-10-29 18:32:44] vat-sync.INFO: DataSyncService initialized successfully [] []
[2025-10-29 18:32:44] vat-sync.INFO: Starting sync cycle 1/1000 [] []
[2025-10-29 18:32:44] vat-sync.INFO: Starting data sync process [] []
[2025-10-29 18:32:45] vat-sync.INFO: Fetched record data {"vb_ID":"30e97994-b35e-4eb8-92a8-2c60678ea892","VATTaxNumberID":"NULL","NameEng":"shenzhenroujieshangmaoyouxiangongsi","BusinessCode":"tuk01"} []
[2025-10-29 18:32:45] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892, VATTaxNumberID: , starting processing... [] []
[2025-10-29 18:32:45] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Processing attachment files: 59fc5737-ca9f-4091-a4cb-09930c08ad3d [] []
[2025-10-29 18:32:45] 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-29 18:32:45] 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-29 18:32:45] vat-sync.INFO: Removed existing country code 86 from phone number [] []
[2025-10-29 18:32:45] vat-sync.INFO: Formatted China phone number: +86-18795859105 -> 8618795859105 (digits only for target DB) [] []
[2025-10-29 18:32:45] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Starting data validation... [] []
[2025-10-29 18:32:45] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Data validation passed [] []
[2025-10-29 18:32:45] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Creating registration email... [] []
[2025-10-29 18:32:45] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat22@usaeu.com","post_data":{"email":"registrationvat22@usaeu.com","password":"meiou@2025","active":1}} []
[2025-10-29 18:32:45] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat22@usaeu.com","active":1,"uname":"registrationvat22","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat22.20251029"}}} []
[2025-10-29 18:32:45] vat-sync.INFO: Email created successfully {"email":"registrationvat22@usaeu.com","sequence":22} []
[2025-10-29 18:32:45] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Email created successfully {"email":"registrationvat22@usaeu.com","sequence":22} []
[2025-10-29 18:32:45] 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-29 18:32:45] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Inserting new record into target database... [] []
[2025-10-29 18:32:45] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - BusinessCode value for INSERT: tuk01 [] []
[2025-10-29 18:32:45] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - INSERT parameters {"business_code":"tuk01","reg_number":"12346","company_name":"shenzhenroujieshangmaoyouxiangongsi"} []
[2025-10-29 18:32:45] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Target database insertion successful [] []
[2025-10-29 18:32:45] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating source email information... [] []
[2025-10-29 18:32:45] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Source email info updated successfully {"email":"registrationvat22@usaeu.com"} []
[2025-10-29 18:32:45] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Updating status to 2 [] []
[2025-10-29 18:32:45] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - Status update successful [] []
[2025-10-29 18:32:45] vat-sync.INFO: VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 - All steps completed successfully, status set to 2 (processing) [] []
[2025-10-29 18:32:45] vat-sync.INFO: Sync cycle 1 completed successfully - VATBusinessRecord.ID: 30e97994-b35e-4eb8-92a8-2c60678ea892 [] []
[2025-10-29 18:32:45] vat-sync.INFO: Waiting 5 seconds before next sync [] []