Automation Policy: "Contracts expiring in the next 30 days" is failing

book

Article ID: 170319

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

Automation Policy "Contracts expiring in the next 30 days" is failing with below error on console:
An unexpected error occurred. Please check the logs for details. Parameter value can not be null.
 

Error in Altiris logs:

Error-1:

Could not execute query for data source: Altiris.Automation.AutomationPolicies.DataSources.DataSourceDataSource+WrapData
Parameter value can not be null.
   [Altiris.Parameters.Exceptions.AeXInvalidParameterValueException @ Altiris.Reporting.UI]
   at Altiris.Reporting.Parameters.ParameterValueEditControls.BasicParameterValueEditControl.get_Value()
   at Altiris.Automation.AutomationPolicies.DataSources.DataSourceDataSource.WrapData.LoadData(Object objExecutionContextData)

Error-2:

Unexpected error in automation policies.
Parameter value can not be null.
   [Altiris.Parameters.Exceptions.AeXInvalidParameterValueException @ Altiris.Reporting.UI]
   at Altiris.Reporting.Parameters.ParameterValueEditControls.BasicParameterValueEditControl.get_Value()
   at Altiris.Automation.AutomationPolicies.DataSources.DataSourceDataSource.WrapData.LoadData(Object objExecutionContextData)
   at Altiris.Automation.AutomationPolicies.AutomationPolicy.Execute(Object objExecutionContextData)
   at Altiris.Automation.AutomationPolicies.Triggers.TriggerBase.Altiris.Automation.Framework.ITriggerTest.FireTrigger(IAutomationPolicy policy, Object objExecutionContextData)
   at Altiris.Automation.Web.AutomationPolicyUI.AutomationPolicyUIPage.btnTestNP_Click(Object sender, EventArgs e)

Cause

Known Issue

Environment

Symantec Management Platform 8.1 RU2/3

Resolution

This issue is fixed in Symantec ITMS 8.1 RU4. Please refer to Fixed issues for Notification Server section, Page 18 in 8.1 RU4 Release Notes (DOC10690).

There are different workarounds to get it working, like:

  1. Under Details, Select the Data Source as Report.
    1. Click on Edit input parameter and type 30 in "Days Until Expiration".
    2. Under Actions > Run job/task, select Email 'Contracts expiring in the next N days' and click OK.
    3. Then Edit input parameter and set following as Data Source and click OK:
    4. To: Custom: Provide the required email address.
    5. CC: Custom: Provide the required email address or leave it blank.
    6. Days: Custom: 30.
    7. contractname: Name.
    8. contracttype: Contract Type.
    9. enddate: Expiration Date.
  2. Create a new policy or clone the exiting policy.
    1. Click on Edit Query and copy the SQL query from Resolved Query tab and click OK.
    2. Then, select the Data Source as Raw SQL query > Edit Query and under Parameterized Query paste the copied SQL.
    3. Click on Resolved Query and Results tab to verify that it works.
    4. Under Actions, select same job/task and Edit Input Parameter as above.