Question
CI
IN
Last activity: 3 Mar 2023 11:52 EST
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 .
-
Like (0)
-
Share this page Facebook Twitter LinkedIn Email Copying... Copied!
Bits in Glass
IN
@kirti Please verify if you have deployed Index class and index table to UAT environment. Also test the connectivity of the same.
-
Marije Schillern
CI
IN
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
CI
IN
@Anoop Krishna I am deployed 3 times, But no use .In UAT shows an error like one of the property not a valid property .
CI
IN
@Anoop Krishna it already in UAT
Pegasystems Inc.
GB
@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 ?