Job Details
8b762840-bc13-45ad-830f-84f55e9ad468
Status
completed
Type
full_pipeline
Progress
Duration
5h 18m 58s
Current Step
Pipeline completed
Accounts Processed
340
Opportunities
2,568
Fundings Loaded
262
Errors
1
Timing Details
- Created At
- 2026-01-25 17:52:34
- Started At
- 2026-01-26 00:54:12
- Completed At
- 2026-01-26 06:13:10
Parameters
{
"batch_size": 100,
"dry_run": false,
"month": 1,
"year": 2025
}
Error Details (1 error)
| # | Error Message | Timestamp | Details |
|---|---|---|---|
| 1 |
(pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query ([Errno 54] Connection reset by peer)')
[SQL:
SELECT
a.id,
a.SalesforceOpportunityId,
a.FullJSON,
a.CreatedDate
FROM AnalyticsBankScrub_Response a
INNER JOIN (
SELECT
SalesforceOpportunityId,
MAX(CreatedDate) as MaxCreatedDate
FROM AnalyticsBankScrub_Response
WHERE SalesforceOpportunityId IN (%(id_0)s,%(id_1)s,%(id_2)s,%(id_3)s,%(id_4)s,%(id_5)s)
GROUP BY SalesforceOpportunityId
) b ON a.SalesforceOpportunityId = b.SalesforceOpportunityId
AND a.CreatedDate = b.MaxCreatedDate
]
[parameters: {'id_0': '0060z00001zXp7CAAS', 'id_1': '0060z0000205zRXAAY', 'id_2': '006Nt00000CiSeQIAV', 'id_3': '006Nt00000Ix6zvIAB', 'id_4': '006Nt00000RjH5FIAV', 'id_5': '006Nt00000TvrNmIAJ'}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
|
2026-01-26T06:13:09.603316 |