Correlation Detail

Trace: App change → jobs → lock execution → outcome.

correlation_id: 0afdc06255f34e34970556f5a27798d5 fail window: 2026-02-05 10:29:20 .002026-02-05 10:29:34 .00

1 — What changed (AppAudit)

No AppAudit rows for this correlation.

2 — What the system decided (Reconcile Jobs)

Time Job User Reason Status Attempts / Error Details
2026-02-05 10:29:20 .00 Job #106 user door assignment changed done attempts: 1
age_seconds: 190595
Raw + Copy
Job JSON
{
  "attempt_count": 1,
  "correlation_id": "0afdc06255f34e34970556f5a27798d5",
  "created_at": "2026-02-05T16:29:20Z",
  "debug_session_id": null,
  "derived": {
    "age_seconds": 190594.535436,
    "is_stuck_running": false
  },
  "job_type": "drift_enforce_lock_truth",
  "last_error": null,
  "next_run_at": null,
  "reason": "user door assignment changed",
  "reconcile_job_id": 106,
  "status": "done",
  "updated_at": "2026-02-05T16:29:24Z",
  "user_id": 0
}
2026-02-05 10:29:20 .00 Job #105 9 doors changed done attempts: 2
age_seconds: 190584
Raw + Copy
Job JSON
{
  "attempt_count": 2,
  "correlation_id": "0afdc06255f34e34970556f5a27798d5",
  "created_at": "2026-02-05T16:29:20Z",
  "debug_session_id": null,
  "derived": {
    "age_seconds": 190584.288297,
    "is_stuck_running": false
  },
  "job_type": "reconcile_user",
  "last_error": null,
  "next_run_at": null,
  "reason": "doors changed",
  "reconcile_job_id": 105,
  "status": "done",
  "updated_at": "2026-02-05T16:29:34Z",
  "user_id": 9
}

3 — What was sent to locks (Provider → Lock)

ACCESS_BROKER

