Hello, I am trying to publish an ArcGIS geoprocessing service in 10.2 I have a script setup that will run multiple times through Pycharm, but when I run it in ArcGIS it will run once and return this error: Traceback (most recent call last): File "C:\Users\\Desktop\git\GeoprocessingService.py", line 477, in <module> main() File "C:\Users\Desktop\git\GeoprocessingService.py", line 372, in main cur) File "C:\Users\Desktop/git\GeoprocessingService.py", line 136, in value_query results = cur.fetchall() File "C:\Python27\ArcGIS10.2\lib\site-packages\psycopg2\extras.py", line 81, in fetchall res = super(DictCursorBase, self).fetchall() File "C:\Python27\ArcGIS10.2\Lib\decimal.py", line 543, in __new__ m = _parser(value.strip()) TypeError: 'NoneType' object is not callable Failed to execute (Script). The script itself is 800 lines, but here is the query I have been running that errors out: def value_query(id_field, id, value_fields, start_date, end_date, date_field, table, cur): query2 = "SELECT " for field in value_fields: query2 += "NULLIF({0}, '-999')::NUMERIC(6,2),".format(field) query2 += "{0} " \ "FROM {1} " \ "WHERE {2} = '{3}' AND {0} BETWEEN '{4}' AND '{5}' " \ "ORDER BY {0} ASC;".format(date_field, table, id_field, id, start_date, end_date) #print "This is Query:" #print query arcpy.AddMessage("{0}".format(query2)) cur.execute(query2) results = cur.fetchall() #print "These are value query results:\n\n {0}".format(results) return results Like I said it runs once in ArcGIS then errors out. However, if I close Arc completely and run the exact same script again, it runs once then stops. I feel like there may be some sort of caching or something that Arc does, but am completely stumped.
... View more