Can not print tech work sheet

[JPReilly]

Updated to 9.3 this morning and now we can not print tech worksheets. Get "Error printing tech worksheet" Tried all the different worksheet options and still get the same error.

[JPReilly]

So we got it working sorta. Still can not print one vehicles worksheet. At first we got an error for every ticket but after rebooting both machines we can now print tickets. Except for the first one we tried. Here is the error details if they help.

System.Data.StrongTypingException: The value for column 'VinCode' in table 'Engine' is DBNull. ---> System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.
at Mitchell1.Manager.Transport.Types.VehicleDataSet.EngineRow.get_VinCode()
--- End of inner exception stack trace ---
at Mitchell1.Manager.Shared.LegacyCancellableThreadTask.<Execute>d__1`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Mitchell1.Manager.Reporting.Reports.Report.<LoadAndFillReportDocument>d__50.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Mitchell1.Manager.Reporting.Reports.Report.<printingForm_DoWork>d__49.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Mitchell1.Manager.Reporting.PresentationLayer.PrintingNoticeForm.<OnLoad>d__25.MoveNext()

[JPReilly]

OK... sorry for all the post just trying to get it figured out.
Narrowed it down to just that vehicle. If I change vehicle on the customer it will print. I tried deleting the VIN and reenter it . Wont print with or without VIN.

[Silky7]

Thanks for the report and detail. We're looking into this now.

[JPReilly]

We have narrowed it down to a Subaru problem. If the vehicle is a Subaru we can not print the tech worksheet. I can change the vehicle to another vehicle the customer owns and it will print no problem. Here is another error report incase it helps.

System.Data.StrongTypingException: The value for column 'VinCode' in table 'Engine' is DBNull. ---> System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.
at Mitchell1.Manager.Transport.Types.VehicleDataSet.EngineRow.get_VinCode()
--- End of inner exception stack trace ---
at Mitchell1.Manager.Shared.LegacyCancellableThreadTask.<Execute>d__1`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Mitchell1.Manager.Reporting.Reports.Report.<LoadAndFillReportDocument>d__50.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Mitchell1.Manager.Reporting.Reports.Report.<printingForm_DoWork>d__49.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Mitchell1.Manager.Reporting.PresentationLayer.PrintingNoticeForm.<OnLoad>d__25.MoveNext()

[Silky7]

Thanks again. We have identified the issue as part of the data schematic changes. The good news is we will have a small patch incoming to those on 9.3 already very soon. If anyone is running into this frequently enough to be bothersome in the interim, you can contact technical support for a fix.

[JPReilly]

Thanks for the update. We had a Honda Civic we couldnt print this morning. Will call tech support today.

[RAddison]

We are also having this exact issue. It is only happening with about half of our scheduled appointments.

System.Data.StrongTypingException: The value for column 'VinCode' in table 'Engine' is DBNull. ---> System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.
at Mitchell1.Manager.Transport.Types.VehicleDataSet.EngineRow.get_VinCode()
--- End of inner exception stack trace ---
at Mitchell1.Manager.Shared.LegacyCancellableThreadTask.<Execute>d__1`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Mitchell1.Manager.Reporting.Reports.Report.<LoadAndFillReportDocument>d__50.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Mitchell1.Manager.Reporting.Reports.Report.<printingForm_DoWork>d__49.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Mitchell1.Manager.Reporting.PresentationLayer.PrintingNoticeForm.<OnLoad>d__25.MoveNext()

[Prestige1]

We were having this problem as well with only Hondas.

I saw on the Facebook group that someone else had the problem and called tech support so we did as well.
They have a script that they ran and it fixed it right up for us.

[RAddison]

That is interesting because we are having it with Subaru's and Hondas.

[JPReilly]

Double post

[JPReilly]

That is interesting because we are having it with Subaru's and Hondas.

Call Tech Support. They were able to login and change some settings. Took 5 min and now no issue printing .

[ricmorin]

I believe this is caused by a missing engine vin identifier.

vincode.png (12.39 KiB) Viewed 2 times