Started running \\londata002.uk.net.intra\CMPPBI\Environment\CIA SBX\Alteryx\Workflows\SystemMonitor BigData\LogScrapper\LogScrapper.yxmd at Wed Jan 13 08:55:15 2016
00:00:0.021 - Alteryx: Allocating requested dedicated sort/join memory would be more than available physical memory.  Reverting to 208MB of memory.
00:00:0.143 - ToolId 163: Tool #8: Alias translated to odb:Provider=SQLOLEDB.1;Password=__EncPwd1__;Persist Security Info=True;User ID=CIA_admin;Initial Catalog=CIA;Data Source=LONS00114361\FIENTDEV, 51463;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=LONS00110450;Use Encryption for Data=False;Tag with column collation when possible=False|Audit."Configuration"
00:00:0.252 - ToolId 163: Tool #8: 2391 records were read from aka:CIA_LOCAL (Audit."Configuration")
00:00:0.269 - ToolId 163: Tool #3: 105 records were True and 2286 were False
00:00:0.291 - ToolId 163: Tool #10: Tool #1: 1 record was output
00:00:0.306 - ToolId 163: Tool #11: 21 records were joined with 0 un-joined left records and 84 un-joined right records
00:00:0.329 - ToolId 164: 1 records were True and 0 were False
00:00:1.906 - ToolId 171: Record #1: Tool #12: LogScrapper_StartBatch Ran Successfully
00:00:1.936 - ToolId 171: Record #1: Tool #12: 1 iterations were run
00:00:1.970 - ToolId 171: 1 iterations were run
00:00:15.811 - ToolId 169: Record #1: Tool #16: ParseLogFiles Ran Successfully
00:00:15.870 - ToolId 169: 1 iterations were run
00:00:22.213 - ToolId 203: Record #1: Tool #16: ParseLogFilesCommitSuccess Ran Successfully
00:00:22.303 - ToolId 203: 1 iterations were run
00:00:26.130 - ToolId 170: Record #1: Tool #16: ParseErrorMessages Ran Successfully
00:00:26.194 - ToolId 170: 1 iterations were run
00:00:28.670 - ToolId 204: Record #1: Tool #16: ParseErrorMessagesCommitSuccess Ran Successfully
00:00:28.727 - ToolId 204: 1 iterations were run
00:00:28.950 - Error - ToolId 206: Record #1: Tool #16: Tool #44: Record #1: Alteryx Engine: Unable to create log file "\\londata002.uk.net.intra\CMPPBI\Alteryx Log Files\Current\Alteryx_Log_1452675344_1.log"
00:00:34.438 - ToolId 206: Record #1: Tool #16: LoadBatchModuleLogs Ran Successfully
00:00:34.479 - ToolId 206: 1 iterations were run
00:00:41.791 - ToolId 202: Record #1: Tool #16: MoveLogFilesToArchive Ran Successfully
00:00:41.852 - ToolId 202: 1 iterations were run
00:00:41.869 - ToolId 199: Tool #3: 0 records were True and 0 were False
00:00:41.888 - ToolId 192: Tool #71: 27 records were True and 0 were False
00:00:41.906 - ToolId 192: Tool #37: 7 unique records and 20 duplicates were found
00:00:41.923 - ToolId 192: Tool #108: Summarize (3): 27 records were summarized to 1 groups
00:00:41.936 - ToolId 192: Tool #108: Text Input (1): 1 record was output
00:00:41.963 - ToolId 192: Tool #106: Alias translated to odb:Provider=SQLOLEDB.1;Password=__EncPwd1__;Persist Security Info=True;User ID=CIA_admin;Initial Catalog=CIA;Data Source=LONS00114361\FIENTDEV, 51463;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=LONS00110450;Use Encryption for Data=False;Tag with column collation when possible=False|SELECT [BatchId]
      ,[BatchName]
      ,[StartTime]
      ,[EndTime]
      ,[Status]
  FROM [Audit].[BatchStatus]
WHERE 27 >=0
00:00:42.106 - ToolId 192: Tool #106: 15269 records were read from aka:CIA_LOCAL (SELECT [BatchId]
      ,[BatchName]
      ,[StartTime]
      ,[EndTime]
      ,[Status]
  FROM [Audit].[BatchStatus]
