Running CLI using SAS

Pinnacle 21 Support Troubleshooting and Problems
1

Hi Narasimha,

What does the log file say? You should be able to find in the folder C:\Users\nayyalas\Documents\Pinnacle 21 Community\logs

I already see one possible cause for the problem: your statement: %let reportpath=C:\Users\nayyalas\Documents\Pinnacle 21 Community\reports;
contains blanks, so I presume you should put it in double quotes, i.e.:
%let reportpath=“C:\Users\nayyalas\Documents\Pinnacle 21 Community\reports”;

Otherwise the software is looking for a folder “Pinnacle” under “Documents”

With best regards,

Jozef

2

Hi Jozef,

Thank you for your response. Please see below:

  • Log file is not being generated.
  • W.r.t report the only reason why i did not include double quotes was when i call the macro variable i have included them, unless i am missing something.

Please advise. Thanks a lot.

3

Hi Narasimha,

I can’t give you additional advice. I am not a Pinnacle21 employee.
I answered as I saw an obvious error in your script.
This is something the Pinnacle21 people should further take care off.
For you, hopefully quickly - I usually answer questions from my XML4Pharma customers within hours.

With best regards,

Jozef Aerts
XML4Pharma

4

Hi Narasimha,

There are few errors in your code you need to correct.

  1. Please refer to CLI documentation https://www.pinnacle21.com/projects/validator/community-cli

For example, you have to specify Engine

  1. Command line statement should be one line of code. Your example code represents 9 different commands rather a single one. All parameters started with a new line are considered as additional separate commands. It may be due to confusing example in P21 documentation. It was done for better readability assuming that all users are aware about CLI syntax.

  2. In SAS, you need to use X command to call Windows CLI

  3. Also, ensure that all CT and dictionaries you refer to are already set-up and a folder for reports exists.

Here is corrected SAS code which should work. You can add MedDRA, UNII and NDF-RT parameters later.

%let jarpath = %str(C:\Users\nayyalas\AppData\Local\Programs\pinnacle21-community\resources\app.asar.unpacked\components\lib);
%let jarfile = %str(p21-client-1.0.0.jar);
%let reportpath=C:\Users\nayyalas\Documents\Pinnacle 21 Community\reports;

x java -jar “&jarpath.&jarfile.” –engine.version="FDA 1903.1" --standard=sdtm --standard.version=3.2 --source.sdtm=“&sdtmpath.” --cdisc.ct.sdtm.version=2018-12-21 --report=“&reportpath.\s101-sdtm.xlsx”;

Kind Regards,

Sergiy

P.S. For diagnostics of your code you can use Windows Command Prompt. Here are steps:

  • Create a text file
  • Enter your code with actual folder and file names instead of using Macro variables. Here is an example:

java -jar “C:\Users\nayyalas\AppData\Local\Programs\pinnacle21-community\resources\app.asar.unpacked\components\lib\p21-client-1.0.0.jar” --engine.version=“FDA 1903.1” --standard=sdtm --standard.version=3.2 --source.sdtm=“C:\Users\nayyalas\Documents\TESTDATA” --cdisc.ct.sdtm.version=2018-12-21 --report=“C:\Users\nayyalas\Documents\Pinnacle 21 Community\reports\s101-sdtm.xlsx”

  • Save it. Rename file extension to ‘.bat’ to make it executable. For example, ‘test.bat’
  • Open Windows Command Prompt by clicking on Window picture in a left bottom corner of your desktop screen and typing ‘cmd’. Black Command Prompt window will be opened
  • Changed working directory to a folder of you BAT file. For example, ‘cd C:\Users\nayyalas\Documents\TEST’
  • Run your script file. You can also redirect log info into some file for diagnostics. For example, ‘test’, ‘test.bat’ or ‘test.bat > test.log’
  • Look into ‘test.log’ file if something is wrong
5

Thank you so much Jozef.

6

Hello Sergiy,

Thank you so much for your response. I will work on this and let you know if this works. Thanks a lot.

Narasimha.

7

Hello, Narasimha.

I also met the error by using “–meddra.version=20.1”.

The code except meddra command line was good working. Could you please run the CLI except meddra CLI?

8

Hi MinJi,

Are you MedDRA files installed correctly? Can you run the same validation using GUI?

Thanks,

Sergiy

9

Hi Sergiy,

