3528230 - Error: unique constraint violated when trying to copy the data from virtual table to the target table - SDI

• Unable to copy the data from virtual table into the target table, and failed with the following error.
• • [301] unique constraint violated: Table (), Index() with error: unique constraint violation in self check for table
• The framework trace contains the error.
  • [ERROR] DPFramework | AsyncHandler.processStreamingExecuteStatement [] - AH: Exception while processing request "SDA Response for OracleECCAdapter of type SUCCESS_MSG responding to FEDERATION_GET_NEXT"
  • [ERROR] DPFramework | AsyncHandler.processStreamingExecuteStatement [] - AH: com.sap.hana.dp.adapter.sdk.AdapterException: Closed Resultset: wasNull Context: java.sql.SQLRecoverableException: Closed Resultset: wasNull
• The index server trace contains the error.
  • e SQLUpdate        MultiStoreInsert.cc: ChunkWise Insert-subSelect error: unique constraint violated
  • e Row_Engine       qx_trex.cc: copy_row_to_column error occurs
  • e Row_Engine       qx_trex.cc: unique constraint violated: Table(), Index() with error: unique constraint violation in self check for table, column='$trexexternalkey$'

SAP HANA Smart Data Integration

Data Duplication, Primary Key, Adapter, DP Agent, Hana, Oracle , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem