Solved

Can't install MSSQL Agent on Windows server 2022 with SQL 2019

  • 3 October 2023
  • 5 replies
  • 390 views

Badge +6

Hi,

Running CV 11.32.6 on prem.

We’re trying to install the MSSQL Agent from Commvault. We managed to get to 90% and then it failes. Reviewing the log for the job doesn’t give us any leads. Please see below.
The server has been restarted several times.

SQL server is on it’s latest CU.

Any one that got any idea?

Log:


@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Machine : commserve-server
File    : JobManager.log
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

2988  23f8  10/03 16:01:34 5462339 Servant    [---- IMMEDIATE AUTOMATIC INSTALL CLIENT REQUEST ----]
2988  23f8  10/03 16:01:34 5462339 JobSvr Obj Skipping Discover phase because auto discovery option is not set.
2988  440c  10/03 16:01:34 5462339 Scheduler  Phase [2-Install Client] (0,0) started on [commserve-server.yy.yy] in [0] second(s) - DistributeUpdates.exe -j 5462339 -a 28449  -jt 5462339:2:1:0:0:11277  -install -CCNumber 2
2988  1e9c  10/03 16:01:37 5462339 Servant    Reg [Control] received. Client [commserve-server] plattype = 1. Token [5462339:2:1:0:0:11277]
2988  3508  10/03 16:05:41 5462339 Scheduler  Set pending cause [Install Software Failed]::Client [commserve-server] Application [DistributeSoftware] Message Id [1140850839] Error code [68:151] RCID [0] ReservationId [0].  Level [0] flags [0] id [0] overwrite [0] append [0] CustId[0].
2988  4c58  10/03 16:05:41 5462339 Scheduler  Job [Failed] message received from [commserve-server.yy.yy] Module [DistributeSoftware] Token [5462339:2:1:0:0:11277] restartPhase [0]
2988  4c58  10/03 16:05:41 5462339 JobSvr Obj Phase [2-Install Client] for Admin Job Failed and cannot be restarted.
2988  4c58  10/03 16:05:41 5462339 Scheduler   -> FAILED <-  (WHOLE JOB) Completed JobType[Install Software] CompletionStatus[Failed]
2988  39a4  10/03 16:05:41 5462339 Post Actions Failed to get attribute [InstallJobId] from App_ClientProp table with errorCode: [0]

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Machine : commserve-server
File    : DistributeSoftware.log
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