WHERE 27 >=0)
00:00:42.123 - ToolId 192: Tool #106: 15269 records were read from 1 files/queries
00:00:42.182 - ToolId 193: 1 record was output
00:00:42.206 - ToolId 192: Tool #88: 277 records were joined with 0 un-joined left records and 14992 un-joined right records
00:00:42.220 - ToolId 192: Tool #90: 1 records were True and 276 were False
00:00:42.241 - ToolId 192: Tool #91: Alias translated to odb:Provider=SQLOLEDB.1;Password=__EncPwd1__;Persist Security Info=True;User ID=CIA_admin;Initial Catalog=CIA;Data Source=LONS00114361\FIENTDEV, 51463;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=LONS00110450;Use Encryption for Data=False;Tag with column collation when possible=False|SELECT * FROM Audit.BatchModules
where BatchId = 15401
00:00:42.280 - ToolId 192: Tool #91: 7 records were read from aka:CIA_LOCAL (SELECT * FROM Audit.BatchModules
where BatchId = 15401)
00:00:42.293 - ToolId 192: Tool #91: 7 records were read from 1 files/queries
00:00:42.313 - ToolId 192: Tool #93: 0 records were joined with 7 un-joined left records and 15269 un-joined right records
00:00:42.328 - ToolId 192: Tool #94: 0 records were True and 0 were False
00:00:42.346 - ToolId 192: Tool #112: 0 records were joined with 0 un-joined left records and 7 un-joined right records
00:00:42.361 - ToolId 192: Tool #63: 7 records were summarized to 1 groups
00:00:42.382 - ToolId 192: Tool #52: Alias translated to odb:Provider=SQLOLEDB.1;Password=__EncPwd1__;Persist Security Info=True;User ID=CIA_admin;Initial Catalog=CIA;Data Source=LONS00114361\FIENTDEV, 51463;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=LONS00110450;Use Encryption for Data=False;Tag with column collation when possible=False|SELECT * FROM Audit."BatchStatus"
WHERE StartTime > '2000-01-01'
00:00:42.500 - ToolId 192: Tool #52: 15265 records were read from aka:CIA_LOCAL (SELECT * FROM Audit."BatchStatus"
WHERE StartTime > '2000-01-01')
00:00:42.517 - ToolId 192: Tool #52: 15265 records were read from 1 files/queries
00:00:42.560 - ToolId 192: Tool #43: Alias translated to odb:Provider=SQLOLEDB.1;Password=__EncPwd1__;Persist Security Info=True;User ID=CIA_admin;Initial Catalog=CIA;Data Source=LONS00114361\FIENTDEV, 51463;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=LONS00110450;Use Encryption for Data=False;Tag with column collation when possible=False|Audit.BatchStatus
00:00:42.641 - ToolId 192: Tool #46: 277 records were joined with 0 un-joined left records and 14988 un-joined right records
00:00:42.664 - ToolId 192: Tool #50: 277 target records generated 277 output records
00:00:42.680 - ToolId 192: Tool #47: 1 records were True and 276 were False
00:00:42.714 - ToolId 192: Tool #44: Alias translated to odb:Provider=SQLOLEDB.1;Password=__EncPwd1__;Persist Security Info=True;User ID=CIA_admin;Initial Catalog=CIA;Data Source=LONS00114361\FIENTDEV, 51463;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=LONS00110450;Use Encryption for Data=False;Tag with column collation when possible=False|Audit.BatchModulesStatus
00:00:48.248 - ToolId 192: Tool #68: Alias translated to odb:Provider=SQLOLEDB.1;Password=__EncPwd1__;Persist Security Info=True;User ID=CIA_admin;Initial Catalog=CIA;Data Source=LONS00114361\FIENTDEV, 51463;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=LONS00110450;Use Encryption for Data=False;Tag with column collation when possible=False|Audit.BatchModulesLogs
00:00:48.321 - ToolId 192: Tool #40: 7 target records generated 7 output records
00:00:48.374 - ToolId 192: Tool #44: 7 records were written to aka:CIA_LOCAL (Audit.BatchModulesStatus)
00:00:48.395 - ToolId 192: Tool #65: Tool #7: 789 records were successfully parsed and 37 were not.
00:00:48.546 - ToolId 192: Tool #68: 826 records were written to aka:CIA_LOCAL (Audit.BatchModulesLogs)
00:00:48.593 - ToolId 192: Tool #72: Alias translated to odb:Provider=SQLOLEDB.1;Password=__EncPwd1__;Persist Security Info=True;User ID=CIA_admin;Initial Catalog=CIA;Data Source=LONS00114361\FIENTDEV, 51463;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=LONS00110450;Use Encryption for Data=False;Tag with column collation when possible=False|SELECT * FROM Control."FileStatus"
WHERE BatchId = 15401
00:00:48.628 - ToolId 192: Tool #72: 4 records were read from aka:CIA_LOCAL (SELECT * FROM Control."FileStatus"
WHERE BatchId = 15401)
00:00:48.656 - ToolId 192: Tool #72: 4 records were read from 1 files/queries
00:00:48.674 - ToolId 192: Tool #77: 0 records were True and 4 were False
00:00:48.703 - ToolId 192: Tool #80: Alias translated to odb:Provider=SQLOLEDB.1;Password=__EncPwd1__;Persist Security Info=True;User ID=CIA_admin;Initial Catalog=CIA;Data Source=LONS00114361\FIENTDEV, 51463;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=LONS00110450;Use Encryption for Data=False;Tag with column collation when possible=False|SELECT * FROM Control."IndexFileStatus"
WHERE BatchId = 15401
00:00:48.728 - ToolId 192: Tool #80: 0 records were read from aka:CIA_LOCAL (SELECT * FROM Control."IndexFileStatus"
WHERE BatchId = 15401)
00:00:48.761 - ToolId 192: Tool #80: 0 records were read from 1 files/queries
00:00:48.785 - ToolId 192: Tool #83: 0 records were True and 0 were False
00:00:48.842 - ToolId 192: Tool #43: 1 records have been updated.
00:00:48.877 - ToolId 192: Tool #43: 1 records were written to aka:CIA_LOCAL (Audit.BatchStatus)
Finished in 00:00:48.908 with 1 error