Skip to Main Content
SCE Platform Ideas Portal - UAT
Status Resolved
Created by Ankur Mankad
Created on Dec 5, 2024

Issue with PMDR Automatic pull in sigma prod

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

  • Attach files