9104  5a84  10/03 16:01:36 5462339 JOB MANAGER INPUT PARAMETERS
9104  5a84  10/03 16:01:36 5462339     Hostname (mangled)    : commserve-server.yy.yy*commserve-server*8400
9104  5a84  10/03 16:01:36 5462339     DelayedReboot        : [NO]
9104  5a84  10/03 16:01:36 5462339     AutoReboot            : [NO]
9104  5a84  10/03 16:01:36 5462339     Restart                : [NO]
9104  5a84  10/03 16:01:36 5462339     JobId                : 5462339
9104  5a84  10/03 16:01:36 5462339     TaskId                : 28449
9104  5a84  10/03 16:01:36 5462339     JMToken                : 5462339:2:1:0:0:11277
9104  5a84  10/03 16:01:36 5462339     IgnoreRunningJobs    : [YES]
9104  5a84  10/03 16:01:36 5462339     Job Type            : Install Software
9104  5a84  10/03 16:01:37 5462339 --------------------------------------------------------------
9104  5a84  10/03 16:01:37 5462339 ------------- Starting Install Software -------------
9104  5a84  10/03 16:01:37 5462339 --------------------------------------------------------------
9104  5a84  10/03 16:01:37 5462339 [GetOptionsFromGui]() - Xml request received from GUI <?xml version="1.0" encoding="UTF-8" standalone="no" ?><TMMsg_JobOption><restoreOptions><virtualServerRstOption isBlockLevelReplication="0"/></restoreOptions><adminOpts><updateOption invokeLevel="5"/><clientInstallOption discoveryType="0" installOSType="0" reuseADCredentials="0" sshKeyFileLocation="" sshPortNumber=""><clientDetails><clientEntity clientId="2280" clientName="xxx" commCellId="0"/></clientDetails><installerOption CommServeHostName="commserve-server" Operationtype="0" RemoteClient="0" requestType="0"><User userId="56" userName="LINKOM\patgras"/><CommServeInfo/><clientComposition activateClient="1" overrideSoftwareCache="0" packageDeliveryOption="0"><clientInfo><client cvdPort="0"><jobResulsDir path=""/></client><clientProps/></clientInfo><components><componentInfo ComponentId="353" ComponentName="iDA for MSSQL Server" _type_="60" clientSidePackage="1" consumeLicense="1" installCommand="" osType="Windows" postInstallCommand="" unInstallCommand=""/><commonInfo globalFilters="2"><storagePolicyToUse/></commonInfo><contentIndexingEngine/><fileSystem configureForLaptopBackups="0"/><mediaAgent/><sqlAgent instanceAutoDiscovery="1"><userAccount userName=""/></sqlAgent><exchangeDatabase differentialBackup="0"/></components><clientRoles bLaptopBackup="0" bNetworkProxy="0"/><sharedInstallLocation silServerID="0"/></clientComposition><installFlags addToFirewallExclusion="1" advancedOptions="" allowMultipleInstances="0" autoInstallPassiveNodes="0" autoRebootPassiveNodes="0" disableOSFirewall="0" forceReboot="0" hideApps="0" ignoreJobsRunning="1" overrideClientInfo="1" patchStandbyCS="0" preferredIPFamily="1" restoreOnlyAgents="0" skipClientsOfCS="0" skipConfigureLaptopBackupMonitor="0" skipConfigureMigrationAssistant="0" skipConfigureProcessManager="0" stopOracleServices="0" unixGroup=""><firewallInstall enableFirewallConfig="0" encryptedTunnel="1" firewallConnectionType="0" httpProxyConfigurationType="0" portNumber="0" proxyClientName="" proxyHostName=""/></installFlags></installerOption><clientAuthForJob password="*******" userName="linkom\patgras"/><sshKeyFilePassphrase/></clientInstallOption></adminOpts><commonOpts notifyUserOnJobCompletion="0"/></TMMsg_JobOption>
9104  5a84  10/03 16:01:37 5462339 Packages selected For Install :iDA for MSSQL Server
9104  5a84  10/03 16:01:38 5462339 CommServe Cache Location [E:\Commvault\ContentStore\SW]
9104  5a84  10/03 16:01:38 5462339 [SetCSCacheInfo]() - Do not need to do clean up or baseline update.
9104  5a84  10/03 16:01:38 5462339 Could not get installation directory
9104  5a84  10/03 16:01:38 5462339 [ComputeRequiredRelAndOsList]() - Could not get answer file since install directory is empty for client [xxx].
9104  5a84  10/03 16:01:38 5462339 [ComputeRequiredRelAndOsList]() - Successfully launched thread with Id [1] for [xxx] to get it's binaryset name.
9104  5a84  10/03 16:01:38 5462339 [ComputeRequiredRelAndOsList]() - Waiting for all the clients threads to complete..
9104  50f0  10/03 16:01:38 5462339 GetClientOSType() - Found already configured Remote cache client Id [2] for new client [xxx.yy.yy]
9104  50f0  10/03 16:01:38 5462339 GetRemoteClientOSType Connecting to remote cache [commserve-server] to get Client OS types for client [xxx.yy.yy]
9104  50f0  10/03 16:01:38 5462339 [CCVPatchesUpdateDBServer::dllConnect]() - Starting dll connect in DBServer remoteHostName = commserve-server.yy.yy*commserve-server*8400
9104  50f0  10/03 16:01:38 5462339 GetRemoteClientOSType Successfully connected to remote cache [commserve-server]
9104  50f0  10/03 16:01:38 5462339 [CCVPatchesUpdateDBServer::dllConnect]() - Starting dll connect in DBServer remoteHostName = commserve-server.yy.yy*commserve-server*8400
9104  50f0  10/03 16:01:38 5462339 [GetClientOSType]() - Successfully get client OS type [WinX64] using associated Remote Cache Client Id [2]
9104  50f0  10/03 16:01:38 5462339 [GetClientOSType]() - Will associate Remote Cache client Id [2] to the new client [xxx.yy.yy]
9104  50f0  10/03 16:01:38 5462339 [GetClientOSType]() - Setting OS id to [3] for client [xxx.yy.yy] having binarysetname [WinX64]
9104  5a84  10/03 16:01:38 5462339 [CheckWhetherDownloadNeeded]() - Cache has the media for RelId 16, OSId 3, SP SP32_5494260:UP13_0
9104  5a84  10/03 16:01:38 5462339 [CheckAndDownloadRequiredMedia]() - Download is not required.
9104  5a84  10/03 16:01:39 5462339 [SetSidesToBeInstalledOnRCClients]() - Number of software caches involved in this job are [1]
9104  5a84  10/03 16:01:39 5462339 Only remote cache's having status as invalid will be tried for sync.
9104  5a84  10/03 16:01:39 5462339 [SyncUAForJob]() - Remote cache list is empty for the syncup.
9104  5a84  10/03 16:01:39 5462339 CvNetworkPool::initNetworkPool() - Creating the control thread
9104  5a84  10/03 16:01:39 5462339 Number of clients in job: [1]
9104  5a84  10/03 16:01:39 5462339 Check and create HS ClusterMap
9104  5a84  10/03 16:01:39 5462339 WaitingForRCSyncDoneIfNeeded() - Some clients are waiting Remote Cache to be synced.
9104  5a84  10/03 16:01:39 5462339 Use updated binary set id [3] for client id [2280]
9104  5a84  10/03 16:01:39 5462339 SimInstalledPackages does not contain any entries for clientId [2280]
9104  5a84  10/03 16:01:39 5462339 Client does not have any physical package.Client should be treated as new.
9104  5a84  10/03 16:01:39 5462339 [GetClientInfo]() - Getting associated (phy/vir) clients and their package list for client [2280]
9104  5a84  10/03 16:01:39 5462339
9104  5a84  10/03 16:01:39 5462339  ******    Client = [xxx.yy.yy], ClientId = [2280], Release = [11.0.0], UpdateAgentClientId = [2]
9104  5a84  10/03 16:01:39 5462339 Binary set id [3], SimOS id [210], [updateOsId : WinX64]
9104  5a84  10/03 16:01:39 5462339 [SetIsAgentlessClient]() - This is a pre-configured client [2280], No physical packages present.
9104  5a84  10/03 16:01:39 5462339 [CheckIfInstallRequired]() - It is a pre install. New client will be installed..
9104  5a84  10/03 16:01:39 5462339 It seems Client is locally uninstalled. Reading client's display name and network hostname from app_client table and ignoring name set in XML blob from GUI
9104  5a84  10/03 16:01:39 5462339
9104  5a84  10/03 16:01:39 5462339  ******    New Client = [xxx.yy.yy], ClientId = [2280], Release = [11.0.0], UpdateAgentClientId = [2]
9104  5a84  10/03 16:01:39 5462339 Client [xxx] cache source : CommServe
9104  5a84  10/03 16:01:39 5462339 CVClient::CVClient() - File[d:\rel_11_0_0_b80_sp32\vaultcx\source\commserver\appmgr\client.cpp], Line[105] netHostName[xxx.yy.yy]: Warning, deprecated call to lookup client using net hostname. Please use shortname instead
9104  5a84  10/03 16:01:39 5462339 No package or update requires reboot as per info on CS, client can reboot (if required) during actual installation
9104  5a84  10/03 16:01:39 5462339 SP found in cache [SP32_5494260:UP13_0]
9104  5a84  10/03 16:01:39 5462339 Packages and Updates installed on Client:
9104  5a84  10/03 16:01:39 5462339
9104  5a84  10/03 16:01:39 5462339 Created lock file [C:\Program Files\Commvault\ContentStore\Deployment\SwCacheLocks\commserve-server\SP32_5494260\WinX64\ReadLocks\P9104_J5462339.lock]
9104  5a84  10/03 16:01:39 5462339 [StartRemoteActivityImpl]() - successfully acquired read lock on cache [commserve-server] to copy packages and launch installer on client xxx
9104  5a84  10/03 16:01:40 5462339 SetNewClientProxyInfo() - Skipping setting proxy info when cache server is CommServer
9104  5a84  10/03 16:01:40 5462339 Sending request to software cache [commserve-server.yy.yy] to perform base package install on remote client xxx.yy.yy
9104  5a84  10/03 16:01:40 5462339 [fnCSUpdateDBJMStatusNew]() - Client status [ QGENERIC_QUEUING_FOR_TRANSFER] set successfully in JMQinetixUpdateStatus Table  for client [ 2280] [ xxx.yy.yy ]
9104  5a84  10/03 16:01:40 5462339 [CCVPatchesUpdateDBServer::dllConnect]() - Starting dll connect in DBServer remoteHostName = commserve-server.yy.yy*commserve-server*8400
9104  5a84  10/03 16:01:40 5462339 [CCVPatchesUpdateDBServer::processXMLMessage] Requested Operation on Client succeeded
9104  5a84  10/03 16:01:40 5462339 Successfully sent base package install request to client to software cache [commserve-server.yy.yy]
9104  5a84  10/03 16:01:40 5462339 Successfully initiated base package install request for client [xxx.yy.yy]
9104  5a84  10/03 16:01:40 5462339
9104  5a84  10/03 16:01:40 5462339 ******   Now Check status of all clients   ******
9104  5a84  10/03 16:01:40 5462339 Check status started for client [xxx.yy.yy][2280]
9104  5a84  10/03 16:05:40 5462339 Waiting for the remote cache syncup threads to be completed..
9104  5a84  10/03 16:05:40 5462339 Clients Failed:
9104  5a84  10/03 16:05:40 5462339 Client [2280] [xxx] [QINSTALL_FAILED]
9104  5a84  10/03 16:05:40 5462339 *******************************************
9104  5a84  10/03 16:05:40 5462339 bvSuccess = false, bvFailed = true, bvRestartNeeded = false, bvUnknown = false, bvOperationNotSupported = false, bvSkipped = false, bvPartialSuccess = false, bvMachineRebootRequired = false m_nvJobRetStatus = 1
9104  5a84  10/03 16:05:40 5462339 Job Failed.
9104  5a84  10/03 16:05:40 5462339 COMPLETE CALLED (JOB Status::FAIL), Job ID = 5462339
9104  5a84  10/03 16:05:41 5462339 [deleteLockFiles]() - Successfully deleted the lock file C:\Program Files\Commvault\ContentStore\Deployment\SwCacheLocks\commserve-server\SP32_5494260\WinX64\ReadLocks\P9104_J5462339.lock

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Machine : commserve-server
File    : AutoInstallServer.log
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

