IoT & Connectivity

Hi , When creating DataTable with service dynamically,  I sometimes get the error "[1,018] Data store unknown error: [Error occurred while accessing the model provider." .    var params = {name: dataTableName,description: "",thingTemplateName: "DataTable",};Resources["EntityServices"].CreateThing(params);Things[dataTableName].SetDataShape({ name: shapeName });//Things[dataTableName].SetProjectName({ projectName: "ABCD" });Things[dataTableName].EnableThing();Things[dataTableName].RestartThing();Things[dataTableName].SetPersistenceProvider({name: persistentProvider});Resources["EntityServices"].AddShapeToThing({name: dataTableName /* THINGNAME */,thingShapeName: "LockableThing" /* THINGSHAPENAME */});Things[dataTableName].EnableThing();Things[dataTableName].RestartThing();   And, if error occurs, I have the following exception handling to rollback:    var params = {name: dataTableName /* THINGNAME */};try{Resources["EntityServices"].DeleteThing(params);logg

Hi all,  I am trying to display data using an XY chart from an infotable on Thingworx. I am aware that I can just use the existing XY chart widget in Thingworx but it does not meet the requirements which I need for a task. Therefore, I have decided to use d3.js to fulfill my requirements. The image shown below is what I have coded using d3.js and imported to Thingworx. However, the data values are hard-coded and that is not what I want. I want the values of XAxis and ASensor to be displayed on my XY chart but I am unable to do so despite binding the infotable with my data. I have attached the relevant files for reference. Any help will be greatly appreciated!

Hi, We are using Creo Product Insight for ThingWorx extension on top of the ThingWorx Analytics extension. How can we create our own dashboards, mashups for showing data using the already existing services of ThingWorx Analytics and Creo Product Insight for ThingWorx extension. Can anyone please share the documents for the same with examples, so that I can go through it. Best regards, Aditya

Hi all,   I am using the server free 30 days to test. I was able to connect my ThingWorx Foundation with my PLC through of ThingWorx Industrial Connectivity.   Now I would like to communicate my local database with thingworx foundation.   Does someone has any guide that can help me with this?   Regards, Leonardo

Hello,   I'm trying to fill out the status page of the configuration section for an asset. For the fields that have to do with time, it seems to want tags with boolean outputs, but the tags I have access to are outputting numerical values. Is there a way to say "if tag is increasing, value = true; if tag is static, value = false"? This list of avaliable operators seems a bit limited, but I'm hoping there is something I'm overlooking.    Thanks

Hello, i already have problems looking for services like getapplicationkey for connecting with vuforia and getlicense to get and update the license 

Hi everybody!   We have the following setup: - running Thingworx Instance with MS SQL DB at Version 8.4 - running Influx DB at Version 1.7.8 -> listening on http with port 8086 - Both running on the same machine e.g. hostname: mythingworx.local - Influx added as successfully as Persistance Provider in Thingworx -> everything fine   What we want: - Secure connection between Thingworx and InfluxDB with HTTPS   Problem: - InfluxDB runs fine on HTTPS at Port 8086 - We have corporate generated SSL certifcates  - We can execute Queries via HTTPS with postman - We changed the url to Influx in Thingworx to https - but: Thingworx only says: unable to update persistance provider  - Thingworx is no longer able to connect to InfluxDB   Logoutput in Application Log: [message: Import Failed: Unable to update PersistenceProvider: Unable to connect to the PersistenceProvider: InfluxDB] Unable to process import: Unable to update PersistenceProvider: Unable to connect

Hi,   I am unable to download any extension from PTC Marketplace. It is giving the following error :  "Product is temporarily unavailable. Please try again after 30 minutes or contact support at http://www.ptc.com/marketplace/contact so we can get this resolved."   Please let me know whether it is a license issue or generic issue of the PTC Marketplace?

Hi, How to reset to original size of the grid columns after increasing or decreasing the width of the grid in runtime by adjusting their columns? In runtime, After adjusting the width of the grid it doesn't go back to initial width even after reloading the whole page. How can I resolve this?    Thanks in advance, Shalini V.

Hello,   we want to store some data for long term where the dataset maybe become huge and has frequent updates. The community recommends not to use DataTables for this usecase. So I installed the Relational Database Extension and was quickly able to establish the connection and create the required tables. But now I run in some trouble as the datatable has a lot of columns and we transport the data in infotables around, I would like these infotables or JSONS as Parameters for the SQL-Query/Command. How can I access these kind of parameters?   This example fails with an exception: Unable to Invoke Service TestInsert_2 on SQL.ProductionTimeSegment : Execute Update failed: com.microsoft.sqlserver.jdbc.SQLServerException: Unclosed quotation mark after the character string '[JSON.Value]);'.   Additional Question: How can I handle secure dynamic SQL, e.g. create an Table machting a given DataShape?

Hello, I created custom service to fetch InfoTable data through Rest API and tried converting the output of the INFOTABLE using INFOTABLE.toJSON() function and set the output parameter accordingly but while I am trying to access it using rest API I am not getting the output in the JSON format. var params = { maxItems: undefined /* NUMBER */, onlyUnacknowledged: undefined /* BOOLEAN */, onlyAcknowledged: undefined /* BOOLEAN */ }; // result: INFOTABLE dataShape: "AlertSummary" var data = me.GetAlertSummary(params); var params = { table: data /* INFOTABLE */ }; // result: JSON var result = Resources["InfoTableFunctions"].ToJSON(params);

