Error connecting to SQL Server: Error message: Failed to connect to zakaria:1433 in 60000ms Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined ValidationError: The 'X-Forwarded-For' header is set but the Express 'trust proxy' setting is false (default). This could indicate a misconfiguration which would prevent express-rate-limit from accurately identifying users. See https://express-rate-limit.github.io/ERR_ERL_UNEXPECTED_X_FORWARDED_FOR/ for more information. at Object.xForwardedForHeader (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\express-rate-limit\dist\index.cjs:187:13) at Object.wrappedValidations. [as xForwardedForHeader] (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\express-rate-limit\dist\index.cjs:398:22) at Object.keyGenerator (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\express-rate-limit\dist\index.cjs:671:20) at C:\wamp64\www\CMMS_Vermicelli_api\node_modules\express-rate-limit\dist\index.cjs:724:32 at processTicksAndRejections (node:internal/process/task_queues:96:5) at async C:\wamp64\www\CMMS_Vermicelli_api\node_modules\express-rate-limit\dist\index.cjs:704:5 { code: 'ERR_ERL_UNEXPECTED_X_FORWARDED_FOR', help: 'https://express-rate-limit.github.io/ERR_ERL_UNEXPECTED_X_FORWARDED_FOR/' } Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined ValidationError: The 'X-Forwarded-For' header is set but the Express 'trust proxy' setting is false (default). This could indicate a misconfiguration which would prevent express-rate-limit from accurately identifying users. See https://express-rate-limit.github.io/ERR_ERL_UNEXPECTED_X_FORWARDED_FOR/ for more information. at Object.xForwardedForHeader (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\express-rate-limit\dist\index.cjs:187:13) at Object.wrappedValidations. [as xForwardedForHeader] (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\express-rate-limit\dist\index.cjs:398:22) at Object.keyGenerator (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\express-rate-limit\dist\index.cjs:671:20) at C:\wamp64\www\CMMS_Vermicelli_api\node_modules\express-rate-limit\dist\index.cjs:724:32 at processTicksAndRejections (node:internal/process/task_queues:96:5) at async C:\wamp64\www\CMMS_Vermicelli_api\node_modules\express-rate-limit\dist\index.cjs:704:5 { code: 'ERR_ERL_UNEXPECTED_X_FORWARDED_FOR', help: 'https://express-rate-limit.github.io/ERR_ERL_UNEXPECTED_X_FORWARDED_FOR/' } ValidationError: The 'X-Forwarded-For' header is set but the Express 'trust proxy' setting is false (default). This could indicate a misconfiguration which would prevent express-rate-limit from accurately identifying users. See https://express-rate-limit.github.io/ERR_ERL_UNEXPECTED_X_FORWARDED_FOR/ for more information. at Object.xForwardedForHeader (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\express-rate-limit\dist\index.cjs:187:13) at Object.wrappedValidations. [as xForwardedForHeader] (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\express-rate-limit\dist\index.cjs:398:22) at Object.keyGenerator (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\express-rate-limit\dist\index.cjs:671:20) at C:\wamp64\www\CMMS_Vermicelli_api\node_modules\express-rate-limit\dist\index.cjs:724:32 at processTicksAndRejections (node:internal/process/task_queues:96:5) at async C:\wamp64\www\CMMS_Vermicelli_api\node_modules\express-rate-limit\dist\index.cjs:704:5 { code: 'ERR_ERL_UNEXPECTED_X_FORWARDED_FOR', help: 'https://express-rate-limit.github.io/ERR_ERL_UNEXPECTED_X_FORWARDED_FOR/' } Error checking active cycles: Error at Query.run (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\sequelize\lib\dialects\mssql\query.js:107:25) at C:\wamp64\www\CMMS_Vermicelli_api\node_modules\sequelize\lib\sequelize.js:315:28 at processTicksAndRejections (node:internal/process/task_queues:96:5) at async MSSqlQueryInterface.select (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\sequelize\lib\dialects\abstract\query-interface.js:407:12) at async Function.findAll (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\sequelize\lib\model.js:1140:21) at async C:\wamp64\www\CMMS_Vermicelli_api\routes\productionLineMixAndDeh.js:270:26 { name: 'SequelizeDatabaseError', parent: AggregateError at RequestTokenHandler.onErrorMessage (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\tedious\lib\token\handler.js:297:30) at Readable. (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\tedious\lib\token\token-stream-parser.js:18:33) at Readable.emit (node:events:390: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) at processTicksAndRejections (node:internal/process/task_queues:96:5) { sql: "SELECT [cycleDate], [status], [cycle_status], [cycle_end_date] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE (([AssetMasterMixAndDeh].[cycle_status] != N'ended' OR [AssetMasterMixAndDeh].[cycle_status] IS NULL) AND ([AssetMasterMixAndDeh].[status] != N'ended' OR [AssetMasterMixAndDeh].[status] IS NULL) AND [AssetMasterMixAndDeh].[cycle_end_date] IS NULL) GROUP BY [cycleDate], [status], [cycle_status], [cycle_end_date] ORDER BY [AssetMasterMixAndDeh].[cycleDate] DESC;", parameters: undefined }, original: AggregateError at RequestTokenHandler.onErrorMessage (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\tedious\lib\token\handler.js:297:30) at Readable. (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\tedious\lib\token\token-stream-parser.js:18:33) at Readable.emit (node:events:390: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) at processTicksAndRejections (node:internal/process/task_queues:96:5) { sql: "SELECT [cycleDate], [status], [cycle_status], [cycle_end_date] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE (([AssetMasterMixAndDeh].[cycle_status] != N'ended' OR [AssetMasterMixAndDeh].[cycle_status] IS NULL) AND ([AssetMasterMixAndDeh].[status] != N'ended' OR [AssetMasterMixAndDeh].[status] IS NULL) AND [AssetMasterMixAndDeh].[cycle_end_date] IS NULL) GROUP BY [cycleDate], [status], [cycle_status], [cycle_end_date] ORDER BY [AssetMasterMixAndDeh].[cycleDate] DESC;", parameters: undefined }, sql: "SELECT [cycleDate], [status], [cycle_status], [cycle_end_date] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE (([AssetMasterMixAndDeh].[cycle_status] != N'ended' OR [AssetMasterMixAndDeh].[cycle_status] IS NULL) AND ([AssetMasterMixAndDeh].[status] != N'ended' OR [AssetMasterMixAndDeh].[status] IS NULL) AND [AssetMasterMixAndDeh].[cycle_end_date] IS NULL) GROUP BY [cycleDate], [status], [cycle_status], [cycle_end_date] ORDER BY [AssetMasterMixAndDeh].[cycleDate] DESC;", parameters: {} } Error fetching detail data: Error at Query.run (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\sequelize\lib\dialects\mssql\query.js:107:25) at C:\wamp64\www\CMMS_Vermicelli_api\node_modules\sequelize\lib\sequelize.js:315:28 at processTicksAndRejections (node:internal/process/task_queues:96:5) at async MSSqlQueryInterface.select (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\sequelize\lib\dialects\abstract\query-interface.js:407:12) at async Function.findAll (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\sequelize\lib\model.js:1140:21) at async C:\wamp64\www\CMMS_Vermicelli_api\routes\productionLineMixAndDeh.js:543:27 { name: 'SequelizeDatabaseError', parent: AggregateError at RequestTokenHandler.onErrorMessage (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\tedious\lib\token\handler.js:297:30) at Readable. (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\tedious\lib\token\token-stream-parser.js:18:33) at Readable.emit (node:events:390: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) at processTicksAndRejections (node:internal/process/task_queues:96:5) { sql: "SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC;", parameters: undefined }, original: AggregateError at RequestTokenHandler.onErrorMessage (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\tedious\lib\token\handler.js:297:30) at Readable. (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\tedious\lib\token\token-stream-parser.js:18:33) at Readable.emit (node:events:390: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) at processTicksAndRejections (node:internal/process/task_queues:96:5) { sql: "SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC;", parameters: undefined }, sql: "SELECT [RowID], [line], [cycleDate], [status], [cycle_status] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC;", parameters: {} } Error fetching master data: Error at Query.run (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\sequelize\lib\dialects\mssql\query.js:107:25) at C:\wamp64\www\CMMS_Vermicelli_api\node_modules\sequelize\lib\sequelize.js:315:28 at processTicksAndRejections (node:internal/process/task_queues:96:5) at async MSSqlQueryInterface.select (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\sequelize\lib\dialects\abstract\query-interface.js:407:12) at async Function.findAll (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\sequelize\lib\model.js:1140:21) at async C:\wamp64\www\CMMS_Vermicelli_api\routes\productionLineMixAndDeh.js:494:27 { name: 'SequelizeDatabaseError', parent: AggregateError at RequestTokenHandler.onErrorMessage (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\tedious\lib\token\handler.js:297:30) at Readable. (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\tedious\lib\token\token-stream-parser.js:18:33) at Readable.emit (node:events:390: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) at processTicksAndRejections (node:internal/process/task_queues:96:5) { sql: "SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC;", parameters: undefined }, original: AggregateError at RequestTokenHandler.onErrorMessage (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\tedious\lib\token\handler.js:297:30) at Readable. (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\tedious\lib\token\token-stream-parser.js:18:33) at Readable.emit (node:events:390: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) at processTicksAndRejections (node:internal/process/task_queues:96:5) { sql: "SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC;", parameters: undefined }, sql: "SELECT [RowID], [cycleDate], [line], [status], [cycle_status], [cycle_end_date], [startDate], [endDate] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE [AssetMasterMixAndDeh].[cycleDate] = N'2025-07-12' ORDER BY [AssetMasterMixAndDeh].[line] ASC, [AssetMasterMixAndDeh].[RowID] ASC;", parameters: {} } Error checking active cycles: Error at Query.run (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\sequelize\lib\dialects\mssql\query.js:107:25) at C:\wamp64\www\CMMS_Vermicelli_api\node_modules\sequelize\lib\sequelize.js:315:28 at runMicrotasks () at processTicksAndRejections (node:internal/process/task_queues:96:5) at async MSSqlQueryInterface.select (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\sequelize\lib\dialects\abstract\query-interface.js:407:12) at async Function.findAll (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\sequelize\lib\model.js:1140:21) at async C:\wamp64\www\CMMS_Vermicelli_api\routes\productionLineMixAndDeh.js:270:26 { name: 'SequelizeDatabaseError', parent: AggregateError at RequestTokenHandler.onErrorMessage (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\tedious\lib\token\handler.js:297:30) at Readable. (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\tedious\lib\token\token-stream-parser.js:18:33) at Readable.emit (node:events:390: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) at runMicrotasks () at processTicksAndRejections (node:internal/process/task_queues:96:5) { sql: "SELECT [cycleDate], [status], [cycle_status], [cycle_end_date] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE (([AssetMasterMixAndDeh].[cycle_status] != N'ended' OR [AssetMasterMixAndDeh].[cycle_status] IS NULL) AND ([AssetMasterMixAndDeh].[status] != N'ended' OR [AssetMasterMixAndDeh].[status] IS NULL) AND [AssetMasterMixAndDeh].[cycle_end_date] IS NULL) GROUP BY [cycleDate], [status], [cycle_status], [cycle_end_date] ORDER BY [AssetMasterMixAndDeh].[cycleDate] DESC;", parameters: undefined }, original: AggregateError at RequestTokenHandler.onErrorMessage (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\tedious\lib\token\handler.js:297:30) at Readable. (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\tedious\lib\token\token-stream-parser.js:18:33) at Readable.emit (node:events:390: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) at runMicrotasks () at processTicksAndRejections (node:internal/process/task_queues:96:5) { sql: "SELECT [cycleDate], [status], [cycle_status], [cycle_end_date] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE (([AssetMasterMixAndDeh].[cycle_status] != N'ended' OR [AssetMasterMixAndDeh].[cycle_status] IS NULL) AND ([AssetMasterMixAndDeh].[status] != N'ended' OR [AssetMasterMixAndDeh].[status] IS NULL) AND [AssetMasterMixAndDeh].[cycle_end_date] IS NULL) GROUP BY [cycleDate], [status], [cycle_status], [cycle_end_date] ORDER BY [AssetMasterMixAndDeh].[cycleDate] DESC;", parameters: undefined }, sql: "SELECT [cycleDate], [status], [cycle_status], [cycle_end_date] FROM [mix_deh_mst] AS [AssetMasterMixAndDeh] WHERE (([AssetMasterMixAndDeh].[cycle_status] != N'ended' OR [AssetMasterMixAndDeh].[cycle_status] IS NULL) AND ([AssetMasterMixAndDeh].[status] != N'ended' OR [AssetMasterMixAndDeh].[status] IS NULL) AND [AssetMasterMixAndDeh].[cycle_end_date] IS NULL) GROUP BY [cycleDate], [status], [cycle_status], [cycle_end_date] ORDER BY [AssetMasterMixAndDeh].[cycleDate] DESC;", parameters: {} } ValidationError: The 'X-Forwarded-For' header is set but the Express 'trust proxy' setting is false (default). This could indicate a misconfiguration which would prevent express-rate-limit from accurately identifying users. See https://express-rate-limit.github.io/ERR_ERL_UNEXPECTED_X_FORWARDED_FOR/ for more information. at Object.xForwardedForHeader (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\express-rate-limit\dist\index.cjs:187:13) at Object.wrappedValidations. [as xForwardedForHeader] (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\express-rate-limit\dist\index.cjs:398:22) at Object.keyGenerator (C:\wamp64\www\CMMS_Vermicelli_api\node_modules\express-rate-limit\dist\index.cjs:671:20) at C:\wamp64\www\CMMS_Vermicelli_api\node_modules\express-rate-limit\dist\index.cjs:724:32 at processTicksAndRejections (node:internal/process/task_queues:96:5) at async C:\wamp64\www\CMMS_Vermicelli_api\node_modules\express-rate-limit\dist\index.cjs:704:5 { code: 'ERR_ERL_UNEXPECTED_X_FORWARDED_FOR', help: 'https://express-rate-limit.github.io/ERR_ERL_UNEXPECTED_X_FORWARDED_FOR/' } Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined Error connecting to SQL Server: Error message: Failed to connect to ESSB01-DESKTOP\SQLDEV2022 - Could not connect (sequence) Error code: undefined Error number: undefined