IoT & Connectivity

Hey everyone !I am design a good loking ui interface, anyone know if it's possible to change the color/style of the scrollbar in the mashup ?here is a screen of my front-end application : 

Hi All,Do we have any kind of decoders available for ThingWorx to read the MQTT data with Sparkplug Specification? Currently I can read the data in encrypted format but I wanted to get it decrypted and get it as a JSON. Any help to understand this is appreciated. Thanks.

Hi,  Do we have a solution to that since that question was asked ?

Hello,  is there any way to clean a selected location in the google map widget?

There are a few things mentioned on this site about this "SAMEORIGIN" error along with suggested fixes.  But the easiest fix I have found is when entering the URL, add the following parameter ("?rs:embed=true") (without parens and quotes, of course).  You should then be able to open URLs within the Webframe widget.  Your URL should then read something like https://my.domain.com/myreport?rs:embed-true&otherparams=asneeded.   I ran across this when attempting to pull down a report from SSRS into ThingWorx.  The on-screen error was not helpful at all (On-screen rror message:  <URL> refused to connect).  But when I opened Developer Tools, I saw the full error (“Refused to display <  URL > in a frame because it set ‘X-Frame-Options’ to ‘sameorigin’ ”).  Adding the above parameter allowed the report to open very easily, and then you can then print a full paginated report from within ThingWorx from SSRS.   E. Shaffer

Hi Developers,I'm seeking on how we can get over 500 records with 1 SQL query.currently we can get maximum 500 records with 1 query. can we make this limit bigger ?  

Hi, I would like to move the ExpandCollapeSelection to right side. Tried with below CSS but didn't get any solution. Also attached video for reference. Need your help ASAP. .tree-toggle::part(tree-toggle-icon){position:absolute !important;right:0px !important;}#root_ptcsgrid-120-bounding-box::part(tree-toggle-icon){position:absolute !important;right:0px !important;}

I am currently working on configurator application and it looks something like this We haveSome configurations on leftA Thing View with a model loaded in the middleA list of selected configuration on the rightI want achieve two things here.Some how get a list of all parts that are currently on this model and I will make them checked by default in the left menu.Hide and show specific parts based on my selection on the left menu. For example, when I unselect Bucket from the menu it should be removed from the model and when I check it , it comes back.This feature I want to add is similar to the Windchill Visualization option. But I don't know where to look for this in Thing Worx and what option of Thing View I need to update.   

Hi all, is there any way to retrieve the token name using the token valuesThere are multiple entry for token name which has same token value. For example ui.testpassed= test passed , also test_passed = test passed. Need to clean up duplicateThanks in advance 

Hi Expert Community,I have an application that requires to read data using Modbus serial at a fix rate (for example every 5 minutes). The complete data read by Modbus should be published using IoT Gateway MQTT. However an additional requirement is that using the System tag for DemandPoll, the MQTT client should trigger a new Modbus acquisition and also get the new set of values published immediately.Can you suggest how the scan rate in Modbus and in IoTGateway should be configured?Regards,  

I have a mashup with an advanced grid that displays data coming from sql server database. I want to be able to add and remove rows in order to add or delete row data. I was able to add two two advanced grids. Grid one showed all my data and grid two was empty. I was only able to select multiple rows by holding ctrl button. That's the only way I could pass data to the other advanced grid. Is there another way of doing this? I want a user within the mashup to be able to add/delete rows.

Hello, i keep getting these info server stats every 30 mins and would like disable it. any suggestions? 

hi, i have a thing with several service each of them add a entry to stream when is executed, the process for add this entry is same on all services but not all services add entry, and i don´t know which is a problem. can you help me?

Hi Everyone, I am having troubles while creating Java extension for converting data from JSON to INFOTABLE, I have tried multiple methods and no seem to work. @ThingworxServiceDefinition(name = "JsontoInfo", description = "", category = "", isAllowOverride = false, aspects = {"isAsync:false" })@ThingworxServiceResult(name = "Result", description = "", baseType = "INFOTABLE", aspects = {"isEntityDataShape:true", "dataShape:DemoDS" })public InfoTable JsontoInfo(@ThingworxServiceParameter(name = "input", description = "", baseType = "JSON", aspects = {"defaultValue:{\"name\":\"Abcd\",\"salary\":25000,\"married\":true}" }) InfoTable input) {_logger.trace("Entering Service: JsontoInfo");_logger.trace("Exiting Service: JsontoInfo");return input;}ERROR:  Unable to Invoke Service JsontoInfo on TestResJson2info : Cannot cast org.json.JSONObject to                        com.thingworx.types.InfoTable if anybody

