IoT & Connectivity

Newb and first time poster.   I am creating a service that calls a stored procedure in SQL Server*. It uses the JDBC connector. The results I see when testing the service don't match what is returned when executed on the SQL Server. Some numbers are completely missing, presumably because of their format? If I change the query to return random integers in the Eff column, then I can get results back. It doesn't seem to matter if I bind my output to a data shape or just to text.   Thanks in advance for any tips.   * it doesn't matter if I am calling a stored proc or running the code in the service. Same result.  

 Image Source: https://www.thefire.org/resources/spotlight/     Designed a super cool mashup? Have an innovative IoT app? Are you really proud of how you solved an IoT challenge? Are you using ThingWorx for a unique use case?   If so, we want to hear from you! I’m looking for a few ThingWorx developers that are interested in sharing their work to be showcased on the Ask Kaya blog! (Don’t worry—we can hide your confidential info and only share what you allow us to.) We’d love to highlight what our developers are doing with ThingWorx out in the real world. If you’re interested, comment below or message me directly!   As always, stay connected.  

Hello everyone!   We are creating a system based on the MQTT protocol, which will be our main source of incoming data. We are planning to connect various systems and devices through it and use it in independent projects on multiple environments. (i.e. DEV/QA/PROD).   The question is if we should stay with MQTT Extension. It looks like it has no user context at all, which is forcing us to use System user everywhere, where Entities are subscribed to changing data from MQTT. It is quite painful and I see quite a lot of room for security leaks.   After some research we found PAT with already implemented MQTT channel.   Questions from my side: 1. Is MQTT channel ready for production use? 2. Is sample MQTT codec sufficient and supported? 3. What is an effort to switch from Extension to codec beside new software mantainance? 4. How it is working comparing to the Extension in terms of a lot of topics (lets say tousands)? 5. Which one is better for the real production use? &

Hi, In pie chart, I am binding single data source. Is it possible to traverse to different mashups based on selected segment of pie chart?   Thanks, Shalini V.

In the Advanced Grid or Grid configuration, you can specify the number format as "0.00". This results in 3.1415 being displayed as "3.14", but also 11 as "11.00", and 12.3 as "12.30" Is there a possible format string to remove unnecessary zero's, so 3.1415 is displayed as "3.14", but 11 is displayed as "11" and 12.3 is displayed as "12.3"?  

Developing Great IoT Solutions Brought to you once again by your EDC team, find attached here a brand-new, comprehensive overview of ThingWorx best practices! This guide was crafted by combining all available feedback, from support cases to PTC Community threads, and tapping all internal resources. Let this guide serve to bridge the knowledge gaps ThingWorx developers most commonly see.    The Developing Great IoT Solutions (DGIS) Guide is a great way to inform both business and technically minded folks about the capabilities of the ThingWorx Platform. Learn how to design good solutions from a high-level, an overview designed specifically with the business audience in mind. Or, learn how to implement good IoT designs through a series of technical examples. Start from very little knowledge of the Platform and end up understanding data structures and aggregation, how to use the collection widget, and how to build a fully functional rules engine for sending and acknowledging al

