Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Unable to create Unique ID(Type Integer) for profile extension schema.

Avatar

Avatar
Validate 1
Level 1
krishnakanthpa1
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
krishnakanthpa1
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
krishnakanthpa1
Level 1

17-12-2017

Hi Everyone,

I have extended profile schema and added few attributes. I was specifically needed an attribute to be unique key with Integer (64 bits, ±9,223×10^15) as attribute type. But I'm getting following warning while I'm preparing publish.

Warning : No key field in 'test (test)' has a dynamic default value, duplicating a 'profile' entity will not be possible.

And I'm getting the following errors when I'm publishing

WDB-200001 SQL statement 'CREATE UNIQUE INDEX NmsRecipient_cusDbindex ON NmsRecipient(biCusPk_testid)' could not be executed.

PGS-220000 PostgreSQL error: ERROR: could not create unique index "nmsrecipient_cusdbindex" DETAIL: Key (bicuspk_testid)=(7118) is duplicated.

But when I change the attribute type into text and selecting dynamic default value(This is not available for integer type) everything is going well.

Can anyone tell me how can I keep attribute type as integer and create a unique key of it?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 1
krishnakanthpa1
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
krishnakanthpa1
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
krishnakanthpa1
Level 1

02-01-2018

Hi Everyone,

Really appreciate your help. Our team has figured out the issue. The warning can be ignored. We just have to check for duplicate values in the attribute column that we are setting as a unique key. So we have cleared the data and created the unique key and published the resource. Now everything works fine.

Thanks for all the help,

Krishna.

Answers (3)

Answers (3)

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

236 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

236 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

02-01-2018

Hi,

There is a dedicated feature in Campaign Standard to add such a field. Here is how to: Adobe Campaign Help | Generating a unique ID for profiles and custom resources

Florent

Avatar

Avatar
Validate 1
Level 1
krishnakanthpa1
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
krishnakanthpa1
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
krishnakanthpa1
Level 1

18-12-2017

Hi Shrawan,

Thank you for your response. But my issue is related with Adobe Campaign Standard not Adobe Campaign Classic.

Thanks

Avatar

Avatar
Boost 50
Employee
shrawans3153003
Employee

Likes

69 likes

Total Posts

150 posts

Correct Reply

66 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Boost 50
Employee
shrawans3153003
Employee

Likes

69 likes

Total Posts

150 posts

Correct Reply

66 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile
shrawans3153003
Employee

18-12-2017

Hi Krishna,

You can try below code for creating a unique index of type int.

<dbindex name="id1" unique="true">

      <keyfield xpath="@id1"/>

  </dbindex>

  <attribute label="Identifier1" name="id1" type="int64"/>

Please go through below link to know more this.

https://docs.campaign.adobe.com/doc/AC/en/CFG_Schema_Reference_Elements_and_attributes.html