ACCESS_BROKER:unknown
1 fail
2026-02-05 10:29:20 .00 · RECONCILE_ENQUEUED · ok
2026-02-05 10:29:20 .00 · RECONCILE_JOB_START · ok
2026-02-05 10:29:20 .00 · RECONCILE_ENQUEUED · ok
2026-02-05 10:29:23 .00 · RECONCILE_JOB_FAILED · fail reconcile_failed
2026-02-05 10:29:23 .00 · DRIFT_ENFORCE_JOB_START · ok
2026-02-05 10:29:23 .00 · DRIFT_ENFORCE_JOB_START · ok
2026-02-05 10:29:24 .00 · DRIFT_ENFORCE_JOB_DONE · ok
2026-02-05 10:29:24 .00 · DRIFT_ENFORCE_JOB_DONE · ok
2026-02-05 10:29:31 .00 · RECONCILE_JOB_START · ok
2026-02-05 10:29:33 .00 · RECONCILE_JOB_DONE · ok
2026-02-05 10:29:33 .00 · RECONCILE_JOB_START · ok
2026-02-05 10:29:34 .00 · RECONCILE_JOB_DONE · ok
Raw logs JSON
[
  {
    "action": "RECONCILE_ENQUEUED",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:20Z",
    "debug_session_id": null,
    "door_id": null,
    "door_name": null,
    "error_message": null,
    "external_id": null,
    "id": 1665,
    "lock_key": "ACCESS_BROKER:unknown",
    "ok": true,
    "provider_type": "ACCESS_BROKER",
    "reconcile_job_id": 105,
    "request_json": {
      "deduped": false,
      "reason": "doors changed",
      "source": "user-door route",
      "user_id": 9
    },
    "response_json": {
      "job_id": 105
    }
  },
  {
    "action": "RECONCILE_JOB_START",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:20Z",
    "debug_session_id": null,
    "door_id": null,
    "door_name": null,
    "error_message": null,
    "external_id": null,
    "id": 1666,
    "lock_key": "ACCESS_BROKER:unknown",
    "ok": true,
    "provider_type": "ACCESS_BROKER",
    "reconcile_job_id": 105,
    "request_json": {
      "attempt_count": 1,
      "job_id": 105,
      "job_type": "reconcile_user",
      "reason": "doors changed",
      "user_id": 9
    },
    "response_json": null
  },
  {
    "action": "RECONCILE_ENQUEUED",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:20Z",
    "debug_session_id": null,
    "door_id": null,
    "door_name": null,
    "error_message": null,
    "external_id": null,
    "id": 1667,
    "lock_key": "ACCESS_BROKER:unknown",
    "ok": true,
    "provider_type": "ACCESS_BROKER",
    "reconcile_job_id": 106,
    "request_json": {
      "job_type": "drift_enforce_lock_truth",
      "reason": "user door assignment changed",
      "source": "user-door route",
      "user_id": 0
    },
    "response_json": {
      "job_id": 106
    }
  },
  {
    "action": "RECONCILE_JOB_FAILED",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:23Z",
    "debug_session_id": null,
    "door_id": null,
    "door_name": null,
    "error_message": "reconcile_failed",
    "external_id": null,
    "id": 1675,
    "lock_key": "ACCESS_BROKER:unknown",
    "ok": false,
    "provider_type": "ACCESS_BROKER",
    "reconcile_job_id": 105,
    "request_json": {
      "attempt_count": 1,
      "job_id": 105,
      "user_id": 9
    },
    "response_json": {
      "next_run_at": "2026-02-05T16:29:28.220091+00:00"
    }
  },
  {
    "action": "DRIFT_ENFORCE_JOB_START",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:23Z",
    "debug_session_id": null,
    "door_id": null,
    "door_name": null,
    "error_message": null,
    "external_id": null,
    "id": 1676,
    "lock_key": "ACCESS_BROKER:unknown",
    "ok": true,
    "provider_type": "ACCESS_BROKER",
    "reconcile_job_id": 106,
    "request_json": {
      "attempt_count": 1,
      "job_id": 106,
      "job_type": "drift_enforce_lock_truth",
      "reason": "user door assignment changed",
      "user_id": 0
    },
    "response_json": null
  },
  {
    "action": "DRIFT_ENFORCE_JOB_START",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:23Z",
    "debug_session_id": null,
    "door_id": null,
    "door_name": null,
    "error_message": null,
    "external_id": null,
    "id": 1677,
    "lock_key": "ACCESS_BROKER:unknown",
    "ok": true,
    "provider_type": "ACCESS_BROKER",
    "reconcile_job_id": 106,
    "request_json": {
      "attempt_count": 1,
      "job_id": 106,
      "job_type": "drift_enforce_lock_truth",
      "reason": "user door assignment changed",
      "user_id": 0
    },
    "response_json": null
  },
  {
    "action": "DRIFT_ENFORCE_JOB_DONE",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:24Z",
    "debug_session_id": null,
    "door_id": null,
    "door_name": null,
    "error_message": null,
    "external_id": null,
    "id": 1679,
    "lock_key": "ACCESS_BROKER:unknown",
    "ok": true,
    "provider_type": "ACCESS_BROKER",
    "reconcile_job_id": 106,
    "request_json": {
      "attempt_count": 1,
      "job_id": 106
    },
    "response_json": {
      "adds": {
        "attempted": 0,
        "failed": 0,
        "ok": 0
      },
      "analysis": {
        "adds": 0,
        "blocked": 0,
        "deletes": 0,
        "doors": 1,
        "grace_bypassed_deletes": 0,
        "invalid_expected": 0
      },
      "deletes": {
        "attempted": 0,
        "failed": 0,
        "ok": 0
      },
      "enforce_plan": {
        "doors": [
          {
            "actual": [],
            "adds": [],
            "blocked_by_grace": [],
            "deletes": [],
            "door_id": 2,
            "expected": [],
            "external_device_id": "28991110",
            "integration_device_id": 1,
            "invalid_expected": [],
            "provider_type": "TTLOCK",
            "summary": {
              "adds": 0,
              "blocked": 0,
              "deletes": 0,
              "grace_bypassed_deletes": 0,
              "invalid_expected": 0
            }
          }
        ],
        "filters": {
          "door_id": null,
          "integration_device_id": 1,
          "provider_type": "TTLOCK"
        },
        "generated_at": "2026-02-05T16:29:23Z",
        "grace_window_seconds": 3600,
        "mode": "ultra_strict",
        "summary": {
          "adds": 0,
          "blocked": 0,
          "deletes": 0,
          "doors": 1,
          "grace_bypassed_deletes": 0,
          "invalid_expected": 0
        }
      },
      "failures": [],
      "generated_at": "2026-02-05T16:29:23Z",
      "ok": true,
      "summary": {
        "adds_attempted": 0,
        "adds_failed": 0,
        "adds_succeeded": 0,
        "deletes_attempted": 0,
        "deletes_failed": 0,
        "deletes_succeeded": 0,
        "failures": []
      },
      "target": {
        "external_id": "28991110",
        "integration_device_id": 1,
        "provider_type": "TTLOCK"
      }
    }
  },
  {
    "action": "DRIFT_ENFORCE_JOB_DONE",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:24Z",
    "debug_session_id": null,
    "door_id": null,
    "door_name": null,
    "error_message": null,
    "external_id": null,
    "id": 1681,
    "lock_key": "ACCESS_BROKER:unknown",
    "ok": true,
    "provider_type": "ACCESS_BROKER",
    "reconcile_job_id": 106,
    "request_json": {
      "attempt_count": 1,
      "job_id": 106
    },
    "response_json": {
      "adds": {
        "attempted": 0,
        "failed": 0,
        "ok": 0
      },
      "analysis": {
        "adds": 0,
        "blocked": 0,
        "deletes": 0,
        "doors": 1
      },
      "deletes": {
        "attempted": 0,
        "failed": 0,
        "ok": 0
      },
      "enforce_plan": {
        "doors": [
          {
            "actual": [],
            "adds": [],
            "blocked_by_grace": [],
            "deletes": [],
            "door_id": 2,
            "expected": [],
            "external_device_id": "28991110",
            "integration_device_id": 1,
            "provider_type": "TTLOCK",
            "summary": {
              "adds": 0,
              "blocked": 0,
              "deletes": 0
            }
          }
        ],
        "filters": {
          "door_id": null,
          "integration_device_id": 1,
          "provider_type": "TTLOCK"
        },
        "generated_at": "2026-02-05T16:29:23Z",
        "grace_window_seconds": 3600,
        "mode": "ultra_strict",
        "summary": {
          "adds": 0,
          "blocked": 0,
          "deletes": 0,
          "doors": 1
        }
      },
      "failures": [],
      "generated_at": "2026-02-05T16:29:23Z",
      "ok": true,
      "target": {
        "external_id": "28991110",
        "integration_device_id": 1,
        "provider_type": "TTLOCK"
      }
    }
  },
  {
    "action": "RECONCILE_JOB_START",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:31Z",
    "debug_session_id": null,
    "door_id": null,
    "door_name": null,
    "error_message": null,
    "external_id": null,
    "id": 1694,
    "lock_key": "ACCESS_BROKER:unknown",
    "ok": true,
    "provider_type": "ACCESS_BROKER",
    "reconcile_job_id": 105,
    "request_json": {
      "attempt_count": 2,
      "job_id": 105,
      "job_type": "reconcile_user",
      "reason": "doors changed",
      "user_id": 9
    },
    "response_json": null
  },
  {
    "action": "RECONCILE_JOB_DONE",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:33Z",
    "debug_session_id": null,
    "door_id": null,
    "door_name": null,
    "error_message": null,
    "external_id": null,
    "id": 1700,
    "lock_key": "ACCESS_BROKER:unknown",
    "ok": true,
    "provider_type": "ACCESS_BROKER",
    "reconcile_job_id": 105,
    "request_json": {
      "attempt_count": 2,
      "job_id": 105,
      "user_id": 9
    },
    "response_json": {
      "job_status": "done",
      "summary": {
        "adds_updates": 0,
        "desired": 1,
        "removes": 4
      }
    }
  },
  {
    "action": "RECONCILE_JOB_START",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:33Z",
    "debug_session_id": null,
    "door_id": null,
    "door_name": null,
    "error_message": null,
    "external_id": null,
    "id": 1701,
    "lock_key": "ACCESS_BROKER:unknown",
    "ok": true,
    "provider_type": "ACCESS_BROKER",
    "reconcile_job_id": 105,
    "request_json": {
      "attempt_count": 2,
      "job_id": 105,
      "job_type": "reconcile_user",
      "reason": "doors changed",
      "user_id": 9
    },
    "response_json": null
  },
  {
    "action": "RECONCILE_JOB_DONE",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:34Z",
    "debug_session_id": null,
    "door_id": null,
    "door_name": null,
    "error_message": null,
    "external_id": null,
    "id": 1703,
    "lock_key": "ACCESS_BROKER:unknown",
    "ok": true,
    "provider_type": "ACCESS_BROKER",
    "reconcile_job_id": 105,
    "request_json": {
      "attempt_count": 2,
      "job_id": 105,
      "user_id": 9
    },
    "response_json": {
      "job_status": "done",
      "summary": {
        "adds_updates": 0,
        "desired": 1,
        "removes": 1
      }
    }
  }
]

