Import Rejection Limitation?

Hi Community! One of my clients asked me a question I wasn't sure about. Thought I'd ask here.

Using AnaplanConnect does anyone know of a limitation of how many rows can be rejected before the entire action is rejected?

I'm not aware of any limit but wanted to see if I missed something.

Adding Pros @DaanishSoomar @MarkWarren @ben_speight @rob_marshall

Accepted answers

DaanishSoomar

I see @JaredDolich.

What I would do here is:

1) With you by their side, have the client log into Anaplan. Open the model. Run the action or process that is of interest. See what happens in the manual run. Does the data load properly?

If no, then herein lies the issue. The below info on encoding might apply as well, but I would double check first to see if the action is mapped and setup correctly.

If the data runs manually, and it’s only an Anaplan connect issue, then I would begin to explore the import menu with the encoding options. There are some issues with regards to UTF-8 vs UTF-16 in certain versions of Anaplan Connect where there are issues of files not loading correctly or having issues with special characters.

The latest version of Anaplan Connect is better at encoding since the dev team has addressed those bugs in the latest release. I had a client with a similar issue and downloading the latest version solved the issue.

Here are some articles that might be good to look at:

https://help.anaplan.com/en/fa793649-8953-4c60-9e04-71e077ff21f3-Tips-for-importing-special-characters

https://community.anaplan.com/t5/Anaplan-Platform/Anaplan-Connect-1-4-Import-Issue/td-p/38277

ben_speight

There is a limit to the size of an error dump file - 50000 rows. But when this is hit, the importer hasn't given up importing, but reporting individual errors to the dump file (so the summary of errors should remain accurate).

All comments

DaanishSoomar

Hmm @JaredDolich,

This is an interesting question.

Some clarifying questions:

1) When they run the action manually, are there error messages? If so, Anaplan Connect is simply automating what happens in the manual environment through its own interface.

So in practice the result should be the same for what happens in the manual run.

I am not aware of any limit either.

However, depending on the size of the file, there are some chunking related issues where if the file is large, the import might get halted halfway through or something like that. You will need to raise the chunksize.

Loading the file in chunks can help improve the load times. Here’s an article that breaks down the details.

JaredDolich

@DaanishSoomar

Yeah. The client has not tried to load manually. Only through Anaplan Connect. The files are extremely small, no more than 10 rows. Seems it allows one record rejection but more than one it fails the entire action. My hunch was that it was a formatting issue and unfortunately the client didn't save the files so I can't validate. We were just curious if anyone knew of a limitation because ultimately, the import will be closer to 150,000 rows. Thus, the concern.

DaanishSoomar

I see @JaredDolich.

What I would do here is:

1) With you by their side, have the client log into Anaplan. Open the model. Run the action or process that is of interest. See what happens in the manual run. Does the data load properly?

If no, then herein lies the issue. The below info on encoding might apply as well, but I would double check first to see if the action is mapped and setup correctly.

Here are some articles that might be good to look at:

https://help.anaplan.com/en/fa793649-8953-4c60-9e04-71e077ff21f3-Tips-for-importing-special-characters

https://community.anaplan.com/t5/Anaplan-Platform/Anaplan-Connect-1-4-Import-Issue/td-p/38277

JaredDolich

@DaanishSoomar

Thank you! We'll give that a try.

DaanishSoomar

No problem @JaredDolich!

ben_speight

DaanishSoomar

Great insight @ben_speight!

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
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…