Symptoms
- In MobileAsset, when Print Previewing an asset tag, no preview window appears, and no error appears on screen. MobileAsset.log contains errors regarding "Input string was not in a correct format" (full error below).
- You can configure the ODBC connection and Labeler's data connection successfully, but the Data tab still says "The connection to <MobileAsset> is not valid. To check the connection properties, click Edit Connection. To delete this data source connection and create a new one, click Remove Connection."
- Clients on workstations and the database PC experience the same thing.
Cause
In SQL, the AssetReader accounts's db_datareader checkbox is unchecked for the WaspTrackAsset database.
Resolution
Check the box. This article has instructions:
SQL Server User Mapping for InventoryControl, MobileAsset, WaspTime:
https://support.waspbarcode.com/kb/articles/1177
https://support.waspbarcode.com/kb/articles/1177
Full error messages:
2016-09-09 16:35:59.621 1 ERROR | Input string was not in a correct format.
2016-09-09 16:35:59.625 1 ERROR | at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
| at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
| at Wasp.WaspPrintEngine.Shared.PreviewNavigateEnableConverter.Convert(Object[] values, Type targetType, Object parameter, CultureInfo culture)
| at System.Windows.Data.MultiBindingExpression.TransferValue()
| at System.Windows.Data.MultiBindingExpression.Transfer()
| at System.Windows.Data.MultiBindingExpression.UpdateTarget(Boolean includeInnerBindings)
| at System.Windows.Data.MultiBindingExpression.AttachToContext(Boolean lastChance)
| at System.Windows.Data.MultiBindingExpression.MS.Internal.Data.IDataBindEngineClient.AttachToContext(Boolean lastChance)
| at MS.Internal.Data.DataBindEngine.Task.Run(Boolean lastChance)
| at MS.Internal.Data.DataBindEngine.Run(Object arg)
| at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
| at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
| at System.Windows.Threading.DispatcherOperation.InvokeImpl()
| at System.Windows.Threading.DispatcherOperation.InvokeInSecurityContext(Object state)
| at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
| at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
| at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
| at MS.Internal.CulturePreservingExecutionContext.Run(CulturePreservingExecutionContext executionContext, ContextCallback callback, Object state)
| at System.Windows.Threading.DispatcherOperation.Invoke()
| at System.Windows.Threading.Dispatcher.ProcessQueue()
| at System.Windows.Threading.Dispatcher.WndProcHook(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
| at MS.Win32.HwndWrapper.WndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam, Boolean& handled)
| at MS.Win32.HwndSubclass.DispatcherCallbackOperation(Object o)
| at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
| at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
| at System.Windows.Threading.Dispatcher.LegacyInvokeImpl(DispatcherPriority priority, TimeSpan timeout, Delegate method, Object args, Int32 numArgs)
| at MS.Win32.HwndSubclass.SubclassWndProc(IntPtr hwnd, Int32 msg, IntPtr wParam, IntPtr lParam)
| at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
| at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
| at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
| at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
| at System.Windows.Forms.Application.RunDialog(Form form)
| at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
| at Wasp.UI.Common.WtCommonUI.OpenAssetList(Form pForm)
| at MobileAsset.UI.MainBI.OpenForm(String sFormName)
| at MobileAsset.UI.MainBI.OpenCorrespondingForm(Int32 nLevel1Index)
| at MobileAsset.UI.MainBI.SubTree_MouseUp(Object sender, MouseEventArgs e)
2016-09-09 16:35:59.626 1 ERROR | Input string was not in a correct format.