注册

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
2014-07-18 添加评论
分享

没有找到相关结果

    已邀请:

    李少华

    赞同来自: 陈於立 

    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行。


    经过与美国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.
    回复时间：2014-07-18 15:20:37 1 0
    分享
    为什么被折叠? 0 个回复被折叠

    要回复问题请先登录或注册


    Copyright © 2025