For a particular dashboard all widgets are getting this error can someone pls help ?

Hi Vinod, from our logs I can see there is an issue with the column the data is being queried from:

ERROR: column "energy" does not exist

. Could you please check? You may also need to invalidate the cache if there were changes introduced recently to your LDM.

I checked its there let me try once again

I see it is still failing with the same error, please note that the error itself is being fed into our logging system from your PostgreSQL database. Could you please check your database logs for any hints? Furthermore, I would recommend double checking that the column in question is still present in the source data, this is the SQL query that's triggering the error:

SELECT "m_52d92306d50c7cd3dff4f269af3f29fb" AS "m_1"
FROM (SELECT SUM("energy") AS "m_52d92306d50c7cd3dff4f269af3f29fb", TRUE AS "def_m_52d92306d50c7cd3dff4f269af3f29fb"
FROM "public"."ifc_data"
WHERE "design" = 'EAF Route'
GROUP BY CAST(NULL AS INTEGER)) AS "t2"
WHERE "def_m_52d92306d50c7cd3dff4f269af3f29fb"