Discussion

2
Replies
121
Views
Elliott.Davis Member since 2013 27 posts
Crestone Technology
Posted: 3 years ago
Last activity: 3 years 11 months ago
Closed

you have a SQL error in the Resolution section of SA ID: SA-21927... here's the fix

Hello,

First off, thank you for the advice in SA ID: SA-21927 (https://pdn.pega.com/support-articles/ftsincrementalindexer-agent-queue…) The problem actually occured at my site, so I am especially appreciative. Begging your pardon, there is a small error in the SQL posted in the resolution section. I have included a correction below.

Cheers,
Elliott

The Resolution contains this SQL

select count(pxworkkey), pxworkclass from pr_sys_queue_ftsindexer group by pxworkclass order by pxworkkey ASC

That fails. I think the author meant to order by count(pxWorkKey) so that the results show the count of entries for each class:

select count(pxworkkey), pxworkclass from pr_sys_queue_ftsindexer
group by pxworkclass order by count(pxworkkey) DESC;

System Administration
Moderation Team has archived post
Share this page LinkedIn