ArcIMS 导致 ArcSDE空间数据库日志中报 error code -51 错误的解决方案

最新推荐文章于 2022-08-29 09:12:21 发布

最新推荐文章于 2022-08-29 09:12:21 发布 · 317 阅读

文章标签：

#数据库

本文介绍了解决ArcSDE中出现的ERR2407错误的方法，通过查阅ArcSDE的帮助文件，定位到具体的DBMS错误，并给出了一个使用无效操作数导致该错误的示例。

出现这种标志性的错误，其实最好的方法是到ArcSDE的帮助文件中查找错误代号，在ArcSDE帮助中得到如下信息

[ERR2407] (SDE error code {error code} {message})

Example 2: When there is an underlying DBMS error. In this example, an invalid operand is used.
[Jan 15, 2004 10:49:55 AM][1316 2132 INFO1] Begin Request [Jan 15, 2004 10:49:55 AM][1316 2132 INFO3] REQUEST: <GET_FEATURES featurelimit="25" beginrecord="1" outputmode="xml" geometry="false" envelope="true" checkesc="true"> <LAYER id="0"> </LAYER> <SPATIALQUERY subfields="#ALL#" where="SDEUSER.WORLD.ABBREVNAME=='France'" > </SPATIALQUERY> </GET_FEATURES> [Jan 15, 2004 10:49:55 AM][1316 2132 INFO1] GET_FEATURES: world [Jan 15, 2004 10:49:55 AM][1316 2132 INFO2] <GET_FEATURES> QS start processing... [Jan 15, 2004 10:49:55 AM][1316 2132 ERROR] [ERR2407] (SDE error code -51 ) SE_stream_query : Underlying DBMS error [Jan 15, 2004 10:49:55 AM][1316 2132 ERROR] RESPONSE: <ERROR machine="MYMACHINE" processid="1316" threadid="2132">[ERR2407] (SDE error code -51 ) SE_stream_query : Underlying DBMS error</ERROR> [Jan 15, 2004 10:49:55 AM][1316 2132 INFO1] Total Request Time: 0.015000s [Jan 15, 2004 10:49:55 AM][1316 2132 INFO1] End Request

Example 2: When there is an underlying DBMS error. In this example, an invalid operand is used.

[Jan 15, 2004 10:49:55 AM][1316 2132 INFO1] Begin Request
[Jan 15, 2004 10:49:55 AM][1316 2132 INFO3] REQUEST: <GET_FEATURES featurelimit="25" beginrecord="1" outputmode="xml" geometry="false" envelope="true" checkesc="true">
<LAYER id="0">
</LAYER>
<SPATIALQUERY subfields="#ALL#" where="SDEUSER.WORLD.ABBREVNAME=='France'" >
</SPATIALQUERY>
</GET_FEATURES>

[Jan 15, 2004 10:49:55 AM][1316 2132 INFO1] GET_FEATURES: world
[Jan 15, 2004 10:49:55 AM][1316 2132 INFO2] <GET_FEATURES> QS start processing...
[Jan 15, 2004 10:49:55 AM][1316 2132 ERROR] [ERR2407] (SDE error code -51 ) SE_stream_query : Underlying DBMS error
[Jan 15, 2004 10:49:55 AM][1316 2132 ERROR] RESPONSE: <ERROR machine="MYMACHINE" processid="1316" threadid="2132">[ERR2407] (SDE error code -51 ) SE_stream_query : Underlying DBMS error</ERROR>
[Jan 15, 2004 10:49:55 AM][1316 2132 INFO1] Total Request Time: 0.015000s
[Jan 15, 2004 10:49:55 AM][1316 2132 INFO1] End Request

对应到更详细的Underlying DBMS就能大致定为问题所在。