IoT & Connectivity

Hi Everyone,   I have a Grid widget which displays data based on selected dropdown, also a data filter widget through which I am filtering grid data so now my requirement is I want to display distinct count of each column in Bar chart widget and  once the data is changed it through data filter widget (for the same dropdown)   bar chart data should also change like whatever data present in grid that data's distinct count should available in bar chart at runtime.   like in runtime if data change according to the filter (Through data filter widget) that should also change the bar chart count that's it. can we achieve this functionality in Thing Worx 9.3.1 version.   if yes pls guide    I am able to get distinct count in bar chart but next is how it should change while filtering which is in runtime actually, I am not sure    Thanks, Lav

 Hello,I am experiencing issues while trying to connect to an OPC UA server using KEPServer. Below are the errors I encountered in the logs:  Date Time Level Source Event 11.12.2024 14:56:46 Warning OPC UA Client OPC UA CLIENT | Socket error occurred connecting. | Error = 10060, Details = 'A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.'. 11.12.2024 14:56:46 Error OPC UA Client OPC UA CLIENT | Channel failed to connect. | Status description = 'Could not establish a network connection to remote server.', Status code = 0X80AC0000. Additional Information:Server Address: opc.tcp://10.20.20.113:4840Username: orecifua1Password: (Provided during setup)Network: I have multiple network adapters and I am trying to ensure the connection uses the correct adapter.Despite ensuring the server is reachable via ping, the OPC UA client fails to estab

how to do basic authentication through REST API in thingworx without passing user name and password in Header

How to add spellcheck in editable string column of grid

Hello, I'm trying to read the tag values from CSV file to KEPServerEX Channel/Device. The reading is basically working and I can see the tag values which are written in CSV.But here comes a problem: When I want to update values in CSV I get an error that the CSV file is locked. How can I change the tags valeus in CSV to get new values in the KEPServer EX? BRTomaz  

Hello, I want to select in a dropdown from a list users list ( I have already do this ) , but after add in the second list the user, I want to make sure in the list I can't add second time same user.  I can do this from Mashup or I need to create a service that compare the users from this two list and create another infotable?  Thank you in advance. 

Hello,I want to add information from Mashup and I want to have an ID incremental from Mashup that is start from 1.I try to find something but anything use some service. I have some services already and I don't want to do this incremental from service, I want to do it from Mashup. Thank you.

Hello, Where can I change the default value of the "messageChunkSize" parameter on the server side? Thanks.

Have service where I receive infotable, and show it in grid.One of column is STATUS, with integer values to present OK/NOK, maybe different in future.Style for whole row is set acc. STATUS column, so if there is 2 (which means NOK), whole row is described in red.Is there also a way (configurable via mashup, style definitions, etc.), to display NOK instead of 2, OK instead of 1, etc.? Or the only way is to change it inside service? 

What’s the best way to cache data in ThingWorx?Should I use properties, configuration tables, or user sessions (of course user session is valid only for user)?Are there other options available? If the value changes very frequently, is there a better alternative to Thing properties?If the value changes less frequently, what’s the best approach for caching?Also, can Ignite be utilized for caching in any way? I am aware that it depends on use case and scenario. I would like to know what are the feasible options available or supported by the ThingWorx platform. Thank you in Advance. -Abhiram

Is it Possible to adjust the spacing of checkbox (when multiselect is enabled) withing the grid row? Is there any property for this? If not, can this be achieved via CSS?

