IoT & Connectivity

I'm working on ThingWorx 9.3.5, I have difficulties on styling the XAxis label for bar chart widget. As you can see on the image, the XAxis label is truncated due to insufficient space at the XAxis. Is there anyway to add new line below instead of truncating it?

Hello,  I'm designing a mashup, to gather and show data from many Things, using Dynamic Services. But it doesn't work, no data is showing in the mashup. I've created a ThingTemplate, with all the properties needed, also, I've created a "Helper Thing" to create new things using the TT as base. The helper also fill the properties whose include some infotables. Everithing works as should until the mashup step. I've created a mashup with list and grids, The idea is: when I press a row, the other grids should show me the data related. For this, I'm using services with output Infotable (IsDataTable with Datashapes and a primary key). I've called those services on the mashup enabling Dynamic Service; Also, I've called the service getImplementingThingsWithData; all of them from the TT.  But it just doesn't work.I've read about IDFieldName (1). I've checked it matchs with my primary key, so I'm not sure if that's the problem. Moreover, I go

Hello,When I Tried to Up the Docker container for thingworx,  I do get the following error: ERROR: The image for the service you're trying to recreate has been removed. If you continue, volume data could be lost. Consider backing up your data before continuing. Continue with the new image? [yN]y Pulling postgresql-init (thingworx/postgresql-init-twx:latest)... ERROR: pull access denied for thingworx/postgresql-init-twx, repository does not exist or may require 'docker login': denied: requested access to the resource is denied How can I resolve this?Thanks,

We are having Thingworx 8.5.1 installed with Installer. It needs to be upgraded to 9.3.x version.   There is an article saying "If you used the installer to install ThingWorx Foundation 8.5.3 or earlier, then manually upgraded to a later 8.5.x version, and are now preparing to upgrade to 9.x by running the ThingWorx Upgrade Ready Utility"   How can I manually upgrade Thingworx 8.5.1 to later 8.5.3?

Hi everyone,   I have KEPServerEX6 and I need to change options in property editor. When I change option and click apply settings is confirmed but when I runtime connect the setings change to previous. Tell me why?

Hi @VladimirRosu_116627, I'm trying to create the security image but as you can see, in the documentation there is an impossible command shell, without param. I didn't find the meaning going through the sh code.  maybe I missed something this is the error trying to create the  twx image Thanks in advance Pier  

Hello, I wanted to use the "OUTPUT" clause in an SQL command to get the latest inserted row.However I am getting this error: Execute Update failed: com.microsoft.sqlserver.jdbc.SQLServerException: A result set was generated for update. Now, the SQL that i am using does work in SSMS. Here is the structure:   INSERT INTO Table (value1, value2) OUTPUT Inserted.uid values(1,2) Any ideas? I would if possible like to avoid using stored procedures. Thanks,

Based on Google's Spanner DB; CockroachDB is a distributed SQL DB scaling horizontally; surviving disk, machine, rack & even datacenter failures. It is built to automatically replicate, rebalance & recover with minimal configuration  See What is CockroachDB? for more.   Useful in use cases requiring: Distributed or replicated OLTP Multi-datacenter deployments Multi-region deployments Cloud migrations Cloud-native infrastructure initiatives Note: CockroachDB in current state isn't suitable for heavy analytics / OLAP.   Feature that makes it really attractiveAs mentioned above, scaling horizontally it requires minimal configuration out of the box allowing quick setup starting from local laptop/machine as shown below it can scale easily to single dedicated server, development/public cloud cluster. Due to easy setup, adding new nodes is as simple as starting the cockroach utility.See CockroachDB FAQ for more. To top it off, it uses PostgreSQL Wire protocol and Post

I got two virtual machines.Virtual machine 1 makes use of System Platform IDE.Virtual machine 2 runs the Kepware and has a Kepserver up and running with a connection to a PLC.I would like to be able to use the Kepserver from Machine 2 on my OPC client in Machine 1.But the kepserver cant be found and even without firewalls enabled on both virtual machines, nothing works.Ive gone through an entire DCOM guide for Kepware and it didnt seem to do anything.If i install Kepware locally on the same machine running System Platform IDE, the kepserver shows up without any problems, and im able to connect directly to it through OPC.But i would like to run the Kepserver on its own virtual machine.Is there something im missing? I would love your inputs ❤️ ! 

Hello,I have Simulated Tags. The values from Thingworx are sent/written to the Simulated Tags. These simulated tags are used in Derived Tags to Calculate and send to Thingworx.But when KepServerEx is Re-Initialized, the simulated Tags become 0. Therefore, Derived Tag values are wrong. How can I prevent simulated Tags from becoming zero whenever KepServerEX is reinitialized? Thanks,

