topic ArcSDESQLExecute problems in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/arcsdesqlexecute-problems/m-p/110698#M3784 <HTML><HEAD></HEAD><BODY><SPAN>I'm looking for anyone who has had experience with arcpy.ArcSDESQLExecute.</SPAN><BR /><BR /><SPAN>I am trying to use Python in ArcGIS 10.1 to return a selected set from an ArcSDE/SQL Server table and write it out to a new table in a file geodatabase. Right now I'm just doing some basic testing to see if I can get it to work correctly because at 9.3.1 there was a serious bug related to the handling of NULL values. That issue appears to be fixed, but now I'm having a different problem.</SPAN><BR /><BR /><SPAN>The new issue I'm having with ArcGIS 10 version is that the returned object (list of lists) causes a Visual C++ error when the object is deleted. Doesn't matter when I delete the list object or if I let&nbsp; Python clean up after executing the script. It will throw that error and I have to kill the application. I've tried running from ArcCatalog and ArcMap as an ArcTool.</SPAN><BR /><BR /><SPAN>There seems to be some relationship with the number of records returned. If I only do a few hundred, the script will usually exit successfully. I've tested with several hundred thousand records in different tables and don't see the client running out of memory and I can iterate through the list without any problems and write everything to a new table.</SPAN><BR /><BR /><SPAN>I also tried pausing the script for a few seconds at different points, but haven't seen any difference in performance.</SPAN><BR /><BR /><SPAN>My test script is attached, any help would be greatly appreciated!</SPAN><BR /><BR /><SPAN>-Steve</SPAN></BODY></HTML> Tue, 23 Aug 2011 15:30:10 GMT StevePeaslee 2011-08-23T15:30:10Z ArcSDESQLExecute problems https://community.esri.com/t5/geoprocessing-questions/arcsdesqlexecute-problems/m-p/110698#M3784 <HTML><HEAD></HEAD><BODY><SPAN>I'm looking for anyone who has had experience with arcpy.ArcSDESQLExecute.</SPAN><BR /><BR /><SPAN>I am trying to use Python in ArcGIS 10.1 to return a selected set from an ArcSDE/SQL Server table and write it out to a new table in a file geodatabase. Right now I'm just doing some basic testing to see if I can get it to work correctly because at 9.3.1 there was a serious bug related to the handling of NULL values. That issue appears to be fixed, but now I'm having a different problem.</SPAN><BR /><BR /><SPAN>The new issue I'm having with ArcGIS 10 version is that the returned object (list of lists) causes a Visual C++ error when the object is deleted. Doesn't matter when I delete the list object or if I let&nbsp; Python clean up after executing the script. It will throw that error and I have to kill the application. I've tried running from ArcCatalog and ArcMap as an ArcTool.</SPAN><BR /><BR /><SPAN>There seems to be some relationship with the number of records returned. If I only do a few hundred, the script will usually exit successfully. I've tested with several hundred thousand records in different tables and don't see the client running out of memory and I can iterate through the list without any problems and write everything to a new table.</SPAN><BR /><BR /><SPAN>I also tried pausing the script for a few seconds at different points, but haven't seen any difference in performance.</SPAN><BR /><BR /><SPAN>My test script is attached, any help would be greatly appreciated!</SPAN><BR /><BR /><SPAN>-Steve</SPAN></BODY></HTML> Tue, 23 Aug 2011 15:30:10 GMT https://community.esri.com/t5/geoprocessing-questions/arcsdesqlexecute-problems/m-p/110698#M3784 StevePeaslee 2011-08-23T15:30:10Z