Error:  ORA-13050: unable to construct spatial object

相关信息
Article ID: 40491
Software:
ArcSDE 8.0.1, 8.0.2, 8.1, 8.1.2, 8.2, 8.3, 9.0, 9.1, 9.2, 9.3, 9.3.1, 10, 10.1
Platforms: N/A

错误信息
Operations on Oracle Spatial layers cause an underlying database error similar to:

"ORA-13050: unable to construct spatial object
ORA-06512: at "MDSYS.SDO_3GL", line 1731
ORA-06512: at "MDSYS.SDO_3GL", line 1725
ORA-06512: at "MDSYS.SDO_3GL", line 1347"

This error may not be returned to the client directly. The error may be written to the sdedc_Oracle.log file, or the use of an SDEINTERCEPT may be needed to confirm this error. (See the related technical article for a description of how to run an SDEINTERCEPT.)

错误原因
A nil SDO_Geometry object is being accessed through a filter predicate. This usually happens when a nil geometry is inserted into the Adds table of a versioned feature class.
已邀请:

易智瑞技术支持

赞同来自:

解决方案
To correct this error, two actions may have to be taken. Upgrade the ArcGIS software to version 10.2 or later. A PL/SQL procedure also may have to be run to migrate values that are currently stored in the Adds table.
  1. Upgrade the ArcGIS client and geodatabase to version 10.2 or later.
  2. Retest the workflow. If the workflow no longer produces the error, do not proceed to Step 3.
  3. If the error is encountered after upgrading, run one of the following functions as the geodatabase administrator. • 

  • To migrate nil shapes in a specific table: begin
    begin   SDE.sdo_util.migrate_nil_shapes_to_current(<owner>,<table_name>,<geometry_column>);end;
    • 
  • To migrate nil shapes in all accessible tables:
    begin   SDE.sdo_util.migrate_nil_shapes_to_current;                                         end;

These procedures do not check for permissions on the underlying tables before starting. The geodatabase administrator must have SELECT and UPDATE privileges granted on each table to run the functions successfully.

创建及修改时间
Created: 8/3/2012

Last Modified: 1/23/2013
原文链接
http://support.esri.com/en/kno ... 40491

要回复问题请先登录注册