IoT & Connectivity

I’m working on predictive maintenance of combustion engines, for this I have 2 years of sensor data of one engine, with close to ten reported failures during that time window.Failures are of different kinds, say:type 1: 3 failurestype 2: 2 failure2type 3: 1 failure...type n: 1 failureSo far I have these ideas:1) Use a classification model to predict probability of failure within a time window.Problem: Very few data points to model, with less than 10 occurrences of the same failure I don’t see feasible to overcome the risk of overfit or obtain any reliable metric, even using over-sampling2) Principal Component analysis: I have found some white papers where PCA is used as a clustering technique to identify anomalies which may include failures as well. What I like of this approach is that will not require to have labeled data, on the other hand it seems to rely heavily on industry expertise to define categories within the groups of data. Another drawback of this approach is that thingworx

Hi Team,   Suppose I have a grid widget with live data populating on it with some service.   What I want if any new row gets added to above data then my grid data gets refreshed immediately (i.e. the service populating data gets called on addition of any new row event) without using auto-refresh. Also don't want to reload the entire page.   Please provide some logic so that this functionality can be achieved.   Thanks in advance.

https://community.ptc.com/t5/ThingWorx-Developers/how-do-I-search-specific-entity-in-grid-Advanced/td-p/687561   Read above post and implemented the same.Need to implement search feature only for 3 columns out of 10 columns of my grid.But search is working for all the columns.Please help me!

We have TLSv1.1 and TLSv1.2 enabled on server. So can we disable TLSv1.0 on server? will it has any impact

Hi  I am looking to display only x-axis values with status as below..can i get which widget we use?   Thanks

Hi, How to reset ThingWorx 9.0 drop down in button click.

Hello,   I am using Azure IoT Hub connector 3.0.1 and Thingworx version version is 8.5.1. I have been observing messages are missing into Azure IoT Hub connector. I am receiving 20 messages from device to Azure IoT Hub Portal in every minute but all messages are not received into Thingworx Azure IoT Hub, 9 or 10 messages are receiving into Thingworx IoT Hub. In cxserver log file, sequence number was captured but there is no data. Refer the below logs. Logs are captured from cxserver log file. "sequence=1370211,sequence=1370212,sequence=1370213,sequence=1370214"---> No data for these sequence number. .............................................................................................. 021-02-15T03:10:09.553 [[encoder-dev-xxx|$Default|AzureIot-dXXXXXXXXXXXXXXXXXXXXXXXXXX]-1-7] DEBUG c.t.p.azure.iot.EventProcessor - Partition events; partitionId=02021-02-15T03:10:09.553 [[encoder-dev-xxx|$Default|AzureIot-dXXXXXXXXXXXXXXXXXXXXXXXXXX]-1-7] DEBUG c.t.p.azure.iot.EventProces

I am using the Thingworx 9.1 version but while working on TWX 9.1 it will stop after sometimes automatically and when I restart the tomcat service the service will not stop. If I restart the system then it will automatically up the tomcat server and thingworx will start for some time. It is continuously showing loading and loading but it will not open any entity in thingworx. I have put this topic on the community but no reply yet.Can you please suggest any way how to overcome those problems?

Hi  can we display bar values on each bar in Bar chart/Label  chart . should be responsive. please see below snap.  

Hi, I followed this post on ThingWorx Developer Portal to learn TWx and managed to import the template the post provides. But TWx gives this error: Import Failed: Invalid Data Table Configuration in [MerchantDatabase] : DataShape [ MerchantDataShape ] was not found.   I then dived into the template file to take a look at it. The configuration of DataShape [MerchantDataShape] is actually there, not know why this error happens.    How to solve this problem? Thanks.

Hi,   Can we setup building Docker images in Windows OS? is provided scripts work in Windows?   In document mentioned, Building Docker images is supported only for Linux operating systems.   Thanks&Regards, Latha

  At first glance I see than a classification models and maybe anomaly detection can be used for predictive maintenance, are there another approach within the platform that can be used for this purpose?   In case more information is required , I have created this other post with more details about the problem in particular: https://community.ptc.com/t5/ThingWorx-Developers/How-to-approach-a-predictive-maintenance-problems-with-a-small/m-p/713255#M50569

Hi,  I created a CustomAuthenticator and want to catch the login request to redirect to another page.  however, I found the request /Thingworx/FormLogin won't be intercepted by matchesAuthRequest matchesAuthRequest(HttpServletRequest httpRequest) that's strange,  the other GET request , for example both of /Thingworx/Home and /Thingworx/Composer can be intercepted by this method .   Is the URL /Thingworx/FormLogin ignored by the servlet filter intently ?    Regards, Sean    

