자동화 실행 31e2bec7

Finance

자동화 실행 31e2bec7

실패

rule_id: 29de06e9-16ee-473c-bdd6-16b244946d10
trigger_kind: manual
started_at: 2026. 05. 05. 00:48
finished_at: 2026. 05. 05. 00:49
finance_import_run_ids: cc6fa3a5-6daa-4af7-9644-05771a8ca771, b0209a52-aaab-4296-9993-7082a1eafb04

결과 요약

84저장

103중복

0스킵

3실패

유형별 처리 결과

통장 내역실패 포함
84저장
1중복
0스킵
3실패
89 rows from Clobe (2025-10-01~2025-10-31)
import_run = cc6fa3a5-6daa-4af7-9644-05771a8ca771
카드 내역성공
0저장
102중복
0스킵
0실패
102 rows from Clobe (2025-10-01~2025-10-31)
import_run = b0209a52-aaab-4296-9993-7082a1eafb04

실패 / 중복 상세

import_run cc6fa3a5 · bank_transactions

실패 3건 보기

#9 insert "통장 내역을 저장하지 못했습니다: duplicate key value violates unique constraint "finance_bank_transactions_fingerprint_idx""

{
  "amount": 2900000,
  "direction": "outflow",
  "groupLabel": "계좌간 출금",
  "description": "주식회사이타즈",
  "accountLabel": "주계좌",
  "balanceAfter": 42339,
  "currencyCode": "KRW",
  "transactionAt": "2025-10-29T18:03:45+09:00",
  "evidenceStatus": "unmatched",
  "counterpartyName": "주식회사이타즈",
  "financeAccountId": null,
  "sourceFingerprint": "7db5b87ab5aad2f4e763a172287a26ce1d068b8c07221573e6033b672ee730f3"
}

#23 insert "통장 내역을 저장하지 못했습니다: duplicate key value violates unique constraint "finance_bank_transactions_fingerprint_idx""

{
  "amount": 6500000,
  "direction": "inflow",
  "groupLabel": "주주/임원/직원 차입금",
  "description": "대표이사차입",
  "accountLabel": "마이너스",
  "balanceAfter": -43250728,
  "currencyCode": "KRW",
  "transactionAt": "2025-10-27T16:14:51+09:00",
  "evidenceStatus": "unmatched",
  "counterpartyName": "대표이사차입",
  "financeAccountId": null,
  "sourceFingerprint": "dc49fdcb8558ea7ea0ea2cf20ab8859db75871841443619375a46ffb599b43b7"
}

#35 insert "통장 내역을 저장하지 못했습니다: duplicate key value violates unique constraint "finance_bank_transactions_fingerprint_idx""

{
  "amount": 1600000,
  "direction": "inflow",
  "groupLabel": "계좌간 입금",
  "description": "대체하나0904",
  "accountLabel": "경리계좌",
  "balanceAfter": 1600000,
  "currencyCode": "KRW",
  "transactionAt": "2025-10-23T16:42:33+09:00",
  "evidenceStatus": "unmatched",
  "counterpartyName": "대체하나0904",
  "financeAccountId": null,
  "sourceFingerprint": "42160c18afd5131450ee877d5cdfe88f69e47c746dfb4c129b9bdd57c190a826"
}

중복 1건 보기

#0 fp:95e07b7f272b

import_run b0209a52 · card_transactions

중복 102건 보기

