IoT & Connectivity

Hello community,Is there a way to check what the real error is in KEPServerEX for SQL diagnostics? This doesn't help at all:Date Time Level Source Event12/08/2024 16:39:18 Error Data Logger Plug-in Unknown error while executing query in table 'mytable' for log group 'datalog-azure'. I am guessing it's something about security/privileges since I am trying to log data in an Azure database.I am able to see tables, columns when I am mapping the data but unable to write values to table.Using app version 6.16 (V6.16.203.0)  Any help is appreciated. Cheers, 

Hi,   I have changed the port to 80 in the server.xml:   When I looked into the Catalina.out, I get the below error:   Does anyone know the solution?   Thanks,

In TWX 8.5, it was possible to enable sorting for all fields in advanced grid widget without enabling it for each field. In TWX 9.5, the new grid widget requires the sort functionality to be enabled individually for each field in grid configuration. Is there a way to make all fields sortable without enabling it individually for each field in grid configuration?

Dear PTC,We are in the process of planning an AM deployment. The purpose of this discussion is to gain a comprehensive understanding and documentation of the capabilities of PinkFederate and ADFS, as well as the differences between the two.Background Information:We configure an Windchill to Denodo connection on our network utilizing PinkFederate and OAuth2.We seek your expertise in determining the most suitable approach between PinkFederate and ADFS for our requirements and can we do the same setup using ADFS.Thank you for your assistance.

I am trying to configure Datalogger and keep running into issues in the configuration. I have created my DSN correctly and it successfully passed the connection test. But whenever I try to select the table name, the dropdown list does not show any of the tables in my database. I attached a screenshot of what shows up in the dropdown. 

var lastMinDate = new Date();lastMinDate.setSeconds(0);lastMinDate.setMilliseconds(0);var result= lastMinDate;

Hi, I'm Refsam Maulana, a technician who is working using the kepware applicationI have a question about kepware, related to OPC DA Client on a domain system. How to make computers that have different IP scopes, but in one domain to be read on the client's computer? Or is there a way to add servers manually instead of choosing from the Microsoft network?Me and my coworkers still haven't figured out how to read the servers on computers that have different ip scopes but in the same domain.    Hoping to get a solution 

Hi, I am using a date picker widget on a popup  on ThingWorx 9.5, for some reason when I select a data from the calendar, the pop-up closes automatically. Is it a known bug? and is there any work around? Thanks in advance.

I'm currently installing Thingworx server on linux.While installing the database i notices the following: 6. Configure pgAdmin:$ sudo pgadmin4◦ In pgAdmin, click on file->Open postgresql.conf◦ Open /etc/postgresql/x.x/main/postgresql.conf◦ Put a check next to listen addresses and port. The default settings of localhost and 5432 are usually sufficient.◦ Save and close.◦ Click on file->Open pg_hba.conf◦ Open /etc/postgresql/x.x/main/pg_hba.conf◦ Double-click on the database ‘all’ line with address 127.0.0.1/32◦ Set Method to md5◦ Click OK◦ Save and exit◦ Close pgAdmin(Sorry i'm unable to quote!!) I'm not happy that MD5 is used for Hashing. MD5 is not a really secure algoritm anymore and i would like to use Sha-2 (what is current default) if possible! Is this possible? if Not Why...More info on MD5:https://security.stackexchange.com/questions/19906/is-md5-considered-insecure https://www.freecodecamp.org/news/md5-vs-sha-1-vs-sha-2-which-is-the-most-secure-encryption-hash-an

Good morning, I have a problem connecting to some OPC UA Clients.Sometimes I get this warning:Warning OPC UA Client XYZ.B&R | Read request failed on device. | Status description = 'The operation timed out.', Status code = 0X800A0000.When it happens some tags are in 'Unknown' quality and until I force a synchronous write the status cannot return to "Good" status. I tried to change "Asynchronous Reqst Timeout", but increasing it immediately returns the value to the default of "1000". Let me know please.Thank you.Regards

Hi Everyone,I have a grid data of 1000's row now I want split data into different pages using pagination widget please help me to write logic and implementation as I am new to thingworx so not much idea on it Thanks and Regards,Lavkush.

