Closed rbovard closed 5 years ago
Hi @rbovard, as you can find under Known issues:
Geocom Database Management Tools do not support Esri Workgroup license.
But you can adapt /py/gc_sql_utils.py - Lin 137 to:
FROM dbo.SDE_table_registry
Best, @thbuchmann
Hi @thbuchmann,
Thanks a lot for your quick workaround, it worked well!
I didn't think about this limitation, since I didn't have a problem with the old script for indexes and it worked well with the same license level.
Best regards.
PS: You can close this issue or not if it's relevant to keep it opened.
Hi @rbovard,
no problem - I think your old script was already adapted ;-)
I'll close the issue. If you have further problems, please let us know.
Best, @thbuchmann
Oh, I just checked it and the schema was not defined:
getTableId = """
SELECT registration_id,imv_view_name
FROM SDE_table_registry
WHERE table_name = '{tablename}'
"""
Is there any reason why you added it?
You're right! for Workgroup there's not always the need to define the "dbo"-scheme because it's the "default"-scheme if you're working with sa-permissions.
Hi @thbuchmann,
I encounter an issue while running
SetSpatialIndexesGeometryMSSQL
script:The full trace:
The database is SQL Server 2017.