2026-04-25 08:16:26 [[31merror[39m]: RequestError: The OLE DB provider "MSDASQL" for linked server "mysql" could not UPDATE table "[mysql].[lamundial]..[fee_receipts]". The rowset was using optimistic concurrency and the value of a column has been changed after the containing row was last fetched or resynchronized.
    at handleError (/var/www/html/backend/SysIP-backend/node_modules/mssql/lib/tedious/request.js:738:15)
    at Connection.emit (node:events:526:28)
    at Connection.emit (/var/www/html/backend/SysIP-backend/node_modules/mssql/node_modules/tedious/lib/connection.js:1040:18)
    at RequestTokenHandler.onErrorMessage (/var/www/html/backend/SysIP-backend/node_modules/mssql/node_modules/tedious/lib/token/handler.js:365:21)
    at Readable.<anonymous> (/var/www/html/backend/SysIP-backend/node_modules/mssql/node_modules/tedious/lib/token/token-stream-parser.js:26:33)
    at Readable.emit (node:events:526:28)
    at addChunk (node:internal/streams/readable:315:12)
    at readableAddChunk (node:internal/streams/readable:289:9)
    at Readable.push (node:internal/streams/readable:228:10)
    at next (node:internal/streams/from:98:31)
{
  "service": "Sys2000",
  "error": "The OLE DB provider \"MSDASQL\" for linked server \"mysql\" could not UPDATE table \"[mysql].[lamundial]..[fee_receipts]\". The rowset was using optimistic concurrency and the value of a column has been changed after the containing row was last fetched or resynchronized.",
  "inputs": {
    "freporte": "2026-04-25T12:32:09.039Z",
    "cmoneda_pago": "BS",
    "ctenedor": 20904284,
    "numRecibos": 4,
    "mpago": 78711.05,
    "mpagoext": 162.67,
    "cprog": "Merito",
    "recibos": "'700053474','700053449','700053424','700053436'",
    "cusuario": 1422,
    "referencia": "000740301729"
  }
}
2026-04-25 08:16:26 [[31merror[39m]: Error: Fallo en operación collect.execute
    at file:///var/www/html/backend/SysIP-backend/src/controllers/collection.js:302:15
    at runMicrotasks (<anonymous>)
    at processTicksAndRejections (node:internal/process/task_queues:96:5)
    at async baseReceiptHandler (file:///var/www/html/backend/SysIP-backend/src/controllers/collection.js:23:20)
{
  "service": "Sys2000",
  "body": {
    "soporte": [
      {
        "cmoneda": "BS",
        "cbanco": 35,
        "cbanco_destino": 35,
        "ctipopago": 3,
        "mpago": 78711.05,
        "mpagoext": 162.66999676565686,
        "mnotificado": 78711.05,
        "mnotificadoext": 162.66999676565686,
        "mpagoigtf": 0,
        "mpagoigtfext": 0,
        "ptasaref": 0,
        "mtotal": 78711.05,
        "mtotalext": 162.67,
        "ptasamon": 483.8695,
        "xreferencia": "000740301729",
        "xruta": "Sin soporte",
        "freporte": "2026-04-25T12:32:09.039Z"
      }
    ],
    "imov": "CO",
    "ctenedor": 20904284,
    "asegurados": [
      "EURISMAR DEL VALLE SALAZAR RODRIGUEZ",
      "HENRY ANTONIO NAREA VASQUEZ"
    ],
    "mpago": 78711.05,
    "mpagoext": 162.67,
    "freporte": "2026-04-25T12:32:09.039Z",
    "cmoneda_pago": "BS",
    "referencia": "000740301729",
    "cprog": "Merito",
    "cusuario": 1422,
    "recibos": [
      "700053474",
      "700053449",
      "700053424",
      "700053436"
    ],
    "numRecibos": 4,
    "fcobro": "2026-04-25T12:32:09.039Z"
  }
}
2026-04-25 10:37:27 [[32minfo[39m]: Saldo de notificaciones
{
  "service": "Sys2000",
  "cusuario": 7,
  "transaccion": 165606,
  "ctenedor": 13287846
}
2026-04-25 11:47:41 [[32minfo[39m]: Saldo de notificaciones
{
  "service": "Sys2000",
  "cusuario": 1422,
  "transaccion": 165608,
  "ctenedor": 30187986
}
2026-04-25 12:10:23 [[31merror[39m]: Error [ERR_HTTP_HEADERS_SENT]: Cannot set headers after they are sent to the client
    at new NodeError (node:internal/errors:371:5)
    at ServerResponse.setHeader (node:_http_outgoing:576:11)
    at ServerResponse.header (/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js:794:10)
    at ServerResponse.send (/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js:174:12)
    at ServerResponse.json (/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js:278:15)
    at ServerResponse.send (/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js:162:21)
    at calculatePlanSis (file:///var/www/html/backend/SysIP-backend/src/controllers/automobile.js:255:10)
    at runMicrotasks (<anonymous>)
    at processTicksAndRejections (node:internal/process/task_queues:96:5)
{
  "error": {
    "code": "ERR_HTTP_HEADERS_SENT"
  },
  "rejection": true,
  "date": "Sat Apr 25 2026 12:10:23 GMT-0400 (Venezuela Time)",
  "process": {
    "pid": 2912553,
    "uid": 0,
    "gid": 0,
    "cwd": "/var/www/html/backend/SysIP-backend",
    "execPath": "/root/.nvm/versions/node/v16.14.2/bin/node",
    "version": "v16.14.2",
    "argv": [
      "/root/.nvm/versions/node/v16.14.2/bin/node",
      "/root/.nvm/versions/node/v16.14.2/lib/node_modules/pm2/lib/ProcessContainerFork.js"
    ],
    "memoryUsage": {
      "rss": 179060736,
      "heapTotal": 88387584,
      "heapUsed": 83819456,
      "external": 9360301,
      "arrayBuffers": 4542006
    }
  },
  "os": {
    "loadavg": [
      0,
      0.03,
      0
    ],
    "uptime": 12530301
  },
  "trace": [
    {
      "column": 5,
      "file": "node:internal/errors",
      "function": "new NodeError",
      "line": 371,
      "method": null,
      "native": false
    },
    {
      "column": 11,
      "file": "node:_http_outgoing",
      "function": "ServerResponse.setHeader",
      "line": 576,
      "method": "setHeader",
      "native": false
    },
    {
      "column": 10,
      "file": "/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js",
      "function": "ServerResponse.header",
      "line": 794,
      "method": "header",
      "native": false
    },
    {
      "column": 12,
      "file": "/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js",
      "function": "ServerResponse.send",
      "line": 174,
      "method": "send",
      "native": false
    },
    {
      "column": 15,
      "file": "/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js",
      "function": "ServerResponse.json",
      "line": 278,
      "method": "json",
      "native": false
    },
    {
      "column": 21,
      "file": "/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js",
      "function": "ServerResponse.send",
      "line": 162,
      "method": "send",
      "native": false
    },
    {
      "column": 10,
      "file": "file:///var/www/html/backend/SysIP-backend/src/controllers/automobile.js",
      "function": "calculatePlanSis",
      "line": 255,
      "method": null,
      "native": false
    },
    {
      "column": null,
      "file": null,
      "function": "runMicrotasks",
      "line": null,
      "method": null,
      "native": false
    },
    {
      "column": 5,
      "file": "node:internal/process/task_queues",
      "function": "processTicksAndRejections",
      "line": 96,
      "method": null,
      "native": false
    }
  ],
  "service": "Sys2000"
}
2026-04-25 14:12:29 [[32minfo[39m]: Saldo de notificaciones
{
  "service": "Sys2000",
  "cusuario": 1422,
  "transaccion": 165617,
  "ctenedor": 4069596
}
2026-04-25 14:30:26 [[31merror[39m]: ConnectionError: Connection is closing
    at ConnectionPool._acquire (/var/www/html/backend/SysIP-backend/node_modules/mssql/lib/base/connection-pool.js:309:36)
    at ConnectionPool.acquire (/var/www/html/backend/SysIP-backend/node_modules/mssql/lib/base/connection-pool.js:293:56)
    at Immediate.<anonymous> (/var/www/html/backend/SysIP-backend/node_modules/mssql/lib/tedious/request.js:419:19)
    at processImmediate (node:internal/timers:466:21)
{
  "error": {
    "code": "ENOTOPEN",
    "name": "ConnectionError"
  },
  "rejection": true,
  "date": "Sat Apr 25 2026 14:30:26 GMT-0400 (Venezuela Time)",
  "process": {
    "pid": 3277947,
    "uid": 0,
    "gid": 0,
    "cwd": "/var/www/html/backend/SysIP-backend",
    "execPath": "/root/.nvm/versions/node/v16.14.2/bin/node",
    "version": "v16.14.2",
    "argv": [
      "/root/.nvm/versions/node/v16.14.2/bin/node",
      "/root/.nvm/versions/node/v16.14.2/lib/node_modules/pm2/lib/ProcessContainerFork.js"
    ],
    "memoryUsage": {
      "rss": 175194112,
      "heapTotal": 93368320,
      "heapUsed": 81102000,
      "external": 9229752,
      "arrayBuffers": 4334634
    }
  },
  "os": {
    "loadavg": [
      0.02,
      0.04,
      0
    ],
    "uptime": 12538703.86
  },
  "trace": [
    {
      "column": 36,
      "file": "/var/www/html/backend/SysIP-backend/node_modules/mssql/lib/base/connection-pool.js",
      "function": "ConnectionPool._acquire",
      "line": 309,
      "method": "_acquire",
      "native": false
    },
    {
      "column": 56,
      "file": "/var/www/html/backend/SysIP-backend/node_modules/mssql/lib/base/connection-pool.js",
      "function": "ConnectionPool.acquire",
      "line": 293,
      "method": "acquire",
      "native": false
    },
    {
      "column": 19,
      "file": "/var/www/html/backend/SysIP-backend/node_modules/mssql/lib/tedious/request.js",
      "function": null,
      "line": 419,
      "method": null,
      "native": false
    },
    {
      "column": 21,
      "file": "node:internal/timers",
      "function": "processImmediate",
      "line": 466,
      "method": null,
      "native": false
    }
  ],
  "service": "Sys2000"
}
2026-04-25 15:05:00 [[32minfo[39m]: Saldo de notificaciones
{
  "service": "Sys2000",
  "cusuario": 1422,
  "transaccion": 165618,
  "ctenedor": 14962521
}
2026-04-25 15:09:06 [[32minfo[39m]: Saldo de notificaciones
{
  "service": "Sys2000",
  "cusuario": 1422,
  "transaccion": 165620,
  "ctenedor": 23195111
}
2026-04-25 16:10:35 [[32minfo[39m]: Saldo de notificaciones
{
  "service": "Sys2000",
  "cusuario": 1422,
  "transaccion": 165625,
  "ctenedor": 19335817
}
2026-04-25 16:14:39 [[32minfo[39m]: Saldo de notificaciones
{
  "service": "Sys2000",
  "cusuario": 1422,
  "transaccion": 165626,
  "ctenedor": 19335817
}
2026-04-25 16:19:27 [[32minfo[39m]: Saldo de notificaciones
{
  "service": "Sys2000",
  "cusuario": 1422,
  "transaccion": 165627,
  "ctenedor": 8767503
}
2026-04-25 16:19:37 [[32minfo[39m]: Saldo de notificaciones
{
  "service": "Sys2000",
  "cusuario": 1422,
  "transaccion": 165628,
  "ctenedor": 8767503
}
2026-04-25 16:24:47 [[32minfo[39m]: Saldo de notificaciones
{
  "service": "Sys2000",
  "cusuario": 1422,
  "transaccion": 165629,
  "ctenedor": 6547677
}
2026-04-25 17:09:38 [[31merror[39m]: Error [ERR_HTTP_HEADERS_SENT]: Cannot set headers after they are sent to the client
    at new NodeError (node:internal/errors:371:5)
    at ServerResponse.setHeader (node:_http_outgoing:576:11)
    at ServerResponse.header (/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js:794:10)
    at ServerResponse.send (/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js:174:12)
    at ServerResponse.json (/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js:278:15)
    at ServerResponse.send (/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js:162:21)
    at calculatePlanSis (file:///var/www/html/backend/SysIP-backend/src/controllers/automobile.js:255:10)
    at runMicrotasks (<anonymous>)
    at processTicksAndRejections (node:internal/process/task_queues:96:5)
{
  "error": {
    "code": "ERR_HTTP_HEADERS_SENT"
  },
  "rejection": true,
  "date": "Sat Apr 25 2026 17:09:38 GMT-0400 (Venezuela Time)",
  "process": {
    "pid": 3336629,
    "uid": 0,
    "gid": 0,
    "cwd": "/var/www/html/backend/SysIP-backend",
    "execPath": "/root/.nvm/versions/node/v16.14.2/bin/node",
    "version": "v16.14.2",
    "argv": [
      "/root/.nvm/versions/node/v16.14.2/bin/node",
      "/root/.nvm/versions/node/v16.14.2/lib/node_modules/pm2/lib/ProcessContainerFork.js"
    ],
    "memoryUsage": {
      "rss": 164663296,
      "heapTotal": 88649728,
      "heapUsed": 81203488,
      "external": 9171024,
      "arrayBuffers": 4352809
    }
  },
  "os": {
    "loadavg": [
      0,
      0.02,
      0.02
    ],
    "uptime": 12548255.35
  },
  "trace": [
    {
      "column": 5,
      "file": "node:internal/errors",
      "function": "new NodeError",
      "line": 371,
      "method": null,
      "native": false
    },
    {
      "column": 11,
      "file": "node:_http_outgoing",
      "function": "ServerResponse.setHeader",
      "line": 576,
      "method": "setHeader",
      "native": false
    },
    {
      "column": 10,
      "file": "/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js",
      "function": "ServerResponse.header",
      "line": 794,
      "method": "header",
      "native": false
    },
    {
      "column": 12,
      "file": "/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js",
      "function": "ServerResponse.send",
      "line": 174,
      "method": "send",
      "native": false
    },
    {
      "column": 15,
      "file": "/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js",
      "function": "ServerResponse.json",
      "line": 278,
      "method": "json",
      "native": false
    },
    {
      "column": 21,
      "file": "/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js",
      "function": "ServerResponse.send",
      "line": 162,
      "method": "send",
      "native": false
    },
    {
      "column": 10,
      "file": "file:///var/www/html/backend/SysIP-backend/src/controllers/automobile.js",
      "function": "calculatePlanSis",
      "line": 255,
      "method": null,
      "native": false
    },
    {
      "column": null,
      "file": null,
      "function": "runMicrotasks",
      "line": null,
      "method": null,
      "native": false
    },
    {
      "column": 5,
      "file": "node:internal/process/task_queues",
      "function": "processTicksAndRejections",
      "line": 96,
      "method": null,
      "native": false
    }
  ],
  "service": "Sys2000"
}
2026-04-25 17:47:43 [[31merror[39m]: TypeError: Cannot read properties of undefined (reading 'cusuario')
    at Object.createJWT (file:///var/www/html/backend/SysIP-backend/src/service/authService.js:97:24)
    at createJWTPHP (file:///var/www/html/backend/SysIP-backend/src/controllers/authController.js:317:32)
    at runMicrotasks (<anonymous>)
    at processTicksAndRejections (node:internal/process/task_queues:96:5)
{
  "error": {},
  "rejection": true,
  "date": "Sat Apr 25 2026 17:47:43 GMT-0400 (Venezuela Time)",
  "process": {
    "pid": 3403518,
    "uid": 0,
    "gid": 0,
    "cwd": "/var/www/html/backend/SysIP-backend",
    "execPath": "/root/.nvm/versions/node/v16.14.2/bin/node",
    "version": "v16.14.2",
    "argv": [
      "/root/.nvm/versions/node/v16.14.2/bin/node",
      "/root/.nvm/versions/node/v16.14.2/lib/node_modules/pm2/lib/ProcessContainerFork.js"
    ],
    "memoryUsage": {
      "rss": 160673792,
      "heapTotal": 86552576,
      "heapUsed": 80625864,
      "external": 10513447,
      "arrayBuffers": 4432537
    }
  },
  "os": {
    "loadavg": [
      0.08,
      0.03,
      0.01
    ],
    "uptime": 12550540.74
  },
  "trace": [
    {
      "column": 24,
      "file": "file:///var/www/html/backend/SysIP-backend/src/service/authService.js",
      "function": "Object.createJWT",
      "line": 97,
      "method": "createJWT",
      "native": false
    },
    {
      "column": 32,
      "file": "file:///var/www/html/backend/SysIP-backend/src/controllers/authController.js",
      "function": "createJWTPHP",
      "line": 317,
      "method": null,
      "native": false
    },
    {
      "column": null,
      "file": null,
      "function": "runMicrotasks",
      "line": null,
      "method": null,
      "native": false
    },
    {
      "column": 5,
      "file": "node:internal/process/task_queues",
      "function": "processTicksAndRejections",
      "line": 96,
      "method": null,
      "native": false
    }
  ],
  "service": "Sys2000"
}
2026-04-25 17:48:03 [[31merror[39m]: TypeError: Cannot read properties of undefined (reading 'cusuario')
    at Object.createJWT (file:///var/www/html/backend/SysIP-backend/src/service/authService.js:97:24)
    at createJWTPHP (file:///var/www/html/backend/SysIP-backend/src/controllers/authController.js:317:32)
    at processTicksAndRejections (node:internal/process/task_queues:96:5)
{
  "error": {},
  "rejection": true,
  "date": "Sat Apr 25 2026 17:48:03 GMT-0400 (Venezuela Time)",
  "process": {
    "pid": 3419485,
    "uid": 0,
    "gid": 0,
    "cwd": "/var/www/html/backend/SysIP-backend",
    "execPath": "/root/.nvm/versions/node/v16.14.2/bin/node",
    "version": "v16.14.2",
    "argv": [
      "/root/.nvm/versions/node/v16.14.2/bin/node",
      "/root/.nvm/versions/node/v16.14.2/lib/node_modules/pm2/lib/ProcessContainerFork.js"
    ],
    "memoryUsage": {
      "rss": 145494016,
      "heapTotal": 79413248,
      "heapUsed": 74163824,
      "external": 8754670,
      "arrayBuffers": 3939527
    }
  },
  "os": {
    "loadavg": [
      0.06,
      0.02,
      0
    ],
    "uptime": 12550560.2
  },
  "trace": [
    {
      "column": 24,
      "file": "file:///var/www/html/backend/SysIP-backend/src/service/authService.js",
      "function": "Object.createJWT",
      "line": 97,
      "method": "createJWT",
      "native": false
    },
    {
      "column": 32,
      "file": "file:///var/www/html/backend/SysIP-backend/src/controllers/authController.js",
      "function": "createJWTPHP",
      "line": 317,
      "method": null,
      "native": false
    },
    {
      "column": 5,
      "file": "node:internal/process/task_queues",
      "function": "processTicksAndRejections",
      "line": 96,
      "method": null,
      "native": false
    }
  ],
  "service": "Sys2000"
}
2026-04-25 18:22:10 [[31merror[39m]: Error [ERR_HTTP_HEADERS_SENT]: Cannot set headers after they are sent to the client
    at new NodeError (node:internal/errors:371:5)
    at ServerResponse.setHeader (node:_http_outgoing:576:11)
    at ServerResponse.header (/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js:794:10)
    at ServerResponse.send (/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js:174:12)
    at ServerResponse.json (/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js:278:15)
    at ServerResponse.send (/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js:162:21)
    at calculatePlanSis (file:///var/www/html/backend/SysIP-backend/src/controllers/automobile.js:255:10)
    at runMicrotasks (<anonymous>)
    at processTicksAndRejections (node:internal/process/task_queues:96:5)
{
  "error": {
    "code": "ERR_HTTP_HEADERS_SENT"
  },
  "rejection": true,
  "date": "Sat Apr 25 2026 18:22:10 GMT-0400 (Venezuela Time)",
  "process": {
    "pid": 3419634,
    "uid": 0,
    "gid": 0,
    "cwd": "/var/www/html/backend/SysIP-backend",
    "execPath": "/root/.nvm/versions/node/v16.14.2/bin/node",
    "version": "v16.14.2",
    "argv": [
      "/root/.nvm/versions/node/v16.14.2/bin/node",
      "/root/.nvm/versions/node/v16.14.2/lib/node_modules/pm2/lib/ProcessContainerFork.js"
    ],
    "memoryUsage": {
      "rss": 155631616,
      "heapTotal": 84455424,
      "heapUsed": 75475312,
      "external": 8901438,
      "arrayBuffers": 4078092
    }
  },
  "os": {
    "loadavg": [
      0.05,
      0.04,
      0
    ],
    "uptime": 12552608.05
  },
  "trace": [
    {
      "column": 5,
      "file": "node:internal/errors",
      "function": "new NodeError",
      "line": 371,
      "method": null,
      "native": false
    },
    {
      "column": 11,
      "file": "node:_http_outgoing",
      "function": "ServerResponse.setHeader",
      "line": 576,
      "method": "setHeader",
      "native": false
    },
    {
      "column": 10,
      "file": "/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js",
      "function": "ServerResponse.header",
      "line": 794,
      "method": "header",
      "native": false
    },
    {
      "column": 12,
      "file": "/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js",
      "function": "ServerResponse.send",
      "line": 174,
      "method": "send",
      "native": false
    },
    {
      "column": 15,
      "file": "/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js",
      "function": "ServerResponse.json",
      "line": 278,
      "method": "json",
      "native": false
    },
    {
      "column": 21,
      "file": "/var/www/html/backend/SysIP-backend/node_modules/express/lib/response.js",
      "function": "ServerResponse.send",
      "line": 162,
      "method": "send",
      "native": false
    },
    {
      "column": 10,
      "file": "file:///var/www/html/backend/SysIP-backend/src/controllers/automobile.js",
      "function": "calculatePlanSis",
      "line": 255,
      "method": null,
      "native": false
    },
    {
      "column": null,
      "file": null,
      "function": "runMicrotasks",
      "line": null,
      "method": null,
      "native": false
    },
    {
      "column": 5,
      "file": "node:internal/process/task_queues",
      "function": "processTicksAndRejections",
      "line": 96,
      "method": null,
      "native": false
    }
  ],
  "service": "Sys2000"
}
2026-04-25 19:11:10 [[32minfo[39m]: Saldo de notificaciones
{
  "service": "Sys2000",
  "cusuario": 7,
  "transaccion": 165638,
  "ctenedor": 502663061
}
2026-04-25 23:29:00 [[32minfo[39m]: Saldo de notificaciones
{
  "service": "Sys2000",
  "cusuario": 1422,
  "transaccion": 165644,
  "ctenedor": 8378812
}
