Here's an interesting one...and one that started to creep up a little in 7.1 but is now a large problem in 7.5. Barcode Solution simply stopped working. on 7.1 we had always had a slow response from Barcode but now it just won't work. We can try to sync one of our profiles and even a test profile with nothing in it and the sync times out on all of our devices with the following error:
An exception occurred in Altiris.Barcode.Synchronization.Action
System.ApplicationException (Altiris.Barcode): Failed to get complete resource list from Database
at Altiris.Barcode.SMPIntegration.BarcodeSyncProfile.GetCompleteResources(DatabaseContext context, Boolean includeUserSpecifiedResources)
at Altiris.Barcode.Synchronization.Command.GetResourceManifest.GetProfileManifest(BarcodeSyncProfile downloadProfile, DatabaseContext context)
at Altiris.Barcode.Synchronization.Command.DownloadManifest.ExecuteCommand()
at Altiris.Barcode.Synchronization.Command.SynchronizationCommandBase.Execute()
at Altiris.Barcode.Web.Synchronization.Action(Byte[] data)
System.Data.SqlClient.SqlException (.Net SqlClient Data Provider): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
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.ConsumeMetaData()
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)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
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)
at Altiris.Barcode.SMPIntegration.BarcodeSyncProfile.GetCompleteResources(DatabaseContext context, Boolean includeUserSpecifiedResources)
SQL Exception details: code=-2
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.Barcode.Base.CodeQuality.BarcodeLogger.LogExceptionToAltirisLog(String error, Exception exException)
at Altiris.Barcode.Base.CodeQuality.Logger.LogExceptionToAltirisLog(String error, Exception exException)
at Altiris.Barcode.Web.Synchronization.Action(Byte[] data)
at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)
at System.Web.Services.Protocols.WebServiceHandler.Invoke()
at System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
at System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)
at System.Web.Script.Services.ScriptHandlerFactory.HandlerWrapper.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)
at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
at System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
Thinking it might really be a timeout issue we tried with the Barcode Essentials app and cranked the time out up to 10 minutes and even on the profile with no data it won't sync. Perhaps we need to remove the solution and start over with clean data but does anyone know how to do that and remove the data from the database? Any other suggestions?