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. 

aishabhy05_0-1614348874192.png

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

aishabhy05_1-1614349172282.png

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

aishabhy05_0-1614348874192.png

 

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

Best Answer

  • 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.

Answers

  • @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!