The ServiceNow Data Platform normalization process can fail with the error below. This error occurs if the OAuth provider URL is not configured properly.
Normalization job failed with error [connecting]. exception in [filter list] not catch(ed) from message. [errors] = 0. [catch list]=[]. [config list]=["TimeoutException","HttpRequestException","\"StatusCode\":50"]. [message list]=BDNA.COMMON.API.APIAUTHOREXCEPTION SERVICE RESPONSE AN ERROR WHEN QUERY THE ACCESS TOKEN. PLEASE CHECK YOUR REFRESH TOKEN. AND ALSO TRY TO CHECK YOUR [CLIENT_SECRET] IN SERVICENOW. BDNA.COMMON.API.APIAUTHOREXCEPTION BDNA.COMMON.API.FRONTEXCEPTION BDNA.COMMON.API.HTTPRESPONSEEXCEPTION SERVICE RESPONSE AN ERROR WITH THE REQUEST BDNA.COMMON.API.HTTPRESPONSEEXCEPTION BDNA.COMMON.API.FRONTEXCEPTION MESSAGESTATUS: {"STATUSCODE":401,"REASONPHRASE":"UNAUTHORIZED"} MESSAGEBODY: {"ERROR_DESCRIPTION":"ACCESS_DENIED","ERROR":"SERVER_ERROR"} BDNA.COMMON.API.FRONTEXCEPTION SYSTEM.EXCEPTION ENDPOINT EXECUTE FAILED. AND FALLBACK IS NOT SUCCESS. FALLBACK IS NOT EXECUTE AS THE RULES IS NOT RESOLVED. SYSTEM.AGGREGATEEXCEPTION ONE OR MORE ERRORS OCCURRED. SYSTEM.AGGREGATEEXCEPTION SYSTEM.AGGREGATEEXCEPTION ONE OR MORE ERRORS OCCURRED. SYSTEM.AGGREGATEEXCEPTION [cause]: MessageStatus: {"StatusCode":401,"ReasonPhrase":"Unauthorized"} MessageBody: {"error_description":"access_denied","error":"server_error"}.
Solution
To correct this issue, follow the steps below.
- Navigate to Flexera Integration > Advanced > Fix Scripts in the ServiceNow instance.
- Click FlexNetManagerSuite_Upgrade.
- Click Run Fix Script.
After the script is complete, regenerate a new token and then re-run the ServiceNow normalize job with the new token.
If the issue persists, navigate to the ServiceNow normalize settings page and follow the steps below.
- Paste in the token and ServiceNow URL and test the connection.
- Paste the file path in the correct Export folder with the correct share privilege and test the connection.
- Click Save and start the normalize process.
