topic AttributeError: ArcSDESQLExecute: in Python Questions

AttributeError: ArcSDESQLExecute:

CliveSwan — Tue, 29 Dec 2020 14:10:27 GMT

Greetings,

I am working in a locked down environment where I can't install any Python modules, so I have to rely on arcpy while working with SDE PostgresSQL.

I don't get any error message connecting, it doesn't return an error for the list of tables, only returns the wildcard, not the tables.

for tbl in tables: print(tbl) ## Only returns a single wildcard, not a list of tables

I get a DBMS error "-37 DBMS Table not found" when doing select or count..

import os, sys import arcpy import arcgis arcpy.env.workspace = r"D:\Users\user\Documents\ArcGIS\Projects\Databases\Databases.gdb" sdeconn = arcpy.ArcSDESQLExecute(r"Z:\a - Connection Files\gisserver_branch.sde") tables = ["%"] ## Logged IN print("Logged IN") for tbl in tables: print(tbl) sql = "select objectid from PRP_LandParcels_Ply" sdeconn_tables=sdeconn.execute(sql)

Appreciate any pointers, to get this working.

Regards,

Clive

Re: AttributeError: ArcSDESQLExecute:

DavidPike — Tue, 29 Dec 2020 14:36:59 GMT

I'm not to sure on arcpy.ArcSDESQLExecute, but you've created a list called 'tables' which has one string in it "%" - iterating over this will return a single %, it makes little sense.

You may have to find the tables intially using the sde connection and ListTables—ArcGIS Pro | Documentation

import arcpy # Set the current workspace arcpy.env.workspace = sde_connection # Get and print a list of tables tables = arcpy.ListTables() for table in tables: print(table)

'tables' will be what you use to iterate over.

You also need a result of executing each query, sdeconn_tables=sdeconn.execute(sql) excutes the query, but what do you want to do with the result object contained in it? I'd advise just a print statement until you get it working.

Also if you could explain what you're actually trying to achieve, someone much more informed than me could probably help you better.

Re: AttributeError: ArcSDESQLExecute:

BlakeTerhune — Tue, 29 Dec 2020 16:54:04 GMT

To start simple, ensure the user defined in the gisserver_branch.sde connection has SELECT privileges on the PRP_LandParcels_Ply table. Second, is the table in a different schema (owner) than the user connecting? You may need to specify the schema with the table name in the sql. Like schemaName.PRP_LandParcels_Ply