Changes in 5.6.6

[FEATURE] Client/Server: Added Excel read cell Task
[FEATURE] Client/Server: Added namespace support for XML Read Task
[BUGFIX] Client/API: Fixed a bug where a user could update her/his own permissions
[BUGFIX] Client: Fixed a problem with SSH/Terminal Explorer being slow
[BUGFIX] Client: Fixed a UI problem with the Event log Trigger and Category operator
[BUGFIX] Server: Fixed a problem with the Event log Trigger where Event type was not matching correctly

---

Hi Henrik,

I have an issue with this version. I upgraded from 5.6.2 which worked fine.

I have a task which executes a bat file. The contents of the .bat file is below:

rem Merge multisheets into 1 each
copy /b ..\AML_Account.xls_Sheet*.csv ..\AML_Account.csv
copy /b ..\AML_Customer.xls_Sheet*.csv ..\AML_Customer.csv
copy /b ..\AML_CustomerExtended.xls_Sheet*.csv ..\AML_CustomerExtended.csv
copy /b ..\AML_EODBalance.xls_Sheet*.csv ..\AML_EODBalance.csv
copy /b ..\AML_Relationship.xls_Sheet*.csv ..\AML_Relationship.csv
copy /b ..\AML_Transaction.xls_Sheet*.csv ..\AML_Transaction.csv

The log doesn't show any error and the job runs successfully.

25/08/2010 9:28:55 AM Debug Task (1202) was added to processlist: 2 Merge CSV Sheets into 1 each
25/08/2010 9:28:55 AM Info Task started: 2 Merge CSV Sheets into 1 each (1202)
25/08/2010 9:28:55 AM Debug Process status - retrieving process id (1202)
25/08/2010 9:28:57 AM Debug Process status - has left WaitForExit (1202)
25/08/2010 9:28:57 AM Debug Process status - OutPut captured (1202)
25/08/2010 9:28:57 AM Debug Process status - trying to retrieve exit code
25/08/2010 9:28:57 AM Debug Process status - ExitCode fetched (1202)
25/08/2010 9:28:57 AM Debug Process status - ProcessHandles closed (1202)
25/08/2010 9:28:57 AM Debug Ending timeout timer (1202)
25/08/2010 9:28:57 AM Debug Ending output readers (1202)
25/08/2010 9:28:57 AM Debug Closing desktop handles (1202)
25/08/2010 9:28:57 AM Debug Process status - About to raise TaskCompleted (1202)
25/08/2010 9:28:57 AM Info Task completed: 2 Merge CSV Sheets into 1 each (1202)
25/08/2010 9:28:57 AM Debug Setting previous task in TaskProcessCompleted: 2 Merge CSV Sheets into 1 each (78c06edf-608d-40a4-b646-e3b422d98562) in job: [Daily] AML 1 BUILD files
25/08/2010 9:28:57 AM Debug Process status - About to SendTaskProcess (1202)
25/08/2010 9:28:57 AM Debug Process status - About to RemoveTaskProcess (1202)
25/08/2010 9:28:57 AM Debug Task (1202) was removed from processlist: 2 Merge CSV Sheets into 1 each

Running this .bat file manually works fine.

Update: I have noticed a few of my tasks using "execute" and "execute script" are failing to run yet successfully finish. They contain .vbs or .bat scripts.

What has changed that might have affected these?

Tested the Excel task.

- use active worksheet looks like the 1st sheet?

- cell by position is zero based.

- cell by reference is working well

-For the range it seems I have to put in the begin and the end cells. The GUI was a bit unclear how to do this. Normally a range is like A3:G6, but it looks like I have to put in one cell for start and end. I think only by reference is enough, and you can check if the entered value is one cell or a range.

-When the range is larger than the content in the sheet I receive an error. I'm not sure why this should be an error, you just grab more empty cells.

- I receive also errors in the range selection when the range is smaller than the content

- Everything in the output tab is not saved, so the output style is not configurable


Regards,
Erik

---

Hi Henrik,

I have an issue with this version. I upgraded from 5.6.2 which worked fine.

I have a task which executes a bat file. The contents of the .bat file is below:

