Jumbled Process

Hi All,

I have a process named "Import From Data lake SP SG FOM" where lots of actions were placed. For instance, My actions in the following order . Today date.csv and import stock Expiry DC-9205,9209,9207 are to be uploaded files.

When I publish the process in the dashboard and click to upload the files, the upload sequence got jumbled as follows

What should be the upload sequence to be followed for anaplan connect import? However, i tried uploading the sequence as follows via anaplan connect.

I got the following error. What could be the cause of error? any suggestions please?

_2021-02-26 17:35:07 INFO [c.a.client.Service :83   ] 1532 |--
> Initializing Service..._
> _2021-02-26 17:35:07 INFO [a.BasicAuthenticator:26   ] 1532 |--
> Authenticating via Basic..._
> _2021-02-26 17:35:11 INFO [c.a.c.l.LogUtils    :44   ] 1532 |--   = =
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =_
> _2021-02-26 17:35:11 INFO [c.a.c.TaskFactory   :118 ] 1532 |--
> Running Process: Import From Datalake SP SG FOM (id=118000000058)_
> _2021-02-26 17:35:14 INFO [c.a.client.Task     :207 ] 1532 |--   Run
> status: Failed._
> _2021-02-26 17:35:14 INFO [c.a.c.l.LogUtils    :56   ] 1532 |--
> -----------------------------------------_
> _2021-02-26 17:35:14 INFO [c.a.client.Task     :230 ] 1532 |--   !!!
> The operation failed !!! =(_
> _2021-02-26 17:35:14 INFO [c.a.c.l.LogUtils    :60   ] 1532 |--   - -
> - - - - - - - - - - - - - - - - - - -_
> _2021-02-26 17:35:14 INFO [c.a.client.Task     :3880 ] 1532 |--   The
> uploaded file is no longer available; please upload the file again_
> _2021-02-26 17:35:14 INFO [c.a.client.Task     :3880 ] 1532 |--   The
> uploaded file is no longer available; please upload the file again_
> _2021-02-26 17:35:14 INFO [c.a.client.Task     :3880 ] 1532 |--
> errorMessage - The uploaded file is no longer available; please upload
> the file again_
> _2021-02-26 17:35:15 DEBUG [c.a.client.Program :1726 ] 1552 |--

Thanks,

Aish

Accepted answers

ben_speight

It doesn't matter in what order you upload the files using Anaplan Connect, they just need to be all still present (and not cleared out by the 48 hour retention policy) when the process is run. The private vs admins vs everyone option apples only to setting a default file, which I don't think is what you want. Also note that when you run the process from the UI as an end user the files you upload are even more fleeting - only being retained for that run of the process - and are not recognised by API import runs, even by the same user.

All comments

JaredDolich

@aishabhy05

The error you're getting in both scenarios appears to be because the import actions were saved as "Private". That's why it asks you to choose a file. For each import run it again but this time save as "EVERYONE". Name your import with the same name as you have now and it will retain the ID. Then you can run AnaplanConnect scripts using the same file name.

See if that helps!

ben_speight

Quick Links

Can you help?

Unanswered questions

Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?