Symptoms

In an attempt to import PPR file for Inhouse Product, an error occurs:

"Unexpected error while parsing configuration"

with an error in in inhouse-products pod

19-05-2022;08:38:30,638 WFLYEJB0034: Jakarta Enterprise Beans Invocation failed on component ExcelConfigManagementBean for method public abstract com.odin.platform.excel.rest.ConfigurationInfo com.od
in.platform.excel.api.ExcelConfigManagement.parseExcelConfig(byte[],int): javax.ejb.EJBException: Unexpected error while parsing configuration, please contact support
        at deployment.inhouse-products-backend.war//com.odin.platform.excel.ejb.excelwizard.ExcelConfigParser.parse(ExcelConfigParser.java:56)
at deployment.inhouse-products-backend.war//com.odin.platform.excel.ejb.ExcelConfigManagementBean.parseExcelConfig(ExcelConfigManagementBean.java:174)

Cause

PPR file has the incorrect column name "#N/A" from the "ServicePlan" sheet.

Resolution

Make sure that the PPR file is correct and matches with the official documentation https://docs.cloudblue.com/cbc/21.0/Product-Lifecycle-Management/File-Requirements.htm