The MedDRA files are installed correctly, because the validation (including MedDRA) using pinnacle 21 without CLI are good working.

However, using CLI, the validation including MedDRA dose not working..

I wrote the CLI as like --meddra.version=22.0 according to the guidelines. The other terminologies (unii, ntf-rt) are good working, however, the only MedDRA does not work in command line.

I want to know how to validate SDTM using meddra in command line.

10

Hi MinJi

Unfortunately, I haven’t been able to reproduce your issue. Here is how CLI works for me with MedDRA and SDTM:

  1. Install MedDRA 22.0 using the GUI:

Install Meddra usIng GUI.jpg
Install Meddra usIng GUI.jpg713×786 85 KB

  1. Go to CLI location, i.e. put it in Pinnacle 21 Community folder in Documents, as it is recommended in CLI documentation

  2. Run validation request with --meddra.version=22.0 or any other version that you installed.

CLI validation with MedDRA.jpg
CLI validation with MedDRA.jpg1240×579 164 KB

In case if you still experience this issue, we would need a log file from CLI to better understand the specifics of that problem.

You could send a log file located in logs/p21-client-1.0.0 to our support email community@pinnacle21.com

Thanks,

Philipp

11

Hi Philipp,

Thank you for prompt reply.

According to the below screen shot, I think the MedDRA was installed correctly. I will send my code to you through email.

meddra_0.JPG
meddra_0.JPG1050×453 60.4 KB

12

Hi Min,

I tried making the change however it still does not generate the report. Please see below for my code and let me know if i am missing anything. Thanks a lot.

%let jarpath = %str(C:\Users\nayyalas\AppData\Local\Programs\pinnacle21-community\resources\app.asar.unpacked\components\lib);
%let jarfile = %str(p21-client-1.0.0.jar) ;

%let reportpath=C:\Users\nayyalas\Documents\Pinnacle 21 Community\reports;
%let sdtmpath=C:\Users\nayyalas\Documents\xpt\dm.xpt;

x java -jar “&jarpath.&jarfile.” --standard=sdtm --standard.version=3.2 --source.sdtm=“&sdtmpath.” --cdisc.ct.sdtm.version=2018-12-21 --unii.version=2018-10-25 --ndf-rt.version=2018-02-05 --report=“&reportpath.\s101-sdtm.xlsx”
;

13

Hi Min,

I tried making the change however it still does not generate the report. Please see below for my code and let me know if i am missing anything. Thanks a lot.

%let jarpath = %str(C:\Users\nayyalas\AppData\Local\Programs\pinnacle21-community\resources\app.asar.unpacked\components\lib);
%let jarfile = %str(p21-client-1.0.0.jar) ;

%let reportpath=C:\Users\nayyalas\Documents\Pinnacle 21 Community\reports;
%let sdtmpath=C:\Users\nayyalas\Documents\xpt\dm.xpt;

x java -jar “&jarpath.&jarfile.” --standard=sdtm --standard.version=3.2 --source.sdtm=“&sdtmpath.” --cdisc.ct.sdtm.version=2018-12-21 --unii.version=2018-10-25 --ndf-rt.version=2018-02-05 --report=“&reportpath.\s101-sdtm.xlsx”
;

14

Hi Narasimha,

You would certainly need to add the engine version parameter to these parameters that you send to CLI.

For example, for FDA 1903.1 it would be –engine.version=“FDA 1903.1”.

Without the engine version, CLI wouldn’t know what engine and config to use and will fail the validation.

Thanks,

Philipp

15

Hello Philip,

Sorry i added that as well please see below. I still do not get any report. Thanks a lot.

%let jarpath = %str(C:\Users\nayyalas\AppData\Local\Programs\pinnacle21-community\resources\app.asar.unpacked\components\lib);
%let jarfile = %str(p21-client-1.0.0.jar) ;

%let reportpath=C:\Users\nayyalas\Documents\Pinnacle 21 Community\reports;
%let sdtmpath=C:\Users\nayyalas\Documents\xpt\dm.xpt;

x java -jar “&jarpath.&jarfile.” --engine.version=“FDA 1903.1” --standard=sdtm --standard.version=3.2 --source.sdtm=“&sdtmpath.” --cdisc.ct.sdtm.version=2018-12-21 --unii.version=2018-10-25 --ndf-rt.version=2018-02-05 --report=“&reportpath.\s101-sdtm.xlsx” ;

