IoT & Connectivity

Hi everybody,   I have installed the tuneller KEPServerEX 6 version 6.5.829.0 and a weeks ago we are experimenting interruptions in the transmision of the data.    I track the problem in the windows event viewers and I found this errors:     Log Name: ApplicationSource: Application ErrorDate: 9/26/2023 12:16:47 AMEvent ID: 1000Task Category: (100)Level: ErrorKeywords: ClassicUser: N/AComputer: OPC_SVRDescription:Faulting application name: server_runtime.exe, version: 6.5.829.0, time stamp: 0x5b22a6cfFaulting module name: ge_ethernet_global_data.dll, version: 6.5.829.0, time stamp: 0x5b22a6dfException code: 0xc0000005Fault offset: 0x000245e8Faulting process id: 0xa48Faulting application start time: 0x01d9efa794a04a0aFaulting application path: C:\Program Files (x86)\Kepware\KEPServerEX 6\server_runtime.exeFaulting module path: C:\Program Files (x86)\Kepware\KEPServerEX 6\drivers\ge_ethernet_global_data.dllReport Id: c70f0f78-fd9b-4a8f-9cf8-92e647f4b643   Thi

Hi all,   When I try to access the Mashup Runtime using a non-administrator account, I get the below error message     I tried following the article    Article - CS289125 - Error getting IR status in Application logs when non-admin users try to access Thingworx Mashups during runtime (ptc.com)   Setting Permissions for Integration Connector Activities (ptc.com)   Still, I'm getting an error   Could someone help me with this    Thanks in advance   /VR  

Hi, I have one property for which I log data for every second in valuestream. I want to display last 3month data from valuestream on time series chart. What is approach I need to use?I am new to Thingworx. Please help.

While fetching data from sql db in thingworx , this query executing for morethan 80 seconds. Any idea on simplifying this query? Query:SELECT distinct a.cmp , a.engseq , a.it, null as COUNTFROM ENGINEERING a WHERE a.MODEL like 'R24R%' AND a.cmp not in ( select cmp from ENGINEERINGwhere MODEL like 'R23R%' ) ;

Dear Community,yet another question for you; regarding the Beckhoff TwinCat driver;I only want to import OPC Variables which I have marked/commented in TwinCat.I commented them as intented for the OPC-Import:(*~ (OPC:1:available for OPC Clients)(OPC_PROP[0005] : 1 : read only)*)Unfortunately, when I import the device with"Respect OPC Read/Write Item Properties", "Respect Tag Case On Import" and "Only Import Variables Marked for OPC" enabled no tags at all are created.Why? Am I doing something wrong? I do not have any additional filters configured.Thanks in advance for your help.Kind regards,Kepware User  

I need to make a SQL query in Thingworx. The query should read (if I were creating it directly): SELECT * FROM MyDB.MyTable where Name like '%Name_Input%'   Another PTC forum post had recommended this as a possible solution: SELECT * FROM MyDB.MyTable where Name like '%' || [[Name_Input]] || '%'   But this query (above) does not work. The post was from the year 2014 and I'm currently using 8.4.1, so I'm guessing that's the issue.....   Solutions anyone?

I am currently attempting to install an instance of ThingWorx 9.0.3 and I have been having trouble with building the docker images with PostgresSQL as far as I can tell there is no issues with the version numbers. however when I run the build.sh Script it always errors out  with the error: ERROR: failed to solve: process "/bin/sh -c echo 'hosts: files mdns4_minimal [NOTFOUND=return] dns mdns4' >> /etc/nsswitch.conf && adduser --uid 1337 --disabled-password --gecos \"\" --home \"/home/${APP_USER}\" \"${APP_USER}\" && apt-get update && apt-get dist-upgrade -y && apt-get install -y --no-install-recommends wget ca-certificates gnupg && rm -rf /var/lib/apt/lists/* && wget -O /usr/local/bin/gosu \"https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-amd64\" && wget -O /usr/local/bin/gosu.asc \"https://github.com/tianon/gosu/releases/download/$GOSU_VERSION/gosu-amd64.asc\" && export GNUPGHOME=\"$(mk

