ThingWorx

Hi, I have an extension which contain one service where data from csv file is loaded into an infotable and service return type is infotable. Service throws custom exception if anything fails or data is not valid in csv.  In thingworx, I am calling the extension service using a snippet service, now I need to validate the service response whether the response contains an infotable or is an error message returned from the service. Incase of error, I need to show it on mashup to end user. The issue is how to validate the response  whether its an infotable or an error message. Appreciate help in advance. 

Hello Developers, I m trying to install Thingworx analytics server  -9.6.1 on my windows .but getting error below like:-I installed java jdk 11.0.12 and also configured successfully. before installation of the thingworx analytics server I used  ThingWorxFoundationMSSQL-9.3.9-x64 in my system and it works very well, however after the uninstallation of  ThingWorxFoundationMSSQL-9.3.9-x64  and trying to install Thingworx Analytics server --getting above error. please provide a solution on this. Thanks

 I downloded the last version of Java sdk thingworx (7.0.2) and I am trying to build the Android-Steamsensor sample. I am following this tutorial (3 steps):https://support.ptc.com/help/thingworx/edge_sdk_java/en/index.html#page/java_sdk/c_android_sdk_samples_build_cmd_line.html#wwID0EOLIO I run gradle.bat assemble => Output: Deprecated Gradle features were used in this build, making it incompatible with Gradle 7.0.Use '--warning-mode all' to show the individual deprecation warnings.See https://docs.gradle.org/6.3/userguide/command_line_interface.html#sec:command_line_warningsBUILD SUCCESSFUL in 740ms According to the tutorial, this command produces your ready-to-deploy apk files in the subdirectory, build/outputs/apk.  However there nothing ! Any idea ? Thank you for your help         

I provided text field widget with Mask Number. This field is displaying '-' symbol as default. Whenever I typed first digit the symbol '-' replaced with digit. But if the digit value passing from binding, then this widget is displaying '-9' Even though if the passed value is positive it is showing the digit after the symbol -. As i dont have option to use disable property in numeric entry widget, i have to go ahead with textfield with mask.  Kindly tell me how to overcome this symbol - when numeric value is passed from parameters.  

Hello, For best practice reason, I am trying to install a second thingworx database for my project.I will have a first database dedicated to my thingworx instance.All data (stream, value stream , datatable..) will be installed in separated database : 'project_db'So the idea is to use thingworx script to install the second database, i am using this article as a starting point :https://www.ptc.com/en/support/article/CS262935 the scripts are:thingworx-model-schema.sqlthingworx-property-schema.sqlthingworx-data-schema.sqlthingworx-grants-schema.sql My questions are : Do I need to install all thingwrox db scripts to install the second database, or I just need to install only thingworx-data-schema.sql script since we only need to store data ?If I have to install only thingworx-data-schema.sql, I notice a lot of table created ? Do I need them all or just a few tables? Can I clean the database and keep only needed tables, if yes witch tables should I keep ?The art

Hello,I have two thingworx (9.3.4) running on 2 differents containers.1- Container 1 is configured on port 80:8080 (NO_TLS = TRUE)2- Container 2 is configured on port 8081:8080  (NO_TLS = TRUE)From my host machine, i run an edge csdkit works perfectly with the first container (port 80) [See log OK]With the second container, i have an error  TW_NEW_SSL_CLIENT: SSL handshake error. Consider verifying you have compatible SSL ciphers, Error was: error:0A00010B:SSL routines::wrong version number. [See log KO]I tried to update the configuration of tomcat but it didn't work Do you have any idea how to use any port except 80 to run the edge Thank you for your help. 

Hi,   I have installed the Thingworx on 8080, but I want to run it on 443, 8080 (HTTP) and 51366(HTTP).   I have changed in the server.xml, but it fails when I add two more connectors: Output of Catalina.out 13:24:47,593 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback-test.xml] 13:24:47,594 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback.groovy] 13:24:47,594 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found resource [logback.xml] at [jar:file:/opt/ThingWorxFoundation/tomcat/apache-tomcat-9.0.52/webapps/Thingworx/WEB-INF/lib/thingworx-platform-common-9.3.0-b20.jar!/logback.xml] 13:24:47,616 |-INFO in ch.qos.logback.core.joran.spi.ConfigurationWatchList@5734eaa7 - URL [jar:file:/opt/ThingWorxFoundation/tomcat/apache-tomcat-9.0.52/webapps/Thingworx/WEB-INF/lib/thingworx-platform-common-9.3.0-b20.jar!/logback.xml] is not of type file 13:24:47,659 |-INFO in ch.qos.logback.classic.j

