ThingWorx Developers

Hello everyone, I am using the Thingworx 9.6 platform, on which I use the purge functions ‘PurgeSelectedPropertyHistory’/‘PurgeAllPropertyHistory’ on ValueStream to manage data retention. I often get the following errorERROR[java.lang.RuntimeException: com.thingworx.common.exceptions.DataAccessException: [1,018] Data store unknown error: [Error occurred while accessing the data provider.] The message is returned to me after 602 seconds. Can anyone help me it is important to keep only a small amount of data active in order to avoid a db overflow.ThanksDimitri 

Hi,I'm looking for the latest solutions to integrate GitHub with ThingWorx for Continuous Integration (CI) and Continuous Deployment (CD). Specifically, I need to:Manage ThingWorx artifacts (e.g., Things, Services, Mashups) in GitHub.Automate workflows for pushing/pulling changes between ThingWorx and GitHub.Set up CI/CD pipelines using GitHub Actions or other tools.Has anyone implemented or found an effective way to use GitHub with ThingWorx for these purposes? If so, what tools or extensions are you using?Thanks in advance!Houssem

Hello I am looking for thingworx 9.7 help center guide , can some one please help me with that Thanks

I need guidance on how to connect Thingworx on-premises version to snowflake database. Could you please provide:1. The necessary steps or documentation for this connection?2. Any prerequisites or system requirements for the on-premises setup?3. Information on licensing or additional configurations needed during this process?4.Any specification on snowflake database?

We can allow other IPs to use the ThingWorx REST API by enabling cross-origin access. I tried modifying the web.xml file, but I couldn't get it to work. Can anyone help me?

I need thingworx cwc extended extensions for features like QA report, Audit Report, Attachements/ logsheet upload in work instruction verification step. 

The extension uses the org.apache.parquet library and writes the parquest file to Thingworx repositories. The service works correctly if Thingworx is installed on a Virtual machine. The service fails to write the file to Thingworx repositories if Thingworx is installed on kubernetes containers. In particular the extension fails by going to do a chmod 644 on the file to define the correct privileges. Has anyone had the same problem? Are there any solutions to the problem?ThanksDimitri

In adv grid, columns are automatically changing its order in UI. How to stop this behaviour ? Iam using Thingworx 9.1.

Im very new to Thingworx and Im trying to build my capability.I am using collection widget with data source from a service in the Thing I created.Inside the collection widget, a mashup is already defined but it doesnt seem to load when I view the mashup. My service doesnt require a parameter and it will give the infotable when executed.Infotable (headers are from the datashape I made)KPIValueColorKPINameA1blackAB2greenBC3redC UID Field: KPIMashup Property Binding:{"KPI": "number","VALUE": "string"}Child Mashup: Test Collection Data  Pls see screenshots, I cannot troubleshoot it, its not giving anything when I load the mashup

Hi,   I have recently upgraded from Thingworx 9.1 to 9.7. The DB also got upgraded.   I did a dump of the DB and restored it to my local environment, and the instance is working fine. But when I do a restore, it does not work fine in the QA Environment. Below is the Error I get in the logs: 2025-02-28 11:04:13.242+0000 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: Bindhu] [S: ] [P: ] [T: http-nio-8080-exec-9] Unable to Invoke Service QueryNamedPropertyHistory on Postman_Thing : com.thingworx.common.exceptions.DataAccessException: [1,018] Data store unknown error: [Error occurred while accessing the data provider.] org.postgresql.util.PSQLException: ERROR: canceling statement due to user request at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356) at org.postgresql.jdbc

Hi all, We have a thing in prod that was pushed from our dev environment. That thing uses a template that is outdated. We want to change the template to a new one that we are now using in dev, but pushing gives this error:How can we go about changing the template in prod? We are unable to manually delete it directly from prod since the entity was pushed there. 

Hello I am trying to apply custom CSS to my Thingworx mashup but it is not working . Is there any sample example or code snippet available which can help me with setting custom css. Thanks

