Discussion

2
Replies
128
Views
Close popover
Elliott Davis (Elliott.Davis)
Crestone Technology
Certified Lead System Architect
Crestone Technology
MX
Elliott.Davis Member since 2013 27 posts
Crestone Technology
Posted: November 1, 2016
Last activity: November 11, 2016
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-size-large) 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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.