I am using ThingWorx Platform Release 9.3 and DatecodeSP5We are getting authentication errors intermittently on Edge and Chrome browsers with SAML. This happened over the weekend after a year or more of successful SAML authentication in those browsers. We resolved the issue by increasing the value for "samlAssertionMaxAuthenticationAge" in the sso-settings.json file but still don't understand why the issue started. Can you provide help with understanding what caused this issue to help prevent it in the future?Here are the errors that I faced[ Error validating SAML message ][ Response doesn't have any valid assertion which would pass subject validation ][ Authentication statement is too old to be used with value

Hi, I have a datatable and one of the field is of type PASSWORD , now i edit the field and choose string for it and i can see encrypt value of this field ...and i am saving the value in datatable using  Resources["EncryptionServices"].EncryptPropertyValue(params) and now i want to see the original values of these fields. Is there any way that i can see the original values? I have written a service to get the entries as a REST API and then iterate each entry and get the field password as one long string and using ACCEPT / also but for me its still coming the same encrypted values what it shows in datatable.    my code to add password result.AddRow({loginName: loginName.toUpperCase(),firstName: firstName,lastName: lastName,language: language,emailAddress: emailAddress.toLowerCase(),hashedLoginName: me.SHA256({toHash: loginName.toUpperCase()}),groups: groups,loginPassword: Resources["EncryptionServices"].EncryptPropertyValue({data: me.SHA256({toHash: loginPas

my thingworx analytics tab can't load dataset 

I have a use-case where in users want an option to change languages at runtime but not using the Runtime overview OOTB option of ThingWorx. Has anyone implemented or worked on similar use-cases.

In Thingworx 9.6 Collection widget, what is the class for selected cell ? 

  In TWX 9.5, the x-axis is not displaying all values.  It seems to be skipping every other value.  I'd like for it to display all values.  I did not see a setting for this in the bar chart configuration.  Is there a way to display all values?

Hello All,Can we use AMU without Kepware?Customer does not want to invest in Kepware, so can we have any work around with MQTT or OPC-UA, etc. Use Case: Data will be fetched from a SCADA system and different Dashboard will be developed in Thingworx along with AMU (Asset Monitoring and Utilization).Regards,Javed Akhtar 

Hi, wondering if there is a way to pass a button click in a collection widget cell mashup to the collection widget refresh.   I have a list of items displayed in a collection widget. There is a 'delete item' button in each item's cell mashup. I'm looking for a way to pass the click event on the button back to the collection widget itself so that it can redraw itself with the new list (minus the deleted item).   Currently I manage this by having the delete button set a boolean session parameter to true. In the main mashup I have a timer running (every second) which checks the state of the boolean & if true redraws the collection widget (list). It works, but seems clunky, so would prefer a way to pass the button click in the cell back to the collection widget without having to use a timer. I did try tying a validator to the session parameter, but it didn't appear to trigger when the session boolean changed.   TIA K

Hello, I am trying to check the network connection with another server from thingworx , but when i try to run the telnet from command prompt it gives me following error. 'telnet' is not recognized as an internal or external command, operable program or batch file Thanks

In TWX 9.6 , While trying to pass value from collection to cell mashup using MashupGlobalPropertyBinding , observed in cell mashup i am not getting the value , What should I try ?

Hello Community,     I  have datatable with usercredentials stored in it and one of the field is of password type which i do hash also before saving it. Now the issue is when i import this datatable from thingworx 9.1 to 9.3 and in my code below:= i am unable to get the value from datatable it just does not appear EntryExists.row[0].loginPassword is undefined even though on old thingworx version everything is working fine.   let EntryExists = Things[userDataTable].GetDataTableEntryByKey({ key: hashedLoginName }); if(EntryExists && EntryExists.rows[0].hashedLoginName == hashedLoginName && EntryExists.rows[0].loginPassword == hashedLoginPassword){  I have changed nothing but still it just does not work because its not getting it from datatable but on other hand all the fields are showing values. Why its like that    My assumption: I think its not possible to import the userpassword which are hashed into another

I am looking for guidance on managing code for custom Thingworx mashups. Is it possible to manage these in code versioning tools such as Github?What are some guidelines on managing changes to configuration of thingworx environments?

Error:  Unable to process purgeBetweenNow Request for Test_CM_ValueStream : Another request for this thing is active

Hi! i have read alot of documentation but cant find how to do this in TW9.5 i get succes on everything but it just adds empty lines in my infotable. i have added the json and service below{"station":"station_3","Artikelnr":2053,"antal":46,"vo":767,"Embalage":"Packaging_3","operator":"Operator_4","Antalskort":3} var dataTableName = "Proddata"; var dataShapeName = ".datashape.lucas"; var result = "Success"; try { var dataToAdd = dataToAdd; var jsonData = JSON.parse(dataToAdd); logger.debug("Incoming JSON data: " + jsonData); // Directly access the InfoTable property on the Thing var infoTable = me[dataTableName]; // Directly create a ValueCollection from the JSON data var rowValues = new Object(); rowValues.station = jsonData.station; rowValues.Artikelnr = jsonData.Artikelnr; rowValues.antal = jsonData.antal; rowValues.vo = jsonData.vo; rowValues.Embalage = jsonData.Embalage; rowValues.operator = jsonData.operator; rowValues.Antalskort = jsonData.Antalskort;

Has anyone tried to migrate ThingWorx from Microsoft SQL server to PostGreSQL. Currently we are using ThingWorx 9.4.2 version.

Hi Everyone,I have grid widget which data is populated through a SQL service, and I want to export that data which is in the grid into an excel file , can I do that if so then please share the solution.   Thanks and Regards, Lavkush

Dear Community,    So below in attachment is my datashape of my datatable and currently i am getting all the entries in one of my service. Is there anyway that with infotable capabilities i can get entries which are created in the last 30 days. As you can see i have one of the parameter qualityCheckTimestamp which records the datetime for the entry. Now i would like to use pre existing function of infotable to get the entries created in last 30 days and if its not possible then i would have to iterate through all the entries to get the desired entries which would might be slow process. so anyone have a clue about it? Thank you 🙂   

Hi all, I have a dropdown on my Mashup that gets display data from one of my properties which have an infotable as output and Datashape of GenericStringList. It used to work fine but one day it just stops working and I can't figure out why after troubleshooting for half a day. Any help will be greatly appreciated.Below is the settings for my dropdown widget:Cheers,Deon