Anaplan Connect 1.4.4 Export Action Error (Certificate Authentication)

Highlighted
New Contributor

Anaplan Connect 1.4.4 Export Action Error (Certificate Authentication)

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.
 
_______________________________________________
 
 
 
 
6 REPLIES 6
Highlighted
Frequent Contributor

Re: Anaplan Connect 1.4.4 Export Action Error (Certificate Authentication)

Hi,

you have commented the CA path:

ABerenguela_0-1601971235059.png

Remove the "rem"

Regards

 

Highlighted
New Contributor

Re: Anaplan Connect 1.4.4 Export Action Error (Certificate Authentication)

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. 

 

Highlighted
Frequent Contributor

Re: Anaplan Connect 1.4.4 Export Action Error (Certificate Authentication)

why is it not mandatory? 

 

did you replace the values of the variables?

 

ABerenguela_0-1601988513382.png

 

Highlighted
Master Anaplanner/Community Boss

Re: Anaplan Connect 1.4.4 Export Action Error (Certificate Authentication)

 @ben_speight Can you please help

Highlighted
Community Boss

Re: Anaplan Connect 1.4.4 Export Action Error (Certificate Authentication)

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.

Highlighted
New Contributor

Re: Anaplan Connect 1.4.4 Export Action Error (Certificate Authentication)

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.