Expand my Community achievements bar.

SOLVED

ACS Schema - Key issue

Avatar

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

Avatar

Correct answer by
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

Avatar

Level 4

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

Avatar

Correct answer by
Level 4

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