x Want to participate? Join the group to interact
  • State Not Answered
  • Replies 2 replies
  • Subscribers 74 subscribers
  • Views 514 views
  • Users 0 members are here
Browse Forums
Announcements
105
topics
32
replies
General Discussion
6k
topics
18k
replies
Knowler

Unexpected Event when running new escalation rule

Posted By

Hello, have created a new escalation rule to update a field when a communication record gets within 30 minutes of it's scheduled date/time. But it's not updating the field, and checking the system log I found the following:-

"Apr 25 2013 17:04:51.996 1052 5592 1 Unexpected event running Escalation Rule (Set Comms to Amber) : 10236<BR>WkRl_WhereClause: comm_status = 'Pending' and DATEDIFF(MINUTE,GetDate(),Comm_DateTime) 0<BR>Access violation at address 1A52B8AE in module 'eware.dll'. Read of address 0000001E"

I've tested the SQL Where clause in SQL Management Studio and it seems to work fine there, could it be something else causing the Unexpected event?
This is in CRM 7.1g
Thanks for any advice

  • 0

    Hi,

    This works for me on v7.1h. Are you using the Set Column Value action? I don't think that it's likely to be the SQL clause as such - have you tried refreshing your metadata to make sure that the metadata exists for the column you're changing?

    Thanks

    Rob

  • 0

    Thanks for your reply Rob, I think it's probably a bug in 7.1g. I also managed to get it to work in 7.1h, and then upon looking at the release notes and finding an old post on these forums about escalation rules not executing if there were no notification actions, I tried adding a 'Show Message on Screen' action to my rule. And then it works! So I suspect it's okay in 7.1h onwards, as they did something with the escalation engine in that patch - sadly the customer is stuck on 7.1g for the time being as they are using Sage200 CRM and that's the latest patch supported. But it all actually works if I include Show Message on Screen actions (and they don't actually seem to show anywhere anyway as it's not a user action that triggers this rule).

    Thanks for posting.

*Community Hub is the new name for Sage City