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:12472) [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 @trg TABLE (uuid uniqueidentifier);

WITH src AS (
    SELECT [uuid], [name], [parent_directory], [created_at], [tags], [media_id], [changed_at], [sync_ver], [is_deleted] FROM [directory] AS src
    WHERE owner='33A536FF-691F-450F-9E3D-148D0048FFD0' AND sync_ver>0
)

SELECT (
    SELECT * FROM src
    WHERE
        sync_ver>1748070827661
        AND is_deleted = 0
        AND NOT EXISTS (SELECT uuid FROM @trg AS trg WHERE src.uuid=trg.uuid)
    FOR JSON AUTO, INCLUDE_NULL_VALUES)
AS [new_to_client]
,
(SELECT (
    SELECT uuid FROM src
    WHERE
        sync_ver>1748070827661
        AND is_deleted = 1
    FOR JSON AUTO, INCLUDE_NULL_VALUES)
) AS [deleted]
,
(SELECT IIF(OBJECT_ID('tempdb..##MissingPKs') IS NULL, NULL, (
    SELECT [column], [value] FROM ##MissingPKs
    WHERE [table]='directory' AND owner='33A536FF-691F-450F-9E3D-148D0048FFD0'
    FOR JSON AUTO, INCLUDE_NULL_VALUES)
)) AS [missing_pks_in_server]
,
(SELECT
    LOWER(CONVERT(VARCHAR(32),HASHBYTES('MD5', LOWER((
 

            {"code":"EREQUEST","originalError":{"sqlstate":"42S02","code":208,"severity":16,"serverName":"SERVER-WIN","procName":"","lineNumber":4},"name":"RequestError","number":208,"lineNumber":4,"state":"42S02","class":16,"serverName":"SERVER-WIN","procName":""}
        
failed to udpate any row of <Media>
sql query execution error:

            
DECLARE @trg TABLE (uuid uniqueidentifier);

WITH src AS (
    SELECT [uuid], [image_quality], [currency], [calendar], [update_buy_price_method], [update_sell_price_method], [default_tax_rate], [inventory_method], [sell_price_method], [sell_price_percent], [fiscal_year_shamsi], [sku_prefix], [sku_length], [order_auto_confirm], [print_settings], [logo1_media_id], [stamp1_media_id], [sign1_media_id], [logo2_media_id], [stamp2_media_id], [sign2_media_id], [invoice_numbering], [extra_services], [ordering_show_stock], [sms_templates], [changed_at], [sync_ver], [is_deleted] FROM [workgroupsetting] AS src
    WHERE owner='1AD3F778-1CF2-4DC7-B23C-9B4B33DC56A1' AND sync_ver>0
)

SELECT (
    SELECT * FROM src
    WHERE
        sync_ver>1748072783017
        AND is_deleted = 0
        AND NOT EXISTS (SELECT uuid FROM @trg AS trg WHERE src.uuid=trg.uuid)
    FOR JSON AUTO, INCLUDE_NULL_VALUES)
AS [new_to_client]
,
(SELECT (
    SELECT uuid FROM src
    WHERE
        sync_ver>1748072783017
      

            {"code":"EREQUEST","originalError":{"sqlstate":"42S02","code":208,"severity":16,"serverName":"SERVER-WIN","procName":"","lineNumber":4},"name":"RequestError","number":208,"lineNumber":4,"state":"42S02","class":16,"serverName":"SERVER-WIN","procName":""}
        
failed to udpate any row of <Media>
failed to udpate any row of <WebshopCart>
failed to udpate any row of <WebshopCart>
failed to udpate any row of <Media>
failed to udpate any row of <Media>
failed to udpate any row of <Media>
failed to udpate any row of <Media>
failed to udpate any row of <Media>
failed to udpate any row of <Media>
failed to udpate any row of <Media>
sql query execution error:

            
DECLARE @product_id uniqueidentifier = NULL
SELECT TOP 1 @product_id=uuid
FROM [Product] prd
JOIN F_Product_Stock_For_Webshop(N'5541DDC9-434F-45E0-AD19-E279ED1B5B16') ps ON ps.product_id = prd.uuid
WHERE public_id=N'529R4M9B'
    AND prd.owner=N'5541DDC9-434F-45E0-AD19-E279ED1B5B16'
    AND prd.is_archived=0
    AND prd.is_deleted=0
	AND prd.active_for_webshop=1
    AND prd.is_available_on_webshop=1 AND ps._stock > 0


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_quant

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