IBM Support

Alphablox known issues: you cannot have more than 255 columns in a given row (IV) with Export to Excel function

Troubleshooting


Problem

When you use Export to Excel function to generate a report in Alphablox, if there are more than 255 columns in a given row (IV) of the report, an exception will occur.

Symptom

A java.lang.RuntimeException will be thrown which indicates that Excel cannot handle such great amount of columns in a given row (IV).

Resolving The Problem

Reorganize the report so that the number of columns in a given row (IV) does not exceed 255.

[{"Product":{"code":"SSCPX3","label":"DB2 Alphablox"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF016","label":"Linux"}],"Version":"9.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21317139