Showing results for 
Search instead for 
Did you mean: 
SAP Community Log-in Update
In a few months, SAP Community will switch to SAP Universal ID as the only option to login. Don’t wait, create your SAP Universal ID now! If you have multiple S- or P- accounts, use the Consolidation Tool to merge your content. Get started with SAP Universal ID now!

CAP - DB Deployer failing after renaming a column of an entity


Hi everyone,

I made a spelling error in a column of an entity in schema file. After renaming the entity, when I try to deploy the artifacts, it is failing with the following error: Database error 287: cannot insert NULL or update to NULL: EMPDIGITALID: line 1 col 1 (at pos 0)

Can someone help. Thanks!!


Accepted Solutions (0)

Answers (1)

Answers (1)


Hi @Mohit_Agarwal 
Thank you for bringing this to our attention.

To help us to understand your query better, could you please provide the following information?

  • Title or URL of the SAP Learning Journey and the exercise (title/number) you are referring to 
  • Screenshots: To help us visualize the issue


Thank you


Hi @Margit_Wagner ,

Pardon me if this is not the right place to ask this question.

This is not a part of any SAP Learning Journey but purely related to Domain modelling in CAP which comes under BTP Extension Suite Learning Journey.

If you look closely, in order entity, earlier it was 'empdigitialid'. Now, I have corrected it to be 'empdigitalid'

Old schema:


Updated schema:


Log file:


Link to log file: cafti-cds-db-deployer.log

Please let me know if you need any other details.



Hi @Mohit_Agarwal
Unfortunately this topic isn't specifically covered here and since it can hardly be answered from our side, I can point you to several excellent resources to help find an answer to your question.

I would like to encourage you to post this question to a our SAP Community where you can directly exchange with experienced experts with project Background -  SAP Community is a public space where anyone can start discussions and questions are answered by anyone.

SAP Community enables professionals across the globe to connect, exchange information, engage, and receive recognition for your achievements. This inclusive and receptive environment welcomes all individuals who want to seek help and share knowledge about SAP software and solutions.

If you need help, and your issue is specific to the standard functionality of your SAP solution, contact SAP Product Support using the channel listed below which best suits your business impact

Please check

Please always feel free to come back to our SAP BTP Learning group to ask your questions related to our  Learning Journeys or to our certification published on SAP Learning  and collaborate with other learners to reach your learning goals and to prepare for your SAP Certification exams. However, for your particular question, I'd recommend the resource above.

I hope this helps, and best of luck!


I hope this helps, and best of luck!