The Software Replicator does not show any Organizational Views or Software after launch

Products

• Software Management Solution

Issue/Introduction

The Software Replicator is blank after launch. No Organizational Groups or Software is listed to be exported. In the log the following error is thrown:

CreateTree: select distinct i.Name, i2.Name from ScopeCollection sc join Item i on i.Guid = sc.ScopeSetGuid join ScopeMembership sm on sc.ScopeCollectionGuid = sm.ScopeCollectionGuid join Item i2 on i2.Guid = sm.ScopeCollectionGuid where lower(i.Name) <> ('default') or (lower(i.Name) = 'default' and (LOWER(i2.Name) in ('software component','software release','service pack','software update' ))) order by 1, 2

Specified argument was out of the range of valid values.
Parameter name: index
   [System.ArgumentOutOfRangeException @ System.Windows.Forms]
   at System.Windows.Forms.TreeNodeCollection.get_Item(Int32 index)
   at ReplKatr.MainForm.AddOrganizationalGroupsToTree()

Exception logged from:
   at Altiris.Diagnostics.Logging.EventLog.ReportException(Int32 severity, String strMessage, String category, Exception exception, String footer)
   at Altiris.NS.Logging.EventLog.ReportException(String strMessage, Exception exception)
   at ReplKatr.MainForm.logException(Exception ex, String Format, Object[] args)
   at ReplKatr.MainForm.AddOrganizationalGroupsToTree()
   at ReplKatr.MainForm.MainForm_Load(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.Form.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
   at System.Windows.Forms.SafeNativeMethods.ShowWindow(HandleRef hWnd, Int32 nCmdShow)
   at System.Windows.Forms.SafeNativeMethods.ShowWindow(HandleRef hWnd, Int32 nCmdShow)
   at System.Windows.Forms.Control.SetVisibleCore(Boolean value)
   at System.Windows.Forms.Form.SetVisibleCore(Boolean value)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
   at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
   at ReplKatr.Program.Main(String[] args)

**CEDUrlStart** :http://entced.symantec.com/entt?product=SMP&version=7.6.1383.0&language=en&module=Ozc+9ytN5/W7iZjTipzjUzFJi3E53dgf6KpPw/rLcU1Mjow1FcdbWWjY/eRwYhnRdhYxLgnbEtacHhbBH/ofQw==&error=185580740&build=**CEDUrlEnd**

Cause

This is caused by an Organizational Group missing the Name field in the Item table.

Resolution

Before looking for other resolutions, make sure you are logged onto the SMP server with the Application Identity account.

First, run the following query to locate the blank named Organizational Groups:

SELECT DISTINCT [Name], Guid FROM ScopeCollection
JOIN Item ON Guid = ScopesetGuid
WHERE [Name] is = ''

For each GUID that is returned, run the following query:

UPDATE Item
SET [Name] = 'Rename Me'
WHERE Guid = 'guid found from prevoius query'