ArcSDE10.2.2执行ST_Geometry时报ORA-20006

 

 

 

 

问题描述：ArcSDE 10.2.2执行ST_Geometry的ST_ASTEXT操作符，将Geometry对象转换为WTK串，如果数据量比较大，比如我测试的数据打出超过1000条数据时，系统会报ORA-20006错误。

ORA-20006: Error generating text from shape (-1)
ORA-06512: 在 "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 67
ORA-06512: 在 "SDE.ST_GEOMETRY_OPERATORS", line 118

----------------------------------------------------------------------------------

版权所有，文章允许转载，但必须以链接方式注明源地址，否则追究法律责任!

Blog:               http://blog.csdn.net/linghe301

----------------------------------------------------------------------------------

测试数据数据量大小

SQL> select count(*) from city;

  COUNT(*)
----------
      2907

----------------------------------------------------------------------------------

版权所有，文章允许转载，但必须以链接方式注明源地址，否则追究法律责任!

Blog:               http://blog.csdn.net/linghe301

----------------------------------------------------------------------------------

测试过程

SQL> select sde.st_astext(shape) from city where objectid<1000;


......




SDE.ST_ASTEXT(SHAPE)
--------------------------------------------------------------------------------

52, 40.87825342 8.68879323, 40.88545342 8.68801382, 40.88795342 8.68567562, 40.8

9275342 8.68788392, 40.89705342 8.69684747, 40.89825342 8.70061497, 40.89865342
8.70711096, 40.90105342 8.70957953, 40.90405342 8.71048901, 40.90605342 8.714776

69, 40.90695342 8.71854479, 40.90915342 8.72153336, 40.91315342 8.72530168, 40.9

1895342 8.73153917, 40.92185342 8.73530782, 40.92735342 8.74089605, 40.93645342
8.73582764, 40.93905342 8.73257879, 40.94005342 8.72842038, 40.94095342 8.724651

96, 40.94435342 8.72166330, 40.94985342 8.71854479, 40.95315342 8.71763524, 40.9

6015342 8.71971422, 40.96415342 8.72075373, 40.96785342 8.72088367, 40.97085342
8.71893460, 40.97425342 8.71919447, 40.97945342 8.72127348, 40.98135342 8.724911


ERROR:
ORA-20006: Error generating text from shape (-1)
ORA-06512: 在 "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 67
ORA-06512: 在 "SDE.ST_GEOMETRY_OPERATORS", line 118



已选择216行。

----------------------------------------------------------------------------------

版权所有，文章允许转载，但必须以链接方式注明源地址，否则追究法律责任!

Blog:               http://blog.csdn.net/linghe301

----------------------------------------------------------------------------------

经过与美国Support的沟通，认定为一个Bug，该问题将在ArcGIS10.3版本解决。

 

[#NIM099098 The ST_AsText SQL function is failing when the result set contains more that one record and NumPoints is ~2000 (or more)..]

The issue is resolved in 10.3.

----------------------------------------------------------------------------------

版权所有，文章允许转载，但必须以链接方式注明源地址，否则追究法律责任!

Blog:               http://blog.csdn.net/linghe301

----------------------------------------------------------------------------------