========================================
Sync tbl_order Table
Source: MySQL (app_id = 5006, sync = 0)
Target: PostgreSQL (app_id = 1003)
Batch Size: 50 records
========================================

Step 1: Connecting to databases...
✓ Connected

Step 2: Reading PostgreSQL schema...
  ✓ Found 26 columns

Step 3: Loading customer ID mapping...
  ✓ Loaded 1247 customer mappings

Step 4: Fetching unsynced records from MySQL (LIMIT 50)...
  Found 5 unsynced records

Step 5: Checking existing records in PostgreSQL...
  Found 0 existing records

Step 6: Filtering missing records...
  Found 5 missing records to sync

Step 7: Syncing records...
--------------------------------------------------------------------------------
    ✗ Error processing record ID 4102: PostgreSQL insert error: ERROR:  null value in column "gateway_name" of relation "tbl_order" violates not-null constraint
DETAIL:  Failing row contains (1276681, 4102310205652310205, 1003, 34950, 0, null, null, 0.00, 0.00, 199.00, 0, 1, INR, 0, null, , 2026-01-27 10:01:21.31177, 2026-01-27 10:01:21.31177, 0, 0, 4102, 0, null, null, 0, null).
    ✗ Error processing record ID 4111: PostgreSQL insert error: ERROR:  null value in column "gateway_name" of relation "tbl_order" violates not-null constraint
DETAIL:  Failing row contains (1276682, 4111512445704512445, 1003, 35130, 0, null, null, 0.00, 0.00, 199.00, 0, 1, INR, 0, null, , 2026-01-27 10:01:21.312544, 2026-01-27 10:01:21.312544, 0, 0, 4111, 0, null, null, 0, null).
    ✗ Error processing record ID 4112: PostgreSQL insert error: ERROR:  null value in column "gateway_name" of relation "tbl_order" violates not-null constraint
DETAIL:  Failing row contains (1276683, 4112365258297365258, 1003, 35131, 0, null, null, 0.00, 0.00, 299.00, 0, 1, INR, 0, null, , 2026-01-27 10:01:21.312907, 2026-01-27 10:01:21.312907, 0, 0, 4112, 0, null, null, 0, null).
    ✗ Error processing record ID 4113: PostgreSQL insert error: ERROR:  null value in column "gateway_name" of relation "tbl_order" violates not-null constraint
DETAIL:  Failing row contains (1276684, 4113273511562273511, 1003, 35131, 0, null, null, 0.00, 0.00, 299.00, 0, 1, INR, 0, null, , 2026-01-27 10:01:21.313246, 2026-01-27 10:01:21.313246, 0, 0, 4113, 0, null, null, 0, null).
    ✗ Error processing record ID 4126: PostgreSQL insert error: ERROR:  null value in column "gateway_name" of relation "tbl_order" violates not-null constraint
DETAIL:  Failing row contains (1276685, 4126971264737971264, 1003, 34942, 0, null, null, 0.00, 0.00, 199.00, 0, 1, INR, 0, null, , 2026-01-27 10:01:21.313549, 2026-01-27 10:01:21.313549, 0, 0, 4126, 0, null, null, 0, null).
--------------------------------------------------------------------------------

==================================================
SYNC SUMMARY
==================================================
Records inserted:     0
Records skipped:       0
Sync updated:         0
Errors:               5
==================================================