Hello,

Can you please assist us regarding an SSISDB package issue.

In fact have updated VC from version 7.4.x to the last one 8.2.7 and since this action we have some trouble with SSISDB package.

Here are more details below :

-- VC Client: 8.2.7
-- Via SQL explorer --> connections are OK, environnment is present
-- No changes has been made on SQL Server side
-- Task has been re-created from scratch without success

For another SSISDB package, the task is now showed as success but we have the following output : ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6642)->ExecutePackage->Completed without any serious errors


ERROR MESSAGE:

15:25:38: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->ExecutePackage->Using the 32 bit runtime: False
15:25:38: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->ExecutePackage->Environment reference count: 1
15:25:38: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->ExecutePackage->Found environment: 'UAT' in folder: 'Wealth data flows'
15:25:38: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->Preparing to set environment: 'UAT' for folder: 'Wealth data flows'
15:25:38: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->Environment not found!
15:25:38: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->Assembly loaded: Microsoft.SqlServer.IntegrationServices.Common.ObjectModel, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
15:25:38: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->ExecutePackage->executionId: 101640
15:25:39: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->ExecutePackage->execution->Messages.Count: 0
15:25:39: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->ExecutePackage->Waiting for completion
15:25:42: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->ExecutePackage->Wait complete
15:25:42: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->ExecutePackage->Error message log complete
15:25:42: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->Execution status: Failed
15:25:42: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->Package execution result: Failure
15:25:42: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->Preparing Task log
15:25:42: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->Sending result
15:25:42: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->Result sent
15:25:44: Server->Executing Task process exited with exit code: 0
15:25:44: Server->Waiting for completion and result
15:25:44: Server->Task result received, success: False


Many thanks for your assistance,
J.

Have you selected the Environment in the Task? Please send screenshot of the Task.

---

Hi,
Yes the environnment has been selected as it should be.

Here are more details:

Task : execute SSISDB Package.

When we run the task from visual cron with a specific user (norkomuat) , its failing with output :

15:25:38: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->ExecutePackage->Using the 32 bit runtime: False
15:25:38: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->ExecutePackage->Environment reference count: 1
15:25:38: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->ExecutePackage->Found environment: 'UAT' in folder: 'Wealth data flows'
15:25:38: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->Preparing to set environment: 'UAT' for folder: 'Wealth data flows'
15:25:38: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->Environment not found!
15:25:38: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->Assembly loaded: Microsoft.SqlServer.IntegrationServices.Common.ObjectModel, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
15:25:38: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->ExecutePackage->executionId: 101640
15:25:39: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->ExecutePackage->execution->Messages.Count: 0
15:25:39: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->ExecutePackage->Waiting for completion
15:25:42: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->ExecutePackage->Wait complete
15:25:42: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->ExecutePackage->Error message log complete
15:25:42: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->Execution status: Failed
15:25:42: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->Package execution result: Failure
15:25:42: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->Preparing Task log
15:25:42: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->Sending result
15:25:42: ExecuteProcess("C:\Program Files (x86)\VisualCron\\MSSQLSSISDB\SSISDBExecute.exe" 6644)->Result sent
15:25:44: Server->Executing Task process exited with exit code: 0
15:25:44: Server->Waiting for completion and result
15:25:44: Server->Task result received, success: False

When we run the same task from visual cron with another user, the task is working => completed without any serious errors.


Many thanks,
Tozier

But While executing the same package via the SQL server management studio with credentials that are failing with the visual cron task it is working ok.

I wonder if it works better if you use Environment:

Wealth data flows\UAT

---

Hi Henrik,


Sorry for the late reply. This has been fixed.

Thanks,

Tozier