IoT & Connectivity

Why does using a NUMBER type attribute to create an alert cause an error?

I am using ThingWorx Platform Release 9.2 and DatecodeSP2Hi Team, We are facing issue while exporting the grid data into csv format in one of the production site and we have seen that service output results are correct format, however it is not in correct format in csv. we have attached the screenshots of service output,region settings and csv format, please investigate this issue and assist us further on this case.Here are the errors that I facedIncorrect csv format

In RTPPM 10.0 the OEE gets calculated at Work Unit Level but when I check the OEE at the Work Center level in KPI Dashboard or reports it shows 0. Any suggestion if I have missed any configurations?

Hi, I have a scenario where in Thingworx mashup there is a text field it should allow only integer. Other than that any text entered it should show "Please enter integer value". How to achieve this?Thningworx version 9.6Can anyone help on this. 

I am trying to send a file to an AWS S3 bucket via an API call.  I am able to send the file when I use Postman, but I am unable to send it via Content Loader Functions.  I am assuming my configurations may be incorrect.   When I send the file through Postman, I do the following: select PUT as the method paste the URL into the request URL (this automatically populates the parameters under Params tab) under the binary tab, select binary and the file to upload click on the Send button The following is my service to send the file via Content Loader Functions: // Content: BLOB var Content = Things["SystemRepository"].LoadBinary({ path: "/directory/subDirectory/someFile.csv" /* STRING */ }); // result: BLOB var result = Resources["ContentLoaderFunctions"].PutBinary({ proxyScheme: undefined /* STRING */, headers: undefined /* JSON */, ignoreSSLErrors: undefined /* BOOLEAN */, useNTLM: undefined /* BOOLEAN */, workstation: undefined /* STRING */, useProxy: undefined /*

 I’m facing a database connectivity / connection pool checkout timeout issue during ThingWorx Foundation startup against AWS RDS PostgreSQL 16.6. ThingWorx goes into ERROR state even though database connectivity works from other clients.EnvironmentThingWorx Foundation: 9.7OS: Ubuntu 22.04Database: AWS RDS PostgreSQL 16.6App Server: Tomcat 9.0.113Java: Amazon Corretto 11.0.29Path: /usr/lib/jvm/java-11-amazon-correttoError Seen (Startup)ThingWorx fails on startup and sets the web app state to ERROR:  *** CRITICAL ERROR ON STARTUP: An attempt by a client to checkout a Connection has timed out. *** Web Application STATE is being set to ERROR! *** This looks like the ThingWorx DB pool is unable to checkout a connection within the timeout (pool exhausted / blocked / cannot create new connections).Important ObservationFrom the same EC2 instance, I can connect successfully using terminal tools (psql style connectivity).I can also connect successfully using pgAdmin.So networ

Hi Community,We are decommissioning ThingWorx and have performed the following steps:Ran uninstall.exe, which removed the ThingWorx services and installation foldersDeleted the ThingWorx database from PostgreSQLCan you please confirm if these two steps are sufficient to completely remove ThingWorx?Additionally, are there any other folders, files, or configurations (e.g., storage directories, environment variables, logs) that should be manually removed to ensure a clean uninstall?Thanks in advance for your guidance.

I'm experiencing an issue following a ThingWorx upgrade via the ThingWorx Foundation Installer for PostgreSQL. The labels for the newly added debugger feature are missing. Can anyone confirm if they're seeing the same problem? 

Hello, I need to upload activation request file to repair my broken license.But i can't login to my kepware account in myKepware.It just keeps loading and loading..."we have made changes to My kepware. Please log in again"

I am using ptcs-grid with multi-row selection enabled.The first row in my grid is a “Total” (summary) row, added through a service.I do not want this row to be selectable, and it should also be excluded when “Select All” is used.Since CSS solutions only hide the checkbox visually (and do not affect selection logic), I would like to know:What are the supported alternatives or best practices to handle this scenario? how the Data is looking on grid i am here attaching the screenshot.from this screenshot i want to Hide the Checkbox for the 1st row whose department="Total"

Hi,We are planning to upgrade ThingWorx 9.3.5 + CWC 3.1.0 to version 10.1.The OS user who originally installed ThingWorx is no longer with the company.Is there an official workaround to allow a new user to run the upgrade installer? or are we forced to perform a manual upgrade? Best Regards,Tomer.

Python which got installed during API installation is 3.10 and having vulnerabilities.We need to upgrade Python, will it support? if not then can we just upgrade API.Whole Kepware Application version upgrade supposed to be last option for us.

Hello community,I would like to know if it's possible to create a nested condition formula using a Derived Tag in Advanced Tags in KEPServerEX. Something "Condition ? Value_if_True : Value_if_False"The idea is to retrieve certain tag based on a tag value, for example:plc1secuence == 1 ? plc2tag1 : plc1secuence == 2 ? plc3tag1 : -1 Tried using IIF statement as well but it doesn't like it either... Looking forward to hear from you.Cheers,

Hello, I've been facing an issue for quite a long time. I have a GE VersaMax CPUE05 PLC connected to my PC by Ethernet. I configured it in KEPServerEX 6, the driver I used is GE Ethernet and it works great just like that. But the problem comes when i connect to the server in factory i/o.There is a big latency of about 2/3 seconds when it comes to tags update. I read the threads here about latency but none of them helped me. Scan mode and maximum bytes per request don't change the delay, it is still there. I have about 160 variables most of them which are boolean. The only thing i noticed is low amount of good reads (at least i think so) compared to writes. You can see the good reads after the first 10 seconds of simulation on the screen.The problem I also noticed is even if there were 3 variables in the project there was still a tiny lag when it comes to the variable update. Could this be the VersaMax Ethernet port? It is only 10Mb/s.  