We will host a live Expert Session: "Thingworx Mashup 101 - Do's and Don'ts" on February 24th, 13h30 EST.   Please find below the description of the expert session and the registration link.   Expert Session: Thingworx Mashup 101 - Do's and Don'ts Date and Time: February 24th, 13h30 EST Duration: 1 hour Host: Aanjan Ravi - Technical Product Manager Registration Here: https://www.ptc.com/en/events/thingworx-mashup-101   Description: This session covers the most common and useful tips about how to correctly use Mashup builder, Widgets and Layouts – and what to avoid -  to create applications with good principles of UI/UX and easier to maintain.   Existing Recorded sessions can be found on support portal using the keyword ‘Expert Sessions’. You can also suggest topics for upcoming sessions using this small form.   Here are some recorded sessions that might be of your interest. You can find recordings for the full library of webinars using the keyword ‘Ex

I have created a mashup which allows you to easily use and test the Prescriptions functionality in Thingworx Analytics (TWA). This is where you choose 1 or more fields for optimization, and TWA tells you how to adjust those fields to get an optimal outcome.   The functionality is based on a public sample dataset for concrete mixtures, full details are included in the attached documentation.  

Here is a tutorial to explain the process of uploading a PMML file from an external system to Thingworx Analytics. The tutorial steps are explained in the attached PDF and all referenced files can be found in the attached ZIP.  

Hi, How does ThingWorx failover concept work? Do we require 2 thingworx for performing the failover? Are there any document available for this which can be referred?    Thanks in advance, Shalini V.

Hi , I am looking to add padding in between containers (responsive). Is it possible to maintain padding between containers? if yes how we can achieve this?   Thanks

I need to open a page with HTML code generated by a service, I can use: a standard mashup with the  Html TextArea widget inside (passing to it the html generated by a service)this works if edit mode is enabled, but if I set "read only" to hide the editing bar, the HTML is not rendered correctly (there is a basic table <table> <tr> <td>..... it just shows text, not the table grid. May be a bug) Generate the .html file on a repository, and open with browser.I didn't tested but it should work .. are there other options ?   // I have thingworx 8.5.9

Hi Everyone, I have used Thingworx 8.5 then I have shifted all my backups in thingworx 9.0 it's fine and there is no issue with any entity but now when I have shifted all the Thingworx 9.0 backups into Thingworx 9.1. It totally strange, some widgets that I have used in thingworx 9.0 mashups are gone. I have used PostgreSQL queries in Thingworx 9.0 but after shifting backups in Thingworx 9.1 it's not running I haven't modified any query after shifting as it is I have shifted. a select query is running in the database thing but not running JOINs query in the database things Spoiler (Highlight to read)SELECT workout_type_id,workout_type FROM "ref_workout_type" ;SELECT workout_type_id,workout_type FROM "ref_workout_type" ; Like above query is running but not running below types query i.e JOINs   Spoiler (Highlight to read)SELECT mem.member_id,concat(us.first_name,' ',us.Last_name) as fullname,ci.city_name,us.is_active,mem.checkboxFROM "tbl_members" AS memJOIN "tbl_users" AS

Hi All, We are trying to connect Dynamics 365 (not CRM) with flow with very little success. I can and have successfully connected to Dynamics CRM so I know that part works. After discussions with PTC we were told to use odata  to retrieve the information. I have the endpoints and I can view the entities in a browser. I know that in flow I need to setup a OData basic connector but that's where I fall short. I was pointed to  Configuring and Loading OAuths > OData Shown below. OData Perform the following steps every time you want to add an OAuth provider for your OData instance: 1. Configure OAuth on your OData instance, and as per your OAuth configuration, provide values in the OAuth configuration JSON file. The following are example values that you might provide for loading OAuths: ▪ Provide header information in the "oauth2_validate_headers" array, as shown in the sample array: {"oauth2_validate_headers": ["{\"Authorization\":\"Bearer {access_token}\"

Hi,   I am trying to call a Sql sequence in Thingworx . i wrote a sql query service in a thing and tried executing it. But it shows the following error "Execute Query failed: com.microsoft.sqlserver.jdbc.SQLServerException: NEXT VALUE FOR function cannot be used if ROWCOUNT option has been set, or the query contains TOP or OFFSET."    how to resolve this?   Thanks in Advance Sadagopan P

How to disable the Apache Tomcat version returned in HTTP headers while loading Thingworx.

Hi , I am using container and in that i added two layouts(Containers) one is responsive with fixed height and another is fully responsive contains bar chart but appearing scroll bar . how to resolve it? please see below snap for ref.. Thanks

Even Though I have 20 Entries in the Database, the Repeater and Collection widget is showing only last added Data in all the Cells as shown below: The Only Binding I have given to them is GetDataTableEntries .....!