Anaplan Connect Import, ERROR: Cannot determine Java version.

Hi!

This is my first time using Anaplan connect. I am running a basic authentication to execute an import list action on Windows.

Below is my script:

@echo off
rem This example loads a source text file and runs an Anaplan import into a module.
rem For details of how to configure this script see doc\Anaplan Connect User Guide.doc
set AnaplanUser="myemail@slalom.com:mypassword"
set WorkspaceId="8a81b08e664b157b0166a7dcefb7597d"
set ModelId="E72AA61272A8496AB1C91B558A2E30AE"
set Operation=-file "EmployeesTest.csv" -put "C:\Users\jonathan.edwards\Documents\EmployeesTest.csv" -import "Employees from EmployeesTest.csv" -execute -output "C:\Users\jonathan.edwards\Documents\My 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

I receive the following error when it runs:

.\AnaplanClient.bat -user "myemail@slalom.com:mypassword" -workspace "8a81b08e664b157b0166a7dcefb7597d" -model "E72AA61272A8496AB1C91B558A2E30AE" -file "EmployeesTest.csv" -put "C:\Users\jonathan.edwards\Documents\EmployeesTest.csv" -import "Employees from EmployeesTest.csv" -execute -output "C:\Users\jonathan.edwards\Documents\My Errors.txt"
Absolute path to JAVA 8 executable not provided. Will attempt to figure out path from JAVA_HOME or Windows registry...
JAVA_HOME is not defined, will attempt to fetch value from registry...
Checking Windows Registry for Java Version...
ERROR: Cannot determine Java version.
Press any key to continue . . .

After it runs, it does not complete the import. What do I need to do to fix this error? Any help is appreciated.

Jonathan

Accepted answers

sean_culligan

Dear Jonathan,

I looks like your JAVA_HOME environment variable has not been configured. If you have installed Java already, you may just need to set the variable. If you do a quick google of set java_home environment variable there are plenty of guides available.

Kind Regards,

Sean

All comments

sean_culligan

Dear Jonathan,

Kind Regards,

Sean

jnoone

Hi Jonathan - there are two options: you can update the variable definition in the anaplan client (AnaplanClient.bat) from %JAVA_HOME% to !JAVA_HOME! in line 42 (screenshot attached) or alternatively set JAVA_HOME="Your Java location" in your environmental variables as mentioned.

The issue is that Anaplan Connect 1.4+ has a hard time finding the correct Java installation location. By setting the location in the script, or modifying the AnaplanClient.bat file, you allow Anaplan Connect v1.4+ to locate the Java installation successfully and complete the script.

Hope this helps.

java_update_48440.jpg

jonathan.edwards

Thank you! This was very easy to do. Here are the instructions I followed for anyone else who is having a similar issue.

https://confluence.atlassian.com/doc/setting-the-java_home-variable-in-windows-8895.html

matthewkuo

Thank you. This solution worked for me too.

Best,
Matthew

DaanishSoomar

The latest version of Anaplan Connect should have solved for this error. Consider upgrading to the latest verison if you have not already.

For older versions, utilizng Windows, Lines 123-125 in the Anaplan Client.bat are missing 3 zeros. This solved the issue for numerous clients I have worked with back while I was in Anaplan Support.

rem Check registry for JDK
:FIND_JAVA_VERSION
echo Checking Windows Registry for Java Version...
for /f "skip=2 tokens=2*" %%a in ('reg query "HKEY_LOCAL_MACHINE\Software\JavaSoft\Java Runtime Environment" /v CurrentVersion 2^>nul') do set CurVer=%%b
if "!CurVer!" equ "0" for /f "skip=2 tokens=2*" %%a in ('reg query "HKEY_LOCAL_MACHINE\Software\Wow6432Node\JavaSoft\Java Runtime Environment" /v CurrentVersion 2^>nul') do set CurVer=%%b
if "!CurVer!" equ "0" for /f "skip=2 tokens=2*" %%a in ('reg query "HKEY_LOCAL_MACHINE\Software\JavaSoft\Java Development Kit" /v CurrentVersion 2^>nul') do set CurVer=%%b
if "!CurVer!" equ "0" for /f "skip=2 tokens=2*" %%a in ('reg query "HKEY_LOCAL_MACHINE\Software\Wow6432Node\JavaSoft\Java Development Kit" /v CurrentVersion 2^>nul') do set CurVer=%%b
goto :eof

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…