Windows-Server-2003

Unicenter Software Delivery 4 在 W2003 SP2 升級後無法連接到 MS SQL 2000 數據庫

  • September 30, 2010

昨天我在安裝了 Unicenter Software Delivery 4 的 Windows Server 2003 上安裝了 Windows Server 2003 Service Pack 2。在安裝之前，我禁用了伺服器上的所有 CA 服務（Brightstor、SDO、RCO、TNG）和 MS SQL 2000 服務。

安裝 SP2 後，我再次啟用了服務，但 Unicenter 服務無法再連接到 MS SQL 2000 數據庫。數據庫本身已啟動並正在執行，我可以使用企業管理器連接到它。

dbcc checkdb不會在Unicenter 數據庫上返回任何錯誤。

Unicenter 服務在啟動期間會引發以下錯誤消息：

IM[1] 27/05 10:38:31,272 Installation Manager in init phase
IM[1] 27/05 10:38:31,694 Process IM(L) - [004152] failed to open database SDDATA. dbopen() call failed.
IM[1] 27/05 10:38:31,694 sqls error details:
IM[1] 27/05 10:38:31,694 (null)
IM[1] 27/05 10:38:32,069 ##EXCEPTION## TableError T@:PS_SQLS\isam_db.cxx:744.
IM[1] 27/05 10:38:32,069 ##EXCEPTION## TableError C@:TaskmgrL\ASMTML.CXX:596.
IM[1] 27/05 10:38:32,069 ##EXCEPTION## ErrorCode: 4711 in SDDATA:Isam::Isam. Process IM(L) - [004152] failed to open database SDDATA. dbopen() call failed.
IM[1] 27/05 10:38:32,069 sqls error details:
IM[1] 27/05 10:38:32,069 (null)
IM[1] 27/05 10:38:32,069  returned 0.
IM[1] 27/05 10:38:32,084 Persistent Storage could not be opened.
Error cause is found in the ASM Event Log. Restart Task Manager.
IM[1] 27/05 10:38:32,084 Failed to open database.
IM[1] 27/05 10:38:32,084 Installation Manager ends>

如果我使用chkmib_l檢查 Unicenter 配置，該工具會引發異常並創建一個小轉儲文件。

An Exception Occurred:

Time:
27/05 09:49:38,928

Reason:
ChkMIB_l.exe caused an UNKNOWN_EXCEPTION in module kernel32.dll at 7C82001B:77E4BEE7

Registers:
EAX=0012F908  EBX=00000000  ECX=00000000  EDX=02410004  ESI=0012F998 
EDI=0012F998  EBP=0012F958  ESP=0012F904  EIP=77E4BEE7  FLG=00000206 
CS =7C82001B      DS =B90023      SS =120023 
ES =120023      FS =7C82003B      GS =3F0000

Call Stack:
7C82001B:77E4BEE7 (0xE06D7363 0x00000001 0x00000003 0x0012F98C) kernel32.dll
7C82001B:77BB3259 (0x0012F9B8 0x2B017C50 0x2B024404 0x00B68C98) MSVCRT.dll
7C82001B:2B010C42 (0x00020003 0x010C00FE 0x003F0190 0x00B69050) PS.dll


<< SOFTWARE DELIVERY INSTANCE INFO >>

TRIGGER       0(1) instances:
JCE           0(1) instances:
TM            0(1) instances:
IM            0(1) instances:
DM            0(1) instances:
DPU           0(71) instances:
NATF          0(1) instances:
MIBCONV       0(0) instances:
API           0(4) instances:
DTSFT         0(0) instances:
TNGPOP        0(0) instances:
DGATE         0(0) instances:

<< FLUSHING MEMORY TRACES >>


<< STOP FLUSHING MEMORY TRACES >>

我將 SDO 服務的配置和系統配置與另一台安裝了 Windows Server 2003 SP2 且 SDO 工作的伺服器進行了比較。

