Menu

#17 SE_shape_generate_point

open
nobody
None
5
2011-07-21
2011-07-21
No

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.

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.