This is the issue:
I have an Oracle spatial (point) table where at least one record has an empty geometry field. The field isn't null, it's completely empty. This record caused my initial workbench to crash with an spatial index creation error.
I identified the offending table and started analyzing the table starting with a workbench containg only the table (using an Oracle spatial reader) and an inspector. That one gave this error:
An error occurred converting an Oracle OCINumber object to an integer: `OCI-22060: argument u2] is an invalid or uninitialized number'. (serverType=`ORACLE8i', serverName=`pkgnnat', userName=`KGNAT_HAVL', password=`***', dbname=`')
Error converting Oracle Spatial object geometry type to an integer: message was `An error occurred converting an Oracle OCINumber object to an integer: `OCI-22060: argument u2] is an invalid or uninitialized number'. (serverType=`ORACLE8i', serverName=`pkgnnat', userName=`KGNAT_HAVL', password=`***', dbname=`')'
This error kept coming back whatever I tried:
A geometryfilter (looking for null type object): error
Geometrextractor/ geometryremover: error
Command line Oracle spatial functions yield this error:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "MDSYS.SDO_GEOM", line 70
ORA-06512: at "MDSYS.SDO_GEOM", line 1851
And a query looking for an empty field fail as well.
BTW: I identified the record by looking at the number of records the workbench WAS able to read and check the next one.
Any suggestions?