clients are unable to receive any data, resulting in HTTP 5XX errors. Below are the details of the problem and the steps I have taken to resolve it.

I am encountering issues deploying my Node.js application to Azure App Service. While the server starts successfully and connects to the database, clients are unable to receive any data, resulting in HTTP 5XX errors. Below are the details of the problem and the steps I have taken to resolve it.

Server indicates it is running and connected to the database.

1. Client requests result in HTTP 5XX errors with no data returned.
2. No data is being sent from the server to the client despite successful handling of requests.

      node js
      server.jsHelprequire('dotenv').config();
      const express = require('express');
      const sql = require('mssql');
      const cors = require('cors');
      const path = require('path');
      const helmet = require('helmet');
      const appInsights = require("applicationinsights");
      // הגדרת Application Insights באמצעות משתנה הסביבה
      appInsights.setup(process.env.APPLICATIONINSIGHTS_CONNECTION_STRING)
          .setAutoDependencyCorrelation(true)
          .setAutoCollectRequests(true)
          .setAutoCollectPerformance(true)
          .setAutoCollectExceptions(true)
          .setAutoCollectDependencies(true)
          .setUseDiskRetryCaching(true)
          .start();
      // אתחול Express
      const app = express();
      const port = process.env.PORT || 3000;
      // הגדרת CORS
      app.use(cors({
        origin: "*",
        methods: ["GET", "POST", "PUT", "DELETE", "OPTIONS"],
        allowedHeaders: ["Content-Type", "Authorization"]
      }));
      // הוספת Helmet לאבטחה
      app.use(helmet());
      // הגדרת קבצים סטטיים
      app.use(express.static(path.join(__dirname, 'wwwroot')));
      // הגבלת גודל הבקשות
      app.use(express.json({ limit: '10kb' }));
      app.use(express.urlencoded({ limit: '10kb', extended: true }));
      // בדיקת משתני סביבה
      const requiredEnvVars = ['DB_HOST', 'DB_USER', 'DB_NAME', 'DB_PORT', 'DB_PASSWORD', 'APPLICATIONINSIGHTS_CONNECTION_STRING'];
      requiredEnvVars.forEach(varName => {
          if (!process.env[varName]) {
              console.error(`Missing required environment variable: ${varName}`);
              process.exit(1);
          }
      });
      // הגדרת פרטי החיבור למסד הנתונים
      const config = {
          user: process.env.DB_USER,
          password: process.env.DB_PASSWORD,
          server: process.env.DB_HOST,
          port: parseInt(process.env.DB_PORT) || 1433,
          database: process.env.DB_NAME,
          options: {
              encrypt: true,
              enableArithAbort: true
          }
      };
      // אתחול מאגר החיבורים הגלובלי
      const poolPromise = sql.connect(config)
          .then(pool => {
              console.log('Connected to the database successfully');
              return pool;
          })
          .catch(err => {
              console.error('Database Connection Failed! Bad Config: ', err);
              process.exit(1);
          });
      // הוספת לוגים לכל בקשה
      app.use((req, res, next) => {
          console.log(`${req.method} ${req.url}`);
          next();
      });
      // 
      app.get('/', (req, res) => {
          res.sendFile(path.join(__dirname, 'wwwroot', 'index.html'));
      });
      // דוגמה לראוט API
      app.get('/api/users', async (req, res, next) => {
          try {
              const pool = await poolPromise;
              const result = await pool.request().query('SELECT * FROM Users');
              res.json(result.recordset);
          } catch (error) {
              next(error); // העברת השגיאה ל-middleware לטיפול בשגיאות
          }
      });
      // Middleware 
      if (process.env.NODE_ENV === 'development') {
          app.use((err, req, res, next) => {
              console.error(err.stack);
              res.status(500).json({ error: err.message, stack: err.stack });
          });
      } else {
          app.use((err, req, res, next) => {
              console.error(err.stack);
              res.status(500).json({ error: 'Internal Server Error' });
          });
      }
      // 
      const server = app.listen(port, () => {
          console.log(`Server is running on port ${port}`);
      });
      // 
      process.on('SIGTERM', () => {
          console.log('SIGTERM signal received: closing HTTP server');
          server.close(() => {
              console.log('HTTP server closed');
              sql.close();
          });
      });
      
   

      node js 
      
      <?xml version="1.0" encoding="utf-8"?>
      <configuration>
        <system.webServer>
          <handlers>
            <add name="iisnode" path="server.js" verb="*" modules="iisnode"/>
          </handlers>
          <rewrite>
            <rules>
              <!-- ניתוב כל שאר הבקשות לשרת Node.js -->
              <rule name="DynamicContent" stopProcessing="true">
                <match url=".*" />
                <conditions>
                  <add input="{REQUEST_FILENAME}" matchType="IsFile" negate="true" />
                </conditions>
                <action type="Rewrite" url="server.js" />
              </rule>
            </rules>
          </rewrite>
          <security>
            <requestFiltering>
              <hiddenSegments>
                <add segment="node_modules"/>
              </hiddenSegments>
            </requestFiltering>
          </security>
          <httpErrors existingResponse="PassThrough" />
          <staticContent>
            <mimeMap fileExtension=".json" mimeType="application/json" />
            <mimeMap fileExtension=".css" mimeType="text/css" />
            <mimeMap fileExtension=".js" mimeType="application/javascript" />
            <!-- הוסף סיומות נוספות לפי הצורך -->
          </staticContent>
          <iisnode
            watchedFiles="*.js;iisnode.yml"
            loggingEnabled="true"
          />
        </system.webServer>
      </configuration>
      
   

      {
        "name": "wevote-app",
        "version": "1.0.0",
        "description": "wevote",
        "main": "server.js",
        "scripts": {
          "start": "node server.js"
        },
        "dependencies": {
          "applicationinsights": "^3.3.0",
          "bcryptjs": "^2.4.3",
          "cors": "^2.8.5",
          "dotenv": "^16.4.5",
          "express": "^4.21.0",
          "helmet": "^6.2.0",
          "jsonwebtoken": "^9.0.2",
          "moment-timezone": "^0.5.45",
          "morgan": "^1.10.0",
          "mssql": "^11.0.1",
          "nodemailer": "^6.9.15",
          "xlsx": "^0.18.5"
        },
        "engines": {
          "node": ">=14.0.0"
        }
      }