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:12932) [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 InStockProducts AS (
                SELECT product_id
                FROM F_Product_Stock_For_Webshop(N'09E74C5B-3429-4ACC-AAC1-7D1152AEB5BF')
                WHERE _stock > 0
            )
            SELECT COUNT(*) AS _count
            FROM Product
            JOIN InStockProducts ON Product.uuid = InStockProducts.product_id
            WHERE Product.is_deleted = 0
                AND Product.owner = N'09E74C5B-3429-4ACC-AAC1-7D1152AEB5BF'
                AND active_for_webshop=1 AND is_archived=0
        

            {"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
sql query execution error:

            
            SELECT
                ord.uuid, ord.order_number, ord.meta_webshop_details, ord.recipient_mobile, ord.status, ord.status_changed_at, ord.status_change_desc, ord.order_type, ord.tax_rate, ord.discount, ord.invoice_number, ord.meta_tracking_reference,
                ord.order_linked_id, ord.description, ord.creator, ord.updated_at, ord.created_at,
                amounts._total_sum, amounts._order_tax, amounts._order_extra_sum, amounts._order_discount, amounts._final_invoice_amount,
                ordDet.title, ordDet.warehouse_id, ordDet.quantity, ordDet.unit, /*ordDet.unit2, ordDet.quantity_coef, */
                ordDet.price, ordDet.discount detail_discount, ordDet.has_tax, ordDet.sequence, ordDet.description detail_description, ordDet.created_at detail_created_at,
                prd.public_id AS product_public_id, prd.title AS product_title, prdMedia.url AS product_cover_image_url,
                prdVar.sku AS product_sku, prdVar.sku_prefix AS product_sku_prefix, 

            {"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
sql query execution error:

            
DECLARE @product_id uniqueidentifier = NULL
SELECT TOP 1 @product_id=uuid
FROM [Product] prd

WHERE public_id=N'NL9PBA3B'
    AND prd.owner=N'757E2384-5298-4D01-B406-67D9DAFAD4DA'
    AND prd.is_archived=0
    AND prd.is_deleted=0
	AND prd.active_for_webshop=1
    


IF (@product_id IS NOT NULL)
BEGIN
    SELECT *,
        (SELECT COUNT(*) FROM WebShopStarred WHERE product_id=@product_id AND is_favorite=1) AS like_count
    FROM [Product] WHERE uuid=@product_id

    SELECT prdVar.uuid, prdVar.product_id, prdVar.sku, prdVar.sku_prefix, prdVar.sku_suffix, prdVar.discount,
        prdVar.sell_price, prdVar.sell_price2, prdVar.sell_price3,
        prdVar.option1_id, prdVar.option_value1_id,
        prdVar.option2_id, prdVar.option_value2_id,
        IIF(prd.is_available_on_webshop=0, 0, IIF(prdVarStock._stock < prdVar.min_purchase_quantity, 0, prdVarStock._stock)) stock,
        prdVar.min_purchase_quantity,
        prdVar.max_purchase_quantity,
		opt1   .name AS option1_name , opt1   .ty

            {"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