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

            SELECT DISTINCT prd.brand
            FROM Product prd
            INNER JOIN V_Directory_Path dirPath ON dirPath.directory_id = prd.directory_id
            INNER JOIN F_Product_Stock_For_Webshop(N'5E75303E-3EAD-4611-B9A0-8D7D4935AE4A') prdStock ON prd.uuid = prdStock.product_id
            WHERE prd.is_deleted = 0
                AND prd.active_for_webshop=1
                AND prd.is_archived=0
                AND prd.owner = N'5E75303E-3EAD-4611-B9A0-8D7D4935AE4A'
                AND prd.brand IS NOT NULL
                AND prdStock._stock > 0
                AND dirPath.directory_path like '%/4C835191-7191-4664-8F0B-936E7ED2CF54%'
        
{"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 DISTINCT prd.brand
            FROM Product prd
            INNER JOIN V_Directory_Path dirPath ON dirPath.directory_id = prd.directory_id
            INNER JOIN F_Product_Stock_For_Webshop(N'5E75303E-3EAD-4611-B9A0-8D7D4935AE4A') prdStock ON prd.uuid = prdStock.product_id
            WHERE prd.is_deleted = 0
                AND prd.active_for_webshop=1
                AND prd.is_archived=0
                AND prd.owner = N'5E75303E-3EAD-4611-B9A0-8D7D4935AE4A'
                AND prd.brand IS NOT NULL
                AND prdStock._stock > 0
                AND dirPath.directory_path like '%/07B933F9-FE1F-4B4A-96A5-05502C505148%'
        
{"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