Narasimha.

16

Hello Narasimha,

I would try to wrap reportpath parameter in %str, just like you do for jarpath and jarfile.

17

Hi Philip,

Not sure i am unable to generate the report running this in SAS. Please see below code :

%let jarpath = %str(C:\Users\nayyalas\AppData\Local\Programs\pinnacle21-community\resources\app.asar.unpacked\components\lib);
%let jarfile = %str(p21-client-1.0.0.jar) ;

%let reportpath=%str(C:\Users\nayyalas\Documents\Pinnacle 21 Community\reports);
%let sdtmpath=C:\Users\nayyalas\Documents\xpt\dm.xpt;

x java -jar “&jarpath.&jarfile.” --engine.version=“FDA 1903.1” --standard=sdtm --standard.version=3.2 --source.sdtm=“&sdtmpath.” --cdisc.ct.sdtm.version=2018-12-21 --unii.version=2018-10-25 --ndf-rt.version=2018-02-05 --report=“&reportpath.\s101-sdtm.xlsx”
;

Thanks a lot for your help.

Narasimha.

18

Hi,

I’m trying to run Pinnacle 3.0.0 validation using windows cmd.

I tried two ways:

1- using validator-cli-2.1.5.jar that is located in \OpenCDISC\pinnacle21-community 3.0.0\components\lib with the following code:

java -Xms256m -Xmx1024m -jar validator-cli-2.1.5.jar -type=SDTM -source=XPT*.XPT -source:type=SAS -config=SDTM_3.2.xml -config:cdisc=2018-09-28 -config:meddra=18.1 -report=Drug-study-report1000.xls -report:type=Excel -report:cutoff=1000 report:overwrite=Yes

This code works and I’m getting the report, but my big problem here is that I can’t define a path for the source data and the report. The only way that it was working is when everything was located in the same location as the jar.

2- using p21-client-1.0.0.jar, following the instructions in https://www.pinnacle21.com/projects/validator/community-cli:

java -Xms256m -Xmx1024m -jar p21-client-1.0.0.jar --engine.version=“FDA 1903.1”–standard=sdtm --standard.version=3.2 --source.sdtm=“\SDTM Post processing\OpenCDISC\pinnacle21-community 3.0.0\components\lib\XPT*.XPT” --cdisc.ct.sdtm.version=2018-09-28 --meddra.version=18.1 --unii.version=2018-10-25 --ndf-rt.version=2018-02-05 --report=“\reports\report.xlsx”

This code gives me the lots of errors, such as:

16:56:29,038 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback.groovy]
16:56:29,038 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback-test.xml]
16:56:29,038 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found resource [logback.xml] at [jar:file:/C:/Users/monick/Documents/Pinnacle%2021%20Community/p21-client-1.0.0.jar!/logback.xml]

Really appreciate your help ( in one of the ways ).

Thanks,

Monick

19

Hello Monick,

Thank you for your questions!

It seems that in the first case you have tried to use a legacy CLI jar file. validator-cli-2.1.5.jar comes from a legacy Community 2.x version that is outdated and not supported.

Please use the latest CLI jar file that comes with Community 3.1.1. The correct file name is p21-client-1.0.4.jar
You can locate it in your Community installation directory under \resources\app.asar.unpacked\components\lib then copy next to your Community configs directory and run validations.

Regarding the command that you posted in 2 - there are several things to fix:

  1. Please use one of the engine versions that are currently supported. For FDA agency these are 1907.2 and 2010.1.
    FDA 1903.1 is outdated and not supported (for example, you cannot choose it in Community GUI anymore).
  2. CLI source parameters don’t support wildcard characters. You will need to remove the “*.XPT” part.
    Unrelated non-CSV or non-XPT files in the folder and its subfolders will be ignored by CLI.
  3. Errors that you listed don’t affect the validation. Usually, critical errors failing the validation process are at the end of the CLI console output and log.

Thanks,

Philipp

20

Thanks a lot Philipp!!

The first way is working now when I’m including the path.

The report seems fine but it’s still giving me lots of comments while running the command, such as:

log4j:WARN No appenders could be found for logger (com.amazonaws.AmazonWebServiceClient).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See Apache log4j 1.2 - Frequently Asked Technical Questions for more info.

How can I be sure that they are not affecting the validation?

Thanks again,

Monick