16872 3948  10/03 16:01:41 5462339 CCVPatchesUpdateDBServer::UpdateJMTable Client status [ QINSTALL_UPLOAD_IN_PROGRESS] set successfully in JMQinetixUpdateStatus Table  for client [ 2280] [ xxx ]
16872 3948  10/03 16:02:13 5462339 CCVPatchesUpdateDBServer::UpdateJMTable Client status [ QINSTALL_BASE_INSTALL_IN_PROGRESS] set successfully in JMQinetixUpdateStatus Table  for client [ 2280] [ xxx.yy.yy ]
16872 5174  10/03 16:05:01 5462339 CCVPatchesUpdateDBServer::UpdateJMTable Client status [ QINSTALL_FAILED] set successfully in JMQinetixUpdateStatus Table  for client [ 2280] [ xxx ]

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
Machine : commserve-server
File    : AutoInstall.log
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

16872 31c4  10/03 16:01:38 5462339 ProcessGetClientOSType() - SSH File content is empty.
16872 31c4  10/03 16:01:40 5462339 [fnCvUpdateDBJMStatusNew] Updating Database with evMsgId [1140850840] for  JobId [5462339], JobType [3],clientName [xxx], clientId [0]
16872 31c4  10/03 16:01:41 5462339 [InstallWinSeed] Update pack number to install is [13]
16872 31c4  10/03 16:01:41 5462339 [InstallWinSeed] Received Request to Install base package on windows client with following parameters hostname [xxx.yy.yy] username [linkom\patgras]
16872 31c4  10/03 16:01:41 5462339 [InstallWinSeed] Package Delivery Option set to 'Copy Packages to client'
16872 31c4  10/03 16:01:41 5462339 [InstallWinSeed] [Base package will be installed] on client [ xxx.yy.yy ], installDirectory [  ],ans file [C:\Program Files\Commvault\ContentStore\Deployment\Install\xxx.base.xml].Transferring Base package files to the client..
16872 31c4  10/03 16:02:13 5462339 [fnCvUpdateDBJMStatusNew] Updating Database with evMsgId [1140850992] for  JobId [5462339], JobType [3],clientName [xxx.yy.yy], clientId [2280]
16872 31c4  10/03 16:02:13 5462339 [fnCvUpdateDBJMStatusNew] Transferring Base packages files has completed on Client [xxx.yy.yy]. Installing File System Core package..
16872 31c4  10/03 16:05:01 5462339 [InstallWinSeed] Error string returned from windows seed API :[  ]
16872 31c4  10/03 16:05:01 5462339 [fnCvUpdateDBJMStatusNew] Updating Database with evMsgId [1140850839] for  JobId [5462339], JobType [3],clientName [xxx], clientId [0]
 

icon

Best answer by PatricG 8 April 2024, 13:27

View original

5 replies

Badge +6

Might be the caused by the fact that we’re not running the latest MR. I’ll get back here when we managed to apply MR20.

Userlevel 4
Badge +11

Hello @PatricG 

Could you also please ensure the pre-requisites for the push installation has been followed properly? 

https://documentation.commvault.com/2022e/expert/1971_prerequisites_for_installations_using_commcell_console.html#review-firewall-and-network-port-requirements

Best,

Rajiv Singal

Badge +6

Updated Commvault to 11.32.20. Problem still exist.

We don’t have any firewall between commserver and the sql-server. Nor are the software fw enabled. So no firewall problems

We’ve been able to do this prior the upgrade when we run 11.24
Guess I better log a case regarding this problem too.

Badge +6

I’ve created a ticket. Our support goes through Fujitsu. If someone got something similar and their support goes through Fujitsu the ticket is W668486423

Badge +6

The solution is to copy the software to the client manually and run it locally

Reply