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
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.
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
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