topic Re: Primary key allows duplicate entry in data dictionary in Application Development and Automation Discussions

Primary key allows duplicate entry in data dictionary

Former Member — Sun, 23 Mar 2014 05:21:22 GMT

Hi Friends,

I have created table to save contact details. here i have assigned USERID and CELL_NO as primary key but when i am trying to create new entry it allows duplicate value. How can i prevent this ?

Please review my attached image for more details.

Thank you Friends.

Re: Primary key allows duplicate entry in data dictionary

Former Member — Sun, 23 Mar 2014 05:24:53 GMT

use semantic key at dtp level

Re: Primary key allows duplicate entry in data dictionary

Former Member — Sun, 23 Mar 2014 05:29:17 GMT

Could you please explain about that ?

Re: Primary key allows duplicate entry in data dictionary

Former Member — Sun, 23 Mar 2014 05:38:38 GMT

Karthik,

There is nothing abnormal in the result..

The results are coming just the way you have defined it.

If you have defined both user id and cell no as primary key, then there will be a unique record for a combination of user id and cell no. If one of them changes, a new record would be created.

If you want only one record to be created for every cell no, make only cell no as the primary key, there wont be duplicates for cell no then.

Regards,

Susmitha

Re: Primary key allows duplicate entry in data dictionary

Former Member — Sun, 23 Mar 2014 06:00:03 GMT

Hi,

Try giving same cell no and same "USER ID" as well (since both a keys). Then it'll pop a message in the status bar saying 'a data record with the specific key already exists'.

As Susmitha said:- if you want only 1 record for every cell number make only "CELL NO" field as primary field.

Hope you understand the concept of primary key in this context.

Regards,

Krishna.

Re: Primary key allows duplicate entry in data dictionary

thangam_perumal — Sun, 23 Mar 2014 06:24:00 GMT

Hi Karthi,

I think table logic is correct. it mean if you entered both primary key same only it wont allow but here you mentioned same cell no but different ID so it will accepts.

E.g

cell no 1234

user id xxx

cell no 1234

user id xxx

above logic wont allows

but you mentioned

cell no 1234

user id xxx

cell no 1234

user id xyz

if you need to remove duplicates mean you should maintain primary key as cell no only not both..

revert back if you didnt get clear.

Regards,

Thangam.P

Re: Primary key allows duplicate entry in data dictionary

Former Member — Sun, 23 Mar 2014 08:06:42 GMT

Thanks for your reply . Now i am clear about this. But is there any other way to check both fields to have unique value ?

Re: Primary key allows duplicate entry in data dictionary

Former Member — Sun, 23 Mar 2014 08:11:02 GMT

I understood . Thanks for your reply. But is there any option to check for both filed to have unique value ?

Re: Primary key allows duplicate entry in data dictionary

Former Member — Sun, 23 Mar 2014 08:46:11 GMT

Yes its possible.

First as already mentioned create the table with cell_no as key.

This will prevent any duplicate values for cell_no.

Next, create an index for the table. Mark it as unique and include the field mandt and userid as the fields. This will prevent any duplicate values for userid too.

Warning - To create the unique index in the database, you must ensure that there are already no duplicate records for user id in the table. If there are duplicate records, then the index will not be created in the underlying database and hence, the duplicate check wont work.

Re: Primary key allows duplicate entry in data dictionary

Former Member — Sun, 23 Mar 2014 09:08:32 GMT

Thank you , Now it is working fine. But during Activation i got some warning message while activating index. could you please explain about it ?

Re: Primary key allows duplicate entry in data dictionary

Former Member — Sun, 23 Mar 2014 10:44:48 GMT

You probably have both the fields as primary key and the unique index created on one of the fields

If you have cell_id defined as primary key in the table, then you don't have to create a unique index for that same field, since an index already exists for that.

When you try to create an index with the same fields as the primary keys of the table, or a subset of the primary key fields, the above error will come.

Mark only one of the field cell or user id as primary key in the table, and the other field as the unique index. (You may need to go to SE14 and adjust and activate table when un-marking one of the fields as primary. )

Re: Primary key allows duplicate entry in data dictionary

Former Member — Sun, 23 Mar 2014 12:25:59 GMT

Now i Understood clearly , Thank you so much