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

627
2
04-03-2018 01:46 PM
ShyamsunderVanga
New Contributor

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")

0 Kudos
2 Replies
BalajiVeera
Occasional Contributor

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.

0 Kudos
ShyamsunderVanga
New Contributor

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.

0 Kudos