ThingWorx

Hi,    I am trying to purge a ThingWorx database, which is hosted on AWS RDS using Postgres. unfortunately, the DB has more than 20TB of data.    I was trying to delete the data in the DB and purged around 80% of the data, but the size of the DB remains the same.   Below are the validations I have done: Re-checked the rows that got purged, and they were not showing up in select After the purge Did Analyze - which deleted all the Dead Tuples from the DB also Checked the Table (public.value_stream) size, still shows the same size of DB which was before the pruge.  What my research shown is that once the AWS RDS DB is increased to a point, that can't be shirnked/decreased, customer should continue paying for it.   I am looking for a best way possible to decrease the size of DB such that the costings get reduced   Thingworx Version: 9.1   Thanks,

I am working on SSO SAML integration with Thingworx 9.3.4 using OKTA. and stuck with the below thingworx error apperating in Application log. Need advice on what might be the issue. I have double checked and validated the path, permission, password mentioned in KeyManagerSettings json parameter in sso-settings.json file. The error:WebApp starting...2025-09-19 13:31:13.071+0530 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Default Persistence Provider Name = ThingworxPersistenceProvider2025-09-19 13:31:13.071+0530 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Default Persistence Provider Package Name = PostgresPersistenceProviderPackage2025-09-19 13:31:13.076+0530 [L: INFO] [O: c.t.p.p.PostgresDatasource] [I: ] [U: SuperUser] [S: ] [P: ] [T: main] Reading configuration from configTableCol2025-09-19 13:31:13.230+0530 [L: INFO] [O: c.t.p.p.PostgresDatasource] [I: ] [U: Supe

Hi all, I'm trying to set the background of a grid filter to transparent (inherit).  I can change the background to a color by changing the top-bar and tools backgrounds in the grid's Style Properties, but setting those to "inherit" is not making the background transparent.  I can't find any other Style Properties to change so maybe I need custom CSS but I don't know how to do that in CSS.  Does anyone have an idea how to do this?  Hopefully the attached image helps show what I'm trying to do (I want the filter background to be transparent to show the overall background color). Thanks! 

I followed this guide...https://support.ptc.com/help/thingworx/platform/r9.6/en/#page/ThingWorx/Help/Mashup_Builder/Widgets/Grid_EditingCellData.html# However, I do not see the edit icon shown below and I cannot edit a cell. Does anyone know why this may be? All I see is the edit button, but nothing becomes editable when pressed.  

公司在用一个mariadb5.5.60数据库，现在我需要用thingworx连接它并查询数据，用mysql的驱动连接不上，请问我要怎么做？麻烦给出详细步骤，感谢！

I am using ThingWorx Platform Release 8.1 and DatecodeSP1After a problem with the server where the RAM memory was saturated, the server had to be restarted, after this event the Tomcat service starts and stops shortly after.Here are the errors that I facedFaulting module name FlxCore64.Dll version 2016.8.0.0 exeption code 0xc0000417

I am using ThingWorx Platform Release 9.0Our customer has requested that the application based on ThingWorx, when saved to the Android home screen using Chrome, appears as a Progressive Web App (PWA), i.e., without the Chrome toolbar, behaving like a standalone app. Currently, when added to the home screen in Chrome, it still shows the browser bar. On Samsung Internet Browser, however, the same shortcut appears correctly as a standalone app.Could you please clarify why this difference occurs and advise what configuration or changes would be needed in order to achieve the same standalone PWA behavior in Chrome?Environment details:ThingWorx version: 9.0.3-b243Android version: 14Chrome version (where PWA does not work as expected): 126.0.6478.110Samsung Internet Browser version (where it works as expected): 24.0.6.15

Hi All,I'm trying to find a way to programmatically list all entity permissions for a specific user or user group in Thingworx 9.7?I've already searched the PTC community and found these two threads, but they haven't resolved my issue.Solved: Permisions for users and groups - PTC CommunitySolved: Re: List a User's, Group's, or Org's Permissions - PTC CommunityThe main problem is that the CheckPermissionDataShape is missing in Thingworx 9.7. I attempted to create my own data shape with required fields based on the documentation, but it is not working as expected.Does anyone know of an alternative method or a workaround to programmatically retrieve a list of all entity permissions for user or user group in Thingworx 9.7? Any guidance would be greatly appreciated! Regards,Bhavya 

Hello, I'd like to ask if it's still possible to print charts in Mashup. I remember there used to be an extension called PDF Extension. Is it possible to implement a button that would take a screenshot of the current screen and print it?

 Hi ThingWorx Community,I’m currently running ThingWorx version 9 (ThingWorx development.server.build-b12466) with a Postgres database. I want to switch to a new Postgres database hosted on RDS.Here’s what I’ve done so far:Created a new RDS instance.Added a database named thingworx.Updated the platform-settings.json file with the new database connection details.However, when I start ThingWorx, I encounter the following error:CRITICAL ERROR ON STARTUP: Unable to initialize and start system: ERROR: current transaction is aborted, commands ignored until end of transaction blockI’m trying to understand:Is updating the platform-settings.json file the correct method to point to a new Postgres database?Are there additional steps I need to perform to migrate ThingWorx to a new database instance?Could this error indicate a problem with the database setup, migration, or connection configuration?Any guidance or recommended steps for safely switching the database would be greatly appreciated.

Thingowtx 9.6.5   I know it's possible to show a message on a mashup if a service gives an error. The message can be a fixed token on the available localizations, or a string.   The string can also report the [server-message] that is the string description of the error generated by the service (plus some additional text !), that is in this format Error executing service ***SERVICENAME**** . Message :: ***ERROR DESCRIPTION *** - See Script Error Log for more details.   Showing "See Script Error Log for more details", but also "Error executing service" is not very professional, even more there is a "customer" reading that ... (which error log ??) Moveover  I would show a dynamic text returned by the service (in case of error) as a "wanted behaviour" for the error notification, because there may be more conditions...   Is there a way to to that ? For me it could be enough to show the error description only instead of the whole message. There should be something li

@Jam_Kirko Could you possibly share the CSS for changing a reference line color if you still have it--from this topic?    

In the mashup design tab my full mashup is not shown, the lower portion of the page is cut off an not accessible; only what initially fits in the view window can be accessed.I should be able to scroll down to see the lower portion of the mashup but I cannot. There are several containers and widgets that are cut off and not accessible to me now. This is a new issue that has occurred during my development. I can preview or view the mashup and all containers/widgets are still present and active, they are only hidden out of view in the design tab. If I minimize the bindings/reminders/validation window at the bottom of the screen more of the mashup becomes visible as the view window is essentially expanded, this still does not show my full mashup.Zooming out of the mashup design tab only shrinks the same portion of the mashup that was viewable, no additional portion of the mashup comes into view only empty space. Likewise using the pan mode only lets me drag the current view around and

I am using ThingWorx Platform Release 9.2 and DatecodeSP6Hi,When I open http://localhost:8080/ its not connecting and giving me popup The site Cant be reached, but in services Tab tomcat services is running. While I upload a Thingworx.war file in Manage apps the localhost was just loading.

We’re working on a work instruction mashup in ThingWorx where the user needs to drag and drop a marker onto an image to indicate the specific location where an operator should perform a task.Is there a recommended way to implement this functionality within the ThingWorx Mashup runtime?Are there any widgets, extensions, or best practices that support drag-and-drop interaction over images?Any guidance or examples would be greatly appreciated!

We enabled sso in our Application, in our application we have react  page it redirects to new page without asking authentication.while we put the url to the new tab also it doesn't ask authentication

Hello, I would like to upload some files to azure container via SFTP, please help me with the best practices.   thanks,Janakiraman

Hi, In a child mashup I have a grid with rows. I exposed a grid parameter (selectedRows) and bound it to the mashup parameter which is also of infotable. But when I try to use this parameter in the parent mashup, I don’t get any data.   Instead, I see developers usually create expressions then bound that mashup parameter of infotables singe value like field in it... to extract single values (like Id, State) and pass those to the parent.  Is this the expected behavior? Why can’t the parent directly consume the InfoTable parameter? Is there a clean way to expose the whole SelectedRows to the parent, or is best practice to always send only the needed values? Thanks!   my expression which i bind from my mashup parameter(infotable type and use that single field to bind with input parameter of this expression ) to get the value and then bind the output again to the mashup parameter which is of string type to get that value in parent mashup....    

Hi Community,   I’m trying to get the part name when clicking on a component in the ThingView widget (PVZ model).   What happens   SelectedOccurrencePath updates (e.g., /0/3/4), so the click is detected. SelectedParts stays empty → no part name or ID is returned.   Question   How can I resolve the occurrence path (e.g., /0/3/4) to the actual part name like 30702722.PRT? Do I need special PVZ publish settings or a widget option so that SelectedParts is populated with part metadata? Expected output when clicking a part: Name: 30702722.PRT Path: /0/3/4   Has anyone implemented this or any idea how to get it?   Thank you

Hi Team,I am looking to implement a monitoring solution for our three ThingWorx (TWX) instances.Our primary requirement is to perform regular health checks to verify that each server is running correctly and the application is reachable. The key objective is to have an automated notification system in place that will alert us immediately if an instance becomes unresponsive or encounters a critical error.Could you please advise on the recommended methods or tools to achieve this?Thank you for your guidance. 

Hello,   help required to  retrieve credentials from Azure Vault to thingworx, this will later be used to in Thingworx configurations.       please help.       Regards, Janakiraman

helppp. i have an SQL query in a Thing. Im trying to extract the date from datetime column using Cast but its not working. select b.sysdat,    cast (b.sysdat as date),    a.itmcod ITEM_CODE,    d.itmdsc ITEM_DESC,    b.trntyp,    sum(b.trnqty) over (partition by a.itmcod,b.trntyp) QUANTITYfrom sysdtl a join systrn b on a.trnseq=b.trnseqjoin itmmst d on a.itmcod=d.itmcod  

I am looking into the new IoT Streams functionality for ThingWorx 10.0 https://support.ptc.com/help/thingworx/platform/r10.0/en/index.html#page/ThingWorx/Help/Composer/DataStorage/IoTStreams.html%23   As it seems like the streams are configurable for Kafka or Azure Event Hub.   We are using Redis as a caching option for several other use cases. Can the IoT Streams be integrated with Redis directly as well?   Alternatively we will need to implement the Redis JDBC driver and create a subscription that will push new data.

Hi Community,   I want to design a mashup where Products are shown as columns and Machines as rows. Inside the cells, admins can add or remove “Errors.”   Example mockup:   Both Products and Machines are dynamic (number of columns and rows can change). Question: What’s the best way in ThingWorx to implement such a dynamic mashup layout?Which widget should i use for this approach?     Additional info: My datashape contains infotable type productStations (machine) field in which we can add more then one machine to one prod and in this infotable we have then another infotable error to save more then one error in it.   Datashape results 1) 2) 3)     Thanks for any design suggestions!  

Hi Community,   I have an InfoTable with several fields, and I would like to use one of those fields as the source for a Dropdown widget. The issue is that this field can contain duplicate values, but in the dropdown I only want to show distinct values. Right now, the only way I see is to create a separate service that takes the InfoTable and returns only the distinct entries.    My question: Is there any way to achieve this directly in the mashup (e.g., via Data Filter, Query, or some built-in option) without having to write an additional service?   Thanks in advance for your ideas!