ACS Schema - Key issue

Avatar

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

22 likes

Total Posts

56 posts

Correct reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

22 likes

Total Posts

56 posts

Correct reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile
santhoshsrg
Level 3

22-02-2019

I created an Integer field and then assigned it as custom identification key. I haven't assigned Automatic primary key.

I also want Create, Duplicate and Delete permissions for this resource data. When i started "Prepare publication" process, I am getting the below mentioned error.

Please provide a fix for this

Error: "At least one key field in 'Client Id (clientId)' must have a default value to authorise creating data."

I am trying to achieve the below schema definition in Campaign standard.(Note: There is no default value assigned here) Is this possible?

Schema in Campaign Classic:

    <attribute label="Client Id" name="clientId" sqlname="CLIENT_ID" type="int64"/>

    <key internal="true" name="PK">

      <keyfield xpath="@clientId"/>

    </key>

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 5
Level 4
AbdulZa
Level 4

Likes

43 likes

Total Posts

50 posts

Correct reply

8 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 4
AbdulZa
Level 4

Likes

43 likes

Total Posts

50 posts

Correct reply

8 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
AbdulZa
Level 4

25-02-2019

Since this is an integer column. Can you just default to zero? Usually, all numeric columns defaulted to zero.

Answers (1)

Answers (1)

Avatar

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

22 likes

Total Posts

56 posts

Correct reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile

Avatar
Give Back 5
Level 3
santhoshsrg
Level 3

Likes

22 likes

Total Posts

56 posts

Correct reply

2 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 3
Ignite 1
View profile
santhoshsrg
Level 3

25-02-2019

It is mandatory in ACS to give default value for all "PK" fields