{
  "derived": {
    "age_seconds": 163220.815133,
    "is_stuck_running": false,
    "last_log_at": "2026-02-05T22:20:39Z",
    "now_utc": "2026-02-07T19:41:00Z",
    "stuck_reason": null,
    "updated_at_utc": "2026-02-05T22:20:39Z"
  },
  "job": {
    "attempt_count": 2,
    "correlation_id": "2f3c9f24e62f427799bb42db30b33d7b",
    "created_at": "2026-02-05T22:20:30.750064+00:00",
    "debug_session_id": null,
    "job_type": "drift_enforce_lock_truth",
    "last_error": null,
    "next_run_at": null,
    "reason": "credential created",
    "reconcile_job_id": 144,
    "status": "done",
    "updated_at": "2026-02-05T22:20:39.401552+00:00",
    "user_id": 0
  },
  "logs": [
    {
      "action": "RECONCILE_ENQUEUED",
      "correlation_id": "2f3c9f24e62f427799bb42db30b33d7b",
      "created_at": "2026-02-05T22:20:30.754528",
      "debug_session_id": null,
      "error_message": null,
      "id": 2027,
      "ok": true,
      "provider_type": "ACCESS_BROKER",
      "reconcile_job_id": 144,
      "request_json": {
        "job_type": "drift_enforce_lock_truth",
        "reason": "credential created",
        "source": "credential route",
        "user_id": 0
      },
      "response_json": {
        "job_id": 144
      }
    },
    {
      "action": "DRIFT_ENFORCE_JOB_START",
      "correlation_id": "2f3c9f24e62f427799bb42db30b33d7b",
      "created_at": "2026-02-05T22:20:31.603245",
      "debug_session_id": null,
      "error_message": null,
      "id": 2029,
      "ok": true,
      "provider_type": "ACCESS_BROKER",
      "reconcile_job_id": 144,
      "request_json": {
        "attempt_count": 1,
        "job_id": 144,
        "job_type": "drift_enforce_lock_truth",
        "reason": "credential created",
        "user_id": 0
      },
      "response_json": null
    },
    {
      "action": "PASSCODE_LIST",
      "correlation_id": "2f3c9f24e62f427799bb42db30b33d7b",
      "created_at": "2026-02-05T22:20:32.355469",
      "debug_session_id": null,
      "error_message": null,
      "id": 2030,
      "ok": true,
      "provider_type": "TTLOCK",
      "reconcile_job_id": 144,
      "request_json": {
        "base_host": "https://api.ttlock.com",
        "method": "GET",
        "path": "/v3/lock/listKeyboardPwd",
        "payload": {
          "accessToken": "***",
          "clientId": "6636adfbf3f9483d946082b74f20797c",
          "date": 1770330031608,
          "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_ADD",
      "correlation_id": "2f3c9f24e62f427799bb42db30b33d7b",
      "created_at": "2026-02-05T22:20:33.108809",
      "debug_session_id": null,
      "error_message": "errcode=-3003 errmsg=The gateway is busy. Please try again later.",
      "id": 2031,
      "ok": false,
      "provider_type": "TTLOCK",
      "reconcile_job_id": 144,
      "request_json": {
        "base_host": "https://api.ttlock.com",
        "method": "POST",
        "path": "/v3/keyboardPwd/add",
        "payload": {
          "accessToken": "***",
          "addType": 2,
          "clientId": "6636adfbf3f9483d946082b74f20797c",
          "date": 1770330032369,
          "endDate": 1801866032365,
          "keyboardPwd": "***1111",
          "keyboardPwdName": "***",
          "lockId": 28991110,
          "startDate": 1770329972365
        },
        "url": "https://api.ttlock.com/v3/keyboardPwd/add"
      },
      "response_json": {
        "description": "\u7f51\u5173\u6b63\u5fd9\uff0c\u8bf7\u7a0d\u540e\u518d\u8bd5\u3002",
        "errcode": -3003,
        "errmsg": "The gateway is busy. Please try again later."
      }
    },
    {
      "action": "TTLOCK_PIN_CREATE",
      "correlation_id": "2f3c9f24e62f427799bb42db30b33d7b",
      "created_at": "2026-02-05T22:20:33.114608",
      "debug_session_id": null,
      "error_message": "TTLock error -3003: The gateway is busy. Please try again later.",
      "id": 2032,
      "ok": false,
      "provider_type": "TTLOCK",
      "reconcile_job_id": 144,
      "request_json": {
        "context": {
          "attempt_count": 1,
          "dedupe_key": "{\"door_id\":null,\"external_id\":\"28991110\",\"integration_device_id\":1,\"job_type\":\"drift_enforce_lock_truth\",\"provider_type\":\"TTLOCK\"}",
          "door_id": 2,
          "enforce_filters": {
            "external_id": "28991110",
            "integration_device_id": 1,
            "provider_type": "TTLOCK"
          },
          "external_id": "28991110",
          "integration_device_id": 1,
          "job_id": 144,
          "job_type": "drift_enforce_lock_truth",
          "provider_type": "TTLOCK",
          "reason": "credential created",
          "source": "reconcile_worker",
          "trigger_reason": "credential created"
        },
        "end_ts_ms": 1801866032365,
        "lock_vendor_id": "28991110",
        "name": "AB U9 C6",
        "pin_last4": "1111",
        "start_ts_ms": 1770329972365
      },
      "response_json": null
    },
    {
      "action": "DRIFT_ENFORCE_ADD_PIN",
      "correlation_id": "2f3c9f24e62f427799bb42db30b33d7b",
      "created_at": "2026-02-05T22:20:33.118167",
      "debug_session_id": null,
      "error_message": "TTLock error -3003: The gateway is busy. Please try again later.",
      "id": 2033,
      "ok": false,
      "provider_type": "ACCESS_BROKER",
      "reconcile_job_id": 144,
      "request_json": {
        "code_name": "AB U9 C6",
        "correlation_id": "job",
        "credential_id": 6,
        "device_external_id": "28991110",
        "door_id": 2,
        "grant_id": 26,
        "integration_device_id": 1,
        "provider_type": "TTLOCK",
        "user_id": 9
      },
      "response_json": null
    },
    {
      "action": "DRIFT_ENFORCE_JOB_FAILED",
      "correlation_id": "2f3c9f24e62f427799bb42db30b33d7b",
      "created_at": "2026-02-05T22:20:33.121625",
      "debug_session_id": null,
      "error_message": "drift_enforce_failed",
      "id": 2034,
      "ok": false,
      "provider_type": "ACCESS_BROKER",
      "reconcile_job_id": 144,
      "request_json": {
        "attempt_count": 1,
        "job_id": 144
      },
      "response_json": {
        "next_run_at": "2026-02-05T22:20:38.121625+00:00"
      }
    },
    {
      "action": "DRIFT_ENFORCE_JOB_START",
      "correlation_id": "2f3c9f24e62f427799bb42db30b33d7b",
      "created_at": "2026-02-05T22:20:38.559623",
      "debug_session_id": null,
      "error_message": null,
      "id": 2044,
      "ok": true,
      "provider_type": "ACCESS_BROKER",
      "reconcile_job_id": 144,
      "request_json": {
        "attempt_count": 2,
        "job_id": 144,
        "job_type": "drift_enforce_lock_truth",
        "reason": "credential created",
        "user_id": 0
      },
      "response_json": null
    },
    {
      "action": "PASSCODE_LIST",
      "correlation_id": "2f3c9f24e62f427799bb42db30b33d7b",
      "created_at": "2026-02-05T22:20:39.391546",
      "debug_session_id": null,
      "error_message": null,
      "id": 2045,
      "ok": true,
      "provider_type": "TTLOCK",
      "reconcile_job_id": 144,
      "request_json": {
        "base_host": "https://api.ttlock.com",
        "method": "GET",
        "path": "/v3/lock/listKeyboardPwd",
        "payload": {
          "accessToken": "***",
          "clientId": "6636adfbf3f9483d946082b74f20797c",
          "date": 1770330038569,
          "lockId": 28991110,
          "pageNo": 1,
          "pageSize": 200
        },
        "url": "https://api.ttlock.com/v3/lock/listKeyboardPwd"
      },
      "response_json": {
        "list": [
          {
            "endDate": 1801866030751,
            "isCustom": 1,
            "keyboardPwd": "***1111",
            "keyboardPwdId": 50957532,
            "keyboardPwdName": "***",
            "keyboardPwdType": 3,
            "keyboardPwdVersion": 4,
            "lockId": 28991110,
            "nickName": "keith",
            "receiverUsername": "",
            "sendDate": 1770330034000,
            "senderUsername": "keith@ac5.ca",
            "startDate": 1770329971618,
            "status": 1
          }
        ],
        "pageNo": 1,
        "pageSize": 200,
        "pages": 1,
        "total": 1
      }
    },
    {
      "action": "DRIFT_ENFORCE_JOB_DONE",
      "correlation_id": "2f3c9f24e62f427799bb42db30b33d7b",
      "created_at": "2026-02-05T22:20:39.401552",
      "debug_session_id": null,
      "error_message": null,
      "id": 2046,
      "ok": true,
      "provider_type": "ACCESS_BROKER",
      "reconcile_job_id": 144,
      "request_json": {
        "attempt_count": 2,
        "job_id": 144
      },
      "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": [
                {
                  "code_name": "AB U9 C6",
                  "provider_receipt_id": null,
                  "source": "lock",
                  "vendor_pin_id": "50957532"
                }
              ],
              "adds": [],
              "blocked_by_grace": [],
              "deletes": [],
              "door_id": 2,
              "expected": [
                {
                  "code_name": "AB U9 C6",
                  "credential_id": 6,
                  "grant_id": 26,
                  "provider_receipt_id": null,
                  "user_id": 9,
                  "vendor_pin_id": "50957532"
                }
              ],
              "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-05T22:20:38Z",
          "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-05T22:20:38Z",
        "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"
        }
      }
    }
  ]
}

(Derived from stored last_result_json; provider grouping uses execution logs.)

{
  "doors": [
    {
      "actual": [
        {
          "code_name": "AB U9 C6",
          "provider_receipt_id": null,
          "source": "lock",
          "vendor_pin_id": "50957532"
        }
      ],
      "adds": [],
      "blocked_by_grace": [],
      "deletes": [],
      "door_id": 2,
      "expected": [
        {
          "code_name": "AB U9 C6",
          "credential_id": 6,
          "grant_id": 26,
          "provider_receipt_id": null,
          "user_id": 9,
          "vendor_pin_id": "50957532"
        }
      ],
      "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-05T22:20:38Z",
  "grace_window_seconds": 3600,
  "mode": "ultra_strict",
  "summary": {
    "adds": 0,
    "blocked": 0,
    "deletes": 0,
    "doors": 1,
    "grace_bypassed_deletes": 0,
    "invalid_expected": 0
  }
}