Loading

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

Дата публикации: Mar 10, 2026
Описание

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.

Решение

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.
Номер статьи базы знаний
004519291
 
Загрузка
Salesforce Help | Article