Download Software Update failed: Procedure or function spPMCore_SoftwareUpdateListIsNotDownloaded has too many arguments specified

Products

• Patch Management Solution for Windows

Issue/Introduction

After upgrading to 8.1 RU7, we noticed that using the distribute packages function to create a new software update policy will download the packages but will then fail. Re-running the distribute packages function will succeed.

Download Software Update failed: Procedure or function spPMCore_SoftwareUpdateListIsNotDownloaded has too many arguments specified.

Procedure or function spPMCore_SoftwareUpdateListIsNotDownloaded has too many arguments specified.
   [System.Data.SqlClient.SqlException @ .Net SqlClient Data Provider]
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at Altiris.NS.DataAccessLayer.Implementation.Altiris_PatchManagementCore_DataAccessLayerPatchManagementCoreResourcesDAL.<>c__DisplayClass6.<spPMCore_SoftwareUpdateListIsNotDownloadedFirst__F>b__4(IDatabaseContext _ctx)
   at Altiris.Database.DatabaseContext`1.RetryAction(Int32 retries, Boolean transacted, Getter`1 getContext, Action`1 action, Action`1 retry, DeadlockRetryArgs& re, Exception& exception, Boolean inTransaction)
   at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetryHelper(Int32 retries, Boolean inTransaction, Getter`1 getContext, Action`1 action, Action`1 retry, Boolean transacted)
   at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetry(Int32 retries, Boolean startNewTransaction, Nullable`1 isolationLevel, Boolean independentContext, Action`1 action, Action`1 retry)
   at Altiris.NS.DataAccessLayer.Implementation.Altiris_PatchManagementCore_DataAccessLayerPatchManagementCoreResourcesDAL.spPMCore_SoftwareUpdateListIsNotDownloadedFirst__F(String ResourceGuids)
   at Altiris.NS.DataAccessLayer.Implementation.Altiris_PatchManagementCore_DataAccessLayerPatchManagementCoreResourcesDAL.spPMCore_SoftwareUpdateListIsNotDownloadedFirst(ICollection`1 ResourceGuids)
   at Altiris.PatchManagementCore.Resources.SoftwareBulletinResource.ReadyForDistribution(Boolean ignoreEnabledFlag, Boolean filterUpdates)
   at Altiris.PatchManagementCore.Tasks.Server.DownloadSWUPackageTask.ProcessPackages(ProcessPackagesRezult rezult)
   at Altiris.PatchManagementCore.Tasks.Server.DownloadSWUPackageTask.OnExecuteSingleton(IServerTaskExecutionInstance instance)

SQL Exception details: code=8144, procedure=spPMCore_SoftwareUpdateListIsNotDownloaded

Exception logged from:
   at Altiris.PatchManagementCore.Tasks.Server.DownloadSWUPackageTask.OnExecuteSingleton(Altiris.TaskManagement.ServerTasks.IServerTaskExecutionInstance)
   at Altiris.PatchManagementCore.Tasks.Server.SerializingBaseSingletonServerTask<TContent,TControl>.OnExecute(Altiris.TaskManagement.ServerTasks.IServerTaskExecutionInstance)
   at Altiris.TaskManagement.ServerTasks.BaseServerTask.OnExecute(Altiris.TaskManagement.Common.Execution.Engine.ITaskExecutionEngine, Altiris.TaskManagement.ServerTasks.IServerTaskExecutionInstance, Altiris.TaskManagement.Common.Execution.Engine.TaskInstanceRequest)
   at Altiris.TaskManagement.ServerTasks.BaseServerTask.Execute(Altiris.TaskManagement.Common.Execution.Engine.ITaskExecutionEngine, Altiris.TaskManagement.Common.Data.IBaseTaskExecutionInstance, Altiris.TaskManagement.Common.Execution.Engine.TaskInstanceRequest)
   at Altiris.TaskManagement.Common.Execution.Engine.TaskEngineExecutionThread.ExecuteTaskHandler()
   at Altiris.TaskManagement.ServerTasks.ServerTaskExecutionThread.ExecuteTaskHandler()
   at Altiris.TaskManagement.Common.Execution.Engine.TaskEngineExecutionThread.Execute()
   at Altiris.TaskManagement.Common.Execution.Engine.TaskExecutionEngine.ProcessTaskExecuteOperation(Altiris.TaskManagement.Common.Execution.Engine.TaskInstanceRequest, Altiris.TaskManagement.Common.Execution.Engine.TaskEngineExecutionThread)
   at Altiris.TaskManagement.ServerTasks.ServerTaskManager.ProcessTaskExecuteOperation(Altiris.TaskManagement.Common.Execution.Engine.TaskInstanceRequest, Altiris.TaskManagement.Common.Execution.Engine.TaskEngineExecutionThread)
   at Altiris.TaskManagement.Common.Execution.Engine.TaskExecutionEngine.ProcessTaskExecuteOperation(Object)
   at Altiris.DotNetLib.Threading.AtrsThreadPoolEx.ProcessWorkToDo(System.Threading.Thread, Altiris.DotNetLib.Threading.AtrsThreadPoolWorkItemEx)
   at Altiris.DotNetLib.Threading.AtrsThreadPoolEx.ProcessWorkToDo()
   at Altiris.DotNetLib.Threading.AtrsThreadPoolEx.WorkerThreadRun()
   at Altiris.DotNetLib.Threading.AtrsThreadPoolEx.WorkerThreadProc()
   at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, Object, Boolean)
   at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, Object, Boolean)
   at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, Object)
   at System.Threading.ThreadHelper.ThreadStart()

User [EPICOR\svc_altiris], Auth [EPICOR\svc_altiris], AppDomain [AtrsHost.exe]

-----------------------------------------------------------------------------------------------------
Date: 2/19/2019 5:03:34 PM, Tick Count: 889712656 (10.07:08:32.6560000), Host Name: AUS-CRPALTNS00, Size: 6.19 KB
Process: AtrsHost (10764), Thread ID: 96, Module: Altiris.PatchManagementCore.dll
Priority: 1, Source: Altiris.PatchManagementCore.Tasks.Server.DownloadSWUPackageTask.OnExecuteSingleton
File: C:\ProgramData\Symantec\SMP\Logs\a.log

Cause

The stored proceedure spPMCore_SoftwareUpdateListIsNotDownloaded failed to upgrade sucessfully from the previous version.

Resolution

Ran the stored procedure from a known good 8.1 RU7 installation to rebuild spPMCore_SoftwareUpdateListIsNotDownloaded.

Note: We recommend backing up the data base prior to this or any data base maintenance.

Contact support if needed to get a copy of the stored procedure