Question
Mindtree
AU
Last activity: 9 Mar 2019 15:33 EST
Report Definition is not fetching the data from Exposed Column
To improve the report performance , optimized the property which is in work class and data is saving to that exposed column but RD is still fetching data from BLOB.
In Property advanced tab,I could see it is optimized only for work class(TGB-FAS-Work) not to implementation classes (TGB-FAS-Work-AP) & (TGB-FAS-Work-EM).
If I try to optimize again,getting the error "Column names in each table must be unique. Column name 'TotalAmount' in table 'dbo.pc_TGB_FAS_Work' is specified more than once."
Tried below approaches:
1. Saved the Work class Database table after optimizing
2. Saved the RD to new Ruleset version
Any Suggestions to fix this?
Pegasystems Inc.
IN
Hi Chaintanya,
Can you please review the below article and the suggestions mentioned there:
https://collaborate.pega.com/question/optimize-reporting-not-working-existing-cases
Thanks!
Pegasystems Inc.
IN
Hi,
Could you please check the table names for TGB-FAS-Work, TGB-FAS-Work-AP and TGB-FAS-Work-EM.
The table will be same for all the three classes unless you have manually changed them.
Since you have already optimized the property for TGB-FAS-Work, a column has already been created in this table. So when you are again trying to optimize the property for TGB-FAS-Work-AP or TGB-FAS-Work-EM, as the column already exist in this table it is throwing the error you have mentioned.
I think you can try one of the below options now to optimize it for AP or EM.
1. Create a Declare index and optimize the column using this declare index and in RD you can have a class join with this declare index and use this column instead (write an activity to populate the old work objects data).
2. Another option you have is delete this column from the table manually and then again optimize the property and this time for the implemented class(run the columnpopulation utility ) .
3. Another option is to create a column with some other name in the same table and then map this column with the property in external mapping tab of class definition (in this option you will have to write an activity to populate this new column with old work objects data).