Anaplan Connect Error

Hi All,

I have an issue while uploading the file via Anaplan connect. Following is a snippet of the error.
>
> _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 |--

However, the file is available in the storage location. Any suggestions? Please note that source label names are matching. While I was configuring the import action, I made as Keep private. Will this impact? If yes, any possible ways i can change back to admin?

Thanks,

Aish

Accepted answers

JaredDolich

@aishabhy05

It appears that the file is no longer there. If you uploaded it in the last 48 hours then let's try another approach. Let's take a look at your Anaplan Connect Script. Let's make sure you're import file name is the same as the import data source (the name of the file you used to create the import action).

Now, I use the command window in Windows but your Script should look something like this:

There are 3 really import switches that have to be set (I highlighted them in red for you)

File | This must be the name of the file in ANAPLAN that you used to create the action in the first place. Check Import Data Source to validate.
Put | This is the location of the file you want to import. Ideally, it will have the same name and I believe this is a best practice.
Import | this is the name of the action that you created using the File above.

See if that helps!

@echo on
rem ---------------------
rem Instantiate Variables
rem ---------------------
set AnaplanUser="Your ID"
set WorkspaceId="Your Workspace"
set ModelId="Your Model"

rem ---------------------------------------------------
rem Import File to Anaplan
rem ---------------------------------------------------
set Operation=-service "https://api.anaplan.com" -auth "https://auth.anaplan.com" -file "SKU Trans.csv" -put "C:\Temp\Citi Trends\SKU Trans.csv" -import "002_MD_HISTORY_ KEYS_LIST" -execute -output "C:\Users\jdoli\AnaplanConnect\Errors.txt"

rem *** End of settings - Do not edit below this line ***
setlocal enableextensions enabledelayedexpansion || exit /b 1
cd %~dp0
if not %AnaplanUser% == "" set Credentials=-user %AnaplanUser%
set Command=.\AnaplanClient.bat %Credentials% -workspace %WorkspaceId% -model %ModelId% %Operation%
@echo %Command%
cmd /c %Command%
pause

All comments

Misbah

@aishabhy05

If you wish to load the source file again then go to Actions->Import Data Source->New Source ->Upload New File (make sure that the name of the file matches with the file that was loaded earlier)

I would have said since it is past 48 hours you need to upload the file again. But this made me think otherwise. @ben_speight what is the correct behavior here?

https://help.anaplan.com/ebc01b56-7b57-4e36-93de-acfdb75a8441-Overview-of-Private-and-Default-Files#Access2

Misbah

ben_speight

Normally you upload the file(s) and then run the process in a single command. Any file uploaded via the API is a private copy and will be removed after 48 hours.

aishabhy05

@ben_speight , @Misbah I have to reupload the source file with "Set as Default" to everyone to avoid the error? Is my understanding correct?

JaredDolich

@aishabhy05 You got it!

aishabhy05

@JaredDolich But still the same error. Any inputs please?

JaredDolich

@aishabhy05

Now, I use the command window in Windows but your Script should look something like this:

There are 3 really import switches that have to be set (I highlighted them in red for you)

File | This must be the name of the file in ANAPLAN that you used to create the action in the first place. Check Import Data Source to validate.
Put | This is the location of the file you want to import. Ideally, it will have the same name and I believe this is a best practice.
Import | this is the name of the action that you created using the File above.

See if that helps!

@echo on
rem ---------------------
rem Instantiate Variables
rem ---------------------
set AnaplanUser="Your ID"
set WorkspaceId="Your Workspace"
set ModelId="Your Model"

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?