error while - database update - to postgresql

WARN Database Update 0:540 Error while updating rows #45983 - #145983, reason: Batch entry 0 UPDATE datamart.bureau_data SET subs_id = 3496179, score_value = 742, created_on = ‘2019-06-28’, opened_count_181_365_days = 3, opened_balance_181_365_days = 224136.0, opened_limit_181_365_days = 277659.0, opened_count_1_5_yrs = 3, opened_balance_1_5_yrs = 0.0, opened_limit_1_5_yrs = 73825.0, opened_count_5_10_yrs = NULL, opened_balance_5_10_yrs = NULL, opened_limit_5_10_yrs = NULL, opened_count_61_180_days = NULL, opened_balance_61_180_days = NULL, opened_limit_61_180_days = NULL, opened_count_gt_10_yrs = NULL, opened_balance_gt_10_yrs = NULL, opened_limit_gt_10_yrs = NULL, opened_count_31_60_days = NULL, opened_balance_31_60_days = NULL, opened_limit_31_60_days = NULL, opened_count_lt_30_days = NULL, opened_balance_lt_30_days = NULL, opened_limit_lt_30_days = NULL, first_trade_open_since = ‘1_5_yrs’, closed_count_181_365_days = 1, closed_balance_181_365_days = 0.0, closed_limit_181_365_days = 55000.0, closed_count_61_180_days = NULL, closed_balance_61_180_days = NULL, closed_limit_61_180_days = NULL, closed_count_6_10_yrs = NULL, closed_balance_6_10_yrs = NULL, closed_limit_6_10_yrs = NULL, closed_count_gt_10_yrs = NULL, closed_balance_gt_10_yrs = NULL, closed_limit_gt_10_yrs = NULL, closed_count_lt_30_days = NULL, closed_balance_lt_30_days = NULL, closed_limit_lt_30_days = NULL, closed_count_1_5_yrs = 2, closed_balance_1_5_yrs = 0.0, closed_limit_1_5_yrs = 18825.0, closed_count_31_60_days = NULL, closed_balance_31_60_days = NULL, closed_limit_31_60_days = NULL, last_trade_closed_since = ‘181_365_days’, closed_trades_count = 3, open_trades_count = 3, total_trades_count = 6.0, trade_banks_count = 5, trade_finance_count = 1, open_autoloan_limit = NULL, open_autoloan_balance = NULL, open_autoloan_count = NULL, open_creditcard_limit = 36120.0, open_creditcard_balance = 205.0, open_creditcard_count = 1, open_personalloan_limit = 239640.0, open_personalloan_balance = 222032.0, open_personalloan_count = 1, open_consumerloan_limit = 1899.0, open_consumerloan_balance = 1899.0, open_consumerloan_count = 1, open_others_limit = NULL, open_others_balance = NULL, open_others_count = NULL, open_two_wheelerloan_limit = NULL, open_two_wheelerloan_balance = NULL, open_two_wheelerloan_count = NULL, open_businessloan_limit = NULL, open_businessloan_balance = NULL, open_businessloan_count = NULL, open_housingloan_limit = NULL, open_housingloan_balance = NULL, open_housingloan_count = NULL, open_goldloan_limit = NULL, open_goldloan_balance = NULL, open_goldloan_count = NULL, open_educationloan_limit = NULL, open_educationloan_balance = NULL, open_educationloan_count = NULL, Loan_on_Credit_Card_pluse_calc_limit = NULL, Loan_on_Credit_Card_pluse_balance = NULL, Loan_on_Credit_Card_pluse_score_value = NULL, closed_creditcard_limit = NULL, closed_creditcard_balance = NULL, closed_creditcard_count = NULL, closed_educationloan_limit = NULL, closed_educationloan_balance = NULL, closed_educationloan_count = NULL, closed_goldloan_limit = NULL, closed_goldloan_balance = NULL, closed_goldloan_count = NULL, closed_autoloan_limit = NULL, closed_autoloan_balance = NULL, closed_autoloan_count = NULL, closed_personalloan_limit = 55000.0, closed_personalloan_balance = 0.0, closed_personalloan_count = 1, closed_consumerloan_limit = 18825.0, closed_consumerloan_balance = 0.0, closed_consumerloan_count = 2, closed_two_wheelerloan_limit = NULL, closed_two_wheelerloan_balance = NULL, closed_two_wheelerloan_count = NULL, closed_others_limit = NULL, closed_others_balance = NULL, closed_others_count = NULL, closed_businessloan_limit = NULL, closed_businessloan_balance = NULL, closed_businessloan_count = NULL, closed_housingloan_limit = NULL, closed_housingloan_balance = NULL, closed_housingloan_count = NULL, delq2_past_due_amt = NULL, delq1_past_due_amt = NULL, writeoff_past_due_amt = NULL, highest_balance = 224136.0, first_account_type = ‘consumer loan’, first_trade_opened = ‘2016-06-09’, comp_limit_lt_25k = NULL, comp_balance_lt_25k = NULL, comp_count_lt_25k = NULL, comp_limit_25k_50k = NULL, comp_balance_25k_50k = NULL, comp_count_25k_50k = NULL WHERE subs_id = 3496179 AND open_two_wheelerloan_limit = NULL AND open_two_wheelerloan_balance = NULL AND open_two_wheelerloan_count = NULL AND closed_two_wheelerloan_limit = NULL AND closed_two_wheelerloan_balance = NULL AND closed_two_wheelerloan_count = NULL was aborted. Call getNextException to see the cause.
WARN Database Update 0:540 Errors “2” updating 145983 rows.

Dear @navinjadhav,

can you check the rows which could not be updated? Do they contain any invalid data (e.g. NULL where NULL is not allowed)?

Best,
Marten

any solution where i can pass null value in int and double…

couse i cant pass ZERO.

example - if i attempt exam and fail with 0 marks = 0
if i didnt attempt examp means NULL.

So both are diff value .

You have to make sure that your DB table definition allows NULL values. When creating a DB table with KNIME DB Table Creator node, you can check/uncheck the option to allow/disallow NULL values for specific columns.

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.