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

SOLVED

ACS Schema - Key issue

santhoshsrg
Level 4
Level 4

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>

1 Accepted Solution
AbdulZa
Correct answer by
Level 4
Level 4

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

View solution in original post

2 Replies
santhoshsrg
Level 4
Level 4

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

AbdulZa
Correct answer by
Level 4
Level 4

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

View solution in original post