Asset Management Suite

 View Only
  • 1.  7.5 Trouble with Barcode Solution

    Posted Oct 11, 2013 04:30 PM

    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?


  • 2.  RE: 7.5 Trouble with Barcode Solution
    Best Answer

    Posted Oct 14, 2013 01:29 PM

    So the barcode solution issues syncing have sort of gone away. I can sync my iOS device using Barcode Essentials ok now however issues persist with the Windows Mobile device. That one I think will be for support.

    The basic fix was a repair of Barcode Solution.