[2026-03-25 17:14:31] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":"infinite","mode":"continuous"} []
[2026-03-25 17:14:31] vat-sync.INFO: Created sync lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock with PID: 1976 [] []
[2026-03-25 17:14:31] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2026-03-25 17:14:31] vat-sync.INFO: Connecting to source database... [] []
[2026-03-25 17:14:31] vat-sync.INFO: Source database connected successfully [] []
[2026-03-25 17:14:31] vat-sync.INFO: Connecting to target database... [] []
[2026-03-25 17:14:32] vat-sync.INFO: Target database connected successfully [] []
[2026-03-25 17:14:32] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2026-03-25 17:14:32] vat-sync.INFO: DataSyncService initialized successfully [] []
[2026-03-25 17:14:32] vat-sync.INFO: Starting sync cycle 1 [] []
[2026-03-25 17:14:32] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:14:32] vat-sync.INFO: Fetched record data {"vb_ID":"48a13229-959d-416b-883c-66ceeedab77f","VATTaxNumberID":"NULL","NameEng":"441","BusinessCode":"NULL"} []
[2026-03-25 17:14:32] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f, VATTaxNumberID: , starting processing... [] []
[2026-03-25 17:14:32] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Processing attachment files: 3636d7e7-249e-3d19-9158-2dc74027bc74 [] []
[2026-03-25 17:14:32] vat-sync.INFO: Found attachment files for ID 3636d7e7-249e-3d19-9158-2dc74027bc74 {"paths":{"path1":null,"path2":null,"path3":null},"types":{"type1":null,"type2":null,"type3":null}} []
[2026-03-25 17:14:32] vat-sync.ERROR: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Legal person country is required but empty [] []
[2026-03-25 17:14:32] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Updating status to -1 with error: Legal person country field cannot be empty [] []
[2026-03-25 17:14:32] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Status update successful [] []
[2026-03-25 17:14:32] vat-sync.WARNING: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Validation failed: Legal person country field cannot be empty [] []
[2026-03-25 17:14:32] vat-sync.WARNING: Sync cycle 1 completed with issues - VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Legal person country field cannot be empty [] []
[2026-03-25 17:14:38] vat-sync.INFO: Starting sync cycle 2 [] []
[2026-03-25 17:14:38] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:14:38] vat-sync.INFO: No pending records found [] []
[2026-03-25 17:14:38] vat-sync.INFO: Sync cycle 2 completed successfully - No pending records found [] []
[2026-03-25 17:24:02] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":"infinite","mode":"continuous"} []
[2026-03-25 17:24:02] vat-sync.INFO: Removed stale lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock [] []
[2026-03-25 17:24:02] vat-sync.INFO: Created sync lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock with PID: 21556 [] []
[2026-03-25 17:24:02] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2026-03-25 17:24:02] vat-sync.INFO: Connecting to source database... [] []
[2026-03-25 17:24:02] vat-sync.INFO: Source database connected successfully [] []
[2026-03-25 17:24:02] vat-sync.INFO: Connecting to target database... [] []
[2026-03-25 17:24:02] vat-sync.INFO: Target database connected successfully [] []
[2026-03-25 17:24:02] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2026-03-25 17:24:02] vat-sync.INFO: DataSyncService initialized successfully [] []
[2026-03-25 17:24:02] vat-sync.INFO: Starting sync cycle 1 [] []
[2026-03-25 17:24:02] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:24:02] vat-sync.INFO: Fetched record data {"vb_ID":"48a13229-959d-416b-883c-66ceeedab77f","VATTaxNumberID":"NULL","NameEng":"441","BusinessCode":"NULL"} []
[2026-03-25 17:24:02] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f, VATTaxNumberID: , starting processing... [] []
[2026-03-25 17:24:02] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Processing attachment files: 3636d7e7-249e-3d19-9158-2dc74027bc74 [] []
[2026-03-25 17:24:02] vat-sync.INFO: Found attachment files for ID 3636d7e7-249e-3d19-9158-2dc74027bc74 {"paths":{"path1":null,"path2":null,"path3":null},"types":{"type1":null,"type2":null,"type3":null}} []
[2026-03-25 17:24:02] vat-sync.ERROR: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Legal person country is required but empty [] []
[2026-03-25 17:24:02] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Updating status to -1 with error: Legal person country field cannot be empty [] []
[2026-03-25 17:24:02] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Status update successful [] []
[2026-03-25 17:24:02] vat-sync.WARNING: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Validation failed: Legal person country field cannot be empty [] []
[2026-03-25 17:24:02] vat-sync.WARNING: Sync cycle 1 completed with issues - VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Legal person country field cannot be empty [] []
[2026-03-25 17:24:07] vat-sync.INFO: Starting sync cycle 2 [] []
[2026-03-25 17:24:07] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:24:07] vat-sync.INFO: No pending records found [] []
[2026-03-25 17:24:07] vat-sync.INFO: Sync cycle 2 completed successfully - No pending records found [] []
[2026-03-25 17:24:12] vat-sync.INFO: Starting sync cycle 3 [] []
[2026-03-25 17:24:12] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:24:12] vat-sync.INFO: No pending records found [] []
[2026-03-25 17:24:12] vat-sync.INFO: Sync cycle 3 completed successfully - No pending records found [] []
[2026-03-25 17:24:17] vat-sync.INFO: Starting sync cycle 4 [] []
[2026-03-25 17:24:18] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:24:18] vat-sync.INFO: No pending records found [] []
[2026-03-25 17:24:18] vat-sync.INFO: Sync cycle 4 completed successfully - No pending records found [] []
[2026-03-25 17:26:10] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":"infinite","mode":"continuous"} []
[2026-03-25 17:26:10] vat-sync.INFO: Removed stale lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock [] []
[2026-03-25 17:26:10] vat-sync.INFO: Created sync lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock with PID: 3372 [] []
[2026-03-25 17:26:10] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2026-03-25 17:26:10] vat-sync.INFO: Connecting to source database... [] []
[2026-03-25 17:26:10] vat-sync.INFO: Source database connected successfully [] []
[2026-03-25 17:26:10] vat-sync.INFO: Connecting to target database... [] []
[2026-03-25 17:26:10] vat-sync.INFO: Target database connected successfully [] []
[2026-03-25 17:26:10] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2026-03-25 17:26:10] vat-sync.INFO: DataSyncService initialized successfully [] []
[2026-03-25 17:26:10] vat-sync.INFO: Starting sync cycle 1 [] []
[2026-03-25 17:26:10] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:26:10] vat-sync.INFO: Fetched record data {"vb_ID":"48a13229-959d-416b-883c-66ceeedab77f","VATTaxNumberID":"NULL","NameEng":"441","BusinessCode":"NULL"} []
[2026-03-25 17:26:10] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f, VATTaxNumberID: , starting processing... [] []
[2026-03-25 17:26:10] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Processing attachment files: 3636d7e7-249e-3d19-9158-2dc74027bc74 [] []
[2026-03-25 17:26:10] vat-sync.INFO: Found attachment files for ID 3636d7e7-249e-3d19-9158-2dc74027bc74 {"paths":{"path1":null,"path2":null,"path3":null},"types":{"type1":null,"type2":null,"type3":null}} []
[2026-03-25 17:26:10] vat-sync.ERROR: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Legal person country is required but empty [] []
[2026-03-25 17:26:10] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Updating status to -1 with error: Legal person country field cannot be empty [] []
[2026-03-25 17:26:10] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Status update successful [] []
[2026-03-25 17:26:10] vat-sync.WARNING: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Validation failed: Legal person country field cannot be empty [] []
[2026-03-25 17:26:10] vat-sync.WARNING: Sync cycle 1 completed with issues - VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Legal person country field cannot be empty [] []
[2026-03-25 17:26:15] vat-sync.INFO: Starting sync cycle 2 [] []
[2026-03-25 17:26:15] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:26:15] vat-sync.INFO: No pending records found [] []
[2026-03-25 17:26:15] vat-sync.INFO: Sync cycle 2 completed successfully - No pending records found [] []
[2026-03-25 17:26:20] vat-sync.INFO: Starting sync cycle 3 [] []
[2026-03-25 17:26:20] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:26:20] vat-sync.INFO: No pending records found [] []
[2026-03-25 17:26:20] vat-sync.INFO: Sync cycle 3 completed successfully - No pending records found [] []
[2026-03-25 17:26:25] vat-sync.INFO: Starting sync cycle 4 [] []
[2026-03-25 17:26:25] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:26:25] vat-sync.INFO: No pending records found [] []
[2026-03-25 17:26:25] vat-sync.INFO: Sync cycle 4 completed successfully - No pending records found [] []
[2026-03-25 17:35:53] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":"infinite","mode":"continuous"} []
[2026-03-25 17:35:53] vat-sync.INFO: Removed stale lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock [] []
[2026-03-25 17:35:53] vat-sync.INFO: Created sync lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock with PID: 26468 [] []
[2026-03-25 17:35:53] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2026-03-25 17:35:53] vat-sync.INFO: Connecting to source database... [] []
[2026-03-25 17:35:53] vat-sync.INFO: Source database connected successfully [] []
[2026-03-25 17:35:53] vat-sync.INFO: Connecting to target database... [] []
[2026-03-25 17:35:53] vat-sync.INFO: Target database connected successfully [] []
[2026-03-25 17:35:53] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2026-03-25 17:35:53] vat-sync.INFO: DataSyncService initialized successfully [] []
[2026-03-25 17:35:53] vat-sync.INFO: Starting sync cycle 1 [] []
[2026-03-25 17:35:53] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:35:53] vat-sync.INFO: Fetched record data {"vb_ID":"48a13229-959d-416b-883c-66ceeedab77f","VATTaxNumberID":"NULL","NameEng":"441","BusinessCode":"NULL"} []
[2026-03-25 17:35:53] vat-sync.INFO: Found pending record - VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f, VATTaxNumberID: , starting processing... [] []
[2026-03-25 17:35:53] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Processing attachment files: 3636d7e7-249e-3d19-9158-2dc74027bc74 [] []
[2026-03-25 17:35:53] vat-sync.INFO: Found attachment files for ID 3636d7e7-249e-3d19-9158-2dc74027bc74 {"paths":{"path1":null,"path2":null,"path3":null},"types":{"type1":null,"type2":null,"type3":null}} []
[2026-03-25 17:35:53] vat-sync.INFO: Phone number formatting successful {"original":"86-14452445","formatted":"8614452445","length":10} []
[2026-03-25 17:35:53] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Starting data validation... [] []
[2026-03-25 17:35:53] 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"} []
[2026-03-25 17:35:53] vat-sync.ERROR: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Data validation failed [] []
[2026-03-25 17:35:53] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Updating status to -1 with error: Legal person name should be in pinyin format (letters, spaces, hyphens only); Legal person age should be between 1 and 100 years; Legal person address line 1 is required; Legal person address line 2 is required; Company address line 1 is required; Company address line 2 is required; Company city is required; Products range is required; Legal document file (upload_file_path1) is required; Supporting document file (upload_file_path2) is required; Additional document file (upload_file_path3) is required [] []
[2026-03-25 17:35:53] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Status update successful [] []
[2026-03-25 17:35:53] vat-sync.WARNING: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Validation failed: Legal person name should be in pinyin format (letters, spaces, hyphens only); Legal person age should be between 1 and 100 years; Legal person address line 1 is required; Legal person address line 2 is required; Company address line 1 is required; Company address line 2 is required; Company city is required; Products range is required; Legal document file (upload_file_path1) is required; Supporting document file (upload_file_path2) is required; Additional document file (upload_file_path3) is required [] []
[2026-03-25 17:35:53] vat-sync.WARNING: Sync cycle 1 completed with issues - VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Data validation failed [] []
[2026-03-25 17:35:58] vat-sync.INFO: Starting sync cycle 2 [] []
[2026-03-25 17:35:58] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:35:58] vat-sync.INFO: No pending records found [] []
[2026-03-25 17:35:58] vat-sync.INFO: Sync cycle 2 completed successfully - No pending records found [] []
[2026-03-25 17:36:03] vat-sync.INFO: Starting sync cycle 3 [] []
[2026-03-25 17:36:03] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:36:03] vat-sync.INFO: No pending records found [] []
[2026-03-25 17:36:03] vat-sync.INFO: Sync cycle 3 completed successfully - No pending records found [] []
[2026-03-25 17:38:41] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":"infinite","mode":"continuous"} []
[2026-03-25 17:38:41] vat-sync.INFO: Removed stale lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock [] []
[2026-03-25 17:38:41] vat-sync.INFO: Created sync lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock with PID: 27040 [] []
[2026-03-25 17:38:41] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2026-03-25 17:38:41] vat-sync.INFO: Connecting to source database... [] []
[2026-03-25 17:38:41] vat-sync.INFO: Source database connected successfully [] []
[2026-03-25 17:38:41] vat-sync.INFO: Connecting to target database... [] []
[2026-03-25 17:38:41] vat-sync.INFO: Target database connected successfully [] []
[2026-03-25 17:38:41] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2026-03-25 17:38:41] vat-sync.INFO: DataSyncService initialized successfully [] []
[2026-03-25 17:38:41] vat-sync.INFO: Starting sync cycle 1 [] []
[2026-03-25 17:38:41] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:38:41] vat-sync.INFO: No pending records found [] []
[2026-03-25 17:38:41] vat-sync.INFO: Sync cycle 1 completed successfully - No pending records found [] []
[2026-03-25 17:38:46] vat-sync.INFO: Starting sync cycle 2 [] []
[2026-03-25 17:38:46] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:38:46] vat-sync.INFO: No pending records found [] []
[2026-03-25 17:38:46] vat-sync.INFO: Sync cycle 2 completed successfully - No pending records found [] []
[2026-03-25 17:38:51] vat-sync.INFO: Starting sync cycle 3 [] []
[2026-03-25 17:38:51] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:38:51] vat-sync.INFO: No pending records found [] []
[2026-03-25 17:38:51] vat-sync.INFO: Sync cycle 3 completed successfully - No pending records found [] []
[2026-03-25 17:38:57] vat-sync.INFO: Starting sync cycle 4 [] []
[2026-03-25 17:38:57] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:38:57] vat-sync.INFO: Fetched record data {"vb_ID":"48a13229-959d-416b-883c-66ceeedab77f","VATTaxNumberID":"NULL","NameEng":"441","BusinessCode":"NULL"} []
[2026-03-25 17:38:57] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Creating registration email... [] []
[2026-03-25 17:38:57] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat3748@usaeu.com","post_data":{"email":"registrationvat3748@usaeu.com","password":"meiou@2025","active":1}} []
[2026-03-25 17:38:59] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat3748@usaeu.com","active":1,"uname":"registrationvat3748","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat3748.20260325"}}} []
[2026-03-25 17:38:59] vat-sync.INFO: Email created successfully {"email":"registrationvat3748@usaeu.com","sequence":3748} []
[2026-03-25 17:38:59] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Email created successfully {"email":"registrationvat3748@usaeu.com","sequence":3748} []
[2026-03-25 17:38:59] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Inserting new record into target database... [] []
[2026-03-25 17:38:59] vat-sync.INFO: Cleaned up sync lock file on exit: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock [] []
[2026-03-25 17:38:59] vat-sync.INFO: Cleaned up heartbeat file on exit: E:\ou\meiou-app\uk_vat_reg\bin/../heartbeat_test.txt [] []
[2026-03-25 17:41:28] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":"infinite","mode":"continuous"} []
[2026-03-25 17:41:28] vat-sync.INFO: Created sync lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock with PID: 12832 [] []
[2026-03-25 17:41:28] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2026-03-25 17:41:28] vat-sync.INFO: Connecting to source database... [] []
[2026-03-25 17:41:28] vat-sync.INFO: Source database connected successfully [] []
[2026-03-25 17:41:28] vat-sync.INFO: Connecting to target database... [] []
[2026-03-25 17:41:28] vat-sync.INFO: Target database connected successfully [] []
[2026-03-25 17:41:28] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2026-03-25 17:41:28] vat-sync.INFO: DataSyncService initialized successfully [] []
[2026-03-25 17:41:28] vat-sync.INFO: Starting sync cycle 1 [] []
[2026-03-25 17:41:28] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:41:28] vat-sync.INFO: Fetched record data {"vb_ID":"48a13229-959d-416b-883c-66ceeedab77f","VATTaxNumberID":"NULL","NameEng":"441","BusinessCode":"NULL"} []
[2026-03-25 17:41:28] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Creating registration email... [] []
[2026-03-25 17:41:28] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat3749@usaeu.com","post_data":{"email":"registrationvat3749@usaeu.com","password":"meiou@2025","active":1}} []
[2026-03-25 17:41:30] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat3749@usaeu.com","active":1,"uname":"registrationvat3749","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat3749.20260325"}}} []
[2026-03-25 17:41:30] vat-sync.INFO: Email created successfully {"email":"registrationvat3749@usaeu.com","sequence":3749} []
[2026-03-25 17:41:30] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Email created successfully {"email":"registrationvat3749@usaeu.com","sequence":3749} []
[2026-03-25 17:41:30] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Inserting new record into target database... [] []
[2026-03-25 17:41:30] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - BusinessCode value for INSERT: NULL [] []
[2026-03-25 17:41:30] 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"} []
[2026-03-25 17:41:30] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - UK company check {"original_country":"中国","english_country":"China","is_uk_company":"false","uk_postcode":null} []
[2026-03-25 17:41:30] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - INSERT parameters {"business_code":null,"reg_number":"91440300MA5DNEJ611","company_name":"441"} []
[2026-03-25 17:41:30] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Target database insertion successful [] []
[2026-03-25 17:41:30] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Updating source email information... [] []
[2026-03-25 17:41:30] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Source email info updated successfully {"email":"registrationvat3749@usaeu.com"} []
[2026-03-25 17:41:30] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Updating status to 2 [] []
[2026-03-25 17:41:30] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Status update successful [] []
[2026-03-25 17:41:30] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - All steps completed successfully, status set to 2 (processing) [] []
[2026-03-25 17:41:30] vat-sync.INFO: Sync cycle 1 completed successfully - VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f [] []
[2026-03-25 17:41:35] vat-sync.INFO: Starting sync cycle 2 [] []
[2026-03-25 17:41:35] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:41:35] vat-sync.INFO: No pending records found [] []
[2026-03-25 17:41:35] vat-sync.INFO: Sync cycle 2 completed successfully - No pending records found [] []
[2026-03-25 17:44:57] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":"infinite","mode":"continuous"} []
[2026-03-25 17:44:57] vat-sync.INFO: Removed stale lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock [] []
[2026-03-25 17:44:57] vat-sync.INFO: Created sync lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock with PID: 20896 [] []
[2026-03-25 17:44:57] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2026-03-25 17:44:57] vat-sync.INFO: Connecting to source database... [] []
[2026-03-25 17:44:58] vat-sync.INFO: Source database connected successfully [] []
[2026-03-25 17:44:58] vat-sync.INFO: Connecting to target database... [] []
[2026-03-25 17:44:58] vat-sync.INFO: Target database connected successfully [] []
[2026-03-25 17:44:58] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2026-03-25 17:44:58] vat-sync.INFO: DataSyncService initialized successfully [] []
[2026-03-25 17:44:58] vat-sync.INFO: Starting sync cycle 1 [] []
[2026-03-25 17:44:58] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:44:58] vat-sync.INFO: Fetched record data {"vb_ID":"48a13229-959d-416b-883c-66ceeedab77f","VATTaxNumberID":"NULL","NameEng":"441","BusinessCode":"NULL"} []
[2026-03-25 17:44:58] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Creating registration email... [] []
[2026-03-25 17:44:58] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat3750@usaeu.com","post_data":{"email":"registrationvat3750@usaeu.com","password":"meiou@2025","active":1}} []
[2026-03-25 17:44:59] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat3750@usaeu.com","active":1,"uname":"registrationvat3750","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat3750.20260325"}}} []
[2026-03-25 17:44:59] vat-sync.INFO: Email created successfully {"email":"registrationvat3750@usaeu.com","sequence":3750} []
[2026-03-25 17:44:59] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Email created successfully {"email":"registrationvat3750@usaeu.com","sequence":3750} []
[2026-03-25 17:44:59] vat-sync.INFO: Found existing record in target database {"source_record_id":"48a13229-959d-416b-883c-66ceeedab77f","target_id":1545,"current_registration_status":"1"} []
[2026-03-25 17:44:59] vat-sync.INFO: Cleaned up sync lock file on exit: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock [] []
[2026-03-25 17:44:59] vat-sync.INFO: Cleaned up heartbeat file on exit: E:\ou\meiou-app\uk_vat_reg\bin/../heartbeat_test.txt [] []
[2026-03-25 17:46:13] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":"infinite","mode":"continuous"} []
[2026-03-25 17:46:13] vat-sync.INFO: Created sync lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock with PID: 26336 [] []
[2026-03-25 17:46:13] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2026-03-25 17:46:13] vat-sync.INFO: Connecting to source database... [] []
[2026-03-25 17:46:13] vat-sync.INFO: Source database connected successfully [] []
[2026-03-25 17:46:13] vat-sync.INFO: Connecting to target database... [] []
[2026-03-25 17:46:13] vat-sync.INFO: Target database connected successfully [] []
[2026-03-25 17:46:13] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2026-03-25 17:46:13] vat-sync.INFO: DataSyncService initialized successfully [] []
[2026-03-25 17:46:13] vat-sync.INFO: Starting sync cycle 1 [] []
[2026-03-25 17:46:13] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:46:13] vat-sync.INFO: Fetched record data {"vb_ID":"48a13229-959d-416b-883c-66ceeedab77f","VATTaxNumberID":"NULL","NameEng":"441","BusinessCode":"NULL"} []
[2026-03-25 17:46:13] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Creating registration email... [] []
[2026-03-25 17:46:13] vat-sync.ERROR: Failed to get next sequence: SQLSTATE[42S02]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid object name 'email_sequence_manager'. [] []
[2026-03-25 17:46:13] vat-sync.ERROR: Failed to get next email sequence [] []
[2026-03-25 17:46:13] vat-sync.ERROR: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Failed to create registration email [] []
[2026-03-25 17:46:13] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Updating status to -1 with error: Failed to create registration email [] []
[2026-03-25 17:46:13] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Status update successful [] []
[2026-03-25 17:46:13] vat-sync.WARNING: Sync cycle 1 completed with issues - VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Failed to create registration email [] []
[2026-03-25 17:46:18] vat-sync.INFO: Starting sync cycle 2 [] []
[2026-03-25 17:46:18] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:46:18] vat-sync.INFO: Fetched record data {"vb_ID":"48a13229-959d-416b-883c-66ceeedab77f","VATTaxNumberID":"NULL","NameEng":"441","BusinessCode":"NULL"} []
[2026-03-25 17:46:18] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Creating registration email... [] []
[2026-03-25 17:46:18] vat-sync.ERROR: Failed to get next sequence: SQLSTATE[42S02]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid object name 'email_sequence_manager'. [] []
[2026-03-25 17:46:18] vat-sync.ERROR: Failed to get next email sequence [] []
[2026-03-25 17:46:18] vat-sync.ERROR: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Failed to create registration email [] []
[2026-03-25 17:46:18] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Updating status to -1 with error: Failed to create registration email [] []
[2026-03-25 17:46:18] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Status update successful [] []
[2026-03-25 17:46:18] vat-sync.WARNING: Sync cycle 2 completed with issues - VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Failed to create registration email [] []
[2026-03-25 17:46:23] vat-sync.INFO: Starting sync cycle 3 [] []
[2026-03-25 17:46:35] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:46:35] vat-sync.INFO: Fetched record data {"vb_ID":"48a13229-959d-416b-883c-66ceeedab77f","VATTaxNumberID":"NULL","NameEng":"441","BusinessCode":"NULL"} []
[2026-03-25 17:46:35] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Creating registration email... [] []
[2026-03-25 17:46:35] vat-sync.ERROR: Failed to get next sequence: SQLSTATE[42S02]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid object name 'email_sequence_manager'. [] []
[2026-03-25 17:46:35] vat-sync.ERROR: Failed to get next email sequence [] []
[2026-03-25 17:46:35] vat-sync.ERROR: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Failed to create registration email [] []
[2026-03-25 17:46:35] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Updating status to -1 with error: Failed to create registration email [] []
[2026-03-25 17:46:35] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Status update successful [] []
[2026-03-25 17:46:35] vat-sync.WARNING: Sync cycle 3 completed with issues - VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Failed to create registration email [] []
[2026-03-25 17:48:48] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":"infinite","mode":"continuous"} []
[2026-03-25 17:48:48] vat-sync.INFO: Removed stale lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock [] []
[2026-03-25 17:48:48] vat-sync.INFO: Created sync lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock with PID: 24948 [] []
[2026-03-25 17:48:48] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2026-03-25 17:48:48] vat-sync.INFO: Connecting to source database... [] []
[2026-03-25 17:48:48] vat-sync.INFO: Source database connected successfully [] []
[2026-03-25 17:48:48] vat-sync.INFO: Connecting to target database... [] []
[2026-03-25 17:48:48] vat-sync.INFO: Target database connected successfully [] []
[2026-03-25 17:48:48] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2026-03-25 17:48:48] vat-sync.INFO: DataSyncService initialized successfully [] []
[2026-03-25 17:48:48] vat-sync.INFO: Starting sync cycle 1 [] []
[2026-03-25 17:48:48] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:48:48] vat-sync.INFO: Fetched record data {"vb_ID":"48a13229-959d-416b-883c-66ceeedab77f","VATTaxNumberID":"NULL","NameEng":"441","BusinessCode":"NULL"} []
[2026-03-25 17:48:48] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Creating registration email... [] []
[2026-03-25 17:48:48] vat-sync.ERROR: Failed to get next sequence: SQLSTATE[42S02]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid object name 'email_sequence_manager'. [] []
[2026-03-25 17:48:48] vat-sync.ERROR: Failed to get next email sequence [] []
[2026-03-25 17:48:48] vat-sync.ERROR: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Failed to create registration email [] []
[2026-03-25 17:48:48] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Updating status to -1 with error: Failed to create registration email [] []
[2026-03-25 17:48:48] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Status update successful [] []
[2026-03-25 17:48:48] vat-sync.WARNING: Sync cycle 1 completed with issues - VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Failed to create registration email [] []
[2026-03-25 17:48:53] vat-sync.INFO: Starting sync cycle 2 [] []
[2026-03-25 17:48:53] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:48:53] vat-sync.INFO: Fetched record data {"vb_ID":"48a13229-959d-416b-883c-66ceeedab77f","VATTaxNumberID":"NULL","NameEng":"441","BusinessCode":"NULL"} []
[2026-03-25 17:48:53] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Creating registration email... [] []
[2026-03-25 17:48:53] vat-sync.ERROR: Failed to get next sequence: SQLSTATE[42S02]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Invalid object name 'email_sequence_manager'. [] []
[2026-03-25 17:48:54] vat-sync.ERROR: Failed to get next email sequence [] []
[2026-03-25 17:48:54] vat-sync.ERROR: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Failed to create registration email [] []
[2026-03-25 17:48:54] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Updating status to -1 with error: Failed to create registration email [] []
[2026-03-25 17:48:54] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Status update successful [] []
[2026-03-25 17:48:54] vat-sync.WARNING: Sync cycle 2 completed with issues - VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Failed to create registration email [] []
[2026-03-25 17:55:45] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":"infinite","mode":"continuous"} []
[2026-03-25 17:55:45] vat-sync.INFO: Removed stale lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock [] []
[2026-03-25 17:55:45] vat-sync.INFO: Created sync lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock with PID: 26332 [] []
[2026-03-25 17:55:45] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2026-03-25 17:55:45] vat-sync.INFO: Connecting to source database... [] []
[2026-03-25 17:55:45] vat-sync.INFO: Source database connected successfully [] []
[2026-03-25 17:55:45] vat-sync.INFO: Connecting to target database... [] []
[2026-03-25 17:55:45] vat-sync.INFO: Target database connected successfully [] []
[2026-03-25 17:55:45] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2026-03-25 17:55:45] vat-sync.INFO: DataSyncService initialized successfully [] []
[2026-03-25 17:55:45] vat-sync.INFO: Starting sync cycle 1 [] []
[2026-03-25 17:55:45] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:55:45] vat-sync.INFO: Fetched record data {"vb_ID":"48a13229-959d-416b-883c-66ceeedab77f","VATTaxNumberID":"NULL","NameEng":"441","BusinessCode":"NULL"} []
[2026-03-25 17:55:45] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Creating registration email... [] []
[2026-03-25 17:55:45] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat3748@usaeu.com","post_data":{"email":"registrationvat3748@usaeu.com","password":"meiou@2025","active":1}} []
[2026-03-25 17:55:47] vat-sync.INFO: Email API response {"result":{"status":0,"msg":"Email already exists","url":"","data":null}} []
[2026-03-25 17:55:47] vat-sync.ERROR: Email creation failed {"email":"registrationvat3748@usaeu.com","sequence":3748,"api_response":{"status":0,"msg":"Email already exists","url":"","data":null}} []
[2026-03-25 17:55:47] vat-sync.INFO: Email already exists, trying next sequence {"email":"registrationvat3748@usaeu.com"} []
[2026-03-25 17:55:47] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat3749@usaeu.com","post_data":{"email":"registrationvat3749@usaeu.com","password":"meiou@2025","active":1}} []
[2026-03-25 17:55:49] vat-sync.INFO: Email API response {"result":{"status":0,"msg":"Email already exists","url":"","data":null}} []
[2026-03-25 17:55:49] vat-sync.ERROR: Email creation failed {"email":"registrationvat3749@usaeu.com","sequence":3749,"api_response":{"status":0,"msg":"Email already exists","url":"","data":null}} []
[2026-03-25 17:55:49] vat-sync.INFO: Email already exists, trying next sequence {"email":"registrationvat3749@usaeu.com"} []
[2026-03-25 17:55:49] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat3750@usaeu.com","post_data":{"email":"registrationvat3750@usaeu.com","password":"meiou@2025","active":1}} []
[2026-03-25 17:55:52] vat-sync.ERROR: Failed to call email creation API [] []
[2026-03-25 17:55:52] vat-sync.ERROR: Email creation failed {"email":"registrationvat3750@usaeu.com","sequence":3750,"api_response":null} []
[2026-03-25 17:55:52] vat-sync.ERROR: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Failed to create registration email [] []
[2026-03-25 17:55:52] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Updating status to -1 with error: Failed to create registration email [] []
[2026-03-25 17:55:52] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Status update successful [] []
[2026-03-25 17:55:52] vat-sync.WARNING: Sync cycle 1 completed with issues - VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Failed to create registration email [] []
[2026-03-25 17:55:52] vat-sync.INFO: Cleaned up sync lock file on exit: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock [] []
[2026-03-25 17:55:52] vat-sync.INFO: Cleaned up heartbeat file on exit: E:\ou\meiou-app\uk_vat_reg\bin/../heartbeat_test.txt [] []
[2026-03-25 17:56:40] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":"infinite","mode":"continuous"} []
[2026-03-25 17:56:40] vat-sync.INFO: Created sync lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock with PID: 4288 [] []
[2026-03-25 17:56:40] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2026-03-25 17:56:40] vat-sync.INFO: Connecting to source database... [] []
[2026-03-25 17:56:40] vat-sync.INFO: Source database connected successfully [] []
[2026-03-25 17:56:40] vat-sync.INFO: Connecting to target database... [] []
[2026-03-25 17:56:40] vat-sync.INFO: Target database connected successfully [] []
[2026-03-25 17:56:40] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2026-03-25 17:56:40] vat-sync.INFO: DataSyncService initialized successfully [] []
[2026-03-25 17:56:40] vat-sync.INFO: Starting sync cycle 1 [] []
[2026-03-25 17:56:40] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 17:56:40] vat-sync.INFO: Fetched record data {"vb_ID":"48a13229-959d-416b-883c-66ceeedab77f","VATTaxNumberID":"NULL","NameEng":"441","BusinessCode":"NULL"} []
[2026-03-25 17:56:40] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Creating registration email... [] []
[2026-03-25 17:56:40] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat3751@usaeu.com","post_data":{"email":"registrationvat3751@usaeu.com","password":"meiou@2025","active":1}} []
[2026-03-25 17:56:48] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat3751@usaeu.com","active":1,"uname":"registrationvat3751","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat3751.20260325"}}} []
[2026-03-25 17:56:48] vat-sync.INFO: Email created successfully {"email":"registrationvat3751@usaeu.com","sequence":3751} []
[2026-03-25 17:56:48] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Email created successfully {"email":"registrationvat3751@usaeu.com","sequence":3751} []
[2026-03-25 17:56:48] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Inserting new record into target database... [] []
[2026-03-25 17:56:48] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - BusinessCode value for INSERT: NULL [] []
[2026-03-25 17:56: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"} []
[2026-03-25 17:56:48] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - UK company check {"original_country":"中国","english_country":"China","is_uk_company":"false","uk_postcode":null} []
[2026-03-25 17:56:48] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - INSERT parameters {"business_code":null,"reg_number":"91440300MA5DNEJ611","company_name":"441"} []
[2026-03-25 17:56:48] vat-sync.ERROR: Failed to insert into target database: SQLSTATE[23000]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Cannot insert the value NULL into column 'id', table 'rpa_test.dbo.uk_vat_register'; column does not allow nulls. INSERT fails. [] []
[2026-03-25 17:56:48] vat-sync.ERROR: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Failed to insert into target database [] []
[2026-03-25 17:56:48] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Updating status to -1 with error: Failed to insert into target database [] []
[2026-03-25 17:56:48] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Status update successful [] []
[2026-03-25 17:56:48] vat-sync.WARNING: Sync cycle 1 completed with issues - VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Failed to insert into target database [] []
[2026-03-25 17:56:48] vat-sync.INFO: Cleaned up sync lock file on exit: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock [] []
[2026-03-25 17:56:48] vat-sync.INFO: Cleaned up heartbeat file on exit: E:\ou\meiou-app\uk_vat_reg\bin/../heartbeat_test.txt [] []
[2026-03-25 18:03:09] vat-sync.INFO: VAT Data Sync Service started {"environment":"test","sync_interval":5,"max_cycles":"infinite","mode":"continuous"} []
[2026-03-25 18:03:09] vat-sync.INFO: Created sync lock file: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock with PID: 1892 [] []
[2026-03-25 18:03:09] vat-sync.INFO: Initializing DataSyncService {"environment":"test"} []
[2026-03-25 18:03:09] vat-sync.INFO: Connecting to source database... [] []
[2026-03-25 18:03:09] vat-sync.INFO: Source database connected successfully [] []
[2026-03-25 18:03:09] vat-sync.INFO: Connecting to target database... [] []
[2026-03-25 18:03:09] vat-sync.INFO: Target database connected successfully [] []
[2026-03-25 18:03:09] vat-sync.INFO: DataSyncService initialization completed successfully [] []
[2026-03-25 18:03:09] vat-sync.INFO: DataSyncService initialized successfully [] []
[2026-03-25 18:03:09] vat-sync.INFO: Starting sync cycle 1 [] []
[2026-03-25 18:03:09] vat-sync.INFO: Starting data sync process [] []
[2026-03-25 18:03:09] vat-sync.INFO: Fetched record data {"vb_ID":"48a13229-959d-416b-883c-66ceeedab77f","VATTaxNumberID":"NULL","NameEng":"441","BusinessCode":"NULL"} []
[2026-03-25 18:03:09] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Creating registration email... [] []
[2026-03-25 18:03:09] vat-sync.INFO: Calling email creation API {"url":"http://mail.usaeu.com:8010/Api/User/create?_key=pLoTJWMWsuHaOJIm","email":"registrationvat3752@usaeu.com","post_data":{"email":"registrationvat3752@usaeu.com","password":"meiou@2025","active":1}} []
[2026-03-25 18:03:10] vat-sync.INFO: Email API response {"result":{"status":1,"msg":"Email created successfully","url":"","data":{"email":"registrationvat3752@usaeu.com","active":1,"uname":"registrationvat3752","tel":"","maildir":"/ewomail/mail/vmail/usaeu.com/r/e/g/registrationvat3752.20260325"}}} []
[2026-03-25 18:03:10] vat-sync.INFO: Email created successfully {"email":"registrationvat3752@usaeu.com","sequence":3752} []
[2026-03-25 18:03:10] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Email created successfully {"email":"registrationvat3752@usaeu.com","sequence":3752} []
[2026-03-25 18:03:11] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Inserting new record into target database... [] []
[2026-03-25 18:03:11] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - BusinessCode value for INSERT: NULL [] []
[2026-03-25 18:03: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"} []
[2026-03-25 18:03:11] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - UK company check {"original_country":"中国","english_country":"China","is_uk_company":"false","uk_postcode":null} []
[2026-03-25 18:03:11] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - INSERT parameters {"business_code":null,"reg_number":"91440300MA5DNEJ611","company_name":"441"} []
[2026-03-25 18:03:11] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Target database insertion successful [] []
[2026-03-25 18:03:11] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Updating source email information... [] []
[2026-03-25 18:03:11] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - Source email info updated successfully {"email":"registrationvat3752@usaeu.com"} []
[2026-03-25 18:03:11] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Updating status to 2 [] []
[2026-03-25 18:03:11] vat-sync.INFO: VATRegInfo.ID: 48a13229-959d-416b-883c-66ceeedab77f - Status update successful [] []
[2026-03-25 18:03:11] vat-sync.INFO: VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f - All steps completed successfully, status set to 2 (processing) [] []
[2026-03-25 18:03:11] vat-sync.INFO: Sync cycle 1 completed successfully - VATBusinessRecord.ID: 48a13229-959d-416b-883c-66ceeedab77f [] []
[2026-03-25 18:03:11] vat-sync.INFO: Cleaned up sync lock file on exit: E:\ou\meiou-app\uk_vat_reg\bin/../sync_test.lock [] []
[2026-03-25 18:03:11] vat-sync.INFO: Cleaned up heartbeat file on exit: E:\ou\meiou-app\uk_vat_reg\bin/../heartbeat_test.txt [] []