IoT & Connectivity

Does the toFixed() method not work in thingworx?

How would one go about specifying a DataShape name for an Infotable property defined in the MashupGlobalPropertyBinding property of a Collection Widget? It's required to specify a DataShape name for the mashup property in order to be able to bind it to an EventsRouter widget input.        

Hi, I am unable to connect thingworx and kepware. I completed the configuration properly but it is showing following error: Connection to ThingWorx failed. | Platform = localhost:8088/Thingworx/WS, error = could not initialize a secure socket connection.   When i enabled the logging, i found below error: unable to add binding for pre-existing Gateway Thing because existing Thing Template does not derive or match [existing: PTC.Factory.KepServerThingTemplate, provided: IndustrialGateway].   Kindly resolve.

Hi All,   I have a query regarding how to add values to a scrollable panel so that every 10 seconds it should display the updated values corresponding to a label.   I will attach the screenshot for a better understanding of the query.   I want a use case where, Temp1(label) corresponds to 26 (value) After 10s, Temp2 (label) corresponds to 18 (value)  After 10s, Temp 3 (label) corresponds to 5 (value) and so on.   The panel has to be updated automatically after the specified time interval. Kindly provide a solution if the query is clear.   Thanks in Advance.   Regards, Airin

I am needing to combine two Info-tables and display certain information from those on another info-table. I keep getting the error "Error executing service GetSalesOrderPartStyleProduct. Message :: Unable to Execute Union: Field [Customer] was not found in both infotables - See Script Error Log for more details." I understand what it means but cannot figure out where I am going wrong in my code. I created my service which has an info-table output. My thought was switching "Union" to "Join" var params = { infoTableName : "InfoTable", dataShapeName : "TrainingDataShape_COB" }; // CreateInfoTableFromDataShape(infoTableName:STRING("InfoTable"), dataShapeName:STRING):INFOTABLE(TrainingDataShape_COB) var myInfoTable = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params); //// result: Two info tables given var itPartInfo = Things["Training.InfoTable.PartInfo"].GetDataTableEntries(params); var itOrderInfo = Things["Training.InfoTable.OrderInfo"].GetDataTableEntries(par

How I can retrieve and create/send data from/to Windchill (process plan, change request). I have Operator Advisor and Navigate installed in Thingworx.

Hello everyone,   I am using Value stream on ThingWorx Server and sending PUT requests (using REST API) setting the properties values and eventually visualizing the changes using mashups.   This feature works well when I change the properties value manually from the ThingWorx server, as it is mentioned in this training. However, when I send the PUT requests using Postman client or Python scripts with REST API, the properties values get updated successfully but the value changes can not be seen with the QueryPropertyHistory Service. It should be also noted that for sending the PUT request with Postman and Python scripts, I should send the request multiple times. In the first efforts I get the error message "500 Internal Server Error" before the request sent successfully getting the message "200 OK". Please refer to the attachments for python script and a screenshot from Postman client.    Just before sending this post, I used the suggested Restlet Client sending

Hi,   The migration process (7.4.0-b159 to 7.4.19-b262) locked up itself, took 11 hours, then hang up and no progress        I wonder if there is any workaround, or by pass the migration process cause I know this migration does not change the Thingworx database schema.   My Bests, Hung Tran

  We are counting down the days for you—developers, technologists, futurists—to witness the unparalleled power of PTC’s technology. Hosted by PTC, LiveWorx is the world’s leading digital transformation event to equip you with the knowledge, power and tools you need to begin or accelerate your company’s digital transformation.   I’m excited to share that I will be presenting a breakout session on June 11th, at 1:15pm EST, around a brand-new functionality we’re offering to improve your ability to manage and deploy your ThingWorx applications.   Want to learn more? Attend LiveWorx 2019 or learn about our livestream options. However you choose to attend, it’s an event that I’m pretty amped for and I can’t wait for you to be, too.   Hope to see you there—it’d be great to meet you in person!   Stay connected, Kaya  

