Video Screencast Help
Protect Your POS Environment Against Retail Data Breaches. Learn More.

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()