When I run my py script I get an "Error: Out of Memory" at the last task arcpy.ImportXMLWorkspaceDocument_management. We're using 10.6 software by Esri. Does anyone know if it's related to how I wrote the script or possibly some other problem?
# Name: EnterpriseGDB.py # Description: Import/Export the contents of my geodatabase to an XML workspace document. # Import system modules import arcpy import os import platform import imp import time xmlDocument = r"C:\EnterpriseGDB.xml" if arcpy.Exists(xmlDocument): print("Removing xml document") os.remove(xmlDocument) print("successful") # Set overwrite output arcpy.env.OverwriteOutput = True # Set local variables for exports in_data = r"Database Connections\SDE.sde" out_file = r"C:\EIS\EISMASTER\eis shape\ArcMap\EnterpriseGDB.xml" export_option = "DATA" storage_type = "BINARY" export_metadata = "METADATA" # Set local variables for imports target_gdb = r"C:\EIS\EISMASTER\eis shape\ArcMap\UPDM.gdb" in_file = r"C:\EIS\EISMASTER\eis shape\ArcMap\EnterpriseGDB.xml" import_type = "DATA" config_keyword = "DEFAULTS" print("Exporting SDE to XML Document") # Execute ExportXMLWorkspaceDocument arcpy.ExportXMLWorkspaceDocument_management(in_data, out_file, export_option, storage_type, export_metadata) print("Finished Exporting") time.sleep(120) print("Importing NEW XML Document to Local GDB") # Execute ImportXMLWorkspaceDocument arcpy.ImportXMLWorkspaceDocument_management(target_gdb, in_file, import_type, config_keyword) print("Finished Importing!")
Do you have the ability to try this script an another computer running 10.6? Or possibly try running the script on a computer running an older version such as 10.5.x?
What kind of SDE geodatabase are you trying to extracting data from (e.g. SQL Server, Oracle, other)?
I've got it running on another computer right now. I'll check it in a few to make sure it's running properly and get back to here.
The second PC running the script has the same version. If it fails I will try the script on another PC with 10.5.
The SDE geodatabase is hosting in SQL Server 2012.