Anaplan Connect 1.4.4 Export Action Error (Certificate Authentication)

anjanas

Hello, 

 

I am trying to run an export action using Certificate Authentication but i am getting an error. 

Below is my script and the error, any help would be appreciated! 

My script is: 

@Echo off

rem set CertPath="C:\certs\cert.pem"

set KeyStorePath="C:\certs\AC1.4_keystore.jks"

set KeyStorePass="keystorepass"

set KeyStoreAlias="keystorealias"

set WorkspaceId="WorkspaceId"

set ModelID="ModelId"

set Operation=-service "https://api.anaplan.com" -auth "https://auth.anaplan.com" -export "Workspace Usage - Size.csv" -execute -get "C:\Users\anjana.menon\Downloads\Workspace Usage - Export.csv"

rem *** End of settings - Do not edit below this line ***

setlocal enableextensions enabledelayedexpansion || exit /b 1

cd %~dp0

set Credentials=-certificate %CertPath% -keystore %KeyStorePath% -keystorepass %KeyStorePass% -keystorealias %KeyStoreAlias%

set Command=.\AnaplanClient.bat %Credentials% -workspace %WorkspaceId% -model %ModelId% %Operation%

@Echo %Command%

cmd /c %Command%

 

pause

_______________________________________________
While running the script, I am getting the following Error:

 

Absolute path to JAVA 8 or Java 11 or OpenJDK8 executable not provided. Will attempt to figure out path from JAVA_HOME or Windows registry...
Found Java executable from JAVA_HOME "C:\JAVA\jdk1.8.0_201\Jre1.8.0_201", at C:\JAVA\jdk1.8.0_201\Jre1.8.0_201\bin\java.exe...
Current Java version = 1.8
Current Java version is valid for Anaplan Connect.
Running Anaplan Connect...
Using Class-Path: C:\APPS\AnaplanDemo\anaplan-connect-1.4.4\anaplan-connect-1.4.4-jar-with-dependencies.jar
2020-10-05 14:09:52 ERROR 3840 |-- Options are:

 

General:
--------
(-h|-help): display this help
(-version): display version information
(-d|-debug): Show more detailed output
(-q|-quiet): Show less detailed output

 

Connection:
-----------
(-s|-service) <service URI>: API service endpoint (defaults to https://api.anaplan.com/)
(-u|-user) <username>[:<password>]: Anaplan user name + (optional) password
(-auth|-authServiceUrl) <Auth Service URL>: Anaplan SSO server.(-c|-certificate) <CA certificate filepath>: Path to user certificate used for authentication (an alternative to using a key store)
(-pkey|-privatekey) <privatekey path>:<passphrase>: Path to user privatekey used for authentication (an alternative to using a key store) + passphrase
(-k|-keystore) <keystore path>: Path to local key store containing user certificate(s) for authentication
(-kp|-keystorepass) <keystore password>: Password for the key store (if not provided, password is read from obfuscated file 'C:\APPS\AnaplanDemo\anaplan-connect-1.4.4\.anaplan\api-client\keystore-access.txt', or prompted for)
(-ka|-keystorealias) <keystore alias>: Alias of the public certificate in the specified key store
(-v|-via) <proxy URI>: use specified proxy
(-vu|-viauser) [<domain>[\<workstation>]\]<username>[:<password>]: use proxy credentials
(-mrc|-maxretrycount): Max retry count for API calls
(-rt|-retrytimeout): Retry timeout for Http client calls
(-ct|-httptimeout): Http client connection timeout

 

Workspace Contents:
-------------------
(-w|-workspace) (<id>|<name>): select a workspace by id/name
(-m|-model) (<id>|<name>): select a model by id/name
(-F|-files): list available server files in selected model
(-f|-file) (<id>|<name>): select a server file by id/name
(-ch|-chunksize): upload chunk-size number, defaults to 1048576.

 

Data Transfer:
--------------
(-g|-get) <local path>: Download specified server file to local file
-gets Write specified server file to standard output
-getc Write tab-separated server file to standard output
(-p|-put) <local path>: Upload to specified server file from local file
-puts Upload to specified server file from standard input
-putc Upload to specified server file from tab-separated standard input

 

Server Actions:
---------------
(-I|-imports): list available imports in selected model
(-i|-import) (<id>|<name>): select an import by id/name
(-E|-exports): list available exports in selected model
(-e|-export) (<id>|<name>): select an export by id/name
(-A|-actions): list available actions in selected model
(-a|-action) (<id>|<name>): select an action by id/name
(-P|-processes): list available processes in selected model
(-pr|-process) <id/name>: select a process by id/name
(-xl|-locale) <locale> Specify locale (eg en_US) to perform server opertion
(-xc|-connectorproperty) [(<source>|<type>)/]property:(value|?):
specify import data source connection property
(-xm|-mappingproperty) [(<import id>|<import name>)/]dimension:(value|?):
specify prompt-at-runtime import mapping value(-x|-execute): Run the selected import/export/action/process

 

Action Information:
-------------------
(-o|-output) <local path>: Retrieve dump file(s) for completed import/process
-emd: Describe layout of an export (metadata)

 

JDBC:
-----
-loadclass <class name>: This parameter is not required since AC 1.4.4.
It will be removed in next version of AC.
-jdbcproperties: Path to JDBC properties file.

 

_______________________________________________

 

 

 

 

ABerenguela

Hi,

you have commented the CA path:

Remove the "rem"

Regards

 

anjanas

Hi, 

Thank you for your comment. 

The .pem certificate path is not mandatory in this case. That is why i have added rem before this line. 

Can you give me any other feedback for removing this error message. 

 

ABerenguela

why is it not mandatory? 

 

did you replace the values of the variables?

 

 

Misbah

 @ben_speight Can you please help

ben_speight

Remove "-certificate %CertPath%" from the line that sets the Credentials variable.

If CertPath is unset (or empty even) then it will expand to an empty string and the next (flag) argument will be used as the certificate path, and after that the program knows something is wrong and bails out.

anjanas

Hi Ben,

Thank you for the reply.

In my original script "-certificate %CertPath%" was already removed.It was not removed it from this script.Sorry for the mistake.