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
The stored proceedure spPMCore_SoftwareUpdateListIsNotDownloaded failed to upgrade sucessfully from the previous version.
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