#0 fp:40792829a5af
#1 fp:b151626a2571
#2 fp:91531b56cc28
#3 fp:b91c702b133b
#4 fp:c43744458a9a
#5 fp:bfeaff1ba3ec
#6 fp:3754acd89ec1
#7 fp:324477b5a3b6
#8 fp:bc5fc7e94c4b
#9 fp:93549558a064
#10 fp:3d84dd3e6a82
#11 fp:c91fbd823b53
#12 fp:f445d2a75382
#13 fp:347cb64b318e
#14 fp:7c09afa061cf
#15 fp:b60a5abbd6b6
#16 fp:a7610eb7e89e
#17 fp:9bbcb8544553
#18 fp:67f53a0d7836
#19 fp:faa256a627a7
#20 fp:631113639f37
#21 fp:73248bc1c681
#22 fp:49104810e126
#23 fp:d7c5d7e47411
#24 fp:fce0d09cc130
#25 fp:8967ffca4452
#26 fp:a46a0307a224
#27 fp:d6de3c5d4a44
#28 fp:064452111de9
#29 fp:8943ccfc4637
#30 fp:31949ddf92c8
#31 fp:293c3f751454
#32 fp:5e647cd840b9
#33 fp:885e928e0711
#34 fp:a7ef6e8d08e5
#35 fp:a0584457a9f8
#36 fp:c00eb377ec16
#37 fp:b17f91834b6e
#38 fp:ab9c93b5618d
#39 fp:6e334c25b120
#40 fp:51aa8fbc772d
#41 fp:6f4b96f3f2d3
#42 fp:2ecfab702243
#43 fp:50f99527b155
#44 fp:1f39e99fe757
#45 fp:41819650eeb2
#46 fp:a77d1437d9b2
#47 fp:93acc22cdda7
#48 fp:3b566bccec67
#49 fp:4350479f2306
#50 fp:0d39db03dfdf
#51 fp:a0621a0074d6
#52 fp:d60d563f389e
#53 fp:3bcd366679e4
#54 fp:37236d8e5e50
#55 fp:175478286ac5
#56 fp:7aef18d95d24
#57 fp:4002c4d07689
#58 fp:1fcf9619ba66
#59 fp:ef07684564e3
#60 fp:a411a0436153
#61 fp:39f59bc14b64
#62 fp:ed98241aefaa
#63 fp:00c012d05c7c
#64 fp:959d2bfd1c30
#65 fp:553bfcfc6dd6
#66 fp:c33991780cf8
#67 fp:7f481978ae5c
#68 fp:169246f081e8
#69 fp:95f4349e0e57
#70 fp:32e27e8dc700
#71 fp:4a168ac2a00d
#72 fp:37fcfdcb7c88
#73 fp:051b57e0e9e3
#74 fp:ee1f52460b53
#75 fp:e6313ea4f6e4
#76 fp:63562ea25bb5
#77 fp:b40bde3f134d
#78 fp:22367f5bb38e
#79 fp:75f4cb97c452
#80 fp:76e10f9ca607
#81 fp:e5bde079b94c
#82 fp:400fc05c007e
#83 fp:1875c42dfcfb
#84 fp:f279c24d63c0
#85 fp:21f293a6062e
#86 fp:459f0a615d0f
#87 fp:4a45e3a64f53
#88 fp:3a0920eccffa
#89 fp:e35f2c5f12f3
#90 fp:e5ef530089a4
#91 fp:3d3a7da6c123
#92 fp:ab652cbae548
#93 fp:7fe336198c7f
#94 fp:0a7260a0b378
#95 fp:7ac70bada657
#96 fp:9d85d25d7335
#97 fp:1bf47c6711fe
#98 fp:4aaa5946324b
#99 fp:c0fea3461b2f
#100 fp:dde71c9ca0f7
#101 fp:9eeedc8c8bc4

원본 JSON

{
  "byKind": {
    "bank_transactions": {
      "note": "89 rows from Clobe (2025-10-01~2025-10-31)",
      "saved": 84,
      "failed": 3,
      "skipped": 0,
      "duplicate": 1,
      "importRunId": "cc6fa3a5-6daa-4af7-9644-05771a8ca771",
      "endpointFilled": true
    },
    "card_transactions": {
      "note": "102 rows from Clobe (2025-10-01~2025-10-31)",
      "saved": 0,
      "failed": 0,
      "skipped": 0,
      "duplicate": 102,
      "importRunId": "b0209a52-aaab-4296-9993-7082a1eafb04",
      "endpointFilled": true
    }
  },
  "aggregate": {
    "saved": 84,
    "failed": 3,
    "skipped": 0,
    "duplicate": 103
  }
}

오류

bank_transactions: 통장 내역을 저장하지 못했습니다: duplicate key value violates unique constraint "finance_bank_transactions_fingerprint_idx"

{
  "kind": "bank_transactions",
  "errors": [
    {
      "message": "통장 내역을 저장하지 못했습니다: duplicate key value violates unique constraint \"finance_bank_transactions_fingerprint_idx\"",
      "fingerprint": "7db5b87ab5aad2f4e763a172287a26ce1d068b8c07221573e6033b672ee730f3"
    },
    {
      "message": "통장 내역을 저장하지 못했습니다: duplicate key value violates unique constraint \"finance_bank_transactions_fingerprint_idx\"",
      "fingerprint": "dc49fdcb8558ea7ea0ea2cf20ab8859db75871841443619375a46ffb599b43b7"
    },
    {
      "message": "통장 내역을 저장하지 못했습니다: duplicate key value violates unique constraint \"finance_bank_transactions_fingerprint_idx\"",
      "fingerprint": "42160c18afd5131450ee877d5cdfe88f69e47c746dfb4c129b9bdd57c190a826"
    }
  ]
}