MakeTableView loses definition query

DonMorrison1 — Sat, 11 Dec 2021 20:33:10 GMT

In my python code that generates mxd files, I changed the name of one of my table views from 'Organizations' to 'Organization' and later discovered that the table view's definition query became blank with that change. To make it even stranger, this only happens if arcpy.env.workspace is set to my enterprise database (None and a file geodatabase work OK). I expect I'll have to open a problem with ESRI, but thought I'd log it here in case anybody else stumbles on it. This is a very severe error for me since the definition query filters sensitive data out of the view - at least when it is working as designed. An obvious workaround is to name it something other than "Organization" but it does shake my confidence that I can trust that the sensitive data will always get filtered out appropriately.

Here is the test code that reproduces the problem

import os
import arcpy
DB_PATH = r'C:/Users/dmorri28/Documents/ArcGIS/Projects/MyProject/CC-SQL2k16-ERC-SDE.sde'
DB_TABLE = os.path.join(DB_PATH, 'ROW_Habitat.SDE.Program')
TITLES = ['DummyTitle', 'Organization', 'Org']
WORKSPACES = [None, DB_PATH, arcpy.env.scratchWorkspace]

def run_test (workspace, title):
 print ('***********************************')
 print ('Workspace: %s' % workspace)
 print ('Title: %s'% title)
 
 arcpy.env.workspace = workspace
 arcpy.MakeTableView_management(DB_TABLE, title, "Org_ID = 'FM'")
 
 table_view = arcpy.mapping.TableView(title)
 print ("Table view query: %s" % (str(table_view.definitionQuery)))
 
 arcpy.Delete_management(title, 'TableView')
if __name__ == '__main__':
 for workspace in WORKSPACES:
 for title in TITLES:
 run_test(workspace, title)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Here is the output - notice how on the fifth test the query is empty.

***********************************
Workspace: None
Title: DummyTitle
Table view query: Org_ID = 'FM'
***********************************
Workspace: None
Title: Organization
Table view query: Org_ID = 'FM'
***********************************
Workspace: None
Title: Org
Table view query: Org_ID = 'FM'
***********************************
Workspace: C:/Users/dmorri28/Documents/ArcGIS/Projects/MyProject/CC-SQL2k16-ERC-SDE.sde
Title: DummyTitle
Table view query: Org_ID = 'FM'
***********************************
Workspace: C:/Users/dmorri28/Documents/ArcGIS/Projects/MyProject/CC-SQL2k16-ERC-SDE.sde
Title: Organization
Table view query: 
***********************************
Workspace: C:/Users/dmorri28/Documents/ArcGIS/Projects/MyProject/CC-SQL2k16-ERC-SDE.sde
Title: Org
Table view query: Org_ID = 'FM'
***********************************
Workspace: None
Title: DummyTitle
Table view query: Org_ID = 'FM'
***********************************
Workspace: None
Title: Organization
Table view query: Org_ID = 'FM'
***********************************
Workspace: None
Title: Org
Table view query: Org_ID = 'FM' ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I was able to reproduce this on two different systems. I'm running this on Python 2.7. I'm also using ArcMap 10.6.1.

Re: MakeTableView - out_view of 'Organization' causes lost definition query

DonMorrison1 — Tue, 22 Sep 2020 04:56:37 GMT

It appears that it "fails" if there is a table in the workspace with the same name as the name of the table view being created (out_view). I have a table called Organization in my enterprise database (but not DummyTitle or Org). I also have a table called Program and sure enough when I created a table view with that name, the definition query came out blank. So I guess that explains it - I really think it should throw an error in this case it the definition query can not be preserved.

topic Re: MakeTableView - out_view of 'Organization' causes lost definition query in Python Questions

MakeTableView loses definition query

Re: MakeTableView - out_view of 'Organization' causes lost definition query