Hi OutSystems community,
While troubleshooting an issue that was preventing us from deploying, it seems that a new module was inadvertently created, resulting in the loss of all our data. Upon inspecting the Espace entity, I noticed that there are now three modules, with module ID 1429 being the correct Product_CS. I have verified this by examining the version history. The currently active Product_CS has only one version, whereas the Product_CS with ID 1429 has multiple versions that align with the work we performed on that specific day.
I have already explored potential solutions on the forum, but due to concerns about permanently losing data, I wanted to seek advice again on how to properly restore the correct Product_CS module. What are the correct steps for this process? And can I be assured that restoring the Product_CS we believe to be correct will also re-establish the data mapping correctly?
Thank you in advance for your assistance!
Best regards, Bart
Hi Bart,
Each module _Cs has created internally different database physical tables.
If you publish version 1429,that will enable that eSpace and physical database tables as well. You will need to update the definition on all the consumers.
To look for the extsting physical table names use system table OSSYS_ENTITY
https://success.outsystems.com/documentation/how_to_guides/data/data_migration_from_production_to_non_production_environment/outsystems_platform_metamodel
and look for the entity name, should retrieve all physical tablenames, active and inactive.
There use the component to query the data
https://www.outsystems.com/forge/component-overview/369/sql-map
Hope that it helps you
Hi Alexandre,
Thanks for your reply :-)
So if I am able to get version 1429 and I publish it again it will get my data back aswell if I understand you correctly?
I found this forum post where Daniel Kuhlmann is telling the steps to recover a module that is no longer in service studio. Is this the correct way to do this you think?
I also created a test where I deleted a CS module with some test data in it and did the steps mentioned in the forum post. This recovers the module but the data is still gone and it seems to create a new module again.
Best,
Bart
Please check the physical table name for the deleted entities using the OSSYS_ENTITY system table name.
Use the sql map component to query about the content.
If you did a test and did not recovered the data you can check this way the data. I thought that the data would remain but let's confirm in the physical table itself.
I will check the component to see if the data is still there. It could also be that I did do it incorrectly, since you can see in the screenshot that a new module with a new id is created. So my 'old' module is still not active and I think therefor the date is not being shown.
For my usecase I didn't deleted the eSpace it was another one with the same name. Let's hope you can retrieve the data.
Regards