-
Title
Search tab not loading any searches -
Description
Consider the scenario:
- Search Tab not loading any searches for a user who is member of Change Auditor Administrators.
- Change Auditor Client log shows the entry: [INFO][ChangeAuditor.MainForm.TryConnectRepository(0)] User GUID: 00000000-0000-0000-0000-000000000000
- Coordinator log has an entry: "[INFO][Dell.Data.ClientSql.HandleException(0)] SQL error: TIMEOUT on usp_QueryTree"
-
Cause
An LDAP request to obtain connecting user's object GUID has failed. This leads to null GUID being used instead. -
Resolution
WORKAROUND
1. Open SQL Management Studio where the Change Auditor database is located, and connect as the Change Auditor Database service account (or other SQL Administrator).
2. Take a backup of the Change Auditor database.
3. Expand the Change Auditor database | Programmability | Stored Procedures.
4. Locate "dbo.usp_QueryTree"
5. Right click dbo.usp_QueryTree, and select Modify.
6. Locate the following section (about half way down):
INSERT INTO
#FolderList
(
FolderLevel,
FolderID
)
SELECT
@FolderLevel,
FolderID
FROM
Query.Folder
WHERE
( ParentFolderID = @ShareID AND OwnerID = @ShareID )
OR ( ParentFolderID = @OwnerID AND OwnerID = @OwnerID )
7. Replace the entire part mentioned above with the following:
IF( @OwnerID != @RootID )
INSERT INTO
#FolderList
(
FolderLevel,
FolderID
)
SELECT
@FolderLevel,
FolderID
FROM
Query.Folder
WHERE
( ParentFolderID = @ShareID AND OwnerID = @ShareID )
OR ( ParentFolderID = @OwnerID AND OwnerID = @OwnerID )
ELSE
INSERT INTO
#FolderList
(
FolderLevel,
FolderID
)
SELECT
@FolderLevel,
FolderID
FROM
Query.Folder
WHERE
( ParentFolderID = @ShareID AND OwnerID = @ShareID )
8. Click the Execute button.
9. Relaunch the Client for one of the impacted users to confirm the Searches tab now loads
-
Defect ID
TF00480429