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

            
BEGIN TRY
    EXEC APP_POST_SYNC '6BFBEA6E-031B-4722-8C97-CB7F05D80056', 1748868851819
END TRY
BEGIN CATCH
    PRINT ERROR_MESSAGE()
END CATCH
    

            {"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":""}
        
sql query execution error:

            SELECT TOP 1 * FROM [WorkgroupMember] 
                    WHERE [uuid]=N'9ECE68F4-6A6C-4AE6-BFED-578CA518DC88' AND [workgroup_id]=N'32DE507D-4C0F-4C38-B265-4D619D001D4C'

            {}
        
TimeoutError: operation timed out for an unknown reason
    at C:\inetpub\TX_Kalaban\node_modules\tarn\dist\PendingOperation.js:17:27
    at runNextTicks (node:internal/process/task_queues:60:5)
    at listOnTimeout (node:internal/timers:540:9)
    at process.processTimers (node:internal/timers:514:7)
unhandledRejection: Error: operation timed out for an unknown reason
sql query execution error:

            SELECT TOP 1 * FROM [WorkgroupMember] 
                    WHERE [uuid]=N'2D3788A5-7383-4EE8-ADCB-0EEA61404044' AND [workgroup_id]=N'133481FC-02B6-4C53-A73F-EA3F29671F2B'

            {}
        
TimeoutError: operation timed out for an unknown reason
    at C:\inetpub\TX_Kalaban\node_modules\tarn\dist\PendingOperation.js:17:27
    at runNextTicks (node:internal/process/task_queues:60:5)
    at listOnTimeout (node:internal/timers:540:9)
    at process.processTimers (node:internal/timers:514:7)
unhandledRejection: Error: operation timed out for an unknown reason
sql query execution error:

            SELECT TOP 1 * FROM [Webshop] 
                    WHERE [private_domain]=N'nourashop.ir'

            {"code":"ECONNCLOSED","name":"ConnectionError"}
        
ConnectionError: Connection is closed.
    at Request._query (C:\inetpub\TX_Kalaban\node_modules\mssql\lib\base\request.js:497:37)
    at Request._query (C:\inetpub\TX_Kalaban\node_modules\mssql\lib\msnodesqlv8\request.js:248:11)
    at C:\inetpub\TX_Kalaban\node_modules\mssql\lib\base\request.js:461:12
    at new Promise (<anonymous>)
    at Request.query (C:\inetpub\TX_Kalaban\node_modules\mssql\lib\base\request.js:460:12)
    at ConnectionPool.query (C:\inetpub\TX_Kalaban\node_modules\mssql\lib\base\connection-pool.js:607:84)
    at exports.executeQuery (C:\inetpub\TX_Kalaban\library\dbManager.js:14:27)
    at runNextTicks (node:internal/process/task_queues:60:5)
    at process.processImmediate (node:internal/timers:449:9)
    at async Webshop.selectTop1By (C:\inetpub\TX_Kalaban\components\dao.js:200:32) {
  code: 'ECONNCLOSED'
}
unhandledRejection: ConnectionError: Connection is closed.
sql query execution error:

            SELECT webCart.*,
                prd.title, prd.description, prd.public_id, prd.warehouse_address, prd.brand, prd.is_virtual, prd.weight,
                prd.unit, prd.tag_festival, prd.tag_new, prd.directory_id, prd.is_available_on_webshop, prd.active_for_webshop,
                prdVar.sell_price, prdVar.sell_price2, prdVar.sell_price3, prdVar.discount, prdVar.sku, prdVar.sku_prefix, prdVar.sku_suffix, prdVar.min_purchase_quantity, prdVar.max_purchase_quantity,
                IIF(prd.is_available_on_webshop=0, 0, prdVarStock._stock) AS [stock],
                opt1.name option1_name, opt1.type option1_type, optVal1.name optionValue1_name, optVal1.value_order optionValue1_val,
                opt2.name option2_name, opt2.type option2_type, optVal2.name optionValue2_name, optVal2.value_order optionValue2_val,
                (SELECT TOP 1 url FROM Media WHERE is_cover=1 AND is_deleted=0 AND type='product_pic' AND Media.product_id = prd.uuid) cover_image
            FROM [WebshopCart]

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

            
            DECLARE @owner uniqueidentifier = N'C40A638A-AF93-4F6D-AB81-FF56F5791C12'

            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('C40A

            {"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 webCart.*,
                prd.title, prd.description, prd.public_id, prd.warehouse_address, prd.brand, prd.is_virtual, prd.weight,
                prd.unit, prd.tag_festival, prd.tag_new, prd.directory_id, prd.is_available_on_webshop, prd.active_for_webshop,
                prdVar.sell_price, prdVar.sell_price2, prdVar.sell_price3, prdVar.discount, prdVar.sku, prdVar.sku_prefix, prdVar.sku_suffix, prdVar.min_purchase_quantity, prdVar.max_purchase_quantity,
                IIF(prd.is_available_on_webshop=0, 0, prdVarStock._stock) AS [stock],
                opt1.name option1_name, opt1.type option1_type, optVal1.name optionValue1_name, optVal1.value_order optionValue1_val,
                opt2.name option2_name, opt2.type option2_type, optVal2.name optionValue2_name, optVal2.value_order optionValue2_val,
                (SELECT TOP 1 url FROM Media WHERE is_cover=1 AND is_deleted=0 AND type='product_pic' AND Media.product_id = prd.uuid) cover_image
            FROM [WebshopCart]

            {"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
(node:1844) MaxListenersExceededWarning: Possible EventEmitter memory leak detected. 11 finish listeners added to [DailyRotateFile]. Use emitter.setMaxListeners() to increase limit
(node:1844) MaxListenersExceededWarning: Possible EventEmitter memory leak detected. 11 error listeners added to [DailyRotateFile]. Use emitter.setMaxListeners() to increase limit