Error: ForeignKeyConstraint - VisualCron

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

Welcome Guest! To enable all features please Login or Register.

mmisko
No customer Topic Starter

2012-09-28T20:36:13Z

Hello,
We're having the same problem as listed in post http://www.visualcron.co....aspx?g=posts&t=1595 . How can we fix this? I'm pretty sure it was created by a cloned/copied task. However, I'm unsure what task/job. We did try restarting the service.

Quote:

Could not add Task: ProcessFile, error: ForeignKeyConstraint Constraint1 requires the child key values (05648b9a-3715-4222-8b97-f320830a5e09, 9676c242-65db-4ea6-9bae-d3940100b657) to exist in the parent table.

Thanks

Edited by user 2012-09-28T20:36:44Z | Reason: Not specified

Sponsor

Forum information

Wanna join the discussion?! Login to your Forum forum account or Register a new forum account

Support
Official support

2012-10-01T13:44:38Z

Do you sometimes click on "Test Job" while having the Job opened?

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

mmisko
No customer Topic Starter

2012-10-04T13:14:46Z

Nope. The application is used by several others. None of them remember doing so either.

Support
Official support

2012-10-04T13:16:24Z

Just to confirm first - restarting the service restores state?

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

mmisko
No customer Topic Starter

2012-10-04T18:07:49Z

Yep, sure did. Was the first thing we tried.

Thanks!

Support
Official support

2012-10-05T06:30:56Z

Ok, so, we need your help to find out why. We could not reproduce this right away. One guess it that it has to do with Clone/Copy but the question is how to reproduce this. Is it clone or copy and is it clone copy of a Task or Job and what happens after that? Any information would we great.

We will try to add some debugging at server level as well for next version.

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

mmisko
No customer Topic Starter

2012-10-05T12:45:03Z

I THINK it might have been a clone on the job level. However honestly it is hard of us to recall the exact actions. Would sending you my settings file help?

mmisko
No customer Topic Starter

2012-10-08T16:04:49Z

I was also unable to duplicate the error. I did notice I don't receive an error if I export the settings and import them in on a test server. I'm a bit nervous to try this on production though.

Edited by user 2012-10-08T16:15:23Z | Reason: additional detail

Support
Official support

2012-10-08T17:19:49Z

Hi mmisko,

as we cannot reproduce this we will do some changes for next release:

1. log when this happens
2. correct error when Job is added (at server level)

(Still, we need to fix the initial problem at Client level - but doing that requires access of logs).

Our plan is to do this release in some days.

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

mmisko
No customer Topic Starter

2012-10-09T12:55:37Z

#10

Thanks for the update and clarification

Support
Official support

2012-10-10T12:52:30Z

#11

Please update to the latest version now.

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

mmisko
No customer Topic Starter

2012-10-10T19:55:36Z

#12

Great, thanks for your fast work!

We're working on updating the servers. First we'll have to do some testing in DEV. However, I upgraded my client and now I no longer receive an error message.

Users browsing this topic

Guest