

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
We are using a Progress Bar for % Complete in a custom portlet that shows Red, Yellow, or Green. The color shows just fine in the portlet, but when we try to export to Excel all we get is a blank tab/window. In the Portlet Definition for the field:
Column Type: Progress Bar
Color Value: Color Source (radio button) with the Red, Yellow, Green field from the SQL statement
If I remove having the Red, Yellow, or Green color for the Progress Bar, the portlet exports to Excel with no problem.
Column Type: Progress Bar
Color Value: Color Source (radio button) with nothing selected
The Red, Yellow, and Green SQL statement works fine if the Column Type is Icon.
Is there anything special for specifying color for a Progress Bar? We are running PPM version 9.32.0002.
Here is the exception from the server log file:
An unknown error has occurred. For more information, please contact your PPM administrator and provide the following GUID number:
GUID=C9FDC50F-8565-650F-A084-626544537C46
Generated Time=2016/12/08-12:56:13.488 EST
at com.kintana.core.server.UncaughtExceptionDefaultHandler.uncaughtException(UncaughtExceptionDefaultHandler.java:25)
at java.lang.ThreadGroup.uncaughtException(ThreadGroup.java:1057)
at java.lang.ThreadGroup.uncaughtException(ThreadGroup.java:1052)
at java.lang.Thread.dispatchUncaughtException(Thread.java:1952)
Caused by: java.lang.NullPointerException
at java.lang.Integer.decode(Integer.java:1161)
at java.awt.Color.decode(Color.java:729)
at com.hp.ppm.html2excel.JerichoUtils.parseColor(JerichoUtils.java:36)
at com.hp.ppm.html2excel.JerichoUtils.parseFontColor(JerichoUtils.java:40)
at com.hp.ppm.html2excel.StreamingTransformer$13.whenText(StreamingTransformer.java:514)
at com.hp.ppm.html2excel.StreamingTransformer.transform(StreamingTransformer.java:66)
at com.hp.ppm.html2excel.ExcelTransformerServlet$2.run(ExcelTransformerServlet.java:52)
at java.lang.Thread.run(Thread.java:745)
ERROR server:Thread-153:(UncaughtExceptionDefaultHandler.java:25):2016/12/08-13:00:20.402 EST: An unknown error has occurred. For more information, please contact your PPM administrator and provide the following GUID number:
GUID=0E76B115-B317-DDB8-F1F4-D2C9AF5F8940
Generated Time=2016/12/08-13:00:20.401 EST
An unknown error has occurred. For more information, please contact your PPM administrator and provide the following GUID number:
GUID=0E76B115-B317-DDB8-F1F4-D2C9AF5F8940
Generated Time=2016/12/08-13:00:20.401 EST
nested detail:null
Thanks
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Problem solved.!
The root cause of the problem was that one of the values was not a color. We were having no color if a value was -1. Once I changed the color to 'GRAY' (for example) so that every part of the case statement returned a color, it displayed properly and successfully exported to Excel.
Thanks


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Hello,
Please try to update the Color Source as below:
This now allows the portlet to be exported to excel.
SELECT 'one' ID, 75 PERC, 'Green' COLOR FROM dual
UNION ALL
SELECT 'two' id, 80 perc, 'RED' color FROM dual
UNION ALL
SELECT 'three' id, 20 perc, 'Yellow' color FROM dual
UNION ALL
SELECT 'four' id, 50 perc, 'YELLOW' color FROM dual
UNION ALL
SELECT 'five' id, 10 perc, 'RED' color FROM dual
UNION ALL
SELECT'six' id, 45 perc, 'RED' color FROM dual WHERE 1=1
Thanks,
Best regards,


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
Problem solved.!
The root cause of the problem was that one of the values was not a color. We were having no color if a value was -1. Once I changed the color to 'GRAY' (for example) so that every part of the case statement returned a color, it displayed properly and successfully exported to Excel.
Thanks