180 views

Description

The Mid Server will lose data if essential fields on the ecc_queue table have been made inactive or removed.
You could be experiencing this problem as well if the same mid-server works fine when connected to another instance.

 

Steps to Reproduce

1 - Open the ECC queue table and disable the payload field (set active = false).

2 - Save.

3 - Create a REST message that uses username/password.

4 - Validate the message works without the mid-server.
E.g: <server>/api/now/table/incident?sysparm_query=numberLIKE002&sysparm_limit=1

5 - Modify the REST message to use the mid-server.

The mid-server returns a "User Not Authenticated" error for missing username/password, instead of validating the ecc_queue containing all the active essential fields, to prevent data loss.

 

 

 

Workaround

This issue is targeted to be fixed in the London release.

As a workaround, please validate the ecc_queue table and review it contains the essential fields with active set to "true":

  • agent
  • agent_correlator
  • error_string
  • from_host
  • from_sys_id
  • name
  • payload
  • priority
  • processed
  • queue
  • response_to
  • sequence
  • source
  • state
  • topic


Related Problem: PRB1105662

Seen In

Helsinki Patch 3

Intended Fix Version

Madrid

Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-03-08 16:26:07
Published:2018-02-22