Changes in 7.1.4

[NOTE] Database: New version of database for logging. Historic events will be cleared from this version.
[FEATURE] Client/Server: Introducing Audit logs
[FEATURE] Client/Server: Introducing Version logs
[FEATURE] Client: Assembly Task->Added support for using Variables in date time data type
[FEATURE] Client: Object relations->Search updated
[FEATURE] Client: FTP Task->Added override options for Transfer type in Connection for Download/Upload commands
[FEATURE] Client/Server: HTTP Task->Added different authentication types
[BUGFIX] Client: Tasks->Fixed a problem with non-responsive Edit button
[BUGFIX] Server: Folder delete Task->Fixed a problem converting old settings to new
[BUGFIX] Client: Calendar->Fixed another bug where the calendar - calculcating next executions
[BUGFIX] Server: SSIS DB Task->Fixed a problem with supplying project parameters
[BUGFIX] Client: Attachments->Fixed problems accessing some Job Variables in Email Task/Notification
[BUGFIX] Client: Log->Fixed an issue in the realtime log when open over night
[BUGFIX] Client: Calendar->Fixed an issue with showing scheduled Jobs in the future
[BUGFIX] Server: Variables->Fixed an issue with using File Conent Variable with Credentials
[BUGFIX] API: Sync->Now sending permissions if sync is off

Quick start documentation about Audit logs 

---

New version uploaded fixing issues with the internal database.

If you downloaded the 7.1.4. beta version before then please test the following:

1. install latest beta
2. run a job
3. check Job history of that Job

If window is empty, please do the following:

1. uninstall VisualCron
2. delete the files (c:/programdata/VisualCron/log/VisualCron4.sdf) and c:/program files (x86)/VisualCron/log/VisualCron4.sdf)
3. re-install latest beta

---

New upload,

+ fix hardcoded issue with Access
+ fixed running single Task problem

---

Hi Henrik,

I installed this version to see if it would fix my problem with the Delete Folder task issue, but once the installer finished the VisualCron service would not start. It would hang and then eventually timeout.

I was able to revert to 7.12 with no problems.

Thanks,
Matt

Hi Henrik,

I installed this version to see if it would fix my problem with the Delete Folder task issue, but once the installer finished the VisualCron service would not start. It would hang and then eventually timeout.

I was able to revert to 7.12 with no problems.

Thanks,
Matt

Could you send us the error from the event log from the time you tried to install this?

---

I received the following 3 errors in the System event log after the install:

#1
Source: SideBySide
Time: 2:01:16PM
Category None
Type: Error
EventID: 32

Dependent Assembly Microsoft.VC90.CRT could not be found and Last Error was The referenced assembly is not installed on your system.


#2
Source: SideBySide
Time: 2:01:16PM
Category None
Type: Error
EventID: 59

Resolve Partial Assembly failed for Microsoft.VC90.CRT. Reference error message: The referenced assembly is not installed on your system.


#3
Source: SideBySide
Time: 2:01:16PM
Category None
Type: Error
EventID: 59

Generate Activation Context failed for C:\Program Files\VisualCron\sqlceme40.dll. Reference error message: The referenced assembly is not installed on your system.

Thanks,
Matt

I received the following 3 errors in the System event log after the install:

#1
Source: SideBySide
Time: 2:01:16PM
Category None
Type: Error
EventID: 32

Dependent Assembly Microsoft.VC90.CRT could not be found and Last Error was The referenced assembly is not installed on your system.


#2
Source: SideBySide
Time: 2:01:16PM
Category None
Type: Error
EventID: 59

Resolve Partial Assembly failed for Microsoft.VC90.CRT. Reference error message: The referenced assembly is not installed on your system.


#3
Source: SideBySide
Time: 2:01:16PM
Category None
Type: Error
EventID: 59

Generate Activation Context failed for C:\Program Files\VisualCron\sqlceme40.dll. Reference error message: The referenced assembly is not installed on your system.

Thanks,
Matt

Which operating system do you use? And is it 32 or 64 bit?

---

The server I installed this one to is Windows Server 2003 Standard, 32bit.

I do have some other production servers that are running Windows Server 2008 R2 - 64bit, but I did not try installing it there yet.

Matt

The server I installed this one to is Windows Server 2003 Standard, 32bit.

I do have some other production servers that are running Windows Server 2008 R2 - 64bit, but I did not try installing it there yet.

Matt

