-----------Exception Details on 5/28/2023 1:53:06 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 1:53:06 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 5/28/2023 1:55:30 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 1:55:30 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 5/28/2023 2:00:09 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 2:00:09 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 5/28/2023 2:05:26 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 2:05:26 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 5/28/2023 2:07:36 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 2:07:36 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 5/28/2023 2:07:42 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 2:07:42 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 5/28/2023 6:05:14 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 6:05:14 PM Subject: ARMOR 3-IC Body: ARMOR 3-IC --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 6:05:15 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 6:05:15 PM Subject: 24V 315amp Lithium Ion battery pack kit w/ charger Body: 24V 315amp Lithium Ion battery pack kit w/ charger --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 6:05:15 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 6:05:15 PM Subject: Velcro loop (sold by the inch) Body: Velcro loop (sold by the inch) --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 6:05:15 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 6:05:15 PM Subject: Velcro hook (sold by the inch) Body: Velcro hook (sold by the inch) --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 6:17:54 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 6:17:54 PM Subject: Hose clamp Body: Hose clamp --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 6:18:10 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 6:18:10 PM Subject: 24V solution solenoid valve assembly Body: 24V solution solenoid valve assembly --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 6:56:33 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 6:56:33 PM Subject: ARMOR 2-KAIVAC 2 (AC & DC) Body: ARMOR 2-KAIVAC 2 (AC & DC) --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 7:05:01 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 7:05:01 PM Subject: parts supply fee Body: parts supply fee --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 7:37:07 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 7:37:07 PM Subject: parts supply fee Body: parts supply fee --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 7:39:44 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 7:39:44 PM 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:e123427b-d2f5-48cc-886b-4a76b5bb1138 Error Number:547,State:0,Class:16 --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 7:42:09 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 7:42:09 PM 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:e2c0f02d-0b78-46fa-a7ad-ec3ac0c02cc0 Error Number:547,State:0,Class:16 --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 7:54:53 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 7:54:53 PM Subject: ARMOR 3-IC Body: ARMOR 3-IC --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 7:54:53 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 7:54:53 PM Subject: 24V 315amp Lithium Ion battery pack kit w/ charger Body: 24V 315amp Lithium Ion battery pack kit w/ charger --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 7:54:53 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 7:54:53 PM Subject: Velcro loop (sold by the inch) Body: Velcro loop (sold by the inch) --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 7:54:53 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 7:54:53 PM Subject: Velcro hook (sold by the inch) Body: Velcro hook (sold by the inch) --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 7:54:56 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 7:54:56 PM Subject: ARMOR 3-IC Body: ARMOR 3-IC --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 7:54:56 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 7:54:56 PM Subject: 24V 315amp Lithium Ion battery pack kit w/ charger Body: 24V 315amp Lithium Ion battery pack kit w/ charger --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 7:54:56 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 7:54:56 PM Subject: Velcro loop (sold by the inch) Body: Velcro loop (sold by the inch) --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 7:54:56 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 7:54:56 PM Subject: Velcro hook (sold by the inch) Body: Velcro hook (sold by the inch) --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 7:56:09 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 7:56:09 PM Subject: Vacuum motor set Body: Vacuum motor set --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:01:25 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:01:25 PM Subject: test Body: System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at ServiceSuite.Service.SaveFile(Int64 AttachmentIdent) in D:\ServiceSuite\ServiceSuite\SS.svc.cs:line 4946 at ServiceSuite.Service.GetNotes(Object identifier, String type, Int64 lastNoteID) in D:\ServiceSuite\ServiceSuite\SS.svc.cs:line 4471371860 --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:04:17 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:04:17 PM Subject: Squeegee blade kit linatex Body: Squeegee blade kit linatex --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:18:01 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:18:01 PM Subject: ARMOR 3-IC Body: ARMOR 3-IC --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:18:01 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:18:01 PM Subject: 24V 315amp Lithium Ion battery pack kit w/ charger Body: 24V 315amp Lithium Ion battery pack kit w/ charger --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:18:02 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:18:02 PM Subject: Velcro loop (sold by the inch) Body: Velcro loop (sold by the inch) --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:18:02 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:18:02 PM Subject: Velcro hook (sold by the inch) Body: Velcro hook (sold by the inch) --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:29:20 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:29:20 PM Subject: Broken Page - BaseCL.cs!! Body: System.InvalidCastException: Specified cast is not valid. at CRMContact.Contacts.GetContactQuick(String contactident) in D:\ServiceSuite\ServiceSuite\Contacts.svc.cs:line 208 --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:29:22 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:29:22 PM Subject: Broken Page - BaseCL.cs!! Body: System.InvalidCastException: Specified cast is not valid. at CRMContact.Contacts.GetContactQuick(String contactident) in D:\ServiceSuite\ServiceSuite\Contacts.svc.cs:line 208 --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:30:57 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:30:57 PM Subject: Broken Page - BaseCL.cs!! Body: System.InvalidCastException: Specified cast is not valid. at CRMContact.Contacts.GetContactQuick(String contactident) in D:\ServiceSuite\ServiceSuite\Contacts.svc.cs:line 208 --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:30:59 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:30:59 PM Subject: Broken Page - BaseCL.cs!! Body: System.InvalidCastException: Specified cast is not valid. at CRMContact.Contacts.GetContactQuick(String contactident) in D:\ServiceSuite\ServiceSuite\Contacts.svc.cs:line 208 --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:34:29 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:34:29 PM Subject: ARMOR 3-IC Body: ARMOR 3-IC --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:34:29 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:34:29 PM Subject: 24V 315amp Lithium Ion battery pack kit w/ charger Body: 24V 315amp Lithium Ion battery pack kit w/ charger --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:34:29 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:34:29 PM Subject: Velcro loop (sold by the inch) Body: Velcro loop (sold by the inch) --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:34:30 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:34:30 PM Subject: Velcro hook (sold by the inch) Body: Velcro hook (sold by the inch) --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:34:52 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:34:52 PM Subject: ARMOR 3-IC Body: ARMOR 3-IC --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:34:52 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:34:52 PM Subject: 24V 315amp Lithium Ion battery pack kit w/ charger Body: 24V 315amp Lithium Ion battery pack kit w/ charger --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:34:52 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:34:52 PM Subject: Velcro loop (sold by the inch) Body: Velcro loop (sold by the inch) --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:34:52 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:34:52 PM Subject: Velcro hook (sold by the inch) Body: Velcro hook (sold by the inch) --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:35:10 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:35:10 PM Subject: ARMOR 3-IC Body: ARMOR 3-IC --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:35:11 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:35:11 PM Subject: 24V 315amp Lithium Ion battery pack kit w/ charger Body: 24V 315amp Lithium Ion battery pack kit w/ charger --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:35:11 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:35:11 PM Subject: Velcro loop (sold by the inch) Body: Velcro loop (sold by the inch) --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:35:11 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:35:11 PM Subject: Velcro hook (sold by the inch) Body: Velcro hook (sold by the inch) --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:35:40 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:35:40 PM Subject: ARMOR 3-IC Body: ARMOR 3-IC --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:35:40 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:35:40 PM Subject: 24V 315amp Lithium Ion battery pack kit w/ charger Body: 24V 315amp Lithium Ion battery pack kit w/ charger --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:35:40 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:35:40 PM Subject: Velcro loop (sold by the inch) Body: Velcro loop (sold by the inch) --------------------------------*End*------------------------------------------ -----------Exception Details on 5/28/2023 8:35:41 PM----------------- ------------------------------------------------------------------------------------- Log Written Date: 5/28/2023 8:35:41 PM Subject: Velcro hook (sold by the inch) Body: Velcro hook (sold by the inch) --------------------------------*End*------------------------------------------