Hi,
I am currently having issues with my script using Anaplan connect and I hope someone could help me with this.
The error I receive is:
“ERROR 12476 |-- Imports not found: Imports not found for Model-ID=8954E749858F4CEEB35EBD5BFB54595B
(Feign: status 401 reading AnaplanAPI#getImports(String,String,int); content:{"status":{"code":401,"message":"Not Authenticated."}})E:\GMS_Anaplan\anaplan-connect-1-4-2>”
I already checked the “obvious” things: model id matches, import action name and file name are correct.
Would you be able to advise me on:
- Did the script actually passed the authentication phase? In the run logs that is the log just before the error code on the import (see attached)
- Do you see a mistake in the script? (see below)
- Could this error be related to the file option default file? currently I have set this to "Everyone'.
Thank you for your help!
Script:
REM @Echo off
rem For details of how to configure this script see doc\Anaplan Connect User Guide.doc
REM ###########################
set CertPath="E:\GMS_Anaplan\anaplan-connect-1-4-2\certs\AnaplanGMSCertPublickey.pem"
set PrivateKey="E:\GMS_Anaplan\anaplan-connect-1-4-2\certs\AnaplanGMSCertPrivatekey.pem:"
set WorkspaceId="8a81b09e603d355d016149ba8d6e67ce"
set ModelId="8954E749858F4CEEB35EBD5BFB54595B"
set JAVA_HOME=E:\GMS_Anaplan\jre1.8.0_144
set ServiceUrl="https://api.anaplan.com"
set AuthUrl="https://auth.anaplan.com"
set Chunksize=40
set FileName = "MOS_Actuals_BU_Rate.csv"
set FilePath ="E:\GMS_Anaplan\UploadtoAnaplan\MOS_Actuals_BU_Rate.csv"
set DumpName ="E:\GMS_Anaplan\UploadtoAnaplanMOS_Actuals_BU_Rate_Error.txt"
rem set Operation=-certificate "E:\GMS_Anaplan\anaplan-connect-1-4-2\DevCerts\KZDWORAEPMD04.corp.zoetis.com.cer" -export "Export_APO_AOP New" -execute -get "E:\ANAplan_APO\APO_Data\AOP\Export_APO_AOP.txt"
rem *** End of settings - Do not edit below this line ***
set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -chunksize %Chunksize% -file %FileName% -put %FilePath% -import "2. Upload HFM Actuals at Budget Rate from file" -execute -output %DumpName%
set Credentials=-certificate %CertPath% -pkey %PrivateKey%
setlocal enableextensions enabledelayedexpansion || exit /b 1
cd %~dp0
REM set Command=.\AnaplanClient.bat %Credentials% -workspace %WorkspaceId% -model %ModelId% %Operation%
set Command=.\AnaplanClient.bat %Credentials% -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -chunksize %Chunksize% -file %FileName% -put %FilePath% -import "2. Upload HFM Actuals at Budget Rate from file" -execute -output %DumpName%
@Echo %Command%
cmd /c %Command%