When we make a Production move and down the line 2 weeks, we get to know the production moved with an error, and there is lot of data added by the client in this time, what would be the best possible ways to fix the issue?
1.Move the production back to the last revision, fix the Dev and do a sync again? but then there will be lot of data loss.
2.Is it recommended to move your production model back in history through restore ID? Or it should always be to the last revision tag. Is there any disadvantage to restore it to some restore ID, does the Dev and Prod sync gets break doing this?
With both these approaches either you will lose the data or you will break the sync. I was thinking of creating new Dev Model from the current Prod Model. Not sure what kind of error are you getting. Can you please detail it out
Actually a line item was initially a User Input which was pushed as a formula in sync, which triggered the data loss for the line item. To fix that we pushed back the production model to some restore ID (there was a data loss doing this), and then the production and development model ALM got break and then to fix that we had to create a fresh Dev model from the Production and redo the development.
Yes, the data loss was there. But is it if we take the production model back in history through Restore ID instead of Revert to Last revision the ALM breaks?
Thanks Kavin, I believe this could be a better approach, until and unless the Sync don't break.
Have you ever tried this approach where you change the Production to standard and revert the model beyond the last revision and then reverted back the model to current state and move the model to Production and still the sync remains intact?
Since the sync is already broken in your case new Dev model is required after all. Which brings me to the point how Important it is to use Copy & Archive option to Archive your models on a daily basis as part of your Disaster Recovery Process.
Since the intention is to get back the input values from an end user you would have unarchived that model and take out those numbers and load those into you current production model.