3700065 - Import job for Public Dimensioin fails with error: "an unexpected error occurred while trying to update the dimension data" in SAP Analytics Cloud (SAC)

• Import job for Public Dimensioin fails with error: "an unexpected error occurred while trying to update the dimension data" in SAP Analytics Cloud (SAC)
• Error message observed in HAR file:
    "exception": "EPM_SERVICE : {\"packageId\":\"sap.fpa.services.resource.dm\",\"objectName\":\"message_dm\",\"messageId\":null,\"args\":[],\"message\":\"An unexpected error occurred while trying to update the dimension data.\",\"previous\":{\"code\":2},\"bUIMessage\":false,\"bWarning\":false,\"status\":500}"
• If trying to create a new model with same query as the dimension job, the data can be retrieved successfully

• SAP Analytic Cloud Enterprise 2025.21.9

KBA , LOD-ANA-ML-DE , SAC Data Wrangling , Problem