Hi there -We're on Thingworx 8.5.15.  I have a mashup that contains a dropdown widget.  I have a service that is used to populate the available choices for the dropdown.  I want to pass the selected values (plural) of the dropdown as a parameter to a second service for processing.  The second service takes a parameter of type String.  In this thread, @Ashritha states that it's a simple matter of binding the Selected Rows property of the first service as a parameter to the second service.  When I try this and log the parameter values received by the second service, I find that it only receives a single String value for processing. What must be done in order to pass multiple values to a service parameter and receive multiple values as a service parameter? thanks in advance,dgg

Hi All,I want to send mail to monitoring team in case of any alerts. So I want to know how to send mail from thingworx. Please let me know your inputs on the same. Unable to Invoke Service SendMessageWithNoReplyTo on EmailOnAFailureCase : Unable to send error email for logged incident

We have a mashup that is connected to Active Directory for authentication. When a user enters their log in credentials we have noticed that Security>Users is case sensitive. It will create a duplicate user name if the user fat fingers the shift key. For example: john.smith (actual log in name)John.Smith (Mistake)JOHN.SMITH (Mistake)When this occurs it prevents the user from accessing the mashup application until the duplicate user name is removed. Does Composer have a OOTB function that prevents this occurring or do we need to develop a custom solution to prevent this from occurring?

I have 2 tables called 'table123' and 'table246'.'table123' columns: 'ID', 'Dept_ID', 'First_Name', 'Surname', 'Salary', 'Address'.'table246' columns: 'Dept_ID', 'Dept_Name'.I'm looking for a list of employees with the lowest salaries in each department. I can accomplish it in two ways: an Equi-Join or an Inner-Join. I've been informed they can both be utilized to get the desired outcome. I used the following queries:Equi-Join:SELECT First_Name, b.Dept_Name, alt.Min_Salary AS Min_Salary FROM table123 a, table246 b, (SELECT Dept_ID, MIN(Salary)Min_Salary FROM table123 GROUP BY Dept_ID)alt WHERE a.Dept_ID = b.Dept_ID AND a.salary = alt.Min_Salary AND a.Dept_ID = alt.Dept_ID;Inner-Join:SELECT MIN(Salary)Min_Salary, Dept_Name FROM table123 a, table246 b INNER JOIN (SELECT First_Name, MIN(Salary) FROM table123 GROUP BY Dept_ID)alt ON b.Dept_ID = alt.Dept_ID;The Equi-Join command returns the appropriate table, with the columns 'First Name,' 'Dept Name,' and 'Min Salary' having all essential

HiAs the trial version of thingworx is not available on thingworx developer site. i want to install thingworx license for personal practice, how i will get that? is it affordable for personal practices? 

There is a situation where DataTables Data(Which is in Postgres) needed to be Migrated to the InfluxDB, such that going forward InfluxDb Streams will be used in DataTables. So, is there any best Practices by PTC provided ?@VladimirN @AnnaAn @paic @slangley @CarlesColl @c_lowy Thanks,Shashi. 

Hi Experts,   Please suggest a way to terminate user session from browser once the Logout is triggered. The user is being authenticated through SSO and want the user to click a button(probably logout) and should be redirected to login again to enter the Azure AD credentials instead of re-login automatically because the session is still alive.   I have already tried TerminateUserSession resource but that works only for Administrators group members and I have non-administrator custom user groups with specific permissions.   Note: Don't want to redirect to a different mashup/screen as a workaround.   TIA.

Migrated the Postgres DB from 10 to 13, but after the migration, data is not logging in to the ValueStream. Below is the Property Settings image. The DataTable entries are stored in DataTable Tables in DB, but not the Property values in the ValueStream Table. What would be the potential issue, or how can this issue be debugged?Thanks,Shashi.  

Placed an Line Chart on the Mashuip, But there is lot of spacing issue on the Chart, by which Dashboard Width and height needed to be increased. How can the spaces can be removed ?@c_lowy @slangley @VladimirN @CarlesColl Thanks,Shashi

This video is Module 10: ThingWorx Foundation & Analytics Integration of the ThingWorx Analytics Training videos. It gives a brief review of core ThingWorx Platform functionality, and how the Analytics server works on top of the platform. It also describes the process of creating a simple application, complete with a mashup to display the information from a predictive model. This video does not contain any hands-on exercises, and you don't need access to a running ThingWorx Analytics environment. This video has chapters available in the player menu so you can jump directly to each section. Chapter Summaries 0:00 – Intro: ThingWorx Foundation & Analytics Integration OverviewThis Module 10 introduction previews the ThingWorx framework, things with properties, services, events, and subscriptions, plus analytics communication methods and mashups for consumable insights. 0:33 – Things in ThingWorx: State, Behavior & Core ComponentsA thing is an instance of an object with state a

