SAP Knowledge Base Article - Preview

3044801 - SDI : Cameljdbc Adapter Data Extraction failing with (dberror) [686]: start task error execution error: ,,,,,,, Camel execution failed.

Symptom

  • When running the Rep-Task the error below occurs:

    An error occurred while executing statement 'call "review_store.START_REPLICATION"' with error message '(dberror) [686]: start task error: "XXXXXXXX"."review_store.START_REPLICATION": line 3 col 0 (at pos 113): [34051] internal error: Remote execution error Camel execution failed. for query "SELECT "VT_review_store"."review_id", "VT_review_store"."store_id" FROM "review_store" "VT_review_store" " at SQLUpdate/Storage/Impl/PipelinedSdaSearch.cc:339; Statement: ,INSERT INTO "XXXXXXXX"."review_store" ("review_id", "store_id") SELECT "review_id", "store_id" FROM (WITH _SYS_WITH_1 AS (SELECT "review_id" , "store_id" FROM "XXXXXXXX"."VT_review_store" AS "VT_review_store") , _SYS_WITH_0 AS (SELECT "XXXXXXXXx_3_VT_review_store_READER"."review_id" AS "review_id", "XXXXXXXX_3_VT_review_store_READER"."store_id" AS "store_id" FROM _SYS_WITH_1 AS "XXXXXXXX_3_VT_review_store_READER" ) SELECT "review_id" AS "review_id", "store_id" AS "store_id" FROM _SYS_WITH_0 AS "READER" )'9:54:10 AM (LSPManager) Programming language services have been loaded.

  • DPAgent framework.trc shows:

     2021-03-25 14:21:12,863 [ERROR] DefaultErrorHandler | CamelLogger.log - Failed delivery for (MessageId: ID-hecxxxxxxx-xxxxx-xx-x on ExchangeId: ID-hecxxxxxxx-xxxxx-xx-x). Exhausted after delivery attempt: 1 caught: com.sap.hana.dp.adapter.sdk.AdapterException: Unparseable date: "1989-06-11T00:00" Context: java.text.ParseException: Unparseable date: "1989-06-11T00:00"
    at java.text.DateFormat.parse(DateFormat.java:366)


Read more...

Environment

  • HANA SDI
  • CamelJDBCAdapter

Product

SAP HANA smart data integration 2.0

Keywords

686 START_REPLICATION , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.