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:16308) [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='EE23D00C-06CD-462D-B6C4-177D5CD40755' AND sync_ver>0
)

SELECT (
    SELECT * FROM src
    WHERE
        sync_ver>1748099163753
        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>1748099163753
        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='EE23D00C-06CD-462D-B6C4-177D5CD40755'
    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":""}
        
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='1624BC08-2C13-4D4D-9104-5CE314021729' AND sync_ver>0
)

SELECT (
    SELECT * FROM src
    WHERE
        sync_ver>1748043928378
        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>1748043928378
        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='1624BC08-2C13-4D4D-9104-5CE314021729'
    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":""}
        
sql query execution error:

            
            DECLARE @owner uniqueidentifier = N'09E74C5B-3429-4ACC-AAC1-7D1152AEB5BF'

            SELECT C.*, ISNULL(CP.prdCount, 0) [prdCount], CP.product_id,
                Media.url AS cover_media_url,
                ISNULL(Media.url, (
                    SELECT TOP 1 url FROM Media WHERE owner = @owner AND is_cover=1 AND is_deleted=0 AND type='product_pic' 
                        AND product_id IN (SELECT product_id FROM CatalogProduct WHERE owner = @owner AND catalog_id = C.uuid)
                    ORDER BY created_at ASC
                )) top_product_image
            FROM Catalog C
            LEFT JOIN Media ON Media.uuid = C.cover_media_id
            LEFT JOIN (
                SELECT colPrd.*,
                    ROW_NUMBER() OVER (PARTITION BY catalog_id ORDER BY colPrd.changed_at DESC) row_num,
                    COUNT(*) OVER (PARTITION BY catalog_id) [prdCount]
                FROM CatalogProduct colPrd
                LEFT JOIN F_Product_Stock_For_Webshop('09E7

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