Extract rule DDL Error

General
, ,
1

In pega 7.2 ,We are implementing Extract rule (BIX) in our organization for data migration by using DataBase schema method.

we have add all properties in the extract rule which we are expecting to extract in which we have same properties in different pages which holds different values. while generating DDL we are getting error that same properties with same name cannot be allowed.

But we want both properties.

Can anyone help us with this issue

2

Hi @rajkotiariga

Hope you are doing well.

Can you once try to generate DDL for one property at a time. Do for one property first and then try for the other property.

Thanks

Megha

3

@rajkotiariga ya that’s not possible in extract rule. If you are having same in different pages under the same table, then you need to use map to. You need to map those page properties to map to column. So while generating DDL those will be treated as different column and when it’s executed in DB, those map to columns will be created as column.

4

@Anoop Krishna Thank you its working