Column Population Jobs Issue in Pega 8.8.3

General
, ,
1

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.

2

Hi @AbhishekC1725

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

3

@sandroRome Thanks for response.

4

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.

5

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