Error Checking System St_geometry Type
服务时出现错误,查看日志 D:\Program Files\ArcGIS\ArcSDE\ora10gexe\etc\sde_esri_sde.log ------------------------------------------------------- ArcSDE 10.0 for Oracle10g Build 775 Fri Sep 17 11:45:27 2010 ------------------------------------------------------- ST_Geometry Schema Owner: (SDE) Type Release: 1007 Instance initialized for ((sde)) . . . Connected to instance . . . ERROR in checking system st_geometry type (1). Error checking the existence of system tables. Run the Upgrade Geodatabase tool to install/upgrade system tables (-450). Refer ArcSDE installation guide for instructions. 产生原因: 1. 安装 ArcSDE 10.0 后需要打补丁才可以使用。此次是安装 ArcSDE 10.0 后直接 post,post 过程中创建了地理数据库,导致后面打补丁也没有效果。 解决方案: 1. 正确的安装顺序是:安装 ArcSDE -> 安装 sp5 (最新补丁,sp1 应该也可以) -> Post。 知识拓展: 1. 如何将 ArcSDE 9.3 升级为 10.0。 参考: http://support.esri.com/en/downloads/patches-servicepacks/view/productid/66/metaid/1877#install-UpgradeGDB http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/A_quick_tour_of_ArcSDE_geodatabase_upgrades/002n0000005n000000/ 上一篇 下一篇 暂无评论,我去发表~ 评论(2) oracle,32位,arcgis,esri 我的热门文章 “未能找到元数据文件”问题的处理 c# winform 利用 windows media player 循环播放视频 HRESULT:0X800736FD 问题的解决 ora-12514 TNS 无监听程序 ArcSde Service(esri_sde) 服务启动后又停止了 相关博文 未登录 •首页 •移动开发 •Web前端 •架构设计 •编程语言 •互联网 •数据库 •系统运维 •云计算 •研发管理 •综合 0 0 2 分享 微信分享新浪微博QQ好友QQ空间 取 消
ERROR in checking system st_geometry type 2013-11-27 14:18 1398人阅读 评论(2) 收藏 举报 本文章已收录于: 分类: ArcGIS(14) 作者同类文章X 版权声明:本文为博主原创文章,未经博主允许不得转载。 环境: Oracle 10.2.0.3.0 ArcSDE 10.0 32位 在安装 ArcSDE 过程中,创建 ArcSDE 服务时出现错误,查看日志 D:\Program Files\ArcGIS\ArcSDE\ora10gexe\etc\sde_esri_sde.log ------------------------------------------------------- ArcSDE 10.0 for Oracle10g Build 775 Fri Sep 17 11:45:27 2010 ------------------------------------------------------- ST_Geometry Schema http://m.blog.csdn.net/article/details?id=16985127 Owner: (SDE) Type Release: 1007 Instance initialized for ((sde)) . . . Connected to instance . . . ERROR in checking system st_geometry type (1). Error checking http://blog.csdn.net/lrh_079/article/details/16985127 the existence of system tables. Run the Upgrade Geodatabase tool to install/upgrade system tables (-450). Refer ArcSDE installation guide for instructions. 产生原因: 1. 安装 ArcSDE 10.0 后需要打补丁才可以使用。此次是安装 ArcSDE 10.0 后直接 post,post 过程中创建了地理数据库,导致后面打补丁也没有效果。 解决方案: 1. 正确的安装顺序是:安装 ArcSDE -> 安装 sp5 (最新补丁,sp1 应该也可以) -> Post。 知识拓展: 1. 如何将 ArcSDE 9.3 升级为 10.0。 参考: http://support.esri.com/en/downloads/patches-servicepacks/view/productid/66/metaid/1877#install-UpgradeGDB http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/A_quick_tour_of_ArcSDE_geodatabase_upgrades/002n0000005n000000/ 顶 0 踩 0 上一篇Network IO Error 下一篇VS2010+ArcGIS Engine 10 在 .Net Framework 3.5 下如何正确运行 我的同类文章 ArcGIS(14) http://blog.csdn.net 参考知识库 更多资料请参考: 猜你在找 查看评论 * 以上用户言论只代表其个人观
Error (100, retrieving bind info for query) oggĿͬ logdump >> http://orax.blog.sohu.com/253932195.html ־ sde Geodatabase tool to upgrade http://gis.stackexchange.com/questions/148792/repair-check-for-empty-geometry-in-arcsde system tables 2013-01-29 16:12 Ķ(?)(0)༭ɾ http://blog.sina.com.cn/s/blog_681b9c910100q5cc.html http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002n000000p8000000.htm http://forums.arcgis.com/threads/1197-Beta-10-Geodatabase-upgrade-feedback Win7+ArcSDE10 +Oracle11gΪ64λװsde10 sp1SDE鿴־ʾϢ-------------------------------------------------------ArcSDE 10.0 for Oracle11g Build 775 Fri Sep 1711:45:27 2010-------------------------------------------------------ST_Geometry Schema Owner: (SDE) Type Release: error checking 1007Instance initialized for ((sde)) . . .Connected to instance . . .ERROR in checking system st_geometry type (1).Error checking the existence of system tables. Runthe Upgrade Geodatabase tool to install/upgrade system tables(-450).Refer ArcSDE installation error checking system guide for instructions. ҪϵͳʾUpgrade Geodatabase tool ǴGP Update GeodatabaseУѡʱ֣sdeûsdeļGPʧܣô죿Oracleû⣬ǾOracle ֱӣGPUpdate Geodatabase ѡֱӣִСOKٴSDEUpgrading an ArcSDE geodatabase in OracleResource Center Beginning withArcGIS 10, geodatabases are upgraded using the Upgrade Geodatabasegeoprocessing tool or Python script. Therefore, you must have thecurrent version of ArcGIS Desktop, ArcGIS Engine, or ArcGIS Serverinstalled on the computer from which you will run the upgrade becausethese applications can run the geoprocessing tool or Python script.Caution: If you havegeodatabases in the schemas of users other than the sde user, you mustfirst upgrade the sde master geodatabase, then upgrade each of thegeodatabases in the other users' schemas. Each geodatabase is upgrade
Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Geographic Information Systems Questions Tags Users Badges Unanswered Ask Question _ Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Repair/Check for empty geometry in ArcSDE? up vote 3 down vote favorite I understand that the standard validation/repair tools are not for use with ArcSDE and that ESRI needs to fix this, but are there work-arounds for at least checking where there might be empty geometry in a feature using ArcObjects or a script? Anything really. I'm attempting to export features from layers in an ArcSDE instance but some of those layers in the database give the "Attempted an operation on empty geometry" error when attempting to extract. I'm running ArcMap 10.3 arcpy arcmap arcsde arcgis-10.3 share|improve this question edited May 27 '15 at 20:29 PolyGeo♦ 39.1k1357143 asked May 27 '15 at 15:47 TacoB0t 10310 3 I suspect you are misidentifying the problem in this situation. Please edit the question to describe the environment and behavior more completely (which version of ArcGIS, what type of geometry storage, the coordinate system and coordinate reference values for the input and output layers, what exact command is being used to perform the export), so that the actual problem can be identified and a solution offered. –Vince May 27 '15 at 16:31 1 I think Vince may be correct. As are you, in that geometry repair cannot be run on sde data. However I think the empty geometry is more of a selection problem. If you are exporting from a csv, I have fixed this problem by selecting all of the rows (that have values) and then exporting. –Brad Nesom May 27 '15 at 19:06 add a comment| 3 Answers 3 active oldest votes up vote 2 down vote accepted ArcGIS does not include tools to detect corrupt geometries because it is not possible to create them (short of hacking the SDE metadata tables). Native SQL types can create corrupt geometries, if ArcGIS is not used in the pipeline, but then there are native tools to detect and repair or delete those same corrupt geometries, so no Esri tools are needed. A definition or selection query of SHAPE IS NULL or SH