ACS Schema - Key issue | Community
Skip to main content
New Participant
February 22, 2019
Solved

ACS Schema - Key issue

  • February 22, 2019
  • 2 replies
  • 2621 views

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>

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by AbdulZa

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

2 replies

AbdulZaAccepted solution
New Participant
February 26, 2019

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

New Participant
February 25, 2019

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