[PLM] Import PPR file is failed "Unexpected error while parsing configuration"
Original Publishing Date:
2022-05-19
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