Worker Home page fails to open, but gives an exception error

Article:TECH12713  |  Created: 2006-03-01  |  Updated: 2008-05-09  |  Article URL http://www.symantec.com/docs/TECH12713
Article Type
Technical Solution

Issue



Workers receive the following error when attempting to access the Worker Report.

Specified argument was out of the range of valid values.
Parameter name: <numeric value>
Details:
• Exception - System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
Parameter name:  <numeric value>
at System.Web.UI.WebControls.ListControl.set_SelectedValue(String value)
at _ASP.WorkerReport_ascx.LoadDataSources()
at Altiris.AppWeaver.TemplateModule.OnLoad(EventArgs e)

Where <numeric value> is a actual number like 72.


Environment



Helpdesk Solution 6.0

Cause



The <numeric value> from the error (72, for example) represents a Helpdesk query that has either been deleted or is no longer shared. The Worker Report (Worker's Home page) keeps a list of queries that are either shared or personal, non-shared, queries.  The <numeric value> was a query that was marked as the last report used on this page; however, the next time the worker returned to the home page, this query was no longer in the dropdown list.

Another cause is that the last time a user was in Helpdesk, the user used query X. While in the meantime query X was unshared, so every time the console was opened, this error occurred.

Solution



The tag table contains the information of what the last query was set to. The solution is simply to remove this specific query from being the last query so that the Worker Report will open up again using a default query.

  1. Open SQL Query Analyzer on the SQL server hosting the Altiris databases and change to the "Altiris_Incidents" database (or whatever your Helpdesk database happens to be).
  2. Once connected pass this SQL code into the Query text area and execute it. Be sure to change "<numeric value>" to the actual number that was seen in the error.

    --START SQL CODE
    delete from tag where name in ('last_query','last_report_query') and value='<numeric value>'
    --END SQL CODE

    Example:

    delete from tag where name in ('last_query','last_report_query') and value='72'

Legacy ID



20202


Article URL http://www.symantec.com/docs/TECH12713


Terms of use for this information are found in Legal Notices