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


Wealthbridge
2009-06-23T23:49:58Z
While testing a new Job on v5.1.2 (on Win2k SP4) the Client never showed updated information about the job and the things that the job was supposed to do didn't happen.
When I closed and re-opened the Client, an unhanded exception error appeared with this information:
System.Data.ConstraintException: Column 'ServerId, JobId, Id' is constrained to be unique.  Value 'e8f2a66f-1927-418c-96ea-72632a9f71be, b2b067c2-104e-42a5-a433-3191787014a5, 6f6358d3-b0a9-4fb7-a3a9-12f06a868242' is already present.
   at System.Data.UniqueConstraint.CheckConstraint(DataRow row, DataRowAction action)
   at System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent)
   at System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Int32 position, Boolean fireEvent, Exception& deferredException)
   at System.Data.DataTable.InsertRow(DataRow row, Int32 proposedID, Int32 pos, Boolean fireEvent)
   at System.Data.DataRowCollection.Add(DataRow row)
   at frmMain2.xZwbYcl0xo(Server& , JobClass , TaskClass )

The newly-created Job has a Task that's been giving me permissions-related problems. (I've posted a different topic about that.)

I was able to get the Client working again from backed-up settings.
The information in the client about versions since v5.1.2 don't say anything about fixing database-related bugs such as this.

Is that bug fixed in a newer version?
Sponsor
Forum information
Support
2009-06-24T00:53:09Z
We have got another report about this but not able to reproduce this ourselves. Were you cloning a Task or Job?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Wealthbridge
2009-06-24T01:18:51Z
Actually, I wasn't *trying* to clone anything.
While testing the job after having set it to use the basic Execute task to run the script, the Client wasnn't showing how the Job test was running and the actions I expected the script to cause weren't happening.

After closing the Edit Job form while the test was still running, I tried refreshing the status to no avail with F5, and then tried refreshing the status by collapsing and re-expanding the Job info, and then finally by disconnecting and re-connecting the client.
It was upon re-connecting that the first Unhandled Exception appeared.

(Why didn't I think to include this detail in my original post? I dunno; I know better than that.)
Support
2009-06-24T09:16:35Z
OK, that brings us closer.

1. Did you click on Test before or after the Job had been created and saved?
2. Can you reproduce this on a new Job?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
ErikC
2009-06-24T10:20:11Z
Wealthbridge/Support, Please change the title to the right version of Visualcron.

Regards
Erik
Uses Visualcron since 2006.
Wealthbridge
2009-06-24T18:43:56Z
Support wrote:

OK, that brings us closer.

1. Did you click on Test before or after the Job had been created and saved?
2. Can you reproduce this on a new Job?


1. I clicked Test Job after changing the task from the Execute Script to the basic Execute.
One other note: while the Test was running I closed the Edit Job form by clicking the [X].
2. We're running multiple important jobs throughout the day. Will those other jobs be affected if I am able to reproduce this problem?

Erik wrote:

Wealthbridge/Support, Please change the title to the right version of Visualcron.


I left out the client version from the topic subject because the "New version available!" information doesn't doesn't say that this problem was addressed in updates since v5.1.2.

BTW- we do have an activation code for 5.1.2. I just couldn't get to it while the Unhanded Exception errors were happening, and I don't want to post it in this thread.
Support
2009-06-24T22:09:56Z
2. Other Jobs settings will not be affected. But you will run into the same problem if you can reproduce it (and you have to restart the services)

I am not understanding the problem with the activation - please contact Sales for all activation/license issues.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Wealthbridge
2009-06-24T22:25:35Z
Support wrote:

2. Other Jobs settings will not be affected. But you will run into the same problem if you can reproduce it (and you have to restart the services)

I am not understanding the problem with the activation - please contact Sales for all activation/license issues.


Yeah- the settings won't be lost; my question was if the *running* of the other jobs would be affected if the database problem were to be replicated.

We haven't had a problem with activation; my co-worker hadn't yet had the chance to copy the Activation Code anywhere. Before we had restored the settings from the backup, the Client crashed because of the Unhandled Exception errors so we couldn't get the Activation Code from it.
We don't know if job-running would be affected by the cause of the Unhandled Exception, and I needed to get support help coming asap so I started this topic because this support forum doesn't require an activation code.
Support
2009-06-24T22:30:43Z
It affects running Jobs if you need to restart the Service (while it is being down).

We would appreciate if you could test this while we will try to reproduce it here as well.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Support
2009-06-24T23:02:30Z
We managed to reproduce this. We will fix this for next version. Thank you for your report.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Wealthbridge
2009-06-24T23:07:26Z
Hurra! (Well, kind of.)
What do I need to avoid doing so that I don't accidentally cause this problem again?
Support
2009-06-25T01:09:56Z
Currently, while a Test Job is running, it is causing new clients problems to Connect. To avoid this you should not currently test Job from Job editor but by running it normally (right click on Job).
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Wealthbridge
2009-06-25T01:26:13Z
Support
2009-06-25T18:16:05Z
Please install version 5.1.9. It has a fix for this issue.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top