ThingWorx

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

Hi there, I am new to Thingworx, I have created a Mashup which contains a collection control, within that collection control I have added a mashup of a checkbox. My requirement is to check only checkbox within collection (Like radio button). I have tried different ways but couldn't achieve it. Like I added a checkbox on parent mashup and passed child mashup checkbox state which affects all checkbox's state within collection. Any idea would be appreciated. Thanks,

Hi all, Getting error while executing AddStreamEntries service: JavaException: java.lang.Exception: Invalid number of values provided to AddStreamEntry   let newEntry = { sourceType: undefined, // STRING values: entries, // INFOTABLE location: undefined, // LOCATION source: undefined, // STRING tags: undefined, // TAGS timestamp: new Date() // DATETIME }; // CreateInfoTableFromDataShape(infoTableName:STRING("InfoTable"), dataShapeName:STRING):INFOTABLE(StreamEntryWithValues) let obj = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({ infoTableName: "InfoTable", dataShapeName: "StreamEntryWithValues" }); obj.AddRow(newEntry); me.AddStreamEntries({ values: obj /* INFOTABLE {"dataShape":"StreamEntryWithValues"} */ });   Thanks,Sujith

Hi all, i have a infotable which has columns. In which a column itself a infotable (columnInfotable) in it.i need to get the value of the of the columns in the columnInfotable. Is there any logic.thanks in advance 

Hi all, i have a infotable which is returned from Store procedure. The infotable has a column which returns 0 and 1. Is there any way to get the count of the rows which has value 1. Thanks in advance 

in my MenuEntry the linkDestination and linkType are primary key. but the documentation says:https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx/Help/Mashup_Builder/Widgets/MenuBarDefiningtheMenuBarItemsUsinganInfotable.html#linkDestination and title are primary key.

Hi Team, Suppose any ThingWorx platform restarts everyday automatically at sometime in night, then how to stop this or edit this automatic ThingWorx restart configuration. Thanks in advance.

Hello all,   I'm facing TWX things disconnecting issue continuously during production run &  whenever im reinitializing kepware, again things will connect.   Can anybody provide some solution to stop this !! or Is there any way to do automatically the same thing from TWX side  as kepware reinitialization does.

Hi all,   is it possible to show a buttons tooltip even if it is deactivated?   Reason is I want to change the tooltip text to explain to the user _why_ the button has been disabled.   Thanks

We have scenario where we have data stored in csv files stored in local computer and we need to read the data into thingworx which is present in cloud. we then have to visualize the data loaded into thingworx from csv in a mashups. Any leads on how we can achieve it. we also have kepware where we can use simulators to read csv files to a tag and then read the data from the tag. But is it possible to read files directly into thingworx without interacting with kepware.

Hi, We developed few mashups in TW 9.0 to set to the mobile resolution of 400*800 and it works fine when we do the runtime view.  When exporting this mashup and importing in TW 9.3, the containers are becoming small even if the containers are set to specific fixed size. The same mashup works fine in 9.0 and containers are spaced how expected but in 9.3 the containers gets shrink. Should we set any property in the higher version?How can this issue be resolved?      

Hi,I got the Radio Buttons on the List widget,Problem: The selected radio Button stays only when we Hover on it. It should be selected after hovering or until the next list item is selected. Used the following CSS: ptcs-list::part(item-value)::before{ content:url('../Common/thingworx/widgets/dhxgrid/images/radio-unfilled.png'); margin: 10px; } ptcs-list::part(item-value):hover::before{ content:url('../Common/thingworx/widgets/dhxgrid/images/radio-filled.png'); margin:10px; } Any workarounds over here can be done?Thanks,

Hi Folks,   As we know Mashup renders Style/StateDefinitions (platform subsystem) before executing data custom services which consumes a significant screen load time. Is there a way to cache these subsystem services rendering so that it doesn't require to load every time?   Related: topic