Post Upgrade Error: No enum constant com.pega.pegarules.priv.database.sqlgen.constants.ColumnType.-9999
Hi team,
we are just in process of upgrading from Pega 7.2.1 to Pega 8.7.3.
During the revalidation we found have for some report definitions the error: No enum constant com.pega.pegarules.priv.database.sqlgen.constants.ColumnType.-9999
From what I can see it only occurs for the report definitions that are using declarative index joins (snip attached)
We are also upgrading from Oracle to MSSQL
Tried the search for any solution, but was not successful; any suggestions were for 7.2 or no answer. Can you please help me to resolve this issue?
Thanks.
***Edited by Moderator Marije to change type from Product to Update***
Pegasystems Inc.
IN
This type of error will happen when there is a mismatch between In/Out parameter defined in the report definition and the column types of the database. Below are few articles that could help to understand it better.
https://support.pega.com/question/report-definition-error-no-enum-constant