Changing label & name for a schema in Adobe Campaign | Community
Skip to main content
N
NR2
November 21, 2024
Solved

Changing label & name for a schema in Adobe Campaign

  • November 21, 2024
  • 1 reply
  • 660 views

We created a schema in Adobe Campaign Client 8.6.2 from external database (Snowflake). The table name for example snowflake is ABC_DEF_GHI and the label and Name provided when creating the schema in Adobe was the same
ABC_DEF_GHI. We would like to change the label to ABC DEF GHI & name to abcDefGhi (Pascal Casing). When I tried to edit label="ABC DEF GHI" & name="abcDefGhi"
There were errors displayed when I changed it & saved. When I cleared cache, disconnected & reconnect back & searched there are 2 entries, one with the old label & name & another with new label & name.The old one works fine while the new one on going to Data tab or other tabs show below error

"XSV-350000 Unable to load document of identifier 'rqa:abcDefGhi' and type 'xtk:schema'." Please let me know how to resolve this issue. Your inputs are much appreciated !!

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 somasundaram_h

Hi @nr2, you may try regenerating the schema. Select the schema 'rqa:abcDefGhi' -> right click -> Actions -> Regenerate selected Schemas. Once regenerated, try to disconnect and reconnect and check once.

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity Advisor
Community Advisor
November 22, 2024

Hi @nr2 ,

When you modify the internal name of the existing schema, it will be treated as new schema.

In your new label schema, check in element tag the following parameters are added,

dataSource="nms:extAccount:internal_name_of_your_snowflake_integration_externalAccount" sqltable="yourSqlTableName"

(You can see the sqltable in your old schema preview tab)

<disconnect & reconnect>

Also, you can try File > clear the local cache... > disconnect & reconnect

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
N
NR2Author
November 22, 2024

Hi @parthasarathy.,

 

Thank you so much for the suggestion. The issues still persists for some reason. I re-tried following the stepas you mentioned and changed the name & label  as per my new requirement & double checked that the new schema has the same dataSource & sqltable values as the original schema. I also did a text compare between old & new schema and only label, name, lastModified & mdf5 (checksum) values are different. I then cleared cache, disconnected & reconnected and checked the new schema but I get the same error "XSV-350000 Unable to load document of identifier 'rqa:abcDefGhi' and type 'xtk:schema'."

somasundaram_h
Community Advisor
somasundaram_hCommunity AdvisorAccepted solution
Community Advisor
November 25, 2024

Hi @nr2, you may try regenerating the schema. Select the schema 'rqa:abcDefGhi' -> right click -> Actions -> Regenerate selected Schemas. Once regenerated, try to disconnect and reconnect and check once.

Terms & ConditionsAccessibility statement

Loading footer...