while using dbms2sde i am getting the following error:
SE_shape_generate_point encountered a -139 error:
The specified coordinate exceeds the valid coordinate range
Here is the complete output:
Running: dbms2sde -o point -l geopost,shape -g 0.008000,0.000000,0.000000 -xnam
e longitude -yname latitude -w "shape is null and longitude is not null" -k v01_
geopost -key postalcode -i tims_sde -D tims -s dm1cke -u gdba -p *******
For fastest performance, use -stable, -load, and -buffer.
Summary information for rows being spatially enabled:
Column Count Minimum Maximum Average Std. Dev.
--------- ----- -------------- ------------ ------------- ------------
LONGITUDE 12620 -135.106686400 0.000000000 -67.404059073 35.724259500
LATITUDE 12620 -66.002300000 62.474631000 38.405415957 18.144956548
Key column(s) is not unique -- 4 duplicate rows may have incorrect shapes.
Rows Enabled Elapsed Time Estimated Time
------------ ------------ --------------
Failed attempt to spatially enable where "POSTALCODE='E5N0B2' and (shape is null
and longitude is not null)"
SE_shape_generate_point encountered a -139 error:
The specified coordinate exceeds the valid coordinate range
Could you please help? It is very critical.
Thanks,
Aravind.