配置相同，使用相同的驅動程序和軟體版本。

您知道導致連接問題的原因嗎？我應該解除安裝 unicenter 服務並在伺服器上進行全新安裝，還是應該刪除 Windows Server 2003 SP2？

我不想刪除 SP2，因為它是 WSUS3 SP2 的要求，我真的不想知道在這樣一個舊系統中有多少可能的漏洞利用 ;-)

非常感謝，祝您有愉快的一天。

您可以在下面找到有關係統和 SDO 服務的更多詳細資訊。

psinfo 輸出（系統資訊）

System information for \\CZZAAS1003:
Uptime:                    0 days 14 hours 38 minutes 50 seconds
Kernel version:            Microsoft Windows Server 2003, Multiprocessor Free
Product type:              Standard Edition
Product version:           5.2
Service pack:              2
Kernel build number:       3790
Install date:              23.9.2004, 11:16:11s
IE version:                6.0000
System root:               C:\WINDOWS
Processors:                2
Processor speed:           2.3 GHz
Processor type:            Intel(R) Xeon(TM) CPU
Physical memory:           1024 MB
Video driver:              RAGE XL PCI Family (Microsoft Corporation)

sdver 輸出（Unicenter 軟體傳遞版本）

Unicenter Software Delivery 4.0 SP1 I2 ENU [2901]
Copyright 2004 Computer Associates International, Incorporated

ms sql 2000版本和odbc驅動版本

MS SQL 2000 Server Standard Edition
Product Version: 8.00.760 (SP3)

ODBC Driver: SQL Server - Version 2000.86.3959.00

完整的 Unicenter 軟體傳遞服務日誌文件