I have installed thingworx foundation downloadable trial version one machine and thingworx industrial connectivity on another machine.   I am following below guide while establishing connection between thingworx foundation and thingworx industrial connectivity https://developer.thingworx.com/en/resources/guides/thingworx-industrial-connectivity-guide   This guide assumes that you are utilizing the hosted Foundation server in combination with the downloadable Industrial Connectivity. It also mention that some instruction requires modification in case of "downloadable Foundation trial". In my case the above mentioned guide does not work. I am not sure what are the steps which required modification in case of hosted foundation server. Please let me know if any one had tried the same for hosted Foundation server. I am also attaching the connection settings for thingworx industrial connectivity and error I am getting while establishing connection between foundation and industrial

We have two OPC UA Clients (PC) and want to communicate between them using KepServerEx. There i no PLC involved!!!   Is this possible? if it is, which driver should I use?   The clients are Pi System and a customer specific program.

Is it possible to connect a Thingworx agent( made by the c sdk) to send messages to Azure IoT hub. If we have to connect Thingworx agent based devices with Azure then how it should be done ?

This post is a couple of years old, and is now locked.  Does anyone know if there has been update on the aability to use OKTA with PTC ThingWorx in the interim?

Hi, We are using Creo Product Insight for ThingWorx extension on top of the ThingWorx Analytics extension. How can I configure predictive analytics and also use it. Also, Can anyone please share the documents for the same with examples, so that I can go through it. Best regards, Aditya

Hi,   I have failed to import a database Thing, that is exported from a DEV system, into a QA system. That was failed because of password fields in the XML exported file. What is the best way to migrate changes in a database Thing from a system to another system? Both systems are running the same version 7.4.19-b262   Any suggestion would be greatly appreciated!   My Bests, Hung Tran

Hello everybody,   I am using a Thing with MSSqlServer template to connect the system to a SQL database. The goal is to log PLC tag (binded to a Remote Thing) values, and store each under its relative database column.   I am using a simple SQL command to write these values into the database:     Spoiler (Highlight to read) INSERT INTO *TableName* (Column1,Column2, ..., Column15) VALUES ([[input1]],[[input2]], ..., [[input15]]) INSERT INTO *TableName* (Column1,Column2, ..., Column15) VALUES ([[input1]],[[input2]], ..., [[input15]])   Together with another service linking each input parameter to my remote thing properties: Spoiler (Highlight to read) var params= { input1: prop1, input2: prop2, ... input15: prop15 }; SQLcommand(params); var params= { input1: prop1, input2: prop2, ... input15: prop15 }; SQLcommand(params);   With this, I am able to ALMOST get what I want. In fact, when looking at what I am actually logging in the SQL database, it look

Hi   I Could not able to download SSH File Transfer Protocol (SFTP)  extension from PTC Market Place, Please send me extension file  if anybody already have that file. 

Anomaly Detection (also known as Outlier Detection) is a set of techniques that identify unusual occurrences in data. The premise is that such occurrences may be early indicators of future negative events (e.g. failure of assets or production lines).  Data Science algorithms for Anomaly Detection include both Supervised and Unsupervised methods. In Unsupervised Anomaly Detection, the algorithms make the assumption that most of the data points are "normal" (e.g. normal operation of the asset) and are looking for data points that are most dissimilar to the remainder of the dataset. Supervised Anomaly Detection requires a labeled set of Anomalies, in which case predictive algorithms can be applied directly on this data.   Thingworx employs a number of algorithms in support of Anomaly Detection: Simple threshold alerts. These are easy to setup on Thing properties but require a domain expert to provide such thresholds. Then, the alert will automatically fire when the value of the

I have two issues when I tried to develop the UI for the exercise in the workbook . When adding entities through the data source pane 1) In the Select Entity field Serviceable TS is not available/displayed 2) From the GetPropertyValues service when  Returned Data is expanded OverallStatus property is not displayed kindly guide me Anitha

Hi all,   I would like know if there is some way to create search fields through of date, hour...   For example: I have a bar chart and I wanna show the data between 09/08/2019 and 09/15/2019.   If there is, does someone know some guide that it can help me?   Regards, Leonardo 

Hey Guys I was struggling for a very long time to use a custom font in Thingworx that will be used by all the widgets, texts and labels and have finally gotten it right, and thought I would share.   The first step would be to add your custom fonts to a repository in on the thingworx server. 1. Add a fileupload widget to a mashup. 2. Set the RepositoryName property to SystemRepository 3. Set the Path property to /Fonts/ 4. Now run the Mashup and choose your font file on your computer and click the "Upload" button to save the file in the repository. (I have done it with both ttf and woff files" 5. In thingworx composer, select the mashup or master mashup of your project. Navigate to the "Custom CSS" tab. 6. In the CSS, paste the following CSS and click save        @font-face {font-family: THENAMEOFYOURFONT;src: url(/Thingworx/FileRepositories/SystemRepository/Fonts/THEFONTFILE.ttf) format('truetype');} *{font-family: 'THENAMEOFYOURFONT', sans-serif; font-size:18p

May I know how to put value which is from aggregate function in data table services, and what is the output?   

Hi,   The system complaints that "This entity does not support property permissions"   Exception: Wrapped java.lang.Exception: This entity does not support property permissions Cause: This entity does not support property permissions   Here under is a code to simulate the case     var EntityServices = Resources['EntityServices'] var newTemplateName = 'TestThingTemplate' if (ThingTemplates[newTemplateName]) EntityServices.DeleteThingTemplate({ name: newTemplateName }) EntityServices.CreateThingTemplate({name: newTemplateName, thingTemplateName: 'RemoteThing' }) ThingTemplates[newTemplateName].AddRunTimePermission({ principalType : "Group", principal : "Users", allow : true, type : "PropertyRead", resource : "*" })     My Bests, Hung Tran