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