Anyone have any idea what this error means in the log file relating to PCA filter. Its constant!
Log File Name: C:\ProgramData\Symantec\SMP\Logs\a.log
Priority: 1
Help and Support:
Date: 23/02/2014 09:59:50
Tick Count: -1967413671
Host Name: SERVER
Process: AeXSvc (11736)
Thread ID: 7
Module: AeXSVC.exe
Source: DeltaCollectionUpdateSchedule
Description: Error delta updating collection: 'Windows Computers Requiring pcAnywhere plug-in Upgrade' (e397b6ae-ad14-4d40-be03-8840fe824235)
Altiris.NS.StandardItems.Collection.AeXInvalidCollectionQueryException (Altiris.NS.StandardItems): Data Source failed to run.
at Altiris.NS.StandardItems.Collection.NSDataSrcBasedResourceCollection.FullUpdateMembership()
at Altiris.NS.StandardItems.Collection.NSDataSrcBasedResourceCollection.DeltaUpdateMembership()
at Altiris.NS.StandardItems.Collection.NSDataSrcBasedResourceCollection.UpdateMembershipCore(ICollectionUpdateMessage updateMessage)
at Altiris.NS.StandardItems.Collection.NSResourceCollectionBase.<>c__DisplayClass5.<UpdateMembershipImpl>b__1(IDatabaseContext ac)
at Altiris.Database.DatabaseContext`1.RetryAction(Int32 retries, Boolean transacted, Getter`1 getContext, Action`1 action, Action`1 retry, DeadlockRetryArgs& re, Exception& exception)
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, IsolationLevel isolationLevel, Boolean independentContext, Action`1 action, Action`1 retry)
at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetry(Int32 retries, Boolean startNewTransaction, Action`1 action, Action`1 retry)
at Altiris.Database.DatabaseContext`1.PerformWithDeadlockRetry(Int32 retries, Action`1 action, Action`1 retry)
at Altiris.NS.StandardItems.Collection.NSResourceCollectionBase.UpdateMembershipImpl(ICollectionUpdateMessage updateMessage)
at Altiris.NS.StandardItems.Collection.NSResourceCollectionBase.UpdateMembership(ICollectionUpdateMessage updateMessage)
at Altiris.NS.StandardItems.Collection.DeltaCollectionUpdateSchedule.DeltaUpdateCollections(ICollection`1 collectionGuids, DateTime lastRunTime)
Altiris.DataSource.Exceptions.DataSourceRunException (Altiris.Reporting.DataSource): An unexpected SQL error occurred when running the RawSqlDataSource: 'Windows Computers Requiring pcAnywhere plug-in Upgrade' ('Windows Computers Requiring pcAnywhere plug-in Upgrade' (e397b6ae-ad14-4d40-be03-8840fe824235))
at Altiris.Reporting.DataSource.RawSqlDataSource.RunTry(IDatabaseContext context, String name, String sql)
at Altiris.Database.DatabaseContext`1.RetryAction(Int32 retries, Boolean transacted, Getter`1 getContext, Action`1 action, Action`1 retry, DeadlockRetryArgs& re, Exception& exception)
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 independentContext, Getter`1 getContext, Action`1 action, Action`1 retry)
at Altiris.Reporting.DataSource.RawSqlDataSource.Run()
at Altiris.NS.StandardItems.Collection.NSDataSrcBasedResourceCollection.FullUpdateMembership()
System.Data.SqlClient.SqlException (.Net SqlClient Data Provider): Invalid length parameter passed to the LEFT or SUBSTRING function.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.HasMoreRows()
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout)
at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable)
at Altiris.Reporting.DataSource.RawSqlDataSource.RunTry(IDatabaseContext context, String name, String sql)
SQL Exception details: code=537, line=1
Exception logged from:
at Altiris.Diagnostics.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception, String footer)
at Altiris.NS.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception)
at Altiris.NS.StandardItems.Collection.DeltaCollectionUpdateSchedule.DeltaUpdateCollections(ICollection`1 collectionGuids, DateTime lastRunTime)
at Altiris.NS.StandardItems.Collection.DeltaCollectionUpdateSchedule.OnScheduleImpl()
at Altiris.NS.StandardItems.Collection.DeltaCollectionUpdateSchedule.OnSchedule(String identifier)
at Altiris.NS.StandardItems.ContainerUpdateSchedule.RunUpdateScheduleImpl(String identifier, String name, Guid scheduleGuid)
at Altiris.NS.StandardItems.ContainerUpdateSchedule.RunFilterDeltaUpdate(String identifier)
at Altiris.NS.StandardItems.ContainerUpdateSchedule.RunDeltaUpdate(String identifier)
at Altiris.NS.StandardItems.ContainerUpdateSchedule.OnSchedule(String identifier)
at Altiris.NS.Scheduling.ScheduleService.ProcessScheduleImpl(String scheduleId, CodeProfiler cp, SecurityContext owner, Guid guid)
at Altiris.NS.Scheduling.ScheduleService.<>c__DisplayClass4.<ProcessSchedule>b__0(SecurityContext owner)
at Altiris.NS.Security.SecurityContext.ExecuteAsOwner(Guid itemGuid, Boolean useAppIdentityIfNoOwnerFound, Action`1 action)
at Altiris.NS.Scheduling.ScheduleService.ProcessSchedule(String scheduleId)
at Altiris.NS.Scheduling.ScheduleService.ProcessScheduleWithCleanup(String scheduleId, Boolean deleteMissingSchedule)
at Altiris.Diagnostics.RemoteControl.ScheduleServiceProxy.ProcessScheduleImpl(String scheduleId, Boolean throwOnError)
at Altiris.Diagnostics.RemoteControl.ScheduleServiceProxy.ProcessScheduleThreadProc(Object state)
at System.Threading.ExecutionContext.runTryCode(Object userData)
at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at Altiris.Diagnostics.RemoteControl.ScheduleServiceProxy.ProcessSchedule(String scheduleId, Boolean async)
at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
at System.Runtime.Remoting.Messaging.ServerObjectTerminatorSink.SyncProcessMessage(IMessage reqMsg)
at System.Runtime.Remoting.Lifetime.LeaseSink.SyncProcessMessage(IMessage msg)
at System.Runtime.Remoting.Messaging.ServerContextTerminatorSink.SyncProcessMessage(IMessage reqMsg)
at System.Runtime.Remoting.Channels.CrossContextChannel.SyncProcessMessageCallback(Object[] args)
at System.Runtime.Remoting.Channels.ChannelServices.DispatchMessage(IServerChannelSinkStack sinkStack, IMessage msg, IMessage& replyMsg)
at System.Runtime.Remoting.Channels.BinaryServerFormatterSink.ProcessMessage(IServerChannelSinkStack sinkStack, IMessage requestMsg, ITransportHeaders requestHeaders, Stream requestStream, IMessage& responseMsg, ITransportHeaders& responseHeaders, Stream& responseStream)
at System.Runtime.Remoting.Channels.SoapServerFormatterSink.ProcessMessage(IServerChannelSinkStack sinkStack, IMessage requestMsg, ITransportHeaders requestHeaders, Stream requestStream, IMessage& responseMsg, ITransportHeaders& responseHeaders, Stream& responseStream)
at System.Runtime.Remoting.MetadataServices.SdlChannelSink.ProcessMessage(IServerChannelSinkStack sinkStack, IMessage requestMsg, ITransportHeaders requestHeaders, Stream requestStream, IMessage& responseMsg, ITransportHeaders& responseHeaders, Stream& responseStream)
at System.Runtime.Remoting.Channels.Tcp.TcpServerTransportSink.ServiceRequest(Object state)
at System.Runtime.Remoting.Channels.SocketHandler.ProcessRequestNow()
at System.Runtime.Remoting.Channels.SocketHandler.BeginReadMessageCallback(IAsyncResult ar)
at System.Net.LazyAsyncResult.Complete(IntPtr userToken)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Net.ContextAwareResult.Complete(IntPtr userToken)
at System.Net.LazyAsyncResult.ProtectedInvokeCallback(Object result, IntPtr userToken)
at System.Net.Sockets.BaseOverlappedAsyncResult.CompletionPortCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* nativeOverlapped)
at System.Threading._IOCompletionCallback.PerformIOCompletionCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* pOVERLAP)