Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-3892

DML statement couldn't be parsed

    XMLWordPrintable

Details

    Description

      Error:

      [2021-08-20 13:14:50,241] ERROR Mining session stopped due to the {} (io.debezium.connector.oracle.logminer.LogMinerHelper:506)
      io.debezium.connector.oracle.logminer.parser.DmlParserException: DML statement couldn't be parsed. Please open a Jira issue with the statement 'update "ABCD_SHARD_1_3"."D_LOT_VERSION" set "DOCX" = NULL, "DOCX_SIGNATURE" = NULL, "XML_OOS" = NULL, "XML_OOS_SIGNATURE" = NULL, "GUARANTEE_PROVIDING_PROCEDURE" = 'Обеспечение исполнения договора по закупке № 72-0821-КЭФ-О', "ORDER_PROVIDING_PROCEDURE" = NULL, "ADDITIONAL_REQUIREMENTS" = NULL, "GUARANT_PROVIDING_PROCEDURE" = NULL where "ID" = '23046925' and "ENTITY_ID" = '15069621' and "STATUS_INFO" IS NULL and "CREATED_DATE" = TO_TIMESTAMP('2021-08-20 13:13:58.790000') and "DELETED_DATE" IS NULL and "STANDARD_CONTRACT" IS NULL and "STANDARD_TT" IS NULL and "STANDARD_TZ" IS NULL and "REASON_FOR_CHANGE_ID" = '0' and "OPERATION_ID" IS NULL and "APPROVED_DATE" IS NULL and "ORGANIZER_ID" = '7093916' and "LOT_NAME" = 'text text text"' and "METHOD_OF_SUPPLIER_ID" = '12' and "START_DATE" = TO_DATE('2021-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and "REASON_OF_CHOICE" IS NULL and "CONTRACT_TYPE" = '3' and "ADVANCED_AMOUNT" IS NULL and "ADVANTAGES_FOR_INVALIDS" IS NULL and "ADVANTAGES_FOR_UIS" IS NULL and "BANKING_CONTRACT_SUPPORT" IS NULL and "CAN_WITHDRAW_BY_AGENT" IS NULL and "CAN_WITHDRAW_BY_CUSTOMER" IS NULL and "CAN_MULTIPLE" IS NULL and "ADDITIONAL_REQUIREMENTS_ID" IS NULL and "SMP_ACCOMODATION" = '0' and "USE_SUBCONTRACTORS" IS NULL and "SMP_TYPE" = 'partly' and "CHARGED" = '0' and "ORDER_PERCENT_AMOUNT" = '0' and "O_UNK" IS NULL and "O_SHORT_NAME" IS NULL and "O_NAME" IS NULL and "O_ACCAUNT_TYPE_ID" IS NULL and "O_ACCOUNT" IS NULL and "O_INN" IS NULL and "O_KPP" IS NULL and "O_BANK_ID" IS NULL and "GUARANTEE_PERCENT_AMOUNT" = '10' and "G_UNK" IS NULL and "G_SHORT_NAME" IS NULL and "G_NAME" IS NULL and "G_ACCAUNT_TYPE_ID" IS NULL and "G_ACCOUNT" IS NULL and "G_BANK_ID" IS NULL and "G_INN" IS NULL and "G_KPP" IS NULL and "SIGNER_USER_ID" IS NULL and "DOCX_FILE_ACCESS_CODE" IS NULL and "OOS_XML_FILE_ACCESS_CODE" IS NULL and "GUARANTEE_PROV_BANK_DETAIL_ID" = '91325087' and "ORDER_PROVIDING_BANK_DETAIL_ID" = '0' and "CONTRACT_NMC" = '0' and "PLANNED_CONTRACT_DATE" = TO_DATE('2021-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and "AVAILABILITY_STAGES_PAYMENT" = '0' and "METHOD_OF_PAYMENT_IN_STAGES_ID" = '0' and "BANS_ADMISSION_FOREIGN_GOODS" IS NULL and "VOLUME_OF_FOREIGN_GOODS" IS NULL and "AVAILABE_FINANCIAL_RESOURCES" = '0' and "REASON_AVAILABE_FINAN_RES" IS NULL and "AVAILABE_EQUIPMENT" = '0' and "REASON_AVAILABE_EQUIPMENT" IS NULL and "AVAILABE_WORK_EXPRNC" = '0' and "REASON_AVAILABE_WORK_EXPRNC" IS NULL and "AVAILABE_SPECIALISTS" = '0' and "REASON_AVAILABE_SPECIALISTS" IS NULL and "CAN_INCREASING_QUANTITY_GOODS" = '0' and "CAN_CHANGE_QUNTTY_WTHN_10PRCNT" = '0' and "CNDTNS_RCGNTN_WIN_EVADES_CTRCT" IS NULL and "GUARANTEE_CHARGED" = '1' and "ADVANTAGES_FOR_UIS_SELECT" = '0' and "ADVANTAGES_FOR_INVALIDS_SELECT" = '0' and "REASON_METHOD_OF_SUPPLIER_ID" = '0' and "D_REASON_METHOD_OF_SUPPLIER" IS NULL and "REASON_CONCLUSION_CONTRACT" IS NULL and "CAN_REDUCING_PRICE" = '0' and "F_REASON_METHOD_OF_SUPPLIER_ID" = '0' and "USE_PAYMENT_SCHEDULE" = '0' and "PAYMENT_DATE" = TO_DATE('2022-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and "SUPPLIER_ID" = '0' and "SENT_TO_CORRECTION" = '0' and "SALES_COMPLETED" = '0' and "RLS_ASSESSING_APLCTNS_FILE_ID" = '0' and "SCOPE_INTELLECTUAL_PROPERTY" IS NULL and "PSBLTY_CTRCT_SEVERAL_PRTPNTS" = '0' and "STANDART_PROVIDING_PROCEDURE" = '0' and "CONTRACTUAL_CONTROL_EMAIL" = 'abc@mail.ru' and "CAN_ADD_TECHNICAL_SPECIFICATIO" = '1' and "CONTRACTUAL_CONTROL_TELEPHONE" = '+123456789' and "OOS_PROCEDURE_NUMBER" IS NULL and "OOS_PROCEDURE_LINK" IS NULL and "STDRT_ORDER_PROVIDING_PRCEDURE" = '0' and "HAS_EXCLUSIVE_RIGHTS" = '0' and "JOINT_AUCTION" = '0' and "AGREEMENT_FILE_ID" = '0' and "BLOCKED_BY_GKU" = '0' and "REASON_RFQ_METHOD_OF_SPLR_ID" = '0' and "JUDGMENT_NUMBER" IS NULL and "PUBLISHED_IN_PLAN_NMC" IS NULL and "SCHEDULE_OF_EXAMINATION" IS NULL and "CONTRACTUAL_CONTROL_NAME" = 'ivanov А.П.' and "GOODS_REQUIRES" = '0' and "RESPONSIBLE_NAME" = 'Тендерная служба т' and "RESPONSIBLE_EMAIL" = 'abc@gmail.com' and "RESPONSIBLE_PHONE" = '+7 (495) 225-19-40' and "BLOCKED_MESSAGE_ID" IS NULL and "PUBLIC_DISCUSSION_NUMBER" IS NULL and "PUBLIC_DISCUSSION_START_DATE" IS NULL and "PUBLIC_DISCUSSION_END_DATE" IS NULL and "PUBLIC_DISCUSSION_PROTOCOL" IS NULL and "MAX_PARTICIPANTS_COUNT" IS NULL and "STATUS_ID" = '1' and "VERSION" = '1' and "UNSUCCESSFUL_PURCHASE" = '0' and "MAY_BE_INCLUDED_IN_JOINT_LOT" = '0' and "CANCELED_LOT_IS_PUBLISHED" = '0' and "PLANNED_CONTRACT_END_DATE" = TO_DATE('2021-12-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and "BIDDING_ON_UNIT_PRODUCTION" = '0' and "CAPITAL_CONSTRUCTION_OBJECT" = '0' and "ADDITIONAL_G_REQUIREMENTS" IS NULL and "NEED_NMC_EXAMINATION_MRG" IS NULL and "NEED_GAUI_NMC_EXAMINATION_MRG" IS NULL and "EEU_PRODUCTION" = '0' and "TURKISH_PRODUCTION_BAN" = '0' and "STATUS_INFO_DF" IS NULL and "TURKISH_ORGANIZATIONS_BAN" = '0' and "GUARANTEE_PERIOD" = '30' and "JA_ORGANIZER_ID" = '0' and "IS_JOINT_AUCTION_ORGANIZER" = '1' and "IS_AUTHORIZED_ORGANIZER" = '0' and "DECIPHER_ADDITIONAL_REQ" IS NULL and "MECHANICAL_ENG_PRODUCTS_BAN" = '0' and "LIGHT_INDUSTRY_PRODUCTS_BAN" = '0' and "SOFTWARE_BAN" = '0' and "FOOD_PRODUCTS_BAN" = '0' and "MEDICAL_PRODUCTS_BAN" = '0' and "MEDICAMENT_PRODUCTS_BAN" = '0' and "ELECTRONIC_PRODUCTS_BAN" = '0' and "DECIPHER_METHOD_NMC" IS NULL and "DECIPHER_IMPOSIBLE_METHOD_NMC" IS NULL and "MULTIPLE_PARTICIPANTS" = '0' and "BEEN_AT_GRBS" = '0' and "ACCEPTED_BY_GRBS" = '0' and "BOTH_ACCOUNTS" = '1' and "REJECTED_BY_GRBS_DATE" IS NULL and "NMC_SUBSTANTATION" IS NULL and "ALLOW_PUBLICATION_BEFORE_MRG" = '0' and "FURNITURE_PRODUCTS_BAN" = '0' and "ADD_REQ_VARIATION" IS NULL and "IS_NEW_ADD_REQ" = '0' and "CRITERIAS_FROM_BKTZ" = '0' and "REJECTED_BY_OIV_DATE" IS NULL and "BEEN_AT_OIV" = '0' and "ACCEPTED_BY_OIV" = '0' and "FROM_OFFER" = '0' and "GRBS_SIGN_OP_ID" IS NULL and "GRBS_SIGN_DOC_CODE" IS NULL and "GRBS_SIGN_SIGNATURE" IS NULL and "REJECT_AT_CENTRALIZATION" = '0' and "CENTRALIZATION_PURCHASE" = '0' and "CENTR_STATUS_ID" = '0' and "CENTR_DIRECTION_ID" IS NULL and "EXCEPTION_FROM_SMP" IS NULL and "NUM_CONTRACTS" IS NULL and "OIV_SIGN_OP_ID" IS NULL and "OIV_SIGN_DOC_CODE" IS NULL and "OIV_SIGN_SIGNATURE" IS NULL and "IS_EXACT_DATE" = '0' and "ACCEPTED_BY_GRBS_DATE" IS NULL and "NORMAL_LIFE_SUPPORT" = '0' and "SCIENCE" = '0' and "METHOD_CODE" = '173391' and "MIN_REQUIREMENTS" = 'Выполнение строительно-монтажных работ в соответствии с документацией и проектом договора. Требуется членство в СРО' and "IS_INNOVATION" = '0' and "BANK_SUPPORT_CONTRACT" = '0' and "IS_AUDIT_307FZ" = '0' and "USING_OWN_METHODS" = '0' and "APPROVAL_WITH_FULL_DOC" = '0' and "IS_SPECIALIZED" = '0' and "GUARANT_CHARGED" = '0' and "GUARANT_PERCENT_AMOUNT" = '0' and "GUARANT_PROV_BANK_DETAIL_ID" = '0' and "PURCHASE_ORGANIZER_ID" = '7093916' and "IS_CHANGE_UNDER_CONTRACT" = '0' and "KPGZ_ID" = '30246740' and "PUBLIC_DISCUTION" = '0' and "PUBLIC_DISCUTION_ID" IS NULL and "REASON_FOR_CHANGE_DESCRIPTION" IS NULL and "PLANNED_PUBLISH_YEAR" = '2021' and "SMALL_VOLUME" = '0' and "PURCHASE_SPECIAL" = '0' and "NO_PUBL_DISC_DUE_CLOSED" = '0' and "NO_PUBL_DISC_DUE_SINGLE" = '0' and "REASON_FOR_CHANGE_ID_2020" = '0' and "CENTRALIZATION_LEVEL" = '0' and "PROGRAM_COMPLEX_BAN" = '0' and "IS_COVID_19" = '0' and "SOME_MANUFACTURE_GOODS_BAN" = '0' and "MANUFACTURE_GOODS_DEFENSE_BAN" = '0' and "GUARANT_MIN_PERIOD" = '0' and "IS_VOTING_2020" = '0' and "IS_BUILDING_SUBJECT" = '0' and "IS223" = '1' and "IKZ" IS NULL and "CUSTOMER_ID" = '7093916' and "AUTOMATIC_CALC_OF_ATTRIBUTES" = '1' and "LOT_NAME_BY_KPGZ" IS NULL and "LOT_NAME_INPUT" = UNISTR('\0412\044B\043F\043E\043B\043D\0435\043D\0438\0435 \0440\0430\0431\043E\0442 \043F\043E \0443\0441\0442\0440\043E\0439\0441\0442\0432\0443 \044D\043B\0435\043A\0442\0440\043E\0441\043D\0430\0431\0436\0435\043D\0438\044F \043E\0441\0442\0430\043D\043E\0432\043E\0447\043D\044B\0445 \043F\0430\0432\0438\043B\044C\043E\043D\043E\0432, \0441\0438\0441\0442\0435\043C \0432\0438\0434\0435\043E\043D\0430\0431\043B\044E\0434\0435\043D\0438\044F, \043D\0430\0440\0443\0436\043D\043E\0433\043E \043E\0441\0432\0435\0449\0435\043D\0438\044F \043F\0430\0440\043A\043E\0432\043E\0433\043E, \0430\0440\0445\0438\0442\0435\043A\0442\0443\0440\043D\043E-\043B\0430\043D\0434\0448\0430\0444\0442\043D\043E\0433\043E \043E\0441\0432\0435\0449\0435\043D\0438\044F, \044D\043B\0435\043A\0442\0440\043E\0441\043D\0430\0431\0436\0435\043D\0438\044F \0441\0438\0441\0442\0435\043C\044B \0432\0438\0434\0435\043E\043D\0430\0431\043B\044E\0434\0435\043D\0438\044F \043D\0430 \043E\0431\044A\0435\043A\0442\0435:  \0421\0442\0440\043E\0438\0442\0435\043B\044C\0441\0442\0432\043E \043C\043E\0441\0442\043E\0432\043E\0433\043E \0441\043E\043E\0440\0443\0436\0435\043D\0438\044F \0447\0435\0440\0435\0437 \0441\0442\0430\0440\043E\0435 \0440\0443\0441\043B\043E \0440.\041C\043E\0441\043A\0432\0430 \0441 \0443\043B\0438\0447\043D\043E-\0434\043E\0440\043E\0436\043D\043E\0439 \0441\0435\0442\044C\044E \0432 \044E\0436\043D\043E\0439 \0447\0430\0441\0442\0438 \0442\0435\0440\0440\0438\0442\043E\0440\0438\0438 \043F\0443\0431\043B\0438\0447\043D\043E\0433\043E \0430\043A\0446\0438\043E\043D\0435\0440\043D\043E\0433\043E \043E\0431\0449\0435\0441\0442\0432\0430 "\0417\0430\0432\043E\0434 \0438\043C\0435\043D\0438 \0418.\0410. \041B\0438\0445\0430\0447\0435\0432\0430" \0441 \043E\0431\0443\0441\0442\0440\043E\0439\0441\0442\0432\043E\043C \043F\0435\0448\0435\0445\043E\0434\043D\044B\0445 \043F\0435\0448\0435\0445\043E\0434\043E\0432, \043E\0442\0441\0442\043E\0439\043D\043E-\0440\0430\0437\0432\043E\0440\043E\0442\043D\043E\0439 \043F\043B\043E\0449\0430\0434\043A\0438, \0437\0434\0430\043D\0438\044F \043A\043E\043D\0435\0447\043D\043E\0439 \0441\0442\0430\043D\0446\0438\0438 \0433\043E\0440\043E\0434\0441\043A\043E\0433\043E \043F\0430\0441\0441\0430\0436\0438\0440\0441\043A\043E\0433\043E \0442\0440\0430\043D\0441\043F\043E\0440\0442\0430. \041E\0431\0443\0441\0442\0440\043E\0439\0441\0442\0432\043E \043D\0430\0431\0435\0440\0435\0436\043D\043E\0439 \0440.\041C\043E\0441\043A\0432\0430 \0432 \0440\0430\0439\043E\043D\0435 \0442\0435\0440\0440\0438\0442\043E\0440\0438\0438 \043F\0443\0431\043B\0438\0447\043D\043E\0433\043E \0430\043A\0446\0438\043E\043D\0435\0440\043D\043E\0433\043E \043E\0431\0449\0435\0441\0442\0432\0430 "\0417\0430\0432\043E\0434 \0438\043C\0435\043D\0438 \0418.\0410. \041B\0438\0445\0430\0447\0435\0432\0430". \042D\0442\0430\043F 1. \0421\0442\0440\043E\0438\0442\0435\043B\044C\0441\0442\0432\043E \043C\043E\0441\0442\043E\0432\043E\0433\043E \0441\043E\043E\0440\0443\0436\0435\043D\0438\044F \0447\0435\0440\0435\0437 \0441\0442\0430\0440\043E\0435 \0440\0443\0441\043B\043E \041C\043E\0441\043A\0432\0430-\0440\0435\043A\0438 \0441 \0443\043B\0438\0447\043D\043E-\0434\043E\0440\043E\0436\043D\043E\0439 \0441\0435\0442\044C\044E \0432 \044E\0436\043D\043E\0439 \0447\0430\0441\0442\0438 \0442\0435\0440\0440\0438\0442\043E\0440\0438\0438 "\0417\0430\0432\043E\0434 \0438\043C\0435\043D\0438 \0418.\0410. \041B\0438\0445\0430\0447\0435\0432\0430" \0441 \043E\0431\0443\0441\0442\0440\043E\0439\0441\0442\0432\043E\043C \043F\0435\0448\0435\0445\043E\0434\043D\043E\0433\043E \043F\0435\0440\0435\0445\043E\0434\0430 \042D\0442\0430\043F 1.1.2 - \0421\0442\0440\043E\0438\0442\0435\043B\044C\0441\0442\0432\043E \0443\043B\0438\0447\043D\043E-\0434\043E\0440\043E\0436\043D\043E\0439 \0441\0435\0442\0438 \043F\043E \043F\0440.\043F\0440. 4062 \043D\0430 \0443\0447\0430\0441\0442\043A\0435 \043E\0442 \0443\043B. \041B\044C\0432\0430 \042E\0434\0438\043D\0430 \0434\043E ') || UNISTR('\0431\0443\043B\044C\0432\0430\0440\0430 \0411\0440\0430\0442\044C\0435\0432 \0412\0435\0441\043D\0438\043D\044B\0445 \0441 \043E\0431\0443\0441\0442\0440\043E\0439\0441\0442\0432\043E\043C \043D\0430\0431\0435\0440\0435\0436\043D\043E\0439."') and "IS_MRG_SPEC" = '0' and "IS_ELECTRONIC_EXECUTION" = '0';'. You can set internal.log.mining.dml.parser='legacy' as a workaround until the parse error is fixed.
              at io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor.parse(LogMinerQueryResultProcessor.java:397)
              at io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor.processResult(LogMinerQueryResultProcessor.java:275)
              at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:184)
              at io.debezium.connector.oracle.logminer.LogMinerStreamingChangeEventSource.execute(LogMinerStreamingChangeEventSource.java:63)
              at io.debezium.pipeline.ChangeEventSourceCoordinator.streamEvents(ChangeEventSourceCoordinator.java:159)
              at io.debezium.pipeline.ChangeEventSourceCoordinator.lambda$start$0(ChangeEventSourceCoordinator.java:122)
              at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
              at java.util.concurrent.FutureTask.run(FutureTask.java:266)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
              at java.lang.Thread.run(Thread.java:748)
      Caused by: io.debezium.connector.oracle.logminer.parser.DmlParserException: Failed to parse update DML: 'update "ABCD_SHARD_1_3"."D_LOT_VERSION" set "DOCX" = NULL, "DOCX_SIGNATURE" = NULL, "XML_OOS" = NULL, "XML_OOS_SIGNATURE" = NULL, "GUARANTEE_PROVIDING_PROCEDURE" = 'Обеспечение исполнения договора по закупке № 72-0821-КЭФ-О', "ORDER_PROVIDING_PROCEDURE" = NULL, "ADDITIONAL_REQUIREMENTS" = NULL, "GUARANT_PROVIDING_PROCEDURE" = NULL where "ID" = '23046925' and "ENTITY_ID" = '15069621' and "STATUS_INFO" IS NULL and "CREATED_DATE" = TO_TIMESTAMP('2021-08-20 13:13:58.790000') and "DELETED_DATE" IS NULL and "STANDARD_CONTRACT" IS NULL and "STANDARD_TT" IS NULL and "STANDARD_TZ" IS NULL and "REASON_FOR_CHANGE_ID" = '0' and "OPERATION_ID" IS NULL and "APPROVED_DATE" IS NULL and "ORGANIZER_ID" = '7093916' and "LOT_NAME" = 'text text text"' and "METHOD_OF_SUPPLIER_ID" = '12' and "START_DATE" = TO_DATE('2021-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and "REASON_OF_CHOICE" IS NULL and "CONTRACT_TYPE" = '3' and "ADVANCED_AMOUNT" IS NULL and "ADVANTAGES_FOR_INVALIDS" IS NULL and "ADVANTAGES_FOR_UIS" IS NULL and "BANKING_CONTRACT_SUPPORT" IS NULL and "CAN_WITHDRAW_BY_AGENT" IS NULL and "CAN_WITHDRAW_BY_CUSTOMER" IS NULL and "CAN_MULTIPLE" IS NULL and "ADDITIONAL_REQUIREMENTS_ID" IS NULL and "SMP_ACCOMODATION" = '0' and "USE_SUBCONTRACTORS" IS NULL and "SMP_TYPE" = 'partly' and "CHARGED" = '0' and "ORDER_PERCENT_AMOUNT" = '0' and "O_UNK" IS NULL and "O_SHORT_NAME" IS NULL and "O_NAME" IS NULL and "O_ACCAUNT_TYPE_ID" IS NULL and "O_ACCOUNT" IS NULL and "O_INN" IS NULL and "O_KPP" IS NULL and "O_BANK_ID" IS NULL and "GUARANTEE_PERCENT_AMOUNT" = '10' and "G_UNK" IS NULL and "G_SHORT_NAME" IS NULL and "G_NAME" IS NULL and "G_ACCAUNT_TYPE_ID" IS NULL and "G_ACCOUNT" IS NULL and "G_BANK_ID" IS NULL and "G_INN" IS NULL and "G_KPP" IS NULL and "SIGNER_USER_ID" IS NULL and "DOCX_FILE_ACCESS_CODE" IS NULL and "OOS_XML_FILE_ACCESS_CODE" IS NULL and "GUARANTEE_PROV_BANK_DETAIL_ID" = '91325087' and "ORDER_PROVIDING_BANK_DETAIL_ID" = '0' and "CONTRACT_NMC" = '0' and "PLANNED_CONTRACT_DATE" = TO_DATE('2021-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and "AVAILABILITY_STAGES_PAYMENT" = '0' and "METHOD_OF_PAYMENT_IN_STAGES_ID" = '0' and "BANS_ADMISSION_FOREIGN_GOODS" IS NULL and "VOLUME_OF_FOREIGN_GOODS" IS NULL and "AVAILABE_FINANCIAL_RESOURCES" = '0' and "REASON_AVAILABE_FINAN_RES" IS NULL and "AVAILABE_EQUIPMENT" = '0' and "REASON_AVAILABE_EQUIPMENT" IS NULL and "AVAILABE_WORK_EXPRNC" = '0' and "REASON_AVAILABE_WORK_EXPRNC" IS NULL and "AVAILABE_SPECIALISTS" = '0' and "REASON_AVAILABE_SPECIALISTS" IS NULL and "CAN_INCREASING_QUANTITY_GOODS" = '0' and "CAN_CHANGE_QUNTTY_WTHN_10PRCNT" = '0' and "CNDTNS_RCGNTN_WIN_EVADES_CTRCT" IS NULL and "GUARANTEE_CHARGED" = '1' and "ADVANTAGES_FOR_UIS_SELECT" = '0' and "ADVANTAGES_FOR_INVALIDS_SELECT" = '0' and "REASON_METHOD_OF_SUPPLIER_ID" = '0' and "D_REASON_METHOD_OF_SUPPLIER" IS NULL and "REASON_CONCLUSION_CONTRACT" IS NULL and "CAN_REDUCING_PRICE" = '0' and "F_REASON_METHOD_OF_SUPPLIER_ID" = '0' and "USE_PAYMENT_SCHEDULE" = '0' and "PAYMENT_DATE" = TO_DATE('2022-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and "SUPPLIER_ID" = '0' and "SENT_TO_CORRECTION" = '0' and "SALES_COMPLETED" = '0' and "RLS_ASSESSING_APLCTNS_FILE_ID" = '0' and "SCOPE_INTELLECTUAL_PROPERTY" IS NULL and "PSBLTY_CTRCT_SEVERAL_PRTPNTS" = '0' and "STANDART_PROVIDING_PROCEDURE" = '0' and "CONTRACTUAL_CONTROL_EMAIL" = 'abc@mail.ru' and "CAN_ADD_TECHNICAL_SPECIFICATIO" = '1' and "CONTRACTUAL_CONTROL_TELEPHONE" = '+123456789' and "OOS_PROCEDURE_NUMBER" IS NULL and "OOS_PROCEDURE_LINK" IS NULL and "STDRT_ORDER_PROVIDING_PRCEDURE" = '0' and "HAS_EXCLUSIVE_RIGHTS" = '0' and "JOINT_AUCTION" = '0' and "AGREEMENT_FILE_ID" = '0' and "BLOCKED_BY_GKU" = '0' and "REASON_RFQ_METHOD_OF_SPLR_ID" = '0' and "JUDGMENT_NUMBER" IS NULL and "PUBLISHED_IN_PLAN_NMC" IS NULL and "SCHEDULE_OF_EXAMINATION" IS NULL and "CONTRACTUAL_CONTROL_NAME" = 'ivanov А.П.' and "GOODS_REQUIRES" = '0' and "RESPONSIBLE_NAME" = 'Тендерная служба т' and "RESPONSIBLE_EMAIL" = 'abc@gmail.com' and "RESPONSIBLE_PHONE" = '+7 (495) 225-19-40' and "BLOCKED_MESSAGE_ID" IS NULL and "PUBLIC_DISCUSSION_NUMBER" IS NULL and "PUBLIC_DISCUSSION_START_DATE" IS NULL and "PUBLIC_DISCUSSION_END_DATE" IS NULL and "PUBLIC_DISCUSSION_PROTOCOL" IS NULL and "MAX_PARTICIPANTS_COUNT" IS NULL and "STATUS_ID" = '1' and "VERSION" = '1' and "UNSUCCESSFUL_PURCHASE" = '0' and "MAY_BE_INCLUDED_IN_JOINT_LOT" = '0' and "CANCELED_LOT_IS_PUBLISHED" = '0' and "PLANNED_CONTRACT_END_DATE" = TO_DATE('2021-12-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and "BIDDING_ON_UNIT_PRODUCTION" = '0' and "CAPITAL_CONSTRUCTION_OBJECT" = '0' and "ADDITIONAL_G_REQUIREMENTS" IS NULL and "NEED_NMC_EXAMINATION_MRG" IS NULL and "NEED_GAUI_NMC_EXAMINATION_MRG" IS NULL and "EEU_PRODUCTION" = '0' and "TURKISH_PRODUCTION_BAN" = '0' and "STATUS_INFO_DF" IS NULL and "TURKISH_ORGANIZATIONS_BAN" = '0' and "GUARANTEE_PERIOD" = '30' and "JA_ORGANIZER_ID" = '0' and "IS_JOINT_AUCTION_ORGANIZER" = '1' and "IS_AUTHORIZED_ORGANIZER" = '0' and "DECIPHER_ADDITIONAL_REQ" IS NULL and "MECHANICAL_ENG_PRODUCTS_BAN" = '0' and "LIGHT_INDUSTRY_PRODUCTS_BAN" = '0' and "SOFTWARE_BAN" = '0' and "FOOD_PRODUCTS_BAN" = '0' and "MEDICAL_PRODUCTS_BAN" = '0' and "MEDICAMENT_PRODUCTS_BAN" = '0' and "ELECTRONIC_PRODUCTS_BAN" = '0' and "DECIPHER_METHOD_NMC" IS NULL and "DECIPHER_IMPOSIBLE_METHOD_NMC" IS NULL and "MULTIPLE_PARTICIPANTS" = '0' and "BEEN_AT_GRBS" = '0' and "ACCEPTED_BY_GRBS" = '0' and "BOTH_ACCOUNTS" = '1' and "REJECTED_BY_GRBS_DATE" IS NULL and "NMC_SUBSTANTATION" IS NULL and "ALLOW_PUBLICATION_BEFORE_MRG" = '0' and "FURNITURE_PRODUCTS_BAN" = '0' and "ADD_REQ_VARIATION" IS NULL and "IS_NEW_ADD_REQ" = '0' and "CRITERIAS_FROM_BKTZ" = '0' and "REJECTED_BY_OIV_DATE" IS NULL and "BEEN_AT_OIV" = '0' and "ACCEPTED_BY_OIV" = '0' and "FROM_OFFER" = '0' and "GRBS_SIGN_OP_ID" IS NULL and "GRBS_SIGN_DOC_CODE" IS NULL and "GRBS_SIGN_SIGNATURE" IS NULL and "REJECT_AT_CENTRALIZATION" = '0' and "CENTRALIZATION_PURCHASE" = '0' and "CENTR_STATUS_ID" = '0' and "CENTR_DIRECTION_ID" IS NULL and "EXCEPTION_FROM_SMP" IS NULL and "NUM_CONTRACTS" IS NULL and "OIV_SIGN_OP_ID" IS NULL and "OIV_SIGN_DOC_CODE" IS NULL and "OIV_SIGN_SIGNATURE" IS NULL and "IS_EXACT_DATE" = '0' and "ACCEPTED_BY_GRBS_DATE" IS NULL and "NORMAL_LIFE_SUPPORT" = '0' and "SCIENCE" = '0' and "METHOD_CODE" = '173391' and "MIN_REQUIREMENTS" = 'Выполнение строительно-монтажных работ в соответствии с документацией и проектом договора. Требуется членство в СРО' and "IS_INNOVATION" = '0' and "BANK_SUPPORT_CONTRACT" = '0' and "IS_AUDIT_307FZ" = '0' and "USING_OWN_METHODS" = '0' and "APPROVAL_WITH_FULL_DOC" = '0' and "IS_SPECIALIZED" = '0' and "GUARANT_CHARGED" = '0' and "GUARANT_PERCENT_AMOUNT" = '0' and "GUARANT_PROV_BANK_DETAIL_ID" = '0' and "PURCHASE_ORGANIZER_ID" = '7093916' and "IS_CHANGE_UNDER_CONTRACT" = '0' and "KPGZ_ID" = '30246740' and "PUBLIC_DISCUTION" = '0' and "PUBLIC_DISCUTION_ID" IS NULL and "REASON_FOR_CHANGE_DESCRIPTION" IS NULL and "PLANNED_PUBLISH_YEAR" = '2021' and "SMALL_VOLUME" = '0' and "PURCHASE_SPECIAL" = '0' and "NO_PUBL_DISC_DUE_CLOSED" = '0' and "NO_PUBL_DISC_DUE_SINGLE" = '0' and "REASON_FOR_CHANGE_ID_2020" = '0' and "CENTRALIZATION_LEVEL" = '0' and "PROGRAM_COMPLEX_BAN" = '0' and "IS_COVID_19" = '0' and "SOME_MANUFACTURE_GOODS_BAN" = '0' and "MANUFACTURE_GOODS_DEFENSE_BAN" = '0' and "GUARANT_MIN_PERIOD" = '0' and "IS_VOTING_2020" = '0' and "IS_BUILDING_SUBJECT" = '0' and "IS223" = '1' and "IKZ" IS NULL and "CUSTOMER_ID" = '7093916' and "AUTOMATIC_CALC_OF_ATTRIBUTES" = '1' and "LOT_NAME_BY_KPGZ" IS NULL and "LOT_NAME_INPUT" = UNISTR('\0412\044B\043F\043E\043B\043D\0435\043D\0438\0435 \0440\0430\0431\043E\0442 \043F\043E \0443\0441\0442\0440\043E\0439\0441\0442\0432\0443 \044D\043B\0435\043A\0442\0440\043E\0441\043D\0430\0431\0436\0435\043D\0438\044F \043E\0441\0442\0430\043D\043E\0432\043E\0447\043D\044B\0445 \043F\0430\0432\0438\043B\044C\043E\043D\043E\0432, \0441\0438\0441\0442\0435\043C \0432\0438\0434\0435\043E\043D\0430\0431\043B\044E\0434\0435\043D\0438\044F, \043D\0430\0440\0443\0436\043D\043E\0433\043E \043E\0441\0432\0435\0449\0435\043D\0438\044F \043F\0430\0440\043A\043E\0432\043E\0433\043E, \0430\0440\0445\0438\0442\0435\043A\0442\0443\0440\043D\043E-\043B\0430\043D\0434\0448\0430\0444\0442\043D\043E\0433\043E \043E\0441\0432\0435\0449\0435\043D\0438\044F, \044D\043B\0435\043A\0442\0440\043E\0441\043D\0430\0431\0436\0435\043D\0438\044F \0441\0438\0441\0442\0435\043C\044B \0432\0438\0434\0435\043E\043D\0430\0431\043B\044E\0434\0435\043D\0438\044F \043D\0430 \043E\0431\044A\0435\043A\0442\0435:  \0421\0442\0440\043E\0438\0442\0435\043B\044C\0441\0442\0432\043E \043C\043E\0441\0442\043E\0432\043E\0433\043E \0441\043E\043E\0440\0443\0436\0435\043D\0438\044F \0447\0435\0440\0435\0437 \0441\0442\0430\0440\043E\0435 \0440\0443\0441\043B\043E \0440.\041C\043E\0441\043A\0432\0430 \0441 \0443\043B\0438\0447\043D\043E-\0434\043E\0440\043E\0436\043D\043E\0439 \0441\0435\0442\044C\044E \0432 \044E\0436\043D\043E\0439 \0447\0430\0441\0442\0438 \0442\0435\0440\0440\0438\0442\043E\0440\0438\0438 \043F\0443\0431\043B\0438\0447\043D\043E\0433\043E \0430\043A\0446\0438\043E\043D\0435\0440\043D\043E\0433\043E \043E\0431\0449\0435\0441\0442\0432\0430 "\0417\0430\0432\043E\0434 \0438\043C\0435\043D\0438 \0418.\0410. \041B\0438\0445\0430\0447\0435\0432\0430" \0441 \043E\0431\0443\0441\0442\0440\043E\0439\0441\0442\0432\043E\043C \043F\0435\0448\0435\0445\043E\0434\043D\044B\0445 \043F\0435\0448\0435\0445\043E\0434\043E\0432, \043E\0442\0441\0442\043E\0439\043D\043E-\0440\0430\0437\0432\043E\0440\043E\0442\043D\043E\0439 \043F\043B\043E\0449\0430\0434\043A\0438, \0437\0434\0430\043D\0438\044F \043A\043E\043D\0435\0447\043D\043E\0439 \0441\0442\0430\043D\0446\0438\0438 \0433\043E\0440\043E\0434\0441\043A\043E\0433\043E \043F\0430\0441\0441\0430\0436\0438\0440\0441\043A\043E\0433\043E \0442\0440\0430\043D\0441\043F\043E\0440\0442\0430. \041E\0431\0443\0441\0442\0440\043E\0439\0441\0442\0432\043E \043D\0430\0431\0435\0440\0435\0436\043D\043E\0439 \0440.\041C\043E\0441\043A\0432\0430 \0432 \0440\0430\0439\043E\043D\0435 \0442\0435\0440\0440\0438\0442\043E\0440\0438\0438 \043F\0443\0431\043B\0438\0447\043D\043E\0433\043E \0430\043A\0446\0438\043E\043D\0435\0440\043D\043E\0433\043E \043E\0431\0449\0435\0441\0442\0432\0430 "\0417\0430\0432\043E\0434 \0438\043C\0435\043D\0438 \0418.\0410. \041B\0438\0445\0430\0447\0435\0432\0430". \042D\0442\0430\043F 1. \0421\0442\0440\043E\0438\0442\0435\043B\044C\0441\0442\0432\043E \043C\043E\0441\0442\043E\0432\043E\0433\043E \0441\043E\043E\0440\0443\0436\0435\043D\0438\044F \0447\0435\0440\0435\0437 \0441\0442\0430\0440\043E\0435 \0440\0443\0441\043B\043E \041C\043E\0441\043A\0432\0430-\0440\0435\043A\0438 \0441 \0443\043B\0438\0447\043D\043E-\0434\043E\0440\043E\0436\043D\043E\0439 \0441\0435\0442\044C\044E \0432 \044E\0436\043D\043E\0439 \0447\0430\0441\0442\0438 \0442\0435\0440\0440\0438\0442\043E\0440\0438\0438 "\0417\0430\0432\043E\0434 \0438\043C\0435\043D\0438 \0418.\0410. \041B\0438\0445\0430\0447\0435\0432\0430" \0441 \043E\0431\0443\0441\0442\0440\043E\0439\0441\0442\0432\043E\043C \043F\0435\0448\0435\0445\043E\0434\043D\043E\0433\043E \043F\0435\0440\0435\0445\043E\0434\0430 \042D\0442\0430\043F 1.1.2 - \0421\0442\0440\043E\0438\0442\0435\043B\044C\0441\0442\0432\043E \0443\043B\0438\0447\043D\043E-\0434\043E\0440\043E\0436\043D\043E\0439 \0441\0435\0442\0438 \043F\043E \043F\0440.\043F\0440. 4062 \043D\0430 \0443\0447\0430\0441\0442\043A\0435 \043E\0442 \0443\043B. \041B\044C\0432\0430 \042E\0434\0438\043D\0430 \0434\043E ') || UNISTR('\0431\0443\043B\044C\0432\0430\0440\0430 \0411\0440\0430\0442\044C\0435\0432 \0412\0435\0441\043D\0438\043D\044B\0445 \0441 \043E\0431\0443\0441\0442\0440\043E\0439\0441\0442\0432\043E\043C \043D\0430\0431\0435\0440\0435\0436\043D\043E\0439."') and "IS_MRG_SPEC" = '0' and "IS_ELECTRONIC_EXECUTION" = '0';'
              at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseUpdate(LogMinerDmlParser.java:155)
              at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parse(LogMinerDmlParser.java:77)
              at io.debezium.connector.oracle.logminer.LogMinerQueryResultProcessor.parse(LogMinerQueryResultProcessor.java:387)
              ... 10 more
      Caused by: io.debezium.DebeziumException: No column '') and ' found in table 'ABCDNEW.ABCD_SHARD_1_3.D_LOT_VERSION'
              at io.debezium.connector.oracle.logminer.LogMinerHelper.getColumnIndexByName(LogMinerHelper.java:729)
              at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseWhereClause(LogMinerDmlParser.java:513)
              at io.debezium.connector.oracle.logminer.parser.LogMinerDmlParser.parseUpdate(LogMinerDmlParser.java:136)
              ... 12 more		
      

      Config:

      {"name":"oracle_logminer_200821-1331","config":{"connector.class":"io.debezium.connector.oracle.OracleConnector","snapshot.locking.mode":"none","tasks.max":"1","database.history.kafka.topic":"history_oracle_logminer_200821-1331","snapshot.delay.ms":"10000","log.mining.strategy":"online_catalog","provide.transaction.metadata":"true","decimal.handling.mode":"string","database.history.skip.unparseable.ddl":"true","database.history.store.only.captured.tables.ddl":"true","log.mining.transaction.retention.hours":"1","database.user":"logminer","database.dbname":"ABCDnew","sanitize.field.names":"true","database.history.kafka.bootstrap.servers":"kafka-1:9092,kafka-2:9092,kafka-3:9092","database.server.name":"ABCDr2","heartbeat.interval.ms":"1000","event.processing.failure.handling.mode":"skip","database.port":"1521","rac.node":"192.168.1.52,192.168.1.53,192.168.1.54","database.hostname":"ABCD-db-new-scan","database.password":"123456789","name":"oracle_logminer_200821-1331","table.include.list":"ABCD_SHARD_1_3.D_LOT_VERSION,ABCD_SHARD_1_3.D_LOT_ENTITY,ABCD_SHARD_1_3.D_LOT_STATUS_HISTORY,ABCD_SHARD_1_3.D_PROCEDURE_LOT_ENTRY,ABCD_SHARD_1_3.D_LOT_LOT_ENTRY,ABCD_SHARD_1_3.D_PROCEDURE_VERSION,ABCD_SHARD_1_3.D_PROCEDURE_ENTITY,ABCD_SHARD_1_3.D_PLAN_SCHEDULE_LOT_ENTRY,ABCD_SHARD_1_3.D_PLAN_SCHEDULE_VERSION,ABCD_SHARD_1_3.D_PLAN_SCHEDULE_ENTITY,ABCD_SHARD_1_3.D_BID,ABCD_SHARD_1_3.D_EA_PARTICIPANT,ABCD_SHARD_1_3.D_LOT_LOTNUM_ENTRY,ABCD_SHARD_1_3.D_PROCEDURE_STATUS_HISTORY,ABCD_SHARD_1_3.D_OOS_EXCHANGE_PROTOCOL,ABCD_SHARD_1_3.D_PROCEDURE_DATE,ABCD_SHARD_1_3.D_OOS_FTP_PROTOCOL,ABCD_SHARD_1_3.D_COMMISSION_SESSION,ABCD_SHARD_1_3.D_LOT_NMC,ABCD_SHARD_1_3.D_LOT_NMC_EXAMINATION,ABCD_SHARD_1_3.D_PURCHASE_PLAN_ENTITY,ABCD_SHARD_1_3.D_PURCHASE_PLAN_VERSION,ABCD_SHARD_1_3.D_PURCHASE_PLAN_STATUS_HISTORY,ABCD_SHARD_1_3.D_PLAN_SCHEDULE_STATUS_HISTORY,ABCD_NSI.N_SPGZ,ABCD_NSI.N_CHARACTERISTIC_SPGZ,ABCD_NSI.N_SPGZ_CHARACTERISTIC_SPGZ,ABCD_NSI.N_CHARACTERISTIC_SPGZ_ENUM,ABCD_NSI.N_KPGZ,ABCD_NSI.N_CHARACTERISTIC_KPGZ,ABCD_NSI.N_KPGZ_CHARACTERISTIC_KPGZ,ABCD_NSI.N_CHARACTERISTIC_KPGZ_ENUM,ABCD_NSI.N_KPGZ_CONTRACT_TEMPLATE,ABCD_NSI.N_KPGZ_TECH_TASK,ABCD_NSI.N_CHARACTERISTIC,ABCD_NSI.N_OKEI_SPGZ","snapshot.mode":"schema_only"}
      

      Attachments

        Activity

          People

            ccranfor@redhat.com Chris Cranford
            chapeauclaque Dmitriy Rum (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: