Console Audit Provisioning Drift Correlations Beds24 Providers: Schlage Providers: TTLock

Correlation Detail

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

Back to Debug Console View JSON
correlation_id: b5e8e7963bbc43ac99a1b9ad77adf8b4 fail window: 2026-02-05 10:29:25 .00 → 2026-02-05 10:29:31 .00
Console (filtered) Audit Provisioning

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:25 .00 Job #107 9 credential changed done attempts: 1
age_seconds: 190487
Raw + Copy
Job JSON 
{
  "attempt_count": 1,
  "correlation_id": "b5e8e7963bbc43ac99a1b9ad77adf8b4",
  "created_at": "2026-02-05T16:29:25Z",
  "debug_session_id": null,
  "derived": {
    "age_seconds": 190487.270308,
    "is_stuck_running": false
  },
  "job_type": "reconcile_user",
  "last_error": null,
  "next_run_at": null,
  "reason": "credential changed",
  "reconcile_job_id": 107,
  "status": "done",
  "updated_at": "2026-02-05T16:29:31Z",
  "user_id": 9
}

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

ACCESS_BROKER

ACCESS_BROKER:unknown
1 fail
2026-02-05 10:29:25 .00 · RECONCILE_ENQUEUED · ok
2026-02-05 10:29:25 .00 · RECONCILE_JOB_START · ok
2026-02-05 10:29:30 .00 · RECONCILE_ENQUEUE_FAILED · fail (sqlite3.OperationalError) database is locked [SQL: INSERT INTO reconcile_jobs (job_type,user_id,reason,status,attempt_count,next_run_at,last_error,rerun_requested,context_json,last_result_json,created_at,updated_at,correlation_id,debug_session_id,attempts,max_attempts) VALUES (?,?,?,?,?,?,?,?,?,?,?
2026-02-05 10:29:31 .00 · RECONCILE_JOB_DONE · ok
Raw logs JSON 
[
  {
    "action": "RECONCILE_ENQUEUED",
    "correlation_id": "b5e8e7963bbc43ac99a1b9ad77adf8b4",
    "created_at": "2026-02-05T16:29:25Z",
    "debug_session_id": null,
    "door_id": null,
    "door_name": null,
    "error_message": null,
    "external_id": null,
    "id": 1682,
    "lock_key": "ACCESS_BROKER:unknown",
    "ok": true,
    "provider_type": "ACCESS_BROKER",
    "reconcile_job_id": 107,
    "request_json": {
      "deduped": false,
      "reason": "credential changed",
      "source": "credential route",
      "user_id": 9
    },
    "response_json": {
      "job_id": 107
    }
  },
  {
    "action": "RECONCILE_JOB_START",
    "correlation_id": "b5e8e7963bbc43ac99a1b9ad77adf8b4",
    "created_at": "2026-02-05T16:29:25Z",
    "debug_session_id": null,
    "door_id": null,
    "door_name": null,
    "error_message": null,
    "external_id": null,
    "id": 1683,
    "lock_key": "ACCESS_BROKER:unknown",
    "ok": true,
    "provider_type": "ACCESS_BROKER",
    "reconcile_job_id": 107,
    "request_json": {
      "attempt_count": 1,
      "job_id": 107,
      "job_type": "reconcile_user",
      "reason": "credential changed",
      "user_id": 9
    },
    "response_json": null
  },
  {
    "action": "RECONCILE_ENQUEUE_FAILED",
    "correlation_id": "b5e8e7963bbc43ac99a1b9ad77adf8b4",
    "created_at": "2026-02-05T16:29:30Z",
    "debug_session_id": null,
    "door_id": null,
    "door_name": null,
    "error_message": "(sqlite3.OperationalError) database is locked\n[SQL: INSERT INTO reconcile_jobs (job_type,user_id,reason,status,attempt_count,next_run_at,last_error,rerun_requested,context_json,last_result_json,created_at,updated_at,correlation_id,debug_session_id,attempts,max_attempts) VALUES (?,?,?,?,?,?,?,?,?,?,?",
    "external_id": null,
    "id": 1704,
    "lock_key": "ACCESS_BROKER:unknown",
    "ok": false,
    "provider_type": "ACCESS_BROKER",
    "reconcile_job_id": null,
    "request_json": {
      "reason": "credential created",
      "source": "credential route",
      "user_id": 0
    },
    "response_json": null
  },
  {
    "action": "RECONCILE_JOB_DONE",
    "correlation_id": "b5e8e7963bbc43ac99a1b9ad77adf8b4",
    "created_at": "2026-02-05T16:29:31Z",
    "debug_session_id": null,
    "door_id": null,
    "door_name": null,
    "error_message": null,
    "external_id": null,
    "id": 1693,
    "lock_key": "ACCESS_BROKER:unknown",
    "ok": true,
    "provider_type": "ACCESS_BROKER",
    "reconcile_job_id": 107,
    "request_json": {
      "attempt_count": 1,
      "job_id": 107,
      "user_id": 9
    },
    "response_json": {
      "job_status": "done",
      "summary": {
        "adds_updates": 1,
        "desired": 1,
        "removes": 4
      }
    }
  }
]

TTLOCK

TTLOCK:unknown
door: ttlock
1 fail
2026-02-05 10:29:25 .00 · PIN_REVOKE · fail invalid literal for int() with base 10: 'a331ab1f-92a1-4e00-8eaa-f017086dd4f2'
2026-02-05 10:29:29 .00 · PIN_UPDATE · ok
Raw logs JSON 
[
  {
    "action": "PIN_REVOKE",
    "correlation_id": "b5e8e7963bbc43ac99a1b9ad77adf8b4",
    "created_at": "2026-02-05T16:29:25Z",
    "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": 1684,
    "lock_key": "TTLOCK:unknown",
    "ok": false,
    "provider_type": "TTLOCK",
    "reconcile_job_id": 107,
    "request_json": {
      "context": {
        "credential_id": 6,
        "source": "reconcile",
        "user_id": 9
      },
      "vendor_pin_id": "a331ab1f-92a1-4e00-8eaa-f017086dd4f2"
    },
    "response_json": null
  },
  {
    "action": "PIN_UPDATE",
    "correlation_id": "b5e8e7963bbc43ac99a1b9ad77adf8b4",
    "created_at": "2026-02-05T16:29:29Z",
    "debug_session_id": null,
    "door_id": 2,
    "door_name": "ttlock",
    "error_message": null,
    "external_id": null,
    "id": 1687,
    "lock_key": "TTLOCK:unknown",
    "ok": true,
    "provider_type": "TTLOCK",
    "reconcile_job_id": 107,
    "request_json": {
      "expires_at": "2027-02-05T16:29:25.477398",
      "name": "AB U9 C6",
      "pin_last4": "1111"
    },
    "response_json": {
      "adopted": false,
      "already_exists": false,
      "vendor_pin_id": 50957532,
      "warning": null
    }
  }
]
TTLOCK:28991110
door: ttlock
ok Dump
2026-02-05 10:29:29 .00 · PASSCODE_ADD · ok
2026-02-05 10:29:29 .00 · PIN_PROVISION · ok
2026-02-05 10:29:29 .00 · PASSCODE_LIST · ok
2026-02-05 10:29:29 .00 · PIN_DELETE · ok
Raw logs JSON 
[
  {
    "action": "PASSCODE_ADD",
    "correlation_id": "b5e8e7963bbc43ac99a1b9ad77adf8b4",
    "created_at": "2026-02-05T16:29:29Z",
    "debug_session_id": null,
    "door_id": 2,
    "door_name": "ttlock",
    "error_message": null,
    "external_id": "28991110",
    "id": 1685,
    "lock_key": "TTLOCK:28991110",
    "ok": true,
    "provider_type": "TTLOCK",
    "reconcile_job_id": 107,
    "request_json": {
      "base_host": "https://api.ttlock.com",
      "method": "POST",
      "path": "/v3/keyboardPwd/add",
      "payload": {
        "accessToken": "***",
        "addType": 2,
        "clientId": "6636adfbf3f9483d946082b74f20797c",
        "date": 1770308965484,
        "endDate": 1801844965477,
        "keyboardPwd": "***1111",
        "keyboardPwdName": "***",
        "lockId": 28991110,
        "startDate": 1770308905484
      },
      "url": "https://api.ttlock.com/v3/keyboardPwd/add"
    },
    "response_json": {
      "keyboardPwdId": 50957532
    }
  },
  {
    "action": "PIN_PROVISION",
    "correlation_id": "b5e8e7963bbc43ac99a1b9ad77adf8b4",
    "created_at": "2026-02-05T16:29:29Z",
    "debug_session_id": null,
    "door_id": 2,
    "door_name": "ttlock",
    "error_message": null,
    "external_id": "28991110",
    "id": 1686,
    "lock_key": "TTLOCK:28991110",
    "ok": true,
    "provider_type": "TTLOCK",
    "reconcile_job_id": 107,
    "request_json": {
      "context": {
        "credential_id": 6,
        "source": "reconcile",
        "user_id": 9
      },
      "expires_at": "2027-02-05T16:29:25.477398+00:00",
      "lock_id": 28991110,
      "name": "AB U9 C6",
      "pin_last4": "1111"
    },
    "response_json": {
      "already_exists": false,
      "result": {
        "keyboardPwdId": 50957532
      },
      "vendor_pin_id": 50957532
    }
  },
  {
    "action": "PASSCODE_LIST",
    "correlation_id": "b5e8e7963bbc43ac99a1b9ad77adf8b4",
    "created_at": "2026-02-05T16:29:29Z",
    "debug_session_id": null,
    "door_id": 2,
    "door_name": "ttlock",
    "error_message": null,
    "external_id": "28991110",
    "id": 1688,
    "lock_key": "TTLOCK:28991110",
    "ok": true,
    "provider_type": "TTLOCK",
    "reconcile_job_id": 107,
    "request_json": {
      "base_host": "https://api.ttlock.com",
      "method": "GET",
      "path": "/v3/lock/listKeyboardPwd",
      "payload": {
        "accessToken": "***",
        "clientId": "6636adfbf3f9483d946082b74f20797c",
        "date": 1770308969157,
        "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": "b5e8e7963bbc43ac99a1b9ad77adf8b4",
    "created_at": "2026-02-05T16:29:29Z",
    "debug_session_id": null,
    "door_id": 2,
    "door_name": "ttlock",
    "error_message": null,
    "external_id": "28991110",
    "id": 1689,
    "lock_key": "TTLOCK:28991110",
    "ok": true,
    "provider_type": "TTLOCK",
    "reconcile_job_id": 107,
    "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
    }
  }
]

SCHLAGE_HOME

SCHLAGE_HOME:93f26d40-0381-5277-bee3-23cf44cda5ac
door: schlage
ok Dump
2026-02-05 10:29:30 .00 · PIN_DELETE · ok
2026-02-05 10:29:30 .00 · PIN_DELETE · ok
2026-02-05 10:29:31 .00 · PIN_DELETE · ok
Raw logs JSON 
[
  {
    "action": "PIN_DELETE",
    "correlation_id": "b5e8e7963bbc43ac99a1b9ad77adf8b4",
    "created_at": "2026-02-05T16:29:30Z",
    "debug_session_id": null,
    "door_id": 1,
    "door_name": "schlage",
    "error_message": null,
    "external_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
    "id": 1690,
    "lock_key": "SCHLAGE_HOME:93f26d40-0381-5277-bee3-23cf44cda5ac",
    "ok": true,
    "provider_type": "SCHLAGE_HOME",
    "reconcile_job_id": 107,
    "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": "b5e8e7963bbc43ac99a1b9ad77adf8b4",
    "created_at": "2026-02-05T16:29:30Z",
    "debug_session_id": null,
    "door_id": 1,
    "door_name": "schlage",
    "error_message": null,
    "external_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
    "id": 1691,
    "lock_key": "SCHLAGE_HOME:93f26d40-0381-5277-bee3-23cf44cda5ac",
    "ok": true,
    "provider_type": "SCHLAGE_HOME",
    "reconcile_job_id": 107,
    "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": "b5e8e7963bbc43ac99a1b9ad77adf8b4",
    "created_at": "2026-02-05T16:29:31Z",
    "debug_session_id": null,
    "door_id": 1,
    "door_name": "schlage",
    "error_message": null,
    "external_id": "93f26d40-0381-5277-bee3-23cf44cda5ac",
    "id": 1692,
    "lock_key": "SCHLAGE_HOME:93f26d40-0381-5277-bee3-23cf44cda5ac",
    "ok": true,
    "provider_type": "SCHLAGE_HOME",
    "reconcile_job_id": 107,
    "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
    }
  }
]

4 — Timeline (All Integration Logs)

2026-02-05 10:29:25 .00 ok ACCESS_BROKER RECONCILE_ENQUEUED Job #107
Raw + Copy
Request JSON 
{
  "deduped": false,
  "reason": "credential changed",
  "source": "credential route",
  "user_id": 9
}
Response JSON 
{
  "job_id": 107
}
2026-02-05 10:29:25 .00 ok ACCESS_BROKER RECONCILE_JOB_START Job #107
Raw + Copy
Request JSON 
{
  "attempt_count": 1,
  "job_id": 107,
  "job_type": "reconcile_user",
  "reason": "credential changed",
  "user_id": 9
}
Response JSON 
null
2026-02-05 10:29:25 .00 fail TTLOCK PIN_REVOKE Job #107
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:29 .00 ok TTLOCK PASSCODE_ADD Job #107
Raw + Copy
Request JSON 
{
  "base_host": "https://api.ttlock.com",
  "method": "POST",
  "path": "/v3/keyboardPwd/add",
  "payload": {
    "accessToken": "***",
    "addType": 2,
    "clientId": "6636adfbf3f9483d946082b74f20797c",
    "date": 1770308965484,
    "endDate": 1801844965477,
    "keyboardPwd": "***1111",
    "keyboardPwdName": "***",
    "lockId": 28991110,
    "startDate": 1770308905484
  },
  "url": "https://api.ttlock.com/v3/keyboardPwd/add"
}
Response JSON 
{
  "keyboardPwdId": 50957532
}
2026-02-05 10:29:29 .00 ok TTLOCK PIN_PROVISION Job #107
Raw + Copy
Request JSON 
{
  "context": {
    "credential_id": 6,
    "source": "reconcile",
    "user_id": 9
  },
  "expires_at": "2027-02-05T16:29:25.477398+00:00",
  "lock_id": 28991110,
  "name": "AB U9 C6",
  "pin_last4": "1111"
}
Response JSON 
{
  "already_exists": false,
  "result": {
    "keyboardPwdId": 50957532
  },
  "vendor_pin_id": 50957532
}
2026-02-05 10:29:29 .00 ok TTLOCK PIN_UPDATE Job #107
Raw + Copy
Request JSON 
{
  "expires_at": "2027-02-05T16:29:25.477398",
  "name": "AB U9 C6",
  "pin_last4": "1111"
}
Response JSON 
{
  "adopted": false,
  "already_exists": false,
  "vendor_pin_id": 50957532,
  "warning": null
}
2026-02-05 10:29:29 .00 ok TTLOCK PASSCODE_LIST Job #107
Raw + Copy
Request JSON 
{
  "base_host": "https://api.ttlock.com",
  "method": "GET",
  "path": "/v3/lock/listKeyboardPwd",
  "payload": {
    "accessToken": "***",
    "clientId": "6636adfbf3f9483d946082b74f20797c",
    "date": 1770308969157,
    "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:29 .00 ok TTLOCK PIN_DELETE Job #107
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:30 .00 ok SCHLAGE_HOME PIN_DELETE Job #107
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:30 .00 ok SCHLAGE_HOME PIN_DELETE Job #107
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:30 .00 fail ACCESS_BROKER RECONCILE_ENQUEUE_FAILED
(sqlite3.OperationalError) database is locked [SQL: INSERT INTO reconcile_jobs (job_type,user_id,reason,status,attempt_count,next_run_at,last_error,rerun_requested,context_json,last_result_json,created_at,updated_at,correlation_id,debug_session_id,attempts,max_attempts) VALUES (?,?,?,?,?,?,?,?,?,?,?
Raw + Copy
Request JSON 
{
  "reason": "credential created",
  "source": "credential route",
  "user_id": 0
}
Response JSON 
null
2026-02-05 10:29:31 .00 ok SCHLAGE_HOME PIN_DELETE Job #107
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:31 .00 ok ACCESS_BROKER RECONCILE_JOB_DONE Job #107
Raw + Copy
Request JSON 
{
  "attempt_count": 1,
  "job_id": 107,
  "user_id": 9
}
Response JSON 
{
  "job_status": "done",
  "summary": {
    "adds_updates": 1,
    "desired": 1,
    "removes": 4
  }
}