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:2196) [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 options_use_count AS (
                SELECT top 5
                    opt.uuid option_id
                    , COUNT(*) _count
                FROM Product prd
                INNER JOIN V_Directory_Path dirPath ON dirPath.directory_id = prd.directory_id
                INNER JOIN ProductVariation pv ON pv.product_id = prd.uuid
                INNER JOIN Options opt ON opt.uuid = pv.option1_id OR opt.uuid = pv.option2_id
                WHERE prd.owner = N'B5CC5A66-D7F0-4AA3-9AB7-989E0B59CFDF'
                    AND prd.is_deleted = 0
                    AND prd.active_for_webshop = 1
                    AND prd.is_archived = 0
                    AND prd.is_advanced_product = 1
                    AND pv.is_deleted = 0
                    AND dirPath.directory_path like '%/F1303009-BB94-489E-9717-93C6137D9813%'
                GROUP BY opt.uuid
                ORDER BY _count DESC
            )
            SELECT
                opt.uuid option_id
                , opt.name option_name
                , opt.display_name option_display_name
                , opt.type option_type
                , options_use_count._count option_use_count
                , ov.uuid optionvalue_id
                , ov.name optionvalue_name
                , ov.value_order optionvalue_order
            FROM Product prd
            INNER JOIN V_Directory_Path dirPath ON dirPath.directory_id = prd.directory_id
            INNER JOIN ProductVariation pv ON pv.product_id = prd.uuid
            --INNER JOIN V_ProductVariation_Stock_For_Webshop stock ON stock.product_variation_id = pv.uuid
            INNER JOIN Options opt ON opt.uuid = pv.option1_id OR opt.uuid = pv.option2_id
            INNER JOIN OptionValues ov ON (opt.uuid = ov.option_id) AND (ov.uuid = pv.option_value1_id OR ov.uuid = pv.option_value2_id)
            INNER JOIN options_use_count ON options_use_count.option_id = opt.uuid
            WHERE prd.owner = N'B5CC5A66-D7F0-4AA3-9AB7-989E0B59CFDF'
                AND prd.is_deleted = 0
                AND prd.active_for_webshop = 1
                AND prd.is_archived = 0
                AND pv.is_deleted = 0
                --AND stock._stock > 0
                AND dirPath.directory_path like '%/F1303009-BB94-489E-9717-93C6137D9813%'
            GROUP BY opt.uuid, opt.name, opt.display_name, opt.type, ov.uuid, ov.name, ov.value_order, options_use_count._count
            ORDER BY option_use_count DESC, opt.uuid, optionvalue_order ASC, optionvalue_name ASC
        
{"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