Color in Progress Bar in Portlet won't Export to Excel

[JodieOndrejka]

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

[QUYNH_BUI_PPM]

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,

[JodieOndrejka · Accepted solution]

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