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 for Me (Login required).

Search for additional results

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