SAP Knowledge Base Article - Preview

3212507 - Issue with loading duplicated records to Direct Update ADSO

Symptom

There was a change on how duplicate values are handled when data is loaded into a Direct Update ADSO:

  • Before SAP HANA 2.0 SPS06, any duplicate records would simply get overwritten.
  • Afterwards, the following error appears in connected DTP logs:

SQL error with code '301'. See the following SQL message:
=> unique constraint violated: Table(/BIC/A...2), Index(/BIC/A...2~0) w
=> ith error: unique constraint violation in self check for table <schema>:/B
=> IC/A...2en, column='', value='32332c535449434b204551554956414c454e5420564f
=> 4c554d453b332c43474c3b322c4443', pos=35895; indexname=/BIC/A...2~0
Exception CX_RSDHA_MSG logged


Read more...

Environment

  • SAP NetWeaver
  • SAP HANA, platform edition 2.0

Product

SAP HANA, platform edition 2.0 ; SAP NetWeaver all versions

Keywords

"unique constraint violation in self check for table", SQL error with code '301', AMDP, ADSO , KBA , HAN-DB-ENG-BW , SAP HANA BW Engine , BW-WHM-DST-DTP , Data Transfer Process , BW-WHM-DBA-ADSO , DataStore Object (advanced) , Problem

About this page

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

Search for additional results

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