We fetched 5000 rows and 4 columns from sql db in 40seconds.Then In Thingworx code, if i used InfoTable.length to find total number of rows in table is taking additional 20seconds. Any other shortcut to get table length quickly.?Query:SELECT distinct a.cmp , a.engseq , a.it,  null as totalrowsFROM ENGINEERING a WHERE a.MODEL like 'R24R%' AND a.cmp not in ( select cmp from ENGINEERINGwhere MODEL like 'R23R%' ) ;  

Upgrading TWX foundation server 8.5 to 9.4 hosted customer by PTC Cloud Services.We have following two approaches,1. Install a fresh instance on the PTC cloud and upgrade 8.5 to 9.42. Upgrade existing Dev environment on PTC cloud and upgrade 8.5 to 9.4In the existing environment, IOT devices are connected with thingworx.Which approach is good for upgrade?  

Dear Kepserver,I'm enounter problem in data logger with error Date Time Level Source Event02/10/2023 09:34:49 Error Data Logger Plug-in Unable to query recordset on Log Group 'Glass_Data'. Reason: sp_cursor: The value of the parameter 'value' is invalid. I check the value which generated default and only rename the " value name " and not for the data type. can you help me which can cause error? 

Hi, my name is Ben Lau, the Project Engineer from a System Integrator in Hong Kong. I would like to communicate with the Johnson Controls NAE and Schneider SmartX controllers through BACnet I/P driver of your KEPSeverEX software. However, I have difficulties in configuration details: When attempting automatic tag generation for a node under Schneider SmartX Controller, the diagnostics window displayed completed status (only built-in tags generated by KEPServer BACnet I/P driver is available) but the following two warnings:"Error reading segmentation supported from remote device. Segmentation will not be supported.""Error reading object list from device. | Class = '1 (Object)', Code = '31 (Unknown Object)'." When attempting automatic tag generation for Johnson Controls NAE Controller, the diagnostics window displayed "Unable to generate a tag database for (Device Name). The device is not responding.".Please refer to the attached screenshots for current BACnet I/P settings for

I have a dropdown widget that populates data after a service run. This all works fine. If I set the "SelectedText" to be one of those values, it works as it should. However, once I change this to a "MultiSelect", the "SelectedText" no longer works. Does anyone have a workaround for this? I am in version 9.0 and cannot upgrade.  

ERROR [widget] "CustomCSS" widget type is missing required member widgetProperties() ERROR [widget] An error occurred while loading widget "kohlerqrscan" [{}] ERROR [widget] "kohlerplotlychartingkit" widget type is missing required member renderHtml() Please find the attached extension and help me figure out the above errors.

hello, I have a linechart where  the margins on left and right side is to big (X-axis), I would like to fill all the available space .On the attached image I marked the space what I would like to 'cut' somehow. Because the x axis is date type and it's variable I cannot set itXAxisMinimumValues and YAxisMinimumValues parameters.(I using ThingWorx 9.1.5-b698) any idea is welcome. thank you    

As per this topic:   Hello all,    I have the similar study but my first plc is control logic  (see the screenshot). I still not able to define the device ID. can you please help?

Hi,I am currently trying to develop a service that should generate a number consisting of a date shorened to yymmddhhmm. When writing the bellow code in javascript (nodejs)const date = new Date();console.log("SSNDate: "+date.toLocaleString("sv-SE", { timeZone: "Europe/Stockholm" }).slice(2).replace(/\s|\.|:|-/g,"")); I get230929090129 With this code:dateFormat(date, "YYMMDDHHmm") I get 23092720756 I would also like my code to take locale and timeZone into account, how is that done? Calling new Date, I get what I understand looks like a unix timestamp: 1695974346423 To summarize:- How to format a date according to YYMMDDHHmmss?- How to take a certain timezone into account?- What is date returning?- How to take timeZone and locale into account, rhinos implementation does not seem to do it the standard way with toLocaleString.- What dateStrings can be used with dateFormat, and how to check that?RegardsOskar Berntorp    

