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

Accepted answers

DavidSmith

@CommunityMember82499

Check out these articles for more information on how to model around formula protection

https://community.anaplan.com/t5/Knowledge/Setting-production-lists/ta-p/19284

https://community.anaplan.com/t5/Knowledge/Production-lists-and-ragged-hierarchies-logic/tac-p/37713#M158

David

All comments

jesse_wilson

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.

CommunityMember82499

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

jesse_wilson

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)

Screen_Shot_2019-03-28_at_16_43396.png

Screen_Shot_2019-03-28_at_17_43396.png

CommunityMember82499

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

DavidSmith

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

CommunityMember82499

Hello david,

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

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.

Data_Hub_Model_-_Congfig_Tab_43400.PNG

Data_Hub_Model_-_List_properties_43400.PNG

Dev_Model_-_Config_Tab_43400.PNG

Dev_model_List_Properties_43400.PNG

Error_Log_-_while_running_the_import_action_43400.PNG

Test_Model_-_Config_Tab_43400.PNG

Test_Model_List_Properties_43400.PNG

rob_marshall

@CommunityMember82499 ,

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.327250813.1553517470-843645507.1553517470)

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

CommunityMember82499

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.

rob_marshall

@CommunityMember82499 ,

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

DavidSmith

@CommunityMember82499

Check out these articles for more information on how to model around formula protection

https://community.anaplan.com/t5/Knowledge/Setting-production-lists/ta-p/19284

https://community.anaplan.com/t5/Knowledge/Production-lists-and-ragged-hierarchies-logic/tac-p/37713#M158

David

CommunityMember82499

Hi David/Rob,

Thanks for your detailed description with perfect documentation, those documents are really very helpful, Thank you once again.

Regards

CommunityMember82499

Hi David/Rob,

Thanks for your detailed description with perfect documentation, those documents are really very helpful, Thank you once again.

Regards
SK

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…