2022-02-03 21:31:25 172.28.1.236 GET /Error er=5926 443 1644 172.28.168.24 Mozilla/5.0+(Macintosh;+Intel+Mac+OS+X+10.15;+rv:96.0)+Gecko/20100101+Firefox/96.0 https://maxar.jiraalign.com/default?Portfolios=2&Releases=24,23,22,21,20,19,18,17,6,16,15,14,13,5,4,2,3,7,44,26,36,37,38,59,60,61,64,65,69,70,71,72,73,74,75,76,77,78 200 0 0 16

{ [-]
   ASP_function: OOFunctionsSql.SetRSParamsCursor
   correlationid: isrtF/SyM8RiX6rAXAF7/kfb55XK7ittkDFCebquJNw=
   customer_db: Maxar
   error_description: Arithmetic overflow error converting float to data type numeric.
   error_id: 5926
   error_number: -2147217833
   error_source: Microsoft SQL Server Native Client 11.0
   log_type: exception
   logfrom_location: Website-ASP
   sql: WITH CTE AS (  SELECT    ProductID, ProductName, ParentID,    CAST(row_number()over(PARTITION BY parentid ORDER BY ProductName) AS varchar(max)) AS [path],    0 as level,    row_number()over(partition by parentid ORDER BY ProductName) / power(100.0,0) AS x FROM tblProducts WHERE parentid IS NULL AND Active = 1  OR ProductId = 37 UNION ALL SELECT    t.ProductID,    t.ProductName,   t.ParentID,    [path] +'-'+ cast(row_number()over(PARTITION BY t.parentid ORDER BY t.ProductName) AS varchar(max)),    level+1,    x + row_number()over(PARTITION BY t.parentid ORDER BY t.ProductName) / power(100.0,level+1)  FROM    cte JOIN tblProducts t ON cte.ProductID = t.ParentID )   SELECT    ProductID,    ProductName,    ParentID,    [path],    x, Level FROM cte ORDER BY x
   timestamp: 2022-02-03T16:31:25.347000-05:00
   url: https://maxar.jiraalign.com:443/NewRequest.asp?FirstTime=True&RequestID=12976
   urlverb: GET
   user: 1644
   version: 10.104.3.22710
}