Occasional Contributor

Data Import unsuccessfull

Hi Experts,

 

I have 3 models, 1.Data Hub, 2.Dev, 3.Test model.

I am changing my list item name in list(numbered list) in my data hub model and running the import action("ABC list from data hub) from Dev model to see the changed list item name is updated or not? and it is getting success, I am able to see the changes.

Now, I am running the same action("ABC list from data hub) in my Test model(which is in deploy mode), but I'm not seeing any changes updated to the list in Test model.

 

Note: when I was running the import action in my test model, I am getting the error saying "An internal error occurred and properties were not updated", I have checked the properties in both data hub model and test model are little different, the peoperty names are available and same in both, but in formula tab the formulas are missing in test model.

 

As per my understanding, Now I need to update the properties to the list in my test model. please correct me this line if I am wrong. If yes, then how to update the properties in a list which my test model is in deploy mode.

 

Thanks

SK

 

 

12 REPLIES 12
Regular Contributor

Re: Data Import unsuccessfull

If you have made changes in your data hub, and these are not reflected in your test model it will cause a failure. You must make the change in the dev model, then sync your test and dev models (I assume you are using ALM in this instance). This will update the structure of your deployed test model so you can successfully import from the hub.



Jesse Wilson
Solution Architect - Data Integrations
Singapore
Occasional Contributor

Re: Data Import unsuccessfull

Hello Jesse,

Thanks for quick around,

Yes, I am using ALM process:
1. Created the revision tag in data hub model.
2. Both modules are offline.
3. while I am clicking the Compare & Sync, I am getting the below error.

error: "No compatible models with revision tags found"

And could you please tell me how do I attach the screenshots here.

Thanks
Sasikanth
Regular Contributor

Re: Data Import unsuccessfull

If there are no compatible models, that would suggest a change was made to your "test" model after you copied it from your "dev" model, which broke the sync. You can look through the history to track back to any model changes and restore a point prior that that, which should bring them back in sync.

 

To attach screenshots, there is a button "Choose Files" under the commend box, to the left of the "Cancel" and "Post" buttons, or you can insert a photo into your reply directly. (See attached) 



Jesse Wilson
Solution Architect - Data Integrations
Singapore
Occasional Contributor

Re: Data Import unsuccessfull

Hello Jesse,

Got your answer,

Now as per my requirement I cannot do ALM from data hub model to test directly.... So again I am coming back to my question.

in my dev model and test model properties are same, the import action is working fine in my dev model which is pulling the data from data hub to dev, whereas the same import action is not working to my test model which is pulling it from same dev model.

Thanks
Sasikanth
Community Boss

Re: Data Import unsuccessfull

What is the error you are now getting?

 

Have you set up this list as a production list in DEV?, if not, so won't be able to update this from the Hub

 

Could you upload some screen shots of the various stages, it will hlep diagnose the problem

 

David

Occasional Contributor

Re: Data Import unsuccessfull

Hello david,

I have 3 models, 1.Data Hub, 2.Dev, 3.Test model.

I am changing my list item name in list(numbered list) in my data hub model and running the import action("ABC list from data hub) from Dev model to see the changed list item name is updated or not? and it is getting success, I am able to see the changes.

Now, I am running the same action("ABC list from data hub) in my Test model(which is in deploy mode), but I'm not seeing any changes updated to the list in Test model.

 

Note: when I was running the import action in my test model, I am getting the error saying "An internal error occurred and properties were not updated"

I am attaching the screenshots for your reference.

Community Boss

Re: Data Import unsuccessfull

@Sasikanth.Busanagari ,

 

So the problem is you don't have the lists marked as Production Data lists (https://help.anaplan.com/anapedia/Content/ALM/Model_Data/Production_Lists.html?_ga=2.70104082.327250...)

 

Essentially, when you are in Deployed mode (ALM), you have the option to mark the list as a Production Data List or not.  What does this mean?  If it is NOT marked as a Production Data List, it means the structure of the list as well as all list members get synced from dev, but it can't be updated by an action in Deployed mode.  If the list IS marked as a Production Data list, it means the structure will sync, but not the members.  With that said, the members of the list will be able to be updated via an action in the deployed model.  Think of it this way:

 

Indicator List with members of Yes and No.  Usually, you will not have a lot of change in this from Prod source systems or this is an Anaplan specific list that does not change, so this would be a perfect candidate for a Non Production List.

 

Transactional List which stores the transactional data:  Since the volume changes based on the source system (Prod source system), this would be a candidate for a Production List as the data would/could vary from Dev to Prod.  And, you will need to update this, in your Anaplan Prod module.  Another example would be your Product hierarchy.  Again, since it can change/vary, and needs to be updated from your source system, this most likely should be a Production List.

 

Hope this helps,

 

Rob

Occasional Contributor

Re: Data Import unsuccessfull

Hi Rob,

 

Thanks for the detailed description,

 

Now I have got the new problem while I was enabling/marking the production data? in my dev model, I am getting this below error.

 

Error.PNG

Community Boss

Re: Data Import unsuccessfull

@Sasikanth.Busanagari ,

 

So it looks like you have a logic error which is using or hardcoding to a certain member.  So, look for the following:

  • Using a Select statement to that member
  • Using the statement If item(list) = that member
  • Do you really need that line item as it looks like a Test.

The reason for this error is you can't always be sure that member will actually be there (from Dev to Production) since they are able to load/modify/delete data to that list.  We cannot allow the user to create a rollback of a model in Deployed mode by deleting a member that is referenced or hardcoded elsewhere.  To get around this and IF you still need this line item, then you can create a SYS module where you have a line item formatted as that list (where the member is entered) and you can use lookup's off of that.

 

Hope this helps,

 

Rob