Rich Y_1 Honored Contributor.
Honored Contributor.
1449 views

PPM 9.32 Build Excel Reports using a PPM Data Source

Jump to solution

I trying to build a Excel report in PPM 9.32 using an existing PPM data source.  I get the following error.

 

Running report reports/ad/User_DOT_Info.xlsx
Error running report: net.sf.jett.exception.TagParseException: Matching tag not found for tag: , located at org.apache.poi.ss.util.CellReference [User!A2], within block Block: left=0, right=3, top=0, bottom=48, direction=NONE
Performance info for Report Report 43862
Report 43862 : 49 ms
  Parsing command : 0 ms
  Preparing Data : 6 ms
  Generating Excel Document : 39 ms

In the Excel template my column A is <jt:forEach items="${datasources.get('Users DOT Info').getData()}" var="org">${org}

Any help you can provide is appreciated.

 

0 Likes
1 Solution

Accepted Solutions
Rich Y_1 Honored Contributor.
Honored Contributor.

Re: PPM 9.32 Build Excel Reports using a PPM Data Source

Jump to solution

Thank you for the offer but I found my issue.  It was in the template.  I removed 1 column and added it back in that fixed my template and stopped me from getting the errors.

9 Replies
Natalia_R_PPM Absent Member.
Absent Member.

Re: PPM 9.32 Build Excel Reports using a PPM Data Source

Jump to solution

Hello Rich,

Maybe you can check the following guide and find some useful information 

HP Project and Portfolio Management Center Software Version: 9.30 Excel Reports Cookbook

Also you can enable the debug lines in order to have an error more specific.

Loggin.conf

 

1) For Reports (shows if any reports are being run )

com.kintana.core.logging.PRODUCT_FUNCTION_LOGGING_LEVEL = com.kintana.rpt.system, DEBUG

com.kintana.core.logging.PRODUCT_FUNCTION_LOGGING_LEVEL = com.kintana.rpt.tag, DEBUG

 

Thanks & Best Regards, 

Natalia

 

HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
0 Likes
Absent Member.. AlexSavencu Absent Member..
Absent Member..

Re: PPM 9.32 Build Excel Reports using a PPM Data Source

Jump to solution

Hi, Rich,

 

did you resolve this issue so far?

 

thanks in advance,

Alex


--remember to kudos people who helped solve your problem
0 Likes
Rich Y_1 Honored Contributor.
Honored Contributor.

Re: PPM 9.32 Build Excel Reports using a PPM Data Source

Jump to solution

Yes I was able to resolve the issue.  Reports are working now but working with HP on memory issues at least I believe they are Java memory issue.

0 Likes
Micro Focus Expert
Micro Focus Expert

Re: PPM 9.32 Build Excel Reports using a PPM Data Source

Jump to solution

Hi Rich,

If you're inserting too much data in the report, you'll run into memory issue. You should use large data mode (described in the Excel Report cookbook) when you're inserting more than a few thousands of rows.

Thanks,

Etienne.

0 Likes
Rich Y_1 Honored Contributor.
Honored Contributor.

Re: PPM 9.32 Build Excel Reports using a PPM Data Source

Jump to solution

How does HP define large data?  The last time I revieved the error the report was pulling 232 rows with 5 columns.  I know this becuase if I run the SQL outside of PPM that is what it pulls.  Is that large data.? Does not seem linke it to me.

0 Likes
Micro Focus Expert
Micro Focus Expert

Re: PPM 9.32 Build Excel Reports using a PPM Data Source

Jump to solution

Hi Rich, This is definitely not large data. Large Data is more about more than 3000 rows, with 10 columns or more. 

In the end, you can do the following: 

- Take the generated report (XLSX file)

- Rename it to .zip

- Unzip it in a dedicated folder

- Look at the total size of that folder, and multiply that size by 2.

That final value is roughly the size that the report will take in PPM memory when generated. If your template has a lot of pictures and some sheets with lots of data (even if they don't have any placeholder for report data), that may be the problem as you may end up with many hundreds of megabytes of memory consumption with a huge spreadsheet.

0 Likes
Rich Y_1 Honored Contributor.
Honored Contributor.

Re: PPM 9.32 Build Excel Reports using a PPM Data Source

Jump to solution

Thanks for the information on large data.  My spreadsheets are very simple no pic, charts, etc so data size will be on the small size.

0 Likes
Micro Focus Expert
Micro Focus Expert

Re: PPM 9.32 Build Excel Reports using a PPM Data Source

Jump to solution

If you could attach your template here, I could give it a try and see if I can reproduce the problem with a few hundreds or thousands of rows.

0 Likes
Rich Y_1 Honored Contributor.
Honored Contributor.

Re: PPM 9.32 Build Excel Reports using a PPM Data Source

Jump to solution

Thank you for the offer but I found my issue.  It was in the template.  I removed 1 column and added it back in that fixed my template and stopped me from getting the errors.

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.