Question
Zensar Technologies Ltd
IN
Last activity: 24 Jun 2024 5:21 EDT
Column Population Jobs Issue in Pega 8.8.3
Hi, I tried to optimize property in pega 8.8.3 version. It is showing column population job status = New. Almost 14 Hrs completed but the status of job is not get completed. And when I am trying to optimize other properties I am getting error that column population job for your class in progress you should wait or cancel that column population job.
I right clicked on that column population job ID but cancel option is disabled. And there is no option to restart the job. Can anyone help me, what should I do now. It is affecting our users reporting task. And need to fix this issue on priority.
Accepted Solution
Updated: 28 Dec 2023 8:37 EST
NTTDATA
IT
try to check if there is a record in progress with the query below (I inserted all pyStatus different from Completed):
SELECT pxcommitdatetime, pxsavedatetime, pxcreatedatetime, pxcreateoperator, pyjobid, PYCLASSNAME, pystatus, pyproperties FROM pegadata.pr_sysjobs where pystatus !='Completed'
If yes, delete that record and the job should continue to work items in New status, else delete also the 'New' pystatus record and optimize again the property.
Best regards,
Sandro
Zensar Technologies Ltd
IN
@sandroRome Thanks for response.
Plexus
ES
Hi, @sandroRome
I have the same problem in production envairoment and when I execute your query, I have all job processes in New status.
How can I fix that? Just only happens in production
Regards.
NTTDATA
IT
Hi @uNlove
you have to delete also the 'New' records and re-optimize again the properties.
Check also if there are some errors in the logs.
best regards, Sandro