HiI have a question related to contained mashupsI created a contained mashup that holds two buttons, and I want to use it in another main mashup as a popup mashup appears when I click on a row on the grid exists the main mashup.I assigned a service ( deletion row from the grid ) to a button exists in the popup contained mashup, when I click on the button nothing reflect on the grid.Service is working and I tested on another button that exists in the main mashup.What can I do to make the service run on the button exists in the contained mashup ?

ThingWorx 9.3.6-b1323 

I am using ThingWorx Platform Release 8.5.As a required project step to upgrade v8.5 to the latest v9.x of ThingWorx, it is necessary to "move" Production ThingWorx due to failing/EOL hardware. As part of the re-cloning process, ThingWorx fails to start after attempting to clone ThingWorx from Source Server to New Target Server with the exact same Hostname. Tomcat starts and shuts down when attempting to start the Windows Service - fails to fully start. Errors in log files are thrown referencing "APR based Apache Tomcat Native library" and "HTTPS protocol". Is there a documented instructions for how-to properly Clone ThingWorx from host to host?Here are the errors that I facedCatalina-log:- 10-Feb-2025 17:44:56.643 SEVERE [main] org.apache.catalina.util.LifecycleBase.handleSubClassException Failed to initialize component [Connector[HTTP/1.1-80]]org.apache.catalina.LifecycleException: Protocol handler initialization failed- 10-Feb-2025 17:44:56.643 INFO [main] org.apache.coyote.Abstract

Hi all,   I want to upgrade ThingWorx version 9.2.13 to 9.6. I want recommendations, Guidance and also support. what are the possible ways and which one is the best approach?

hi,can I add media ( icons ) to grid ???I tried several times but the media image is not displayed on the grid only the path like /Thingworx/MediaEntities/Media name only this path appears.Also I made the column configuration Image render.Note : this grid binded with infotable and the column in the infotable which represent the media is string type

Hello, I need a schedule widget. I see the standard one (this one) but I would like to have additional functionalities, like single-day visualization and/or click to open details.   Is there another custom version of the widget or is it possible to customize it?   Thanks in advance

In chipdatafilter, we want to filter one column using multiple values. Example, I want to filter ColoursColumn in grid data using three values like Red,Orange,Yellow. How to do this.   Is there any way to multiselect options of values to filter grid data?

Hi ,    We could see the below answer in the community , is still TimeScaleDB is not supported ? could you please confirm      TimeScaleDB as Persistent Provider     ‎Dec 12, 2019 01:23 PM     TimeScaleDB is not supported at this time.  Please refer to this page from our Help Center for a list of supported persistence providers.   View solution in original post   Thanks   

Hi,   I have a Thingworx 9.1 instance and am looking to upgrade to 9.7. However, the instance is on the Postgres DB, and real-time data is stored in the Postgres.What would be the easiest way to do this? 1. Should I Upgrade the Postgres Version? 2. Should I Upgrade the Scehma too?   Thanks,

@lschier  I followed your instructions for one of my requirement. I am getting the error at the service -  Error executing service autoLoadMultipleExcelFiles. Message :: Could not initialize class org.apache.poi.xssf.usermodel.XSSFWorkbook. Would you be able to help?   Version of TW- 9.6.0-b85

I am creating a bar chart with 7 Legends and legends are showing in multiple columns.Is is possible to show all legends in one row.Requirement-Thanks in advance. 

Hi team, I wonder if its possible to freeze a particular row item from grid widget while scrolling? Am having 100 rows in my grid and the top row holding some calculations as reference for rest of the below items, while scrolling up/down it take top row too. So, is it possible to freeze any particular row item? or excluding particular row being filtered?  please provide any suggestion.  thanks,Janakiraman

Hi, How to update scan rate for few properties to Kepware industrial thing at a time using service instead of updating one by one  property in Thingworx 9.5. I am trying to update scanrate to few properties using service but SQL transaction log size is increasing. Because , updating scan rate one by one property using below service. Is there way update scan rate at a time ? I am using below code. for(let i = 0; i < propertynamelist.length; i++) {    ...........  .................    Things[remotething].SetRemotePropertyBinding({ propertyName: propertyName /* STRING */ , aspects:          {           scanRate: 480000  // Update only the scan rate aspect         } });   }   Thanks&Regards, Latha