ThingWorx

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 @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,

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

  We have to upgrade Thingworx 8.5.1 to 9.3.x. Tools: Thingworx Installer - 8.5.1  Java - jdk1.8.0_171 PostgreSQL - 10   Trying to simulate in test environment. While installing Thingworx 8.5.1 getting following error,   Logs:   [2022-12-23T02:44:22-08:00] INFO: windows_service[ThingWorx-Foundation] configured. [2022-12-23T02:45:23-08:00] ERROR: Running exception handlers [2022-12-23T02:45:23-08:00] ERROR: Exception handlers complete [2022-12-23T02:45:23-08:00] FATAL: Stacktrace dumped to c:/progra~2/thingw~1.1/installer/foundation/local-mode-cache/cache/chef-stacktrace.out [2022-12-23T02:45:23-08:00] FATAL: Please provide the contents of the stacktrace.out file if you file a bug report [2022-12-23T02:45:23-08:00] FATAL: Chef::Exceptions::MultipleFailures: Multiple failures occurred: * Timeout::Error occurred in delayed notification: Timeout::Error * Timeout::Error occurred in delayed notification: Timeout::Error    Attached logs from C:\Program

I'm trying to get Thingworx to issue a schedule to restart a client PC. Is this possible either through the client or as a Javascript set of commands?Thanks

Hi, I do have a few Entities tagged with the tag Applications: Sprint1; how can I get all the Entities under that Tag in a Service output to have an Info table?Thanks,

Hey guys,     I have list of documents(link) coming from windchil and want to download all at once to a folder and need to zip it.   suggestion please     Thanks  

Good day community, I have a connected device represented by a thing. There is a property on the thing called: last connection. I am representing this thing using a label and an icon on the mashup side. This icon should change to a green color when the device is connected and then switch to a red color when the device is offline. How do I go about writing a dynamic service to accomplish this?Many thanks,  

Hi Developers,I'd like to get your support on CSS part.I'm try to hide the disclosure button in the value display widget with custom css, however it doesnt work.Could you tell me how we can hide the button ?our thingworx env is "ThingWorx 9.2.6-b366". 

After installing the Thingworx Analytics Extension, the Analytics tab is not showing up in Composer although the Analytics Server Things do show up and are 'connected'.Details:We have a Thingworx Foundation cluster (3 nodes) running Thingworx 9.3.0 on RHEL.We just finished installing Thingworx Analytics Server 9.3.0 on a separate RHEL node.  As part of the Server installation, we set it to install the Analytics Extension in Foundation.  It gave us a message that the extension was queued for install on the next platform restart. Since it's a cluster, we weren't sure whether that meant to restart just one of the nodes, all of them individually, or all of them at the same time.  So we tried all three of these methods.  We also tried installing the extension directly in Composer.  The Analytics tab for Analytics Builder/Manager still doesn't show up in Composer.  Any ideas on what we may have missed?

Is there any way to send multiple outputs from the single service at a set of intervals?  for ex:  I have an HTML snippet to display images using the HTML text area widget. In my case, I have a list of image URLs in an array to display. My intention after invoking the service user should see all the images, each image should stay on the screen for 2 seconds.  unfortunately, the HTMLTextArea widget is not taking a script from the HTML code.

var query2 = {"filters":{"type": "OR","filters": [{"type": "NE",fieldName: "name",value:"ConsolidatedInfoFiles"},{"type": "NE",fieldName: "name",value:"Health Summary"},{"type": "NE",fieldName: "name",value:"Shiftwise Melt Consumption"},{"type": "NE",fieldName: "name",value:"Shiftwise Energy Consumption"}]}};var params1 = {t: infoIT /* INFOTABLE */,query: query2 /* QUERY */};var result = Resources["InfoTableFunctions"].Query(params1);

Hi Experts,   I have a very specific requirement to highlight certain bars in a Bar Chart without changing original colors of the bars.   Current scenario: Data infotable is bound to Chart and chart adjusts and displays bars according to the data value with different color for all bars.   Expected: Data infotable has 2 values beyond threshold and chart should highlight those 2 bars in red color and rest of the bars should remain in original(different) colors.   Tried and didn't work: Applied state formatting with a threshold value which turns all the bars meeting condition in red color and rest of them in another single color. Attached is the screenshot of the same.     Example: Display top 2 fruits bars in red which has highest sales i.e. Banana and Pear.    

I need to read the SciptLog file from Thingworx to check the activities of a particular process. Is it possible to read the ScriptLog content from Thingworx ?ThanksDimitri