Question
Virtusa
IN
Last activity: 28 May 2025 6:01 EDT
Data is not populated in exposed column
I have optimized a property 'Date' which is under page(.Transaction.Date). Property is also added in external mapping. We deployed this property to stating by promoting DB Instance and Class. I could able to see job population status as 100%. But when i execute the query i could not able to see values in the exposed column (Date) but values are there in blob data. Tried to execute OOTB activity 'RecreateIndexesForClass' but no use. Let me know if any solution for this.
Reagrds,
Yasvanth.
Tata Consultancy Services
IN
Can you try saving Data-Admin-DB-Table instance of the exposed table
save the Class of the DB table and then try running the report.
Virtusa
IN
Did that part as well but still data is not populated.
Tata Consultancy Services
IN
Have you checked the Schema in the environment in which you have moved?
Virtusa
IN
yes the exposed column exists in schema.
Tata Consultancy Services
IN
could you please create a onetime utility and try to repopulate the values
try if this works out for you.
Thanks
Gayatri
Maantic Inc
IN
Do you see the column visible under Schema Tools?
Lventur
IN
Please have a clear cache restart for your environment and try, it will work. This is a kind of a known issue, in many places DB changes are not getting reflected when we are doing deployment.
Eclantiqx
IN
Hi @Yasvanth Tanuku,
If none of the above solutions work, create a Declare Index rule and check if it resolves the issue. I hope it works.
Thanks
Raja