Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..
110 views

Excel Report Java Preprocessor Error - java.lang.ClassNotFoundException

Jump to solution

Good day,

I have created a Java Preprocessor class for the excel report. After uploading the JAR file I get the following error when running the excel report: java.lang.ClassNotFoundException

It seems that it can't find the java class specified:

ksc_run_excel_report epmo/EPMOPortfolioDashboardTemplateV1.0.xlsx
REPORT_ID=[RP.REPORT_SUBMISSION_ID]
DATA_PREPROCESSOR_CLASS= za.co.mtn.ppm.bpm.excelreports.EpmoPortfolioReportClass
DEBUG=false
ksc_end_report_parameters

The Report Log information:

Running report epmo/EPMOPortfolioDashboardTemplateV1.0.xlsx
Looking for template in: /app/ppm/dev/conf/custom_excel_templates/epmo/EPMOPortfolioDashboardTemplateV1.0.xlsx - Template file found.
Error running report: za.co.mtn.ppm.bpm.excelreports.EpmoPortfolioReportClass
Performance info for Report Report 30930
Report 30930 : 87 ms
  Parsing command : 0 ms
  Preparing Data : 80 ms
  Running custom Data Preprocessor : 1 ms

The server log file info:

ERROR :CommandRunner for com.kintana.rpt.server.KSCRunExcelReportCommand Batch ID: 34620:(KSCRunExcelReportCommand.java:306):2020/02/06-07:07:48.069 SAST: Error while running Excel Report with template epmo/EPMOPortfolioDashboardTemplateV1.0.xlsx
java.lang.ClassNotFoundException: za.co.mtn.ppm.bpm.excelreports.EpmoPortfolioReportClass

The only issue that I see and want to confirm is that the file permissions in Linux are different from the rest of the jar's in the directory: <server>/deploy/itg.war/WEB-INF/lib: See attached screenshot Annotation 2020-02-06 072744.jpg

Will the permissions impact the execution of the Java Class?

Regards,

Alfred

0 Likes
1 Solution

Accepted Solutions
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Excel Report Java Preprocessor Error - java.lang.ClassNotFoundException

Jump to solution

Hi Alfred,

Looks like you already figured out everything! You're correct about file permissions being the likely culprit: You should copy files to the PPM file system with the same user as will be used to run PPM, otherwise PPM may not be able to open the file(s).

So change ownership of the jar file to user svc_ppmsrv , restart PPM, and that should fix the issue.

Cheers,

Etienne.

View solution in original post

0 Likes
2 Replies
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Excel Report Java Preprocessor Error - java.lang.ClassNotFoundException

Jump to solution

Hi Alfred,

Looks like you already figured out everything! You're correct about file permissions being the likely culprit: You should copy files to the PPM file system with the same user as will be used to run PPM, otherwise PPM may not be able to open the file(s).

So change ownership of the jar file to user svc_ppmsrv , restart PPM, and that should fix the issue.

Cheers,

Etienne.

View solution in original post

0 Likes
Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..

Re: Excel Report Java Preprocessor Error - java.lang.ClassNotFoundException

Jump to solution

Thanks Etienne.

Our customer has setup the Linux privilege very tightly controlled. We have to sudo to the ppm service account and did not allow any owner changes in the directories.

I have logged a support case with the customer's Linux support team and gave them some of the directories where we as consultants will need more privileges.

Thanks for confirming what I thought is the issue.

Regards,

Alfred

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.