I am facing issue in receiving data from Informatica cloud

anitha123

Hi ,

I am receiving the below error .please let me know the reason.

Error in Anaplan.png

I am not getting data into target module.I am not understanding what is the issue

Accepted answers

All comments

seymatas1

Hi Anitha,

It looks like the mapping for your import action got broken. Here are some simple troubleshooting steps to help you fix it:

Open your data file, IC_BU_Actuals_NPNL_csv, and check the column names.
Open your target model, likely a data hub model.
Go to Modules and open DAT013c.
Compare the column names in your file with the line item names in the module. If they don’t match, it means either the file or the module line items were changed. You can either update the file or the line items to match, or map them manually.

Here’s how to manually map:

Go to Actions, find Import into DAT013c BU Actuals action.
Click Edit.
Go to the Line Items tab. You’ll see the line item names like GROSS_MARGIN, OPERATING_MARGIN, NET_REVENUE_SNOW_Asset_License, etc.
Map each column manually to the correct line item.

Note: Anaplan is not case-sensitive, so no need to worry about upper or lower case mismatches.

I hope this helps.

Seyma 🌷🙂

anitha123

Hi Seyma,

Actually the issue was between Informatica cloud and anaplan.the issue was resolved after unique id mapping in Informatica end but no records are flowing into anaplan.Manual uploads done in anaplan is working.The last action showing 0 successful rows

{C6B73891-22C7-4CD2-9C32-924DD7248D1A}.png

Quick Links

Can you help?

Unanswered questions

How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
How to use Client ID and Client Secret for API request directly?
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
New UX Filtering for Hierarchy sibling
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…