Changing label & name for a schema in Adobe Campaign

[NR2]

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 !!

[ParthaSarathy]

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

[NR2]

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]

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.