-----------Exception Details on 7/30/2023 5:52:47 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 5:52:47 AM Subject: Shop Supplies Body: Shop Supplies --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 6:06:08 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 6:06:08 AM Subject: PLUG CHECK VALVE Body: PLUG CHECK VALVE --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 6:06:26 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 6:06:26 AM Subject: QUICK CONNECT INJECTOR Body: QUICK CONNECT INJECTOR --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 6:06:44 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 6:06:44 AM Subject: 3 way valve assembly Body: 3 way valve assembly --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 6:11:52 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 6:11:52 AM Subject: ARMOR 2+ - Kaivac 2+ Body: ARMOR 2+ - Kaivac 2+ --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 6:12:16 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 6:12:16 AM Subject: FLAT FREE TIRE 8IN 1/2 HUB Body: FLAT FREE TIRE 8IN 1/2 HUB --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 6:12:32 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 6:12:32 AM Subject: Battery key Body: Battery key --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 6:13:31 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 6:13:31 AM Subject: QUICK CONNECT INJECTOR Body: QUICK CONNECT INJECTOR --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 6:21:29 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 6:21:29 AM Subject: 120VAC UL battery charger with locking metal plug Body: 120VAC UL battery charger with locking metal plug --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 6:22:05 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 6:22:05 AM Subject: Shop Supplies Body: Shop Supplies --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 6:24:07 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 6:24:07 AM Subject: SaveWorkOrder Issue Body: SaveWorkOrder Issue: System.Data.SqlClient.SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_WorkOrderCustQty_WorkOrderLineItems". The conflict occurred in database "ServiceSuite", table "dbo.WorkOrderLineItems", column 'WorkOrderLineIdent'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at WO.WorkOrderLineItem.Save(WorkOrder wo, Program prog, ServicePartner SP, Security sec) in D:\ServiceSuite\ServiceSuite\WorkOrderLineItem.cs:line 445 at WO.WorkOrder.ReorderLineItems(List`1 LineItems, Int64 WorkOrderIdent) in D:\ServiceSuite\ServiceSuite\WorkOrder.svc.cs:line 928 at WO.WorkOrder.ReorderLineItems(List`1 LineItems) in D:\ServiceSuite\ServiceSuite\WorkOrder.svc.cs:line 649 at WO.WorkOrder.Save() in D:\ServiceSuite\ServiceSuite\WorkOrder.svc.cs:line 2365 at ServiceSuite.Service.SaveWorkOrder(WorkOrder WorkOrder) in D:\ServiceSuite\ServiceSuite\SS.svc.cs:line 6482 ClientConnectionId:92c97c81-b91b-4c57-ac6c-69f580082a38 Error Number:547,State:0,Class:16 --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 7:30:36 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 7:30:36 AM Subject: battery Body: battery --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 7:44:12 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 7:44:12 AM Subject: ARMOR 2+ - Kaivac 2+ Body: ARMOR 2+ - Kaivac 2+ --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:00:17 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:00:17 AM Subject: Travel Body: Travel --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:00:18 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:00:18 AM Subject: BATTERY DISPOSAL Body: BATTERY DISPOSAL --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:00:19 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:00:19 AM Subject: SHOP SUPPLIES Body: SHOP SUPPLIES --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:00:20 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:00:20 AM Subject: Fuel Body: Fuel --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:00:21 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:00:21 AM Subject: EXPEDITED SHIPPING & HANDLING Body: EXPEDITED SHIPPING & HANDLING --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:00:21 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:00:21 AM Subject: BATTERY- 12V 115AH AGM Body: BATTERY- 12V 115AH AGM --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:00:21 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:00:21 AM Subject: Labor Body: Labor --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:00:27 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:00:27 AM Subject: Travel Body: Travel --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:00:28 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:00:28 AM Subject: SHOP SUPPLIES Body: SHOP SUPPLIES --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:00:29 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:00:29 AM Subject: Fuel Body: Fuel --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:00:30 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:00:30 AM Subject: EXPEDITED SHIPPING & HANDLING Body: EXPEDITED SHIPPING & HANDLING --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:00:31 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:00:31 AM Subject: Wheel with spline Body: Wheel with spline --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:00:31 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:00:31 AM Subject: Squeegee blade 31 inch front gum rubber (red) Body: Squeegee blade 31 inch front gum rubber (red) --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:00:31 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:00:31 AM Subject: Notes issue Body: System.Data.SqlClient.SqlException (0x80131904): The parameterized query '(@WorkOrderIdent bigint,@AttachmentIdent bigint,@Cust bit,@SP bi' expects the parameter '@url', which was not supplied. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at ServiceSuite.Service.ChangeQueue(Notes Note, Int64 TaskIdent) in D:\ServiceSuite\ServiceSuite\SS.svc.cs:line 5519 ClientConnectionId:49032722-5e67-4821-9b9c-a210664918f5 Error Number:8178,State:1,Class:16 c:\Web\InetPub\DotNet Applications\Dev\New\ServiceSuite\TempWorkOrderXML\WO386122.xml --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:00:32 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:00:32 AM Subject: Squeegee blade rear Body: Squeegee blade rear --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:00:32 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:00:32 AM Subject: Notes issue Body: System.Data.SqlClient.SqlException (0x80131904): The parameterized query '(@WorkOrderIdent bigint,@AttachmentIdent bigint,@Cust bit,@SP bi' expects the parameter '@url', which was not supplied. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at ServiceSuite.Service.ChangeQueue(Notes Note, Int64 TaskIdent) in D:\ServiceSuite\ServiceSuite\SS.svc.cs:line 5519 ClientConnectionId:94f1521d-2e6a-4ae3-a95d-4cd358f09a4e Error Number:8178,State:1,Class:16 c:\Web\InetPub\DotNet Applications\Dev\New\ServiceSuite\TempWorkOrderXML\WO386122.xml --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:00:32 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:00:32 AM Subject: FITTING, PLSTC, E90, BM08/PM08, NYL Body: FITTING, PLSTC, E90, BM08/PM08, NYL --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:00:32 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:00:32 AM Subject: Cap assembly Body: Cap assembly --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:00:33 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:00:33 AM Subject: Notes issue Body: System.Data.SqlClient.SqlException (0x80131904): The parameterized query '(@WorkOrderIdent bigint,@AttachmentIdent bigint,@Cust bit,@SP bi' expects the parameter '@url', which was not supplied. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at ServiceSuite.Service.ChangeQueue(Notes Note, Int64 TaskIdent) in D:\ServiceSuite\ServiceSuite\SS.svc.cs:line 5519 ClientConnectionId:c92bf7cc-7d8d-4de3-b395-3f2cb275aa4a Error Number:8178,State:1,Class:16 c:\Web\InetPub\DotNet Applications\Dev\New\ServiceSuite\TempWorkOrderXML\WO386122.xml --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:00:33 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:00:33 AM Subject: BATTERY,T-1275 12V 150AH DEEP CYCLE Body: BATTERY,T-1275 12V 150AH DEEP CYCLE --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:00:33 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:00:33 AM Subject: Labor Body: Labor --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 8:20:03 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 8:20:03 AM Subject: battery terminal Body: battery terminal --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 10:27:41 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 10:27:41 AM Subject: BC queue count issue Body: System.NullReferenceException: Object reference not set to an instance of an object. at Ajax.Ajax.GetBCProgressCount() in D:\ServiceSuite\ServiceSuite\Ajax.svc.cs:line 2446 --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 11:01:51 AM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 11:01:51 AM Subject: errrrrrrr Service Suite Service Address validation Body: {"XAVResponse":{"Response":{"ResponseStatus":{"Code":"1", "Description":"Success"}, "TransactionReference":{"CustomerContext":"USAC"}}, "ValidAddressIndicator":"", "AddressClassification":{"Code":"2", "Description":"Residential"}, "Candidate":{"AddressClassification":{"Code":"2", "Description":"Residential"}, "AddressKeyFormat":{"AddressLine":"204 W ROBINSON AVE", "PoliticalDivision2":"GROVETOWN", "PoliticalDivision1":"GA", "PostcodePrimaryLow":"30813", "PostcodeExtendedLow":"2142", "Region":"GROVETOWN GA 30813-2142", "CountryCode":"US"}}}} - {"UPSSecurity":{"UsernameToken":{"Username":"usaclean","Password":"2803$usac"},"ServiceAccessToken":{"AccessLicenseNumber":"0D7022E6C48E6031"}},"XAVRequest":{"Request":{"RequestOption":"3","TransactionReference":{"CustomerContext":"USAC"}},"MaximumListSize":"5","AddressKeyFormat":{"AddressLine":["204 W ROBINSON AVE"],"PoliticalDivision2":"GROVETOWN","PoliticalDivision1":"GA","PostcodePrimaryLow":null,"PostcodeExtendedLow":null,"CountryCode":"US"}}} --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 1:00:12 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 1:00:12 PM Subject: SHOP SUPPLIES Body: SHOP SUPPLIES --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 1:00:13 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 1:00:13 PM Subject: Fuel Body: Fuel --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 1:00:13 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 1:00:13 PM Subject: Travel Body: Travel --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 1:00:13 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 1:00:13 PM Subject: Shipping Body: Shipping --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 1:00:14 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 1:00:14 PM Subject: Squeegee blade 34 inch urethane rear Body: Squeegee blade 34 inch urethane rear --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 1:00:15 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 1:00:15 PM Subject: Notes issue Body: System.Data.SqlClient.SqlException (0x80131904): The parameterized query '(@WorkOrderIdent bigint,@AttachmentIdent bigint,@Cust bit,@SP bi' expects the parameter '@url', which was not supplied. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at ServiceSuite.Service.ChangeQueue(Notes Note, Int64 TaskIdent) in D:\ServiceSuite\ServiceSuite\SS.svc.cs:line 5519 ClientConnectionId:3db684ce-ea36-4c12-ac22-0b45ec4211d6 Error Number:8178,State:1,Class:16 c:\Web\InetPub\DotNet Applications\Dev\New\ServiceSuite\TempWorkOrderXML\WO385855.xml --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 1:00:15 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 1:00:15 PM Subject: Front left strap weldment Body: Front left strap weldment --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 1:00:15 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 1:00:15 PM Subject: Front right strap weldment Body: Front right strap weldment --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 1:00:16 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 1:00:16 PM Subject: TIRE-8.5 inch, FOAM FILLED SHORE 20 (25PSI). Body: TIRE-8.5 inch, FOAM FILLED SHORE 20 (25PSI). --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 1:00:17 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 1:00:17 PM Subject: BATTERY 12V 100AH AGM Body: BATTERY 12V 100AH AGM --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 1:00:17 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 1:00:17 PM Subject: Squeegee blade 34 inch urethane front Body: Squeegee blade 34 inch urethane front --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 1:00:18 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 1:00:18 PM Subject: Notes issue Body: System.Data.SqlClient.SqlException (0x80131904): The parameterized query '(@WorkOrderIdent bigint,@AttachmentIdent bigint,@Cust bit,@SP bi' expects the parameter '@url', which was not supplied. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at ServiceSuite.Service.ChangeQueue(Notes Note, Int64 TaskIdent) in D:\ServiceSuite\ServiceSuite\SS.svc.cs:line 5519 ClientConnectionId:52b028b5-770a-46ae-9e47-17b25e232e13 Error Number:8178,State:1,Class:16 c:\Web\InetPub\DotNet Applications\Dev\New\ServiceSuite\TempWorkOrderXML\WO385855.xml --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 1:00:18 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 1:00:18 PM Subject: Labor Body: Labor --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 5:54:55 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 5:54:55 PM Subject: BC queue count issue Body: System.NullReferenceException: Object reference not set to an instance of an object. at Ajax.Ajax.GetBCProgressCount() in D:\ServiceSuite\ServiceSuite\Ajax.svc.cs:line 2446 --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 9:10:17 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 9:10:17 PM Subject: BC queue count issue Body: System.NullReferenceException: Object reference not set to an instance of an object. at Ajax.Ajax.GetBCProgressCount() in D:\ServiceSuite\ServiceSuite\Ajax.svc.cs:line 2446 --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 9:27:11 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 9:27:11 PM Subject: BC queue count issue Body: System.NullReferenceException: Object reference not set to an instance of an object. at Ajax.Ajax.GetBCProgressCount() in D:\ServiceSuite\ServiceSuite\Ajax.svc.cs:line 2446 --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 9:34:28 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 9:34:28 PM Subject: BC queue count issue Body: System.NullReferenceException: Object reference not set to an instance of an object. at Ajax.Ajax.GetBCProgressCount() in D:\ServiceSuite\ServiceSuite\Ajax.svc.cs:line 2446 --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 9:59:19 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 9:59:19 PM Subject: BC queue count issue Body: System.NullReferenceException: Object reference not set to an instance of an object. at Ajax.Ajax.GetBCProgressCount() in D:\ServiceSuite\ServiceSuite\Ajax.svc.cs:line 2446 --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 10:14:55 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 10:14:55 PM Subject: BC queue count issue Body: System.NullReferenceException: Object reference not set to an instance of an object. at Ajax.Ajax.GetBCProgressCount() in D:\ServiceSuite\ServiceSuite\Ajax.svc.cs:line 2446 --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 11:34:25 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 11:34:25 PM Subject: 37 inch squeegee pu assembly Body: 37 inch squeegee pu assembly --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 11:34:35 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 11:34:35 PM Subject: Squeegee blade front Body: Squeegee blade front --------------------------------*End*------------------------------------------ -----------Exception Details on 7/30/2023 11:35:55 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 7/30/2023 11:35:55 PM Subject: Squeegee blade rear Body: Squeegee blade rear --------------------------------*End*------------------------------------------