topic Re: ArcPy.DA runs on 32 bit not 64 in Python Questions

ArcPy.DA runs on 32 bit not 64

EricFulcher1 — Tue, 28 Apr 2020 22:50:16 GMT

So the following script worked on Arcpy 32 bit but not on 64 bit IDLE. Any thoughts? 10.6.1 arcgis.

ALSO - this works against an fgdb but not an enterprise geodatabase (Oracle).

Thanks,

Eric

arcpy scripting‌

--- Script

import arcpy

arcpy.env.workspace = "D:/WOBufferScripts/GLSVDEVL@GLS.sde"

arcpy.da.SearchCursor("GLS.MWO", ['SHAPE@'], "OBJECTID > 0")

print "It Worked"

--- 32 Bit Results

32 BIT

Python 2.7.14 (v2.7.14:84471935ed, Sep 16 2017, 20:19:30) [MSC v.1500 32 bit (Intel)] on win32

Type "copyright", "credits" or "license()" for more information.

>>>

================== RESTART: D:\WOBufferScripts64bit\test.py ==================

It Worked

>>>

--- 64 Bit Results

64 bit

Python 2.7.14 (v2.7.14:84471935ed, Sep 16 2017, 20:25:58) [MSC v.1500 64 bit (AMD64)] on win32

Type "copyright", "credits" or "license()" for more information.

>>>

================== RESTART: D:\WOBufferScripts64bit\test.py ==================

Traceback (most recent call last):

File "D:\WOBufferScripts64bit\test.py", line 4, in <module>

arcpy.da.SearchCursor("GLS.MWO", ['SHAPE@'], "OBJECTID > 0")

RuntimeError: cannot open 'GLS.MWO'

Re: ArcPy.DA runs on 32 bit not 64

JoeBorgione — Sun, 12 Dec 2021 03:38:12 GMT

I don't have an answer but when it comes to cursors, I like to set up a variable for the feature class or table name that you are cursoring through:

fc = r'D:/WOBufferScripts/GLSVDEVL@GLS.sde/GLS.WMO'
arcpy.da.SearchCursor(fc, ['SHAPE@'], "OBJECTID > 0")‍‍

Re: ArcPy.DA runs on 32 bit not 64

DanPatterson_Retired — Tue, 28 Apr 2020 23:05:06 GMT

It was a while ago, but didn't you have to install python for Background Geoprocessing to get 64 bit arcpy?

Re: ArcPy.DA runs on 32 bit not 64

EricFulcher1 — Tue, 28 Apr 2020 23:05:18 GMT

um so do I. simplified the code to 3 lines to isolate the issue.

Re: ArcPy.DA runs on 32 bit not 64

EricFulcher1 — Tue, 28 Apr 2020 23:06:03 GMT

I have both 32 and 64 bit installed. the results are from each on the same server.

Re: ArcPy.DA runs on 32 bit not 64

JoshuaBixby — Wed, 29 Apr 2020 19:10:20 GMT

You likely have a configuration issue with your 64-bit Oracle client. Make sure both your 32-bit and 64-bit Oracle clients are installed and configured properly.

Re: ArcPy.DA runs on 32 bit not 64

EricFulcher1 — Wed, 29 Apr 2020 19:12:36 GMT

Correct sir! - I had forgotten to put tnsnames in the 64 bit directory