I'm having this bug in TW 8.5.0 where the reworked widgets are not always showing up. When I press 'view mashup' 10 times, I'd see the new widgets 1 time. I have set up 3 environments with TW 8.5.0, and I have had this with 2 out of 3 environments: - One in the cloud (don't know what database) - One with PostgreSQL - One with MSSQL (with no issues)    Will this issue be resolved in 8.5.1? And when will 8.5.1 be released?    Jasper

Hello Friends,   I have install ThingworxH2trial 8.4 version . I have made mashup that is taking realtime value in gauge widget  and I have used things ,MQTT extension,subscription and changevalue event . Values are stored in valuestream successfully    But suddenly,When we open thngworx ,Following error is apeared. After that when we make again new things Base thing template is listed empty though MQTT extension is listed in extensions list.   Application log [message: Entity Not Found : [Teksun_mqttThing]]   Error in writing to Data Table for Feature : twx_composer, Product: TWX_PLATFORM Error : Unable to store license usage data in data table due to error:null

I have mashups that use the advance grid extension in 8.4. I just upgrade to 8.5 and the message to replace the legacy widgets, which will soon be deprecated. How does the advance grid will be affected?   

Hi All, I am new to PTC ThingWorx and started to  learn each components. Now I want to configure Operator Advisor with Windchill MPMLink. I don't how to achieve this. Please help me.   Do I need ThingWorx platform/Composer to  configure Operator Advisor? if yes, then please share the ThingWorx platform/Composer  installation steps.   Thanks Saravanan

hi,  I have a problem and search for a solution, I created an organization and  put a user into, I need when I log in with this user, the page showed a mashup, I configured and give permission to the user from the mashup page,  my problem, when I log in using this user, the mashup shown as a white page, and it isn't shown anything,  what the problem??  

Hi, We wanted to send a text from a textbox to a service on text change event. We are providing a data input to the text box and when that data is changed in database it will change in textbox, at that time it should trigger a service. We are connecting the text changed event for this. But, the text changed event is working only if it is edited manually. We do not want to manually edit it as we are going to hide the text box.   Thanks, Shalini V.

Hi guys,   I am working with Manufacturing apps in Thingworx 8.5.  I have created a new availability KPI that I want to display on the Production KPI mashup.   I have done the following: - On all my templated I have overridden the KPInames service to include the new KPI - I updated the GetEquipmentNetworkForKPIs service with the underlying PopulateProductionKPIsTreeGrid service to include the KPI in the InfoArray on the PTC.Factory.PlantStatusUtils thing. - I also updated the PTC.Factory.PlantStatusTreeDataShape and PTC.Factory.EquipmentStatusTreeDataShape to include the new KPI.   On the advanced tree grid widget in the mashup I can see the new KPI but when I select it to include it in the grid columns it is not shown when the mashup is loaded.   Any advice on why this is happening and how to allow me to do this?

I need to set/unset datafields in a timeseries chart based on selection of a checkbox for datafield selection in a runtime mashup. ex: I have timeseries chart with temperature and humidity as datafields in timeseries. In mashup, user is provided with a checkbox for selection of temperature, humidity.Based on selection of checkbox, timeseries to show data from datafields of temperature, humidity dynamically on mashup. Does timeseries widget properties support such dynamic setting of datafield, if not I will explore other chart widgets.   Thanks..

Hello,   I want to create a service with JSON output, I want the output to always have the same structure.For example my structure is composed of 3 fields (field1, field2 and field3), sometimes one or several fields are null, but I want to see them in my output, regardless. In my code I have :   result = { field1 : "some value", field2 : null, field3 : "other value" }   but my service gives me only :  { field1 : "some value", field3 : "other value" }   How can I have field2 please ?

Hi Everyone,   We are trying to fill in a thing name in the GetDesignTimePermission result infotable using the DeriveField snippet.  var params = { type: "Thing" /* STRING */, maxItems: 1000000 /* NUMBER */ }; var result1 = Resources["EntityServices"].GetEntityList(params); var result2 = Things[result1.rows[0].name].GetDesignTimePermissions(); //This is only for a single entity for testing purposes var params = { types: "STRING" /* STRING */, t: result2 /* INFOTABLE */, columns: "EntityName" /* STRING */, expressions: "result1.rows[0].name" /* STRING */ }; var result = Resources["InfoTableFunctions"].DeriveFields(params); However we are having trouble finding a valid expression.  Error executing service GetDesignTimePermissionsforUser. Message :: Script evaluation error : ReferenceError: "result1" is not defined. (DSLCompiledExpressionProcessor#1) - See Script Error Log for more details. What would be a valid expression to add the relevant thingname in a new col

Hi all,   I have installed Thingworx Flow on a local machine, everything was successfully installed and I can access Thingworx flow from the URL. But because it is locally installed, I get the security error of the certificate not being valid, but I can pass by this. Everything seem to work but not the Authentication connectors (OAuth) (would need one for Salesforce connection).    Everywhere (in the global setting page, and in the component itself)  it comes as no results found if I want to add one.   Would this be an issue with the certificate not being trusted? I have already tried to create one as from a RootCA and then imported the RootCA as trusted but I still get the invalid in the browser.   Anybody how had the same issue, how can help on this? I there maybe a guide on installing windows locally and make it work with certificates?   Thanks.   Steven    

Hi all, I have some trouble when try to install Thingworx Flow. I have installed on my server TW 8.4.3 and I want to integrate Flow. But, when I try to do that, I always received same message and when I try to log in into Flow, I see 404 error.

Am able to access thingworx flow from the suggested URL (https://<hostname>:<Port>/Thingworx/Composer/apps/flow). But when I created a Thing in Thingworx composer and added a service by selecting "Workflow", it throws, 404 Page Not Found error in the service creation panel. I checked the status of flow with "pm2 ls" command in command prompt and all the components are "online".   Can someone please suggest a solution. Am currently using Thingworx 8.5 version.  

Hi, Just found that DeleteDataTableEntries can only delete 500 entries as most , but there is no parameter to control it.  Executing the service one more time, and it will delete the next 500 entries.  Is it a correct/designed behavior ?    Thingworx version:  8.4.4   Regards, Sean

Hello, I have a model deployed from creo to ThingWorx Analytics Manager using Creo product insight extension for ThingWorx and I am also able to send data from creo to ThingWorx and vice versa.Now my question is that how to do predictive Analytics using the data which is coming from creo to Thingworx. Also, can we use the same model which gets deployed when we publish sensor or model from creo?Thanks,

I'm using a company hosted demo server and I've created a mashup displaying data collected from a raspberry pi with a temperature and humidity sensor and GPS collector. I'm trying to use the google maps widget installed on the demo server however, it's not coming up in the widgets section. When I go in the manage section and then extensions, it is there however when I view any mashup with this widget in, I can't see it and an error comes up in the log saying 'google maps doesn't exist'. None of my other colleagues using the same server have this issue and don't know how to solve it. If anyone has any suggestions/solutions they would be much appreciated.    

When creating and using a Style Theme I have the option to select fonts on different items (Headers, Labels, Body) There are several fonts as standard, but how do I use for instance the Roboto opensource font?   In 8.3 I put the font in a repository and used CSS to specify on a top level to use this font with !important Not a good way...   Can I "install" a font and use it in Style Themes?

Events   Timers and Schedulers both come with a specific Event inherited from the Thing Template: Timer ScheduledEvent Both have a Data Shape allowing to capture the timestamp of when the Event was actually fired. Events in ThingWorx are triggered when a specific condition is met. In this context the condition is met and the Event is fired when a Timer has expired or a Scheduler's time is reached. Once an Event is triggered, Subscriptions will take care of executing custom Services to react to the Event. Subscriptions   Subscriptions listen to Events and can be used to react to certain Events with running custom Service scripts. To follow-up on Timers and Schedulers, a new Subscription must be created, listening to any related Event fired. Add a new Subscription to the Thing with       As the Subscription is usually listening to the Thing that it is configured on, the Source has to be left empty. When listening to other Entities' Subscriptions the corre

Hi, Frame Layout widget didn't work in thingworx 8.5  Anyone has similar widget recommendation or any suggestion on building overlay layouts instead of frame Layout widget?