SAP HANA XSA SPS 12.1 HRTT: Deleted Objects (Tables and Procedures)

[draschke]

Hi,

I tried to change columns name within cds tables (WebIDE).

Because I wasn't able to build it (dependencies with procedures) I decided in the end to delete the tables and procedures with HRTT - Toll (Webeditor).

But now, if I try to build the tables which I deleted before, they will not be created anymore. I can build it successfully, but the tables aren't there.

(I took the procedure out, which caused the problems)

Was it wrong to do it with the HRTT Tool?

And one more question, how can I delete all my deployed objects?

[thomas_jung · Accepted solution]

>Was it wrong to do it with the HRTT Tool?

Yes.  Directly deleting catalog objects generated by CDS has always been a bad idea.  Old repository or HDI, this situation remains.  CDS contains metadata about the state of the catalog objects which gets out of sync if you directly alter/delete the runtime catalog objects. Instead comment out the object in the hdbcds file or change file extension and deploy.  This will safely drop the runtime objects. In the upcoming HANA release this also gets a bit easier because we can selectively deploy individual objects instead of always the entire HDB module.

[draschke · Accepted solution]

Hi Thomas,

I was trying everything, before I've chosen this way.

But there was really a strange behavior with a procedure, which caused the problem.

Ok, I'm not able to do create my whole project anymore, tables are missing.

Is there a way to delete all deployed objects to get it clean again?

Thanks a lot!

[thomas_jung · Accepted solution]

You might try deleting the HDB service which should delete the container.  Or renaming the service which would result in the creation of a new container instance.

[draschke · Accepted solution]

Please, could somebody tell me exactly what to do if I'll delete or rename my service.

Don't want influence the other container.

Thanks a lot!

[Former Member · Accepted solution]

I would try renaming first, that way you can revert to the old one if you see any issues.

Regards,

Omer.

[draschke · Accepted solution]

Hi,

if I want to rename only my container, how does it work?

xs rename DIRASCHK-2uuqxcacoifttcx4-TBASE-hdi-container ...

Thanks for your help!

[Former Member · Accepted solution]

Hi,

Try to change the name of the hdi container name in the mta.yaml (in web IDE) and then rebuild the db module.

Regards,

Omer.

[draschke · Accepted solution]

Hi Omer,

did it, but the system creates only a new container and the old one is still there.

The old one doesn't 'll recreated. But I need the old hdi-name, because all my colleagues are working on the same one.

How can I delete the old one?

BR,

Dirk

[Former Member · Accepted solution]

If you want to delete a service you can use the xs command ("xs ds", run "xs help ds" to get more information about it).

When working in Web IDE on a certain db service - web IDE generates a unique service per user per project - meaning if another user in another web IDE workspace is working on a mta.yaml with a same name - he/she are actually using one which is specific to them.

Regards,

Omer.

[draschke · Accepted solution]

Thanks Omer,

this (xs ds) is what I was looking for!

BR,

Dirk