SAP Knowledge Base Article - Preview

2966625 - Model can not be updated in the Repository because of SQL0803N error - SAP PD

Symptom

  • Updating a model into the repository via the Proxy is canceled.
  • The output displays:

Unexpected error while executing SQL statements in the repository
The check in of the document has been cancelled.

  • It occurs when creating a baseline version too.
  • It works fine when using a Direct ODBC repository definition.
  • Proxy log reports:

error - OdbcError(4): [23505] [IBM][CLI Driver][DB2/AIX64] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "SCHEMA.PMXATV" from having duplicate values for the index key. SQLSTATE=23505


Read more...

Environment

  • SAP PowerDesigner (PD) 16.7
  • IBM DB2

Product

SAP PowerDesigner 16.7

Keywords

check, checkin, check-in, 822731, CR822731, CR#822731 , KBA , BC-SYB-PD , PowerDesigner , Bug Filed

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.