Loading

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

Fecha de publicación: Mar 10, 2026
Descripción

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.

Solución

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.
Número del artículo de conocimiento
004519291
 
Cargando
Salesforce Help | Article