This video is Module 11: ThingWorx Analytics Mashup Exercise of the ThingWorx Analytics Training videos. It shows you how to create a ThingWorx project and populate it with entities that collectively comprise a functioning application.  It contains a recommended hands-on exercise. Here you are shown how to build a ThingWorx application that uses a ThingWorx Analytics predictive model. If your ThingWorx environment is connected to a streaming asset, say, through Kepware, you may use five tags from that asset rather than from the "CCPP" thing shown in this video. Simply bind to those tags and rename the new properties as shown in this video. NOTE: This exercise is only for demonstration purposes, and will not produce a meaningful or accurate model. **Update June 16, 2023: The following steps now reference "DataSimulator_Standalone.xml" instead of the previous "dataSimulator.xml". This new Thing will prevent errors on import.**If your environment isn't connected to a streaming asset, you

This video continues Module 9: Anomaly Detection of the ThingWorx Analytics Training videos. It begins with a ThingWatcher exercise, and concludes by describing Statistical Process Control (SPC). The "SPC Accelerator" will be covered in Module 9 Part 3. This video contains a hands-on exercise which you may complete as you wish. However, it's not necessary, as the following modules do not rely on the product of this exercise. It shows you how to configure a property on a thing for anomaly detection, and view the results in a mashup. Download and import the attached "Project_AnomalyDetection_ThingWatcher.xml". NOTE: It is recommended to import into a sandbox or non-production environment running ThingWorx/ThingWorx Analytics 9.2 or later. Chapters are available in this video — use the chapter menu in the player to jump to any section.Chapter Summaries 0:00 – Intro: Thing Watcher Anomaly Detection Demo with a SimulatorKicks off a hands-on walkthrough of configuring ThingWorx Thing Watcher

This video concludes Module 9: Anomaly Detection of the ThingWorx Analytics Training videos. It gives an overview of the "Statistical Process Control (SPC) Accelerator" This video doesn't contain a required hands-on exercise. If you are interested in the accelerator, feel free to explore the accelerator by following along with this video. A team at PTC built the accelerator to expedite the process of building an SPC application inside ThingWorx. This accelerator is not a fully-developed or supported PTC product - it is a set of ThingWorx entities for the user to modify and employ as needed. If interested, download the attached "Statistical Process Control Documentation_v6.5.pdf" and "SPC 6.5 Import Package.zip". NOTE: It is recommended to import into a sandbox or non-production environment running ThingWorx 9.1.6 or later.  This video has chapters — open the chapter menu in the player to jump to any section. Chapter Summaries 0:00 – Introduction: SPC Accelerator in ThingWorx & SPC

This video begins Module 9: Anomaly Detection of the ThingWorx Analytics Training videos. It describes how Thingwatcher can be set up to monitor values streaming from connected assets, and send an alert if its behavior deviates from its 'normal' behavior. This video does not contain any hands-on exercises, and you don't need access to a running ThingWorx Analytics environment. This video has chapters — use the chapter menu in the player to jump to any section. Chapter Summaries 0:00 – Introduction: ThingWorx Analytics Module 9 – Anomaly Detection, Thing Watcher & SPCKicks off Module 9 with a roadmap covering the ThingWorx Analytics Thing Watcher feature, a hands-on alert configuration exercise, statistical process control (SPC) concepts, and how the SPC accelerator jump-starts building an SPC application. 0:32 – ThingWorx Analytics Server: Builder, Manager & Codeless Model BuildingExplains that the ThingWorx Analytics Server powers predictive signals, profiles, machine learning

This video concludes Module 8: Time Series Modeling of the ThingWorx Analytics Training videos.  It contains a hands-on exercise, and it is recommended to complete it before moving on to subsequent sections. In this exercise you are shown how to train a time series model and interpret the performance metrics. Download and use the attached "gas_prices.csv", This video has chapters — use the chapter menu in the player to jump to any section. Chapter Summaries0:00 – Getting Started: Navigate to the ThingWorx Analytics Data SectionKicks off the walkthrough by opening ThingWorx Analytics and using the left-side Analytics icon to reach the Data area where datasets are created and managed. 0:16 – Create a Dataset: Upload US Gas Prices CSV & Enable Time Series DataShows how to create a new dataset (named "US Gas Prices"), attach the source CSV with Choose File, uncheck the upload-metadata option, tick the Time Series Data box, and Submit so ThingWorx Analytics infers the metadata. 0:55 – C