Uncaught (in promise) Error: JavaScript

Question

Hello,

Can someone give any ideas why this is happening, I've had many days reseraching and changing the code as suggested but it is not working; I received the following error:

“Uncaught (in promise) Error: A listener indicated an asynchronous response by returning true, but the message channel closed before a response was received”

Doing some research on, I found out that maybe is a cross-origin request issue and it is caused by various Chrome Extensions, but I checked and I do not have any Chrome extension blocking.

Thank you.

async function getUserDetails(MemberID) {
    try {
        const config = {
           
            server: '.',
            database: 'WebForms',
            options: {
                //encrypt: true // Use this if you're on Azure
            }
        };

        // Connect to the database
        await sql.connect(config);

        // Query the database
        const result = await sql.query`SELECT RTRIM(LTRIM(CONCAT(COALESCE(FirstName + ' ', ''), COALESCE(LastName, '')))) AS MemberName, SSN FROM dbo.Members WHERE MemberID = ${MemberID}`;
        
        if (result.recordset.length > 0) {
          const { MemberName, SSN } = result.recordset[0];

          console.log(`Name: ${MemberName}, SSN: ${SSN}`);

          document.getElementById("membername").value = MemberName;                                        
          document.getElementById("SSN").value = SSN;
  
          
                                                                         
          } else {
              console.log('No user found with the provided account number.');
  
              document.getElementById("membername").value = '';                                          
              document.getElementById("SSN").value = '';
          }
          
          
                                           
    } catch (err) {
        console.error('SQL error', err);
    } finally {
        await sql.close();
    }                                    
}