Error while exporting error dump from Informatica

Hi,

I'm using informatica cloud for importing from source system to Anaplan Module. The error dump is exported to a windows server to view incase there is an error in the import. Error dump is exported in csv format. But incase of an error in import when the error dump is being exported I get the following failed notification along with this error in Informatica. What could be the reason? I have previously run the same action successfully in other import jobs but now getting this error.

Accepted answers

All comments

JaredDolich

@Shawnm

Ah, we'll have to put on our detective hat. I see two possible reasons.

Most likely the import module mapping or the format of the .csv for the import has changed. Make absolutely sure the the .csv is formatted the same as the mapping in the import action. To make sure, re-import the .csv manually, make sure you save the import as "everyone", and name it the same import action as before. Also, confirm the mapping is correct.
There's an outside chance this is an authentication issue. Double check that the email you are using can log into Anaplan if you are using basic authentication. Also, double check that that same email has access to the module and has any selective access at the top level.

See if any of these ideas help. Let me know.

Shawnm

Hi @JaredDolich

Thanks for replying. I save the import as "admins only" does that impact the error dump export? Rest everything you mentioned I have checked already- mapping, connections everything is correct.

JaredDolich

@Shawnm Admin only is fine. Just make sure the default import file is the one being used. If everything checks out, I would strongly suggest rebuilding the import action, again save as "admin", rename it and change your Informatica script to point to the new import action instead. Let's see if that helps. If not, we'll have to call in the pros to decipher the error message. The only clue I see here is the header mismatch which suggests the headers in the import file are not the same as what's in the .csv (or the mapping).

Shawnm

Hi @JaredDolich , The headers are actually matched correctly. The error also mentions not able to connect to native system. I have run similar actions in the past but suddenly when I try to do the same for another import I started to get this error.

JaredDolich

@Shawnm I've heard of this error before and it required a rebuild of the import action. Did you try that? Give support@anaplan.com a shout out too. I see some known issues regarding Informatica, here's one suggestion: Workaround: Edit and re-save (no changes required) any pre-existing Informatica jobs and try re-running them.

Shawnm

Hi @JaredDolich ,

I tried rebuilidng the actions. This issue is happening only when exporting error logs for an import action in Anaplan.For every import action there is a errordump in Anaplan which when exported shows us the incase there are any errors in the import. When there is no error the error dump gets exported through informatica with no issues. But when there is an error this failed notification is coming up. Even the error log export actions that were working before is showing the same error.

JaredDolich

@Shawnm let's call in some of the pros @ben_speight @DaanishSoomar @Misbah and @rob_marshall

DaanishSoomar

Hello @Shawnm,

Being former Anaplan Support, I know Support had a dedicated team member who is an SME on Informatica. That may be your best route as they’ll also have visibility into previous cases and resolutions.

rob_marshall

@Shawnm

Give this a shot...Run the import action from within Anaplan and see what the issue is...I am wondering if there are some special characters that Informatica is having issues with.

Rob

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385