Facing issue to run report in UAT
Hi ,
i created one report for cancelled invoice I used declare index .
in dev environment report working as expected.
But in UAT i am getting below error
No enum constant com.pega.pegarules.priv.database.sqlgen.constants.ColumnType.-9999
Please help how to resolve this error in UAT .
Actually we deployed Index class and index table we see different in dev and UAT environment.
dev created a new table .But i can see in SQL bd .
In UAT environment i can see different table
@Anoop Krishna I am deployed 3 times, But no use .In UAT shows an error like one of the property not a valid property .
@kirti Please have a look at similar errors described in other forum posts such as Report Definition error "No enum constant com.pega.pegarules.data.external.rd.constants.ColumnType.INT IDENTITY"
What is the data type of the report property? Pega does not support '-9999' type of db columns in reports. No enum for it is present in report generation classes
What does the declare index do? Declare Indexes are used to expose aggregate properties like Page/List/Group. These exposed properties can be used for reporting using Declarative Index Join.
Please provide the definition of the report. What is the '-9999' column type listed? In your Dev environment have you defined a column of type '-9999'? What is your DB on both environments?
Have you tried to delete the current column and add the property on Pega side then run the optimization to create a proper column with a recognized type ?