SAP Knowledge Base Article - Preview

2138895 - Index definition not replicated - SAP PD

Symptom

  • Due to this, the DDL (SQL Script) is wrong and when Oracle runs it, it fails, as it tries to create the index again after having created the constraint. And, as it has the same name, the script fails (in Oracle, when the constraint is created, the index is also created automatically).
  • When a table with a Pkey index is replicated, not only the index columns should be replicated but also the index definition. By default, the definition of the replicated Pkey index is <None> and both a primary key constraint and a primary key index are to be generated:

/*==============================================================*/
/* Table: T_1 */
/*==============================================================*/
create table T_1 
(
C_1 CHAR(10) not null
);

alter table T_1
add constraint KEY_1 primary key (C_1);

/*==============================================================*/
/* Index: KEY_1 */
/*==============================================================*/
create unique index KEY_1  on T_1 (
C_1 ASC
);

  • The Oracle server will raise an error due the Primary key is auto-indexed and the index already exists.
  • If the replica had brought the right "column definition" it would not have happened because the DDL would not have included the redundant index creation sentence:

/*==============================================================*/
/* Table: T_1 */
/*==============================================================*/
create table T_1 
(
C_1 CHAR(10) not null
);

alter table T_1
add constraint KEY_1 primary key (C_1);

  • In source PDM:

Source_table_index_pk.PNG

  • In Target:

target_table_ind_pk.PNG


Read more...

Environment

  • SAP PowerDesigner (PD) 16.5 
  • SAP PowerDesigner (PD) 16.6
  • DBMS: Oracle

Product

SAP PowerDesigner 16.5 ; SAP PowerDesigner 16.6

Keywords

association, pdm, pkey index, CR780791, 780791, CR#780791 , 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.