topic Re: How to handle ORA-25440: signal received: Unhandled exception: code= c0000005 in Python Questions

How to handle ORA-25440: signal received: Unhandled exception: code= c0000005

ShyamsunderVanga — Tue, 03 Apr 2018 20:46:42 GMT

I am running python script to create json file. I have executed this code for various tables (all have shape geometry field) and works fine. Only for two of the tables (Oracle 11g) I am getting ORA-25440 error. These two tables are not any different from the successful ones. I am getting this error in arcpy.conversion.FeauturestoJson second statement below. From the first statement .shp file (2.1gb) is created and second statement creates .json file with 1kb and fails.

arcpy.FeatureClassToFeatureClass_conversion(fullTableName, stagingPath, tempFeature, where_clause="", field_mapping='SHAPE_AREA "SHAPE_AREA" false false true 0 Double 0 0 ,First,#,fullTableName,SHAPE.AREA,-1,-1;SHAPE_LEN "SHAPE_LEN" false false true 0 Double 0 0 ,First,#,fullTableName,SHAPE.LEN,-1,-1', config_keyword="")

arcpy.conversion.FeaturesToJSON(in_features=tempStagingFeature, out_json_file=stagingJsonFile, format_json="NOT_FORMATTED", include_z_values="NO_Z_VALUES", include_m_values="NO_M_VALUES", geoJSON="GEOJSON")

Re: How to handle ORA-25440: signal received: Unhandled exception: code= c0000005

BalajiVeera — Tue, 03 Apr 2018 22:49:34 GMT

Hi Shyam,

If input spatial tables from Oracle SDE, then it should be issue with table alias name was different from display name.

Use the Alias Name in python script. You can find the alias name from Table properties.

Re: How to handle ORA-25440: signal received: Unhandled exception: code= c0000005

ShyamsunderVanga — Wed, 04 Apr 2018 01:23:24 GMT

Veera, I looked at alias for both the tables. They are same as Table names. So, that is not the issue. Thanks for your suggestion.