Hi, i am using KEPServerEX 6, connected to Mitsubishi PLCs through Mitsubishi Ethernet Driver, Q Series Model. Total there are 5 connections with the same configurations and settings, and 4 are communicating fine. However for the remaining 1 PLC, i am able to ping to the IP address of the plc, but when i run the OPC Quick Client, i am getting Bad for Quality and Unknown for Value. However, occasionally i am able to get good quality with proper values from the plc. I would like to know how should i go about troubleshooting it, thank you.    

Hi Developers,I'm trying to create the following functions.1. save image file to SQL as binary data.2. pull binary data from SQL.3. create Image contents from the binary data to display on mashup. I'm struggling to create codes for part 3.Could anyone help me for the part3?    

Hello, i'am trying to add the value of a property to the Value column of a infotable located in the same thing as the properties i want to use. I have the name of every property in string format and since there are around 200 of them i wanted to use this to add them. example: myArr = [{Name: 'Tag1', Message: 'Hello', Type: 'BOOLEAN'}, {Name: 'Tag2', Message: 'Sweet', Type: 'BOOLEAN'}]   me.myInfo.AddRow(       {        Name: myArr[0].Name        Message: myArr[0].Message        Status: me.myArr[0].Name //This part dont work. I Have a property with that exact name and i want the status for that property      }   how can i reffrence the tag with the string i have? Or another smarter way to refrence it? In my program im planning to use a for loop to go over every tag one at the time.      

Shall we add subcolumns for each field definition in infotable

{"data": [{"usageId": "50030540014333322800000050","assetFound": true,"compartments": {"rows": [{"compartmentId": "50030540014333322800000052","observableProperties": {"gatewayLocationDescription": "Ireland","temperature": 6,"timestamp": 1612393200000},"compartmentUsage": {"compartmentState": "Inuse","minTemperatureThreshold": 2.2}},{"compartmentId": "50030540014333322800000051","observableProperties": {"gatewayLocationDescription": "Belgium","temperature": 2,"timestamp": 1612220400000},"compartmentUsage": {"compartmentState": "Idle"}}],"dataShape": {"fieldDefinitions": {"compartmentId": {"name": "compartmentId","aspects": {"isPrimaryKey": false},"description": "","baseType": "STRING","ordinal": 1},"observableProperties": {"name": "observableProperties","aspects": {"isPrimaryKey": false},"description": "","baseType": "JSON","ordinal": 3},"compartmentUsage": {"name": "compartmentUsage","aspects": {"isPrimaryKey": false},"description": "","baseType": "JSON","ordinal": 2}}}}}],"message":

I'm having problems troubleshooting an SLC5/05 tag syntax.  I am using Open Addressing and both of my OPC UA utilities required imported tags.  Any tools or utilities I can use? 

We are having a following services to get/search/query the data table data. Which service is more efficient? GetDataTableEntriesSearchDataTableEntriesQueryDataTableEntries 

hi, allNow I'm working with Thingworx 9.2.0.I create ex1Thig and add ex1Infotable property defined by ex1Datashpe includes LOCATION base type field to show the location on the Google Map Widget as below.The location field is available at the setting default value in INFOTABLE.But the location field in not available in edit value in INFOTABLE because the location column is missing, Why?Thanks. 1 ex1Datashape 2 ex1Thing 3 ex1Infotable -> default value -> all columns are available. 4 ex1InfoTable -> value setting --> no location field!          

I'm trying to push an empty child infotable to a field (of basetype : infotable) in parent infotable var InvalidAssets = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({infoTableName: "InfoTable",dataShapeName: "ChildInfotable.DS"});var output = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({infoTableName: "InfoTable",dataShapeName: "ParentInfotable.DS"});var message = "Please enter name";output.AddRow({"InvalidAssets" : InvalidAssets, //infotable"StatusMessage" : message //string});var result = output; attached is the output I'm seeing... but I would like to have empty infotable in the "InvalidAssets" feild as I'm trying to bind the child infotable from the output of the service to a grid in mashup.