topic Re: script tool in Python Questions

script tool

jayasudha — Thu, 08 Dec 2016 12:21:59 GMT

I have created script tool which uses cx_oracle and able to add in arcgis tool box. This tool executed fine in arcgis.
Then i have created gp service using this script and the service is created successfully on arcgis server.
But when i try to execute this gp service from arcgis, there is following error from server logs.
Any suggestions on how to resolve this ?

SEVERE Dec 8, 2016 5:40:27 PM Error executing tool. test/test.GPServer

SEVERE Dec 8, 2016 5:40:27 PM Traceback (most recent call last):
File "C:\arcgisserver\directories\arcgissystem\arcgisinput\test\test.GPServer\extracted\v101\pmms\module1.py",
line 19, in import cx_Oracle ImportError: DLL load failed:
%1 is not a valid Win32 application.
Failed to execute (Script). Failed to execute (Script). test/test.GPServer

Re: script tool

NeilAyres — Thu, 08 Dec 2016 13:08:16 GMT

I think server is running 64bit.

What is this tool using which is trying to execute something in 32bit.

Having had some recent experience getting GP services to run, its a bit of an art. Stuff can work perfectly as a tool in Desktop, but then just do nothing at all running as a service on the server.

Re: script tool

jayasudha — Fri, 09 Dec 2016 08:51:06 GMT

Python is installed with ArcGIS ( i think both are 32 bit).

Any work around for this ?

Re: script tool

JonathanQuinn — Fri, 09 Dec 2016 20:22:17 GMT

You need to make sure that the 64 bit version of the cx_oracle module is available on the Server. Once you do that, try to import it using the version of Python included with the Server install, (you can use Idle). If it imports in Idle, your service will work.

Re: script tool

jayasudha — Sat, 10 Dec 2016 06:04:36 GMT

Thanks for your reply.

I have installed 64 bit cx_Oracle as mentioned in your link.

cx_Oracle-5.2.1-11g.win-amd64-py2.7.exe (md5)

Then i set path variable to refer C:\Python27\ArcGISx6410.1;C:\Python27\ArcGISx6410.1\Lib\site-packages.

I started IDLE from server install and tried to import cx_Oracle. There is error.

Traceback (most recent call last):
File "<pyshell#0>", line 1, in <module>
import cx_Oracle
ImportError: No module named cx_Oracle
>>>

Re: script tool

JonathanQuinn — Mon, 12 Dec 2016 20:02:20 GMT

Can you verify that the cx_oracle package exists in the C:\Python27\ArcGISx6410.5\Lib\site-packages folder?

Re: script tool

jayasudha — Tue, 13 Dec 2016 04:16:04 GMT

C:\Python27\ArcGISx6410.1\Lib\site-packages folder contains following.

cx_Oracle.pyd --> PYD file

cx_Oracle-5.2.1-py2.7.egg-info --> folder

               dependency_links
               PKG-INFO
               SOURCES
               top_level

Re: script tool

JonathanQuinn — Tue, 13 Dec 2016 18:37:37 GMT

Hm, to be honest, I don't really understand how that module installs. Perhaps someone else with more knowledge on it can help out. After installing, I was expecting to see a cx_oracle folder, (or something to that effect), with the associated scripts, (_init_.py, etc) in it.

Re: script tool

JoshuaBixby — Tue, 13 Dec 2016 18:45:41 GMT

How did you install cx_Oracle? If you are getting an import error, then it isn't installed correctly.

Re: script tool

JonathanQuinn — Tue, 13 Dec 2016 18:48:22 GMT

I downloaded the .exe and ran through the setup wizard. It created the folders the OP described, so it sounds like the OP did the same thing. Not sure if the installer is funny or there are other steps required.

Re: script tool

JoshuaBixby — Tue, 13 Dec 2016 19:42:38 GMT

JQuinn-esristaff‌, my apologies, my question was directed at the OP. If the OP is getting an import error, the module didn't install correctly. I wonder if the OP has multiple Python installations on the same machine and the installer is getting mixed up and either installing in the wrong place or mixing up configuration parameters.

Re: script tool

jayasudha — Wed, 14 Dec 2016 08:01:02 GMT

https://pypi.python.org/packages/52/71/b4d90ee0c21002559562e0749e0c127017d58cfa37cc0d7c240e8ff2448c/cx_Oracle-5.2.1-11g.…

I installed cx_Oracle 64 bit using above link.

Both ArcGIS and ArcGIS server are in same machine.

The folder C:\Python27 contains ArcGIS10.1, ArcGISx6410.1

The environment variables are as below.

C:\Python27\ArcGIS10.1;

C:\Python27\ArcGISx6410.1\Lib\site-packages;

C:\Program Files\ArcGIS\Server\arcpy\arcpy;

C:\Program Files (x86)\ArcGIS\Desktop10.1\arcpy\arcpy

Re: script tool

DanPatterson_Retired — Wed, 14 Dec 2016 08:52:13 GMT

your software is quite old... check to see if some of your issues have been addressed in more recent versions of your software or combinations of it