Running CLI using SAS Without JAVA

Pinnacle 21 Support Troubleshooting and Problems
1

I am using and programming with Java for over 25 years …

When you have added the link to the prepackaged Java (included in the P21 distribution) correctly to your Windows PATH variable, the CLI command should just be the same. Reason is that the command “java” should then always be recognized automatically.
Just try “java -version” using the windows console or in a “.bat” file to check whether you have correctly added the link to your Windows PATH variable.

But why should you not have Java installed on your machine? Is there company policy that doesn’t allow it?
99.9% of the computers nowadays are sold with Java pre-installed,

2

Hi Jozef,

Thank you for your reply!
I have Java Version 1.5.0 installed on my PC. Is that sufficient to run the CLI or do I need a newer version of the software?

Here is the code I use but nothing happens when I run it… No error, no warnings… So I could not find the problem..

%let jarpath = %str(C:\Users\xxx\Documents\Pinnacle 21 Community\configs) ;
%let jarfile = p21-client-1.0.2.jar ;
%let configpath = %str(C:\Users\xxx\Documents\Pinnacle 21 Community\configs) ;

/* CDISC Data Parameters /
%let sdtmpath = U:\study\DBASE_SDTM\XPT ;
%let adampath = U:\study\DBASE_ADAM\XPT ;
/ Validation Report Parameters */
%let reportpath = U:\study\DBASE_ADAM;

/* ADaM Validation*/
x java -jar “&jarpath.&jarfile.” ^ --engine.version=“FDA 1903.1” --standard=adam ^ --standard.version=1.0 ^ --source.sdtm=“&sdtmpath.” ^ --source.adam=“&adampath.” ^ --cdisc.ct.sdtm.version=2019-09-27 ^ --cdisc.ct.adam.version=2019-03-29 ^ --meddra.version=19.0 ^ --report=“&reportpath.\training-adam.xlsx” ;

Do you see any issue?

Kind regards

3

No, you should at least use version 1.8. I propose that you update (<5 minutes work): 1.5 is already very very old.

Is there a reason why you have “x” before the Java command?

A reason that you do not see an error, might be that the console is closing immediately. A possibility to avoid that is to run using Windows Powershell.

4

Hi Jozef,

Unfortunately I don’t have the access right to update Java on the company computer… That’s why I was trying to use the Java of the P21 package…

Indeed the console is opening and closing directly…

I put the “x” before the Java command because it was in the instructions :

https://www.pharmasug.org/proceedings/2018/DS/PharmaSUG-2018-DS20.pdf and here :

https://www.pinnacle21.com/forum/running-cli-using-sas

Regarding your answer:

“When you have added the link to the prepackaged Java (included in the P21 distribution) correctly to your Windows PATH variable, the CLI command should just be the same. Reason is that the command “java” should then always be recognized automatically.”

Could you clarify the steps I have to take? What do you mean by 'Add the Java to the Windows PATH variable" ? What is Windows PATH variable?

Thank you so much!

5

Hi Tathoum,

“Google is your friend” …
If you google for “add java to windows path” you will find a large numbers of articles and even movies about this topic.

6

Hello Tathoum,

Since you don’t have admin rights, you can still use pre-packaged Java 8 from your Community installation. You will need to add this path to your user environmental variables.

C:\Users{username}\AppData\Local\Programs\pinnacle21-community\resources\app.asar.unpacked\components\java64\bin

  1. Please use this path, replace {username} with your actual Windows user name. Make sure that this path does exist.

  2. From Start menu open Control Panel.

  3. In Control Panel go to User Accounts.

  4. In User Accounts click on the “Change my environment variables” link on the left.

  5. In the “User variables” section (top half of the screen) find Path or PATH variable. Double-click it to edit.

  6. Click “New” and insert this path from step 1. Please also check if you already had any Java-related paths there. If you have some, please move this new path up, so that it will be preferred. Then click OK to submit.

  7. You might need to restart the Terminal or Command Prompt for these changes to be applied.

After you follow these steps you can call the CLI with (“java -jar p21-client-1.0.2.jar …”) from either SAS, some script, or command line.

Thanks,

Philipp

7

Hi all,

I saw in that we can run CLI without having Java 8 installed (https://www.pinnacle21.com/projects/validator/community-cli):

“If you don’t have Java installed on your Windows PC, you can use Java 8 that comes pre-packaged with Community. Add the following path to your PATH system variable: C:\Users{username}\AppData\Local\Programs\pinnacle21-community\resources\app.asar.unpacked\components\java64\bin”

But I don’t know how this line has to be used in the CLI which normally look like :

x java -jar p21-client-1.0.0.jar
–engine.version=“FDA 1903.1”
–standard=adam
–standard.version=1.1
–source.sdtm=“C:\path\to\xpt\sdtm\data”
–source.adam=“C:\path\to\xpt\adam\data”
–source.define=“C:\path\to\adam\define.xml”
–cdisc.ct.sdtm.version=2017-12-22
–cdisc.ct.adam.version=2017-12-22
–meddra.version=19.0
–report=“C:\path\to\validation\report.xlsx”

Does someone already try this?

Many thanks for your help!