Community forum

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


Guest
2014-09-08T15:01:40Z
For me it's happening w/ the execution of an executable as well as the execution of an ssis. I think it related to the length of time the step takes however i'm not certain. Any idea's why i get an error 255 on occasion?



07:30:00: Server->Execute path: C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe
07:30:00: Server->Executing Task process
07:30:00: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Assembly loaded: System.IdentityModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
07:30:00: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->CreateService->Response channel created on address: /TaskProcess/89147
07:30:00: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Requesting Task information
07:30:00: Server->Sending Task information
07:30:00: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Task information sent
07:30:00: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Assembly loaded: System.Transactions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
07:30:00: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Task information received
07:30:00: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Before execute
07:30:00: Server->Task information sent
07:30:00: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Assembly loaded: Microsoft.SqlServer.Management.IntegrationServices, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
07:30:00: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Assembly loaded: Microsoft.SqlServer.Management.Sdk.Sfc, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
07:30:00: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Assembly loaded: Microsoft.SqlServer.ConnectionInfo, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
07:30:00: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->task.Folder->Fattail
07:30:00: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->task.ProjectName->Fattail Daily Prod
07:30:00: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->task.PackageName->Fattail_Daily_PROD.dtsx
07:30:00: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->task.ConnectionString->Data Source=pschedwinv01;Initial Catalog=SSISDB;Integrated Security=SSPI;
07:30:00: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Assembly loaded: Microsoft.SqlServer.Diagnostics.STrace, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
07:30:00: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Assembly loaded: Microsoft.SqlServer.SqlClrProvider, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
07:30:00: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Assembly loaded: System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Assembly loaded: Microsoft.SqlServer.Management.IntegrationServicesEnum, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->task.Catalog->SSISDB
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Assembly loaded: System.Numerics, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Assembly loaded: System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Retrieving catalogFolder (10 folder(s))
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Catalog containing folder: DFP_Data_Load
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Catalog containing folder: eBay
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Catalog containing folder: ExternalData
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Catalog containing folder: Fattail
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Catalog containing folder: Omniture_referrer_source_walmart_club
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Catalog containing folder: SCOMP
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Catalog containing folder: VCRON Jobs
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Catalog containing folder: Walmart API
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Catalog containing folder: WalmartFinancial
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Catalog containing folder: zOBSOLETE
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Retrieving the project from catalogFolder (5 project(s))
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Catalog folder containing project: Fattail Daily PROD Update
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Catalog folder containing project: Fattail Daily Prod
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Catalog folder containing project: Fattail Hourly Prod
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Catalog folder containing project: Fattail Prod Revision
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Catalog folder containing project: Fattail Quart Hourly PROD
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Retrieving the package from project (1 package(s))
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Project containing package: Fattail_Daily_PROD.dtsx
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package found, id: 59
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter count: 25
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Preparing value parameters
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Looping through parameters
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.100dw01.Fattail.ConnectionString, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.100dw01.Fattail.InitialCatalog, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.100dw01.Fattail.Password, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.100dw01.Fattail.RetainSameConnection, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.100dw01.Fattail.ServerName, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.100dw01.Fattail.UserName, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.Excel Connection Manager.ConnectionString, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.Excel Connection Manager.ExcelFilePath, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.Excel Connection Manager.FirstRowHasColumnName, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.Excel Connection Manager.InitialCatalog, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.Excel Connection Manager.Password, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.Excel Connection Manager.RetainSameConnection, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.Excel Connection Manager.ServerName, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.Excel Connection Manager.UserName, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.SFDC_Daily_Details__*.csv.AlwaysCheckForRowDelimiters, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.SFDC_Daily_Details__*.csv.CodePage, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.SFDC_Daily_Details__*.csv.ColumnNamesInFirstDataRow, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.SFDC_Daily_Details__*.csv.DataRowsToSkip, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.SFDC_Daily_Details__*.csv.Format, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.SFDC_Daily_Details__*.csv.HeaderRowDelimiter, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.SFDC_Daily_Details__*.csv.HeaderRowsToSkip, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.SFDC_Daily_Details__*.csv.LocaleID, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.SFDC_Daily_Details__*.csv.RowDelimiter, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.SFDC_Daily_Details__*.csv.TextQualifier, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Package parameter: CM.SFDC_Daily_Details__*.csv.Unicode, value type: Literal, object type: 30
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Parameters set
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Looping through project parameters
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Project parameter: CM.PSCHEDWINV01.SSISDB.ConnectionString, value type: Literal, object type: 20
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Project parameter: CM.PSCHEDWINV01.SSISDB.InitialCatalog, value type: Literal, object type: 20
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Project parameter: CM.PSCHEDWINV01.SSISDB.Password, value type: Literal, object type: 20
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Project parameter: CM.PSCHEDWINV01.SSISDB.RetainSameConnection, value type: Literal, object type: 20
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Project parameter: CM.PSCHEDWINV01.SSISDB.ServerName, value type: Literal, object type: 20
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Project parameter: CM.PSCHEDWINV01.SSISDB.UserName, value type: Literal, object type: 20
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Setting project parameters
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Using the 32 bit runtime: False
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Environment reference count: 0
07:30:01: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Assembly loaded: Microsoft.SqlServer.IntegrationServices.Common.ObjectModel, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
07:30:02: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->executionId: 16893
07:30:11: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->execution->Messages.Count: 48
07:30:11: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->ExecutePackage->Waiting for completion
07:32:00: ExecuteProcess("C:\SetupWS\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 89147)->Assembly loaded: System.Xaml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
07:47:38: Server->Executing Task process exited with exit code: 255
Sponsor
Forum information
Support
2014-09-08T16:18:07Z
Which version are you using - this should be fixed in 7.2.0.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top