Production sync done with a bug in DEV Model

Highlighted
Occasional Contributor

Production sync done with a bug in DEV Model

Hi,

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?

 

Thanks.

14 REPLIES 14
Highlighted
Master Anaplanner/Community Boss

Re: Production sync done with a bug in DEV Model

@CommunityMember128917 

 

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

Highlighted
Occasional Contributor

Re: Production sync done with a bug in DEV Model

Thanks @Misbah

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?

 

Highlighted
Master Anaplanner/Community Boss

Re: Production sync done with a bug in DEV Model

@CommunityMember128917 

 

Yes if you go beyond your last revision tag you will lose the sync. I think whatever you have is inline with what should be done - unless any other champs have different thoughts

Highlighted
Occasional Contributor

Re: Production sync done with a bug in DEV Model

yes. Thanks.

Highlighted
Master Anaplanner/Community Boss

Re: Production sync done with a bug in DEV Model

@CommunityMember128917,

Let me put my thoughts and check if it works for you.

This seems to be a critical issue and please be aware at any point before doing the Production sync. 

Before you start, please do a COPY and ARCHIVE of the existing Production model to be on the safer side. 

Step 1: Take your PROD model out of Deployed mode and go back to the point before the last Revision Tag as you mentioned. (Note: DO NOT MAKE ANY CHANGES)

Step 2: Export the data from the line item (Mentioned by you in the above thread) and keep it in CSV or TXT. 

Step 3: Get the model back to its original point and put it in the deployed mode (Make sure the Sync doesn't break)

Step 4: Remove the formula from the line item and Sync it with PROD. 

Step 5: Now create a one-time activity action to import the line item data into the module.

 

I hope this will prevent you from either breaking the Sync or Data Loss. Let me know if you have any concerns with this approach. 

 

Regards,
Kavin.
Highlighted
Occasional Contributor

Re: Production sync done with a bug in DEV Model

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?

Highlighted
Master Anaplanner/Community Boss

Re: Production sync done with a bug in DEV Model

HI @CommunityMember128917,

I tried replicating the scenario in my test model and seems to be working fine. Ideally, it should work!

Does anyone disagree?

Regards,
Kavin.
Highlighted
Occasional Contributor

Re: Production sync done with a bug in DEV Model

Thanks Kavin,

 

Community Members can you confirm is you foresee any issue in this approach or if we can take it as an accepted solution to fix the Production Model.

Highlighted
Master Anaplanner/Community Boss

Re: Production sync done with a bug in DEV Model

@CommunityMember128917 

 

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.