SAP Knowledge Base Article - Public

3611665 - View cannot be deployed after changing the length of a dimension due to dependency

Symptom

While deploying a view that contains dependent views, if a length of a dimension was changed the following error is raised

Model could not be deployed. {"message":"Status 400 is not accepted: [{\"severity\":3,\"message\":\"The type of column XXXXX#YYYYY cannot be modified from String(X) to String(Y) because it's used by the following objects:\",\"messageCode\":\"DATATYPE_IN_USE\",\"description\":\"ZZZZZ, ZZZZZ, ZZZZZ\",\"additionalInfo\":{\"old\":{\"type\":\"cds.String\",\"length\":\"X\"},\"new\":{\"type\":\"cds.String\",\"length\":\"Y\"}},\"inaccessibleDependencies\":0,\"objectName\":\"XXXXX#YYYYY\",\"dependencies\":

....

\"pendingError\":false,\"httpCode\":400}]"} 

Environment

SAP Datasphere

Reproducing the Issue

  1. Change the length of a dimension in a view that has dependency
  2. Deploy the view

Cause

It is a product issue

Resolution

The solution will de delivered on wave 11.

As a workaround, you can delete the view from the dependent view, deploy the changed view, and add it back to the dependent view.

See Also

2984828 - SAP Data Warehouse Cloud Release & Delivery Schedule

Keywords

SAP Datasphere, Data Length, Explicit Conversion, Dimension, Error, Data Builder, Views , KBA , DS-MD-VIW , Views , DS-MD-REPO , Repository Backend , Problem

Product

SAP Datasphere all versions