Error Upgrading to E703

[IT_GUY299]

I am trying to upgrade IMC from E605 to E703. I receved an upgrade has failed please review dmslog. DMSlog has shows this error

2021-10-26 12:26:33 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.SlaveMessageHandler::onMessage(1241)] slave receive message: src=Slave_ALL; type=QUERY_REMOTE_PROC
2021-10-26 12:26:33 [INFO ] [Thread-103] [com.h3c.imc.deploy.dma.IPConfigFileManager::readAllConfigs(168)] Start loading server-addr.xml configuration file
2021-10-26 12:26:33 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.MasterMessageHandler::onMessage(694)] Master receive message: src=Slave_1634928583532; type=QUERY_REMOTE_PROC_RESP
2021-10-26 12:26:33 [INFO ] [Thread-103] [com.h3c.imc.deploy.dma.IPConfigFileManager::readAllConfigs(232)] Load server-addr.xml configuration file succeeded
2021-10-26 12:26:33 [INFO ] [Thread-103] [com.h3c.imc.deploy.tasks.BuildDatabaseTask::prepare(459)] Reset database username/password/address to original value
2021-10-26 12:26:33 [INFO ] [Thread-103] [com.h3c.imc.deploy.dma.MasterDeployTask::executeDeploy(176)] Executing com.h3c.imc.deploy.tasks.BuildDatabaseTask(Building database - client\V7R1E0605-V7R1E0605L02\update_script_sqlserver.hz...)...
2021-10-26 12:26:33 [INFO ] [SwingWorker-pool-6-thread-4] [com.h3c.imc.deploy.tasks.BuildDatabaseTask$DatabaseBuilderWorker::doInBackground(840)] ???????
2021-10-26 12:26:33 [INFO ] [SwingWorker-pool-6-thread-4] [com.h3c.imc.deploy.Util::getExecEnvWithDatabaseEnvSet(2025)] getExecEnvWithDatabaseEnvSetSQLServer
2021-10-26 12:26:33 [INFO ] [SwingWorker-pool-6-thread-4] [com.h3c.imc.deploy.Util::getExecEnvsWithSqlServerPathSet(2134)] ??sqlserver????
2021-10-26 12:26:33 [ERROR] [SwingWorker-pool-6-thread-4] [com.h3c.imc.deploy.tasks.BuildDatabaseTask$DatabaseBuilderWorker::doInBackground(921)] Execute database script error! return value: 9009. For details, see log file: C:\Windows\iMC-Reserved\log\dbresult_202110261226332.log
2021-10-26 12:26:34 [INFO ] [Thread-103] [com.h3c.imc.deploy.dma.DeployManager::saveAllComponentDeployInfo(756)] Save Component Deploy Info OK
2021-10-26 12:26:34 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.SlaveMessageHandler::onMessage(1241)] slave receive message: src=Slave_ALL; type=COMP_STATE_CHANGED_NOTIFY
2021-10-26 12:26:34 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.monitor.JmxMonitor::loadConfig(395)] JmxMonitor config reloaded, size = 2
2021-10-26 12:26:34 [INFO ] [pool-9-thread-1] [com.h3c.imc.deploy.dma.monitor.JmxMonitor::connectOne(433)] Start monitor state file: ${instroot}/client/conf/.state
2021-10-26 12:26:34 [INFO ] [pool-9-thread-1] [com.h3c.imc.deploy.dma.monitor.JmxMonitor::connectOne(433)] Start monitor state file: ${instroot}/seplat/client/conf/.state
2021-10-26 12:26:38 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.MasterMessageHandler::onMessage(694)] Master receive message: src=Slave_1635267278412; type=QUERY_COMPONENTS
2021-10-26 12:26:38 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.SlaveMessageHandler::onMessage(1241)] slave receive message: src=Slave_1635267278412; type=QUERY_COMPONENTS_RESP
2021-10-26 12:26:38 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.SlaveMessageHandler::onMessage(1241)] slave receive message: src=Slave_ALL; type=COMP_STATE_CHANGED_NOTIFY
2021-10-26 12:26:40 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.MasterMessageHandler::onMessage(694)] Master receive message: src=Slave_1635267278412; type=HEART_BEAT
2021-10-26 12:26:40 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.SlaveMessageHandler::onMessage(1241)] slave receive message: src=Slave_1635267278412; type=HEART_BEAT_RESP
2021-10-26 12:26:40 [INFO ] [Thread-103] [com.h3c.imc.deploy.dma.MasterMessageHandler::handleComponentDeployOrUpdateCompleteRequestMessage(1772)] [Master] Send Component Update Complete Response to 127.0.0.1
2021-10-26 12:26:40 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.SlaveMessageHandler::onMessage(1241)] slave receive message: src=Slave_1635267278412; type=COMPDEPLOY_CPL_RESP
2021-10-26 12:26:40 [INFO ] [Thread-102] [com.h3c.imc.deploy.dma.SlaveMessageHandler::sendSlaveComponentDeployOrUpdateCompleteRequest(741)] [Slave] Receive Component Deploy Or Update Complete Response
2021-10-26 12:26:40 [INFO ] [Thread-102] [com.h3c.imc.deploy.dma.ServerMessageHandler::handleComponentDeployOrUpdateCompleteRequestMessage(987)] [Server] Send Component Deploy Or Update Complete Response
2021-10-26 12:26:42 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.MasterMessageHandler::onMessage(694)] Master receive message: src=Slave_1634928583532; type=QUERY_COMPONENTS
2021-10-26 12:26:42 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.SlaveMessageHandler::onMessage(1241)] slave receive message: src=Slave_1634928583532; type=QUERY_COMPONENTS_RESP
2021-10-26 12:26:43 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.SlaveMessageHandler::onMessage(1241)] slave receive message: src=Slave_ALL; type=QUERY_REMOTE_PROC
2021-10-26 12:26:43 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.MasterMessageHandler::onMessage(694)] Master receive message: src=Slave_1634928583532; type=QUERY_REMOTE_PROC_RESP
2021-10-26 12:26:53 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.SlaveMessageHandler::onMessage(1241)] slave receive message: src=Slave_ALL; type=QUERY_REMOTE_PROC
2021-10-26 12:26:53 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.MasterMessageHandler::onMessage(694)] Master receive message: src=Slave_1634928583532; type=QUERY_REMOTE_PROC_RESP
2021-10-26 12:27:03 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.SlaveMessageHandler::onMessage(1241)] slave receive message: src=Slave_ALL; type=QUERY_REMOTE_PROC
2021-10-26 12:27:03 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.MasterMessageHandler::onMessage(694)] Master receive message: src=Slave_1634928583532; type=QUERY_REMOTE_PROC_RESP
2021-10-26 12:27:13 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.SlaveMessageHandler::onMessage(1241)] slave receive message: src=Slave_ALL; type=QUERY_REMOTE_PROC
2021-10-26 12:27:13 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.MasterMessageHandler::onMessage(694)] Master receive message: src=Slave_1634928583532; type=QUERY_REMOTE_PROC_RESP
2021-10-26 12:27:15 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.MasterMessageHandler::onMessage(694)] Master receive message: src=Slave_1634928583532; type=HEART_BEAT
2021-10-26 12:27:15 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.SlaveMessageHandler::onMessage(1241)] slave receive message: src=Slave_1634928583532; type=HEART_BEAT_RESP
2021-10-26 12:27:23 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.SlaveMessageHandler::onMessage(1241)] slave receive message: src=Slave_ALL; type=QUERY_REMOTE_PROC
2021-10-26 12:27:23 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.MasterMessageHandler::onMessage(694)] Master receive message: src=Slave_1634928583532; type=QUERY_REMOTE_PROC_RESP
2021-10-26 12:27:33 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.SlaveMessageHandler::onMessage(1241)] slave receive message: src=Slave_ALL; type=QUERY_REMOTE_PROC
2021-10-26 12:27:33 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.MasterMessageHandler::onMessage(694)] Master receive message: src=Slave_1634928583532; type=QUERY_REMOTE_PROC_RESP
2021-10-26 12:27:38 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.MasterMessageHandler::onMessage(694)] Master receive message: src=Slave_1635267278412; type=QUERY_COMPONENTS
2021-10-26 12:27:38 [INFO ] [ActiveMQ Session Task-2] [com.h3c.imc.deploy.dma.SlaveMessageHandler::onMessage(1241)] slave receive message: src=Slave_1635267278412; type=QUERY_COMPONENTS_RESP

In looking at the C:\Windows\iMC-Reserved\log\dbresult_202110261226332.log I see this. Any thoughts?

Begin to install database and data...
--------------------------------
Begin to create plat db table...
'osql' is not recognized as an internal or external command,
operable program or batch file.

[jguse · Accepted solution]

Hello,

First of all, I'd suggest upgrading to E0705 directly - there should be no need to upgrade to E0703, it can be skipped.

The error you see related to "osql" means there is an issue with the DB client or PATH to it on your IMC system. OSQL is the command line for MSSQL and IMC relies on it to access the database. Make sure the DB client is installed correctly (see the corresponding MSSQL Installation guide for IMC) and that the MSSQL Binn directory is in the system PATH. It should be added automatically if you've installed all the required client components and SQL Server Management Studio.

[IT_GUY299]

Thanks for pointing out 705, I missied that in the release notes.

I am new to iMC and am having trouble finding the SQL installation guide but I will keep looking. Thanks.

[jguse]

Hello,

You can find documents for IMC at this link. Search there for SQL to find the MSSQL installation guides, there's one for each IMC-supported major version of MSSQL.

[IT_GUY299]

Awesome! Thank you!

I hope the new community on Aruba is as helpful as this one...