iisnode encountered an error when processing the request.
HRESULT: 0x6d HTTP status: 500 HTTP subStatus: 1013 HTTP reason: Internal Server Error
You are receiving this HTTP 200 response because system.webServer/iisnode/@devErrorsEnabled configuration setting is 'true'.
In addition to the log of stdout and stderr of the node.exe process, consider using debugging and ETW traces to further diagnose the problem.
The last 64k of the output generated by the node.exe process to stderr is shown below:
(node:15780) [DEP0005] DeprecationWarning: Buffer() is deprecated due to security and usability issues. Please use the Buffer.alloc(), Buffer.allocUnsafe(), or Buffer.from() methods instead. (Use `node --trace-deprecation ...` to show where the warning was created) sql query execution error: WITH cheapest_variation AS ( SELECT product_id, sell_price, discount FROM ( SELECT product_id, sell_price, discount, ROW_NUMBER() OVER (PARTITION BY ProductVariation.product_id ORDER BY (CASE WHEN sell_price > 0 THEN 0 ELSE 1 END), sell_price) row_num FROM ProductVariation WHERE owner='5541DDC9-434F-45E0-AD19-E279ED1B5B16' AND is_deleted=0 AND uuid IN (SELECT product_variation_id FROM dbo.F_ProductVariation_Stock_For_Webshop('5541DDC9-434F-45E0-AD19-E279ED1B5B16') WHERE _stock > 0) ) AS _ WHERE row_num = 1 ), variation_info AS ( SELECT pv.product_id, SUM(pvStock._stock) total_stock, COUNT(pv.uuid) product_variation_count FROM ProductVariation pv INNER JOIN dbo.V_ProductVariation_Stock_For_Webshop pvStock ON pv.uuid = pvStock.product_variation_id WHERE pv.owner='5541DDC9-434F-45E0-AD19-E279ED1B5B16' AND is_deleted=0 GROUP BY pv.product_id ) SELECT uuid, title, public_id, brand, unit, directory_id, is_available_on_webshop, changed_at, ISNULL(sell_price, 0) [sell {"code":"EREQUEST","originalError":{"sqlstate":"HYT00","code":0,"severity":0,"serverName":"","procName":"","lineNumber":0},"name":"RequestError","number":0,"lineNumber":0,"state":"HYT00","class":0,"serverName":"","procName":""} unhandledRejection: RequestError: Query timeout expired