How to find a bad Island Follow
If you have the island ID from the logs you can use this script to determine the Island name and location.
-Change Production_PortalFX to the name of your FX database.
-Change 66251f1c-e86d-47ca-8300-18338c705065 to the ID you pulled from the log.
SELECT islandInfo.IslandID as 'Island Name',
workinfo.WorkGroupName,
Pageinfo.DisplayText as 'Page Name'
FROM [Production_PortalFX].[dbo].[PWPageIslands] islandInfo
left join (Select * from [Production_PortalFX].[dbo].[PWPages]) as pageinfo on pageinfo.PageID = islandinfo.PageID
left join (Select * from [Production_PortalFX].[dbo].[PWWorkGroups]) as workInfo on workinfo.ViewID = pageinfo.ViewID
WHERE IslandInstanceID = '66251f1c-e86d-47ca-8300-18338c705065'
Comments
0 comments
Please sign in to leave a comment.