nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Arcpy DeleteRows tool: error code 000732

KevinPiraino2

I have created a simple python script to do the following:

Scrape web page for data listed in table/json
Write data into local FGDB table
Map data in local FGDB using coordinates
Replace SDE data with mapped data in local FGDB

Everything works up until step 4 which includes a DeleteRows function call and then an Append function call. I am using DeleteRows instead of truncate due to database locks. Currently this script works perfectly fine from my local machine, but on our server machine where this script will reside for scheduling purposes I run into the error 000732: dataset does not exist or is not supported. I have run through all of the suggested workarounds/solutions and none worked. I even ran the tool in catalog on the server machine and it worked, just not in the script.

Make sure file path provided is correct.
Make sure file path provided is not a relative file path.
No spaces in file path name
No misspellings
Backslashes instead of forward slashes
No subtypes
Process runs on windows machine not UNIX or Linux so hopefully no issue with Copy Rows or Make XY Event Layer tools
Disabled background geoprocessing

Are there any additional suggestions or could this possibly be a bug?

Najděte více příspěvků označených jako

Accepted answers

All comments

Lorne

I suggest getting the connection string properties and embedding that into your script. Here's an example for connecting into SQL Server.

fc = "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' \
      xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' \
      xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.6.0'> \
      <WorkspaceConnectionString> \
      ENCRYPTED_PASSWORD=XXX0000XXXX; \
      SERVER=TGISDB001SQL; \
      INSTANCE=sde:sqlserver:my_instance; \
      DBCLIENT=sqlserver; \
      DB_CONNECTION_PROPERTIES=My_DataBase; \
      DATABASE=My_Data; \
      USER=user; \
      VERSION=dbo.DEFAULT; \
      AUTHENTICATION_MODE=DBMS \
      </WorkspaceConnectionString> \
      <WorkspaceFactory>SDE</WorkspaceFactory> \
      <Dataset>Mydata.Dataset.FeatureClass</Dataset> \
      <DatasetType>esriDTFeatureClass</DatasetType> \
      </CIMStandardDataConnection>"

KevinPiraino2

Yes you are correct, it is using an SDE file. I assume it's referencing the connection file properly. I have the SDE connection file located in the same folder the script runs from and the script references the file as such:

db_test = r'C:\rn_development\COVID_Testing_Sites\AZURE_HealthDepartment_gisadministrator_93.sde\HealthDepartment.DBO.CovidTestSites\HealthDepartment.DBO.IDPH_COVID_Test_Sites'

arcpy.DeleteRows_management(db_test)

As for the file being the same on the local machine, yes to an extent. The exact paths differs, but the file was originally copied from local machine to the server when I was setting up the final testing on the server machine.

DavidPike

if it's an SDE it's using a connection file I guess? Is that connection file being properly referenced and is the same as on the local machine?

KevinPiraino2

David,

No the error occurs when trying to use the Delete Rows function against the SDE database table/feature class. Currently when I run the Delete Rows function against the SDE database table/feature class from my local machine the function has no problem executing. The issue occurs when attempting to run the Delete Rows function against the SDE database table/feature class from our server machine (where the script will be run from once its fully tested). I'm 99% sure its not the file path name since I was able to navigate to the SDE table/feature class using the file path the script uses (both in windows file explorer and ArcCatalog on the server machine). I even ran the Delete Rows tool in ArcCatalog (using the SDE data) and it ran fine. I then took the code snippet from the results pane and inserted it into the script and it still failed.

DavidPike

The path isn't a Mapped drive on your local machine? Have you tried UNC or attempting to navigate to that path in Catalog/Windows Explorer on the server?

KevinPiraino2

Tomasz,

Thank you for your suggestion, but unfortunately all of my variables that contain string paths already have the "r" pre-fix so this suggestion does not apply.

TomaszTARCHALSKI1

Hi,

make sure that the variable path is set like this:

myvariable_path = r'C:\Temp\Integrations'

the letter "r" (raw path) is important.

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.