ACS Schema - Key issue | Community
Skip to main content
S
santhoshsrg
Level 4
February 22, 2019
Solved

ACS Schema - Key issue

  • February 22, 2019
  • 2 replies
  • 2627 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

    S
    santhoshsrgAuthor
    Level 4
    February 25, 2019

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

    A
    AbdulZaAccepted solution
    Level 3
    February 26, 2019

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

      Terms & ConditionsAccessibility statement

      Loading footer...