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


Guest
2013-10-17T15:51:56Z
Hi,

I have an SQL trigger on a job, and whenever I enable it Visual Cron reports an error saying "A trigger was inactivated due to an error: Object reference not set to an instance of an object"

Any suggestions? It's not a .NET based trigger so I can't work out if the error is an internal Visual Cron one or not?

Nick
Sponsor
Forum information
Support
2013-10-17T18:49:47Z
Which version are you running?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
RTHGIEBanque
2014-05-09T08:37:41Z
Hi,

Last evening, we have experimented the same issue in Production with the following message:
08/05/2014 22:03:07 Debug Saving Jobs
08/05/2014 22:03:36 Err Impersonation error: The security database on the server does not have a computer account for this workstation trust relationship.
08/05/2014 22:03:36 Err Impersonation error: The security database on the server does not have a computer account for this workstation trust relationship.
08/05/2014 22:03:36 Err A Trigger was inactivated due to an error: Object reference not set to an instance of an object. The Trigger was connected to the job: CoursHisto Fill empty Quotes (Duplicate)
08/05/2014 22:03:36 Err A Trigger was inactivated due to an error: Object reference not set to an instance of an object. The Trigger was connected to the job: DBA - DBRestore
08/05/2014 22:03:37 Err Trigger error: A Trigger was inactivated due to an error: Object reference not set to an instance of an object. The Trigger was connected to the job: CoursHisto Fill empty Quotes (Duplicate)
08/05/2014 22:03:37 Err Trigger error: A Trigger was inactivated due to an error: Object reference not set to an instance of an object. The Trigger was connected to the job: DBA - DBRestore
08/05/2014 22:03:37 Debug Trigger was expired and inactivated
08/05/2014 22:03:37 Debug Trigger was expired and inactivated
08/05/2014 22:04:08 Debug Saving Jobs

We are using VisualCron 7.0.7 and this error happens on SQL triggers only.

Many thanks,
Kind regards,
Sylvain
Support
2014-05-09T14:12:17Z
About the impersonation error the problems seems to be a AD problem after a quick search on Google.

About the inactivation error I suggest upgrading to the latest. If you still get it we will prepare a special version for you with more debugging.

Thanks
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top