| 14933663 |
Error |
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'maturitydate' at row 1: INSERT INTO "dp_product" ("product_id", "attribute_name", "class1_name_d", "class1_name_e", "class2_name_d", "class2_name_e", "class2_official_svsp_id", "class2_official_svsp_id_new", "class2_strike1_alias", "class2_strike2_alias", "class2_strike3_alias", "class2_strike4_alias", "coupon", "coupon_interest", "coupon_premium", "currency_tradingbased_short", "currency_trading_short", "earliestexercisedate", "exchange_name", "exercise_entitlestounit", "exercise_numberneeded", "factor", "feature_1_id", "feature_2_id", "feature_3_id", "feature_4_id", "feature_5_id", "feature_availability", "firstlistingdate", "isin", "isactivemanaged", "iscleanpriced", "iscollateralized", "ispercentage", "isquanto", "issueprice", "issuer_name", "issuer_short", "knock_date", "knock_status", "lasttradingdate", "management_fees", "maturitydate", "name_e", "nominalvalue", "participation_level", "payment_winscale_downside", "protection_level_percent", "quotes_lastmodifieddate", "ratio", "redemption_percent", "status", "style_short", "subscription_enddate", "symbol", "termsheet", "valuations_ask_size_average", "valuations_bid_size_average", "valuations_bonus_yield", "valuations_bonus_yield_pa", "valuations_break_even", "valuations_calcprice", "valuations_calcprice_strike", "valuations_calcprice_underlying", "valuations_daystomaturity", "valuations_delta", "valuations_discount_percent", "valuations_fair_value", "valuations_fair_value_gap", "valuations_fair_value_issuer", "valuations_gamma", "valuations_gearing", "valuations_implvola_ask", "valuations_implvola_bid", "valuations_implvola_calcprice", "valuations_implvola_change", "valuations_intrinsic_value", "valuations_lastmodifieddate", "valuations_leverage_percent", "valuations_liquidity_rating_code", "valuations_market_making_index", "valuations_moneyness", "valuations_outperformance_level", "valuations_premium", "valuations_premium_pa", "valuations_price_rating_code", "valuations_product_rating_code", "valuations_qqm_average_buy_volume", "valuations_qqm_average_buy_volume_price", "valuations_qqm_average_sell_volume", "valuations_qqm_average_sell_volume_price", "valuations_qqm_average_spread", "valuations_qqm_date", "valuations_qqm_last_best_ask_price", "valuations_qqm_last_best_ask_volume", "valuations_qqm_last_best_bid_price", "valuations_qqm_last_best_bid_volume", "valuations_qqm_quotes_availability_ratio", "valuations_qqm_spreads_availability_ratio", "valuations_ratings_risk_classcode", "valuations_ratings_risk_value", "valuations_redemption_max", "valuations_rho", "valuations_sideward_yield", "valuations_sideward_yield_pa", "valuations_spread_average", "valuations_spread_homo", "valuations_spread_percent", "valuations_strikesensitivity", "valuations_theta_1day", "valuations_theta_7days", "valuations_timevalue", "valuations_turnover_chf_average", "valuations_underperformance_level", "valuations_vega", "valuations_yield_max", "valuations_yield_max_pa", "wkn", "created", "changed", "solid_valor", "solid_bc", "solid_bc_id", "solid_cc", "solid_cc_id", "fullquote_link", "solid_changed", "underlying_component_strike_1_isknocked", "underlying_component_strike_2_isknocked", "underlying_component_strike_3_isknocked", "underlying_component_strike_4_isknocked", "number_of_underlyings") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23, :db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27, :db_insert_placeholder_28, :db_insert_placeholder_29, :db_insert_placeholder_30, :db_insert_placeholder_31, :db_insert_placeholder_32, :db_insert_placeholder_33, :db_insert_placeholder_34, :db_insert_placeholder_35, :db_insert_placeholder_36, :db_insert_placeholder_37, :db_insert_placeholder_38, :db_insert_placeholder_39, :db_insert_placeholder_40, :db_insert_placeholder_41, :db_insert_placeholder_42, :db_insert_placeholder_43, :db_insert_placeholder_44, :db_insert_placeholder_45, :db_insert_placeholder_46, :db_insert_placeholder_47, :db_insert_placeholder_48, :db_insert_placeholder_49, :db_insert_placeholder_50, :db_insert_placeholder_51, :db_insert_placeholder_52, :db_insert_placeholder_53, :db_insert_placeholder_54, :db_insert_placeholder_55, :db_insert_placeholder_56, :db_insert_placeholder_57, :db_insert_placeholder_58, :db_insert_placeholder_59, :db_insert_placeholder_60, :db_insert_placeholder_61, :db_insert_placeholder_62, :db_insert_placeholder_63, :db_insert_placeholder_64, :db_insert_placeholder_65, :db_insert_placeholder_66, :db_insert_placeholder_67, :db_insert_placeholder_68, :db_insert_placeholder_69, :db_insert_placeholder_70, :db_insert_placeholder_71, :db_insert_placeholder_72, :db_insert_placeholder_73, :db_insert_placeholder_74, :db_insert_placeholder_75, :db_insert_placeholder_76, :db_insert_placeholder_77, :db_insert_placeholder_78, :db_insert_placeholder_79, :db_insert_placeholder_80, :db_insert_placeholder_81, :db_insert_placeholder_82, :db_insert_placeholder_83, :db_insert_placeholder_84, :db_insert_placeholder_85, :db_insert_placeholder_86, :db_insert_placeholder_87, :db_insert_placeholder_88, :db_insert_placeholder_89, :db_insert_placeholder_90, :db_insert_placeholder_91, :db_insert_placeholder_92, :db_insert_placeholder_93, :db_insert_placeholder_94, :db_insert_placeholder_95, :db_insert_placeholder_96, :db_insert_placeholder_97, :db_insert_placeholder_98, :db_insert_placeholder_99, :db_insert_placeholder_100, :db_insert_placeholder_101, :db_insert_placeholder_102, :db_insert_placeholder_103, :db_insert_placeholder_104, :db_insert_placeholder_105, :db_insert_placeholder_106, :db_insert_placeholder_107, :db_insert_placeholder_108, :db_insert_placeholder_109, :db_insert_placeholder_110, :db_insert_placeholder_111, :db_insert_placeholder_112, :db_insert_placeholder_113, :db_insert_placeholder_114, :db_insert_placeholder_115, :db_insert_placeholder_116, :db_insert_placeholder_117, :db_insert_placeholder_118, :db_insert_placeholder_119, :db_insert_placeholder_120, :db_insert_placeholder_121, :db_insert_placeholder_122, :db_insert_placeholder_123, :db_insert_placeholder_124, :db_insert_placeholder_125, :db_insert_placeholder_126, :db_insert_placeholder_127, :db_insert_placeholder_128, :db_insert_placeholder_129, :db_insert_placeholder_130, :db_insert_placeholder_131); Array
(
[:db_insert_placeholder_0] => 14933663
[:db_insert_placeholder_1] => Bull
[:db_insert_placeholder_2] => Partizipationsprodukte
[:db_insert_placeholder_3] => Participation Products
[:db_insert_placeholder_4] => Tracker-Zertifikat
[:db_insert_placeholder_5] => Tracker Certificate
[:db_insert_placeholder_6] => 210
[:db_insert_placeholder_7] => 1300
[:db_insert_placeholder_8] =>
[:db_insert_placeholder_9] =>
[:db_insert_placeholder_10] =>
[:db_insert_placeholder_11] =>
[:db_insert_placeholder_12] =>
[:db_insert_placeholder_13] =>
[:db_insert_placeholder_14] =>
[:db_insert_placeholder_15] => JPY
[:db_insert_placeholder_16] => JPY
[:db_insert_placeholder_17] => 2655417600
[:db_insert_placeholder_18] => SIX Swiss Exchange - Structured Products
[:db_insert_placeholder_19] =>
[:db_insert_placeholder_20] =>
[:db_insert_placeholder_21] =>
[:db_insert_placeholder_22] => 9
[:db_insert_placeholder_23] => 13
[:db_insert_placeholder_24] =>
[:db_insert_placeholder_25] =>
[:db_insert_placeholder_26] =>
[:db_insert_placeholder_27] => 1
[:db_insert_placeholder_28] => 1709161200
[:db_insert_placeholder_29] => CH1292088866
[:db_insert_placeholder_30] => 0
[:db_insert_placeholder_31] =>
[:db_insert_placeholder_32] => 0
[:db_insert_placeholder_33] => 0
[:db_insert_placeholder_34] => 0
[:db_insert_placeholder_35] => 7830
[:db_insert_placeholder_36] => Leonteq Securities
[:db_insert_placeholder_37] => LEON
[:db_insert_placeholder_38] =>
[:db_insert_placeholder_39] =>
[:db_insert_placeholder_40] => 2655417600
[:db_insert_placeholder_41] => 0
[:db_insert_placeholder_42] => 2656018800
[:db_insert_placeholder_43] => Tracker Zertifikat
[:db_insert_placeholder_44] =>
[:db_insert_placeholder_45] => 1
[:db_insert_placeholder_46] =>
[:db_insert_placeholder_47] =>
[:db_insert_placeholder_48] =>
[:db_insert_placeholder_49] => 1000
[:db_insert_placeholder_50] =>
[:db_insert_placeholder_51] => 1
[:db_insert_placeholder_52] => A
[:db_insert_placeholder_53] =>
[:db_insert_placeholder_54] => ZLULTQ
[:db_insert_placeholder_55] => https://services.derivativepartners.com/api/products/CH1292088866/documents/termsheet
[:db_insert_placeholder_56] =>
[:db_insert_placeholder_57] =>
[:db_insert_placeholder_58] =>
[:db_insert_placeholder_59] =>
[:db_insert_placeholder_60] =>
[:db_insert_placeholder_61] =>
[:db_insert_placeholder_62] =>
[:db_insert_placeholder_63] => 10756599
[:db_insert_placeholder_64] => 10122
[:db_insert_placeholder_65] =>
[:db_insert_placeholder_66] =>
[:db_insert_placeholder_67] =>
[:db_insert_placeholder_68] =>
[:db_insert_placeholder_69] =>
[:db_insert_placeholder_70] =>
[:db_insert_placeholder_71] =>
[:db_insert_placeholder_72] =>
[:db_insert_placeholder_73] =>
[:db_insert_placeholder_74] =>
[:db_insert_placeholder_75] =>
[:db_insert_placeholder_76] =>
[:db_insert_placeholder_77] =>
[:db_insert_placeholder_78] =>
[:db_insert_placeholder_79] => 1
[:db_insert_placeholder_80] => 0
[:db_insert_placeholder_81] =>
[:db_insert_placeholder_82] =>
[:db_insert_placeholder_83] =>
[:db_insert_placeholder_84] =>
[:db_insert_placeholder_85] =>
[:db_insert_placeholder_86] =>
[:db_insert_placeholder_87] => 30
[:db_insert_placeholder_88] => 355093
[:db_insert_placeholder_89] => 30
[:db_insert_placeholder_90] => 358661
[:db_insert_placeholder_91] => 1
[:db_insert_placeholder_92] => 1781215200
[:db_insert_placeholder_93] => 11945
[:db_insert_placeholder_94] => 30
[:db_insert_placeholder_95] => 10353
[:db_insert_placeholder_96] => 30
[:db_insert_placeholder_97] => 99.9899979
[:db_insert_placeholder_98] => 54.5099983
[:db_insert_placeholder_99] =>
[:db_insert_placeholder_100] =>
[:db_insert_placeholder_101] =>
[:db_insert_placeholder_102] =>
[:db_insert_placeholder_103] =>
[:db_insert_placeholder_104] =>
[:db_insert_placeholder_105] =>
[:db_insert_placeholder_106] => 0.0099698
[:db_insert_placeholder_107] => 0.0099698
[:db_insert_placeholder_108] =>
[:db_insert_placeholder_109] =>
[:db_insert_placeholder_110] =>
[:db_insert_placeholder_111] =>
[:db_insert_placeholder_112] =>
[:db_insert_placeholder_113] =>
[:db_insert_placeholder_114] =>
[:db_insert_placeholder_115] =>
[:db_insert_placeholder_116] =>
[:db_insert_placeholder_117] => 129208886
[:db_insert_placeholder_118] => 1781587210
[:db_insert_placeholder_119] => 1781587210
[:db_insert_placeholder_120] =>
[:db_insert_placeholder_121] =>
[:db_insert_placeholder_122] =>
[:db_insert_placeholder_123] =>
[:db_insert_placeholder_124] =>
[:db_insert_placeholder_125] =>
[:db_insert_placeholder_126] =>
[:db_insert_placeholder_127] =>
[:db_insert_placeholder_128] =>
[:db_insert_placeholder_129] =>
[:db_insert_placeholder_130] =>
[:db_insert_placeholder_131] =>
)
(/var/www/html/web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php:817) |
| 19057681 |
Error |
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'maturitydate' at row 1: UPDATE "dp_product" SET "product_id"=:db_update_placeholder_0, "attribute_name"=:db_update_placeholder_1, "class1_name_d"=:db_update_placeholder_2, "class1_name_e"=:db_update_placeholder_3, "class2_name_d"=:db_update_placeholder_4, "class2_name_e"=:db_update_placeholder_5, "class2_official_svsp_id"=:db_update_placeholder_6, "class2_official_svsp_id_new"=:db_update_placeholder_7, "class2_strike1_alias"=:db_update_placeholder_8, "class2_strike2_alias"=:db_update_placeholder_9, "class2_strike3_alias"=:db_update_placeholder_10, "class2_strike4_alias"=:db_update_placeholder_11, "coupon"=:db_update_placeholder_12, "coupon_interest"=:db_update_placeholder_13, "coupon_premium"=:db_update_placeholder_14, "currency_tradingbased_short"=:db_update_placeholder_15, "currency_trading_short"=:db_update_placeholder_16, "earliestexercisedate"=:db_update_placeholder_17, "exchange_name"=:db_update_placeholder_18, "exercise_entitlestounit"=:db_update_placeholder_19, "exercise_numberneeded"=:db_update_placeholder_20, "factor"=:db_update_placeholder_21, "feature_1_id"=:db_update_placeholder_22, "feature_2_id"=:db_update_placeholder_23, "feature_3_id"=:db_update_placeholder_24, "feature_4_id"=:db_update_placeholder_25, "feature_5_id"=:db_update_placeholder_26, "feature_availability"=:db_update_placeholder_27, "firstlistingdate"=:db_update_placeholder_28, "isin"=:db_update_placeholder_29, "isactivemanaged"=:db_update_placeholder_30, "iscleanpriced"=:db_update_placeholder_31, "iscollateralized"=:db_update_placeholder_32, "ispercentage"=:db_update_placeholder_33, "isquanto"=:db_update_placeholder_34, "issueprice"=:db_update_placeholder_35, "issuer_name"=:db_update_placeholder_36, "issuer_short"=:db_update_placeholder_37, "knock_date"=:db_update_placeholder_38, "knock_status"=:db_update_placeholder_39, "lasttradingdate"=:db_update_placeholder_40, "management_fees"=:db_update_placeholder_41, "maturitydate"=:db_update_placeholder_42, "name_e"=:db_update_placeholder_43, "nominalvalue"=:db_update_placeholder_44, "participation_level"=:db_update_placeholder_45, "payment_winscale_downside"=:db_update_placeholder_46, "protection_level_percent"=:db_update_placeholder_47, "quotes_lastmodifieddate"=:db_update_placeholder_48, "ratio"=:db_update_placeholder_49, "redemption_percent"=:db_update_placeholder_50, "status"=:db_update_placeholder_51, "style_short"=:db_update_placeholder_52, "subscription_enddate"=:db_update_placeholder_53, "symbol"=:db_update_placeholder_54, "termsheet"=:db_update_placeholder_55, "valuations_ask_size_average"=:db_update_placeholder_56, "valuations_bid_size_average"=:db_update_placeholder_57, "valuations_bonus_yield"=:db_update_placeholder_58, "valuations_bonus_yield_pa"=:db_update_placeholder_59, "valuations_break_even"=:db_update_placeholder_60, "valuations_calcprice"=:db_update_placeholder_61, "valuations_calcprice_strike"=:db_update_placeholder_62, "valuations_calcprice_underlying"=:db_update_placeholder_63, "valuations_daystomaturity"=:db_update_placeholder_64, "valuations_delta"=:db_update_placeholder_65, "valuations_discount_percent"=:db_update_placeholder_66, "valuations_fair_value"=:db_update_placeholder_67, "valuations_fair_value_gap"=:db_update_placeholder_68, "valuations_fair_value_issuer"=:db_update_placeholder_69, "valuations_gamma"=:db_update_placeholder_70, "valuations_gearing"=:db_update_placeholder_71, "valuations_implvola_ask"=:db_update_placeholder_72, "valuations_implvola_bid"=:db_update_placeholder_73, "valuations_implvola_calcprice"=:db_update_placeholder_74, "valuations_implvola_change"=:db_update_placeholder_75, "valuations_intrinsic_value"=:db_update_placeholder_76, "valuations_lastmodifieddate"=:db_update_placeholder_77, "valuations_leverage_percent"=:db_update_placeholder_78, "valuations_liquidity_rating_code"=:db_update_placeholder_79, "valuations_market_making_index"=:db_update_placeholder_80, "valuations_moneyness"=:db_update_placeholder_81, "valuations_outperformance_level"=:db_update_placeholder_82, "valuations_premium"=:db_update_placeholder_83, "valuations_premium_pa"=:db_update_placeholder_84, "valuations_price_rating_code"=:db_update_placeholder_85, "valuations_product_rating_code"=:db_update_placeholder_86, "valuations_qqm_average_buy_volume"=:db_update_placeholder_87, "valuations_qqm_average_buy_volume_price"=:db_update_placeholder_88, "valuations_qqm_average_sell_volume"=:db_update_placeholder_89, "valuations_qqm_average_sell_volume_price"=:db_update_placeholder_90, "valuations_qqm_average_spread"=:db_update_placeholder_91, "valuations_qqm_date"=:db_update_placeholder_92, "valuations_qqm_last_best_ask_price"=:db_update_placeholder_93, "valuations_qqm_last_best_ask_volume"=:db_update_placeholder_94, "valuations_qqm_last_best_bid_price"=:db_update_placeholder_95, "valuations_qqm_last_best_bid_volume"=:db_update_placeholder_96, "valuations_qqm_quotes_availability_ratio"=:db_update_placeholder_97, "valuations_qqm_spreads_availability_ratio"=:db_update_placeholder_98, "valuations_ratings_risk_classcode"=:db_update_placeholder_99, "valuations_ratings_risk_value"=:db_update_placeholder_100, "valuations_redemption_max"=:db_update_placeholder_101, "valuations_rho"=:db_update_placeholder_102, "valuations_sideward_yield"=:db_update_placeholder_103, "valuations_sideward_yield_pa"=:db_update_placeholder_104, "valuations_spread_average"=:db_update_placeholder_105, "valuations_spread_homo"=:db_update_placeholder_106, "valuations_spread_percent"=:db_update_placeholder_107, "valuations_strikesensitivity"=:db_update_placeholder_108, "valuations_theta_1day"=:db_update_placeholder_109, "valuations_theta_7days"=:db_update_placeholder_110, "valuations_timevalue"=:db_update_placeholder_111, "valuations_turnover_chf_average"=:db_update_placeholder_112, "valuations_underperformance_level"=:db_update_placeholder_113, "valuations_vega"=:db_update_placeholder_114, "valuations_yield_max"=:db_update_placeholder_115, "valuations_yield_max_pa"=:db_update_placeholder_116, "wkn"=:db_update_placeholder_117, "created"=:db_update_placeholder_118, "changed"=:db_update_placeholder_119, "solid_valor"=:db_update_placeholder_120, "solid_bc"=:db_update_placeholder_121, "solid_bc_id"=:db_update_placeholder_122, "solid_cc"=:db_update_placeholder_123, "solid_cc_id"=:db_update_placeholder_124, "fullquote_link"=:db_update_placeholder_125, "solid_changed"=:db_update_placeholder_126, "underlying_component_strike_1_isknocked"=:db_update_placeholder_127, "underlying_component_strike_2_isknocked"=:db_update_placeholder_128, "underlying_component_strike_3_isknocked"=:db_update_placeholder_129, "underlying_component_strike_4_isknocked"=:db_update_placeholder_130, "number_of_underlyings"=:db_update_placeholder_131
WHERE "id" = :db_condition_placeholder_0; Array
(
[:db_update_placeholder_0] => 19057681
[:db_update_placeholder_1] => Bear
[:db_update_placeholder_2] => Kapitalschutzprodukte
[:db_update_placeholder_3] => Capital Protection Products
[:db_update_placeholder_4] => Kapitalschutz-Zertifikat mit Coupon
[:db_update_placeholder_5] => Capital Protection Note with Coupon
[:db_update_placeholder_6] => 210
[:db_update_placeholder_7] => 1140
[:db_update_placeholder_8] =>
[:db_update_placeholder_9] =>
[:db_update_placeholder_10] =>
[:db_update_placeholder_11] =>
[:db_update_placeholder_12] =>
[:db_update_placeholder_13] =>
[:db_update_placeholder_14] =>
[:db_update_placeholder_15] => EUR
[:db_update_placeholder_16] => PCT
[:db_update_placeholder_17] => 2239315200
[:db_update_placeholder_18] => SIX Swiss Exchange - Structured Products
[:db_update_placeholder_19] =>
[:db_update_placeholder_20] =>
[:db_update_placeholder_21] =>
[:db_update_placeholder_22] => 5
[:db_update_placeholder_23] => 2
[:db_update_placeholder_24] =>
[:db_update_placeholder_25] =>
[:db_update_placeholder_26] =>
[:db_update_placeholder_27] => 1
[:db_update_placeholder_28] => 1765753200
[:db_update_placeholder_29] => FR0014012XH6
[:db_update_placeholder_30] => 0
[:db_update_placeholder_31] => 0
[:db_update_placeholder_32] => 0
[:db_update_placeholder_33] => 1
[:db_update_placeholder_34] =>
[:db_update_placeholder_35] => 1
[:db_update_placeholder_36] => Royal Bank of Canada
[:db_update_placeholder_37] => RBC
[:db_update_placeholder_38] =>
[:db_update_placeholder_39] =>
[:db_update_placeholder_40] => 2239315200
[:db_update_placeholder_41] =>
[:db_update_placeholder_42] => 2239311600
[:db_update_placeholder_43] => Phoenix Notes
[:db_update_placeholder_44] => 1000
[:db_update_placeholder_45] =>
[:db_update_placeholder_46] =>
[:db_update_placeholder_47] => 1
[:db_update_placeholder_48] =>
[:db_update_placeholder_49] =>
[:db_update_placeholder_50] =>
[:db_update_placeholder_51] => 1
[:db_update_placeholder_52] => A
[:db_update_placeholder_53] =>
[:db_update_placeholder_54] => AALVSP
[:db_update_placeholder_55] =>
[:db_update_placeholder_56] =>
[:db_update_placeholder_57] =>
[:db_update_placeholder_58] =>
[:db_update_placeholder_59] =>
[:db_update_placeholder_60] =>
[:db_update_placeholder_61] =>
[:db_update_placeholder_62] =>
[:db_update_placeholder_63] =>
[:db_update_placeholder_64] => 5299
[:db_update_placeholder_65] =>
[:db_update_placeholder_66] =>
[:db_update_placeholder_67] =>
[:db_update_placeholder_68] =>
[:db_update_placeholder_69] =>
[:db_update_placeholder_70] =>
[:db_update_placeholder_71] =>
[:db_update_placeholder_72] =>
[:db_update_placeholder_73] =>
[:db_update_placeholder_74] =>
[:db_update_placeholder_75] =>
[:db_update_placeholder_76] =>
[:db_update_placeholder_77] =>
[:db_update_placeholder_78] =>
[:db_update_placeholder_79] =>
[:db_update_placeholder_80] =>
[:db_update_placeholder_81] =>
[:db_update_placeholder_82] =>
[:db_update_placeholder_83] =>
[:db_update_placeholder_84] =>
[:db_update_placeholder_85] =>
[:db_update_placeholder_86] =>
[:db_update_placeholder_87] =>
[:db_update_placeholder_88] =>
[:db_update_placeholder_89] =>
[:db_update_placeholder_90] =>
[:db_update_placeholder_91] =>
[:db_update_placeholder_92] => 1781215200
[:db_update_placeholder_93] =>
[:db_update_placeholder_94] =>
[:db_update_placeholder_95] =>
[:db_update_placeholder_96] =>
[:db_update_placeholder_97] =>
[:db_update_placeholder_98] =>
[:db_update_placeholder_99] =>
[:db_update_placeholder_100] =>
[:db_update_placeholder_101] =>
[:db_update_placeholder_102] =>
[:db_update_placeholder_103] =>
[:db_update_placeholder_104] =>
[:db_update_placeholder_105] =>
[:db_update_placeholder_106] =>
[:db_update_placeholder_107] =>
[:db_update_placeholder_108] =>
[:db_update_placeholder_109] =>
[:db_update_placeholder_110] =>
[:db_update_placeholder_111] =>
[:db_update_placeholder_112] =>
[:db_update_placeholder_113] =>
[:db_update_placeholder_114] =>
[:db_update_placeholder_115] =>
[:db_update_placeholder_116] =>
[:db_update_placeholder_117] => 149113391
[:db_update_placeholder_118] => 1759227060
[:db_update_placeholder_119] => 1781587210
[:db_update_placeholder_120] =>
[:db_update_placeholder_121] =>
[:db_update_placeholder_122] =>
[:db_update_placeholder_123] =>
[:db_update_placeholder_124] =>
[:db_update_placeholder_125] =>
[:db_update_placeholder_126] => 1781497846
[:db_update_placeholder_127] => 0
[:db_update_placeholder_128] => 0
[:db_update_placeholder_129] => 0
[:db_update_placeholder_130] => 0
[:db_update_placeholder_131] => 1
[:db_condition_placeholder_0] => 670106
)
(/var/www/html/web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php:817) |
| 19462728 |
Error |
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'maturitydate' at row 1: INSERT INTO "dp_product" ("product_id", "attribute_name", "class1_name_d", "class1_name_e", "class2_name_d", "class2_name_e", "class2_official_svsp_id", "class2_official_svsp_id_new", "class2_strike1_alias", "class2_strike2_alias", "class2_strike3_alias", "class2_strike4_alias", "coupon", "coupon_interest", "coupon_premium", "currency_tradingbased_short", "currency_trading_short", "earliestexercisedate", "exchange_name", "exercise_entitlestounit", "exercise_numberneeded", "factor", "feature_1_id", "feature_2_id", "feature_3_id", "feature_4_id", "feature_5_id", "feature_availability", "firstlistingdate", "isin", "isactivemanaged", "iscleanpriced", "iscollateralized", "ispercentage", "isquanto", "issueprice", "issuer_name", "issuer_short", "knock_date", "knock_status", "lasttradingdate", "management_fees", "maturitydate", "name_e", "nominalvalue", "participation_level", "payment_winscale_downside", "protection_level_percent", "quotes_lastmodifieddate", "ratio", "redemption_percent", "status", "style_short", "subscription_enddate", "symbol", "termsheet", "valuations_ask_size_average", "valuations_bid_size_average", "valuations_bonus_yield", "valuations_bonus_yield_pa", "valuations_break_even", "valuations_calcprice", "valuations_calcprice_strike", "valuations_calcprice_underlying", "valuations_daystomaturity", "valuations_delta", "valuations_discount_percent", "valuations_fair_value", "valuations_fair_value_gap", "valuations_fair_value_issuer", "valuations_gamma", "valuations_gearing", "valuations_implvola_ask", "valuations_implvola_bid", "valuations_implvola_calcprice", "valuations_implvola_change", "valuations_intrinsic_value", "valuations_lastmodifieddate", "valuations_leverage_percent", "valuations_liquidity_rating_code", "valuations_market_making_index", "valuations_moneyness", "valuations_outperformance_level", "valuations_premium", "valuations_premium_pa", "valuations_price_rating_code", "valuations_product_rating_code", "valuations_qqm_average_buy_volume", "valuations_qqm_average_buy_volume_price", "valuations_qqm_average_sell_volume", "valuations_qqm_average_sell_volume_price", "valuations_qqm_average_spread", "valuations_qqm_date", "valuations_qqm_last_best_ask_price", "valuations_qqm_last_best_ask_volume", "valuations_qqm_last_best_bid_price", "valuations_qqm_last_best_bid_volume", "valuations_qqm_quotes_availability_ratio", "valuations_qqm_spreads_availability_ratio", "valuations_ratings_risk_classcode", "valuations_ratings_risk_value", "valuations_redemption_max", "valuations_rho", "valuations_sideward_yield", "valuations_sideward_yield_pa", "valuations_spread_average", "valuations_spread_homo", "valuations_spread_percent", "valuations_strikesensitivity", "valuations_theta_1day", "valuations_theta_7days", "valuations_timevalue", "valuations_turnover_chf_average", "valuations_underperformance_level", "valuations_vega", "valuations_yield_max", "valuations_yield_max_pa", "wkn", "created", "changed", "solid_valor", "solid_bc", "solid_bc_id", "solid_cc", "solid_cc_id", "fullquote_link", "solid_changed", "underlying_component_strike_1_isknocked", "underlying_component_strike_2_isknocked", "underlying_component_strike_3_isknocked", "underlying_component_strike_4_isknocked", "number_of_underlyings") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23, :db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27, :db_insert_placeholder_28, :db_insert_placeholder_29, :db_insert_placeholder_30, :db_insert_placeholder_31, :db_insert_placeholder_32, :db_insert_placeholder_33, :db_insert_placeholder_34, :db_insert_placeholder_35, :db_insert_placeholder_36, :db_insert_placeholder_37, :db_insert_placeholder_38, :db_insert_placeholder_39, :db_insert_placeholder_40, :db_insert_placeholder_41, :db_insert_placeholder_42, :db_insert_placeholder_43, :db_insert_placeholder_44, :db_insert_placeholder_45, :db_insert_placeholder_46, :db_insert_placeholder_47, :db_insert_placeholder_48, :db_insert_placeholder_49, :db_insert_placeholder_50, :db_insert_placeholder_51, :db_insert_placeholder_52, :db_insert_placeholder_53, :db_insert_placeholder_54, :db_insert_placeholder_55, :db_insert_placeholder_56, :db_insert_placeholder_57, :db_insert_placeholder_58, :db_insert_placeholder_59, :db_insert_placeholder_60, :db_insert_placeholder_61, :db_insert_placeholder_62, :db_insert_placeholder_63, :db_insert_placeholder_64, :db_insert_placeholder_65, :db_insert_placeholder_66, :db_insert_placeholder_67, :db_insert_placeholder_68, :db_insert_placeholder_69, :db_insert_placeholder_70, :db_insert_placeholder_71, :db_insert_placeholder_72, :db_insert_placeholder_73, :db_insert_placeholder_74, :db_insert_placeholder_75, :db_insert_placeholder_76, :db_insert_placeholder_77, :db_insert_placeholder_78, :db_insert_placeholder_79, :db_insert_placeholder_80, :db_insert_placeholder_81, :db_insert_placeholder_82, :db_insert_placeholder_83, :db_insert_placeholder_84, :db_insert_placeholder_85, :db_insert_placeholder_86, :db_insert_placeholder_87, :db_insert_placeholder_88, :db_insert_placeholder_89, :db_insert_placeholder_90, :db_insert_placeholder_91, :db_insert_placeholder_92, :db_insert_placeholder_93, :db_insert_placeholder_94, :db_insert_placeholder_95, :db_insert_placeholder_96, :db_insert_placeholder_97, :db_insert_placeholder_98, :db_insert_placeholder_99, :db_insert_placeholder_100, :db_insert_placeholder_101, :db_insert_placeholder_102, :db_insert_placeholder_103, :db_insert_placeholder_104, :db_insert_placeholder_105, :db_insert_placeholder_106, :db_insert_placeholder_107, :db_insert_placeholder_108, :db_insert_placeholder_109, :db_insert_placeholder_110, :db_insert_placeholder_111, :db_insert_placeholder_112, :db_insert_placeholder_113, :db_insert_placeholder_114, :db_insert_placeholder_115, :db_insert_placeholder_116, :db_insert_placeholder_117, :db_insert_placeholder_118, :db_insert_placeholder_119, :db_insert_placeholder_120, :db_insert_placeholder_121, :db_insert_placeholder_122, :db_insert_placeholder_123, :db_insert_placeholder_124, :db_insert_placeholder_125, :db_insert_placeholder_126, :db_insert_placeholder_127, :db_insert_placeholder_128, :db_insert_placeholder_129, :db_insert_placeholder_130, :db_insert_placeholder_131); Array
(
[:db_insert_placeholder_0] => 19462728
[:db_insert_placeholder_1] => Bear
[:db_insert_placeholder_2] => Kapitalschutzprodukte
[:db_insert_placeholder_3] => Capital Protection Products
[:db_insert_placeholder_4] => Kapitalschutz-Zertifikat mit Coupon
[:db_insert_placeholder_5] => Capital Protection Note with Coupon
[:db_insert_placeholder_6] => 210
[:db_insert_placeholder_7] => 1140
[:db_insert_placeholder_8] =>
[:db_insert_placeholder_9] =>
[:db_insert_placeholder_10] =>
[:db_insert_placeholder_11] =>
[:db_insert_placeholder_12] =>
[:db_insert_placeholder_13] =>
[:db_insert_placeholder_14] =>
[:db_insert_placeholder_15] => EUR
[:db_insert_placeholder_16] => PCT
[:db_insert_placeholder_17] => 2150794800
[:db_insert_placeholder_18] => SIX Swiss Exchange - Structured Products
[:db_insert_placeholder_19] =>
[:db_insert_placeholder_20] =>
[:db_insert_placeholder_21] =>
[:db_insert_placeholder_22] => 16
[:db_insert_placeholder_23] => 5
[:db_insert_placeholder_24] => 2
[:db_insert_placeholder_25] =>
[:db_insert_placeholder_26] =>
[:db_insert_placeholder_27] => 1
[:db_insert_placeholder_28] => 1772060400
[:db_insert_placeholder_29] => FR00140149E8
[:db_insert_placeholder_30] => 0
[:db_insert_placeholder_31] => 0
[:db_insert_placeholder_32] => 1
[:db_insert_placeholder_33] => 1
[:db_insert_placeholder_34] =>
[:db_insert_placeholder_35] => 1
[:db_insert_placeholder_36] => Royal Bank of Canada
[:db_insert_placeholder_37] => RBC
[:db_insert_placeholder_38] =>
[:db_insert_placeholder_39] =>
[:db_insert_placeholder_40] => 2150794800
[:db_insert_placeholder_41] => 0
[:db_insert_placeholder_42] => 2150751600
[:db_insert_placeholder_43] => Callable Linked Notes
[:db_insert_placeholder_44] => 1000
[:db_insert_placeholder_45] =>
[:db_insert_placeholder_46] =>
[:db_insert_placeholder_47] => 1
[:db_insert_placeholder_48] =>
[:db_insert_placeholder_49] =>
[:db_insert_placeholder_50] =>
[:db_insert_placeholder_51] => 1
[:db_insert_placeholder_52] => A
[:db_insert_placeholder_53] =>
[:db_insert_placeholder_54] => AANHSP
[:db_insert_placeholder_55] =>
[:db_insert_placeholder_56] =>
[:db_insert_placeholder_57] =>
[:db_insert_placeholder_58] =>
[:db_insert_placeholder_59] =>
[:db_insert_placeholder_60] =>
[:db_insert_placeholder_61] =>
[:db_insert_placeholder_62] =>
[:db_insert_placeholder_63] =>
[:db_insert_placeholder_64] => 4274
[:db_insert_placeholder_65] =>
[:db_insert_placeholder_66] =>
[:db_insert_placeholder_67] =>
[:db_insert_placeholder_68] =>
[:db_insert_placeholder_69] =>
[:db_insert_placeholder_70] =>
[:db_insert_placeholder_71] =>
[:db_insert_placeholder_72] =>
[:db_insert_placeholder_73] =>
[:db_insert_placeholder_74] =>
[:db_insert_placeholder_75] =>
[:db_insert_placeholder_76] =>
[:db_insert_placeholder_77] =>
[:db_insert_placeholder_78] =>
[:db_insert_placeholder_79] =>
[:db_insert_placeholder_80] =>
[:db_insert_placeholder_81] =>
[:db_insert_placeholder_82] =>
[:db_insert_placeholder_83] =>
[:db_insert_placeholder_84] =>
[:db_insert_placeholder_85] =>
[:db_insert_placeholder_86] =>
[:db_insert_placeholder_87] =>
[:db_insert_placeholder_88] =>
[:db_insert_placeholder_89] =>
[:db_insert_placeholder_90] =>
[:db_insert_placeholder_91] =>
[:db_insert_placeholder_92] => 1781215200
[:db_insert_placeholder_93] =>
[:db_insert_placeholder_94] =>
[:db_insert_placeholder_95] =>
[:db_insert_placeholder_96] =>
[:db_insert_placeholder_97] =>
[:db_insert_placeholder_98] =>
[:db_insert_placeholder_99] =>
[:db_insert_placeholder_100] =>
[:db_insert_placeholder_101] =>
[:db_insert_placeholder_102] =>
[:db_insert_placeholder_103] =>
[:db_insert_placeholder_104] =>
[:db_insert_placeholder_105] =>
[:db_insert_placeholder_106] =>
[:db_insert_placeholder_107] =>
[:db_insert_placeholder_108] =>
[:db_insert_placeholder_109] =>
[:db_insert_placeholder_110] =>
[:db_insert_placeholder_111] =>
[:db_insert_placeholder_112] =>
[:db_insert_placeholder_113] =>
[:db_insert_placeholder_114] =>
[:db_insert_placeholder_115] =>
[:db_insert_placeholder_116] =>
[:db_insert_placeholder_117] => 145666987
[:db_insert_placeholder_118] => 1781587210
[:db_insert_placeholder_119] => 1781587210
[:db_insert_placeholder_120] =>
[:db_insert_placeholder_121] =>
[:db_insert_placeholder_122] =>
[:db_insert_placeholder_123] =>
[:db_insert_placeholder_124] =>
[:db_insert_placeholder_125] =>
[:db_insert_placeholder_126] =>
[:db_insert_placeholder_127] =>
[:db_insert_placeholder_128] =>
[:db_insert_placeholder_129] =>
[:db_insert_placeholder_130] =>
[:db_insert_placeholder_131] =>
)
(/var/www/html/web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php:817) |
| 19647036 |
Error |
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'maturitydate' at row 1: INSERT INTO "dp_product" ("product_id", "attribute_name", "class1_name_d", "class1_name_e", "class2_name_d", "class2_name_e", "class2_official_svsp_id", "class2_official_svsp_id_new", "class2_strike1_alias", "class2_strike2_alias", "class2_strike3_alias", "class2_strike4_alias", "coupon", "coupon_interest", "coupon_premium", "currency_tradingbased_short", "currency_trading_short", "earliestexercisedate", "exchange_name", "exercise_entitlestounit", "exercise_numberneeded", "factor", "feature_1_id", "feature_2_id", "feature_3_id", "feature_4_id", "feature_5_id", "feature_availability", "firstlistingdate", "isin", "isactivemanaged", "iscleanpriced", "iscollateralized", "ispercentage", "isquanto", "issueprice", "issuer_name", "issuer_short", "knock_date", "knock_status", "lasttradingdate", "management_fees", "maturitydate", "name_e", "nominalvalue", "participation_level", "payment_winscale_downside", "protection_level_percent", "quotes_lastmodifieddate", "ratio", "redemption_percent", "status", "style_short", "subscription_enddate", "symbol", "termsheet", "valuations_ask_size_average", "valuations_bid_size_average", "valuations_bonus_yield", "valuations_bonus_yield_pa", "valuations_break_even", "valuations_calcprice", "valuations_calcprice_strike", "valuations_calcprice_underlying", "valuations_daystomaturity", "valuations_delta", "valuations_discount_percent", "valuations_fair_value", "valuations_fair_value_gap", "valuations_fair_value_issuer", "valuations_gamma", "valuations_gearing", "valuations_implvola_ask", "valuations_implvola_bid", "valuations_implvola_calcprice", "valuations_implvola_change", "valuations_intrinsic_value", "valuations_lastmodifieddate", "valuations_leverage_percent", "valuations_liquidity_rating_code", "valuations_market_making_index", "valuations_moneyness", "valuations_outperformance_level", "valuations_premium", "valuations_premium_pa", "valuations_price_rating_code", "valuations_product_rating_code", "valuations_qqm_average_buy_volume", "valuations_qqm_average_buy_volume_price", "valuations_qqm_average_sell_volume", "valuations_qqm_average_sell_volume_price", "valuations_qqm_average_spread", "valuations_qqm_date", "valuations_qqm_last_best_ask_price", "valuations_qqm_last_best_ask_volume", "valuations_qqm_last_best_bid_price", "valuations_qqm_last_best_bid_volume", "valuations_qqm_quotes_availability_ratio", "valuations_qqm_spreads_availability_ratio", "valuations_ratings_risk_classcode", "valuations_ratings_risk_value", "valuations_redemption_max", "valuations_rho", "valuations_sideward_yield", "valuations_sideward_yield_pa", "valuations_spread_average", "valuations_spread_homo", "valuations_spread_percent", "valuations_strikesensitivity", "valuations_theta_1day", "valuations_theta_7days", "valuations_timevalue", "valuations_turnover_chf_average", "valuations_underperformance_level", "valuations_vega", "valuations_yield_max", "valuations_yield_max_pa", "wkn", "created", "changed", "solid_valor", "solid_bc", "solid_bc_id", "solid_cc", "solid_cc_id", "fullquote_link", "solid_changed", "underlying_component_strike_1_isknocked", "underlying_component_strike_2_isknocked", "underlying_component_strike_3_isknocked", "underlying_component_strike_4_isknocked", "number_of_underlyings") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23, :db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27, :db_insert_placeholder_28, :db_insert_placeholder_29, :db_insert_placeholder_30, :db_insert_placeholder_31, :db_insert_placeholder_32, :db_insert_placeholder_33, :db_insert_placeholder_34, :db_insert_placeholder_35, :db_insert_placeholder_36, :db_insert_placeholder_37, :db_insert_placeholder_38, :db_insert_placeholder_39, :db_insert_placeholder_40, :db_insert_placeholder_41, :db_insert_placeholder_42, :db_insert_placeholder_43, :db_insert_placeholder_44, :db_insert_placeholder_45, :db_insert_placeholder_46, :db_insert_placeholder_47, :db_insert_placeholder_48, :db_insert_placeholder_49, :db_insert_placeholder_50, :db_insert_placeholder_51, :db_insert_placeholder_52, :db_insert_placeholder_53, :db_insert_placeholder_54, :db_insert_placeholder_55, :db_insert_placeholder_56, :db_insert_placeholder_57, :db_insert_placeholder_58, :db_insert_placeholder_59, :db_insert_placeholder_60, :db_insert_placeholder_61, :db_insert_placeholder_62, :db_insert_placeholder_63, :db_insert_placeholder_64, :db_insert_placeholder_65, :db_insert_placeholder_66, :db_insert_placeholder_67, :db_insert_placeholder_68, :db_insert_placeholder_69, :db_insert_placeholder_70, :db_insert_placeholder_71, :db_insert_placeholder_72, :db_insert_placeholder_73, :db_insert_placeholder_74, :db_insert_placeholder_75, :db_insert_placeholder_76, :db_insert_placeholder_77, :db_insert_placeholder_78, :db_insert_placeholder_79, :db_insert_placeholder_80, :db_insert_placeholder_81, :db_insert_placeholder_82, :db_insert_placeholder_83, :db_insert_placeholder_84, :db_insert_placeholder_85, :db_insert_placeholder_86, :db_insert_placeholder_87, :db_insert_placeholder_88, :db_insert_placeholder_89, :db_insert_placeholder_90, :db_insert_placeholder_91, :db_insert_placeholder_92, :db_insert_placeholder_93, :db_insert_placeholder_94, :db_insert_placeholder_95, :db_insert_placeholder_96, :db_insert_placeholder_97, :db_insert_placeholder_98, :db_insert_placeholder_99, :db_insert_placeholder_100, :db_insert_placeholder_101, :db_insert_placeholder_102, :db_insert_placeholder_103, :db_insert_placeholder_104, :db_insert_placeholder_105, :db_insert_placeholder_106, :db_insert_placeholder_107, :db_insert_placeholder_108, :db_insert_placeholder_109, :db_insert_placeholder_110, :db_insert_placeholder_111, :db_insert_placeholder_112, :db_insert_placeholder_113, :db_insert_placeholder_114, :db_insert_placeholder_115, :db_insert_placeholder_116, :db_insert_placeholder_117, :db_insert_placeholder_118, :db_insert_placeholder_119, :db_insert_placeholder_120, :db_insert_placeholder_121, :db_insert_placeholder_122, :db_insert_placeholder_123, :db_insert_placeholder_124, :db_insert_placeholder_125, :db_insert_placeholder_126, :db_insert_placeholder_127, :db_insert_placeholder_128, :db_insert_placeholder_129, :db_insert_placeholder_130, :db_insert_placeholder_131); Array
(
[:db_insert_placeholder_0] => 19647036
[:db_insert_placeholder_1] => Bear
[:db_insert_placeholder_2] => Kapitalschutzprodukte
[:db_insert_placeholder_3] => Capital Protection Products
[:db_insert_placeholder_4] => Kapitalschutz-Zertifikat mit Coupon
[:db_insert_placeholder_5] => Capital Protection Note with Coupon
[:db_insert_placeholder_6] => 210
[:db_insert_placeholder_7] => 1140
[:db_insert_placeholder_8] =>
[:db_insert_placeholder_9] =>
[:db_insert_placeholder_10] =>
[:db_insert_placeholder_11] =>
[:db_insert_placeholder_12] =>
[:db_insert_placeholder_13] =>
[:db_insert_placeholder_14] =>
[:db_insert_placeholder_15] => EUR
[:db_insert_placeholder_16] => PCT
[:db_insert_placeholder_17] => 2243116800
[:db_insert_placeholder_18] => SIX Swiss Exchange - Structured Products
[:db_insert_placeholder_19] =>
[:db_insert_placeholder_20] =>
[:db_insert_placeholder_21] =>
[:db_insert_placeholder_22] => 5
[:db_insert_placeholder_23] => 15
[:db_insert_placeholder_24] => 2
[:db_insert_placeholder_25] =>
[:db_insert_placeholder_26] =>
[:db_insert_placeholder_27] => 1
[:db_insert_placeholder_28] => 1769727600
[:db_insert_placeholder_29] => XS3213396206
[:db_insert_placeholder_30] => 0
[:db_insert_placeholder_31] => 0
[:db_insert_placeholder_32] => 0
[:db_insert_placeholder_33] => 1
[:db_insert_placeholder_34] =>
[:db_insert_placeholder_35] => 1
[:db_insert_placeholder_36] => Royal Bank of Canada
[:db_insert_placeholder_37] => RBC
[:db_insert_placeholder_38] =>
[:db_insert_placeholder_39] =>
[:db_insert_placeholder_40] => 2243116800
[:db_insert_placeholder_41] => 0
[:db_insert_placeholder_42] => 2243113200
[:db_insert_placeholder_43] => Phoenix Notes
[:db_insert_placeholder_44] => 1000
[:db_insert_placeholder_45] =>
[:db_insert_placeholder_46] =>
[:db_insert_placeholder_47] => 1
[:db_insert_placeholder_48] =>
[:db_insert_placeholder_49] =>
[:db_insert_placeholder_50] =>
[:db_insert_placeholder_51] => 1
[:db_insert_placeholder_52] => A
[:db_insert_placeholder_53] =>
[:db_insert_placeholder_54] => AAPPSP
[:db_insert_placeholder_55] =>
[:db_insert_placeholder_56] =>
[:db_insert_placeholder_57] =>
[:db_insert_placeholder_58] =>
[:db_insert_placeholder_59] =>
[:db_insert_placeholder_60] =>
[:db_insert_placeholder_61] =>
[:db_insert_placeholder_62] =>
[:db_insert_placeholder_63] =>
[:db_insert_placeholder_64] => 5343
[:db_insert_placeholder_65] =>
[:db_insert_placeholder_66] =>
[:db_insert_placeholder_67] =>
[:db_insert_placeholder_68] =>
[:db_insert_placeholder_69] =>
[:db_insert_placeholder_70] =>
[:db_insert_placeholder_71] =>
[:db_insert_placeholder_72] =>
[:db_insert_placeholder_73] =>
[:db_insert_placeholder_74] =>
[:db_insert_placeholder_75] =>
[:db_insert_placeholder_76] =>
[:db_insert_placeholder_77] =>
[:db_insert_placeholder_78] =>
[:db_insert_placeholder_79] =>
[:db_insert_placeholder_80] =>
[:db_insert_placeholder_81] =>
[:db_insert_placeholder_82] =>
[:db_insert_placeholder_83] =>
[:db_insert_placeholder_84] =>
[:db_insert_placeholder_85] =>
[:db_insert_placeholder_86] =>
[:db_insert_placeholder_87] =>
[:db_insert_placeholder_88] =>
[:db_insert_placeholder_89] =>
[:db_insert_placeholder_90] =>
[:db_insert_placeholder_91] =>
[:db_insert_placeholder_92] => 1781215200
[:db_insert_placeholder_93] =>
[:db_insert_placeholder_94] =>
[:db_insert_placeholder_95] =>
[:db_insert_placeholder_96] =>
[:db_insert_placeholder_97] =>
[:db_insert_placeholder_98] =>
[:db_insert_placeholder_99] =>
[:db_insert_placeholder_100] =>
[:db_insert_placeholder_101] =>
[:db_insert_placeholder_102] =>
[:db_insert_placeholder_103] =>
[:db_insert_placeholder_104] =>
[:db_insert_placeholder_105] =>
[:db_insert_placeholder_106] =>
[:db_insert_placeholder_107] =>
[:db_insert_placeholder_108] =>
[:db_insert_placeholder_109] =>
[:db_insert_placeholder_110] =>
[:db_insert_placeholder_111] =>
[:db_insert_placeholder_112] =>
[:db_insert_placeholder_113] =>
[:db_insert_placeholder_114] =>
[:db_insert_placeholder_115] =>
[:db_insert_placeholder_116] =>
[:db_insert_placeholder_117] => 147344997
[:db_insert_placeholder_118] => 1781587210
[:db_insert_placeholder_119] => 1781587210
[:db_insert_placeholder_120] =>
[:db_insert_placeholder_121] =>
[:db_insert_placeholder_122] =>
[:db_insert_placeholder_123] =>
[:db_insert_placeholder_124] =>
[:db_insert_placeholder_125] =>
[:db_insert_placeholder_126] =>
[:db_insert_placeholder_127] =>
[:db_insert_placeholder_128] =>
[:db_insert_placeholder_129] =>
[:db_insert_placeholder_130] =>
[:db_insert_placeholder_131] =>
)
(/var/www/html/web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php:817) |
| 19909971 |
Error |
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'maturitydate' at row 1: INSERT INTO "dp_product" ("product_id", "attribute_name", "class1_name_d", "class1_name_e", "class2_name_d", "class2_name_e", "class2_official_svsp_id", "class2_official_svsp_id_new", "class2_strike1_alias", "class2_strike2_alias", "class2_strike3_alias", "class2_strike4_alias", "coupon", "coupon_interest", "coupon_premium", "currency_tradingbased_short", "currency_trading_short", "earliestexercisedate", "exchange_name", "exercise_entitlestounit", "exercise_numberneeded", "factor", "feature_1_id", "feature_2_id", "feature_3_id", "feature_4_id", "feature_5_id", "feature_availability", "firstlistingdate", "isin", "isactivemanaged", "iscleanpriced", "iscollateralized", "ispercentage", "isquanto", "issueprice", "issuer_name", "issuer_short", "knock_date", "knock_status", "lasttradingdate", "management_fees", "maturitydate", "name_e", "nominalvalue", "participation_level", "payment_winscale_downside", "protection_level_percent", "quotes_lastmodifieddate", "ratio", "redemption_percent", "status", "style_short", "subscription_enddate", "symbol", "termsheet", "valuations_ask_size_average", "valuations_bid_size_average", "valuations_bonus_yield", "valuations_bonus_yield_pa", "valuations_break_even", "valuations_calcprice", "valuations_calcprice_strike", "valuations_calcprice_underlying", "valuations_daystomaturity", "valuations_delta", "valuations_discount_percent", "valuations_fair_value", "valuations_fair_value_gap", "valuations_fair_value_issuer", "valuations_gamma", "valuations_gearing", "valuations_implvola_ask", "valuations_implvola_bid", "valuations_implvola_calcprice", "valuations_implvola_change", "valuations_intrinsic_value", "valuations_lastmodifieddate", "valuations_leverage_percent", "valuations_liquidity_rating_code", "valuations_market_making_index", "valuations_moneyness", "valuations_outperformance_level", "valuations_premium", "valuations_premium_pa", "valuations_price_rating_code", "valuations_product_rating_code", "valuations_qqm_average_buy_volume", "valuations_qqm_average_buy_volume_price", "valuations_qqm_average_sell_volume", "valuations_qqm_average_sell_volume_price", "valuations_qqm_average_spread", "valuations_qqm_date", "valuations_qqm_last_best_ask_price", "valuations_qqm_last_best_ask_volume", "valuations_qqm_last_best_bid_price", "valuations_qqm_last_best_bid_volume", "valuations_qqm_quotes_availability_ratio", "valuations_qqm_spreads_availability_ratio", "valuations_ratings_risk_classcode", "valuations_ratings_risk_value", "valuations_redemption_max", "valuations_rho", "valuations_sideward_yield", "valuations_sideward_yield_pa", "valuations_spread_average", "valuations_spread_homo", "valuations_spread_percent", "valuations_strikesensitivity", "valuations_theta_1day", "valuations_theta_7days", "valuations_timevalue", "valuations_turnover_chf_average", "valuations_underperformance_level", "valuations_vega", "valuations_yield_max", "valuations_yield_max_pa", "wkn", "created", "changed", "solid_valor", "solid_bc", "solid_bc_id", "solid_cc", "solid_cc_id", "fullquote_link", "solid_changed", "underlying_component_strike_1_isknocked", "underlying_component_strike_2_isknocked", "underlying_component_strike_3_isknocked", "underlying_component_strike_4_isknocked", "number_of_underlyings") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23, :db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27, :db_insert_placeholder_28, :db_insert_placeholder_29, :db_insert_placeholder_30, :db_insert_placeholder_31, :db_insert_placeholder_32, :db_insert_placeholder_33, :db_insert_placeholder_34, :db_insert_placeholder_35, :db_insert_placeholder_36, :db_insert_placeholder_37, :db_insert_placeholder_38, :db_insert_placeholder_39, :db_insert_placeholder_40, :db_insert_placeholder_41, :db_insert_placeholder_42, :db_insert_placeholder_43, :db_insert_placeholder_44, :db_insert_placeholder_45, :db_insert_placeholder_46, :db_insert_placeholder_47, :db_insert_placeholder_48, :db_insert_placeholder_49, :db_insert_placeholder_50, :db_insert_placeholder_51, :db_insert_placeholder_52, :db_insert_placeholder_53, :db_insert_placeholder_54, :db_insert_placeholder_55, :db_insert_placeholder_56, :db_insert_placeholder_57, :db_insert_placeholder_58, :db_insert_placeholder_59, :db_insert_placeholder_60, :db_insert_placeholder_61, :db_insert_placeholder_62, :db_insert_placeholder_63, :db_insert_placeholder_64, :db_insert_placeholder_65, :db_insert_placeholder_66, :db_insert_placeholder_67, :db_insert_placeholder_68, :db_insert_placeholder_69, :db_insert_placeholder_70, :db_insert_placeholder_71, :db_insert_placeholder_72, :db_insert_placeholder_73, :db_insert_placeholder_74, :db_insert_placeholder_75, :db_insert_placeholder_76, :db_insert_placeholder_77, :db_insert_placeholder_78, :db_insert_placeholder_79, :db_insert_placeholder_80, :db_insert_placeholder_81, :db_insert_placeholder_82, :db_insert_placeholder_83, :db_insert_placeholder_84, :db_insert_placeholder_85, :db_insert_placeholder_86, :db_insert_placeholder_87, :db_insert_placeholder_88, :db_insert_placeholder_89, :db_insert_placeholder_90, :db_insert_placeholder_91, :db_insert_placeholder_92, :db_insert_placeholder_93, :db_insert_placeholder_94, :db_insert_placeholder_95, :db_insert_placeholder_96, :db_insert_placeholder_97, :db_insert_placeholder_98, :db_insert_placeholder_99, :db_insert_placeholder_100, :db_insert_placeholder_101, :db_insert_placeholder_102, :db_insert_placeholder_103, :db_insert_placeholder_104, :db_insert_placeholder_105, :db_insert_placeholder_106, :db_insert_placeholder_107, :db_insert_placeholder_108, :db_insert_placeholder_109, :db_insert_placeholder_110, :db_insert_placeholder_111, :db_insert_placeholder_112, :db_insert_placeholder_113, :db_insert_placeholder_114, :db_insert_placeholder_115, :db_insert_placeholder_116, :db_insert_placeholder_117, :db_insert_placeholder_118, :db_insert_placeholder_119, :db_insert_placeholder_120, :db_insert_placeholder_121, :db_insert_placeholder_122, :db_insert_placeholder_123, :db_insert_placeholder_124, :db_insert_placeholder_125, :db_insert_placeholder_126, :db_insert_placeholder_127, :db_insert_placeholder_128, :db_insert_placeholder_129, :db_insert_placeholder_130, :db_insert_placeholder_131); Array
(
[:db_insert_placeholder_0] => 19909971
[:db_insert_placeholder_1] => Bear
[:db_insert_placeholder_2] => Kapitalschutzprodukte
[:db_insert_placeholder_3] => Capital Protection Products
[:db_insert_placeholder_4] => Kapitalschutz-Zertifikat mit Coupon
[:db_insert_placeholder_5] => Capital Protection Note with Coupon
[:db_insert_placeholder_6] => 460
[:db_insert_placeholder_7] => 1140
[:db_insert_placeholder_8] =>
[:db_insert_placeholder_9] =>
[:db_insert_placeholder_10] =>
[:db_insert_placeholder_11] =>
[:db_insert_placeholder_12] =>
[:db_insert_placeholder_13] =>
[:db_insert_placeholder_14] =>
[:db_insert_placeholder_15] => EUR
[:db_insert_placeholder_16] => PCT
[:db_insert_placeholder_17] => 2149891200
[:db_insert_placeholder_18] => SIX Swiss Exchange - Structured Products
[:db_insert_placeholder_19] =>
[:db_insert_placeholder_20] =>
[:db_insert_placeholder_21] =>
[:db_insert_placeholder_22] => 9
[:db_insert_placeholder_23] => 2
[:db_insert_placeholder_24] =>
[:db_insert_placeholder_25] =>
[:db_insert_placeholder_26] =>
[:db_insert_placeholder_27] => 1
[:db_insert_placeholder_28] => 1771196400
[:db_insert_placeholder_29] => FR0014015NJ6
[:db_insert_placeholder_30] => 0
[:db_insert_placeholder_31] => 0
[:db_insert_placeholder_32] => 0
[:db_insert_placeholder_33] => 1
[:db_insert_placeholder_34] =>
[:db_insert_placeholder_35] => 1
[:db_insert_placeholder_36] => Royal Bank of Canada
[:db_insert_placeholder_37] => RBC
[:db_insert_placeholder_38] =>
[:db_insert_placeholder_39] =>
[:db_insert_placeholder_40] => 2149891200
[:db_insert_placeholder_41] => 0
[:db_insert_placeholder_42] => 2149887600
[:db_insert_placeholder_43] => Digital Coupon Notes
[:db_insert_placeholder_44] => 1000
[:db_insert_placeholder_45] =>
[:db_insert_placeholder_46] =>
[:db_insert_placeholder_47] => 1
[:db_insert_placeholder_48] =>
[:db_insert_placeholder_49] =>
[:db_insert_placeholder_50] =>
[:db_insert_placeholder_51] => 1
[:db_insert_placeholder_52] => A
[:db_insert_placeholder_53] =>
[:db_insert_placeholder_54] => AAQ1SP
[:db_insert_placeholder_55] =>
[:db_insert_placeholder_56] =>
[:db_insert_placeholder_57] =>
[:db_insert_placeholder_58] =>
[:db_insert_placeholder_59] =>
[:db_insert_placeholder_60] =>
[:db_insert_placeholder_61] =>
[:db_insert_placeholder_62] =>
[:db_insert_placeholder_63] =>
[:db_insert_placeholder_64] => 4264
[:db_insert_placeholder_65] =>
[:db_insert_placeholder_66] =>
[:db_insert_placeholder_67] =>
[:db_insert_placeholder_68] =>
[:db_insert_placeholder_69] =>
[:db_insert_placeholder_70] =>
[:db_insert_placeholder_71] =>
[:db_insert_placeholder_72] =>
[:db_insert_placeholder_73] =>
[:db_insert_placeholder_74] =>
[:db_insert_placeholder_75] =>
[:db_insert_placeholder_76] =>
[:db_insert_placeholder_77] =>
[:db_insert_placeholder_78] =>
[:db_insert_placeholder_79] =>
[:db_insert_placeholder_80] =>
[:db_insert_placeholder_81] =>
[:db_insert_placeholder_82] =>
[:db_insert_placeholder_83] =>
[:db_insert_placeholder_84] =>
[:db_insert_placeholder_85] =>
[:db_insert_placeholder_86] =>
[:db_insert_placeholder_87] =>
[:db_insert_placeholder_88] =>
[:db_insert_placeholder_89] =>
[:db_insert_placeholder_90] =>
[:db_insert_placeholder_91] =>
[:db_insert_placeholder_92] => 1781215200
[:db_insert_placeholder_93] =>
[:db_insert_placeholder_94] =>
[:db_insert_placeholder_95] =>
[:db_insert_placeholder_96] =>
[:db_insert_placeholder_97] =>
[:db_insert_placeholder_98] =>
[:db_insert_placeholder_99] =>
[:db_insert_placeholder_100] =>
[:db_insert_placeholder_101] =>
[:db_insert_placeholder_102] =>
[:db_insert_placeholder_103] =>
[:db_insert_placeholder_104] =>
[:db_insert_placeholder_105] =>
[:db_insert_placeholder_106] =>
[:db_insert_placeholder_107] =>
[:db_insert_placeholder_108] =>
[:db_insert_placeholder_109] =>
[:db_insert_placeholder_110] =>
[:db_insert_placeholder_111] =>
[:db_insert_placeholder_112] =>
[:db_insert_placeholder_113] =>
[:db_insert_placeholder_114] =>
[:db_insert_placeholder_115] =>
[:db_insert_placeholder_116] =>
[:db_insert_placeholder_117] => 149496801
[:db_insert_placeholder_118] => 1781587210
[:db_insert_placeholder_119] => 1781587210
[:db_insert_placeholder_120] =>
[:db_insert_placeholder_121] =>
[:db_insert_placeholder_122] =>
[:db_insert_placeholder_123] =>
[:db_insert_placeholder_124] =>
[:db_insert_placeholder_125] =>
[:db_insert_placeholder_126] =>
[:db_insert_placeholder_127] =>
[:db_insert_placeholder_128] =>
[:db_insert_placeholder_129] =>
[:db_insert_placeholder_130] =>
[:db_insert_placeholder_131] =>
)
(/var/www/html/web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php:817) |
| 19909988 |
Error |
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'maturitydate' at row 1: INSERT INTO "dp_product" ("product_id", "attribute_name", "class1_name_d", "class1_name_e", "class2_name_d", "class2_name_e", "class2_official_svsp_id", "class2_official_svsp_id_new", "class2_strike1_alias", "class2_strike2_alias", "class2_strike3_alias", "class2_strike4_alias", "coupon", "coupon_interest", "coupon_premium", "currency_tradingbased_short", "currency_trading_short", "earliestexercisedate", "exchange_name", "exercise_entitlestounit", "exercise_numberneeded", "factor", "feature_1_id", "feature_2_id", "feature_3_id", "feature_4_id", "feature_5_id", "feature_availability", "firstlistingdate", "isin", "isactivemanaged", "iscleanpriced", "iscollateralized", "ispercentage", "isquanto", "issueprice", "issuer_name", "issuer_short", "knock_date", "knock_status", "lasttradingdate", "management_fees", "maturitydate", "name_e", "nominalvalue", "participation_level", "payment_winscale_downside", "protection_level_percent", "quotes_lastmodifieddate", "ratio", "redemption_percent", "status", "style_short", "subscription_enddate", "symbol", "termsheet", "valuations_ask_size_average", "valuations_bid_size_average", "valuations_bonus_yield", "valuations_bonus_yield_pa", "valuations_break_even", "valuations_calcprice", "valuations_calcprice_strike", "valuations_calcprice_underlying", "valuations_daystomaturity", "valuations_delta", "valuations_discount_percent", "valuations_fair_value", "valuations_fair_value_gap", "valuations_fair_value_issuer", "valuations_gamma", "valuations_gearing", "valuations_implvola_ask", "valuations_implvola_bid", "valuations_implvola_calcprice", "valuations_implvola_change", "valuations_intrinsic_value", "valuations_lastmodifieddate", "valuations_leverage_percent", "valuations_liquidity_rating_code", "valuations_market_making_index", "valuations_moneyness", "valuations_outperformance_level", "valuations_premium", "valuations_premium_pa", "valuations_price_rating_code", "valuations_product_rating_code", "valuations_qqm_average_buy_volume", "valuations_qqm_average_buy_volume_price", "valuations_qqm_average_sell_volume", "valuations_qqm_average_sell_volume_price", "valuations_qqm_average_spread", "valuations_qqm_date", "valuations_qqm_last_best_ask_price", "valuations_qqm_last_best_ask_volume", "valuations_qqm_last_best_bid_price", "valuations_qqm_last_best_bid_volume", "valuations_qqm_quotes_availability_ratio", "valuations_qqm_spreads_availability_ratio", "valuations_ratings_risk_classcode", "valuations_ratings_risk_value", "valuations_redemption_max", "valuations_rho", "valuations_sideward_yield", "valuations_sideward_yield_pa", "valuations_spread_average", "valuations_spread_homo", "valuations_spread_percent", "valuations_strikesensitivity", "valuations_theta_1day", "valuations_theta_7days", "valuations_timevalue", "valuations_turnover_chf_average", "valuations_underperformance_level", "valuations_vega", "valuations_yield_max", "valuations_yield_max_pa", "wkn", "created", "changed", "solid_valor", "solid_bc", "solid_bc_id", "solid_cc", "solid_cc_id", "fullquote_link", "solid_changed", "underlying_component_strike_1_isknocked", "underlying_component_strike_2_isknocked", "underlying_component_strike_3_isknocked", "underlying_component_strike_4_isknocked", "number_of_underlyings") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23, :db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27, :db_insert_placeholder_28, :db_insert_placeholder_29, :db_insert_placeholder_30, :db_insert_placeholder_31, :db_insert_placeholder_32, :db_insert_placeholder_33, :db_insert_placeholder_34, :db_insert_placeholder_35, :db_insert_placeholder_36, :db_insert_placeholder_37, :db_insert_placeholder_38, :db_insert_placeholder_39, :db_insert_placeholder_40, :db_insert_placeholder_41, :db_insert_placeholder_42, :db_insert_placeholder_43, :db_insert_placeholder_44, :db_insert_placeholder_45, :db_insert_placeholder_46, :db_insert_placeholder_47, :db_insert_placeholder_48, :db_insert_placeholder_49, :db_insert_placeholder_50, :db_insert_placeholder_51, :db_insert_placeholder_52, :db_insert_placeholder_53, :db_insert_placeholder_54, :db_insert_placeholder_55, :db_insert_placeholder_56, :db_insert_placeholder_57, :db_insert_placeholder_58, :db_insert_placeholder_59, :db_insert_placeholder_60, :db_insert_placeholder_61, :db_insert_placeholder_62, :db_insert_placeholder_63, :db_insert_placeholder_64, :db_insert_placeholder_65, :db_insert_placeholder_66, :db_insert_placeholder_67, :db_insert_placeholder_68, :db_insert_placeholder_69, :db_insert_placeholder_70, :db_insert_placeholder_71, :db_insert_placeholder_72, :db_insert_placeholder_73, :db_insert_placeholder_74, :db_insert_placeholder_75, :db_insert_placeholder_76, :db_insert_placeholder_77, :db_insert_placeholder_78, :db_insert_placeholder_79, :db_insert_placeholder_80, :db_insert_placeholder_81, :db_insert_placeholder_82, :db_insert_placeholder_83, :db_insert_placeholder_84, :db_insert_placeholder_85, :db_insert_placeholder_86, :db_insert_placeholder_87, :db_insert_placeholder_88, :db_insert_placeholder_89, :db_insert_placeholder_90, :db_insert_placeholder_91, :db_insert_placeholder_92, :db_insert_placeholder_93, :db_insert_placeholder_94, :db_insert_placeholder_95, :db_insert_placeholder_96, :db_insert_placeholder_97, :db_insert_placeholder_98, :db_insert_placeholder_99, :db_insert_placeholder_100, :db_insert_placeholder_101, :db_insert_placeholder_102, :db_insert_placeholder_103, :db_insert_placeholder_104, :db_insert_placeholder_105, :db_insert_placeholder_106, :db_insert_placeholder_107, :db_insert_placeholder_108, :db_insert_placeholder_109, :db_insert_placeholder_110, :db_insert_placeholder_111, :db_insert_placeholder_112, :db_insert_placeholder_113, :db_insert_placeholder_114, :db_insert_placeholder_115, :db_insert_placeholder_116, :db_insert_placeholder_117, :db_insert_placeholder_118, :db_insert_placeholder_119, :db_insert_placeholder_120, :db_insert_placeholder_121, :db_insert_placeholder_122, :db_insert_placeholder_123, :db_insert_placeholder_124, :db_insert_placeholder_125, :db_insert_placeholder_126, :db_insert_placeholder_127, :db_insert_placeholder_128, :db_insert_placeholder_129, :db_insert_placeholder_130, :db_insert_placeholder_131); Array
(
[:db_insert_placeholder_0] => 19909988
[:db_insert_placeholder_1] => Bear
[:db_insert_placeholder_2] => Kapitalschutzprodukte
[:db_insert_placeholder_3] => Capital Protection Products
[:db_insert_placeholder_4] => Kapitalschutz-Zertifikat mit Coupon
[:db_insert_placeholder_5] => Capital Protection Note with Coupon
[:db_insert_placeholder_6] => 460
[:db_insert_placeholder_7] => 1140
[:db_insert_placeholder_8] =>
[:db_insert_placeholder_9] =>
[:db_insert_placeholder_10] =>
[:db_insert_placeholder_11] =>
[:db_insert_placeholder_12] =>
[:db_insert_placeholder_13] =>
[:db_insert_placeholder_14] =>
[:db_insert_placeholder_15] => EUR
[:db_insert_placeholder_16] => PCT
[:db_insert_placeholder_17] => 2149891200
[:db_insert_placeholder_18] => SIX Swiss Exchange - Structured Products
[:db_insert_placeholder_19] =>
[:db_insert_placeholder_20] =>
[:db_insert_placeholder_21] =>
[:db_insert_placeholder_22] => 9
[:db_insert_placeholder_23] => 2
[:db_insert_placeholder_24] =>
[:db_insert_placeholder_25] =>
[:db_insert_placeholder_26] =>
[:db_insert_placeholder_27] => 1
[:db_insert_placeholder_28] => 1771196400
[:db_insert_placeholder_29] => FR0014015NI8
[:db_insert_placeholder_30] => 0
[:db_insert_placeholder_31] => 0
[:db_insert_placeholder_32] => 0
[:db_insert_placeholder_33] => 1
[:db_insert_placeholder_34] =>
[:db_insert_placeholder_35] => 1
[:db_insert_placeholder_36] => Royal Bank of Canada
[:db_insert_placeholder_37] => RBC
[:db_insert_placeholder_38] =>
[:db_insert_placeholder_39] =>
[:db_insert_placeholder_40] => 2149891200
[:db_insert_placeholder_41] => 0
[:db_insert_placeholder_42] => 2149887600
[:db_insert_placeholder_43] => Digital Coupon Notes
[:db_insert_placeholder_44] => 1000
[:db_insert_placeholder_45] =>
[:db_insert_placeholder_46] =>
[:db_insert_placeholder_47] => 1
[:db_insert_placeholder_48] =>
[:db_insert_placeholder_49] =>
[:db_insert_placeholder_50] =>
[:db_insert_placeholder_51] => 1
[:db_insert_placeholder_52] => A
[:db_insert_placeholder_53] =>
[:db_insert_placeholder_54] => AAQ4SP
[:db_insert_placeholder_55] =>
[:db_insert_placeholder_56] =>
[:db_insert_placeholder_57] =>
[:db_insert_placeholder_58] =>
[:db_insert_placeholder_59] =>
[:db_insert_placeholder_60] =>
[:db_insert_placeholder_61] =>
[:db_insert_placeholder_62] =>
[:db_insert_placeholder_63] => 3.3699999
[:db_insert_placeholder_64] => 4264
[:db_insert_placeholder_65] =>
[:db_insert_placeholder_66] =>
[:db_insert_placeholder_67] =>
[:db_insert_placeholder_68] =>
[:db_insert_placeholder_69] =>
[:db_insert_placeholder_70] =>
[:db_insert_placeholder_71] =>
[:db_insert_placeholder_72] =>
[:db_insert_placeholder_73] =>
[:db_insert_placeholder_74] =>
[:db_insert_placeholder_75] =>
[:db_insert_placeholder_76] =>
[:db_insert_placeholder_77] =>
[:db_insert_placeholder_78] =>
[:db_insert_placeholder_79] =>
[:db_insert_placeholder_80] =>
[:db_insert_placeholder_81] =>
[:db_insert_placeholder_82] =>
[:db_insert_placeholder_83] =>
[:db_insert_placeholder_84] =>
[:db_insert_placeholder_85] =>
[:db_insert_placeholder_86] =>
[:db_insert_placeholder_87] =>
[:db_insert_placeholder_88] =>
[:db_insert_placeholder_89] =>
[:db_insert_placeholder_90] =>
[:db_insert_placeholder_91] =>
[:db_insert_placeholder_92] => 1781215200
[:db_insert_placeholder_93] =>
[:db_insert_placeholder_94] =>
[:db_insert_placeholder_95] =>
[:db_insert_placeholder_96] =>
[:db_insert_placeholder_97] =>
[:db_insert_placeholder_98] =>
[:db_insert_placeholder_99] =>
[:db_insert_placeholder_100] =>
[:db_insert_placeholder_101] =>
[:db_insert_placeholder_102] =>
[:db_insert_placeholder_103] =>
[:db_insert_placeholder_104] =>
[:db_insert_placeholder_105] =>
[:db_insert_placeholder_106] =>
[:db_insert_placeholder_107] =>
[:db_insert_placeholder_108] =>
[:db_insert_placeholder_109] =>
[:db_insert_placeholder_110] =>
[:db_insert_placeholder_111] =>
[:db_insert_placeholder_112] =>
[:db_insert_placeholder_113] =>
[:db_insert_placeholder_114] =>
[:db_insert_placeholder_115] =>
[:db_insert_placeholder_116] =>
[:db_insert_placeholder_117] => 149496802
[:db_insert_placeholder_118] => 1781587210
[:db_insert_placeholder_119] => 1781587210
[:db_insert_placeholder_120] =>
[:db_insert_placeholder_121] =>
[:db_insert_placeholder_122] =>
[:db_insert_placeholder_123] =>
[:db_insert_placeholder_124] =>
[:db_insert_placeholder_125] =>
[:db_insert_placeholder_126] =>
[:db_insert_placeholder_127] =>
[:db_insert_placeholder_128] =>
[:db_insert_placeholder_129] =>
[:db_insert_placeholder_130] =>
[:db_insert_placeholder_131] =>
)
(/var/www/html/web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php:817) |
| 20034561 |
Error |
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'maturitydate' at row 1: INSERT INTO "dp_product" ("product_id", "attribute_name", "class1_name_d", "class1_name_e", "class2_name_d", "class2_name_e", "class2_official_svsp_id", "class2_official_svsp_id_new", "class2_strike1_alias", "class2_strike2_alias", "class2_strike3_alias", "class2_strike4_alias", "coupon", "coupon_interest", "coupon_premium", "currency_tradingbased_short", "currency_trading_short", "earliestexercisedate", "exchange_name", "exercise_entitlestounit", "exercise_numberneeded", "factor", "feature_1_id", "feature_2_id", "feature_3_id", "feature_4_id", "feature_5_id", "feature_availability", "firstlistingdate", "isin", "isactivemanaged", "iscleanpriced", "iscollateralized", "ispercentage", "isquanto", "issueprice", "issuer_name", "issuer_short", "knock_date", "knock_status", "lasttradingdate", "management_fees", "maturitydate", "name_e", "nominalvalue", "participation_level", "payment_winscale_downside", "protection_level_percent", "quotes_lastmodifieddate", "ratio", "redemption_percent", "status", "style_short", "subscription_enddate", "symbol", "termsheet", "valuations_ask_size_average", "valuations_bid_size_average", "valuations_bonus_yield", "valuations_bonus_yield_pa", "valuations_break_even", "valuations_calcprice", "valuations_calcprice_strike", "valuations_calcprice_underlying", "valuations_daystomaturity", "valuations_delta", "valuations_discount_percent", "valuations_fair_value", "valuations_fair_value_gap", "valuations_fair_value_issuer", "valuations_gamma", "valuations_gearing", "valuations_implvola_ask", "valuations_implvola_bid", "valuations_implvola_calcprice", "valuations_implvola_change", "valuations_intrinsic_value", "valuations_lastmodifieddate", "valuations_leverage_percent", "valuations_liquidity_rating_code", "valuations_market_making_index", "valuations_moneyness", "valuations_outperformance_level", "valuations_premium", "valuations_premium_pa", "valuations_price_rating_code", "valuations_product_rating_code", "valuations_qqm_average_buy_volume", "valuations_qqm_average_buy_volume_price", "valuations_qqm_average_sell_volume", "valuations_qqm_average_sell_volume_price", "valuations_qqm_average_spread", "valuations_qqm_date", "valuations_qqm_last_best_ask_price", "valuations_qqm_last_best_ask_volume", "valuations_qqm_last_best_bid_price", "valuations_qqm_last_best_bid_volume", "valuations_qqm_quotes_availability_ratio", "valuations_qqm_spreads_availability_ratio", "valuations_ratings_risk_classcode", "valuations_ratings_risk_value", "valuations_redemption_max", "valuations_rho", "valuations_sideward_yield", "valuations_sideward_yield_pa", "valuations_spread_average", "valuations_spread_homo", "valuations_spread_percent", "valuations_strikesensitivity", "valuations_theta_1day", "valuations_theta_7days", "valuations_timevalue", "valuations_turnover_chf_average", "valuations_underperformance_level", "valuations_vega", "valuations_yield_max", "valuations_yield_max_pa", "wkn", "created", "changed", "solid_valor", "solid_bc", "solid_bc_id", "solid_cc", "solid_cc_id", "fullquote_link", "solid_changed", "underlying_component_strike_1_isknocked", "underlying_component_strike_2_isknocked", "underlying_component_strike_3_isknocked", "underlying_component_strike_4_isknocked", "number_of_underlyings") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23, :db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27, :db_insert_placeholder_28, :db_insert_placeholder_29, :db_insert_placeholder_30, :db_insert_placeholder_31, :db_insert_placeholder_32, :db_insert_placeholder_33, :db_insert_placeholder_34, :db_insert_placeholder_35, :db_insert_placeholder_36, :db_insert_placeholder_37, :db_insert_placeholder_38, :db_insert_placeholder_39, :db_insert_placeholder_40, :db_insert_placeholder_41, :db_insert_placeholder_42, :db_insert_placeholder_43, :db_insert_placeholder_44, :db_insert_placeholder_45, :db_insert_placeholder_46, :db_insert_placeholder_47, :db_insert_placeholder_48, :db_insert_placeholder_49, :db_insert_placeholder_50, :db_insert_placeholder_51, :db_insert_placeholder_52, :db_insert_placeholder_53, :db_insert_placeholder_54, :db_insert_placeholder_55, :db_insert_placeholder_56, :db_insert_placeholder_57, :db_insert_placeholder_58, :db_insert_placeholder_59, :db_insert_placeholder_60, :db_insert_placeholder_61, :db_insert_placeholder_62, :db_insert_placeholder_63, :db_insert_placeholder_64, :db_insert_placeholder_65, :db_insert_placeholder_66, :db_insert_placeholder_67, :db_insert_placeholder_68, :db_insert_placeholder_69, :db_insert_placeholder_70, :db_insert_placeholder_71, :db_insert_placeholder_72, :db_insert_placeholder_73, :db_insert_placeholder_74, :db_insert_placeholder_75, :db_insert_placeholder_76, :db_insert_placeholder_77, :db_insert_placeholder_78, :db_insert_placeholder_79, :db_insert_placeholder_80, :db_insert_placeholder_81, :db_insert_placeholder_82, :db_insert_placeholder_83, :db_insert_placeholder_84, :db_insert_placeholder_85, :db_insert_placeholder_86, :db_insert_placeholder_87, :db_insert_placeholder_88, :db_insert_placeholder_89, :db_insert_placeholder_90, :db_insert_placeholder_91, :db_insert_placeholder_92, :db_insert_placeholder_93, :db_insert_placeholder_94, :db_insert_placeholder_95, :db_insert_placeholder_96, :db_insert_placeholder_97, :db_insert_placeholder_98, :db_insert_placeholder_99, :db_insert_placeholder_100, :db_insert_placeholder_101, :db_insert_placeholder_102, :db_insert_placeholder_103, :db_insert_placeholder_104, :db_insert_placeholder_105, :db_insert_placeholder_106, :db_insert_placeholder_107, :db_insert_placeholder_108, :db_insert_placeholder_109, :db_insert_placeholder_110, :db_insert_placeholder_111, :db_insert_placeholder_112, :db_insert_placeholder_113, :db_insert_placeholder_114, :db_insert_placeholder_115, :db_insert_placeholder_116, :db_insert_placeholder_117, :db_insert_placeholder_118, :db_insert_placeholder_119, :db_insert_placeholder_120, :db_insert_placeholder_121, :db_insert_placeholder_122, :db_insert_placeholder_123, :db_insert_placeholder_124, :db_insert_placeholder_125, :db_insert_placeholder_126, :db_insert_placeholder_127, :db_insert_placeholder_128, :db_insert_placeholder_129, :db_insert_placeholder_130, :db_insert_placeholder_131); Array
(
[:db_insert_placeholder_0] => 20034561
[:db_insert_placeholder_1] => Bear
[:db_insert_placeholder_2] => Kapitalschutzprodukte
[:db_insert_placeholder_3] => Capital Protection Products
[:db_insert_placeholder_4] => Kapitalschutz-Zertifikat mit Coupon
[:db_insert_placeholder_5] => Capital Protection Note with Coupon
[:db_insert_placeholder_6] => 210
[:db_insert_placeholder_7] => 1140
[:db_insert_placeholder_8] =>
[:db_insert_placeholder_9] =>
[:db_insert_placeholder_10] =>
[:db_insert_placeholder_11] =>
[:db_insert_placeholder_12] =>
[:db_insert_placeholder_13] =>
[:db_insert_placeholder_14] =>
[:db_insert_placeholder_15] => EUR
[:db_insert_placeholder_16] => PCT
[:db_insert_placeholder_17] => 2246140800
[:db_insert_placeholder_18] => SIX Swiss Exchange - Structured Products
[:db_insert_placeholder_19] =>
[:db_insert_placeholder_20] =>
[:db_insert_placeholder_21] =>
[:db_insert_placeholder_22] => 5
[:db_insert_placeholder_23] => 2
[:db_insert_placeholder_24] =>
[:db_insert_placeholder_25] =>
[:db_insert_placeholder_26] =>
[:db_insert_placeholder_27] => 1
[:db_insert_placeholder_28] => 1772751600
[:db_insert_placeholder_29] => FR0014015SD8
[:db_insert_placeholder_30] => 0
[:db_insert_placeholder_31] => 0
[:db_insert_placeholder_32] => 0
[:db_insert_placeholder_33] => 1
[:db_insert_placeholder_34] =>
[:db_insert_placeholder_35] => 1
[:db_insert_placeholder_36] => Royal Bank of Canada
[:db_insert_placeholder_37] => RBC
[:db_insert_placeholder_38] =>
[:db_insert_placeholder_39] =>
[:db_insert_placeholder_40] => 2246140800
[:db_insert_placeholder_41] => 0
[:db_insert_placeholder_42] => 2246137200
[:db_insert_placeholder_43] => Phoenix Notes
[:db_insert_placeholder_44] => 1000
[:db_insert_placeholder_45] =>
[:db_insert_placeholder_46] =>
[:db_insert_placeholder_47] => 1
[:db_insert_placeholder_48] =>
[:db_insert_placeholder_49] =>
[:db_insert_placeholder_50] =>
[:db_insert_placeholder_51] => 1
[:db_insert_placeholder_52] => A
[:db_insert_placeholder_53] =>
[:db_insert_placeholder_54] => AAR1SP
[:db_insert_placeholder_55] =>
[:db_insert_placeholder_56] =>
[:db_insert_placeholder_57] =>
[:db_insert_placeholder_58] =>
[:db_insert_placeholder_59] =>
[:db_insert_placeholder_60] =>
[:db_insert_placeholder_61] =>
[:db_insert_placeholder_62] =>
[:db_insert_placeholder_63] =>
[:db_insert_placeholder_64] => 5378
[:db_insert_placeholder_65] =>
[:db_insert_placeholder_66] =>
[:db_insert_placeholder_67] =>
[:db_insert_placeholder_68] =>
[:db_insert_placeholder_69] =>
[:db_insert_placeholder_70] =>
[:db_insert_placeholder_71] =>
[:db_insert_placeholder_72] =>
[:db_insert_placeholder_73] =>
[:db_insert_placeholder_74] =>
[:db_insert_placeholder_75] =>
[:db_insert_placeholder_76] =>
[:db_insert_placeholder_77] =>
[:db_insert_placeholder_78] =>
[:db_insert_placeholder_79] =>
[:db_insert_placeholder_80] =>
[:db_insert_placeholder_81] =>
[:db_insert_placeholder_82] =>
[:db_insert_placeholder_83] =>
[:db_insert_placeholder_84] =>
[:db_insert_placeholder_85] =>
[:db_insert_placeholder_86] =>
[:db_insert_placeholder_87] =>
[:db_insert_placeholder_88] =>
[:db_insert_placeholder_89] =>
[:db_insert_placeholder_90] =>
[:db_insert_placeholder_91] =>
[:db_insert_placeholder_92] => 1781215200
[:db_insert_placeholder_93] =>
[:db_insert_placeholder_94] =>
[:db_insert_placeholder_95] =>
[:db_insert_placeholder_96] =>
[:db_insert_placeholder_97] =>
[:db_insert_placeholder_98] =>
[:db_insert_placeholder_99] =>
[:db_insert_placeholder_100] =>
[:db_insert_placeholder_101] =>
[:db_insert_placeholder_102] =>
[:db_insert_placeholder_103] =>
[:db_insert_placeholder_104] =>
[:db_insert_placeholder_105] =>
[:db_insert_placeholder_106] =>
[:db_insert_placeholder_107] =>
[:db_insert_placeholder_108] =>
[:db_insert_placeholder_109] =>
[:db_insert_placeholder_110] =>
[:db_insert_placeholder_111] =>
[:db_insert_placeholder_112] =>
[:db_insert_placeholder_113] =>
[:db_insert_placeholder_114] =>
[:db_insert_placeholder_115] =>
[:db_insert_placeholder_116] =>
[:db_insert_placeholder_117] => 149496811
[:db_insert_placeholder_118] => 1781587210
[:db_insert_placeholder_119] => 1781587210
[:db_insert_placeholder_120] =>
[:db_insert_placeholder_121] =>
[:db_insert_placeholder_122] =>
[:db_insert_placeholder_123] =>
[:db_insert_placeholder_124] =>
[:db_insert_placeholder_125] =>
[:db_insert_placeholder_126] =>
[:db_insert_placeholder_127] =>
[:db_insert_placeholder_128] =>
[:db_insert_placeholder_129] =>
[:db_insert_placeholder_130] =>
[:db_insert_placeholder_131] =>
)
(/var/www/html/web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php:817) |
| 20170112 |
Error |
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'maturitydate' at row 1: INSERT INTO "dp_product" ("product_id", "attribute_name", "class1_name_d", "class1_name_e", "class2_name_d", "class2_name_e", "class2_official_svsp_id", "class2_official_svsp_id_new", "class2_strike1_alias", "class2_strike2_alias", "class2_strike3_alias", "class2_strike4_alias", "coupon", "coupon_interest", "coupon_premium", "currency_tradingbased_short", "currency_trading_short", "earliestexercisedate", "exchange_name", "exercise_entitlestounit", "exercise_numberneeded", "factor", "feature_1_id", "feature_2_id", "feature_3_id", "feature_4_id", "feature_5_id", "feature_availability", "firstlistingdate", "isin", "isactivemanaged", "iscleanpriced", "iscollateralized", "ispercentage", "isquanto", "issueprice", "issuer_name", "issuer_short", "knock_date", "knock_status", "lasttradingdate", "management_fees", "maturitydate", "name_e", "nominalvalue", "participation_level", "payment_winscale_downside", "protection_level_percent", "quotes_lastmodifieddate", "ratio", "redemption_percent", "status", "style_short", "subscription_enddate", "symbol", "termsheet", "valuations_ask_size_average", "valuations_bid_size_average", "valuations_bonus_yield", "valuations_bonus_yield_pa", "valuations_break_even", "valuations_calcprice", "valuations_calcprice_strike", "valuations_calcprice_underlying", "valuations_daystomaturity", "valuations_delta", "valuations_discount_percent", "valuations_fair_value", "valuations_fair_value_gap", "valuations_fair_value_issuer", "valuations_gamma", "valuations_gearing", "valuations_implvola_ask", "valuations_implvola_bid", "valuations_implvola_calcprice", "valuations_implvola_change", "valuations_intrinsic_value", "valuations_lastmodifieddate", "valuations_leverage_percent", "valuations_liquidity_rating_code", "valuations_market_making_index", "valuations_moneyness", "valuations_outperformance_level", "valuations_premium", "valuations_premium_pa", "valuations_price_rating_code", "valuations_product_rating_code", "valuations_qqm_average_buy_volume", "valuations_qqm_average_buy_volume_price", "valuations_qqm_average_sell_volume", "valuations_qqm_average_sell_volume_price", "valuations_qqm_average_spread", "valuations_qqm_date", "valuations_qqm_last_best_ask_price", "valuations_qqm_last_best_ask_volume", "valuations_qqm_last_best_bid_price", "valuations_qqm_last_best_bid_volume", "valuations_qqm_quotes_availability_ratio", "valuations_qqm_spreads_availability_ratio", "valuations_ratings_risk_classcode", "valuations_ratings_risk_value", "valuations_redemption_max", "valuations_rho", "valuations_sideward_yield", "valuations_sideward_yield_pa", "valuations_spread_average", "valuations_spread_homo", "valuations_spread_percent", "valuations_strikesensitivity", "valuations_theta_1day", "valuations_theta_7days", "valuations_timevalue", "valuations_turnover_chf_average", "valuations_underperformance_level", "valuations_vega", "valuations_yield_max", "valuations_yield_max_pa", "wkn", "created", "changed", "solid_valor", "solid_bc", "solid_bc_id", "solid_cc", "solid_cc_id", "fullquote_link", "solid_changed", "underlying_component_strike_1_isknocked", "underlying_component_strike_2_isknocked", "underlying_component_strike_3_isknocked", "underlying_component_strike_4_isknocked", "number_of_underlyings") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23, :db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27, :db_insert_placeholder_28, :db_insert_placeholder_29, :db_insert_placeholder_30, :db_insert_placeholder_31, :db_insert_placeholder_32, :db_insert_placeholder_33, :db_insert_placeholder_34, :db_insert_placeholder_35, :db_insert_placeholder_36, :db_insert_placeholder_37, :db_insert_placeholder_38, :db_insert_placeholder_39, :db_insert_placeholder_40, :db_insert_placeholder_41, :db_insert_placeholder_42, :db_insert_placeholder_43, :db_insert_placeholder_44, :db_insert_placeholder_45, :db_insert_placeholder_46, :db_insert_placeholder_47, :db_insert_placeholder_48, :db_insert_placeholder_49, :db_insert_placeholder_50, :db_insert_placeholder_51, :db_insert_placeholder_52, :db_insert_placeholder_53, :db_insert_placeholder_54, :db_insert_placeholder_55, :db_insert_placeholder_56, :db_insert_placeholder_57, :db_insert_placeholder_58, :db_insert_placeholder_59, :db_insert_placeholder_60, :db_insert_placeholder_61, :db_insert_placeholder_62, :db_insert_placeholder_63, :db_insert_placeholder_64, :db_insert_placeholder_65, :db_insert_placeholder_66, :db_insert_placeholder_67, :db_insert_placeholder_68, :db_insert_placeholder_69, :db_insert_placeholder_70, :db_insert_placeholder_71, :db_insert_placeholder_72, :db_insert_placeholder_73, :db_insert_placeholder_74, :db_insert_placeholder_75, :db_insert_placeholder_76, :db_insert_placeholder_77, :db_insert_placeholder_78, :db_insert_placeholder_79, :db_insert_placeholder_80, :db_insert_placeholder_81, :db_insert_placeholder_82, :db_insert_placeholder_83, :db_insert_placeholder_84, :db_insert_placeholder_85, :db_insert_placeholder_86, :db_insert_placeholder_87, :db_insert_placeholder_88, :db_insert_placeholder_89, :db_insert_placeholder_90, :db_insert_placeholder_91, :db_insert_placeholder_92, :db_insert_placeholder_93, :db_insert_placeholder_94, :db_insert_placeholder_95, :db_insert_placeholder_96, :db_insert_placeholder_97, :db_insert_placeholder_98, :db_insert_placeholder_99, :db_insert_placeholder_100, :db_insert_placeholder_101, :db_insert_placeholder_102, :db_insert_placeholder_103, :db_insert_placeholder_104, :db_insert_placeholder_105, :db_insert_placeholder_106, :db_insert_placeholder_107, :db_insert_placeholder_108, :db_insert_placeholder_109, :db_insert_placeholder_110, :db_insert_placeholder_111, :db_insert_placeholder_112, :db_insert_placeholder_113, :db_insert_placeholder_114, :db_insert_placeholder_115, :db_insert_placeholder_116, :db_insert_placeholder_117, :db_insert_placeholder_118, :db_insert_placeholder_119, :db_insert_placeholder_120, :db_insert_placeholder_121, :db_insert_placeholder_122, :db_insert_placeholder_123, :db_insert_placeholder_124, :db_insert_placeholder_125, :db_insert_placeholder_126, :db_insert_placeholder_127, :db_insert_placeholder_128, :db_insert_placeholder_129, :db_insert_placeholder_130, :db_insert_placeholder_131); Array
(
[:db_insert_placeholder_0] => 20170112
[:db_insert_placeholder_1] => Bear
[:db_insert_placeholder_2] => Kapitalschutzprodukte
[:db_insert_placeholder_3] => Capital Protection Products
[:db_insert_placeholder_4] => Kapitalschutz-Zertifikat mit Coupon
[:db_insert_placeholder_5] => Capital Protection Note with Coupon
[:db_insert_placeholder_6] => 210
[:db_insert_placeholder_7] => 1140
[:db_insert_placeholder_8] =>
[:db_insert_placeholder_9] =>
[:db_insert_placeholder_10] =>
[:db_insert_placeholder_11] =>
[:db_insert_placeholder_12] =>
[:db_insert_placeholder_13] =>
[:db_insert_placeholder_14] =>
[:db_insert_placeholder_15] => EUR
[:db_insert_placeholder_16] => PCT
[:db_insert_placeholder_17] => 2154902400
[:db_insert_placeholder_18] => SIX Swiss Exchange - Structured Products
[:db_insert_placeholder_19] =>
[:db_insert_placeholder_20] =>
[:db_insert_placeholder_21] =>
[:db_insert_placeholder_22] => 5
[:db_insert_placeholder_23] => 2
[:db_insert_placeholder_24] =>
[:db_insert_placeholder_25] =>
[:db_insert_placeholder_26] =>
[:db_insert_placeholder_27] => 1
[:db_insert_placeholder_28] => 1776204000
[:db_insert_placeholder_29] => FR0014016036
[:db_insert_placeholder_30] => 0
[:db_insert_placeholder_31] => 0
[:db_insert_placeholder_32] => 0
[:db_insert_placeholder_33] => 1
[:db_insert_placeholder_34] =>
[:db_insert_placeholder_35] => 1
[:db_insert_placeholder_36] => Royal Bank of Canada
[:db_insert_placeholder_37] => RBC
[:db_insert_placeholder_38] =>
[:db_insert_placeholder_39] =>
[:db_insert_placeholder_40] => 2154902400
[:db_insert_placeholder_41] => 0
[:db_insert_placeholder_42] => 2154895200
[:db_insert_placeholder_43] => Phoenix Notes
[:db_insert_placeholder_44] => 1000
[:db_insert_placeholder_45] =>
[:db_insert_placeholder_46] =>
[:db_insert_placeholder_47] => 1
[:db_insert_placeholder_48] =>
[:db_insert_placeholder_49] =>
[:db_insert_placeholder_50] =>
[:db_insert_placeholder_51] => 1
[:db_insert_placeholder_52] => A
[:db_insert_placeholder_53] =>
[:db_insert_placeholder_54] => AASMSP
[:db_insert_placeholder_55] =>
[:db_insert_placeholder_56] =>
[:db_insert_placeholder_57] =>
[:db_insert_placeholder_58] =>
[:db_insert_placeholder_59] =>
[:db_insert_placeholder_60] =>
[:db_insert_placeholder_61] =>
[:db_insert_placeholder_62] =>
[:db_insert_placeholder_63] =>
[:db_insert_placeholder_64] => 4322
[:db_insert_placeholder_65] =>
[:db_insert_placeholder_66] =>
[:db_insert_placeholder_67] =>
[:db_insert_placeholder_68] =>
[:db_insert_placeholder_69] =>
[:db_insert_placeholder_70] =>
[:db_insert_placeholder_71] =>
[:db_insert_placeholder_72] =>
[:db_insert_placeholder_73] =>
[:db_insert_placeholder_74] =>
[:db_insert_placeholder_75] =>
[:db_insert_placeholder_76] =>
[:db_insert_placeholder_77] =>
[:db_insert_placeholder_78] =>
[:db_insert_placeholder_79] =>
[:db_insert_placeholder_80] =>
[:db_insert_placeholder_81] =>
[:db_insert_placeholder_82] =>
[:db_insert_placeholder_83] =>
[:db_insert_placeholder_84] =>
[:db_insert_placeholder_85] =>
[:db_insert_placeholder_86] =>
[:db_insert_placeholder_87] =>
[:db_insert_placeholder_88] =>
[:db_insert_placeholder_89] =>
[:db_insert_placeholder_90] =>
[:db_insert_placeholder_91] =>
[:db_insert_placeholder_92] => 1781215200
[:db_insert_placeholder_93] =>
[:db_insert_placeholder_94] =>
[:db_insert_placeholder_95] =>
[:db_insert_placeholder_96] =>
[:db_insert_placeholder_97] =>
[:db_insert_placeholder_98] =>
[:db_insert_placeholder_99] =>
[:db_insert_placeholder_100] =>
[:db_insert_placeholder_101] =>
[:db_insert_placeholder_102] =>
[:db_insert_placeholder_103] =>
[:db_insert_placeholder_104] =>
[:db_insert_placeholder_105] =>
[:db_insert_placeholder_106] =>
[:db_insert_placeholder_107] =>
[:db_insert_placeholder_108] =>
[:db_insert_placeholder_109] =>
[:db_insert_placeholder_110] =>
[:db_insert_placeholder_111] =>
[:db_insert_placeholder_112] =>
[:db_insert_placeholder_113] =>
[:db_insert_placeholder_114] =>
[:db_insert_placeholder_115] =>
[:db_insert_placeholder_116] =>
[:db_insert_placeholder_117] => 149496835
[:db_insert_placeholder_118] => 1781587210
[:db_insert_placeholder_119] => 1781587210
[:db_insert_placeholder_120] =>
[:db_insert_placeholder_121] =>
[:db_insert_placeholder_122] =>
[:db_insert_placeholder_123] =>
[:db_insert_placeholder_124] =>
[:db_insert_placeholder_125] =>
[:db_insert_placeholder_126] =>
[:db_insert_placeholder_127] =>
[:db_insert_placeholder_128] =>
[:db_insert_placeholder_129] =>
[:db_insert_placeholder_130] =>
[:db_insert_placeholder_131] =>
)
(/var/www/html/web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php:817) |
| 20883479 |
Error |
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'maturitydate' at row 1: INSERT INTO "dp_product" ("product_id", "attribute_name", "class1_name_d", "class1_name_e", "class2_name_d", "class2_name_e", "class2_official_svsp_id", "class2_official_svsp_id_new", "class2_strike1_alias", "class2_strike2_alias", "class2_strike3_alias", "class2_strike4_alias", "coupon", "coupon_interest", "coupon_premium", "currency_tradingbased_short", "currency_trading_short", "earliestexercisedate", "exchange_name", "exercise_entitlestounit", "exercise_numberneeded", "factor", "feature_1_id", "feature_2_id", "feature_3_id", "feature_4_id", "feature_5_id", "feature_availability", "firstlistingdate", "isin", "isactivemanaged", "iscleanpriced", "iscollateralized", "ispercentage", "isquanto", "issueprice", "issuer_name", "issuer_short", "knock_date", "knock_status", "lasttradingdate", "management_fees", "maturitydate", "name_e", "nominalvalue", "participation_level", "payment_winscale_downside", "protection_level_percent", "quotes_lastmodifieddate", "ratio", "redemption_percent", "status", "style_short", "subscription_enddate", "symbol", "termsheet", "valuations_ask_size_average", "valuations_bid_size_average", "valuations_bonus_yield", "valuations_bonus_yield_pa", "valuations_break_even", "valuations_calcprice", "valuations_calcprice_strike", "valuations_calcprice_underlying", "valuations_daystomaturity", "valuations_delta", "valuations_discount_percent", "valuations_fair_value", "valuations_fair_value_gap", "valuations_fair_value_issuer", "valuations_gamma", "valuations_gearing", "valuations_implvola_ask", "valuations_implvola_bid", "valuations_implvola_calcprice", "valuations_implvola_change", "valuations_intrinsic_value", "valuations_lastmodifieddate", "valuations_leverage_percent", "valuations_liquidity_rating_code", "valuations_market_making_index", "valuations_moneyness", "valuations_outperformance_level", "valuations_premium", "valuations_premium_pa", "valuations_price_rating_code", "valuations_product_rating_code", "valuations_qqm_average_buy_volume", "valuations_qqm_average_buy_volume_price", "valuations_qqm_average_sell_volume", "valuations_qqm_average_sell_volume_price", "valuations_qqm_average_spread", "valuations_qqm_date", "valuations_qqm_last_best_ask_price", "valuations_qqm_last_best_ask_volume", "valuations_qqm_last_best_bid_price", "valuations_qqm_last_best_bid_volume", "valuations_qqm_quotes_availability_ratio", "valuations_qqm_spreads_availability_ratio", "valuations_ratings_risk_classcode", "valuations_ratings_risk_value", "valuations_redemption_max", "valuations_rho", "valuations_sideward_yield", "valuations_sideward_yield_pa", "valuations_spread_average", "valuations_spread_homo", "valuations_spread_percent", "valuations_strikesensitivity", "valuations_theta_1day", "valuations_theta_7days", "valuations_timevalue", "valuations_turnover_chf_average", "valuations_underperformance_level", "valuations_vega", "valuations_yield_max", "valuations_yield_max_pa", "wkn", "created", "changed", "solid_valor", "solid_bc", "solid_bc_id", "solid_cc", "solid_cc_id", "fullquote_link", "solid_changed", "underlying_component_strike_1_isknocked", "underlying_component_strike_2_isknocked", "underlying_component_strike_3_isknocked", "underlying_component_strike_4_isknocked", "number_of_underlyings") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23, :db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27, :db_insert_placeholder_28, :db_insert_placeholder_29, :db_insert_placeholder_30, :db_insert_placeholder_31, :db_insert_placeholder_32, :db_insert_placeholder_33, :db_insert_placeholder_34, :db_insert_placeholder_35, :db_insert_placeholder_36, :db_insert_placeholder_37, :db_insert_placeholder_38, :db_insert_placeholder_39, :db_insert_placeholder_40, :db_insert_placeholder_41, :db_insert_placeholder_42, :db_insert_placeholder_43, :db_insert_placeholder_44, :db_insert_placeholder_45, :db_insert_placeholder_46, :db_insert_placeholder_47, :db_insert_placeholder_48, :db_insert_placeholder_49, :db_insert_placeholder_50, :db_insert_placeholder_51, :db_insert_placeholder_52, :db_insert_placeholder_53, :db_insert_placeholder_54, :db_insert_placeholder_55, :db_insert_placeholder_56, :db_insert_placeholder_57, :db_insert_placeholder_58, :db_insert_placeholder_59, :db_insert_placeholder_60, :db_insert_placeholder_61, :db_insert_placeholder_62, :db_insert_placeholder_63, :db_insert_placeholder_64, :db_insert_placeholder_65, :db_insert_placeholder_66, :db_insert_placeholder_67, :db_insert_placeholder_68, :db_insert_placeholder_69, :db_insert_placeholder_70, :db_insert_placeholder_71, :db_insert_placeholder_72, :db_insert_placeholder_73, :db_insert_placeholder_74, :db_insert_placeholder_75, :db_insert_placeholder_76, :db_insert_placeholder_77, :db_insert_placeholder_78, :db_insert_placeholder_79, :db_insert_placeholder_80, :db_insert_placeholder_81, :db_insert_placeholder_82, :db_insert_placeholder_83, :db_insert_placeholder_84, :db_insert_placeholder_85, :db_insert_placeholder_86, :db_insert_placeholder_87, :db_insert_placeholder_88, :db_insert_placeholder_89, :db_insert_placeholder_90, :db_insert_placeholder_91, :db_insert_placeholder_92, :db_insert_placeholder_93, :db_insert_placeholder_94, :db_insert_placeholder_95, :db_insert_placeholder_96, :db_insert_placeholder_97, :db_insert_placeholder_98, :db_insert_placeholder_99, :db_insert_placeholder_100, :db_insert_placeholder_101, :db_insert_placeholder_102, :db_insert_placeholder_103, :db_insert_placeholder_104, :db_insert_placeholder_105, :db_insert_placeholder_106, :db_insert_placeholder_107, :db_insert_placeholder_108, :db_insert_placeholder_109, :db_insert_placeholder_110, :db_insert_placeholder_111, :db_insert_placeholder_112, :db_insert_placeholder_113, :db_insert_placeholder_114, :db_insert_placeholder_115, :db_insert_placeholder_116, :db_insert_placeholder_117, :db_insert_placeholder_118, :db_insert_placeholder_119, :db_insert_placeholder_120, :db_insert_placeholder_121, :db_insert_placeholder_122, :db_insert_placeholder_123, :db_insert_placeholder_124, :db_insert_placeholder_125, :db_insert_placeholder_126, :db_insert_placeholder_127, :db_insert_placeholder_128, :db_insert_placeholder_129, :db_insert_placeholder_130, :db_insert_placeholder_131); Array
(
[:db_insert_placeholder_0] => 20883479
[:db_insert_placeholder_1] => Bull
[:db_insert_placeholder_2] => Kapitalschutzprodukte
[:db_insert_placeholder_3] => Capital Protection Products
[:db_insert_placeholder_4] => Kapitalschutz-Zertifikat mit Coupon
[:db_insert_placeholder_5] => Capital Protection Note with Coupon
[:db_insert_placeholder_6] => 460
[:db_insert_placeholder_7] => 1140
[:db_insert_placeholder_8] => Conditional Coupon Level
[:db_insert_placeholder_9] =>
[:db_insert_placeholder_10] =>
[:db_insert_placeholder_11] =>
[:db_insert_placeholder_12] =>
[:db_insert_placeholder_13] =>
[:db_insert_placeholder_14] =>
[:db_insert_placeholder_15] => EUR
[:db_insert_placeholder_16] => PCT
[:db_insert_placeholder_17] => 2156198400
[:db_insert_placeholder_18] => SIX Swiss Exchange - Structured Products
[:db_insert_placeholder_19] =>
[:db_insert_placeholder_20] =>
[:db_insert_placeholder_21] =>
[:db_insert_placeholder_22] => 9
[:db_insert_placeholder_23] => 2
[:db_insert_placeholder_24] =>
[:db_insert_placeholder_25] =>
[:db_insert_placeholder_26] =>
[:db_insert_placeholder_27] => 1
[:db_insert_placeholder_28] => 1777500000
[:db_insert_placeholder_29] => XS3277701440
[:db_insert_placeholder_30] => 0
[:db_insert_placeholder_31] => 0
[:db_insert_placeholder_32] => 0
[:db_insert_placeholder_33] => 1
[:db_insert_placeholder_34] =>
[:db_insert_placeholder_35] => 1
[:db_insert_placeholder_36] => Royal Bank of Canada
[:db_insert_placeholder_37] => RBC
[:db_insert_placeholder_38] =>
[:db_insert_placeholder_39] =>
[:db_insert_placeholder_40] => 2156198400
[:db_insert_placeholder_41] =>
[:db_insert_placeholder_42] => 2156191200
[:db_insert_placeholder_43] => Fixed Rate Callable notes
[:db_insert_placeholder_44] => 1000
[:db_insert_placeholder_45] =>
[:db_insert_placeholder_46] =>
[:db_insert_placeholder_47] => 1.588
[:db_insert_placeholder_48] =>
[:db_insert_placeholder_49] =>
[:db_insert_placeholder_50] =>
[:db_insert_placeholder_51] => 1
[:db_insert_placeholder_52] => A
[:db_insert_placeholder_53] =>
[:db_insert_placeholder_54] => AAVFSP
[:db_insert_placeholder_55] =>
[:db_insert_placeholder_56] =>
[:db_insert_placeholder_57] =>
[:db_insert_placeholder_58] =>
[:db_insert_placeholder_59] =>
[:db_insert_placeholder_60] =>
[:db_insert_placeholder_61] =>
[:db_insert_placeholder_62] =>
[:db_insert_placeholder_63] => 0.816
[:db_insert_placeholder_64] => 4337
[:db_insert_placeholder_65] =>
[:db_insert_placeholder_66] =>
[:db_insert_placeholder_67] =>
[:db_insert_placeholder_68] =>
[:db_insert_placeholder_69] =>
[:db_insert_placeholder_70] =>
[:db_insert_placeholder_71] =>
[:db_insert_placeholder_72] =>
[:db_insert_placeholder_73] =>
[:db_insert_placeholder_74] =>
[:db_insert_placeholder_75] =>
[:db_insert_placeholder_76] =>
[:db_insert_placeholder_77] =>
[:db_insert_placeholder_78] =>
[:db_insert_placeholder_79] =>
[:db_insert_placeholder_80] =>
[:db_insert_placeholder_81] =>
[:db_insert_placeholder_82] =>
[:db_insert_placeholder_83] =>
[:db_insert_placeholder_84] =>
[:db_insert_placeholder_85] =>
[:db_insert_placeholder_86] =>
[:db_insert_placeholder_87] =>
[:db_insert_placeholder_88] =>
[:db_insert_placeholder_89] =>
[:db_insert_placeholder_90] =>
[:db_insert_placeholder_91] =>
[:db_insert_placeholder_92] => 1781215200
[:db_insert_placeholder_93] =>
[:db_insert_placeholder_94] =>
[:db_insert_placeholder_95] =>
[:db_insert_placeholder_96] =>
[:db_insert_placeholder_97] =>
[:db_insert_placeholder_98] =>
[:db_insert_placeholder_99] =>
[:db_insert_placeholder_100] =>
[:db_insert_placeholder_101] =>
[:db_insert_placeholder_102] =>
[:db_insert_placeholder_103] =>
[:db_insert_placeholder_104] =>
[:db_insert_placeholder_105] =>
[:db_insert_placeholder_106] =>
[:db_insert_placeholder_107] =>
[:db_insert_placeholder_108] =>
[:db_insert_placeholder_109] =>
[:db_insert_placeholder_110] =>
[:db_insert_placeholder_111] =>
[:db_insert_placeholder_112] =>
[:db_insert_placeholder_113] =>
[:db_insert_placeholder_114] =>
[:db_insert_placeholder_115] =>
[:db_insert_placeholder_116] =>
[:db_insert_placeholder_117] => 151129446
[:db_insert_placeholder_118] => 1781587210
[:db_insert_placeholder_119] => 1781587210
[:db_insert_placeholder_120] =>
[:db_insert_placeholder_121] =>
[:db_insert_placeholder_122] =>
[:db_insert_placeholder_123] =>
[:db_insert_placeholder_124] =>
[:db_insert_placeholder_125] =>
[:db_insert_placeholder_126] =>
[:db_insert_placeholder_127] =>
[:db_insert_placeholder_128] =>
[:db_insert_placeholder_129] =>
[:db_insert_placeholder_130] =>
[:db_insert_placeholder_131] =>
)
(/var/www/html/web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php:817) |