ThingWorx

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

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. 

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      

Hi, In my production server event queue size is keep on increasing. I have extracted the stacktrace file with help of Support Tools Extension. How to analyse or find out the root cause of event queue size.   Thanks & Regards, Sathishkumar C.

Dear community,   I would like to retrieve the last x (e. g. 10) records (by id) from a DataTable. This post nearly covers my problem but Streams do not suite my data and the second solution does not work because I have an additional filter. Here is what I thought should work:   var query = { "sorts": [ { "fieldName": "MessageId", "isAscending": false } ], "filters": { "type": "EQ", "fieldName": "Direction", "value": 2 } }; var entries = Things["MESMessageLogDT"].QueryDataTableEntries({ maxItems: 10, query: query }); MESMessageLogDT is the DataTable entity and I would like to get the last 10 records matching my filter criteria (Direction = 2), this is why I cannot simply take length - x.   However, the actual result is: The first 10 records but in descending order. So apparently the sequence of data processing is filter maxitems sort while I need (and expected) filter sort maxitems   A workaround is this but the performance is poor and gets wo

Hello, I had a infotable with values separated by "," , I should split that data and insert in to a location basetype where using that location we should make a geofence on the map.   Please let me know how to split that data and insert into location base type.   find attached image for clarity.   Regards, Bhargav.

I'm querying a datatable, and passing this query (below). If I run the QueryDataTable entries with this query, it returns no results. If I just change the Station parameter to be "EQ" and just add the machine name as a string, the query works as expected (returning 40+ results).    What gives? What am I doing wrong?           var machineArray = ['my_machine_name'];   var query = {"filters": {"type": "And","filters": [{"type": "IN","fieldName": "Station","value": machineArray},{"type": "EQ","fieldName": "Program","value": Transmission},{"type": "EQ","fieldName": "Operation","value": Operation}]}};   var myQueryResults = Things["Ford.PFS.GM.Historian.Repository"].QueryDataTableEntries({maxItems: 200000 /* NUMBER */,values: undefined /* INFOTABLE */,query: query /* QUERY */,source: undefined /* STRING */,tags: undefined /* TAGS */});

Hi,   I wanted to send an email notification to users on a particular event occurrence and for that I created a Notification and then a Trigger but the problem is the trigger is not getting fired and no users are getting the email. When the same I tried to do using a Subscription then It's working but not With the Notifications and Triggers. Just check the attached images for further details.   If anyone knows about the resolution for this, please help me out.   Thank You. 

Hello Everyone,   I tried to retrieve the device id from my application.log at twxFoundationH2Trial-8.3.2\tomcat\apache-tomcat-8.5.23\ThingworxStorage\logs on my machine. Howvere I can't find the device id as stated here in ThingWorx fails to start up or starts up in limited mode due to license expiration. My free 90 day trial license for ThingWorx foundation server expired on 4th July. I have followed the above tutorial to get device_id as no licenseRequestFile.txt exists on my machine.   Also I am usinh ThingWorx version 8.3.2   Kindly suggest how should I proceed.   Regards, Aarushi  

I am trying Prescriptive analytics on Thingworx with the analytics manager. The data set that i am using is a example data set with Temperature and Vibration values. I selected the values for levers and was able to generate the above prescriptive scores. However i am confused with the above results. The goal field i select was Goal and it has 3 values: good normal and bad.    1. How does the model understand the string ('good', 'normal' and 'bad')? 2. What does it mean by the value of the scores? eg what is the meaning of 0.22221755904502294? This value seems low so does it mean it is not optimized?  

Hi,   The error is 406 Not Acceptable.   2019-09-08 18:28:17.766-0500 [L: ERROR] [O: E.c.t.w.Importer] [I: ] [U: thingworxRead] [S: ] [T: http-nio-192.168.230.139-443-exec-44] [message: Import Failed: java.lang.NullPointerException] com.thingworx.contentmanagement.ImportProcessor.processImport(ImportProcessor.java:1764) ... Wrapped by: com.thingworx.common.exceptions.ModelAccessException: [2,006] Unknown error occurred. Contact the administrator if this re-occurs.   The detail error in Error log is 2019-09-08 18:28:17.766-0500 [L: ERROR] [O: E.c.t.w.Importer] [I: ] [U: thingworxRead] [S: ] [T: http-nio-192.168.230.139-443-exec-44] [message: Import Failed: java.lang.NullPointerException] java.lang.NullPointerException: null Wrapped by: java.lang.Exception: Import Failed: java.lang.NullPointerException at com.thingworx.contentmanagement.ImportProcessor.processImport(ImportProcessor.java:1764) at com.thingworx.webservices.Importer.processImport(Importer.java:342) at

We use collection widget to show menu style row in main mashup. This essentially renders n  number of icons in the footer. This main mashup also contains contained mashup in often we have to drive the contained mashup based on some action within those contained mashups. This works fine.   However, the challenge we face is for instance if a user clicks on Menu A which loads Mashup A in contained mashup and based on some action on contained mashup A user is automatically directed to Contained mashups B. Since switch between mashup wasn't the result of manual click on the icon in the footer the selection on the collection widget falls out of sync. Which would mean in above e.g. as user was navigated  programatically to Contained mashup B from Contained Mashup A, the footer with collection widget still shows icon A as selected when actually the user is viewing mashup B which corresponds to Icon B.   I hope i didn't make it too confusing 🙂   Is there anyway we