Hi, i am trying for quite some time to get my raspberry pi connected to TW using kwyboard and mouse. i am getting this errors    [DEBUG] 2019-06-02 23:16:40,32 SDK: twTlsClient_Connect: Connecting to server[ERROR] 2019-06-02 23:16:40,43 SDK: TW_NEW_SSL_CLIENT: SSL handshake error. Error: error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown protocol.[ERROR] 2019-06-02 23:16:40,43 SDK: Error intializing SSL connection[ERROR] 2019-06-02 23:16:40,43 SDK: twWs_Connect: Error restarting socket. Error 0[DEBUG] 2019-06-02 23:16:45,44 SDK: twTlsClient_Reconnect: Re-establishing SSL context[DEBUG] 2019-06-02 23:16:45,44 SDK: twTlsClient_Connect: Connecting to server[ERROR] 2019-06-02 23:16:45,57 SDK: TW_NEW_SSL_CLIENT: SSL handshake error. Error: error:140770FC:SSL routines:SSL23_GET_SERVER_HELLO:unknown protocol.       and i am using this config.json file   {"ws_servers": [{"host": "192.168.1.206","port": 80}],"http_server": {"host": "127.0.0.1","port": 8080,

Hi Team,I have a problem with the tutorial "Operationalize an Analytics Model". I followed all the steps, but the Analysis Events or the Analysis Job does not sent the results back to the Thing "AMQS_Thing". Is there a known issue?

hi,    I wan to know, Can we use SQL server instead of Postgresql for thingworx installion?      Thanks and Regards, Sheetal Sable  

Hi ,   I'm working with collection widget, I have used a static mashup as a child mashup and in responsive mashup I have used collection widget. It was working as expected but I have bonded a different service, from that time I'm getting single cell in each row, Expected to have 2 cells in a row.   How can I configure this?  Are there any suggestions in improving this?   Thanks in advance, Bhavya 

I have got the Trial Version of Thingworx and have imported the PostgreSQLExtensionPackage from the TW-Marketplace. The database connection works, a simple service of the type "SQL-query" shows results. How can I alter this service in Java script to store the resultset of the SQL (e.g. select * from tab1) in a data table?   Thanks for your help.

Hello guys,   I've been having trouble understanding how services work and how I should program them, I understand the concept of them being the functions of the thing but when it comes to create them, I don't have enough knowledge. The problem I have now is that I have a Data Table with some locations and I want to create Geofences around each one of them. The purpose is to track a vehicle and check if he made into the next Geofence in time. I searched some documents in support but none of it was helpful, this article https://www.ptc.com/en/support/article?n=CS225480&source=snippet shows how to show a Geofence by region but my purpose is to create it for multiple points. Remember that I have the locations in a Data Table but I don't know how to create a Geofence in each one of these points relating it to the vehicle I am tracking.   I also saw a function createCircularGeoFence in service Snippets but I don't know where I would use them to create the Geofences around

In this Blog, we will share some light about Gradient boost, which is a default algorithm in our Analytics platform. We will touch on:1) The main purpose of Gradient boost and how the technique works.2) We will look at advantages and constraint.3) Last some “nice to know” tips when working with Gradient.Gradient boost is a machine learning technique which main purpose is to help weak prediction models become stronger. Gradient boost works by building one tree at a time, and correct errors made by previously tree. The theory support reweights of edges which allows badly weight edges to get reweighted. For example the misclassified gain weight and those weights which are classified correctly, lose weight. It is kind of the same strategy when dealing with stocks; you balance the investment between bonds and share. An analog could also be done to illnesses; If a doctor informs that you have a rare disease, you want to make sure to get a few more opinions from other doctors, You will evalua

Hi,   I created a new persistent provider called "PostgreSQL" , I've set it to be active and set it as default persistence provider.   I can find it in Monitoring->Subsystems->Stream Processing.      But after calling Things["xxx"].AddStreamEntry,  I didn't find the value "number of stream entries that have been queued" changed,  it seems the persistent provider doesn't take effect .  How to enable it ?    Regards, Sean

I am using Thingworx database to store one week data from manufacturing plants and use Azure Datalake to store older data. Is there a way to use Mashup to view historical data from Azure Datalake? I know I can use PowerBI to view historical data. But I want to use the same tool to see both real time and historical data. 

I have a SOAP input in postXML snippet and get output as XML. How to pass the input in XML format? Is there any usecase you share.   When I pass the input as XML I am getting error as "DOCTYPE is disallowed when the feature "http://apache.org/xml/features/disallow-doctype-decl" set to true.

Hi,    My customer has 5 factories , he has purchased one ThingWorx SCO and deployed it in factory A1.   Now the customer wants to use the ThingWorx in the other 4 factories(A2 ~ A4),  the options could be :    1.   Reuse the single ThingWorx Server  Buy more licensed users for the current ThingWorx SCO , deploy the SDK agent in the 4 factories to collect data and  all of the factories share the single ThingWorx server in factory A1.  The data of the 5 factories are visible to each other .    2.   Deploy separated ThingWorx Servers w/o Federation Buy more licensed users for the current ThingWorx SCO , deploy the SDK agent and ThingWorx server in the 4 factories as well.   The data of the 5 factories are separated .    3.   Deploy separated ThingWorx Servers with Federation Buy more licensed users for the current ThingWorx SCO , deploy the SDK agent and ThingWorx

Hi,   I have an infotable that is being passed to Service-A, that service is adding additional fields to that infotable, and returning that infotable. This infotable is being passed to the Grid-Advanced widget to populate its data.   When a row is selected from this grid, I will populate a particular column in that row with a string.   I'm not sure how to accomplish this goal. I currently have Service-A going into an event router along with the result of another service, Service-B (this service takes the infotable from Service-A and populates the value, then returns the entire infotable). Service-B is called when the SelectedRowsChanged event from Service-A is triggered. However, for some reason that event is not being triggered. Any help would be greatly appreciated!

Hello forum,   I'm trying to install Foundation and keep getting this error soon after the PTC logo appears on the screen: "There has been an error. Could not verify java, please install the required Java version." This is on windows 7, so I tried on my other machine on windows 10, with same result.   Using the latest version of Java - 1.8.0_191.   Am I meant to roll back the Java installation?

Hi all, I am facing this issue where I am not able to push more(85 to be exact) entries into a stream. I have write a service which will calculate and then push the value to stream. I run the service 85 times and feed the same to stream.to check the working/performance of the service i have fed 85 output to result. i can see 85 values in result, but when i go to the stream and check the same i see only 40-50 are present.    

Hi,  I'm using the Java SDK to send event to Thingworx platform. Checking the application log I found the error :   "Could NOT send response for request 12 on /Things/DeviceTestThing/Services/ProcessRemoteEvents/ [java.lang.Exception: No open connections were available on endpoint 11]"   How to avoid such error ?    Regards, Sean

I can't understand because this SQL query doesn't work: COUNT Department,IF(Department = 'toys', COUNT(), 0) AS numberOfToys,IF(Department = 'health', COUNT(), 0) AS numberOfHealthFROM TABLE; TABLE Department - Valuetoys - Atoys - Btoys - Chealth - Khealth - Ftoys - Gtoys - Rtoys - Wtoys - Q I'd like to count number of occurrences about both toys record and health ones into 2 columns. department numberOfToys numberOfHealth toys 7 0health 0 2 WHY ?!