Skip to main content
M
mberber12-Amethyst
12-Amethyst
December 3, 2020
Solved

Error Executing Event Handler on Subscription

  • December 3, 2020
  • 1 reply
  • 4709 views

Hello Everyone.

 

For a customer we recenlty migrated to TWX 8.5 to 9.0.3.  Instead upgrading system we did install from scratch to new server using TWX installer  and copy entities from  8.5.    

 

Our major problem is Subscriptions.  Almost all are remote things are bind to Kepware and getting data from various machines. After upgrading most of our Things their subcriptions imported as Disabled. We had to manually Enable most of our Subscrptions. The method we did use to create subcription is to create subscription either on the ThingTemplate or ThingShape level to which Things to inherit. 

 

After monitoring for two weeks our Application Logs are crawling with the Error = Error Executing Event Handler '<subcriptionName>' for event Type.Thing:Entity.<thingName>:Event.DataChange:Property.<propertName> which is mandatory to use this DataChange event on Things to run our logics But they are simply dont work way they should be. Services are working fine when we did test but DataChange event on Subscriptions  are unable to catch changes . Its very frustrating. Things are also getting disabled time to time. 

 

We did try to upgrade TWX 9.1 but it became worst. Almost all or SQL scripts became broken couse of longer then 2 lines of SQL Scripts are broken. So we did back to 9.0.3. 

 

Is there anyone has also encounter this problem ?

 

We need to solve this becuse is simply no make sense that the project which is working perfectly fine at 8.5  but 9.03 it that just dont. 

 

Thank you

Murat.

 

Best answer by PaiChung

If 9.1 fixes the subscription issue, then you can fix the sql by forcing spaces everywhere you use <cr>.

I.E.

select * from table tablename

where this = that

make it

select * from table tablename

   where this = that

 

Not sure how much SQL you have in use.

1 reply

P
PaiChung22-Sapphire IAnswer
22-Sapphire I
December 3, 2020

If 9.1 fixes the subscription issue, then you can fix the sql by forcing spaces everywhere you use <cr>.

I.E.

select * from table tablename

where this = that

make it

select * from table tablename

   where this = that

 

Not sure how much SQL you have in use.

A
anarwal5-Regular Member
5-Regular Member
December 7, 2020

Hi @mberber ,If @PaiChung  response has answered your question, please mark as Accepted Solution, for the benefit of others who may have the same question.

Terms & ConditionsCookie settingsAccessibility statement