Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X
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.
Solved! Go to Solution.
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.
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.
Hello Pai;
Your solution works, but we have to manually edit all SQL Commands, which is a lot. So this is not very efficient. What is the cause of this problem? Is there any other way to write this without caring <cr> or whitespace when writing SQL queries?
Downgrading to version 9.0.3 seems to be the solution to this problem.
Wondering, does PTC know that this problem is in TWX 9.1?
Thank you
The issue is a known problem that the platform team is fixing, I do not know when the fix will be released though.
Hi @mberber.
If you feel your question has been answered, please mark the appropriate response as the Accepted Solution for the benefit of others with the same question.
Regards.
--Sharon