Anaplan Connect - Put file gives Array Index Out of Bounds

CommunityMember116379
Occasional Contributor

Re: Anaplan Connect - Put file gives Array Index Out of Bounds

Ran into this issue importing into a list with Anaplan Connect, after many successful runs over a period of months. An increase in volume seems to have introduced the problem. Coincidentally or not, the import file is larger than the chunk. There is only one field in the file. I tried specifying 1 and 0 delimiters in the import definition, and tried with or without a string delimiter. In the anaplan client script call, the chunksize parameter is immediately after model ID. Has anyone else experienced something similar or have other suggestions?

CommunityMember116379
Occasional Contributor

Re: Anaplan Connect - Put file gives Array Index Out of Bounds

Adding a second field to the input file, with a comma delimiter, then updating the import map seems to have resolved the 'Array index out of bounds' error for now.

rahulnair
Occasional Contributor

Re: Anaplan Connect - Put file gives Array Index Out of Bounds

Hello  sean_culligan

 

I am facing "Array index out of bounds" when I import data for the first time then I manually change delimter to comma in Import data source as you mention and it works. But for the first time, delimeter I could see "|" instead ",". When I manually upload file with comma separator it works perfect.  

 

How could I change delimter at first instance ? do I need to specify , in script 

 

set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -chunksize %Chunksize% -file %FileName% -put %FilePath% -import %ImportName% -execute -output "C:\Workspace\Anaplan\anaplan-connect\errors\My Errors.txt"

 

Could you please help me on this 

sean_culligan
Certified Master Anaplanner

Re: Anaplan Connect - Put file gives Array Index Out of Bounds

@rahulnair The delimiter of the file is defined when you 'upload the file' in Anaplan. If you wish to update an existing source file definition go to the actions screen, and select import data sources. Then upload the file again (with the original name).

 

In this screen you should be able to set the delimiter. If you want it to be a comma set it as such. 

 

When you run the import process via the API this uses the file format which was defined. So it should not change based on the data you are importing. If you are really stuck send me a message directly and we can arrange a private conversation on this one. As it may be better to have a quick look at it.

rahulnair
Occasional Contributor

Re: Anaplan Connect - Put file gives Array Index Out of Bounds

Thanks @sean_culligan for the reply. this is resolved, Thanks again!
sean_culligan
Certified Master Anaplanner

abRe: Anaplan Connect - Put file gives Array Index Out of Bounds

@rahulnair thanks for confirming, good to hear it is resolved.

matthew.casper
New Contributor

Re: Anaplan Connect - Put file gives Array Index Out of Bounds

I am getting this error currently.  The processes to upload have not changed; chunk size set to 20mb and after the model ID in the set operation.  File is pipe delimited only ("|") and I get the error regardless of whether the file has 250k records or just 85k.

 

Any steps or pieces to check would be greatly appreciated.  Using Anaplan Connect 1.4.2