Вчера я установил Windows Server 2003 Service Pack 2 на Windows Server 2003, на котором установлена Unicenter Software Delivery 4. Перед установкой я отключил все службы CA на сервере (Brightstor, SDO, RCO, TNG) и службу MS SQL 2000.
После установки SP2 я снова включил службы, но служба Unicenter больше не может подключаться к базе данных MS SQL 2000. Сама база данных запущена и работает, и я могу подключиться к ней с помощью Enterprise Manager.
А 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>
Если я проверю конфигурацию Unicenter с помощью chkmib_l инструмент выдает исключение и создает небольшой файл дампа.
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 output (версия доставки ПО 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
В конечном итоге проблема была решена путем установки последних пакетов обновления MS SQL 2000 перед установкой пакета обновления для ОС.