rem Merge multisheets into 1 each
copy /b ..\AML_Account.xls_Sheet*.csv ..\AML_Account.csv
copy /b ..\AML_Customer.xls_Sheet*.csv ..\AML_Customer.csv
copy /b ..\AML_CustomerExtended.xls_Sheet*.csv ..\AML_CustomerExtended.csv
copy /b ..\AML_EODBalance.xls_Sheet*.csv ..\AML_EODBalance.csv
copy /b ..\AML_Relationship.xls_Sheet*.csv ..\AML_Relationship.csv
copy /b ..\AML_Transaction.xls_Sheet*.csv ..\AML_Transaction.csv

The log doesn't show any error and the job runs successfully.

25/08/2010 9:28:55 AM Debug Task (1202) was added to processlist: 2 Merge CSV Sheets into 1 each
25/08/2010 9:28:55 AM Info Task started: 2 Merge CSV Sheets into 1 each (1202)
25/08/2010 9:28:55 AM Debug Process status - retrieving process id (1202)
25/08/2010 9:28:57 AM Debug Process status - has left WaitForExit (1202)
25/08/2010 9:28:57 AM Debug Process status - OutPut captured (1202)
25/08/2010 9:28:57 AM Debug Process status - trying to retrieve exit code
25/08/2010 9:28:57 AM Debug Process status - ExitCode fetched (1202)
25/08/2010 9:28:57 AM Debug Process status - ProcessHandles closed (1202)
25/08/2010 9:28:57 AM Debug Ending timeout timer (1202)
25/08/2010 9:28:57 AM Debug Ending output readers (1202)
25/08/2010 9:28:57 AM Debug Closing desktop handles (1202)
25/08/2010 9:28:57 AM Debug Process status - About to raise TaskCompleted (1202)
25/08/2010 9:28:57 AM Info Task completed: 2 Merge CSV Sheets into 1 each (1202)
25/08/2010 9:28:57 AM Debug Setting previous task in TaskProcessCompleted: 2 Merge CSV Sheets into 1 each (78c06edf-608d-40a4-b646-e3b422d98562) in job: [Daily] AML 1 BUILD files
25/08/2010 9:28:57 AM Debug Process status - About to SendTaskProcess (1202)
25/08/2010 9:28:57 AM Debug Process status - About to RemoveTaskProcess (1202)
25/08/2010 9:28:57 AM Debug Task (1202) was removed from processlist: 2 Merge CSV Sheets into 1 each

Running this .bat file manually works fine.

Update: I have noticed a few of my tasks using "execute" and "execute script" are failing to run yet successfully finish. They contain .vbs or .bat scripts.

What has changed that might have affected these?

From what I can see, no changes have been made. I would create a simple test with a copy with absolute paths (not relative) first - could you do that?

Perhaps, you used another user than SYSTEM in last install?

---

Henrik,

I used the same user (administrator) with domain admin access while installing.

I tried with a new job with an absolute path and a relative path - still no luck the job runs but does not execute the script.

Henrik,

I used the same user (administrator) with domain admin access while installing.

I tried with a new job with an absolute path and a relative path - still no luck the job runs but does not execute the script.

I was thinking about the user that runs the VisualCron service - not the user that is used during installation.

I think we need to go deeper into what you mean by "the job runs but does not execute the script".

1. do the Task run?
2. what output do you have in standard output and standard error column when you double click on them? This should probably tell about why it fails.

---

Tested the Excel task.

- use active worksheet looks like the 1st sheet?

- cell by position is zero based.

- cell by reference is working well

-For the range it seems I have to put in the begin and the end cells. The GUI was a bit unclear how to do this. Normally a range is like A3:G6, but it looks like I have to put in one cell for start and end. I think only by reference is enough, and you can check if the entered value is one cell or a range.

-When the range is larger than the content in the sheet I receive an error. I'm not sure why this should be an error, you just grab more empty cells.

- I receive also errors in the range selection when the range is smaller than the content

- Everything in the output tab is not saved, so the output style is not configurable


Regards,
Erik

Thanks Erik, we will look at this.

---

Henrik,

I used the same user (administrator) with domain admin access while installing.

I tried with a new job with an absolute path and a relative path - still no luck the job runs but does not execute the script.