var users = [{ name: "Jane Doe", role: "Interior Designer", imagePath: "/Thingworx/MediaEntities/LAYOUTTESTIMAGE" },];var result ="<!DOCTYPE html>\n" +"<html>\n" +"<head>\n" +" <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n" +"</head>\n" +"<body style=\"display: flex; justify-content: center; align-items: center; flex-wrap: nowrap; height: 100vh; margin: 0; background-color: #f4f4f4; overflow-x: auto;\">\n";for (var i = 0; i < 10; i++) {result +=" <!-- Card " + (i + 1) + " -->\n" +" <div style=\"box-shadow: 0 10px 8px 0 rgba(0,0,0,0.2); display: inline-block; transition: 0.3s; width: 18%; margin: 10px; border-radius: 5px; background-color: #fff; overflow: hidden;\">\n" +" <img src=\"" + users[0].imagePath + "\" alt=\"Avatar\" style=\"width: 100%; height: auto; display: block;\">\n" +" <div style=\"padding: 16px; text-align: center;\">\n" +" <h4 style=\"margin: 0; font-size: 1.5em; color: #333;

Distributed Timer and Scheduler Execution in a ThingWorx High Availability (HA) ClusterWritten by Desheng Xu and edited by Mike Jasperson  OverviewStarting with the 9.0 release, ThingWorx supports an “active-active” high availability (or HA) configuration, with multiple nodes providing redundancy in the event of hardware failures as well as horizontal scalability for workloads that can be distributed across the cluster. In this architecture, one of the ThingWorx nodes is elected as the “singleton” (or lead) node of the cluster.  This node is responsible for managing the execution of all events triggered by timers or schedulers – they are not distributed across the cluster. This design has proved challenging for some implementations as it presents a potential for a ThingWorx application to generate imbalanced workload if complex timers and schedulers are needed. However, your ThingWorx applications can overcome this limitation, and still use timer

We cannot connected the Kepware sever to the DxP(OPC UA client) using  "Basic256 sing"But We connected the Kepware sever to the DxP(OPC UA client)successful on no security. When I turned on encryption, the following error occurred on the client side."Selected security is not found in server endpoints"Please tell me what to check. 

Hi community, I would like to ask that if anyone knows that how to iterate over the application keys which are existed in the platform without knowing anything like list of Application keys. Please let me know about itfor eg like GetKeyID(), GetExpirationDate(), ... Thanks!

I am facing issues regarding Menus not changing Contained Mashups and instead overriding the parent mashup when clicked. This issue was noticed when loading projects developed on Thingworx 9.3/9.4 onto Thingworx 9.5 (ThingWorx 9.5.4-b764). The attached project functions as intended on Thingworx 9.4 (ThingWorx 9.4.0-b49) but not on Thingworx 9.5. The menu is correctly configured (having DrivePageMashupOrBindToMashup set to "Bound to mashup parameter"). Like I said, the exact same configuration functions correctly on TW9.4 but not on TW9.5.

We are running KepServer to monitor our equipment, but we are having frequent disconnection of the system causing data monitoring loss. When we Re-Initialize KepServer, I get the below error I am not sure what to do to correct this issue  

Hello, I have a multiple PLCs in the operation lines. Each PLC has operation data from single or multiple machines. I read data from them in a single KEPServerEX. From there I am reading data in a Linux server with the help of a Python script which uses asyncua and asyncio to read data and then it stores in a postgresql database.I read data from Kepware in 1 second interval. But sometimes I lose data from any of the machines which is connected to the PLC where as data from other machines are fine. Problem is that everything will be fine for hours and suddenly we lose data from any of the machine. There is a single python script to read all data. asyncio parallel execution method is applied to read data from all machines at a time. When terminate the python code and execute it again everything becomes normal. Can you please say what could be the probable issues and how to fix that. 

Hello,I am using the Java SDK to invoke service QueryImplementingThingsOptimized  let result = ThingTemplates["LoraDeviceGenericModel"].QueryImplementingThingsOptimized( {    maxItems: 1000,}); The corresponding Java code is as follows; ValueCollection getEntityListParams = new ValueCollection();getEntityListParams.SetNumberValue("maxItems", BATCH_THINGS);getEntityListParams.SetNumberValue("offset", offset);InfoTable queryResult = thingClient.invokeService(ThingTemplates, "LoraDeviceGenericModel", "QueryImplementingThingsOptimized",getEntityListParams, TIMEOUT_30_000_MS); But this call could be optimized by using a filter on returned fields; function entityList(inarray) { let out = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({ dataShapeName: 'EntityList' }); inarray.forEach(entry => out.AddRow({ name: entry, description: entry })); return out; } let result = ThingTemplates["LoraDeviceGenericModel"].QueryImplementingThings

Can Thingworx container be closed on outside click ?

Hello, Our company's custom MES application uses an Oracle database on the backend and connects with the shopfloor PLCs using the KEPServerEX OPC server. We plan to migrate the MES application (Full-stack - database + Middleware + UI) and the OPC server machine to Oracle Cloud. Below are the existing configurations: Oracle database 12c Rel 2OPC ServerWindows Server 2019KEPServer EX 6.9.584.0Oracle Instant Client 12cOracle ODBC Driver 12cAs part of the migration, we want to upgrade the Oracle database to 19c and switch to the Oracle Autonomous Transaction Processing (ATP) database. We have set up the ODBC connection using the Oracle 12c ODBC driver and instant Client 19c (we also tried the 12c client). KEPServerEX can connect to the ATP database; it can read but not write.  Desired Future ConfigurationsOracle ATP database 19cOPC ServerWindows Server 2022KEPServer EX 6.17.240.0 (The older version 6.9.584.0 cannot even read from the Oracle database)Oracl

I am looking to evaluate multiple tags in my Advanced Derived Tag with a String output.  I would like the output to be the following machine states: "Running" or "Idle" or "Down".  Is this possible?

Good afternoon. KepServerEX V5.21 I would like to implement a periodic backup of the runtime project: is there a method to do this via the command line by running a batch script or using API calls? RegardsPaolo 

We want to send data of all the tags to iot gateway only when value for 1 of the tags changes using kepserverex 6.15 version. We've tried combinations of publishing on intervals(wide format as well as narrow format) and on data change using Every Scan and On Data Change option for each iot gateway tag. How can this be achieved using advanced tags(linked tag or derived tag) or is there any other alternative to this?

I’m planning to upgrade to a newer version of SCPA and need to migrate all my entities with the SCPA configuration. Can someone assist with the steps or provide best practices for the migration process?