Loading

Data 360: Error Unmapping Data Streams – "Failed to Retrieve ExternalizedReferences" Exception

Publiseringsdato: Mar 10, 2026
Beskrivelse

When attempting to unmap a data stream, you might encounter the following error:

 

Error Message:

Innermost Cause: shared.cdp.exceptions.CDPHandledException: Failed to retrieve the ExternalizedReferences with exception: common.exception.SfdcSqlException: ERROR: value with length 18 too long for type character varying(15)

{call cReport.bulk_get_reports(?,?,?,?)}

SQLState: 22001
File: varchar.c, Routine: varchar, Line: 640
; [conn=STANDARD:1:1:1932790:1]:

 

This error occurs when the DMO or a field within the data stream is currently used in a report.

Løsning

Step 1: Identify Reports Using the Data Stream

Before unmapping a data stream, verify that no reports are dependent on it by retrieving associated reports using WorkBench API calls.

Use the following API endpoint:

/services/data/<API-Version>/analytics/report-types/<report-type>/recent-reports?pageSize=100&isCurrentUser=true&offset=0

For example, if the API name of the DMO is ssot__Account__dlm, use:

  • To retrieve reports created by the current user:
     
/services/data/v62.0/analytics/report-types/CustomEntity$ssot__Account__dlm/recent-reports?pageSize=100&isCurrentUser=true&offset=0
  • To retrieve reports created by other users:


/services/data/v62.0/analytics/report-types/CustomEntity$ssot__Account__dlm/recent-reports?pageSize=100&isCurrentUser=false&offset=0


Step 2: Delete or Modify Dependencies


If reports are returned in the API response, delete or modify them as needed before proceeding with unmapping.


Step 3: Retry Unmapping the Data Stream


Once all dependencies are removed or updated, attempt to unmap the data stream again and verify the issue is resolved.
Knowledge-artikkelnummer
004519291
 
Laster
Salesforce Help | Article