MID Server - dashboard Pending Jobs and Processing Jobs (ecc queue)

CV1
Tera Contributor

‎12-13-2023 04:32 PM

Hi All,

Our LDAP servers are frequently down and when re-entering pwd and stopping /staring listener it comes up.

  • Please advise what could be the reason for this behavior  and why the sql user is getting locked.
  • Steps to check ecc queue to check what jobs are processing and if we can clean /stop them.

 

TIA

0 Helpfuls
  • 656 Views
1 REPLY 1

Ratnakar7
Mega Sage
Mega Sage

‎12-15-2023 09:03 AM

Hi @CV1 ,

 

When dealing with MID Server issues, especially related to LDAP connectivity and potential SQL user lockouts, there are several steps and considerations you can take:

Investigating LDAP Connectivity Issues:

  1. Review Logs:

    • Check the MID Server logs for any error messages related to LDAP connectivity.
    • Logs can be found in the MID Server installation directory under the agent/logs folder.

  2. Check LDAP Configuration:

    • Verify that the LDAP server configurations in ServiceNow are accurate and up-to-date.
    • Ensure that the MID Server has the correct credentials to connect to the LDAP server.

  3. LDAP Server Health:

    • Ensure that the LDAP server itself is healthy and responsive.
    • Check for network connectivity issues between the MID Server and the LDAP server.

  4. User Lockout:

    • Investigate why the SQL user is getting locked. Check if there are multiple failed login attempts.
    • Verify that the credentials used by the MID Server to connect to the SQL server are correct.

Reviewing ECC Queue (Event Communication Channel):

    1. Check Pending Jobs:

      • Navigate to Outbound Transactions in your ServiceNow instance.
      • Look for pending jobs related to the LDAP operations or MID Server.

    2. Review Processing Jobs:

      • To check processing jobs, you may use the following script in the Script Background module:

 

 

var eccQueue = new GlideRecord('ecc_queue');
eccQueue.addQuery('state', 'processing');
eccQueue.query();
while (eccQueue.next()) {
    gs.info('Processing ECC Queue record: ' + eccQueue.getValue('name'));
    // Add more details or actions as needed
}

 

  • Cancel or Retry Jobs:

    • Depending on what you find in the ECC Queue, you might need to cancel or retry specific jobs.
    • Use caution when canceling jobs, as it could have an impact on your system.

Thanks,

Ratnakar

0 Helpfuls