Expand my Community achievements bar.

Accelerate your Campaign learning with the Adobe Campaign Mentorship Program 2023!
SOLVED

Hi i am creating a schema and getting this error , i have created schemas before but did not encountered this error, it would very helpful if anybody can help me out thank you

Avatar

Level 2

Screenshot (98).pngScreenshot (99).png

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

You almost got it, here it is

 

<srcSchema _cs="Intersets (aks)" created="2023-04-24 12:34:44.410Z" createdBy-id="0"
entitySchema="xtk:srcSchema" img="xtk:schema.png" label="Intersets" labelSingular="Interest"
lastModified="2023-04-24 12:35:39.963Z" mappingType="sql" md5="1920390063D80ACF0C51EA5D183AE180"
modifiedBy-id="0" name="interest" namespace="aks" xtkschema="xtk:srcSchema">
	<createdBy _cs="Hote.user1526 (Hote.User1526)"/>
	<modifiedBy _cs="Hote.user1526 (Hote.User1526)"/>
		
	<element autopk="true" label="Intersets" labelSingular="Interest" name="interest">
		<key internal="true" name="productBrands">
			<keyfield xpath="@productBrands"/>
		</key>	
		<attribute label="Product Categories" length="80" name="productCategories" type="string"/>
		<attribute label="Product Brands" length="80" name="productBrands" type="string"/>
		<attribute label="Product Sizes" length="40" name="productSizes" type="long"/>
		<attribute label="Gender" length="40" name="gender" type="string"/>
		<attribute label="Intersets" labelSingular="Interest" name="interest"/>
		<attribute label="Product Categories" length="80" name="productCategories" type="string"/>
	</element>
</srcSchema>

View solution in original post

9 Replies

Avatar

Community Advisor

The error is clear

 

David__Garcia_0-1682340144382.png

 

Avatar

Level 2

I am getting different error after doing it Screenshot (100).png

Avatar

Community Advisor

Remove the first line called Element and just copy the attribute, in the schema structure you can only have one wrapper called element with all the attributes inside of it.

 

Here is the schema structure documentation https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/schema-r...

 

<srcSchema>
    <enumeration>
        ...          //definition of enumerations
    </enumeration>

    <element>         //definition of the root <element>    (mandatory)

        <compute-string/>  //definition of a compute-string
        <dbindex>
            ...        //definition of indexes
        </dbindex>
        <key>
            ...        //definition of keys
        </key>
        <sysFilter>
            ...           //definition of filters
        </sysFilter>
        <attribute>
            ...             //definition of fields
        </attribute>

            <element>           //definition of sub-<element>
                  <attribute>           //(collection, links or XML)
                  ...                         //and additional fields
                  </attribute>
                ...
            </element>

    </element>

        <methods>                 //definition of SOAP methods
            <method>
                ...
            </method>
            ...
    </methods>

</srcSchema>

 

Avatar

Level 2

means not use element tag and use them as attributes?

Avatar

Community Advisor

Copy and paste your code here after making the changes I mentioned and I'll amend the code.

Avatar

Level 2

<srcSchema _cs="Intersets (aks)" created="2023-04-24 12:34:44.410Z" createdBy-id="0"
entitySchema="xtk:srcSchema" img="xtk:schema.png" label="Intersets" labelSingular="Interest"
lastModified="2023-04-24 12:35:39.963Z" mappingType="sql" md5="1920390063D80ACF0C51EA5D183AE180"
modifiedBy-id="0" name="interest" namespace="aks" xtkschema="xtk:srcSchema">
<createdBy _cs="Hote.user1526 (Hote.User1526)"/>
<modifiedBy _cs="Hote.user1526 (Hote.User1526)"/>
<element label="Intersets" labelSingular="Interest" name="interest">

<attribute label="Product Categories" length="80" name="productCategories" type="string"/>
<attribute label="Product Brands" length="80" name="productBrands" type="string"/>
<key internal="true" name="productBrands">
<keyfield xpath="@productBrands"/>
</key>
<attribute label="Product Sizes" length="40" name="productSizes" type="long"/>
<attribute label="Gender" length="40" name="gender" type="string"/>
<attribute label="Intersets" labelSingular="Interest" name="interest"/>

<attribute label="Product Categories" length="80" name="productCategories" type="string"/>
</element>

</srcSchema>

Avatar

Correct answer by
Community Advisor

You almost got it, here it is

 

<srcSchema _cs="Intersets (aks)" created="2023-04-24 12:34:44.410Z" createdBy-id="0"
entitySchema="xtk:srcSchema" img="xtk:schema.png" label="Intersets" labelSingular="Interest"
lastModified="2023-04-24 12:35:39.963Z" mappingType="sql" md5="1920390063D80ACF0C51EA5D183AE180"
modifiedBy-id="0" name="interest" namespace="aks" xtkschema="xtk:srcSchema">
	<createdBy _cs="Hote.user1526 (Hote.User1526)"/>
	<modifiedBy _cs="Hote.user1526 (Hote.User1526)"/>
		
	<element autopk="true" label="Intersets" labelSingular="Interest" name="interest">
		<key internal="true" name="productBrands">
			<keyfield xpath="@productBrands"/>
		</key>	
		<attribute label="Product Categories" length="80" name="productCategories" type="string"/>
		<attribute label="Product Brands" length="80" name="productBrands" type="string"/>
		<attribute label="Product Sizes" length="40" name="productSizes" type="long"/>
		<attribute label="Gender" length="40" name="gender" type="string"/>
		<attribute label="Intersets" labelSingular="Interest" name="interest"/>
		<attribute label="Product Categories" length="80" name="productCategories" type="string"/>
	</element>
</srcSchema>

Avatar

Level 5

Hi @Akash_SM 

 

Could try once moving the defined key at the beginning of attributes or after the definition of attributes.

 

Regards

A

Avatar

Level 5

Something like below

  <element label="interest" name="Intersets">
  <!-- Begining the defination of attributes 
<key internal="true" name="productBrands">
<keyfield xpath="@productBrands"/>
</key>
-->
<attribute label="Product Categories" length="80" name="productCategories" type="string"/>
<attribute label="Product Brands" length="80" name="productBrands" type="string"/>
<attribute label="Product Sizes" length="40" name="productSizes" type="long"/>
<attribute label="Gender" length="40" name="gender" type="string"/>
<attribute label="Intersets" name="interest"/>
<attribute label="Product Categories" length="80" name="productCategories" type="string"/>

<!-- After the defination of attributes 
<key internal="true" name="productBrands">
<keyfield xpath="@productBrands"/>
</key>
-->
</element>