Normalization Services "Failure: Could not download Normalized Manufacturer Names"

Pat Espin · ‎09-01-2017

In my Jakarta developer instance, I'm trying to go through the guided set up for Normalization Services. When I get to the data section and try to "Download Normalized Data" I get an error, almost immediately after starting that says "Failure: Could not download Normalized Manufacturer Names". Anyone know why?

adilrathore · ‎09-01-2017

Apart from the Screenshot what error is being reported in the System log.

Pat Espin · ‎09-01-2017

The error seems to be: "Logic Error: No Join Found for table: sys_metadata0: no thrown error"

Pat Espin · ‎09-01-2017

Adil,

This this - looks like a 401 error. I'm signed on as a user I created - maybe I can try admin.

09-01 12:22	Information	Method failed: (/api/now/table/cds_server_name) with code: 401 - Invalid username/password combo	*** Script
Select record for action	Preview	09-01 12:22	Information	Attempting to download data from cds_client_mapping	*** Script
Select record for action	Preview	09-01 12:22	Information	Failed retrieving data from repository. 401	*** Script
Select record for action	Preview	09-01 12:22	Information	Attempting to download data from cds_client_name	*** Script
Select record for action	Preview	09-01 12:22	Information	Endpoint is : https://sncdataservices.service-now.com/api/now/table/cds_server_name?sysparm_fields=name%2Cfield%2C...	*** Script
Select record for action	Preview	09-01 12:22	Information	Method failed: (/api/now/table/cds_server_mapping) with code: 401 - Invalid username/password combo	*** Script
Select record for action	Preview	09-01 12:22	Information	Last Updated On:	*** Script
Select record for action	Preview	09-01 12:22	Information	Failed retrieving data from repository. 401	*** Script
Select record for action	Preview	09-01 12:22	Information	Failed retrieving data from repository. 401	*** Script
Select record for action	Preview	09-01 12:22	Information	Last Updated On:	*** Script
Select record for action	Preview	09-01 12:22	Information	CanonicalRepo: Trying to get registry record for table: 24b0ecdcc3522200f25d174292d3aecc	*** Script
Select record for action	Preview	09-01 12:22	Information	Endpoint is : https://sncdataservices.service-now.com/api/now/table/cds_server_mapping?sysparm_fields=canonical_na...	*** Script
Select record for action	Preview	09-01 12:22	Information	Method failed: (/api/now/table/cds_server_name) with code: 401 - Invalid username/password combo	*** Script
Select record for action	Preview	09-01 12:22	Information	CanonicalRepo: Table: 34002410c3922200f25d174292d3ae21 last_updated_on:

Pat Espin · ‎09-01-2017

When logging in as admin user I see the same errors:

Failed retrieving data from repository. 401

Endpoint is : https://sncdataservices.service-now.com/api/now/table/cds_server_name?sysparm_fields=name%2Cfield%2C...

Method failed: (/api/now/table/cds_server_mapping) with code: 401 - Invalid username/password combo

Method failed: (/api/now/table/cds_server_name) with code: 401 - Invalid username/password combo

Error occured while downloading data for table: cds_client_name from server table: cds_server_name

Endpoint is : https://sncdataservices.service-now.com/api/now/table/cds_server_mapping?sysparm_fields=canonical_na...

Failed retrieving data from repository. 401