--------------------------------------------------------------- Log Entry : 2/1/2024 12:37:23 PM - ------------------------------------------------------------- {"HeaderId":0,"RTSHeaderId":203,"sDate":"2024-02-01","VendorId":977,"UserId":9,"Body":[{"Item_Id":693,"Warehouse_Id":0,"Converter_Id":436,"ProductType_Id":1,"Unit_Id":6,"ExpectedQty":800.0,"ReceivedQty":800.0,"QtyDifference":0.0,"QtyPerPallet":0.0,"TotalPallet":0.0,"ActualPallet":0.0,"ChargablePallet":0.0,"ChargableContainer":0.0,"Remarks":"","RefId":1417,"BatchNo":"d1","ExpDate":"2024-02-29","MfgDate":"2024-02-01","BatchQty":1.0}]} --------------------------------------------------------------- Log Entry : 2/1/2024 12:37:26 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:4ec918ec-4852-4f88-a160-a99a9cbf1648 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 12:39:59 PM - ------------------------------------------------------------- {"HeaderId":0,"RTSHeaderId":203,"sDate":"2024-02-01","VendorId":977,"UserId":9,"Body":[{"Item_Id":693,"Warehouse_Id":0,"Converter_Id":438,"ProductType_Id":1,"Unit_Id":6,"ExpectedQty":800.0,"ReceivedQty":800.0,"QtyDifference":0.0,"QtyPerPallet":0.0,"TotalPallet":0.0,"ActualPallet":0.0,"ChargablePallet":0.0,"ChargableContainer":0.0,"Remarks":"","RefId":1417,"BatchNo":"g2","ExpDate":"2024-02-29","MfgDate":"2024-02-01","BatchQty":2.0}]} --------------------------------------------------------------- Log Entry : 2/1/2024 12:40:02 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:ee79ea3d-95c8-41a3-ae9f-18f493993553 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 12:40:02 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:4ec918ec-4852-4f88-a160-a99a9cbf1648 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 12:52:57 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:ee79ea3d-95c8-41a3-ae9f-18f493993553 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 12:53:25 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:ee79ea3d-95c8-41a3-ae9f-18f493993553 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 12:53:35 PM - ------------------------------------------------------------- {"iWarehouse":33,"iConverter":81022,"iHeaderId":28,"UserId":9} --------------------------------------------------------------- Log Entry : 2/1/2024 12:53:35 PM - ------------------------------------------------------------- InwardController Method:Inward System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.InwardController.PostingFocus(Posingdata obj) ClientConnectionId:ee79ea3d-95c8-41a3-ae9f-18f493993553 Error Number:512,State:1,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 12:53:39 PM - ------------------------------------------------------------- {"iWarehouse":33,"iConverter":81022,"iHeaderId":28,"UserId":9} --------------------------------------------------------------- Log Entry : 2/1/2024 12:53:39 PM - ------------------------------------------------------------- InwardController Method:Inward System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.InwardController.PostingFocus(Posingdata obj) ClientConnectionId:ee79ea3d-95c8-41a3-ae9f-18f493993553 Error Number:512,State:1,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 1:05:39 PM - ------------------------------------------------------------- {"iWarehouse":33,"iConverter":81022,"iHeaderId":28,"UserId":9} --------------------------------------------------------------- Log Entry : 2/1/2024 1:09:03 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:d8267919-3832-46c6-92c3-a0e0134df8b7 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 1:09:03 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:32726b6b-07ec-4f62-a501-0a340bd86160 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 1:09:08 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:32726b6b-07ec-4f62-a501-0a340bd86160 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 1:22:12 PM - ------------------------------------------------------------- {"iWarehouse":33,"iConverter":81022,"iHeaderId":28,"UserId":9} --------------------------------------------------------------- Log Entry : 2/1/2024 1:24:09 PM - ------------------------------------------------------------- {"iWarehouse":33,"iConverter":81022,"iHeaderId":28,"UserId":9} --------------------------------------------------------------- Log Entry : 2/1/2024 1:31:13 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:c271634d-dd69-4ff9-a77a-fd88e22e77cd Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 1:31:13 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:122be501-8889-4c18-8bc3-fe1355e3d072 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 1:38:36 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:0f834120-1eb1-4754-a843-25ffb9b1717b Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 1:39:39 PM - ------------------------------------------------------------- {"HeaderId":0,"RTSHeaderId":203,"sDate":"2024-02-01","VendorId":977,"UserId":9,"Body":[{"Item_Id":696,"Warehouse_Id":0,"Converter_Id":439,"ProductType_Id":1,"Unit_Id":6,"ExpectedQty":6000.0,"ReceivedQty":6000.0,"QtyDifference":0.0,"QtyPerPallet":0.0,"TotalPallet":0.0,"ActualPallet":0.0,"ChargablePallet":0.0,"ChargableContainer":0.0,"Remarks":"","RefId":1416,"BatchNo":"h1","ExpDate":"2024-02-29","MfgDate":"2024-02-01","BatchQty":10.0}]} --------------------------------------------------------------- Log Entry : 2/1/2024 1:39:44 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:0f834120-1eb1-4754-a843-25ffb9b1717b Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 1:39:44 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:0f834120-1eb1-4754-a843-25ffb9b1717b Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 1:41:31 PM - ------------------------------------------------------------- {"HeaderId":0,"RTSHeaderId":203,"sDate":"2024-02-01","VendorId":977,"UserId":9,"Body":[{"Item_Id":693,"Warehouse_Id":0,"Converter_Id":440,"ProductType_Id":1,"Unit_Id":6,"ExpectedQty":800.0,"ReceivedQty":800.0,"QtyDifference":0.0,"QtyPerPallet":0.0,"TotalPallet":0.0,"ActualPallet":0.0,"ChargablePallet":0.0,"ChargableContainer":0.0,"Remarks":"","RefId":1417,"BatchNo":"h1","ExpDate":"2024-02-01","MfgDate":"2024-02-01","BatchQty":1.0}]} --------------------------------------------------------------- Log Entry : 2/1/2024 1:41:33 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:0f834120-1eb1-4754-a843-25ffb9b1717b Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 1:41:33 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:0f834120-1eb1-4754-a843-25ffb9b1717b Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 1:41:48 PM - ------------------------------------------------------------- {"iWarehouse":33,"iConverter":440,"iHeaderId":1,"UserId":9} --------------------------------------------------------------- Log Entry : 2/1/2024 3:22:20 PM - ------------------------------------------------------------- {"HeaderId":0,"RTSHeaderId":513,"sDate":"2024-02-01","VendorId":977,"UserId":9,"Body":[{"Item_Id":697,"Warehouse_Id":0,"Converter_Id":442,"ProductType_Id":1,"Unit_Id":6,"ExpectedQty":60.0,"ReceivedQty":60.0,"QtyDifference":0.0,"QtyPerPallet":0.0,"TotalPallet":0.0,"ActualPallet":0.0,"ChargablePallet":0.0,"ChargableContainer":0.0,"Remarks":"","RefId":3604,"BatchNo":"b1","ExpDate":"2024-02-29","MfgDate":"2024-02-01","BatchQty":1.0}]} --------------------------------------------------------------- Log Entry : 2/1/2024 3:22:59 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:f13dd0a4-aaa2-4902-bb7d-b474d3872b45 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 3:23:07 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:f13dd0a4-aaa2-4902-bb7d-b474d3872b45 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 3:23:27 PM - ------------------------------------------------------------- {"iWarehouse":33,"iConverter":442,"iHeaderId":2,"UserId":9} --------------------------------------------------------------- Log Entry : 2/1/2024 3:57:43 PM - ------------------------------------------------------------- {"HeaderId":0,"RTSHeaderId":513,"sDate":"2024-02-01","VendorId":977,"UserId":9,"Body":[{"Item_Id":697,"Warehouse_Id":0,"Converter_Id":443,"ProductType_Id":1,"Unit_Id":6,"ExpectedQty":60.0,"ReceivedQty":60.0,"QtyDifference":0.0,"QtyPerPallet":0.0,"TotalPallet":0.0,"ActualPallet":0.0,"ChargablePallet":0.0,"ChargableContainer":0.0,"Remarks":"","RefId":3604,"BatchNo":"b1","ExpDate":"2024-02-01","MfgDate":"2024-02-01","BatchQty":1.0}]} --------------------------------------------------------------- Log Entry : 2/1/2024 3:57:52 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:8787dc9d-f980-49bb-82ce-8dd7a1b3e1ac Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 3:57:52 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:21c591d3-8416-441b-8a8b-8e16ebadc1a2 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 3:58:14 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:8787dc9d-f980-49bb-82ce-8dd7a1b3e1ac Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 3:58:17 PM - ------------------------------------------------------------- {"iWarehouse":33,"iConverter":442,"iHeaderId":2,"UserId":9} --------------------------------------------------------------- Log Entry : 2/1/2024 4:43:03 PM - ------------------------------------------------------------- {"HeaderId":0,"RTSHeaderId":513,"sDate":"2024-02-01","VendorId":977,"UserId":9,"Body":[{"Item_Id":697,"Warehouse_Id":0,"Converter_Id":444,"ProductType_Id":1,"Unit_Id":6,"ExpectedQty":60.0,"ReceivedQty":60.0,"QtyDifference":0.0,"QtyPerPallet":0.0,"TotalPallet":0.0,"ActualPallet":0.0,"ChargablePallet":0.0,"ChargableContainer":0.0,"Remarks":"","RefId":3604,"BatchNo":"b1","ExpDate":"2024-02-29","MfgDate":"2024-02-01","BatchQty":1.0}]} --------------------------------------------------------------- Log Entry : 2/1/2024 4:44:27 PM - ------------------------------------------------------------- {"HeaderId":1,"RTSHeaderId":0,"sDate":"2024-02-01","VendorId":977,"UserId":9,"Body":[{"Item_Id":697,"Warehouse_Id":0,"Converter_Id":444,"ProductType_Id":1,"Unit_Id":6,"ExpectedQty":60.0,"ReceivedQty":2.0,"QtyDifference":0.0,"QtyPerPallet":0.0,"TotalPallet":0.0,"ActualPallet":0.0,"ChargablePallet":0.0,"ChargableContainer":0.0,"Remarks":"","RefId":3604,"BatchNo":"b1","ExpDate":"2024-02-29","MfgDate":"2024-02-01","BatchQty":1.0},{"Item_Id":697,"Warehouse_Id":0,"Converter_Id":445,"ProductType_Id":1,"Unit_Id":6,"ExpectedQty":60.0,"ReceivedQty":2.0,"QtyDifference":0.0,"QtyPerPallet":0.0,"TotalPallet":0.0,"ActualPallet":0.0,"ChargablePallet":0.0,"ChargableContainer":0.0,"Remarks":"","RefId":3604,"BatchNo":"b2","ExpDate":"2024-02-29","MfgDate":"2024-02-01","BatchQty":1.0}]} --------------------------------------------------------------- Log Entry : 2/1/2024 4:45:11 PM - ------------------------------------------------------------- {"HeaderId":2,"RTSHeaderId":0,"sDate":"2024-02-01","VendorId":977,"UserId":9,"Body":[{"Item_Id":697,"Warehouse_Id":0,"Converter_Id":444,"ProductType_Id":1,"Unit_Id":6,"ExpectedQty":60.0,"ReceivedQty":2.0,"QtyDifference":0.0,"QtyPerPallet":0.0,"TotalPallet":0.0,"ActualPallet":0.0,"ChargablePallet":0.0,"ChargableContainer":0.0,"Remarks":"","RefId":3604,"BatchNo":"b1","ExpDate":"2024-02-29","MfgDate":"2024-02-01","BatchQty":1.0},{"Item_Id":697,"Warehouse_Id":0,"Converter_Id":445,"ProductType_Id":1,"Unit_Id":6,"ExpectedQty":60.0,"ReceivedQty":2.0,"QtyDifference":0.0,"QtyPerPallet":0.0,"TotalPallet":0.0,"ActualPallet":0.0,"ChargablePallet":0.0,"ChargableContainer":0.0,"Remarks":"","RefId":3604,"BatchNo":"b2","ExpDate":"2024-02-29","MfgDate":"2024-02-01","BatchQty":1.0}]} --------------------------------------------------------------- Log Entry : 2/1/2024 4:52:10 PM - ------------------------------------------------------------- {"HeaderId":0,"RTSHeaderId":513,"sDate":"2024-02-01","VendorId":977,"UserId":9,"Body":[{"Item_Id":697,"Warehouse_Id":0,"Converter_Id":446,"ProductType_Id":1,"Unit_Id":6,"ExpectedQty":60.0,"ReceivedQty":60.0,"QtyDifference":0.0,"QtyPerPallet":0.0,"TotalPallet":0.0,"ActualPallet":0.0,"ChargablePallet":0.0,"ChargableContainer":0.0,"Remarks":"","RefId":3604,"BatchNo":"b1","ExpDate":"2024-02-29","MfgDate":"2024-02-01","BatchQty":1.0}]} --------------------------------------------------------------- Log Entry : 2/1/2024 4:53:09 PM - ------------------------------------------------------------- {"HeaderId":1,"RTSHeaderId":0,"sDate":"2024-02-01","VendorId":977,"UserId":9,"Body":[{"Item_Id":697,"Warehouse_Id":0,"Converter_Id":446,"ProductType_Id":1,"Unit_Id":6,"ExpectedQty":60.0,"ReceivedQty":2.0,"QtyDifference":0.0,"QtyPerPallet":0.0,"TotalPallet":0.0,"ActualPallet":0.0,"ChargablePallet":0.0,"ChargableContainer":0.0,"Remarks":"","RefId":3604,"BatchNo":"b1","ExpDate":"2024-02-29","MfgDate":"2024-02-01","BatchQty":1.0},{"Item_Id":697,"Warehouse_Id":0,"Converter_Id":447,"ProductType_Id":1,"Unit_Id":6,"ExpectedQty":60.0,"ReceivedQty":2.0,"QtyDifference":0.0,"QtyPerPallet":0.0,"TotalPallet":0.0,"ActualPallet":0.0,"ChargablePallet":0.0,"ChargableContainer":0.0,"Remarks":"","RefId":3604,"BatchNo":"c1","ExpDate":"2024-02-29","MfgDate":"2024-02-01","BatchQty":1.0}]} --------------------------------------------------------------- Log Entry : 2/1/2024 4:53:22 PM - ------------------------------------------------------------- {"HeaderId":1,"RTSHeaderId":0,"sDate":"2024-02-01","VendorId":977,"UserId":9,"Body":[{"Item_Id":697,"Warehouse_Id":0,"Converter_Id":446,"ProductType_Id":1,"Unit_Id":6,"ExpectedQty":60.0,"ReceivedQty":2.0,"QtyDifference":0.0,"QtyPerPallet":0.0,"TotalPallet":0.0,"ActualPallet":0.0,"ChargablePallet":0.0,"ChargableContainer":0.0,"Remarks":"","RefId":3604,"BatchNo":"b1","ExpDate":"2024-02-29","MfgDate":"2024-02-01","BatchQty":1.0},{"Item_Id":697,"Warehouse_Id":0,"Converter_Id":447,"ProductType_Id":1,"Unit_Id":6,"ExpectedQty":60.0,"ReceivedQty":2.0,"QtyDifference":0.0,"QtyPerPallet":0.0,"TotalPallet":0.0,"ActualPallet":0.0,"ChargablePallet":0.0,"ChargableContainer":0.0,"Remarks":"","RefId":3604,"BatchNo":"c1","ExpDate":"2024-02-29","MfgDate":"2024-02-01","BatchQty":1.0}]} --------------------------------------------------------------- Log Entry : 2/1/2024 4:53:30 PM - ------------------------------------------------------------- {"HeaderId":1,"RTSHeaderId":0,"sDate":"2024-02-01","VendorId":977,"UserId":9,"Body":[{"Item_Id":697,"Warehouse_Id":0,"Converter_Id":446,"ProductType_Id":1,"Unit_Id":6,"ExpectedQty":60.0,"ReceivedQty":2.0,"QtyDifference":0.0,"QtyPerPallet":0.0,"TotalPallet":0.0,"ActualPallet":0.0,"ChargablePallet":0.0,"ChargableContainer":0.0,"Remarks":"","RefId":3604,"BatchNo":"b1","ExpDate":"2024-02-29","MfgDate":"2024-02-01","BatchQty":1.0},{"Item_Id":697,"Warehouse_Id":0,"Converter_Id":447,"ProductType_Id":1,"Unit_Id":6,"ExpectedQty":60.0,"ReceivedQty":2.0,"QtyDifference":0.0,"QtyPerPallet":0.0,"TotalPallet":0.0,"ActualPallet":0.0,"ChargablePallet":0.0,"ChargableContainer":0.0,"Remarks":"","RefId":3604,"BatchNo":"c1","ExpDate":"2024-02-29","MfgDate":"2024-02-01","BatchQty":1.0}]} --------------------------------------------------------------- Log Entry : 2/1/2024 4:54:11 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:d60d3f55-7389-4f83-b8ae-4383bb152879 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 4:54:26 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:d60d3f55-7389-4f83-b8ae-4383bb152879 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 4:54:40 PM - ------------------------------------------------------------- {"iWarehouse":33,"iConverter":446,"iHeaderId":1,"UserId":9} --------------------------------------------------------------- Log Entry : 2/1/2024 4:54:41 PM - ------------------------------------------------------------- InwardController Method:Inward System.Data.SqlClient.SqlException (0x80131904): Procedure or function ssSp_FullyLockConvertor has too many arguments specified. at System.Data.SqlClient.SqlConnection.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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Sang.FocusWH.WebApi.General.DBHelper.ExecuteNonQuery(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.InwardController.PostingFocus(Posingdata obj) ClientConnectionId:d60d3f55-7389-4f83-b8ae-4383bb152879 Error Number:8144,State:2,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 4:55:00 PM - ------------------------------------------------------------- {"iWarehouse":33,"iConverter":446,"iHeaderId":1,"UserId":9} --------------------------------------------------------------- Log Entry : 2/1/2024 4:55:00 PM - ------------------------------------------------------------- InwardController Method:Inward System.Data.SqlClient.SqlException (0x80131904): Procedure or function ssSp_FullyLockConvertor has too many arguments specified. at System.Data.SqlClient.SqlConnection.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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Sang.FocusWH.WebApi.General.DBHelper.ExecuteNonQuery(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.InwardController.PostingFocus(Posingdata obj) ClientConnectionId:b2eb2f97-458e-46b9-8209-aa0da9a278ff Error Number:8144,State:2,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 5:03:32 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:9b6e811c-7772-4314-8396-da547b38eb28 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 5:03:32 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:404f60d6-3c25-4206-a59f-019a105894ca Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 5:06:06 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:404f60d6-3c25-4206-a59f-019a105894ca Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 5:06:08 PM - ------------------------------------------------------------- {"iWarehouse":33,"iConverter":447,"iHeaderId":1,"UserId":9} --------------------------------------------------------------- Log Entry : 2/1/2024 5:06:09 PM - ------------------------------------------------------------- InwardController Method:Inward System.Data.SqlClient.SqlException (0x80131904): Procedure or function ssSp_FullyLockConvertor has too many arguments specified. at System.Data.SqlClient.SqlConnection.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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Sang.FocusWH.WebApi.General.DBHelper.ExecuteNonQuery(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.InwardController.PostingFocus(Posingdata obj) ClientConnectionId:404f60d6-3c25-4206-a59f-019a105894ca Error Number:8144,State:2,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 5:06:36 PM - ------------------------------------------------------------- {"iWarehouse":33,"iConverter":447,"iHeaderId":1,"UserId":9} --------------------------------------------------------------- Log Entry : 2/1/2024 5:06:36 PM - ------------------------------------------------------------- InwardController Method:Inward System.Data.SqlClient.SqlException (0x80131904): Procedure or function ssSp_FullyLockConvertor has too many arguments specified. at System.Data.SqlClient.SqlConnection.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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Sang.FocusWH.WebApi.General.DBHelper.ExecuteNonQuery(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.InwardController.PostingFocus(Posingdata obj) ClientConnectionId:9b6e811c-7772-4314-8396-da547b38eb28 Error Number:8144,State:2,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 5:20:07 PM - ------------------------------------------------------------- {"iWarehouse":33,"iConverter":447,"iHeaderId":1,"UserId":9} --------------------------------------------------------------- Log Entry : 2/1/2024 5:20:07 PM - ------------------------------------------------------------- {"iWarehouse":33,"iConverter":447,"iHeaderId":1,"UserId":9} --------------------------------------------------------------- Log Entry : 2/1/2024 5:20:07 PM - ------------------------------------------------------------- {"iWarehouse":33,"iConverter":447,"iHeaderId":1,"UserId":9} --------------------------------------------------------------- Log Entry : 2/1/2024 5:20:10 PM - ------------------------------------------------------------- InwardController Method:Inward System.Data.SqlClient.SqlException (0x80131904): Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fn_datetoint", or the name is ambiguous. at System.Data.SqlClient.SqlConnection.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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Sang.FocusWH.WebApi.General.DBHelper.ExecuteNonQuery(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.InwardController.PostingFocus(Posingdata obj) ClientConnectionId:ffec9661-702f-4730-88a9-c54a39255986 Error Number:4121,State:1,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 5:20:10 PM - ------------------------------------------------------------- InwardController Method:Inward System.Data.SqlClient.SqlException (0x80131904): Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fn_datetoint", or the name is ambiguous. at System.Data.SqlClient.SqlConnection.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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Sang.FocusWH.WebApi.General.DBHelper.ExecuteNonQuery(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.InwardController.PostingFocus(Posingdata obj) ClientConnectionId:ffec9661-702f-4730-88a9-c54a39255986 Error Number:4121,State:1,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 5:20:10 PM - ------------------------------------------------------------- InwardController Method:Inward System.Data.SqlClient.SqlException (0x80131904): Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fn_datetoint", or the name is ambiguous. at System.Data.SqlClient.SqlConnection.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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Sang.FocusWH.WebApi.General.DBHelper.ExecuteNonQuery(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.InwardController.PostingFocus(Posingdata obj) ClientConnectionId:ffec9661-702f-4730-88a9-c54a39255986 Error Number:4121,State:1,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 5:20:15 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:349fba26-7b89-44c7-9536-8a3cb1e72997 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 5:20:38 PM - ------------------------------------------------------------- {"iWarehouse":33,"iConverter":446,"iHeaderId":1,"UserId":9} --------------------------------------------------------------- Log Entry : 2/1/2024 5:20:38 PM - ------------------------------------------------------------- InwardController Method:Inward System.Data.SqlClient.SqlException (0x80131904): Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fn_datetoint", or the name is ambiguous. at System.Data.SqlClient.SqlConnection.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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Sang.FocusWH.WebApi.General.DBHelper.ExecuteNonQuery(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.InwardController.PostingFocus(Posingdata obj) ClientConnectionId:ffec9661-702f-4730-88a9-c54a39255986 Error Number:4121,State:1,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 5:22:02 PM - ------------------------------------------------------------- {"iWarehouse":33,"iConverter":446,"iHeaderId":1,"UserId":9} --------------------------------------------------------------- Log Entry : 2/1/2024 5:22:03 PM - ------------------------------------------------------------- InwardController Method:Inward System.Data.SqlClient.SqlException (0x80131904): Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fn_datetoint", or the name is ambiguous. at System.Data.SqlClient.SqlConnection.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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Sang.FocusWH.WebApi.General.DBHelper.ExecuteNonQuery(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.InwardController.PostingFocus(Posingdata obj) ClientConnectionId:ffec9661-702f-4730-88a9-c54a39255986 Error Number:4121,State:1,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 5:22:50 PM - ------------------------------------------------------------- {"iWarehouse":33,"iConverter":446,"iHeaderId":1,"UserId":9} --------------------------------------------------------------- Log Entry : 2/1/2024 7:51:06 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:3a78be7d-37b5-41d2-86ac-fc52d3a27f86 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 7:51:06 PM - ------------------------------------------------------------- MasterController Method:Master System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'ssSp_Masters' expects parameter '@sSearch', which was not supplied. at Sang.FocusWH.WebApi.General.DBHelper.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.FocusWH.WebApi.Controllers.MasterController.GetMaster(Int32 MasterType, Int32 SearchType, String SearchString, Int32 UserId) ClientConnectionId:3a78be7d-37b5-41d2-86ac-fc52d3a27f86 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 2/1/2024 8:34:00 PM - ------------------------------------------------------------- {"HeaderId":0,"SOHeaderId":136,"sDate":"2024-02-01","CustomerId":620,"ContractNoId":346,"DivisionId":2,"DispatchPortId":0,"DestinationPortId":0,"UserId":9,"sDeliveryDate":"2024/02/01","Body":[{"Item_Id":697,"Converter_Id":446,"ProductType_Id":1,"Unit_Id":6,"Quantity":1.0,"IssuedPallet":0.0,"WarehouseId":33,"RefId":1142,"BatchId":3615,"BatchNo":"CH3","BatchQty":1.0}]} --------------------------------------------------------------- Log Entry : 2/1/2024 8:39:01 PM - ------------------------------------------------------------- {"HeaderId":531,"SOHeaderId":0,"sDate":"2024/02/01","CustomerId":620,"ContractNoId":346,"DivisionId":2,"DispatchPortId":0,"DestinationPortId":0,"UserId":9,"sDeliveryDate":"2024/02/01","Body":[{"Item_Id":697,"Converter_Id":447,"ProductType_Id":1,"Unit_Id":6,"Quantity":1.0,"IssuedPallet":0.0,"WarehouseId":33,"RefId":1142,"BatchId":3614,"BatchNo":"C1","BatchQty":1.0},{"Item_Id":697,"Converter_Id":446,"ProductType_Id":1,"Unit_Id":6,"Quantity":1.0,"IssuedPallet":0.0,"WarehouseId":33,"RefId":1142,"BatchId":3615,"BatchNo":"CH3","BatchQty":1.0}]}