List Hierarchy Update Failure

Monpero · 2024-01-03T11:29:55+00:00

There was an error rendering this rich post.

Hi All,

I am trying to update a composite list hierarchy with 2 levels they are both Numbered List.

In the source module the List being imported are NOT a numbered List only in the PROD model it is set to a Numbered List.

Here is the Parent List and Code is concatenated with _L1

Below is the child list that Rolled up to the Parent List

When I tried to update the child list I keep getting an error

I have mapped the action with the Parent and also tried the parent code but it is still not working and I have used the "TRIM" function on the concatenated Code just to remove any space but I'm still getting error.

Please any suggestion as to why I keep having the issue and any workaround to resolve the issue.

Accepted answers

All comments

Dikshant

@innocent,

Does your list have a parent configured?

If yes, is it the Budget List or something else?

Try to manually search for those Budget codes?

andrewtye

@innocent - is the budget to project a one to one mapping? if it isn't then you'll need to have the project code as combination of budget & project codes so to create unique instances, you don't need to have the L1/L2 elements. This is because you can't have two codes of the same thing.

Monpero

@Dikshant Thanks for the response. The budget to project is a one to many mapping. many project ID rolls up to one Budget Line ID and the Budget Line ID has a top level.

@andrewtye - Thanks, I'll give it a go and see if that works

Monpero

Hi guys - I implemented some changes by removing some of the list items (P2 leafs in this case) that was causing an error. and ran the action and it worked in the DEV

after syncing to the PROD and ran the action in the PROD, it throws an error even though it work perfectly well in the DEV.

Please guys any suggestions on how to fix this issue?

@andrewtye - I tried concatenating the project codes with the parent list name, yet I was having error with importing with that method.

The P2 list L2 makes it unique and not same as parent with L1. what could possible be wrong, any idea?

Dikshant

@innocent, Can you share the production error logs. Since the list is production data, the items will be different in Dev and prod and hence causing the failure. Can you read the logs and see the parent ID which is failing, actually present in the parent list or not? Similar activity which you have done in DEV.

Monpero

Hi @Dikshant, here below is the print of the error log. As you can see they are not similar names with the parent.

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…