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:18900) [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:

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

WHERE public_id=N'VNPV7HEZ'
    AND prd.owner=N'93D2D0C4-FB1A-475F-8717-BF6312CA5BF3'
    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   .type        AS option1_type,
		optVal1.name AS option1_value, optVal1.value_order AS option1_order,
		opt2   .name AS option2_name , opt2   .type        AS option2_type,
		optVal2.name AS option2_value, optVal2.value_order AS option2_order
    FROM [ProductVariation]  AS prdVar
    LEFT JOIN [Product]      AS prd     ON prd.uuid = prdVar.product_id
    LEFT JOIN F_ProductVariation_Stock_For_Webshop(N'93D2D0C4-FB1A-475F-8717-BF6312CA5BF3') AS prdVarStock ON prdVar.uuid = prdVarStock.product_variation_id
	LEFT JOIN [Options]      AS opt1    ON prdVar.option1_id       = opt1.uuid    AND opt1   .is_deleted=0
	LEFT JOIN [OptionValues] AS optVal1 ON prdVar.option_value1_id = optVal1.uuid AND optVal1.is_deleted=0
	LEFT JOIN [Options]      AS opt2    ON prdVar.option2_id       = opt2.uuid    AND opt2   .is_deleted=0
	LEFT JOIN [OptionValues] AS optVal2 ON prdVar.option_value2_id = optVal2.uuid AND optVal2.is_deleted=0
    WHERE prdVar.product_id=@product_id AND prdVar.is_deleted=0
        -- -- it will cause missing prdVar info for a combination of options
    ORDER BY (CASE WHEN prdVar.sell_price > 0 THEN 0 ELSE 1 END), prdVar.sell_price

    SELECT url
    FROM [Media]
    WHERE Media.product_id=@product_id AND is_deleted=0
    ORDER BY is_cover DESC, list_order, created_at ASC

	SELECT atr.name, atr.display_name, atr.type,
		prdAtr.value AS [value], prdAtr.is_public AS [is_public], prdAtr.display_order AS [display_order]
	FROM [Attribute] AS atr
	INNER JOIN [ProductAttribute] AS prdAtr ON atr.uuid=prdAtr.attribute_id
	WHERE prdAtr.product_id=@product_id AND prdAtr.is_deleted=0 AND prdAtr.is_public=1
	ORDER BY prdAtr.display_order ASC

    SELECT uuid, name, type, 1 AS _order FROM [Options] WHERE uuid IN (SELECT option1_id FROM [ProductVariation] WHERE ProductVariation.product_id=@product_id AND is_deleted=0)
    UNION
    SELECT uuid, name, type, 2 AS _order FROM [Options] WHERE uuid IN (SELECT option2_id FROM [ProductVariation] WHERE ProductVariation.product_id=@product_id AND is_deleted=0)
    /* -- unlock more options like the following commented lines...
    UNION
    SELECT uuid, name, type, 3 AS _order FROM [Options] WHERE uuid IN (SELECT option3_id FROM [ProductVariation] WHERE ProductVariation.product_id=@product_id AND is_deleted=0)
    */
	ORDER BY _order

	SELECT uuid, name, option_id, value_order
	FROM [OptionValues]
	WHERE uuid IN (
		SELECT option_value1_id FROM [ProductVariation] WHERE ProductVariation.product_id=@product_id AND is_deleted=0
		UNION
		SELECT option_value2_id FROM [ProductVariation] WHERE ProductVariation.product_id=@product_id AND is_deleted=0
		/* -- unlock more options like the following commented lines...
		UNION
		SELECT option_value3_id FROM [ProductVariation] WHERE ProductVariation.product_id=@product_id AND is_deleted=0
		*/
	)
	ORDER BY value_order,name
END
{"code":"EREQUEST","originalError":{"sqlstate":"24000","code":0,"severity":0,"serverName":"","procName":"","lineNumber":0},"name":"RequestError","number":0,"lineNumber":0,"state":"24000","class":0,"serverName":"","procName":""}
unhandledRejection: RequestError: Invalid cursor state
sql query execution error:
SELECT TOP 1 * FROM [Webshop] 
                    WHERE [private_domain]=N'bahramstore.com'
{"code":"ENOTOPEN","name":"ConnectionError"}
ConnectionError: Connection is closing
    at ConnectionPool._acquire (C:\inetpub\TX_Kalaban\node_modules\mssql\lib\base\connection-pool.js:382:36)
    at ConnectionPool.acquire (C:\inetpub\TX_Kalaban\node_modules\mssql\lib\base\connection-pool.js:366:56)
    at Immediate.<anonymous> (C:\inetpub\TX_Kalaban\node_modules\mssql\lib\msnodesqlv8\request.js:354:19)
    at process.processImmediate (node:internal/timers:478:21) {
  code: 'ENOTOPEN'
}
unhandledRejection: ConnectionError: Connection is closing
sql query execution error:

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

WHERE public_id=N'VNPV7HEZ'
    AND prd.owner=N'93D2D0C4-FB1A-475F-8717-BF6312CA5BF3'
    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   .type        AS option1_type,
		optVal1.name AS option1_value, optVal1.value_order AS option1_order,
		opt2   .name AS option2_name , opt2   .type        AS option2_type,
		optVal2.name AS option2_value, optVal2.value_order AS option2_order
    FROM [ProductVariation]  AS prdVar
    LEFT JOIN [Product]      AS prd     ON prd.uuid = prdVar.product_id
    LEFT JOIN F_ProductVariation_Stock_For_Webshop(N'93D2D0C4-FB1A-475F-8717-BF6312CA5BF3') AS prdVarStock ON prdVar.uuid = prdVarStock.product_variation_id
	LEFT JOIN [Options]      AS opt1    ON prdVar.option1_id       = opt1.uuid    AND opt1   .is_deleted=0
	LEFT JOIN [OptionValues] AS optVal1 ON prdVar.option_value1_id = optVal1.uuid AND optVal1.is_deleted=0
	LEFT JOIN [Options]      AS opt2    ON prdVar.option2_id       = opt2.uuid    AND opt2   .is_deleted=0
	LEFT JOIN [OptionValues] AS optVal2 ON prdVar.option_value2_id = optVal2.uuid AND optVal2.is_deleted=0
    WHERE prdVar.product_id=@product_id AND prdVar.is_deleted=0
        -- -- it will cause missing prdVar info for a combination of options
    ORDER BY (CASE WHEN prdVar.sell_price > 0 THEN 0 ELSE 1 END), prdVar.sell_price

    SELECT url
    FROM [Media]
    WHERE Media.product_id=@product_id AND is_deleted=0
    ORDER BY is_cover DESC, list_order, created_at ASC

	SELECT atr.name, atr.display_name, atr.type,
		prdAtr.value AS [value], prdAtr.is_public AS [is_public], prdAtr.display_order AS [display_order]
	FROM [Attribute] AS atr
	INNER JOIN [ProductAttribute] AS prdAtr ON atr.uuid=prdAtr.attribute_id
	WHERE prdAtr.product_id=@product_id AND prdAtr.is_deleted=0 AND prdAtr.is_public=1
	ORDER BY prdAtr.display_order ASC

    SELECT uuid, name, type, 1 AS _order FROM [Options] WHERE uuid IN (SELECT option1_id FROM [ProductVariation] WHERE ProductVariation.product_id=@product_id AND is_deleted=0)
    UNION
    SELECT uuid, name, type, 2 AS _order FROM [Options] WHERE uuid IN (SELECT option2_id FROM [ProductVariation] WHERE ProductVariation.product_id=@product_id AND is_deleted=0)
    /* -- unlock more options like the following commented lines...
    UNION
    SELECT uuid, name, type, 3 AS _order FROM [Options] WHERE uuid IN (SELECT option3_id FROM [ProductVariation] WHERE ProductVariation.product_id=@product_id AND is_deleted=0)
    */
	ORDER BY _order

	SELECT uuid, name, option_id, value_order
	FROM [OptionValues]
	WHERE uuid IN (
		SELECT option_value1_id FROM [ProductVariation] WHERE ProductVariation.product_id=@product_id AND is_deleted=0
		UNION
		SELECT option_value2_id FROM [ProductVariation] WHERE ProductVariation.product_id=@product_id AND is_deleted=0
		/* -- unlock more options like the following commented lines...
		UNION
		SELECT option_value3_id FROM [ProductVariation] WHERE ProductVariation.product_id=@product_id AND is_deleted=0
		*/
	)
	ORDER BY value_order,name
END
{"code":"EREQUEST","originalError":{"sqlstate":"24000","code":0,"severity":0,"serverName":"","procName":"","lineNumber":0},"name":"RequestError","number":0,"lineNumber":0,"state":"24000","class":0,"serverName":"","procName":""}
unhandledRejection: RequestError: Invalid cursor state