TRIGGER[1] 27/05 10:38:28,366 SD Trigger Agent has started
NATF[1] 27/05 10:38:28,928 Initiation phase finished
IM[1] 27/05 10:38:31,272 Installation Manager in init phase
IM[1] 27/05 10:38:31,694 Process IM(L) - [004152] failed to open database SDDATA. dbopen() call failed.
IM[1] 27/05 10:38:31,694 sqls error details:
IM[1] 27/05 10:38:31,694 (null)
IM[1] 27/05 10:38:32,069 ##EXCEPTION## TableError T@:PS_SQLS\isam_db.cxx:744.
IM[1] 27/05 10:38:32,069 ##EXCEPTION## TableError C@:TaskmgrL\ASMTML.CXX:596.
IM[1] 27/05 10:38:32,069 ##EXCEPTION## ErrorCode: 4711 in SDDATA:Isam::Isam. Process IM(L) - [004152] failed to open database SDDATA. dbopen() call failed.
IM[1] 27/05 10:38:32,069 sqls error details:
IM[1] 27/05 10:38:32,069 (null)
IM[1] 27/05 10:38:32,069  returned 0.
IM[1] 27/05 10:38:32,084 Persistent Storage could not be opened.
Error cause is found in the ASM Event Log. Restart Task Manager.
IM[1] 27/05 10:38:32,084 Failed to open database.
IM[1] 27/05 10:38:32,084 Installation Manager ends
TM[1] 27/05 10:38:32,116 Task Manager in init phase
TM[1] 27/05 10:38:32,334 Process TM(L) - [006132] failed to open database SDDATA. dbopen() call failed.
TM[1] 27/05 10:38:32,334 sqls error details:
TM[1] 27/05 10:38:32,334 (null)
TM[1] 27/05 10:38:32,381 ##EXCEPTION## TableError T@:PS_SQLS\isam_db.cxx:744.
TM[1] 27/05 10:38:32,381 ##EXCEPTION## TableError C@:TaskmgrL\ASMTML.CXX:596.
TM[1] 27/05 10:38:32,381 ##EXCEPTION## ErrorCode: 4711 in SDDATA:Isam::Isam. Process TM(L) - [006132] failed to open database SDDATA. dbopen() call failed.
TM[1] 27/05 10:38:32,381 sqls error details:
TM[1] 27/05 10:38:32,381 (null)
TM[1] 27/05 10:38:32,381  returned 0.
TM[1] 27/05 10:38:32,381 Persistent Storage could not be opened.
Error cause is found in the ASM Event Log. Restart Task Manager.
TM[1] 27/05 10:38:32,381 Failed to open database.
TM[1] 27/05 10:38:32,381 Task Manager ends
DM[1] 27/05 10:38:33,272 Dialogue Manager is now active
API[1] 27/05 10:38:34,397 API Server Process in init phase
API[1] 27/05 10:38:34,397 API - SDNLS_Init
API[1] 27/05 10:38:34,397 API - connectEM
API[1] 27/05 10:38:34,412 API - apiServ.init
DM[1] 27/05 10:38:34,678  **AND** 1 Agents triggered
API[1] 27/05 10:38:34,709 Process API(L) - [005680] failed to open database SDDATA. dbopen() call failed.
API[1] 27/05 10:38:34,709 sqls error details:
API[1] 27/05 10:38:34,709 (null)
API[1] 27/05 10:38:34,756 ##EXCEPTION## TableError T@:PS_SQLS\isam_db.cxx:744.
API[1] 27/05 10:38:34,756 ##EXCEPTION## TableError C@:MainAPIL\APISERVL.CXX:246.
API[1] 27/05 10:38:34,756 ##EXCEPTION## ErrorCode: 4711 in SDDATA:Isam::Isam. Process API(L) - [005680] failed to open database SDDATA. dbopen() call failed.
API[1] 27/05 10:38:34,756 sqls error details:
API[1] 27/05 10:38:34,756 (null)
API[1] 27/05 10:38:34,756  returned 0.
API[1] 27/05 10:38:34,756 Open of the database failed.
API[1] 27/05 10:38:34,756 API - apiServ.init complete
API[1] 27/05 10:38:34,756 API - start_APIServer
DM[1] 27/05 10:38:34,803 CZZAAR1037
DPU[1:CZZAAR1037] 27/05 10:38:35,772 DPU in init phase
DPU[1:CZZAAR1037] 27/05 10:38:36,100 >> GetManagerData
DPU[1:CZZAAR1037] 27/05 10:38:36,287 >> SetCompInfo
DPU[1:CZZAAR1037] 27/05 10:38:36,334 >> GetContainerList
DPU[1:CZZAAR1037] 27/05 10:38:36,350 getJobState 3 from 5b6ad
DPU[1:CZZAAR1037] 27/05 10:38:36,350 getJobState 3 from 5b6ad
DPU[1:CZZAAR1037] 27/05 10:38:36,350 getJobState 3 from 5b6b7
DPU[1:CZZAAR1037] 27/05 10:38:36,350 getJobState 3 from 5b6b7
DPU[1:CZZAAR1037] 27/05 10:38:36,350 getJobState 3 from 5b6c1
DPU[1:CZZAAR1037] 27/05 10:38:36,350 getJobState 3 from 5b6c1
DPU[1:CZZAAR1037] 27/05 10:38:36,366 getJobState 3 from 5b6cb
DPU[1:CZZAAR1037] 27/05 10:38:36,366 getJobState 3 from 5b6cb
DPU[1:CZZAAR1037] 27/05 10:38:36,366 getJobState 3 from 5b6f9
DPU[1:CZZAAR1037] 27/05 10:38:36,366 getJobState 3 from 5b6f9
DPU[1:CZZAAR1037] 27/05 10:38:36,366 getJobState 3 from 5b71a
DPU[1:CZZAAR1037] 27/05 10:38:36,366 getJobState 3 from 5b71a
DPU[1:CZZAAR1037] 27/05 10:38:36,366 getJobState 3 from 5b724
DPU[1:CZZAAR1037] 27/05 10:38:36,381 getJobState 3 from 5b724
DPU[1:CZZAAR1037] 27/05 10:38:36,397 getJobState 3 from 5b72e
DPU[1:CZZAAR1037] 27/05 10:38:36,397 getJobState 3 from 5b72e
DPU[1:CZZAAR1037] 27/05 10:38:36,397 getJobState 3 from 5b738
DPU[1:CZZAAR1037] 27/05 10:38:36,397 getJobState 3 from 5b738
DPU[1:CZZAAR1037] 27/05 10:38:36,397 getJobState 3 from 5b742
DPU[1:CZZAAR1037] 27/05 10:38:36,397 getJobState 3 from 5b742
DPU[1:CZZAAR1037] 27/05 10:38:36,397 getJobState 3 from 5b74c
DPU[1:CZZAAR1037] 27/05 10:38:36,397 getJobState 3 from 5b74c
DPU[1:CZZAAR1037] 27/05 10:38:36,397 getJobState 3 from 5b756
DPU[1:CZZAAR1037] 27/05 10:38:36,397 getJobState 3 from 5b756
DPU[1:CZZAAR1037] 27/05 10:38:36,397 getJobState 3 from 5b78a
DPU[1:CZZAAR1037] 27/05 10:38:36,397 getJobState 3 from 5b78a
DPU[1:CZZAAR1037] 27/05 10:38:36,397 getJobState 3 from 5b7af
DPU[1:CZZAAR1037] 27/05 10:38:36,397 getJobState 3 from 5b7af
DPU[1:CZZAAR1037] 27/05 10:38:36,522 >> SetCompAttr
DPU[1:CZZAAR1037] 27/05 10:38:36,569 >> SetDetected
DPU[1:CZZAAR1037] 27/05 10:38:36,584 disconnect
DPU[1:CZZAAR1037] 27/05 10:38:36,584 getJobState 3 from 5b6ad
DPU[1:CZZAAR1037] 27/05 10:38:36,584 getJobState 3 from 5b6b7
DPU[1:CZZAAR1037] 27/05 10:38:36,584 getJobState 3 from 5b6c1
DPU[1:CZZAAR1037] 27/05 10:38:36,584 getJobState 3 from 5b6cb
DPU[1:CZZAAR1037] 27/05 10:38:36,584 getJobState 3 from 5b6f9
DPU[1:CZZAAR1037] 27/05 10:38:36,584 getJobState 3 from 5b71a
DPU[1:CZZAAR1037] 27/05 10:38:36,584 getJobState 3 from 5b724
DPU[1:CZZAAR1037] 27/05 10:38:36,584 getJobState 3 from 5b72e
DPU[1:CZZAAR1037] 27/05 10:38:36,584 getJobState 3 from 5b738
DPU[1:CZZAAR1037] 27/05 10:38:36,584 getJobState 3 from 5b742
DPU[1:CZZAAR1037] 27/05 10:38:36,584 getJobState 3 from 5b74c
DPU[1:CZZAAR1037] 27/05 10:38:36,584 getJobState 3 from 5b756
DPU[1:CZZAAR1037] 27/05 10:38:36,584 getJobState 3 from 5b78a
DPU[1:CZZAAR1037] 27/05 10:38:36,584 getJobState 3 from 5b7af
DPU[1:CZZAAR1037] 27/05 10:38:36,584 DPU ends
DM[1] 27/05 10:38:38,006  **AND** 0 Agents triggered
JCE[1] 27/05 10:38:38,053 JCE starts
DM[1] 27/05 10:38:38,287 CZZAAS1003
DPU[2:CZZAAS1003] 27/05 10:38:38,412 DPU in init phase
DPU[2:CZZAAS1003] 27/05 10:38:38,647 >> GetManagerData
DPU[2:CZZAAS1003] 27/05 10:38:38,756 >> SetCompInfo
DPU[2:CZZAAS1003] 27/05 10:38:38,787 >> GetContainerList
DM[1] 27/05 10:38:38,850  **AND** 1 Agents triggered
DM[1] 27/05 10:38:38,928 CZZAAR1124
DPU[3:CZZAAR1124] 27/05 10:38:39,053 DPU in init phase
DPU[3:CZZAAR1124] 27/05 10:38:39,272 >> GetManagerData
DM[1] 27/05 10:38:39,334  **AND** 1 Agents triggered
DPU[3:CZZAAR1124] 27/05 10:38:39,381 >> SetCompInfo
DPU[3:CZZAAR1124] 27/05 10:38:39,412 >> GetContainerList
DM[1] 27/05 10:38:39,412 CZZAAR1125
DPU[3:CZZAAR1124] 27/05 10:38:39,428 getJobState 3 from 5b88e
DPU[3:CZZAAR1124] 27/05 10:38:39,428 getJobState 3 from 5b88e
DPU[2:CZZAAS1003] 27/05 10:38:39,491 >> SetCompAttr
DPU[3:CZZAAR1124] 27/05 10:38:39,522 >> SetCompAttr
DPU[4:CZZAAR1125] 27/05 10:38:39,522 DPU in init phase
DPU[3:CZZAAR1124] 27/05 10:38:39,584 >> SetDetected
DPU[2:CZZAAS1003] 27/05 10:38:39,584 >> SetDetected
DPU[3:CZZAAR1124] 27/05 10:38:39,584 disconnect
DPU[3:CZZAAR1124] 27/05 10:38:39,600 getJobState 3 from 5b88e
DPU[3:CZZAAR1124] 27/05 10:38:39,600 DPU ends
DPU[2:CZZAAS1003] 27/05 10:38:39,631 disconnect
DPU[2:CZZAAS1003] 27/05 10:38:39,631 DPU ends
DPU[4:CZZAAR1125] 27/05 10:38:39,756 >> GetManagerData
DPU[4:CZZAAR1125] 27/05 10:38:39,850 >> SetCompInfo
DPU[4:CZZAAR1125] 27/05 10:38:39,881 >> GetContainerList
DPU[4:CZZAAR1125] 27/05 10:38:39,897 getJobState 3 from 5b8a9
DPU[4:CZZAAR1125] 27/05 10:38:39,897 getJobState 3 from 5b8a9
DPU[4:CZZAAR1125] 27/05 10:38:39,991 >> SetCompAttr
DPU[4:CZZAAR1125] 27/05 10:38:40,100 >> SetDetected
DPU[4:CZZAAR1125] 27/05 10:38:40,116 disconnect
DPU[4:CZZAAR1125] 27/05 10:38:40,116 getJobState 3 from 5b8a9
DPU[4:CZZAAR1125] 27/05 10:38:40,116 DPU ends
DM[1] 27/05 10:38:40,741  **AND** 0 Agents triggered
JCE[1] 27/05 10:38:42,756 JCE ends
DM[1] 27/05 10:38:47,475  **AND** 0 Agents triggered
DM[1] 27/05 10:38:54,241  **AND** 0 Agents triggered

通過在安裝 OS 的 Service Pack 之前安裝最新的 MS SQL 2000 Service Pack 最終解決了這個問題。

引用自：https://serverfault.com/questions/145775

相關問答

Windows

應用程序部署的流行（免費？）選項有哪些？

  • April 24, 2016
檢視問答
Windows-Server-2003

通過組策略解除安裝未知軟體。

  • February 28, 2013
檢視問答
Windows-Server-2003

如何在我的林中部署帶有最新服務包的 Windows Server 2003？

  • June 11, 2012
檢視問答
Windows-Server-2008

無人值守自動部署 Windows Server 2003 和 2008

  • February 26, 2012
檢視問答
Windows-Server-2003

OS X 10.7，Windows Server 2003 共享文件夾的 shell 腳本

  • November 10, 2011
檢視問答
Windows-Server-2003

通過 Windows Server 2003 AD 網路部署單個 XML 文件

  • August 1, 2011
檢視問答