Description |
Warehouse rate matrix is not saving detail categories and throwing errors attached in screen shot.
SQL Profiler shows below error.
{color:blue}exec{color} sp_executesql N{color:red}'INSERT [dbo].[tblLGWarehouseRateMatrixDetail]([intWarehouseRateMatrixHeaderId], [strCategory], [strActivity], [intType], [intSort], [dblUnitRate], [intCommodityUnitMeasureId], [ysnPrint], [dtmCreatedDate], [intUserSecurityId], [strComments], [intConcurrencyId])
VALUES (@0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10, @11)
SELECT [intWarehouseRateMatrixDetailId]
FROM [dbo].[tblLGWarehouseRateMatrixDetail]
WHERE @@ROWCOUNT > 0 AND [intWarehouseRateMatrixDetailId] = scope_identity()'{color},N{color:red}'@0 int,@1 nvarchar(max) ,@2 nvarchar(max) ,@3 int,@4 int,@5 decimal(18,6),@6 int,@7 bit,@8 datetime2(7),@9 int,@10 nvarchar(max) ,@11 int'{color},@0={color:red}3{color},@1=N{color:red}'Handling'{color},@2=N{color:red}'Devanning'{color},@3={color:red}2{color},@4={color:red}1{color},@5={color:red}0.010000{color},@6={color:red}8{color},@7={color:red}1{color},@8={color:red}'0001-01-01 00:00:00'{color},@9={color:red}0{color},@10=N{color:red}'comment1'{color},@11={color:red}1{color}
go
|