Below is my code: //creating an infotablelet Log = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({infoTableName: "InfoTable",dataShapeName: "DataShape"}); //Defining date variablevar currentDate; //assigning valueList variable to my infoTable property that contains values (current it only has one row)var valuesList = Things["TestThing1"].infoTableThingProperty; //loop through the infotable abovefor(var i=0; i<valuesList.length; i++){// new object newEntry = {duration:valuesList[i].duration,source: valuesList[i].Source,Name: valuesList[i].Name,Type: valuesList[i].Type,StartTime: valuesList[i].StartTime,EndTime: valuesList[i].faultEndTime,Voltage: valuesList[i].Voltage,Text: valuesList[i].Text};//adding my object values to the infotableLog.AddRow(newEntry);} //adding my infotable to the stream var newLog = Things["SinkWorx.PwrSupplyError_Stream"].AddStreamEntries({values: Log /* INFOTABLE {"dataShape":"StreamEntryWithValues"} */});&nbs

Some background, we were having some issues with properties connecting that do not change often. We changed the push type of the property to "Always" and this allowed good quality. According to best practices though, we shouldn't do this for many properties. In the same article, it mentions setting the Cache time would pull from the Edge device so we tried this in hopes these properties can pull these static values and connect. Issue: We're having trouble with setting the cache time of a remote property via service. Here's the code, cacheTime grabbed from this article.    // properties and addresses from Kepware propertiesAndAddresses = ["FlowMeterFlowRateAV","S7E_1501_1032.1032.3.DB74,DBW10",.....]; for(var i = 0; i < propertiesAndAddresses.length - 1; i+=2){ var aspects = { "tagAddress": propertiesAndAddresses[i+1], "scanRate": 500 }; me.SetRemotePropertyBinding({ propertyName: propertiesAndAddresses[i], // STRING aspects: aspects,// JSON cache

Hi Community, We created a grid using collection widget, which is working fine for us and is showing data as per expectation.But only two users are facing this issue that no data is loading for them on screen, but service is returning data in response. Although, I can see child mashup name in headers of network with Request Method as GET and Error code as 404.Is data loading on response and not on runtime because of this 404 error or can this be due to something else?Permissions seem to be working fine for user.

Hello,I develop a thingworx application and our application is in a site that publishes us as an iframe. But in this way, the cookies do not work anymore. Indeed, the domain name on my browser is no longer the one of the Thingworx application. And I have the impression that it does not fit anymore. Is it possible to configure the cookie domain name so that it works as an iframe? Thank you for your help. 

I installed ThingWorx 9.1.1 (Postgres, Java 11, Windows) using installer. After the installation, I can't see ThingWorx-Foundation.exe in tomcat/bin folder. 

Thingworx Version: 9.3When ever the Mashup is opened as PopUp on a button click, there is white border on the button (button on the opened Mashup).Thanks,Shashi

Hello, I keep getting once or twice a week this DEADLOCK error in our system. we have looked are timers, schedulers, nested loops, with no final solution. I need urgent help to figure out what is causing it.Attached is Application Screenshot and Log Files. 

Hi, How can we pass intotable as a parameter to a stored procedure for inserting data in postgreSQL table. @nmilleson @VladimirRosu_116627 , Can you please help me.Thanks,Meghna

Hello, community, I would like to capture the time a subscription gets fired. Is there a way to this Regards.TB

Hi all, I have 2 Thingworx instances raising every 30 minutes a warning related to 'Thingworx System Metrics' (screenshot attached).Does anyone have an idea on what is going wrong ? Thanks for your help.Thibaut

Hello ! I have some troubles upgrading Thingworx 9.1 to 9.2.4 (both with an H2 db) My Tomcat server works when Webapps is empty, but whenever I restart it with the Thingworx.war in Webapps, it crashes, returning me this log in ErrorLog.log :2022-10-11 08:15:44.725+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Error in copying permissions: A problem occurred while trying to acquire a cached PreparedStatement in a background thread. 2022-10-11 08:15:44.727+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Error encountered while executing migrator 2022-10-11 08:15:44.727+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] java.sql.SQLException: A problem occurred while trying to acquire a cached PreparedStatement in a background thread. 2022-10-11 08:15:44.727+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] An error was encountered while executing task