We have not got the 2003 instance up yet but we are releasing a new build now. Please test.

---

New build, changes:

[FEATURE] Client/Server: Introducing Audit logs
[FEATURE] Client/Server: Introducing Version logs
[BUGFIX] Client: Log->Fixed an issue in the realtime log when open over night

---

I was able to test the Delete Folder function fix for this version by installing a fresh copy of VisualCron 5.7.4, adding some Delete Folder jobs, and then installing the 7.1.4 beta as an upgrade on Windows Server 2003 - 32bit (with the fix for VC90 files you gave me).

After the upgrade the Delete Folder function continued to work as expected and didn't delete the Base folder field. Looks good, and thanks for the quick fix!

Matt

New version, changes:

[FEATURE] Client: Assembly Task->Added support for using Variables in date time data type
+ fixed installer problems for SQLCE 4 on some servers (moakmatt)
+ various minor changes to audit log

---

New version, changes:

[BUGFIX] Client: Calendar->Fixed an issue with showing scheduled Jobs in the future

+ object relations updated with button from versions
+ permission AuditLog added
+ various Audit log related issues

---

New upload, changes:

[FEATURE] Client: Object relations->Search updated
+ various issues with Audit log

---

New upload:

+various changes and fixes in Audit log/Versions

---

New upload:

+ various fixes and changes in Audit log/Versions
+ added Object relations to different menus
+ fixed some error handling in FTP/SFTP Tasks

---

Hi Henrik,

I think the Audit Trail / Log / Diff enhancements are looking good.

As a site with multiple users & multiple servers we will find this a great enhancement.

Reversion is very good also.

Couple of minor points :

1) In terms of version management, when you revert to an earlier it would be useful to see that it was a reversion, not just another change in the Summary - Screen 1
2) Mouse Over is excellent, many of the changes / field values will be large. Can we indicate on screen (perhaps "...") that there is more to see as a visual cue ? May be worth tweaking the columns to maximize the before / after - Screen 2 & Screen 2a
3) Use of VisualCron Default Admin (Locally) Compromises Audit Trail (as it does really for Maintenance . . . where you have multiple Job admins). Screen 3
4) You will note that Job Changes are logging trigger changes in the summary which is not correct (The DIFF is correct). Would be *nice* if the trigger is mentioned in the summary only when trigger changed, not job change where there happens to be a trigger present. Screen 3

Hi Henrik,

Post Upgrade I am getting an error on a basic File copy task.

Please See attached Screen Prints.

Test of file copy is OK.

Process previously running OK.

---
Exception in Task: startIndex cannot be larger than length of string.
Parameter name: startIndex
Exception in Task: No file(s) copied
---

Hi Henrik,

Post Upgrade I am getting an error on a basic File copy task.

Please See attached Screen Prints.

Test of file copy is OK.

Process previously running OK.

---
Exception in Task: startIndex cannot be larger than length of string.
Parameter name: startIndex
Exception in Task: No file(s) copied
---

Please copy paste exactly what the Variables contain.

---

New version uploaded, changes:

[FEATURE] Client: FTP Task->Added override options for Transfer type in Connection for Download/Upload commands
[BUGFIX] Server: Variables->Fixed an issue with using File Conent Variable with Credentials

+ fixes an issue with Credentials window
+ other minor audit log fixes

---

New version uploaded:

+ fixes queries and indexes

This version will clear current log file.

---

Hi Henrik,

User Variables Attached in Screen Prints (But they appear OK and are unchanged from previous).

It appears that previous renaming with file wildcards that worked in 7.1.3 are not working in this version ?

i.e. this destination file mask on copy (Screen 2):

* - {COMPUTER(Name)} - {DATEFORMAT(yyyy-MM-dd)}.*

Just a * above (No rename) works of course, but adding back the above fails with the index error.

Have also attached 'history' in folder of what we have had in the past pre going the 7.1.4 beta which is a daily snapshot of visualcron settings.

Please note the last screen print where I have replaced the variables above with hard coded labels and it is still not working (same error)

Once I remove the extension part of the rename it works !

Regards

Kevin

New upload, fixes:

[BUGFIX] API: Sync->Now sending permissions if sync is off
+ small installer fixes
+ fixed issue with Assembly execute Task hanging for 20s
+ minor audit log changes

---

New upload - fixed issue with setting user that runs service.

---

New upload:

[FEATURE] Client/Server: HTTP Task->Added different authentication types

---