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:3976) [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)
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 <WebshopCart>
failed to udpate any row of <Media>
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='3FDE9907-12BF-473D-8CB3-2A749A478E4F' AND sync_ver>0
)

SELECT (
    SELECT * FROM src
    WHERE
        sync_ver>1745650193919
        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>1745650193919
        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='3FDE9907-12BF-473D-8CB3-2A749A478E4F'
    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>
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:

            
BEGIN TRY
    EXEC APP_POST_SYNC '273572B2-062D-4F39-8593-872A2B4E48C2', 1745666088495
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:

            
BEGIN TRY
    INSERT INTO log (uuid, [category], [description], [param1], [param2], [workgroup_member_id], [created_at], changed_at, sync_ver, owner) VALUES  ('AD71E5FB-3399-4BD0-8C35-1CE090C57967', N'Order/update_status', N'وضعیت سفارش شماره A153 توسط پریا زارعی  به پیش فاکتور تغییر کرد', N'06ffb87c-33a3-4f30-85ae-7b847a734560', NULL, N'88821232-3081-4021-88ce-2c5f22337aff', 1745666451954, 1745666451956, 1745666460056, 'F4E837E9-DC5E-46B7-8B69-BB506E84638C')
END TRY
BEGIN CATCH
    DECLARE @error_message_0 varchar(max) = ERROR_MESSAGE()
    EXEC APP_INSERT_MISSING_PKS_BY_ERROR_MESSAGE @error_message_0, N'{"uuid":"AD71E5FB-3399-4BD0-8C35-1CE090C57967","workgroup_member_id":"88821232-3081-4021-88ce-2c5f22337aff","description":"وضعیت سفارش شماره A153 توسط پریا زارعی  به پیش فاکتور تغییر کرد","category":"Order/update_status","param1":"06ffb87c-33a3-4f30-85ae-7b847a734560","param2":null,"created_at":1745666451954,"changed_at":1745666451956,"sync_ver":1745666460056,"is_deleted":0}', 'F4E83

            {"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":""}
        
cannot insert bulk RequestError: Query timeout expired
    at handleError (C:\inetpub\TX_Kalaban\node_modules\mssql\lib\msnodesqlv8\request.js:276:21)
    at StreamEvents.emit (node:events:514:28)
    at C:\inetpub\TX_Kalaban\node_modules\msnodesqlv8\lib\reader.js:83:20
    at Array.forEach (<anonymous>)
    at Query.routeStatementError (C:\inetpub\TX_Kalaban\node_modules\msnodesqlv8\lib\reader.js:73:19)
    at C:\inetpub\TX_Kalaban\node_modules\msnodesqlv8\lib\reader.js:239:12
    at C:\inetpub\TX_Kalaban\node_modules\msnodesqlv8\lib\driver.js:191:13
    at Immediate.<anonymous> (C:\inetpub\TX_Kalaban\node_modules\msnodesqlv8\lib\driver.js:167:9)
    at process.processImmediate (node:internal/timers:478:21) {
  code: 'EREQUEST',
  originalError: [Error: [Microsoft][SQL Server Native Client 11.0]Query timeout expired] {
    sqlstate: 'HYT00',
    code: 0,
    severity: 0,
    serverName: '',
    procName: '',
    lineNumber: 0
  },
  number: 0,
  lineNumber: 0,
  state: 'HYT00',
  class: 0,
  serverName: '',
  procName: ''
}
sql query execution error:

            SELECT TOP 1 * FROM [Webshop] 
                    WHERE [private_domain]=N'jelini.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 TOP 1 * FROM [Webshop] 
                    WHERE [private_domain]=N'eyt-car.com'

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

            
BEGIN TRY
    INSERT INTO log (uuid, [category], [description], [param1], [param2], [workgroup_member_id], [created_at], changed_at, sync_ver, owner) VALUES  ('B76C50E6-7371-40FF-B135-942FA8C52907', N'Order/edit', N'سفارش شماره A6245 توسط [989132008401] ویرایش شد', N'c66b3a1c-2a08-48c5-8a43-df0161066a57', NULL, N'9C9AB4D2-4F2E-4AE0-A09E-085EF0245266', 1745666454640, 1745666454655, 1745666462888, '5902B937-1003-4AD3-92B8-23D3F84F9B71')
END TRY
BEGIN CATCH
    DECLARE @error_message_0 varchar(max) = ERROR_MESSAGE()
    EXEC APP_INSERT_MISSING_PKS_BY_ERROR_MESSAGE @error_message_0, N'{"uuid":"B76C50E6-7371-40FF-B135-942FA8C52907","workgroup_member_id":"9C9AB4D2-4F2E-4AE0-A09E-085EF0245266","description":"سفارش شماره A6245 توسط [989132008401] ویرایش شد","category":"Order/edit","param1":"c66b3a1c-2a08-48c5-8a43-df0161066a57","param2":null,"created_at":1745666454640,"changed_at":1745666454655,"sync_ver":1745666462888,"is_deleted":0}', '5902B937-1003-4AD3-92B8-23D3F84F9B71'
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":""}
        
cannot insert bulk RequestError: Query timeout expired
    at handleError (C:\inetpub\TX_Kalaban\node_modules\mssql\lib\msnodesqlv8\request.js:276:21)
    at StreamEvents.emit (node:events:514:28)
    at C:\inetpub\TX_Kalaban\node_modules\msnodesqlv8\lib\reader.js:83:20
    at Array.forEach (<anonymous>)
    at Query.routeStatementError (C:\inetpub\TX_Kalaban\node_modules\msnodesqlv8\lib\reader.js:73:19)
    at C:\inetpub\TX_Kalaban\node_modules\msnodesqlv8\lib\reader.js:239:12
    at C:\inetpub\TX_Kalaban\node_modules\msnodesqlv8\lib\driver.js:191:13
    at Immediate.<anonymous> (C:\inetpub\TX_Kalaban\node_modules\msnodesqlv8\lib\driver.js:167:9)
    at process.processImmediate (node:internal/timers:478:21) {
  code: 'EREQUEST',
  originalError: [Error: [Microsoft][SQL Server Native Client 11.0]Query timeout expired] {
    sqlstate: 'HYT00',
    code: 0,
    severity: 0,
    serverName: '',
    procName: '',
    lineNumber: 0
  },
  number: 0,
  lineNumber: 0,
  state: 'HYT00',
  class: 0,
  serverName: '',
  procName: ''
}