TTLOCK

TTLOCK:28991110
door: ttlock
ok Dump
2026-02-05 10:29:21 .00 · PASSCODE_LIST · ok
2026-02-05 10:29:21 .00 · PIN_DELETE · ok
2026-02-05 10:29:24 .00 · PASSCODE_LIST · ok
2026-02-05 10:29:24 .00 · PASSCODE_LIST · ok
2026-02-05 10:29:32 .00 · PASSCODE_LIST · ok
2026-02-05 10:29:32 .00 · PIN_DELETE · ok
Raw logs JSON
[
  {
    "action": "PASSCODE_LIST",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:21Z",
    "debug_session_id": null,
    "door_id": 2,
    "door_name": "ttlock",
    "error_message": null,
    "external_id": "28991110",
    "id": 1668,
    "lock_key": "TTLOCK:28991110",
    "ok": true,
    "provider_type": "TTLOCK",
    "reconcile_job_id": 105,
    "request_json": {
      "base_host": "https://api.ttlock.com",
      "method": "GET",
      "path": "/v3/lock/listKeyboardPwd",
      "payload": {
        "accessToken": "***",
        "clientId": "6636adfbf3f9483d946082b74f20797c",
        "date": 1770308960418,
        "lockId": 28991110,
        "pageNo": 1,
        "pageSize": 200
      },
      "url": "https://api.ttlock.com/v3/lock/listKeyboardPwd"
    },
    "response_json": {
      "list": [],
      "pageNo": 1,
      "pageSize": 200,
      "pages": 0,
      "total": 0
    }
  },
  {
    "action": "PIN_DELETE",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:21Z",
    "debug_session_id": null,
    "door_id": 2,
    "door_name": "ttlock",
    "error_message": null,
    "external_id": "28991110",
    "id": 1669,
    "lock_key": "TTLOCK:28991110",
    "ok": true,
    "provider_type": "TTLOCK",
    "reconcile_job_id": 105,
    "request_json": {
      "lock_id": 28991110,
      "name": "AB U9 C1",
      "note": "listed_ok_but_not_found",
      "pin_last4": null,
      "resolution_attempted": true,
      "resolved_vendor_pin_id": null,
      "vendor_pin_id": null
    },
    "response_json": {
      "already": true,
      "ok": true
    }
  },
  {
    "action": "PASSCODE_LIST",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:24Z",
    "debug_session_id": null,
    "door_id": 2,
    "door_name": "ttlock",
    "error_message": null,
    "external_id": "28991110",
    "id": 1678,
    "lock_key": "TTLOCK:28991110",
    "ok": true,
    "provider_type": "TTLOCK",
    "reconcile_job_id": 106,
    "request_json": {
      "base_host": "https://api.ttlock.com",
      "method": "GET",
      "path": "/v3/lock/listKeyboardPwd",
      "payload": {
        "accessToken": "***",
        "clientId": "6636adfbf3f9483d946082b74f20797c",
        "date": 1770308963245,
        "lockId": 28991110,
        "pageNo": 1,
        "pageSize": 200
      },
      "url": "https://api.ttlock.com/v3/lock/listKeyboardPwd"
    },
    "response_json": {
      "list": [],
      "pageNo": 1,
      "pageSize": 200,
      "pages": 0,
      "total": 0
    }
  },
  {
    "action": "PASSCODE_LIST",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:24Z",
    "debug_session_id": null,
    "door_id": 2,
    "door_name": "ttlock",
    "error_message": null,
    "external_id": "28991110",
    "id": 1680,
    "lock_key": "TTLOCK:28991110",
    "ok": true,
    "provider_type": "TTLOCK",
    "reconcile_job_id": 106,
    "request_json": {
      "base_host": "https://api.ttlock.com",
      "method": "GET",
      "path": "/v3/lock/listKeyboardPwd",
      "payload": {
        "accessToken": "***",
        "clientId": "6636adfbf3f9483d946082b74f20797c",
        "date": 1770308963297,
        "lockId": 28991110,
        "pageNo": 1,
        "pageSize": 200
      },
      "url": "https://api.ttlock.com/v3/lock/listKeyboardPwd"
    },
    "response_json": {
      "list": [],
      "pageNo": 1,
      "pageSize": 200,
      "pages": 0,
      "total": 0
    }
  },
  {
    "action": "PASSCODE_LIST",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:32Z",
    "debug_session_id": null,
    "door_id": 2,
    "door_name": "ttlock",
    "error_message": null,
    "external_id": "28991110",
    "id": 1695,
    "lock_key": "TTLOCK:28991110",
    "ok": true,
    "provider_type": "TTLOCK",
    "reconcile_job_id": 105,
    "request_json": {
      "base_host": "https://api.ttlock.com",
      "method": "GET",
      "path": "/v3/lock/listKeyboardPwd",
      "payload": {
        "accessToken": "***",
        "clientId": "6636adfbf3f9483d946082b74f20797c",
        "date": 1770308971516,
        "lockId": 28991110,
        "pageNo": 1,
        "pageSize": 200
      },
      "url": "https://api.ttlock.com/v3/lock/listKeyboardPwd"
    },
    "response_json": {
      "list": [
        {
          "endDate": 1801844965477,
          "isCustom": 1,
          "keyboardPwd": "***1111",
          "keyboardPwdId": 50957532,
          "keyboardPwdName": "***",
          "keyboardPwdType": 3,
          "keyboardPwdVersion": 4,
          "lockId": 28991110,
          "nickName": "keith",
          "receiverUsername": "",
          "sendDate": 1770308969000,
          "senderUsername": "keith@ac5.ca",
          "startDate": 1770308905484,
          "status": 1
        }
      ],
      "pageNo": 1,
      "pageSize": 200,
      "pages": 1,
      "total": 1
    }
  },
  {
    "action": "PIN_DELETE",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:32Z",
    "debug_session_id": null,
    "door_id": 2,
    "door_name": "ttlock",
    "error_message": null,
    "external_id": "28991110",
    "id": 1696,
    "lock_key": "TTLOCK:28991110",
    "ok": true,
    "provider_type": "TTLOCK",
    "reconcile_job_id": 105,
    "request_json": {
      "lock_id": 28991110,
      "name": "AB U9 C1",
      "note": "listed_ok_but_not_found",
      "pin_last4": null,
      "resolution_attempted": true,
      "resolved_vendor_pin_id": null,
      "vendor_pin_id": null
    },
    "response_json": {
      "already": true,
      "ok": true
    }
  }
]
TTLOCK:unknown
door: ttlock
2 fail
2026-02-05 10:29:23 .00 · PIN_REVOKE · fail invalid literal for int() with base 10: 'a331ab1f-92a1-4e00-8eaa-f017086dd4f2'
2026-02-05 10:29:23 .00 · PIN_DELETE · fail invalid literal for int() with base 10: 'a331ab1f-92a1-4e00-8eaa-f017086dd4f2'
Raw logs JSON
[
  {
    "action": "PIN_REVOKE",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:23Z",
    "debug_session_id": null,
    "door_id": 2,
    "door_name": "ttlock",
    "error_message": "invalid literal for int() with base 10: \u0027a331ab1f-92a1-4e00-8eaa-f017086dd4f2\u0027",
    "external_id": null,
    "id": 1673,
    "lock_key": "TTLOCK:unknown",
    "ok": false,
    "provider_type": "TTLOCK",
    "reconcile_job_id": 105,
    "request_json": {
      "context": {
        "credential_id": 6,
        "source": "reconcile",
        "user_id": 9
      },
      "vendor_pin_id": "a331ab1f-92a1-4e00-8eaa-f017086dd4f2"
    },
    "response_json": null
  },
  {
    "action": "PIN_DELETE",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:23Z",
    "debug_session_id": null,
    "door_id": 2,
    "door_name": "ttlock",
    "error_message": "invalid literal for int() with base 10: \u0027a331ab1f-92a1-4e00-8eaa-f017086dd4f2\u0027",
    "external_id": null,
    "id": 1674,
    "lock_key": "TTLOCK:unknown",
    "ok": false,
    "provider_type": "TTLOCK",
    "reconcile_job_id": 105,
    "request_json": {
      "lock_id": null,
      "message": null,
      "pin_last4": null,
      "resolved_vendor_pin_id": null,
      "vendor_pin_id": "a331ab1f-92a1-4e00-8eaa-f017086dd4f2"
    },
    "response_json": null
  }
]

