Job Details
c4674212-e9f1-49e7-90a9-f6cbb60db47a
Status
completed
Type
full_pipeline
Progress
Duration
38m 12s
Current Step
Pipeline completed
Accounts Processed
300
Opportunities
2,300
Fundings Loaded
258
Errors
13
Timing Details
- Created At
- 2026-01-25 11:42:30
- Started At
- 2026-01-25 13:43:20
- Completed At
- 2026-01-25 14:21:32
Parameters
{
"batch_size": 100,
"dry_run": false,
"month": 1,
"year": 2025
}
Error Details (13 errors)
| # | Error Message | Timestamp | Details |
|---|---|---|---|
| 1 |
Failed: SQUARE ADVANCE
|
2026-01-25T14:21:32.060248 | |
| 2 |
Failed: DLP FUNDING
|
2026-01-25T14:21:32.060252 | |
| 3 |
Error loading funding SQUARE ADVANCE: (pymysql.err.OperationalError) (1213, 'Deadlock found when trying to get lock; try restarting transaction')
[SQL: INSERT INTO competitor_funding (created_at, modified_at, account_id, opportunity_id, iso_name, account_name, account_industry, account_city, account_state, account_entity_type, account_inception_date, funder_name, funder_name_normalized, date_funded, amount_funded, term_in_days, daily_payment, payment_amount, payment_first_date, payment_last_date, payment_count, payment_frequency, financing_type, first_payment_amount, last_payment_amount, first_bank_statement_start, last_bank_statement_end, analytics_response_ids, occurrence_count) VALUES (%(created_at)s, %(modified_at)s, %(account_id)s, %(opportunity_id)s, %(iso_name)s, %(account_name)s, %(account_industry)s, %(account_city)s, %(account_state)s, %(account_entity_type)s, %(account_inception_date)s, %(funder_name)s, %(funder_name_normalized)s, %(date_funded)s, %(amount_funded)s, %(term_in_days)s, %(daily_payment)s, %(payment_amount)s, %(payment_first_date)s, %(payment_last_date)s, %(payment_count)s, %(payment_frequency)s, %(financing_type)s, %(first_payment_amount)s, %(last_payment_amount)s, %(first_bank_statement_start)s, %(last_bank_statement_end)s, %(analytics_response_ids)s, %(occurrence_count)s) ON DUPLICATE KEY UPDATE modified_at = %(param_1)s, opportunity_id = %(param_2)s, iso_name = %(param_3)s, account_name = %(param_4)s, account_industry = %(param_5)s, account_city = %(param_6)s, account_state = %(param_7)s, account_entity_type = %(param_8)s, account_inception_date = %(param_9)s, amount_funded = %(param_10)s, term_in_days = %(param_11)s, daily_payment = %(param_12)s, payment_amount = %(param_13)s, payment_first_date = %(param_14)s, payment_last_date = %(param_15)s, payment_count = %(param_16)s, payment_frequency = %(param_17)s, financing_type = %(param_18)s, first_payment_amount = %(param_19)s, last_payment_amount = %(param_20)s, first_bank_statement_start = %(param_21)s, last_bank_statement_end = %(param_22)s, analytics_response_ids = CASE WHEN VALUES(analytics_response_ids) IS NOT NULL THEN CASE WHEN JSON_CONTAINS(COALESCE(analytics_response_ids, '[]'), VALUES(analytics_response_ids)) THEN analytics_response_ids ELSE JSON_MERGE_PRESERVE(COALESCE(analytics_response_ids, '[]'), VALUES(analytics_response_ids)) END ELSE analytics_response_ids END, occurrence_count = occurrence_count + 1]
[parameters: {'created_at': datetime.datetime(2026, 1, 25, 11, 57, 9, 766821), 'modified_at': datetime.datetime(2026, 1, 25, 11, 57, 9, 766823), 'account_id': '0010z00001SgI3XAAV', 'opportunity_id': '006Nt00000KCAg2IAH', 'iso_name': 'ATYG LLC', 'account_name': 'Asian Journal Publications Inc', 'account_industry': 'Printing/Publishing', 'account_city': 'Glendale', 'account_state': 'CA', 'account_entity_type': 'Corp.', 'account_inception_date': datetime.date(1996, 2, 14), 'funder_name': 'SQUARE ADVANCE', 'funder_name_normalized': 'SQUAREADVANCE', 'date_funded': None, 'amount_funded': None, 'term_in_days': None, 'daily_payment': Decimal('692.0'), 'payment_amount': Decimal('13840.0'), 'payment_first_date': datetime.date(2024, 11, 1), 'payment_last_date': datetime.date(2024, 11, 29), 'payment_count': 20, 'payment_frequency': 'Daily', 'financing_type': 'Cash Advance', 'first_payment_amount': Decimal('692.0'), 'last_payment_amount': Decimal('692.0'), 'first_bank_statement_start': datetime.date(2024, 11, 1), 'last_bank_statement_end': datetime.date(2025, 2, 28), 'analytics_response_ids': '[198396]', 'occurrence_count': 1, 'param_1': datetime.datetime(2026, 1, 25, 11, 57, 9, 766182), 'param_2': '006Nt00000KCAg2IAH', 'param_3': 'ATYG LLC', 'param_4': 'Asian Journal Publications Inc', 'param_5': 'Printing/Publishing', 'param_6': 'Glendale', 'param_7': 'CA', 'param_8': 'Corp.', 'param_9': datetime.date(1996, 2, 14), 'param_10': None, 'param_11': None, 'param_12': Decimal('692.0'), 'param_13': Decimal('13840.0'), 'param_14': datetime.date(2024, 11, 1), 'param_15': datetime.date(2024, 11, 29), 'param_16': 20, 'param_17': 'Daily', 'param_18': 'Cash Advance', 'param_19': Decimal('692.0'), 'param_20': Decimal('692.0'), 'param_21': datetime.date(2024, 11, 1), 'param_22': datetime.date(2025, 2, 28)}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
|
2026-01-25T14:21:32.060253 | |
| 4 |
Error loading funding DLP FUNDING: (pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: INSERT INTO competitor_funding (created_at, modified_at, account_id, opportunity_id, iso_name, account_name, account_industry, account_city, account_state, account_entity_type, account_inception_date, funder_name, funder_name_normalized, date_funded, amount_funded, term_in_days, daily_payment, payment_amount, payment_first_date, payment_last_date, payment_count, payment_frequency, financing_type, first_payment_amount, last_payment_amount, first_bank_statement_start, last_bank_statement_end, analytics_response_ids, occurrence_count) VALUES (%(created_at)s, %(modified_at)s, %(account_id)s, %(opportunity_id)s, %(iso_name)s, %(account_name)s, %(account_industry)s, %(account_city)s, %(account_state)s, %(account_entity_type)s, %(account_inception_date)s, %(funder_name)s, %(funder_name_normalized)s, %(date_funded)s, %(amount_funded)s, %(term_in_days)s, %(daily_payment)s, %(payment_amount)s, %(payment_first_date)s, %(payment_last_date)s, %(payment_count)s, %(payment_frequency)s, %(financing_type)s, %(first_payment_amount)s, %(last_payment_amount)s, %(first_bank_statement_start)s, %(last_bank_statement_end)s, %(analytics_response_ids)s, %(occurrence_count)s) ON DUPLICATE KEY UPDATE modified_at = %(param_1)s, opportunity_id = %(param_2)s, iso_name = %(param_3)s, account_name = %(param_4)s, account_industry = %(param_5)s, account_city = %(param_6)s, account_state = %(param_7)s, account_entity_type = %(param_8)s, account_inception_date = %(param_9)s, amount_funded = %(param_10)s, term_in_days = %(param_11)s, daily_payment = %(param_12)s, payment_amount = %(param_13)s, payment_first_date = %(param_14)s, payment_last_date = %(param_15)s, payment_count = %(param_16)s, payment_frequency = %(param_17)s, financing_type = %(param_18)s, first_payment_amount = %(param_19)s, last_payment_amount = %(param_20)s, first_bank_statement_start = %(param_21)s, last_bank_statement_end = %(param_22)s, analytics_response_ids = CASE WHEN VALUES(analytics_response_ids) IS NOT NULL THEN CASE WHEN JSON_CONTAINS(COALESCE(analytics_response_ids, '[]'), VALUES(analytics_response_ids)) THEN analytics_response_ids ELSE JSON_MERGE_PRESERVE(COALESCE(analytics_response_ids, '[]'), VALUES(analytics_response_ids)) END ELSE analytics_response_ids END, occurrence_count = occurrence_count + 1]
[parameters: {'created_at': datetime.datetime(2026, 1, 25, 11, 57, 9, 813976), 'modified_at': datetime.datetime(2026, 1, 25, 11, 57, 9, 813994), 'account_id': '0010z00001SgI3XAAV', 'opportunity_id': '006Nt00000NnYUkIAN', 'iso_name': 'ATYG LLC', 'account_name': 'Asian Journal Publications Inc', 'account_industry': 'Printing/Publishing', 'account_city': 'Glendale', 'account_state': 'CA', 'account_entity_type': 'Corp.', 'account_inception_date': datetime.date(1996, 2, 14), 'funder_name': 'DLP FUNDING', 'funder_name_normalized': 'DLPFUNDING', 'date_funded': None, 'amount_funded': None, 'term_in_days': None, 'daily_payment': Decimal('3223.0'), 'payment_amount': Decimal('12892.0'), 'payment_first_date': datetime.date(2025, 6, 23), 'payment_last_date': datetime.date(2025, 6, 30), 'payment_count': 4, 'payment_frequency': 'Daily', 'financing_type': 'Cash Advance', 'first_payment_amount': Decimal('3223.0'), 'last_payment_amount': Decimal('3223.0'), 'first_bank_statement_start': datetime.date(2025, 5, 1), 'last_bank_statement_end': datetime.date(2025, 6, 30), 'analytics_response_ids': '[306697]', 'occurrence_count': 1, 'param_1': datetime.datetime(2026, 1, 25, 11, 57, 9, 812382), 'param_2': '006Nt00000NnYUkIAN', 'param_3': 'ATYG LLC', 'param_4': 'Asian Journal Publications Inc', 'param_5': 'Printing/Publishing', 'param_6': 'Glendale', 'param_7': 'CA', 'param_8': 'Corp.', 'param_9': datetime.date(1996, 2, 14), 'param_10': None, 'param_11': None, 'param_12': Decimal('3223.0'), 'param_13': Decimal('12892.0'), 'param_14': datetime.date(2025, 6, 23), 'param_15': datetime.date(2025, 6, 30), 'param_16': 4, 'param_17': 'Daily', 'param_18': 'Cash Advance', 'param_19': Decimal('3223.0'), 'param_20': Decimal('3223.0'), 'param_21': datetime.date(2025, 5, 1), 'param_22': datetime.date(2025, 6, 30)}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
|
2026-01-25T14:21:32.060254 | |
| 5 |
Failed: CFG MERCHANT SOLUTIONS
|
2026-01-25T14:21:32.060255 | |
| 6 |
Failed: CHRYSLER CAPITAL
|
2026-01-25T14:21:32.060257 | |
| 7 |
Failed: EBF HOLDINGS
|
2026-01-25T14:21:32.060258 | |
| 8 |
Failed: TIMEPAYMENT
|
2026-01-25T14:21:32.060259 | |
| 9 |
Error loading funding CFG MERCHANT SOLUTIONS: (pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: INSERT INTO competitor_funding (created_at, modified_at, account_id, opportunity_id, iso_name, account_name, account_industry, account_city, account_state, account_entity_type, account_inception_date, funder_name, funder_name_normalized, date_funded, amount_funded, term_in_days, daily_payment, payment_amount, payment_first_date, payment_last_date, payment_count, payment_frequency, financing_type, first_payment_amount, last_payment_amount, first_bank_statement_start, last_bank_statement_end, analytics_response_ids, occurrence_count) VALUES (%(created_at)s, %(modified_at)s, %(account_id)s, %(opportunity_id)s, %(iso_name)s, %(account_name)s, %(account_industry)s, %(account_city)s, %(account_state)s, %(account_entity_type)s, %(account_inception_date)s, %(funder_name)s, %(funder_name_normalized)s, %(date_funded)s, %(amount_funded)s, %(term_in_days)s, %(daily_payment)s, %(payment_amount)s, %(payment_first_date)s, %(payment_last_date)s, %(payment_count)s, %(payment_frequency)s, %(financing_type)s, %(first_payment_amount)s, %(last_payment_amount)s, %(first_bank_statement_start)s, %(last_bank_statement_end)s, %(analytics_response_ids)s, %(occurrence_count)s) ON DUPLICATE KEY UPDATE modified_at = %(param_1)s, opportunity_id = %(param_2)s, iso_name = %(param_3)s, account_name = %(param_4)s, account_industry = %(param_5)s, account_city = %(param_6)s, account_state = %(param_7)s, account_entity_type = %(param_8)s, account_inception_date = %(param_9)s, amount_funded = %(param_10)s, term_in_days = %(param_11)s, daily_payment = %(param_12)s, payment_amount = %(param_13)s, payment_first_date = %(param_14)s, payment_last_date = %(param_15)s, payment_count = %(param_16)s, payment_frequency = %(param_17)s, financing_type = %(param_18)s, first_payment_amount = %(param_19)s, last_payment_amount = %(param_20)s, first_bank_statement_start = %(param_21)s, last_bank_statement_end = %(param_22)s, analytics_response_ids = CASE WHEN VALUES(analytics_response_ids) IS NOT NULL THEN CASE WHEN JSON_CONTAINS(COALESCE(analytics_response_ids, '[]'), VALUES(analytics_response_ids)) THEN analytics_response_ids ELSE JSON_MERGE_PRESERVE(COALESCE(analytics_response_ids, '[]'), VALUES(analytics_response_ids)) END ELSE analytics_response_ids END, occurrence_count = occurrence_count + 1]
[parameters: {'created_at': datetime.datetime(2026, 1, 25, 11, 59, 51, 464932), 'modified_at': datetime.datetime(2026, 1, 25, 11, 59, 51, 464935), 'account_id': '0010z00001TBuzgAAD', 'opportunity_id': '006Nt00000CEzazIAD', 'iso_name': 'Shore Funding Solutions INC', 'account_name': 'Wired Up Home Theater LLC', 'account_industry': 'Electronics', 'account_city': 'The Plains', 'account_state': 'VA', 'account_entity_type': 'LLC', 'account_inception_date': datetime.date(2011, 1, 5), 'funder_name': 'CFG MERCHANT SOLUTIONS', 'funder_name_normalized': 'CFGMERCHANTSOLUTIONS', 'date_funded': None, 'amount_funded': None, 'term_in_days': None, 'daily_payment': Decimal('149.0'), 'payment_amount': Decimal('5066.0'), 'payment_first_date': datetime.date(2024, 4, 2), 'payment_last_date': datetime.date(2024, 5, 31), 'payment_count': 34, 'payment_frequency': 'Daily', 'financing_type': 'Cash Advance', 'first_payment_amount': Decimal('149.0'), 'last_payment_amount': Decimal('149.0'), 'first_bank_statement_start': datetime.date(2024, 1, 31), 'last_bank_statement_end': datetime.date(2024, 5, 31), 'analytics_response_ids': '[58635]', 'occurrence_count': 1, 'param_1': datetime.datetime(2026, 1, 25, 11, 59, 51, 423555), 'param_2': '006Nt00000CEzazIAD', 'param_3': 'Shore Funding Solutions INC', 'param_4': 'Wired Up Home Theater LLC', 'param_5': 'Electronics', 'param_6': 'The Plains', 'param_7': 'VA', 'param_8': 'LLC', 'param_9': datetime.date(2011, 1, 5), 'param_10': None, 'param_11': None, 'param_12': Decimal('149.0'), 'param_13': Decimal('5066.0'), 'param_14': datetime.date(2024, 4, 2), 'param_15': datetime.date(2024, 5, 31), 'param_16': 34, 'param_17': 'Daily', 'param_18': 'Cash Advance', 'param_19': Decimal('149.0'), 'param_20': Decimal('149.0'), 'param_21': datetime.date(2024, 1, 31), 'param_22': datetime.date(2024, 5, 31)}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
|
2026-01-25T14:21:32.060260 | |
| 10 |
Error loading funding CHRYSLER CAPITAL: (pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: INSERT INTO competitor_funding (created_at, modified_at, account_id, opportunity_id, iso_name, account_name, account_industry, account_city, account_state, account_entity_type, account_inception_date, funder_name, funder_name_normalized, date_funded, amount_funded, term_in_days, daily_payment, payment_amount, payment_first_date, payment_last_date, payment_count, payment_frequency, financing_type, first_payment_amount, last_payment_amount, first_bank_statement_start, last_bank_statement_end, analytics_response_ids, occurrence_count) VALUES (%(created_at)s, %(modified_at)s, %(account_id)s, %(opportunity_id)s, %(iso_name)s, %(account_name)s, %(account_industry)s, %(account_city)s, %(account_state)s, %(account_entity_type)s, %(account_inception_date)s, %(funder_name)s, %(funder_name_normalized)s, %(date_funded)s, %(amount_funded)s, %(term_in_days)s, %(daily_payment)s, %(payment_amount)s, %(payment_first_date)s, %(payment_last_date)s, %(payment_count)s, %(payment_frequency)s, %(financing_type)s, %(first_payment_amount)s, %(last_payment_amount)s, %(first_bank_statement_start)s, %(last_bank_statement_end)s, %(analytics_response_ids)s, %(occurrence_count)s) ON DUPLICATE KEY UPDATE modified_at = %(param_1)s, opportunity_id = %(param_2)s, iso_name = %(param_3)s, account_name = %(param_4)s, account_industry = %(param_5)s, account_city = %(param_6)s, account_state = %(param_7)s, account_entity_type = %(param_8)s, account_inception_date = %(param_9)s, amount_funded = %(param_10)s, term_in_days = %(param_11)s, daily_payment = %(param_12)s, payment_amount = %(param_13)s, payment_first_date = %(param_14)s, payment_last_date = %(param_15)s, payment_count = %(param_16)s, payment_frequency = %(param_17)s, financing_type = %(param_18)s, first_payment_amount = %(param_19)s, last_payment_amount = %(param_20)s, first_bank_statement_start = %(param_21)s, last_bank_statement_end = %(param_22)s, analytics_response_ids = CASE WHEN VALUES(analytics_response_ids) IS NOT NULL THEN CASE WHEN JSON_CONTAINS(COALESCE(analytics_response_ids, '[]'), VALUES(analytics_response_ids)) THEN analytics_response_ids ELSE JSON_MERGE_PRESERVE(COALESCE(analytics_response_ids, '[]'), VALUES(analytics_response_ids)) END ELSE analytics_response_ids END, occurrence_count = occurrence_count + 1]
[parameters: {'created_at': datetime.datetime(2026, 1, 25, 13, 30, 5, 106934), 'modified_at': datetime.datetime(2026, 1, 25, 13, 30, 5, 106940), 'account_id': '0010z00001TBvQ3AAL', 'opportunity_id': '006Nt00000IfXnFIAV', 'iso_name': 'SHMIL Enterprises LLC', 'account_name': 'Xynkhouse Auto Llc', 'account_industry': 'Automotive Sales - Used', 'account_city': 'Monroe', 'account_state': 'GA', 'account_entity_type': 'LLC', 'account_inception_date': datetime.date(2017, 5, 1), 'funder_name': 'CHRYSLER CAPITAL', 'funder_name_normalized': 'CHRYSLERCAPITAL', 'date_funded': None, 'amount_funded': None, 'term_in_days': None, 'daily_payment': Decimal('53.59'), 'payment_amount': Decimal('4716.0'), 'payment_first_date': datetime.date(2024, 9, 26), 'payment_last_date': datetime.date(2024, 12, 26), 'payment_count': 4, 'payment_frequency': 'Monthly', 'financing_type': 'Cash Advance', 'first_payment_amount': Decimal('1179.0'), 'last_payment_amount': Decimal('1179.0'), 'first_bank_statement_start': datetime.date(2024, 9, 1), 'last_bank_statement_end': datetime.date(2024, 12, 31), 'analytics_response_ids': '[167294]', 'occurrence_count': 1, 'param_1': datetime.datetime(2026, 1, 25, 13, 30, 5, 104736), 'param_2': '006Nt00000IfXnFIAV', 'param_3': 'SHMIL Enterprises LLC', 'param_4': 'Xynkhouse Auto Llc', 'param_5': 'Automotive Sales - Used', 'param_6': 'Monroe', 'param_7': 'GA', 'param_8': 'LLC', 'param_9': datetime.date(2017, 5, 1), 'param_10': None, 'param_11': None, 'param_12': Decimal('53.59'), 'param_13': Decimal('4716.0'), 'param_14': datetime.date(2024, 9, 26), 'param_15': datetime.date(2024, 12, 26), 'param_16': 4, 'param_17': 'Monthly', 'param_18': 'Cash Advance', 'param_19': Decimal('1179.0'), 'param_20': Decimal('1179.0'), 'param_21': datetime.date(2024, 9, 1), 'param_22': datetime.date(2024, 12, 31)}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
|
2026-01-25T14:21:32.060261 | |
| 11 |
Error loading funding EBF HOLDINGS: (pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: INSERT INTO competitor_funding (created_at, modified_at, account_id, opportunity_id, iso_name, account_name, account_industry, account_city, account_state, account_entity_type, account_inception_date, funder_name, funder_name_normalized, date_funded, amount_funded, term_in_days, daily_payment, payment_amount, payment_first_date, payment_last_date, payment_count, payment_frequency, financing_type, first_payment_amount, last_payment_amount, first_bank_statement_start, last_bank_statement_end, analytics_response_ids, occurrence_count) VALUES (%(created_at)s, %(modified_at)s, %(account_id)s, %(opportunity_id)s, %(iso_name)s, %(account_name)s, %(account_industry)s, %(account_city)s, %(account_state)s, %(account_entity_type)s, %(account_inception_date)s, %(funder_name)s, %(funder_name_normalized)s, %(date_funded)s, %(amount_funded)s, %(term_in_days)s, %(daily_payment)s, %(payment_amount)s, %(payment_first_date)s, %(payment_last_date)s, %(payment_count)s, %(payment_frequency)s, %(financing_type)s, %(first_payment_amount)s, %(last_payment_amount)s, %(first_bank_statement_start)s, %(last_bank_statement_end)s, %(analytics_response_ids)s, %(occurrence_count)s) ON DUPLICATE KEY UPDATE modified_at = %(param_1)s, opportunity_id = %(param_2)s, iso_name = %(param_3)s, account_name = %(param_4)s, account_industry = %(param_5)s, account_city = %(param_6)s, account_state = %(param_7)s, account_entity_type = %(param_8)s, account_inception_date = %(param_9)s, amount_funded = %(param_10)s, term_in_days = %(param_11)s, daily_payment = %(param_12)s, payment_amount = %(param_13)s, payment_first_date = %(param_14)s, payment_last_date = %(param_15)s, payment_count = %(param_16)s, payment_frequency = %(param_17)s, financing_type = %(param_18)s, first_payment_amount = %(param_19)s, last_payment_amount = %(param_20)s, first_bank_statement_start = %(param_21)s, last_bank_statement_end = %(param_22)s, analytics_response_ids = CASE WHEN VALUES(analytics_response_ids) IS NOT NULL THEN CASE WHEN JSON_CONTAINS(COALESCE(analytics_response_ids, '[]'), VALUES(analytics_response_ids)) THEN analytics_response_ids ELSE JSON_MERGE_PRESERVE(COALESCE(analytics_response_ids, '[]'), VALUES(analytics_response_ids)) END ELSE analytics_response_ids END, occurrence_count = occurrence_count + 1]
[parameters: {'created_at': datetime.datetime(2026, 1, 25, 14, 17, 22, 103314), 'modified_at': datetime.datetime(2026, 1, 25, 14, 17, 22, 103315), 'account_id': '0010z00001UUQysAAH', 'opportunity_id': '006Nt00000Bzo83IAB', 'iso_name': 'Streamline Funding, LLC', 'account_name': 'Game Start Inc', 'account_industry': 'Computer/Electronics Repair', 'account_city': 'Westbury', 'account_state': 'NY', 'account_entity_type': 'Corp', 'account_inception_date': datetime.date(2011, 7, 25), 'funder_name': 'EBF HOLDINGS', 'funder_name_normalized': 'EBFHOLDINGS', 'date_funded': datetime.date(2024, 2, 13), 'amount_funded': Decimal('19275.0'), 'term_in_days': 107, 'daily_payment': Decimal('250.0'), 'payment_amount': Decimal('14000.0'), 'payment_first_date': datetime.date(2024, 2, 14), 'payment_last_date': datetime.date(2024, 5, 31), 'payment_count': 56, 'payment_frequency': 'Daily', 'financing_type': 'Cash Advance', 'first_payment_amount': Decimal('250.0'), 'last_payment_amount': Decimal('250.0'), 'first_bank_statement_start': datetime.date(2024, 1, 24), 'last_bank_statement_end': datetime.date(2024, 5, 31), 'analytics_response_ids': '[53559]', 'occurrence_count': 1, 'param_1': datetime.datetime(2026, 1, 25, 14, 17, 22, 102736), 'param_2': '006Nt00000Bzo83IAB', 'param_3': 'Streamline Funding, LLC', 'param_4': 'Game Start Inc', 'param_5': 'Computer/Electronics Repair', 'param_6': 'Westbury', 'param_7': 'NY', 'param_8': 'Corp', 'param_9': datetime.date(2011, 7, 25), 'param_10': Decimal('19275.0'), 'param_11': 107, 'param_12': Decimal('250.0'), 'param_13': Decimal('14000.0'), 'param_14': datetime.date(2024, 2, 14), 'param_15': datetime.date(2024, 5, 31), 'param_16': 56, 'param_17': 'Daily', 'param_18': 'Cash Advance', 'param_19': Decimal('250.0'), 'param_20': Decimal('250.0'), 'param_21': datetime.date(2024, 1, 24), 'param_22': datetime.date(2024, 5, 31)}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
|
2026-01-25T14:21:32.060262 | |
| 12 |
Error loading funding TIMEPAYMENT: (pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL: INSERT INTO competitor_funding (created_at, modified_at, account_id, opportunity_id, iso_name, account_name, account_industry, account_city, account_state, account_entity_type, account_inception_date, funder_name, funder_name_normalized, date_funded, amount_funded, term_in_days, daily_payment, payment_amount, payment_first_date, payment_last_date, payment_count, payment_frequency, financing_type, first_payment_amount, last_payment_amount, first_bank_statement_start, last_bank_statement_end, analytics_response_ids, occurrence_count) VALUES (%(created_at)s, %(modified_at)s, %(account_id)s, %(opportunity_id)s, %(iso_name)s, %(account_name)s, %(account_industry)s, %(account_city)s, %(account_state)s, %(account_entity_type)s, %(account_inception_date)s, %(funder_name)s, %(funder_name_normalized)s, %(date_funded)s, %(amount_funded)s, %(term_in_days)s, %(daily_payment)s, %(payment_amount)s, %(payment_first_date)s, %(payment_last_date)s, %(payment_count)s, %(payment_frequency)s, %(financing_type)s, %(first_payment_amount)s, %(last_payment_amount)s, %(first_bank_statement_start)s, %(last_bank_statement_end)s, %(analytics_response_ids)s, %(occurrence_count)s) ON DUPLICATE KEY UPDATE modified_at = %(param_1)s, opportunity_id = %(param_2)s, iso_name = %(param_3)s, account_name = %(param_4)s, account_industry = %(param_5)s, account_city = %(param_6)s, account_state = %(param_7)s, account_entity_type = %(param_8)s, account_inception_date = %(param_9)s, amount_funded = %(param_10)s, term_in_days = %(param_11)s, daily_payment = %(param_12)s, payment_amount = %(param_13)s, payment_first_date = %(param_14)s, payment_last_date = %(param_15)s, payment_count = %(param_16)s, payment_frequency = %(param_17)s, financing_type = %(param_18)s, first_payment_amount = %(param_19)s, last_payment_amount = %(param_20)s, first_bank_statement_start = %(param_21)s, last_bank_statement_end = %(param_22)s, analytics_response_ids = CASE WHEN VALUES(analytics_response_ids) IS NOT NULL THEN CASE WHEN JSON_CONTAINS(COALESCE(analytics_response_ids, '[]'), VALUES(analytics_response_ids)) THEN analytics_response_ids ELSE JSON_MERGE_PRESERVE(COALESCE(analytics_response_ids, '[]'), VALUES(analytics_response_ids)) END ELSE analytics_response_ids END, occurrence_count = occurrence_count + 1]
[parameters: {'created_at': datetime.datetime(2026, 1, 25, 14, 18, 12, 151715), 'modified_at': datetime.datetime(2026, 1, 25, 14, 18, 12, 151716), 'account_id': '0010z00001UUQysAAH', 'opportunity_id': '006Nt00000IxoBKIAZ', 'iso_name': 'Streamline Funding, LLC', 'account_name': 'Game Start Inc', 'account_industry': 'Computer/Electronics Repair', 'account_city': 'Westbury', 'account_state': 'NY', 'account_entity_type': 'Corp', 'account_inception_date': datetime.date(2011, 7, 25), 'funder_name': 'TIMEPAYMENT', 'funder_name_normalized': 'TIMEPAYMENT', 'date_funded': None, 'amount_funded': None, 'term_in_days': None, 'daily_payment': Decimal('5.4'), 'payment_amount': Decimal('270.0'), 'payment_first_date': datetime.date(2024, 10, 15), 'payment_last_date': datetime.date(2024, 12, 10), 'payment_count': 5, 'payment_frequency': 'Biweekly', 'financing_type': 'Cash Advance', 'first_payment_amount': Decimal('54.0'), 'last_payment_amount': Decimal('54.0'), 'first_bank_statement_start': datetime.date(2024, 8, 22), 'last_bank_statement_end': datetime.date(2024, 12, 31), 'analytics_response_ids': '[173101]', 'occurrence_count': 1, 'param_1': datetime.datetime(2026, 1, 25, 14, 18, 12, 151253), 'param_2': '006Nt00000IxoBKIAZ', 'param_3': 'Streamline Funding, LLC', 'param_4': 'Game Start Inc', 'param_5': 'Computer/Electronics Repair', 'param_6': 'Westbury', 'param_7': 'NY', 'param_8': 'Corp', 'param_9': datetime.date(2011, 7, 25), 'param_10': None, 'param_11': None, 'param_12': Decimal('5.4'), 'param_13': Decimal('270.0'), 'param_14': datetime.date(2024, 10, 15), 'param_15': datetime.date(2024, 12, 10), 'param_16': 5, 'param_17': 'Biweekly', 'param_18': 'Cash Advance', 'param_19': Decimal('54.0'), 'param_20': Decimal('54.0'), 'param_21': datetime.date(2024, 8, 22), 'param_22': datetime.date(2024, 12, 31)}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
|
2026-01-25T14:21:32.060263 | |
| 13 |
(pymysql.err.OperationalError) (1205, 'Lock wait timeout exceeded; try restarting transaction')
[SQL:
UPDATE competitor_funding
SET
factor_rate_collected = %(factor_rate)s,
expected_payoff_date = %(expected_payoff)s,
has_full_term_visibility = %(visibility)s,
payoff_status = %(status)s,
payment_variance_detected = %(variance)s,
variance_details = %(variance_details)s,
modified_at = NOW()
WHERE id = %(funding_id)s
]
[parameters: {'factor_rate': 0.22362198958279614, 'expected_payoff': datetime.date(2025, 9, 2), 'visibility': 'yes', 'status': 'restructured', 'variance': 'yes', 'variance_details': '[{"payment_number": 1, "date": "2025-07-02", "expected_amount": 285.0, "actual_amount": 2854.17, "percent_change": 901.46, "is_last_payment": false}, ... (447 characters truncated) ... {"payment_number": 5, "date": "2025-07-30", "expected_amount": 285.0, "actual_amount": 2854.17, "percent_change": 901.46, "is_last_payment": false}]', 'funding_id': 405}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
|
2026-01-25T14:21:32.060263 |