I was thinking about the user that runs the VisualCron service - not the user that is used during installation.

I think we need to go deeper into what you mean by "the job runs but does not execute the script".

1. do the Task run?
2. what output do you have in standard output and standard error column when you double click on them? This should probably tell about why it fails.

ok this is the actual job - it contains 4 tasks



Task 1 completes how it is supposed to. The .VBS runs and converts the files.
Task 2 completes but does not launch the .bat file - it shows as successful.
Task 3 same as task 2
Task 4 completes how it is supposed to.

I have set store standard output and store standard error checked.

The account that runs the visualcron service is Au\administrator which has domain admin access.

Levi,

if you are:

1. having problems with the Execute Task
2. the only lines in the .bat file are:

rem Merge multisheets into 1 each
copy /b ..\AML_Account.xls_Sheet*.csv ..\AML_Account.csv
copy /b ..\AML_Customer.xls_Sheet*.csv ..\AML_Customer.csv
copy /b ..\AML_CustomerExtended.xls_Sheet*.csv ..\AML_CustomerExtended.csv
copy /b ..\AML_EODBalance.xls_Sheet*.csv ..\AML_EODBalance.csv
copy /b ..\AML_Relationship.xls_Sheet*.csv ..\AML_Relationship.csv
copy /b ..\AML_Transaction.xls_Sheet*.csv ..\AML_Transaction.csv

3. and you use the settings listed above

..then, something is very strange unless you are using a Condition on those Tasks or some kind of other flow.

Have you turned of Standard output logging? You should get output as it is a normal batch file. Try recreating the Job with just one Task and you will see.

---

Still the same after recreating the job/task.

no output also.

Still the same after recreating the job/task.

no output also.

Could we do screen sharing? Please download Yuuguu and add user visualcron@gmail.com

---

hi Henrik,

I am unable to do screen sharing as we are behind a firewall and it would require change management forms to be filled out etc..

Is there anything else I can try?

Henrik,

I have checked the windows event viewer and can see cmd.exe crashing each time the job is running. I am running Windows 2008 SP2 with all updates.

Faulting application cmd.exe, version 6.0.6001.18000, time stamp 0x47918bde, faulting module kernel32.dll, version 6.0.6002.18005, time stamp 0x49e03821, exception code 0xc0000142, fault offset 0x00009eed, process id 0x1bac, application start time 0x01cb458978f13929.

Henrik,

I have checked the windows event viewer and can see cmd.exe crashing each time the job is running. I am running Windows 2008 SP2 with all updates.

Faulting application cmd.exe, version 6.0.6001.18000, time stamp 0x47918bde, faulting module kernel32.dll, version 6.0.6002.18005, time stamp 0x49e03821, exception code 0xc0000142, fault offset 0x00009eed, process id 0x1bac, application start time 0x01cb458978f13929.

Have never seen that before. Looks more like a Windows update have caused this as the crash is in Windows and not in VisualCron.

Yuuguu does not require that you open any incoming ports so you don't need firewall changes.

Btw, why don't you use the Copy files Task?

---

Henrik,

We use the .bat to merge .csv files - copy files task does not do that

Henrik,

We use the .bat to merge .csv files - copy files task does not do that

Oh, missed that, we will add Merge Task right away, it is something that is missing. What merge functions are you looking for?

---

Great Henrik!

We would like to merge csv/txt files (with wildcards) - exactly like what the .bat file does.

Hi Henrik,

I have figured what as caused this.

There were a few GPO settings in relation to UAC prompting which were enabled in the domain which were causing cmd.exe cscript.exe wscript.exe and other unsigned .exes to prompt for elevation (without VC knowing) thus causing it to crash!

Hi Henrik,

I have figured what as caused this.

There were a few GPO settings in relation to UAC prompting which were enabled in the domain which were causing cmd.exe cscript.exe wscript.exe and other unsigned .exes to prompt for elevation (without VC knowing) thus causing it to crash!

Ok, great that it was resolved. Thanks for the update.

---

Henrik,

We use the .bat to merge .csv files - copy files task does not do that

Test the new Task here:

http://www.visualcron.co....aspx?g=posts&t=1423 

---