Hello Kepware CommunityI am currently tinkering with the KepServerEX capabilities and have come across some unusual behavior. My task is to connect the Kepware to an MQTT server, retrieve the payload, and parse it into SQL. Everything goes smoothly if I use Kepware's default logging, which has 4 fields: numeric_id, quality, time_stamp, and value.It is ok when use a Narrow table format setting, which I set it as follows.And it return this sql tableNow I have a custom table that need to be fillAnd my column(s) set up, they have the same column registerThe logger is up and running, no error log but it does not log anything to the table.Which setting that I need to change ? Many thanks in advance. Have a great day.Best regardsTran Duc Thinh  

I have set up a simulator tag that receives its value from the link advance tag. The input of the link advance tag is the value from the ADAM READ-only Register address, and the output of the link advance tag is the simulator tag value. I have configured the link tag as the on interval mode, so that after every 100ms, link tag writes whatever the value is at the register address to the simulator tag. but the question is, even if the value is same after 100ms, is the update counter on the OPC client side should update its value or not ..?

I have a Prosoft PLX51-DF1-ENI card connected to a PLC5 via  a DF1 serial cable. I need to get a Factorytalk SCADA and Kepware to communicate to the PLC. Kepware is required to allow comms to an old historian. When Kepware is disabled the Factroytalk SCADA can communicate to the PLC OK. But once Kepware is enabled the Factorytalk comms start to fail.. In Kepware I am using the Allen Bradley Ethernet Driver and the tags show good values. I have the tag scan rates set to 1000ms. It seems like to Kepware connection is overloading the DF1 comms. Is there anything I can try to get this to work 

Warning OPC UA Client OPCUA_Hydraulic_Shop | Reconnecting server due to connection loss.

I am developing an application using OPC DA, but my client wants us to upgrade to OPC UA. The problem is that when the HMI reads the tag structure, it is different. With OPC DA my structure uses dots (.) to separate the path, and in OPC UA it uses backslashes (\) to separate the path. This has never happened to me before. Could you help me?

Hi,How would you use an Emergency ID in a disaster recovery scenario? For example, let's say you lose access to the server where Kepware was installed but have backups of the project available and have re-installed it on another server... seeking clarification on how you would handle the Emergency ID and Activation ID in this scenario.Also, is the Emergency ID available for re-use an unlimited number of times so long as it is reset and the original Activation ID is still active?

Hi all, Many of you I think attended the What's new in TW10 webinar yesterday.The debugger in particular looked like something we have been asking for a long time, which is very good news.I have been trying TW10 since june but have not experienced any good usefulness with the debugger.Even though I placed several breakpoints in the code most of the time it does not break there. Is there a difference if you place them in JS functions or outside? Shouldn't be?The information shown in the Variable section is most of the time useless. It shows 'com.thingworx.types' for instance on InfoTables.80% of our mashups are showing grids of InfoTables. These tables are populated from parsing Windchill REST services JSON data, and this would be EXTREMELY useful so use the debugger for this.What am I missing? Anyone else found the debugger useful? If so, care to explain? BR,Roger

Hi Community,I’m using ThingWorx 10.0.0 and working with high-frequency properties named property1 and property2 that update very often.If these are marked as Logged = TRUE, they generate a large amount of history data and can impact system performance.Proposed ApproachBefore I implement anything, this is the strategy I’m considering to log values only every X minutes:1. Keep original properties unlogged (Logged = FALSE).2. Create separate periodic properties (Logged = TRUE, DataChange = ALWAYS).3. Use a Timer to write values to these periodic properties every X minutes:me.property1_periodic = me.property1; me.property2 = me.property2;This would store history only at fixed intervals instead of every update.Looking for SuggestionsIs this a good approach?Are there any built-in features or alternative strategies for periodic logging that I should consider before implementing this?I’d appreciate any recommendations or best practices from the community.

When I upload a file, it shows the file below with an "x" to remove the file as well. However, I need to remove this "x" because there is no bindable event to removing an item. Instead, I have a button to clear the items which then triggers some other services.  How do I remove the "x" button from this widget as shown below? Thingworx 9.6 

I am trying to create a custom tooltip for the line chart. I have the custom tooltip working except my dynamic data are returning as N/A in the tooltip. My datashape for the chart data are as follows:xaxis: stringyaxis: numberlineLabel: string My custom localization token value is as follows:${label} #newline# ${Data:lineLabel}: ${value} How do I get the lineLabel value to show here ${Data:lineLabel}? I am using the syntax provided by PTC docs link here...https://support.ptc.com/help/thingworx/platform/r9.6/en/index.html#page/ThingWorx/Help/Mashup_Builder/Widgets/CreatingCustomChartTooltips.html  

Hello Community, I am trying to find a way to monitor or check the amount of triggers the DB thing is creating and whether that is contributing to the performance of the ThingWorx due to load getting created on the SQL server from where I am getting data.I am aware of the C3P0 thread count which can be used to monitor the DB connections, but that is specific to the default persistence provider. I am fetching data from multiple DBs using MS SQL DB Thing connectors.I want to know if there is any way we can monitor the queue size and active connections.So, in the DB Thing Configuration tab, the JDBC connection settings has an option of Maximum Number of Connections which is set to 5 and there's also an option to enable monitoring. But I am trying to understand how I can do the monitoring even if it is enabled.Also, how to monitor the active connections out of the maximum 5 and the requests or the queue size to the DB thing at a regular interval. Please refer to the below referen