{
  "errorId": "ERR_1769517064267_skfccbgb7",
  "timestamp": "2026-01-27T12:31:04.267Z",
  "message": "Table 'finance.shiftsessions' doesn't exist",
  "stack": "Error\n    at Query.run (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n    at E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n    at async MySQLQueryInterface.select (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n    at async ShiftSession.findAll (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n    at async autoCloseExpiredSessions (E:\\my_2025_pro\\alkhlodfinance\\backend\\services\\shiftAutoCloseService.js:145:26)",
  "name": "SequelizeDatabaseError",
  "sql": "SELECT `ShiftSession`.`id`, `ShiftSession`.`shiftId`, `ShiftSession`.`branchId`, `ShiftSession`.`userId`, `ShiftSession`.`sessionDate`, `ShiftSession`.`startTime`, `ShiftSession`.`endTime`, `ShiftSession`.`expectedStartTime`, `ShiftSession`.`expectedEndTime`, `ShiftSession`.`openingBalance`, `ShiftSession`.`closingBalance`, `ShiftSession`.`expectedClosingBalance`, `ShiftSession`.`cashDifference`, `ShiftSession`.`totalSales`, `ShiftSession`.`totalCash`, `ShiftSession`.`totalCard`, `ShiftSession`.`totalWallet`, `ShiftSession`.`totalTransfer`, `ShiftSession`.`totalDiscount`, `ShiftSession`.`totalTax`, `ShiftSession`.`transactionsCount`, `ShiftSession`.`status`, `ShiftSession`.`closedBy`, `ShiftSession`.`notes`, `ShiftSession`.`closingNotes`, `ShiftSession`.`reportData`, `ShiftSession`.`createdAt`, `ShiftSession`.`updatedAt`, `shift`.`id` AS `shift.id`, `shift`.`shiftName` AS `shift.shiftName`, `shift`.`startTime` AS `shift.startTime`, `shift`.`endTime` AS `shift.endTime` FROM `ShiftSessions` AS `ShiftSession` LEFT OUTER JOIN `Shifts` AS `shift` ON `ShiftSession`.`shiftId` = `shift`.`id` WHERE `ShiftSession`.`status` = 'open' AND `ShiftSession`.`sessionDate` = '2026-01-27';",
  "parameters": {},
  "context": {
    "service": "shiftAutoCloseService"
  },
  "additionalInfo": {},
  "systemInfo": {
    "nodeVersion": "v22.13.1",
    "platform": "win32",
    "arch": "x64",
    "memoryUsage": {
      "rss": 152178688,
      "heapTotal": 105164800,
      "heapUsed": 35332464,
      "external": 2347890,
      "arrayBuffers": 49186
    },
    "uptime": 2.9066759
  }
}
----------------------------------------------------------------------------------------------------
{
  "errorId": "ERR_1769517120067_z99kcewkj",
  "timestamp": "2026-01-27T12:32:00.067Z",
  "message": "Table 'finance.shiftsessions' doesn't exist",
  "stack": "Error\n    at Query.run (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n    at E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n    at async MySQLQueryInterface.select (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n    at async ShiftSession.findAll (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n    at async autoCloseExpiredSessions (E:\\my_2025_pro\\alkhlodfinance\\backend\\services\\shiftAutoCloseService.js:145:26)\n    at async cron.schedule.scheduled (E:\\my_2025_pro\\alkhlodfinance\\backend\\services\\shiftAutoCloseService.js:231:5)\n    at async Timeout._onTimeout (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\node-cron\\dist\\cjs\\scheduler\\runner.js:70:44)",
  "name": "SequelizeDatabaseError",
  "sql": "SELECT `ShiftSession`.`id`, `ShiftSession`.`shiftId`, `ShiftSession`.`branchId`, `ShiftSession`.`userId`, `ShiftSession`.`sessionDate`, `ShiftSession`.`startTime`, `ShiftSession`.`endTime`, `ShiftSession`.`expectedStartTime`, `ShiftSession`.`expectedEndTime`, `ShiftSession`.`openingBalance`, `ShiftSession`.`closingBalance`, `ShiftSession`.`expectedClosingBalance`, `ShiftSession`.`cashDifference`, `ShiftSession`.`totalSales`, `ShiftSession`.`totalCash`, `ShiftSession`.`totalCard`, `ShiftSession`.`totalWallet`, `ShiftSession`.`totalTransfer`, `ShiftSession`.`totalDiscount`, `ShiftSession`.`totalTax`, `ShiftSession`.`transactionsCount`, `ShiftSession`.`status`, `ShiftSession`.`closedBy`, `ShiftSession`.`notes`, `ShiftSession`.`closingNotes`, `ShiftSession`.`reportData`, `ShiftSession`.`createdAt`, `ShiftSession`.`updatedAt`, `shift`.`id` AS `shift.id`, `shift`.`shiftName` AS `shift.shiftName`, `shift`.`startTime` AS `shift.startTime`, `shift`.`endTime` AS `shift.endTime` FROM `ShiftSessions` AS `ShiftSession` LEFT OUTER JOIN `Shifts` AS `shift` ON `ShiftSession`.`shiftId` = `shift`.`id` WHERE `ShiftSession`.`status` = 'open' AND `ShiftSession`.`sessionDate` = '2026-01-27';",
  "parameters": {},
  "context": {
    "service": "shiftAutoCloseService"
  },
  "additionalInfo": {},
  "systemInfo": {
    "nodeVersion": "v22.13.1",
    "platform": "win32",
    "arch": "x64",
    "memoryUsage": {
      "rss": 87298048,
      "heapTotal": 36220928,
      "heapUsed": 33275248,
      "external": 2343553,
      "arrayBuffers": 25678
    },
    "uptime": 58.706325
  }
}
----------------------------------------------------------------------------------------------------
{
  "errorId": "ERR_1769517180073_u88epp53b",
  "timestamp": "2026-01-27T12:33:00.073Z",
  "message": "Table 'finance.shiftsessions' doesn't exist",
  "stack": "Error\n    at Query.run (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n    at E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n    at async MySQLQueryInterface.select (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n    at async ShiftSession.findAll (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n    at async autoCloseExpiredSessions (E:\\my_2025_pro\\alkhlodfinance\\backend\\services\\shiftAutoCloseService.js:145:26)\n    at async cron.schedule.scheduled (E:\\my_2025_pro\\alkhlodfinance\\backend\\services\\shiftAutoCloseService.js:231:5)\n    at async Timeout._onTimeout (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\node-cron\\dist\\cjs\\scheduler\\runner.js:70:44)",
  "name": "SequelizeDatabaseError",
  "sql": "SELECT `ShiftSession`.`id`, `ShiftSession`.`shiftId`, `ShiftSession`.`branchId`, `ShiftSession`.`userId`, `ShiftSession`.`sessionDate`, `ShiftSession`.`startTime`, `ShiftSession`.`endTime`, `ShiftSession`.`expectedStartTime`, `ShiftSession`.`expectedEndTime`, `ShiftSession`.`openingBalance`, `ShiftSession`.`closingBalance`, `ShiftSession`.`expectedClosingBalance`, `ShiftSession`.`cashDifference`, `ShiftSession`.`totalSales`, `ShiftSession`.`totalCash`, `ShiftSession`.`totalCard`, `ShiftSession`.`totalWallet`, `ShiftSession`.`totalTransfer`, `ShiftSession`.`totalDiscount`, `ShiftSession`.`totalTax`, `ShiftSession`.`transactionsCount`, `ShiftSession`.`status`, `ShiftSession`.`closedBy`, `ShiftSession`.`notes`, `ShiftSession`.`closingNotes`, `ShiftSession`.`reportData`, `ShiftSession`.`createdAt`, `ShiftSession`.`updatedAt`, `shift`.`id` AS `shift.id`, `shift`.`shiftName` AS `shift.shiftName`, `shift`.`startTime` AS `shift.startTime`, `shift`.`endTime` AS `shift.endTime` FROM `ShiftSessions` AS `ShiftSession` LEFT OUTER JOIN `Shifts` AS `shift` ON `ShiftSession`.`shiftId` = `shift`.`id` WHERE `ShiftSession`.`status` = 'open' AND `ShiftSession`.`sessionDate` = '2026-01-27';",
  "parameters": {},
  "context": {
    "service": "shiftAutoCloseService"
  },
  "additionalInfo": {},
  "systemInfo": {
    "nodeVersion": "v22.13.1",
    "platform": "win32",
    "arch": "x64",
    "memoryUsage": {
      "rss": 87953408,
      "heapTotal": 36745216,
      "heapUsed": 34085136,
      "external": 2351870,
      "arrayBuffers": 33995
    },
    "uptime": 118.711786
  }
}
----------------------------------------------------------------------------------------------------
{
  "errorId": "ERR_1769517240046_l2xqj23w1",
  "timestamp": "2026-01-27T12:34:00.046Z",
  "message": "Table 'finance.shiftsessions' doesn't exist",
  "stack": "Error\n    at Query.run (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n    at E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n    at async MySQLQueryInterface.select (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n    at async ShiftSession.findAll (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n    at async autoCloseExpiredSessions (E:\\my_2025_pro\\alkhlodfinance\\backend\\services\\shiftAutoCloseService.js:145:26)\n    at async cron.schedule.scheduled (E:\\my_2025_pro\\alkhlodfinance\\backend\\services\\shiftAutoCloseService.js:231:5)\n    at async Timeout._onTimeout (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\node-cron\\dist\\cjs\\scheduler\\runner.js:70:44)",
  "name": "SequelizeDatabaseError",
  "sql": "SELECT `ShiftSession`.`id`, `ShiftSession`.`shiftId`, `ShiftSession`.`branchId`, `ShiftSession`.`userId`, `ShiftSession`.`sessionDate`, `ShiftSession`.`startTime`, `ShiftSession`.`endTime`, `ShiftSession`.`expectedStartTime`, `ShiftSession`.`expectedEndTime`, `ShiftSession`.`openingBalance`, `ShiftSession`.`closingBalance`, `ShiftSession`.`expectedClosingBalance`, `ShiftSession`.`cashDifference`, `ShiftSession`.`totalSales`, `ShiftSession`.`totalCash`, `ShiftSession`.`totalCard`, `ShiftSession`.`totalWallet`, `ShiftSession`.`totalTransfer`, `ShiftSession`.`totalDiscount`, `ShiftSession`.`totalTax`, `ShiftSession`.`transactionsCount`, `ShiftSession`.`status`, `ShiftSession`.`closedBy`, `ShiftSession`.`notes`, `ShiftSession`.`closingNotes`, `ShiftSession`.`reportData`, `ShiftSession`.`createdAt`, `ShiftSession`.`updatedAt`, `shift`.`id` AS `shift.id`, `shift`.`shiftName` AS `shift.shiftName`, `shift`.`startTime` AS `shift.startTime`, `shift`.`endTime` AS `shift.endTime` FROM `ShiftSessions` AS `ShiftSession` LEFT OUTER JOIN `Shifts` AS `shift` ON `ShiftSession`.`shiftId` = `shift`.`id` WHERE `ShiftSession`.`status` = 'open' AND `ShiftSession`.`sessionDate` = '2026-01-27';",
  "parameters": {},
  "context": {
    "service": "shiftAutoCloseService"
  },
  "additionalInfo": {},
  "systemInfo": {
    "nodeVersion": "v22.13.1",
    "platform": "win32",
    "arch": "x64",
    "memoryUsage": {
      "rss": 94167040,
      "heapTotal": 41725952,
      "heapUsed": 38774648,
      "external": 2379507,
      "arrayBuffers": 61632
    },
    "uptime": 178.6849261
  }
}
----------------------------------------------------------------------------------------------------
{
  "errorId": "ERR_1769517257239_nefqagbvl",
  "timestamp": "2026-01-27T12:34:17.239Z",
  "message": "Table 'finance.shiftsessions' doesn't exist",
  "stack": "Error\n    at Query.run (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n    at E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n    at async MySQLQueryInterface.select (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n    at async ShiftSession.findAll (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n    at async autoCloseExpiredSessions (E:\\my_2025_pro\\alkhlodfinance\\backend\\services\\shiftAutoCloseService.js:145:26)",
  "name": "SequelizeDatabaseError",
  "sql": "SELECT `ShiftSession`.`id`, `ShiftSession`.`shiftId`, `ShiftSession`.`branchId`, `ShiftSession`.`userId`, `ShiftSession`.`sessionDate`, `ShiftSession`.`startTime`, `ShiftSession`.`endTime`, `ShiftSession`.`expectedStartTime`, `ShiftSession`.`expectedEndTime`, `ShiftSession`.`openingBalance`, `ShiftSession`.`closingBalance`, `ShiftSession`.`expectedClosingBalance`, `ShiftSession`.`cashDifference`, `ShiftSession`.`totalSales`, `ShiftSession`.`totalCash`, `ShiftSession`.`totalCard`, `ShiftSession`.`totalWallet`, `ShiftSession`.`totalTransfer`, `ShiftSession`.`totalDiscount`, `ShiftSession`.`totalTax`, `ShiftSession`.`transactionsCount`, `ShiftSession`.`status`, `ShiftSession`.`closedBy`, `ShiftSession`.`notes`, `ShiftSession`.`closingNotes`, `ShiftSession`.`reportData`, `ShiftSession`.`createdAt`, `ShiftSession`.`updatedAt`, `shift`.`id` AS `shift.id`, `shift`.`shiftName` AS `shift.shiftName`, `shift`.`startTime` AS `shift.startTime`, `shift`.`endTime` AS `shift.endTime` FROM `ShiftSessions` AS `ShiftSession` LEFT OUTER JOIN `Shifts` AS `shift` ON `ShiftSession`.`shiftId` = `shift`.`id` WHERE `ShiftSession`.`status` = 'open' AND `ShiftSession`.`sessionDate` = '2026-01-27';",
  "parameters": {},
  "context": {
    "service": "shiftAutoCloseService"
  },
  "additionalInfo": {},
  "systemInfo": {
    "nodeVersion": "v22.13.1",
    "platform": "win32",
    "arch": "x64",
    "memoryUsage": {
      "rss": 151609344,
      "heapTotal": 104902656,
      "heapUsed": 35388096,
      "external": 2347890,
      "arrayBuffers": 49186
    },
    "uptime": 2.8913905
  }
}
----------------------------------------------------------------------------------------------------
{
  "errorId": "ERR_1769517260089_fs4yxeohs",
  "timestamp": "2026-01-27T12:34:20.089Z",
  "message": "Table 'finance.shiftsessions' doesn't exist",
  "stack": "Error\n    at Query.run (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n    at E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n    at async MySQLQueryInterface.select (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n    at async ShiftSession.findAll (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n    at async autoCloseExpiredSessions (E:\\my_2025_pro\\alkhlodfinance\\backend\\services\\shiftAutoCloseService.js:145:26)",
  "name": "SequelizeDatabaseError",
  "sql": "SELECT `ShiftSession`.`id`, `ShiftSession`.`shiftId`, `ShiftSession`.`branchId`, `ShiftSession`.`userId`, `ShiftSession`.`sessionDate`, `ShiftSession`.`startTime`, `ShiftSession`.`endTime`, `ShiftSession`.`expectedStartTime`, `ShiftSession`.`expectedEndTime`, `ShiftSession`.`openingBalance`, `ShiftSession`.`closingBalance`, `ShiftSession`.`expectedClosingBalance`, `ShiftSession`.`cashDifference`, `ShiftSession`.`totalSales`, `ShiftSession`.`totalCash`, `ShiftSession`.`totalCard`, `ShiftSession`.`totalWallet`, `ShiftSession`.`totalTransfer`, `ShiftSession`.`totalDiscount`, `ShiftSession`.`totalTax`, `ShiftSession`.`transactionsCount`, `ShiftSession`.`status`, `ShiftSession`.`closedBy`, `ShiftSession`.`notes`, `ShiftSession`.`closingNotes`, `ShiftSession`.`reportData`, `ShiftSession`.`createdAt`, `ShiftSession`.`updatedAt`, `shift`.`id` AS `shift.id`, `shift`.`shiftName` AS `shift.shiftName`, `shift`.`startTime` AS `shift.startTime`, `shift`.`endTime` AS `shift.endTime` FROM `ShiftSessions` AS `ShiftSession` LEFT OUTER JOIN `Shifts` AS `shift` ON `ShiftSession`.`shiftId` = `shift`.`id` WHERE `ShiftSession`.`status` = 'open' AND `ShiftSession`.`sessionDate` = '2026-01-27';",
  "parameters": {},
  "context": {
    "service": "shiftAutoCloseService"
  },
  "additionalInfo": {},
  "systemInfo": {
    "nodeVersion": "v22.13.1",
    "platform": "win32",
    "arch": "x64",
    "memoryUsage": {
      "rss": 152363008,
      "heapTotal": 104640512,
      "heapUsed": 35462912,
      "external": 2348161,
      "arrayBuffers": 49457
    },
    "uptime": 2.4696455
  }
}
----------------------------------------------------------------------------------------------------
{
  "errorId": "ERR_1769517300054_mj5ecvs6y",
  "timestamp": "2026-01-27T12:35:00.054Z",
  "message": "Table 'finance.shiftsessions' doesn't exist",
  "stack": "Error\n    at Query.run (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n    at E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n    at async MySQLQueryInterface.select (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n    at async ShiftSession.findAll (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n    at async autoCloseExpiredSessions (E:\\my_2025_pro\\alkhlodfinance\\backend\\services\\shiftAutoCloseService.js:145:26)\n    at async cron.schedule.scheduled (E:\\my_2025_pro\\alkhlodfinance\\backend\\services\\shiftAutoCloseService.js:231:5)\n    at async Timeout._onTimeout (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\node-cron\\dist\\cjs\\scheduler\\runner.js:70:44)",
  "name": "SequelizeDatabaseError",
  "sql": "SELECT `ShiftSession`.`id`, `ShiftSession`.`shiftId`, `ShiftSession`.`branchId`, `ShiftSession`.`userId`, `ShiftSession`.`sessionDate`, `ShiftSession`.`startTime`, `ShiftSession`.`endTime`, `ShiftSession`.`expectedStartTime`, `ShiftSession`.`expectedEndTime`, `ShiftSession`.`openingBalance`, `ShiftSession`.`closingBalance`, `ShiftSession`.`expectedClosingBalance`, `ShiftSession`.`cashDifference`, `ShiftSession`.`totalSales`, `ShiftSession`.`totalCash`, `ShiftSession`.`totalCard`, `ShiftSession`.`totalWallet`, `ShiftSession`.`totalTransfer`, `ShiftSession`.`totalDiscount`, `ShiftSession`.`totalTax`, `ShiftSession`.`transactionsCount`, `ShiftSession`.`status`, `ShiftSession`.`closedBy`, `ShiftSession`.`notes`, `ShiftSession`.`closingNotes`, `ShiftSession`.`reportData`, `ShiftSession`.`createdAt`, `ShiftSession`.`updatedAt`, `shift`.`id` AS `shift.id`, `shift`.`shiftName` AS `shift.shiftName`, `shift`.`startTime` AS `shift.startTime`, `shift`.`endTime` AS `shift.endTime` FROM `ShiftSessions` AS `ShiftSession` LEFT OUTER JOIN `Shifts` AS `shift` ON `ShiftSession`.`shiftId` = `shift`.`id` WHERE `ShiftSession`.`status` = 'open' AND `ShiftSession`.`sessionDate` = '2026-01-27';",
  "parameters": {},
  "context": {
    "service": "shiftAutoCloseService"
  },
  "additionalInfo": {},
  "systemInfo": {
    "nodeVersion": "v22.13.1",
    "platform": "win32",
    "arch": "x64",
    "memoryUsage": {
      "rss": 89571328,
      "heapTotal": 38318080,
      "heapUsed": 34581264,
      "external": 2343836,
      "arrayBuffers": 25961
    },
    "uptime": 42.4348623
  }
}
----------------------------------------------------------------------------------------------------
{
  "errorId": "ERR_1769517360062_6yt70d46g",
  "timestamp": "2026-01-27T12:36:00.062Z",
  "message": "Table 'finance.shiftsessions' doesn't exist",
  "stack": "Error\n    at Query.run (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n    at E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n    at async MySQLQueryInterface.select (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n    at async ShiftSession.findAll (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n    at async autoCloseExpiredSessions (E:\\my_2025_pro\\alkhlodfinance\\backend\\services\\shiftAutoCloseService.js:145:26)\n    at async cron.schedule.scheduled (E:\\my_2025_pro\\alkhlodfinance\\backend\\services\\shiftAutoCloseService.js:231:5)\n    at async Timeout._onTimeout (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\node-cron\\dist\\cjs\\scheduler\\runner.js:70:44)",
  "name": "SequelizeDatabaseError",
  "sql": "SELECT `ShiftSession`.`id`, `ShiftSession`.`shiftId`, `ShiftSession`.`branchId`, `ShiftSession`.`userId`, `ShiftSession`.`sessionDate`, `ShiftSession`.`startTime`, `ShiftSession`.`endTime`, `ShiftSession`.`expectedStartTime`, `ShiftSession`.`expectedEndTime`, `ShiftSession`.`openingBalance`, `ShiftSession`.`closingBalance`, `ShiftSession`.`expectedClosingBalance`, `ShiftSession`.`cashDifference`, `ShiftSession`.`totalSales`, `ShiftSession`.`totalCash`, `ShiftSession`.`totalCard`, `ShiftSession`.`totalWallet`, `ShiftSession`.`totalTransfer`, `ShiftSession`.`totalDiscount`, `ShiftSession`.`totalTax`, `ShiftSession`.`transactionsCount`, `ShiftSession`.`status`, `ShiftSession`.`closedBy`, `ShiftSession`.`notes`, `ShiftSession`.`closingNotes`, `ShiftSession`.`reportData`, `ShiftSession`.`createdAt`, `ShiftSession`.`updatedAt`, `shift`.`id` AS `shift.id`, `shift`.`shiftName` AS `shift.shiftName`, `shift`.`startTime` AS `shift.startTime`, `shift`.`endTime` AS `shift.endTime` FROM `ShiftSessions` AS `ShiftSession` LEFT OUTER JOIN `Shifts` AS `shift` ON `ShiftSession`.`shiftId` = `shift`.`id` WHERE `ShiftSession`.`status` = 'open' AND `ShiftSession`.`sessionDate` = '2026-01-27';",
  "parameters": {},
  "context": {
    "service": "shiftAutoCloseService"
  },
  "additionalInfo": {},
  "systemInfo": {
    "nodeVersion": "v22.13.1",
    "platform": "win32",
    "arch": "x64",
    "memoryUsage": {
      "rss": 93138944,
      "heapTotal": 40153088,
      "heapUsed": 37639224,
      "external": 2360742,
      "arrayBuffers": 42867
    },
    "uptime": 102.4435201
  }
}
----------------------------------------------------------------------------------------------------
{
  "errorId": "ERR_1769517420066_yh9144x8k",
  "timestamp": "2026-01-27T12:37:00.066Z",
  "message": "Table 'finance.shiftsessions' doesn't exist",
  "stack": "Error\n    at Query.run (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n    at E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n    at async MySQLQueryInterface.select (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n    at async ShiftSession.findAll (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n    at async autoCloseExpiredSessions (E:\\my_2025_pro\\alkhlodfinance\\backend\\services\\shiftAutoCloseService.js:145:26)\n    at async cron.schedule.scheduled (E:\\my_2025_pro\\alkhlodfinance\\backend\\services\\shiftAutoCloseService.js:231:5)\n    at async Timeout._onTimeout (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\node-cron\\dist\\cjs\\scheduler\\runner.js:70:44)",
  "name": "SequelizeDatabaseError",
  "sql": "SELECT `ShiftSession`.`id`, `ShiftSession`.`shiftId`, `ShiftSession`.`branchId`, `ShiftSession`.`userId`, `ShiftSession`.`sessionDate`, `ShiftSession`.`startTime`, `ShiftSession`.`endTime`, `ShiftSession`.`expectedStartTime`, `ShiftSession`.`expectedEndTime`, `ShiftSession`.`openingBalance`, `ShiftSession`.`closingBalance`, `ShiftSession`.`expectedClosingBalance`, `ShiftSession`.`cashDifference`, `ShiftSession`.`totalSales`, `ShiftSession`.`totalCash`, `ShiftSession`.`totalCard`, `ShiftSession`.`totalWallet`, `ShiftSession`.`totalTransfer`, `ShiftSession`.`totalDiscount`, `ShiftSession`.`totalTax`, `ShiftSession`.`transactionsCount`, `ShiftSession`.`status`, `ShiftSession`.`closedBy`, `ShiftSession`.`notes`, `ShiftSession`.`closingNotes`, `ShiftSession`.`reportData`, `ShiftSession`.`createdAt`, `ShiftSession`.`updatedAt`, `shift`.`id` AS `shift.id`, `shift`.`shiftName` AS `shift.shiftName`, `shift`.`startTime` AS `shift.startTime`, `shift`.`endTime` AS `shift.endTime` FROM `ShiftSessions` AS `ShiftSession` LEFT OUTER JOIN `Shifts` AS `shift` ON `ShiftSession`.`shiftId` = `shift`.`id` WHERE `ShiftSession`.`status` = 'open' AND `ShiftSession`.`sessionDate` = '2026-01-27';",
  "parameters": {},
  "context": {
    "service": "shiftAutoCloseService"
  },
  "additionalInfo": {},
  "systemInfo": {
    "nodeVersion": "v22.13.1",
    "platform": "win32",
    "arch": "x64",
    "memoryUsage": {
      "rss": 95105024,
      "heapTotal": 43298816,
      "heapUsed": 40590072,
      "external": 2378204,
      "arrayBuffers": 60329
    },
    "uptime": 162.446902
  }
}
----------------------------------------------------------------------------------------------------
{
  "errorId": "ERR_1769517480047_doa7laxyf",
  "timestamp": "2026-01-27T12:38:00.047Z",
  "message": "Table 'finance.shiftsessions' doesn't exist",
  "stack": "Error\n    at Query.run (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n    at E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n    at async MySQLQueryInterface.select (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n    at async ShiftSession.findAll (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n    at async autoCloseExpiredSessions (E:\\my_2025_pro\\alkhlodfinance\\backend\\services\\shiftAutoCloseService.js:145:26)\n    at async cron.schedule.scheduled (E:\\my_2025_pro\\alkhlodfinance\\backend\\services\\shiftAutoCloseService.js:231:5)\n    at async Timeout._onTimeout (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\node-cron\\dist\\cjs\\scheduler\\runner.js:70:44)",
  "name": "SequelizeDatabaseError",
  "sql": "SELECT `ShiftSession`.`id`, `ShiftSession`.`shiftId`, `ShiftSession`.`branchId`, `ShiftSession`.`userId`, `ShiftSession`.`sessionDate`, `ShiftSession`.`startTime`, `ShiftSession`.`endTime`, `ShiftSession`.`expectedStartTime`, `ShiftSession`.`expectedEndTime`, `ShiftSession`.`openingBalance`, `ShiftSession`.`closingBalance`, `ShiftSession`.`expectedClosingBalance`, `ShiftSession`.`cashDifference`, `ShiftSession`.`totalSales`, `ShiftSession`.`totalCash`, `ShiftSession`.`totalCard`, `ShiftSession`.`totalWallet`, `ShiftSession`.`totalTransfer`, `ShiftSession`.`totalDiscount`, `ShiftSession`.`totalTax`, `ShiftSession`.`transactionsCount`, `ShiftSession`.`status`, `ShiftSession`.`closedBy`, `ShiftSession`.`notes`, `ShiftSession`.`closingNotes`, `ShiftSession`.`reportData`, `ShiftSession`.`createdAt`, `ShiftSession`.`updatedAt`, `shift`.`id` AS `shift.id`, `shift`.`shiftName` AS `shift.shiftName`, `shift`.`startTime` AS `shift.startTime`, `shift`.`endTime` AS `shift.endTime` FROM `ShiftSessions` AS `ShiftSession` LEFT OUTER JOIN `Shifts` AS `shift` ON `ShiftSession`.`shiftId` = `shift`.`id` WHERE `ShiftSession`.`status` = 'open' AND `ShiftSession`.`sessionDate` = '2026-01-27';",
  "parameters": {},
  "context": {
    "service": "shiftAutoCloseService"
  },
  "additionalInfo": {},
  "systemInfo": {
    "nodeVersion": "v22.13.1",
    "platform": "win32",
    "arch": "x64",
    "memoryUsage": {
      "rss": 95666176,
      "heapTotal": 44085248,
      "heapUsed": 41168160,
      "external": 2378329,
      "arrayBuffers": 60454
    },
    "uptime": 222.4278659
  }
}
----------------------------------------------------------------------------------------------------
{
  "errorId": "ERR_1769517575246_489fyhwgc",
  "timestamp": "2026-01-27T12:39:35.246Z",
  "message": "Table 'finance.shiftsessions' doesn't exist",
  "stack": "Error\n    at Query.run (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n    at E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n    at async MySQLQueryInterface.select (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n    at async ShiftSession.findAll (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n    at async autoCloseExpiredSessions (E:\\my_2025_pro\\alkhlodfinance\\backend\\services\\shiftAutoCloseService.js:145:26)",
  "name": "SequelizeDatabaseError",
  "sql": "SELECT `ShiftSession`.`id`, `ShiftSession`.`shiftId`, `ShiftSession`.`branchId`, `ShiftSession`.`userId`, `ShiftSession`.`sessionDate`, `ShiftSession`.`startTime`, `ShiftSession`.`endTime`, `ShiftSession`.`expectedStartTime`, `ShiftSession`.`expectedEndTime`, `ShiftSession`.`openingBalance`, `ShiftSession`.`closingBalance`, `ShiftSession`.`expectedClosingBalance`, `ShiftSession`.`cashDifference`, `ShiftSession`.`totalSales`, `ShiftSession`.`totalCash`, `ShiftSession`.`totalCard`, `ShiftSession`.`totalWallet`, `ShiftSession`.`totalTransfer`, `ShiftSession`.`totalDiscount`, `ShiftSession`.`totalTax`, `ShiftSession`.`transactionsCount`, `ShiftSession`.`status`, `ShiftSession`.`closedBy`, `ShiftSession`.`notes`, `ShiftSession`.`closingNotes`, `ShiftSession`.`reportData`, `ShiftSession`.`createdAt`, `ShiftSession`.`updatedAt`, `shift`.`id` AS `shift.id`, `shift`.`shiftName` AS `shift.shiftName`, `shift`.`startTime` AS `shift.startTime`, `shift`.`endTime` AS `shift.endTime` FROM `ShiftSessions` AS `ShiftSession` LEFT OUTER JOIN `Shifts` AS `shift` ON `ShiftSession`.`shiftId` = `shift`.`id` WHERE `ShiftSession`.`status` = 'open' AND `ShiftSession`.`sessionDate` = '2026-01-27';",
  "parameters": {},
  "context": {
    "service": "shiftAutoCloseService"
  },
  "additionalInfo": {},
  "systemInfo": {
    "nodeVersion": "v22.13.1",
    "platform": "win32",
    "arch": "x64",
    "memoryUsage": {
      "rss": 152772608,
      "heapTotal": 104640512,
      "heapUsed": 44024200,
      "external": 2491519,
      "arrayBuffers": 192815
    },
    "uptime": 35.7313591
  }
}
----------------------------------------------------------------------------------------------------
{
  "errorId": "ERR_1769517600121_ypkalqm8r",
  "timestamp": "2026-01-27T12:40:00.121Z",
  "message": "Table 'finance.shiftsessions' doesn't exist",
  "stack": "Error\n    at Query.run (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\mysql\\query.js:52:25)\n    at E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\sequelize.js:315:28\n    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)\n    at async MySQLQueryInterface.select (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\dialects\\abstract\\query-interface.js:407:12)\n    at async ShiftSession.findAll (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\sequelize\\lib\\model.js:1140:21)\n    at async autoCloseExpiredSessions (E:\\my_2025_pro\\alkhlodfinance\\backend\\services\\shiftAutoCloseService.js:145:26)\n    at async cron.schedule.scheduled (E:\\my_2025_pro\\alkhlodfinance\\backend\\services\\shiftAutoCloseService.js:231:5)\n    at async Timeout._onTimeout (E:\\my_2025_pro\\alkhlodfinance\\backend\\node_modules\\node-cron\\dist\\cjs\\scheduler\\runner.js:70:44)",
  "name": "SequelizeDatabaseError",
  "sql": "SELECT `ShiftSession`.`id`, `ShiftSession`.`shiftId`, `ShiftSession`.`branchId`, `ShiftSession`.`userId`, `ShiftSession`.`sessionDate`, `ShiftSession`.`startTime`, `ShiftSession`.`endTime`, `ShiftSession`.`expectedStartTime`, `ShiftSession`.`expectedEndTime`, `ShiftSession`.`openingBalance`, `ShiftSession`.`closingBalance`, `ShiftSession`.`expectedClosingBalance`, `ShiftSession`.`cashDifference`, `ShiftSession`.`totalSales`, `ShiftSession`.`totalCash`, `ShiftSession`.`totalCard`, `ShiftSession`.`totalWallet`, `ShiftSession`.`totalTransfer`, `ShiftSession`.`totalDiscount`, `ShiftSession`.`totalTax`, `ShiftSession`.`transactionsCount`, `ShiftSession`.`status`, `ShiftSession`.`closedBy`, `ShiftSession`.`notes`, `ShiftSession`.`closingNotes`, `ShiftSession`.`reportData`, `ShiftSession`.`createdAt`, `ShiftSession`.`updatedAt`, `shift`.`id` AS `shift.id`, `shift`.`shiftName` AS `shift.shiftName`, `shift`.`startTime` AS `shift.startTime`, `shift`.`endTime` AS `shift.endTime` FROM `ShiftSessions` AS `ShiftSession` LEFT OUTER JOIN `Shifts` AS `shift` ON `ShiftSession`.`shiftId` = `shift`.`id` WHERE `ShiftSession`.`status` = 'open' AND `ShiftSession`.`sessionDate` = '2026-01-27';",
  "parameters": {},
  "context": {
    "service": "shiftAutoCloseService"
  },
  "additionalInfo": {},
  "systemInfo": {
    "nodeVersion": "v22.13.1",
    "platform": "win32",
    "arch": "x64",
    "memoryUsage": {
      "rss": 153305088,
      "heapTotal": 75542528,
      "heapUsed": 35183952,
      "external": 2366149,
      "arrayBuffers": 48274
    },
    "uptime": 60.6059483
  }
}
----------------------------------------------------------------------------------------------------