I am working on a solution that involves creating tags using the Kepware Configuration API. I have been able to find documentation for and create normal tags, but I can't seem to find any information on how to create Advanced Tags using the API. I have looked through the Advanced Tags help guide as well as the Kepware Server help guide but it doesn't have any documentation on how to create advanced tags using the API (unless I am missing it somehow). Can anyone confirm if advanced tags can be created from the API and if so is there documentation on how to construct the API call? If anyone could point me in the right direction that would be greatly appreciated, thanks!

I have upgraded KepServerEx.V5 to V.6. It can communicate with ControlLogix before upgrading. After upgrading to V.6. 

Hi all, Fairly short question, but is there a way to get all tags among all tag groups on a kepware device using the configuration API? I am finding that I need to be specific in my API calls and specify the tag group, but I'd like to be able to get all of the tags for the device in one call. Thanks!

Lately I have been working with some UI widgets extensions. It seemed to be a repetitive task to do the initial developments, version it, deploy , look for bugs and repeat. So I thought of develop an Eclipse IDE plugin (As is the primary IDE supported for extensions development), which can automatically increase the path number of the extension, build it and upload to a target Thingworx server, preferably Development. Attached is the jar file of the plugin that you can use with eclipse. If interested you can follow the following steps and try it out,1. Download the .jar file and put it into drop-ins folder of your eclipse IDENow restart the Eclipse IDE, Once restarted you will see a new icon in the toolbar of your IDE, You can now use the plugin, on click of this the following download would appear, In the dialog, select the extension project, set the server address, and add an appKey with Admin level access, don not forget to click on Update TWX details. That would store the

I am using ThingWorx Platform Release 9.2 and DatecodeSP6Hi,Regarding the case Article - CS250386, to update element in the Configuration table of a Thing by custom script service, we should enable and restart the Thing after calling SetConfigurationTable. This documentation is available for Thingworx until 8.4. Is it really what we have to do to update the Thing Configuration? We didn't find anythhing about that in the documentation.What about the next version (9.2 -> 9.5)?

Hi,  I am trying to use the validation inputs for a text box widget. If I manually set these parameters then it works as intended and looks like this:  But if I try to bind validation functions to these parameters for when the text box has a comma, then it simply doesn't work. I have already verified that my service is working correctly and is bound to the properties correctly, but for some reason it just doesn't work when I bind it over on validation. Any ideas? 

var date = new Date();for (let index = 0; index < 12; index++) {    let startDate = new Date(date);    startDate.setHours(18 + index, 0, 0);        let endDate = new Date(date);    endDate.setHours(18 + index + 1, 0, 0);        console.log("StartDate " + startDate);    console.log("EndDate " + endDate);}

Hi,i have installed Kepware EX demo . I am planning to connect Postgres Db with Kepware to store the data in DB.can anyone help me out with the steps in connecting Postgres DB with Kepware .

Hi all, I have a line chart widget that I want to remove the markers from only one line on a multi-line line chart as such:I want the grey and red dots gone since these are just limits, but to leave the purple ones. I have found a way to remove all the dots and a way to change the size of all the dots but no way to only change some of them. Note: I have many dots on the limit lines instead of just the endpoints of the time range because when trying to use the zoom feature, the chart the lines disappear unless there is data within the zoom time range, so I found this to be the best solution if I can get the dots removed.

Hi all, I am trying to zoom into a line chart that has limit lines made: I want to be able to see these limit lines still if I zoom into the image, but they disappear even if I keep them in the zoom range:Any tips on how to get this line to stay even after zooming?

Im having trouble making the mashupcontainer the same size as the container im placing it, tried to solve with css but no luck, anyone know how to make so mashupcontainer has the same size as container?

Hi Team,   What SQL Commands can be used to Change the Collation/COLLATE of the MS SQL SB?   Thanks,

Hi all, I am experiencing some weird behavior with querying property history from the influx DB in thingworx. I am querying several properties at the same time within a time range, some of these are numeric and some are boolean. For the numeric ones I am getting good correct data, but for some of the boolean values the query shows no history and has it as blank. However, the booleans when queried individually show property history and have been flipping between true and false consistently.  I am not sure why this is occurring exactly since the properties have good history but it doesn't show when querying several properties. (I am doing one bigger query because I have a lot of properties that need to be queried in my service). Any feedback is appreciated!

Hello I would like to increase the time of status message that comes on thingworx. Currently it stays for little time and i want to increase that . Is there a way to do it? Thingworx version is 9.4 Thanks