Duplicate Extended properties table names

Question

Hi All,

We are using ArcGIS enterprise version: 10.9.1 & ArcGIS Pro V 2.9

We have created a "Template" with the name "testtemplate" with the table name "temptable" in the "Extended Properties" and delete the template with one of the following reason

Reason to delete the template: Created a table name with 'RELATIONSHIP' 1-1 and saved template. Actually it should be 1-M. We have to delete the template.

WFM is allowing to create new "Template" with the same name "testtemplate", but it is not allowing to create table with the same name "temptable" in the "Extended Properties". It is throwing the following error.

Failed to update job template: Duplicate extended property table name(s) found: temptable.

Is this expected behavior or did we missed anything.

We have around 80+ extended property tables (with different 'RELATIONSHIP' like 1-1 & 1-M) with 30+ Templates and 20+ flow diagrams and we want the same tables names in DEV,UAT, PROD.

Current workaround following: We have created a new "Workflow Item" altogether and recreating templates with the extended property.

@JFarmer Please suggest.

UmmiHamizah · Answer

Hello @TiffanyWeintraub,

I'm currently facing the same issue. I cannot save the job template as duplicated table is found even when I created a new table with a new name. Is there any workaround on how to delete the extended properties table from the workflow database?

TiffanyWeintraub · Answer

Hello @sirishb. The reason you are getting this particular error message about duplicate table names is because when you delete the extended property table from the job template or the entire job template in the web application, the underlying tables do not get deleted from the workflow database. So when you try to create a new table with that same name, it is finding the previous table.

Thank you for reaching out to the community with your question. Currently, this is expected behavior but we do have an item in our backlog to address this issue and make this data clean up process a little more transparent.