SCHLAGE_HOME

SCHLAGE_HOME:93f26d40-0381-5277-bee3-23cf44cda5ac
door: schlage
ok Dump
2026-02-05 10:29:22 .00 · PIN_DELETE · ok
2026-02-05 10:29:22 .00 · PIN_DELETE · ok
2026-02-05 10:29:23 .00 · PIN_DELETE · ok
2026-02-05 10:29:32 .00 · PIN_DELETE · ok
2026-02-05 10:29:33 .00 · PIN_DELETE · ok
2026-02-05 10:29:33 .00 · PIN_DELETE · ok
2026-02-05 10:29:34 .00 · PIN_DELETE · ok
Raw logs JSON
[
  {
    "action": "PIN_DELETE",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:22Z",
    "debug_session_id": null,
    "door_id": 1,
    "door_name": "schlage",
    "error_message": null,
    "external_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
    "id": 1670,
    "lock_key": "SCHLAGE_HOME:93f26d40-0381-5277-bee3-23cf44cda5ac",
    "ok": true,
    "provider_type": "SCHLAGE_HOME",
    "reconcile_job_id": 105,
    "request_json": {
      "device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
      "name": "AB U9 C1",
      "pin_last4": null,
      "receipt_id": null,
      "receipt_numeric_ignored": false
    },
    "response_json": {
      "already": true,
      "ok": true
    }
  },
  {
    "action": "PIN_DELETE",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:22Z",
    "debug_session_id": null,
    "door_id": 1,
    "door_name": "schlage",
    "error_message": null,
    "external_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
    "id": 1671,
    "lock_key": "SCHLAGE_HOME:93f26d40-0381-5277-bee3-23cf44cda5ac",
    "ok": true,
    "provider_type": "SCHLAGE_HOME",
    "reconcile_job_id": 105,
    "request_json": {
      "device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
      "name": "AB U9 C7",
      "pin_last4": null,
      "receipt_id": "50957532",
      "receipt_numeric_ignored": true
    },
    "response_json": {
      "already": true,
      "ok": true
    }
  },
  {
    "action": "PIN_DELETE",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:23Z",
    "debug_session_id": null,
    "door_id": 1,
    "door_name": "schlage",
    "error_message": null,
    "external_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
    "id": 1672,
    "lock_key": "SCHLAGE_HOME:93f26d40-0381-5277-bee3-23cf44cda5ac",
    "ok": true,
    "provider_type": "SCHLAGE_HOME",
    "reconcile_job_id": 105,
    "request_json": {
      "device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
      "name": "AB U9 C6",
      "pin_last4": null,
      "receipt_id": "50957532",
      "receipt_numeric_ignored": true
    },
    "response_json": {
      "already": true,
      "ok": true
    }
  },
  {
    "action": "PIN_DELETE",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:32Z",
    "debug_session_id": null,
    "door_id": 1,
    "door_name": "schlage",
    "error_message": null,
    "external_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
    "id": 1697,
    "lock_key": "SCHLAGE_HOME:93f26d40-0381-5277-bee3-23cf44cda5ac",
    "ok": true,
    "provider_type": "SCHLAGE_HOME",
    "reconcile_job_id": 105,
    "request_json": {
      "device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
      "name": "AB U9 C1",
      "pin_last4": null,
      "receipt_id": null,
      "receipt_numeric_ignored": false
    },
    "response_json": {
      "already": true,
      "ok": true
    }
  },
  {
    "action": "PIN_DELETE",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:33Z",
    "debug_session_id": null,
    "door_id": 1,
    "door_name": "schlage",
    "error_message": null,
    "external_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
    "id": 1698,
    "lock_key": "SCHLAGE_HOME:93f26d40-0381-5277-bee3-23cf44cda5ac",
    "ok": true,
    "provider_type": "SCHLAGE_HOME",
    "reconcile_job_id": 105,
    "request_json": {
      "device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
      "name": "AB U9 C7",
      "pin_last4": null,
      "receipt_id": null,
      "receipt_numeric_ignored": false
    },
    "response_json": {
      "already": true,
      "ok": true
    }
  },
  {
    "action": "PIN_DELETE",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:33Z",
    "debug_session_id": null,
    "door_id": 1,
    "door_name": "schlage",
    "error_message": null,
    "external_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
    "id": 1699,
    "lock_key": "SCHLAGE_HOME:93f26d40-0381-5277-bee3-23cf44cda5ac",
    "ok": true,
    "provider_type": "SCHLAGE_HOME",
    "reconcile_job_id": 105,
    "request_json": {
      "device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
      "name": "AB U9 C6",
      "pin_last4": "1111",
      "receipt_id": null,
      "receipt_numeric_ignored": false
    },
    "response_json": {
      "already": true,
      "ok": true
    }
  },
  {
    "action": "PIN_DELETE",
    "correlation_id": "0afdc06255f34e34970556f5a27798d5",
    "created_at": "2026-02-05T16:29:34Z",
    "debug_session_id": null,
    "door_id": 1,
    "door_name": "schlage",
    "error_message": null,
    "external_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
    "id": 1702,
    "lock_key": "SCHLAGE_HOME:93f26d40-0381-5277-bee3-23cf44cda5ac",
    "ok": true,
    "provider_type": "SCHLAGE_HOME",
    "reconcile_job_id": 105,
    "request_json": {
      "device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
      "pin_last4": "1111",
      "receipt_id": null
    },
    "response_json": {
      "already": true,
      "ok": true
    }
  }
]

