IoT & Connectivity

Hello, I am using ThingWorx 9.3.9.I was wondering if there was a method to get data from a infotable, and separate each of the columns in an property. In my case, I have three columns, id, temperature, and force, and I want to separate these into three different properties in a Thing. I have written a service in a Thing that has 4 properties, 3 of which are numbers and the last one being an infotable. This is my service code that I tried to use to pull one row of information from the infotable:   let infoTable = me.MyCSVProperty; let searchCriteria = { "id" : 2 }; let foundRow = infoTable.Find(searchCriteria); if (foundRow!== null) { let id = foundRow.getValue(0); if (id!== null && id!== undefined) { me.id = id; } else { me.id = -1; // Set to -1 to indicate an error } } else { me.id = 4; }   and when i run this program i get an error: Any help would be greatly appreciated!Additionally, I am new to coding and thingworx so detailed explanation

Network adapter is not shown. So getting BAD in client file.    Following action also done but still not showing it. Start the server_config.exe as Administrator Go to KEPServerEX 6\server_config.exe > right click Properties > Compatibility > Change Settings for all users > Run this program as administrator > Enable.     Please suggest what to do for Quality as good in client file 

Has anyone tried connecting to the A/B Powermonitor 5000?  The Rockwell manual says we can configure RSLinx as a SLC5/03 as it supports PCCC addressing.  I tried SLC5/05 in KepwareEX and this didn't work.  Neither did the PLC-5 family,  Thanks        

Hi,Does KEPServerEX support integrity with any hardware security module? 

Hey Community, here i want data from three different datatables and i want to have all the entries in one infotable. How can i achieve it? i think i need to have here infotable and collect all the data there... let data; linesArray.forEach(line => { logger.info("QControl."+line.lineName+"-"+line.lineLocation+".DT"); let thingName = "QControl."+line.lineName+"-"+line.lineLocation+".DT"; let maxItems = Things[thingName].GetDataTableEntryCount(); data = Things[thingName].GetDataTableEntries({ maxItems: maxItems /* NUMBER */ }); });  

For one of the customers, we are working on application development where Snowflake DB data (Power bi View tables) need to be inserted in postgres through ThingWorx schedular but while doing so ThingWorx Apache Tomcat went down.  We are handling here around 22 lac rows to insert it in database. While doing so we are experiencing this. Please help us to improve this. Is there other way to insert this many rows from snowflake DB to postgres without affecting ThingWorx performance?

Hello,  I am reading Channel.Device.System*_Error tag via OPC DA Client of the SCADA. I am able to read tags of the device but can't read the _Error tag and quality is bad, whenever I restart the kepserver computer.After started the quick client I can see the tag quality is good.Why this is happen? Thank you in advance.

How to start userextension properties in alphabetical order

So I'm tasked with resurrecting neglected OPC connections and I'm encountering a situation where i have to use a custom interface design XML file with KepServerEX 5.12.140.0 to specify tags from Sartorius AMBR systems. I'm also encountering an issue where the OPC UA Configuration Manager that came with KepServerEX 5.12.140.0 seems to be creating a bad URI that can't be parsed by newer software because it puts whitespace in the URI string?'C:\Program Files (x86)\Kepware\KEPServerEX 5\plugins\connection_sharing.dll'. Reason: 'Connection sharing plug-in failed to load due to lack of driver support.'am also encountering the following error "Unable to load plug-in DLL  Wondering if an upgrade to 6.5 will solve my problems or if i need a more expansive license key or if i should be looking at Kepware Server instead: if there's a driver OOB for KepServerEX if i just get a different license type that will allow me to use drivers and not just a CID XML file. Or if I upgrade

Good day, everyone I am trying to print my webpage/mashup, (an image just for now).Following this article guide: https://www.ptc.com/en/support/article/CS319138I wrote the below in a service and I invoke this service on a button click with the hopes of getting the print page to open up (Like how it would when you press Ctrl+P).This isn't working. Is there something I am missing? The code: let table = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({infoTableName: "InfoTable",dataShapeName: "dataShape_DS"});let html = "window.open('http://xx.xx.co/:port/Thingworx/MediaEntities/Icon'); html.print()";table.AddRow({htmlColumn:html});result = table.htmlColumn;

I have configured DPM equipment. using  https://www.ptc.com/en/support/article/CS371476   this linkBut I cannot select the WorkCentre showing some error. Kindly check attached  image.I have also checked https://support.ptc.com/help/digital_performance_management/r9.5/en/index.html#page/dpm/digital_performance_management/production_dashboard/production_blocks.html# Please guide

Hello,   What is the difference between thingworx and thingworx naviagte. I am working on thingworx but thingworxnavigate is also a platform or how does it works. Would anyone clear my confusion please

In thingworx navigate UI, how to upload the files directly from windchill rather than uploading from local drive.

Why the Display Name stated in State definition file is not shown accordingly for value with boolean base type? please refer the screen shotversion: ThingWorx 9.3.7-b1432  

Hi Community,   We have trying to enable SSO on Thingworx using ADFS as IDP. We followed steps suggested in this link - Configuring Authentication with AD FS (ptc.com)   When we enable SSO on Thingworx, we are getting below error      2024-06-29 04:54:29.694+0000 [L: INFO] [O: o.s.s.s.l.SAMLDefaultLogger] [I: ] [U: ???] [S: ] [P: ] [T: https-openssl-nio-443-exec-8] AuthNResponse;FAILURE;<<IP>>;<<RELYING_PARTY>>;https://<<ADFS HOST >>/adfs/services/trust;;;org.opensaml.common.SAMLException: Response has invalid status code urn:oasis:names:tc:SAML:2.0:status:Responder, status message is null__ at org.springframework.security.saml.websso.WebSSOProfileConsumerImpl.processAuthenticationResponse     Could someone help me to solve this issue   /VR

When creating a button with only an icon/ image displayed on it I find that the icon can only be enlarged to so far before it exceeds some allowable area.With a blank label the icon, sized here to 100x100 pixels, becomes cropped. With a label the icon is properly sized.Is there a way to get image only buttons to have their icons properly sized without this cropping?

var data = me.Data; //InfoTable var result;result = "<!DOCTYPE html><html><head></head><body>" +"<table style='width: 100%; border-collapse: collapse;'>" +"<thead>" +"<tr>" +"<th style='border: 1px solid black; color: white; padding: 8px; text-align: center; background-color: #005495;'>Column 1</th>" +"<th style='border: 1px solid black; color: white; padding: 8px; text-align: center; background-color: #005495;'>Column 2</th>" +"<th style='border: 1px solid black; color: white; padding: 8px; text-align: center; background-color: #005495;'>Column 3</th>" +"</tr>" +"</thead>" +"<tbody>";// Iterate over the rows of the InfoTablefor (var i = 0; i < data.rows.length; i++) {var row = data.rows[i];result += "<tr>";// Iterate over each column in the rowfor (var key in row) {var value = row[key];result += "<td style='border: 1px solid black; padding: 8px; text-align: center;'&g

If my KepServerEx V6 instance has two separate network connections to a pair of EN4TR com cards in a CLX rack,  This is to give me redundant com paths to the critical systems. Is there a way to configure them in a redundant\failover architecture within KepServerEx? I know this can be done with an external router but I was hoping there was a native solution.  

Greetings, I know nothing about kepware, other than it gets data from my PLCs for me.  i dont setup the topics, i pretty much never get on the server.  not my job. However, i am having trouble getting info from an oracle database, after having what i think i needed installed on the server.  There were some OPCDB addons or something like that, as well as upgrading oracle on the server from v12 to 18 maybe?  I got the user and password from our IT folks. I can connect to and see the columns i want to pull the data from, however when i try to actually pull data, i get the error attached.  i asked our IT folks and they said i had the correct login info to read from the oracle database and they suggested i get on here... I program PLCs, so i may not understand what you say, but hopefully i can show it to someone who will know what to do with it

Hello,I am involved in a project requiring integration between our MES system and an ECU, where the primary communication challenge is interfacing via CAN Bus. Our objective is to supply test criteria to the ECU and capture the results directly into the MES system VIA KEPServerEX 6.Given our constraints, we are considering using gateways that can convert CAN Bus protocols (CAN 2.0a/b and CAN/J1939) to more common protocols like TCP, UDP, or OPC UA. I am concerned about the reliability of these gateways, especially since many are from lesser-known vendors with limited reviews.Does anyone have experience with such setups, particularly with CAN/J1939 to TCP or UDP conversions? Are there specific gateway brands or models you would recommend? Additionally, there are mentions of MODBUS to CAN Bus conversions in some threads, but details are scarce. Can anyone shed more light on this option?Any insights, experiences, or recommendations on gateway configurations and best practices would be gre

Hello everyone,I am trying to use Kepware Ex Datalogger with FloatArray type.I have selected all items from the device into datalog configuration in Narrow Table Format. When I trigger my DataLog, It only logs data for tags other than Array type tags and I get below error in Kepware. "Error Data Logger Plug-in Unable to query recordset on Log Group 'DataLog_abc_Profile'. Reason: String data, right truncation" I have not configured individual elements of Array type tags rather I have selected direct tags' name in datalog items. Is my configuration OK or I will need to configure individual element for data logging?

Hi i get a strange error in my thingworx setup. i have an SQLconnector which calls different stored procedures, that is then used in different mashups. i am now getting the following error on one of those services that calls a stored procedure from SQL:[message: Execution error in service script [GET_ProdOrder_Next_onEquipmentID] :: New request is not allowed to start because it should come with valid transaction descriptor.]this works for most user but not all about 5 out of 16 can not get the result from the service.thanks for your help in advance.

Hi all,   I want to create this very simple logic... Disable a button for 3 seconds after clicked then enable again. It seems that this program has a way of making very simple logic ... complex for me.Can anyone explain how this very basic feature can be implemented.

Hi Community,   Could anyone tell me how to specify config.json file path while running edge microserver in CMD   Thanks, VR

Hello, I'm new to thingworx. Working with version 9.1I'm trying to create a service that aims to clean up the rows of an infotable-type property following a certain logic.This service cycles through a set of things and for each one it clones the "alarms" infotable property with  var newAlarms = Resources["InfoTableFunctions"].Clone({ t: alarms, }); newAlarms.RemoveAllRows();  it verifies if any of the rows present within the property is missing within a stream. Otherwise it applies  newAlarms.AddRow(alarm);  (where alarm is equal to the row index inside the loop) if any rows have been removed in this process, the value of the cloned infotable is associated to the alarms property   thing.alarms = newAlarms;  The service seems to work, the alarm is removed, but it seems like the infotable gets corrupted after the modification. From composer I see that the property has rows inside it, but if I click to view the content a pr