Select to view content in your preferred language

script tool

2174
12
12-08-2016 04:21 AM
jayasudha
Emerging Contributor

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

0 Kudos
12 Replies
JoshuaBixby
MVP Esteemed Contributor

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.

0 Kudos
jayasudha
Emerging Contributor

https://pypi.python.org/packages/52/71/b4d90ee0c21002559562e0749e0c127017d58cfa37cc0d7c240e8ff2448c/... 

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

0 Kudos
DanPatterson_Retired
MVP Emeritus

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

0 Kudos