SDE 10 for DB2打sp1补丁需要注意的问题

原创 2011年01月10日 10:53:00

今天查看ArcSDE 10升级的网页,发现了以下的消息,对使用DB2的用户进行SDE升级的时候会有帮组的。

This applies to upgrading ArcSDE from 10 to 10 SP1 ONLY. When you upgrade, a call to the stored procedure, SDE_RELEASE_PROC, is made to determine whether the ArcSDE schema, procedures, and functions need to be upgraded. At the end of the upgrade process, the SDE_RELEASE_PROC procedure itself is dropped and re-created. However, the DROP PROCEDURE fails as a result of locks. If a LOCKTIMEOUT has not been set, the process hangs. If LOCKTIMEOUT is set, the operation rolls back and the upgrade fails. In the error logs, you will see the following error message:

db_execute_ddlsql SQL
 Stmt: <DROP
 PROCEDURE
 SDE.sde_release_proc> 
ERROR in
 creating system stored procedures.
Error: -1
DBMS error code: -454
SQL0454N The signature provided in
 the definition for
 routine
 "SDE.SDE_RELEASE_PROC" matches the signature of
 some
 other routine
 that already exists
 in
 the schema
 or
 for
 the type. LINE NUMBER=1. SQLSTATE
=42723 

Esri is working with IBM to resolve this problem under PMR(Problem Management Record) - 67192,756,000.

The current workaround is as follows:

1. Open a DB2 command window on the client machine from which you will run the Upgrade Geodatabase tool or script.

2. Connect to the ArcSDE geodatabase as the sde user.

db2 connect
 to
 <dbname> user
 sde using
 <sde_password> 
 
3. Drop the sde_release_proc.
 
db2 "drop
 procedure
 sde_release_proc" 
 
4. Once the stored procedure has been dropped, you can proceed with the upgrade
版权声明:本文为博主原创文章,未经博主允许不得转载。

相关文章推荐

ArcSDE10升级SP1补丁

ArcGIS10刚出不久(可能是个人感觉),SP1补丁就出了,唉,没有办法,这么大的软件,肯定会有这样那样的问题,还好,我们一直在努力不断更新。 那么出了新补丁,我们就同步打上好了,避免解决一些关于...

VS10sp1-KB983509 vs2010补丁

  • 2015-03-16 08:34
  • 795KB
  • 下载

微软vs2010的sp1补丁for WinXP

  • 2013-10-24 21:16
  • 6.13MB
  • 下载

VS2008SP1中jQuery Intellisense补丁KB958502安装失败的解决办法

提示:首先确信您一定以及肯定打了SP1的补丁。本文仅适用于您在打了SP1补丁后依然出现不能安装的问题,提示“此计算机上没有安装本软件更新支持的产品。单击“取消”退出安装程序。” 原因...

IE10 for Windows 7 SP1中文版64位

  • 2013-03-19 11:55
  • 43.12MB
  • 下载

先ArcGIS 9.3安装引起的VS2008 sp1补丁及VS2010安装失败的解决办法

最近刚购置了一台新的小本本,给她配备了Win7旗舰版的系统,主要是想用她来自学开发Silverlight for Windows Phone及ArcGIS API for Silverlight的,可...

ie10 for win7 sp1

  • 2013-01-03 10:17
  • 22.75MB
  • 下载

vs2005环境window embedded wince6.0 SP1+R2+R3补丁包

*************************************************************** Windows Embedded CE 6.0 R3.msi的下载地址...
  • wk_sky
  • wk_sky
  • 2013-05-21 14:00
  • 1550
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:深度学习:神经网络中的前向传播和反向传播算法推导
举报原因:
原因补充:

(最多只允许输入30个字)