Video Screencast Help
As we strive to continually improve your experience on our site, please help us by taking this survey and tell us about your satisfaction level using Symantec Connect. One lucky winner will receive 500 Connect points! * Take the survey.

BUG: Can't Use SQL Variables in Automation Report Email

Created: 04 Sep 2013 • Updated: 04 Sep 2013
noodleNT's picture
0 Agree
0 Disagree
0 0 Votes
Login to vote

I have a SQL Report in Altiris that has a bunch of @Variables defined. If I use this report in an Automation Policy to email me the results the email task will fail. If I go back and replace all the @Variables in the SQL code to hardcoded values the Automation Policy runs just fine and I get the email as expected.

System.IndexOutOfRangeException: Index was outside the bounds of the array. at Altiris.TaskManagement.Tokens.BaseToken.ReplaceServerTokenCallback(String tokenText, String tokenName, Object state) at Altiris.DotNetLib.Text.TextParsing.ReplaceTokens(String str, String delimiter, TokenValueCallback callback, Object state, Boolean bPassThrough) at Altiris.TaskManagement.Tokens.BaseToken.ReplaceServerTokenValues(String baseString, TokenDefinitionCollection tokens, Boolean bPassThroughUnresolved) at Altiris.TaskServerTasks.SendEmailTask.SendEmailServerTask.ReplaceTokens(String text, ParameterValueCollection input) at Altiris.TaskServerTasks.SendEmailTask.SendEmailServerTask.SendEmail(ParameterValueCollection input) at Altiris.TaskServerTasks.SendEmailTask.SendEmailServerTask.OnExecute(IServerTaskExecutionInstance instance) at Altiris.TaskManagement.ServerTasks.BaseServerTask.OnExecute(ITaskExecutionEngine engine, IServerTaskExecutionInstance instance, TaskInstanceRequest request) at Altiris.TaskManagement.ServerTasks.BaseServerTask.Execute(ITaskExecutionEngine engine, IBaseTaskExecutionInstance instance, TaskInstanceRequest request) at Altiris.TaskManagement.Common.Execution.Engine.TaskEngineExecutionThread.ExecuteTaskHandler()