4 — Timeline (All Integration Logs)

2026-02-05 10:29:20 .00 ok ACCESS_BROKER RECONCILE_ENQUEUED Job #105
Raw + Copy
Request JSON
{
  "deduped": false,
  "reason": "doors changed",
  "source": "user-door route",
  "user_id": 9
}
Response JSON
{
  "job_id": 105
}
2026-02-05 10:29:20 .00 ok ACCESS_BROKER RECONCILE_JOB_START Job #105
Raw + Copy
Request JSON
{
  "attempt_count": 1,
  "job_id": 105,
  "job_type": "reconcile_user",
  "reason": "doors changed",
  "user_id": 9
}
Response JSON
null
2026-02-05 10:29:20 .00 ok ACCESS_BROKER RECONCILE_ENQUEUED Job #106
Raw + Copy
Request JSON
{
  "job_type": "drift_enforce_lock_truth",
  "reason": "user door assignment changed",
  "source": "user-door route",
  "user_id": 0
}
Response JSON
{
  "job_id": 106
}
2026-02-05 10:29:21 .00 ok TTLOCK PASSCODE_LIST Job #105
Raw + Copy
Request JSON
{
  "base_host": "https://api.ttlock.com",
  "method": "GET",
  "path": "/v3/lock/listKeyboardPwd",
  "payload": {
    "accessToken": "***",
    "clientId": "6636adfbf3f9483d946082b74f20797c",
    "date": 1770308960418,
    "lockId": 28991110,
    "pageNo": 1,
    "pageSize": 200
  },
  "url": "https://api.ttlock.com/v3/lock/listKeyboardPwd"
}
Response JSON
{
  "list": [],
  "pageNo": 1,
  "pageSize": 200,
  "pages": 0,
  "total": 0
}
2026-02-05 10:29:21 .00 ok TTLOCK PIN_DELETE Job #105
Raw + Copy
Request JSON
{
  "lock_id": 28991110,
  "name": "AB U9 C1",
  "note": "listed_ok_but_not_found",
  "pin_last4": null,
  "resolution_attempted": true,
  "resolved_vendor_pin_id": null,
  "vendor_pin_id": null
}
Response JSON
{
  "already": true,
  "ok": true
}
2026-02-05 10:29:22 .00 ok SCHLAGE_HOME PIN_DELETE Job #105
Raw + Copy
Request JSON
{
  "device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
  "name": "AB U9 C1",
  "pin_last4": null,
  "receipt_id": null,
  "receipt_numeric_ignored": false
}
Response JSON
{
  "already": true,
  "ok": true
}
2026-02-05 10:29:22 .00 ok SCHLAGE_HOME PIN_DELETE Job #105
Raw + Copy
Request JSON
{
  "device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
  "name": "AB U9 C7",
  "pin_last4": null,
  "receipt_id": "50957532",
  "receipt_numeric_ignored": true
}
Response JSON
{
  "already": true,
  "ok": true
}
2026-02-05 10:29:23 .00 ok SCHLAGE_HOME PIN_DELETE Job #105
Raw + Copy
Request JSON
{
  "device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
  "name": "AB U9 C6",
  "pin_last4": null,
  "receipt_id": "50957532",
  "receipt_numeric_ignored": true
}
Response JSON
{
  "already": true,
  "ok": true
}
2026-02-05 10:29:23 .00 fail TTLOCK PIN_REVOKE Job #105
invalid literal for int() with base 10: 'a331ab1f-92a1-4e00-8eaa-f017086dd4f2'
Raw + Copy
Request JSON
{
  "context": {
    "credential_id": 6,
    "source": "reconcile",
    "user_id": 9
  },
  "vendor_pin_id": "a331ab1f-92a1-4e00-8eaa-f017086dd4f2"
}
Response JSON
null
2026-02-05 10:29:23 .00 fail TTLOCK PIN_DELETE Job #105
invalid literal for int() with base 10: 'a331ab1f-92a1-4e00-8eaa-f017086dd4f2'
Raw + Copy
Request JSON
{
  "lock_id": null,
  "message": null,
  "pin_last4": null,
  "resolved_vendor_pin_id": null,
  "vendor_pin_id": "a331ab1f-92a1-4e00-8eaa-f017086dd4f2"
}
Response JSON
null
2026-02-05 10:29:23 .00 fail ACCESS_BROKER RECONCILE_JOB_FAILED Job #105
reconcile_failed
Raw + Copy
Request JSON
{
  "attempt_count": 1,
  "job_id": 105,
  "user_id": 9
}
Response JSON
{
  "next_run_at": "2026-02-05T16:29:28.220091+00:00"
}
2026-02-05 10:29:23 .00 ok ACCESS_BROKER DRIFT_ENFORCE_JOB_START Job #106
Raw + Copy
Request JSON
{
  "attempt_count": 1,
  "job_id": 106,
  "job_type": "drift_enforce_lock_truth",
  "reason": "user door assignment changed",
  "user_id": 0
}
Response JSON
null
2026-02-05 10:29:23 .00 ok ACCESS_BROKER DRIFT_ENFORCE_JOB_START Job #106
Raw + Copy
Request JSON
{
  "attempt_count": 1,
  "job_id": 106,
  "job_type": "drift_enforce_lock_truth",
  "reason": "user door assignment changed",
  "user_id": 0
}
Response JSON
null
2026-02-05 10:29:24 .00 ok TTLOCK PASSCODE_LIST Job #106
Raw + Copy
Request JSON
{
  "base_host": "https://api.ttlock.com",
  "method": "GET",
  "path": "/v3/lock/listKeyboardPwd",
  "payload": {
    "accessToken": "***",
    "clientId": "6636adfbf3f9483d946082b74f20797c",
    "date": 1770308963245,
    "lockId": 28991110,
    "pageNo": 1,
    "pageSize": 200
  },
  "url": "https://api.ttlock.com/v3/lock/listKeyboardPwd"
}
Response JSON
{
  "list": [],
  "pageNo": 1,
  "pageSize": 200,
  "pages": 0,
  "total": 0
}
2026-02-05 10:29:24 .00 ok TTLOCK PASSCODE_LIST Job #106
Raw + Copy
Request JSON
{
  "base_host": "https://api.ttlock.com",
  "method": "GET",
  "path": "/v3/lock/listKeyboardPwd",
  "payload": {
    "accessToken": "***",
    "clientId": "6636adfbf3f9483d946082b74f20797c",
    "date": 1770308963297,
    "lockId": 28991110,
    "pageNo": 1,
    "pageSize": 200
  },
  "url": "https://api.ttlock.com/v3/lock/listKeyboardPwd"
}
Response JSON
{
  "list": [],
  "pageNo": 1,
  "pageSize": 200,
  "pages": 0,
  "total": 0
}
2026-02-05 10:29:24 .00 ok ACCESS_BROKER DRIFT_ENFORCE_JOB_DONE Job #106
Raw + Copy
Request JSON
{
  "attempt_count": 1,
  "job_id": 106
}
Response JSON
{
  "adds": {
    "attempted": 0,
    "failed": 0,
    "ok": 0
  },
  "analysis": {
    "adds": 0,
    "blocked": 0,
    "deletes": 0,
    "doors": 1,
    "grace_bypassed_deletes": 0,
    "invalid_expected": 0
  },
  "deletes": {
    "attempted": 0,
    "failed": 0,
    "ok": 0
  },
  "enforce_plan": {
    "doors": [
      {
        "actual": [],
        "adds": [],
        "blocked_by_grace": [],
        "deletes": [],
        "door_id": 2,
        "expected": [],
        "external_device_id": "28991110",
        "integration_device_id": 1,
        "invalid_expected": [],
        "provider_type": "TTLOCK",
        "summary": {
          "adds": 0,
          "blocked": 0,
          "deletes": 0,
          "grace_bypassed_deletes": 0,
          "invalid_expected": 0
        }
      }
    ],
    "filters": {
      "door_id": null,
      "integration_device_id": 1,
      "provider_type": "TTLOCK"
    },
    "generated_at": "2026-02-05T16:29:23Z",
    "grace_window_seconds": 3600,
    "mode": "ultra_strict",
    "summary": {
      "adds": 0,
      "blocked": 0,
      "deletes": 0,
      "doors": 1,
      "grace_bypassed_deletes": 0,
      "invalid_expected": 0
    }
  },
  "failures": [],
  "generated_at": "2026-02-05T16:29:23Z",
  "ok": true,
  "summary": {
    "adds_attempted": 0,
    "adds_failed": 0,
    "adds_succeeded": 0,
    "deletes_attempted": 0,
    "deletes_failed": 0,
    "deletes_succeeded": 0,
    "failures": []
  },
  "target": {
    "external_id": "28991110",
    "integration_device_id": 1,
    "provider_type": "TTLOCK"
  }
}
2026-02-05 10:29:24 .00 ok ACCESS_BROKER DRIFT_ENFORCE_JOB_DONE Job #106
Raw + Copy
Request JSON
{
  "attempt_count": 1,
  "job_id": 106
}
Response JSON
{
  "adds": {
    "attempted": 0,
    "failed": 0,
    "ok": 0
  },
  "analysis": {
    "adds": 0,
    "blocked": 0,
    "deletes": 0,
    "doors": 1
  },
  "deletes": {
    "attempted": 0,
    "failed": 0,
    "ok": 0
  },
  "enforce_plan": {
    "doors": [
      {
        "actual": [],
        "adds": [],
        "blocked_by_grace": [],
        "deletes": [],
        "door_id": 2,
        "expected": [],
        "external_device_id": "28991110",
        "integration_device_id": 1,
        "provider_type": "TTLOCK",
        "summary": {
          "adds": 0,
          "blocked": 0,
          "deletes": 0
        }
      }
    ],
    "filters": {
      "door_id": null,
      "integration_device_id": 1,
      "provider_type": "TTLOCK"
    },
    "generated_at": "2026-02-05T16:29:23Z",
    "grace_window_seconds": 3600,
    "mode": "ultra_strict",
    "summary": {
      "adds": 0,
      "blocked": 0,
      "deletes": 0,
      "doors": 1
    }
  },
  "failures": [],
  "generated_at": "2026-02-05T16:29:23Z",
  "ok": true,
  "target": {
    "external_id": "28991110",
    "integration_device_id": 1,
    "provider_type": "TTLOCK"
  }
}
2026-02-05 10:29:31 .00 ok ACCESS_BROKER RECONCILE_JOB_START Job #105
Raw + Copy
Request JSON
{
  "attempt_count": 2,
  "job_id": 105,
  "job_type": "reconcile_user",
  "reason": "doors changed",
  "user_id": 9
}
Response JSON
null
2026-02-05 10:29:32 .00 ok TTLOCK PASSCODE_LIST Job #105
Raw + Copy
Request JSON
{
  "base_host": "https://api.ttlock.com",
  "method": "GET",
  "path": "/v3/lock/listKeyboardPwd",
  "payload": {
    "accessToken": "***",
    "clientId": "6636adfbf3f9483d946082b74f20797c",
    "date": 1770308971516,
    "lockId": 28991110,
    "pageNo": 1,
    "pageSize": 200
  },
  "url": "https://api.ttlock.com/v3/lock/listKeyboardPwd"
}
Response JSON
{
  "list": [
    {
      "endDate": 1801844965477,
      "isCustom": 1,
      "keyboardPwd": "***1111",
      "keyboardPwdId": 50957532,
      "keyboardPwdName": "***",
      "keyboardPwdType": 3,
      "keyboardPwdVersion": 4,
      "lockId": 28991110,
      "nickName": "keith",
      "receiverUsername": "",
      "sendDate": 1770308969000,
      "senderUsername": "keith@ac5.ca",
      "startDate": 1770308905484,
      "status": 1
    }
  ],
  "pageNo": 1,
  "pageSize": 200,
  "pages": 1,
  "total": 1
}
2026-02-05 10:29:32 .00 ok TTLOCK PIN_DELETE Job #105
Raw + Copy
Request JSON
{
  "lock_id": 28991110,
  "name": "AB U9 C1",
  "note": "listed_ok_but_not_found",
  "pin_last4": null,
  "resolution_attempted": true,
  "resolved_vendor_pin_id": null,
  "vendor_pin_id": null
}
Response JSON
{
  "already": true,
  "ok": true
}
2026-02-05 10:29:32 .00 ok SCHLAGE_HOME PIN_DELETE Job #105
Raw + Copy
Request JSON
{
  "device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
  "name": "AB U9 C1",
  "pin_last4": null,
  "receipt_id": null,
  "receipt_numeric_ignored": false
}
Response JSON
{
  "already": true,
  "ok": true
}
2026-02-05 10:29:33 .00 ok SCHLAGE_HOME PIN_DELETE Job #105
Raw + Copy
Request JSON
{
  "device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
  "name": "AB U9 C7",
  "pin_last4": null,
  "receipt_id": null,
  "receipt_numeric_ignored": false
}
Response JSON
{
  "already": true,
  "ok": true
}
2026-02-05 10:29:33 .00 ok SCHLAGE_HOME PIN_DELETE Job #105
Raw + Copy
Request JSON
{
  "device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
  "name": "AB U9 C6",
  "pin_last4": "1111",
  "receipt_id": null,
  "receipt_numeric_ignored": false
}
Response JSON
{
  "already": true,
  "ok": true
}
2026-02-05 10:29:33 .00 ok ACCESS_BROKER RECONCILE_JOB_DONE Job #105
Raw + Copy
Request JSON
{
  "attempt_count": 2,
  "job_id": 105,
  "user_id": 9
}
Response JSON
{
  "job_status": "done",
  "summary": {
    "adds_updates": 0,
    "desired": 1,
    "removes": 4
  }
}
2026-02-05 10:29:33 .00 ok ACCESS_BROKER RECONCILE_JOB_START Job #105
Raw + Copy
Request JSON
{
  "attempt_count": 2,
  "job_id": 105,
  "job_type": "reconcile_user",
  "reason": "doors changed",
  "user_id": 9
}
Response JSON
null
2026-02-05 10:29:34 .00 ok SCHLAGE_HOME PIN_DELETE Job #105
Raw + Copy
Request JSON
{
  "device_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
  "pin_last4": "1111",
  "receipt_id": null
}
Response JSON
{
  "already": true,
  "ok": true
}
2026-02-05 10:29:34 .00 ok ACCESS_BROKER RECONCILE_JOB_DONE Job #105
Raw + Copy
Request JSON
{
  "attempt_count": 2,
  "job_id": 105,
  "user_id": 9
}
Response JSON
{
  "job_status": "done",
  "summary": {
    "adds_updates": 0,
    "desired": 1,
    "removes": 1
  }
}