Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
NicolasRivas
Partner - Contributor III
Partner - Contributor III

Error trying to use Qlik Mailbox IMAP Connector

As the title says, Whenever we try to use ANY functionality of Qlik Mailbox IMAP Connector, we have the error "There was an error running the table (The server has closed the connection.":

  • I already checked if IMAP was enabled in GMAIL
  • I try restarting services or the server
  • I checked the logs but it doesn't says much more than that.
  • I googled the error but found nothing.

NicolasRivas_0-1733491321226.png

 

NicolasRivas_1-1733491342688.pngNicolasRivas_2-1733491363914.png

 

Labels (2)
3 Replies
diegozecchini
Specialist
Specialist

Hi!
Here some checks for your situation.

-Double-check that IMAP is enabled under Gmail Settings > Forwarding and POP/IMAP.
-Gmail blocks connections from apps that are not using OAuth 2.0. Make sure you allow connections through https://myaccount.google.com/lesssecureapps.

If the account has 2-Step Verification enabled, you'll need to generate an App Password for Qlik Mailbox IMAP Connector instead of using the regular password.

NicolasRivas
Partner - Contributor III
Partner - Contributor III
Author

Hello Diego,

-The IMAP Isenabled on gmail

-The less secured apps allowed is active on gmail setting

-An the 2 step verification is offline.

diegozecchini
Specialist
Specialist

Hi!
here are some further checks and solutions to troubleshoot the connector issue:

1. Verify IMAP Connection Outside Qlik
Use a third-party IMAP client (like Thunderbird, Outlook, or PowerShell Test-ImapConnectivity) to connect to Gmail with the same credentials and IMAP server:
Server: imap.gmail.com
Port: 993 (SSL enabled)
If the connection fails, is not Qlik, may be firewall.

2. Enable App Password
Since "Less secure apps" is enabled, but the connection still fails, Google security might still block Qlik's connection:

Generate an App Password for Qlik Mailbox IMAP Connector.
Go to: Google Security Settings > App Passwords.
Use the generated 16-character password instead of the regular password in Qlik.
Even if 2-Step Verification is OFF, sometimes Google enforces additional security measures.


Finally you could look for SSL/TLS errors in the Qlik Connector logs.
The issue could arise if the Gmail IMAP connection requires a specific TLS version:
Verify the TLS version in use by your server (must be TLS 1.2 or higher).
Check Qlik configuration to ensure it supports TLS 1.2/1.3.