Description
est: DMS_AutoTest_DTreeNotifyQueue
Ziel: Überprüfung, ob die Task-Queue des Content Servers abgearbeitet wird. Falls es Probleme mit der Indexierung geben sollte, schlägt der WebReport hoffentlich Alarm. Die Limits, die aktuell eingetragen sind, müssen wir ggfs. noch Anpassen, wenn wir etwa mehr Erfahrung haben. Aktuell: >100 Tasks in der Queue, die Folder oder Dokument betreffen: WARNING, >500 Tasks in der Queue, die Folder oder Dokument betreffen: ERROR
NickName: DMS_AutoTest_DTreeNotifyQueue
E-Mail Message:
Text | Picture |
|---|---|
name: cypress_webreports_408 |
|
Applies to
System | Version | Approved |
|---|---|---|
Summary
Check how Many Entry has the Table
| Code Block |
|---|
select count(*) from dtreenotify |
Select per Type
| Code Block |
|---|
select count(*), ntype from dtreenotify group by NTYPE |
NType | ||
|---|---|---|
1 | The change notification constant for the creation of a node | |
2 | The change notification constant for the copying of a node | |
3 | The change notification constant for the creation of a root node | |
4 | The change notification constant for deleting a node | |
5 | The change notification constant for moving a node | |
6 | The change notification constant for renaming a node. | |
7 | The change notification constant for the modification of a node | |
8 | The change notification constant for the addition of an ACL to a node | |
9 | he change notification constant for the modification of an ACL of a node | |
10 | The change notification constant for the deleting of an ACL from a node | |
-1 | Deals with ranking/ Rate It in LES 9.6 and 9.7 | |
12 | ||
2001 | ||
2004 |
. NType=5 NOTIFY_MOVE The change notification constant for moving a node. NType=6 NOTIFY_RENAME The change notification constant for renaming a node. NType=7 NOTIFY_UPDATE The change notification constant for the modification of a node. NType=8 NOTIFY_ACL_ADD The change notification constant for the addition of an ACL to a node. NType=9 NOTIFY_ACL_UPDATE The change notification constant for the modification of an ACL of a node. NType=10 NOTIFY_ACL_DELETE The change notification constant for the deleting of an ACL from a node. NType=-1 Deals with ranking/ Rate It in LES 9.6 and 9.7