Hi Sonal,
As discussed, could you please look at the following issue reported in the PMDR pull job status table in sigma production DB.
Query used –
select *,timezone('Asia/Kolkata'::text, to_timestamp((start_time / 1000)::double precision)) from sigma.auto_onboard_job_execution_summary aojes
where module IN ('Codelist View','Comments View','Dataset View','Methods View','Valuelevel View','Variable View','WhereClause View')
and job_trigger_type ='automatic'
and status = 'Failed'
-- and start_time is not null
order by start_time desc
Error –
API returned with error: - {"timestamp":1730563424714,"status":500,"error":"Internal Server Error","path":"/sce/core/pmdr/version/valuelevels/finalData"}; nested exception is org.springframework.web.reactive.function.client.WebClientResponseException$InternalServerError: 500 Internal Server Error from POST http://sigma-study-service-prd:80/sce/core/pmdr/version/valuelevels/finalData
Environment – Sigma Production
Thanks,
Ashish Sahoo