ThingWorx Developers

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  

when we try to import entities from system repository it is showing error in application log as [1,018] Data store unknown error: [Error occurred while accessing the model provider.]  

Hi Team, Where can i find this AutoComplete Widget extension.   Regards,Saran 

SelectedRowsChangedCallback is broken in 9.3.4. already opened a case with support.

Hi PTC,we have requirement to enable the Web cam and able capture an Image. is there any provision that to access the device camera to integrate with Thingworx.Kindly provide assistance.  Thank you,@H_1234

I am running demo version of KepwareEX and communicating Modbus to a device. IP addresses are on same subnet and can ping the device. However, when running quick client the update count stays at one for all tags? Even the ones form statistics and system tags do not update? The quality is good on all tags but none of them are updating. Any ideas?

When trying to optimize the grid advanced widget it is working when tried in console, but when impemented in custom css the styles are not getting reflected.

Hi there,  We are hoping to migrate our current TW env out of a Postgres back end and move it into SQL Server. We are running the application on a RHEL7 Linux box. I am finding the PTC installer fails to connect to SQL server. By using SQLCMD in Linux we can connect to SQL Server using the -C switch which turns off certificate validation. Can this switch be used the installer ?

I am facing a problem when I tried to establish the connectivity between My Thingworx and SAP,Can someone please provide the available HandsOn tutorial for the configurations. It would be really helpful. Thanks in Advance.

Hi, I have created a services in database for updating the data of database table,  from data table, but it is not updating the integer data in database table, following is the service details, let table;let variable;let DataTableData = Things["pp_44270_SPC_DataTable"].GetDataTableEntries({maxItems: 1000 /* NUMBER {"defaultValue":500} */});for (var i=0; i <=DataTableData.rows.length; i++){var row=DataTableData.rows[i];table=me.Table_Update1({DataSource: row.datasource /* STRING [Required] */,Workstation: row.workstation /* STRING [Required] */,Model: row.model /* STRING [Required] */,Variable: row.variable /* STRING [Required] */,Value: row.value /* INTEGER [Required] {"minimumValue":1,"maximumValue":100} */,Key: row.key});var result=table;} I will be thankful, if some one provide me the solution. Thanks in advance.

Hello everyone! I have an infotable with data that I'll export as a .csv file. However, one of the fields is a link and I'd like to present it as a clickable link once the user opens the file. Is this possible? For now, the link is not clickable so users have to copy and paste it to the browser to access it.Thank you in advance. 

Hi, I have a service that is triggered based on a different event. The service takes 1 input and outputs an infotable.When I try to bind a dropdown to the output of this service I don't get any option to bind the service output to a dropdown.

Hi,I am using the following snippet, to Query on FieldName Which does not contain the "Test Question" Text in the FieldName Data var query = { "filters":{ "type": "NOTLIKE", "fieldName": "Name", "value": "Test question:\\+*" } }; let params = { t: result /* INFOTABLE */, query: query /* QUERY */ }; // result: INFOTABLE result = Resources["InfoTableFunctions"].Query(params);   Even though I get an INFOTABLE with rows containing "Test Question" in the FieldName "Name"..Where did I do wrong?Note: I have followed Query Parameter for Query Services (ptc.com) and Picked up the snippet from thereThanks,