IoT & Connectivity

Hi, In my production server event queue size is keep on increasing. I have extracted the stacktrace file with help of Support Tools Extension. How to analyse or find out the root cause of event queue size.   Thanks & Regards, Sathishkumar C.

Dear community,   I would like to retrieve the last x (e. g. 10) records (by id) from a DataTable. This post nearly covers my problem but Streams do not suite my data and the second solution does not work because I have an additional filter. Here is what I thought should work:   var query = { "sorts": [ { "fieldName": "MessageId", "isAscending": false } ], "filters": { "type": "EQ", "fieldName": "Direction", "value": 2 } }; var entries = Things["MESMessageLogDT"].QueryDataTableEntries({ maxItems: 10, query: query }); MESMessageLogDT is the DataTable entity and I would like to get the last 10 records matching my filter criteria (Direction = 2), this is why I cannot simply take length - x.   However, the actual result is: The first 10 records but in descending order. So apparently the sequence of data processing is filter maxitems sort while I need (and expected) filter sort maxitems   A workaround is this but the performance is poor and gets wo

Hello, I had a infotable with values separated by "," , I should split that data and insert in to a location basetype where using that location we should make a geofence on the map.   Please let me know how to split that data and insert into location base type.   find attached image for clarity.   Regards, Bhargav.

I'm querying a datatable, and passing this query (below). If I run the QueryDataTable entries with this query, it returns no results. If I just change the Station parameter to be "EQ" and just add the machine name as a string, the query works as expected (returning 40+ results).    What gives? What am I doing wrong?           var machineArray = ['my_machine_name'];   var query = {"filters": {"type": "And","filters": [{"type": "IN","fieldName": "Station","value": machineArray},{"type": "EQ","fieldName": "Program","value": Transmission},{"type": "EQ","fieldName": "Operation","value": Operation}]}};   var myQueryResults = Things["Ford.PFS.GM.Historian.Repository"].QueryDataTableEntries({maxItems: 200000 /* NUMBER */,values: undefined /* INFOTABLE */,query: query /* QUERY */,source: undefined /* STRING */,tags: undefined /* TAGS */});

Hi,   I wanted to send an email notification to users on a particular event occurrence and for that I created a Notification and then a Trigger but the problem is the trigger is not getting fired and no users are getting the email. When the same I tried to do using a Subscription then It's working but not With the Notifications and Triggers. Just check the attached images for further details.   If anyone knows about the resolution for this, please help me out.   Thank You. 

Hello Everyone,   I tried to retrieve the device id from my application.log at twxFoundationH2Trial-8.3.2\tomcat\apache-tomcat-8.5.23\ThingworxStorage\logs on my machine. Howvere I can't find the device id as stated here in ThingWorx fails to start up or starts up in limited mode due to license expiration. My free 90 day trial license for ThingWorx foundation server expired on 4th July. I have followed the above tutorial to get device_id as no licenseRequestFile.txt exists on my machine.   Also I am usinh ThingWorx version 8.3.2   Kindly suggest how should I proceed.   Regards, Aarushi  

I am trying Prescriptive analytics on Thingworx with the analytics manager. The data set that i am using is a example data set with Temperature and Vibration values. I selected the values for levers and was able to generate the above prescriptive scores. However i am confused with the above results. The goal field i select was Goal and it has 3 values: good normal and bad.    1. How does the model understand the string ('good', 'normal' and 'bad')? 2. What does it mean by the value of the scores? eg what is the meaning of 0.22221755904502294? This value seems low so does it mean it is not optimized?  

Hi,   The error is 406 Not Acceptable.   2019-09-08 18:28:17.766-0500 [L: ERROR] [O: E.c.t.w.Importer] [I: ] [U: thingworxRead] [S: ] [T: http-nio-192.168.230.139-443-exec-44] [message: Import Failed: java.lang.NullPointerException] com.thingworx.contentmanagement.ImportProcessor.processImport(ImportProcessor.java:1764) ... Wrapped by: com.thingworx.common.exceptions.ModelAccessException: [2,006] Unknown error occurred. Contact the administrator if this re-occurs.   The detail error in Error log is 2019-09-08 18:28:17.766-0500 [L: ERROR] [O: E.c.t.w.Importer] [I: ] [U: thingworxRead] [S: ] [T: http-nio-192.168.230.139-443-exec-44] [message: Import Failed: java.lang.NullPointerException] java.lang.NullPointerException: null Wrapped by: java.lang.Exception: Import Failed: java.lang.NullPointerException at com.thingworx.contentmanagement.ImportProcessor.processImport(ImportProcessor.java:1764) at com.thingworx.webservices.Importer.processImport(Importer.java:342) at

We use collection widget to show menu style row in main mashup. This essentially renders n  number of icons in the footer. This main mashup also contains contained mashup in often we have to drive the contained mashup based on some action within those contained mashups. This works fine.   However, the challenge we face is for instance if a user clicks on Menu A which loads Mashup A in contained mashup and based on some action on contained mashup A user is automatically directed to Contained mashups B. Since switch between mashup wasn't the result of manual click on the icon in the footer the selection on the collection widget falls out of sync. Which would mean in above e.g. as user was navigated  programatically to Contained mashup B from Contained Mashup A, the footer with collection widget still shows icon A as selected when actually the user is viewing mashup B which corresponds to Icon B.   I hope i didn't make it too confusing 🙂   Is there anyway we

Hi all,   I want customize my gauge as the image below:     I have the extesion "Progress Gauge" and "Gauge".   Is possible do it?

Hi, I've  added a new til in DataTable and it shows in Mfg, after following the guide in hingworx Apps Customization Guide 8.4.1 page 102.   1. TileIcon: I've made an icon for my tile under Media. It's supposed to be 80pixel high, but it filles the tile when viewed in runtime. It's a png-file. What file formats are supported?   2. TileLabel: For the Mfg Apps the tile label is a resource set in double square brackets [[PTC.SCA.SCA.....]]. I'm not able to source this resource in Twx to duplicate it. How is this handled? Please advice.  I've tried to add a ToolTip text instead, but this does not show on the Tile   3. TileDescription: as TileLabel

I am looking to make a call from within an extension widget to a service on the platform. Namely, I am looking to get the current user identity and some other tasks (which are handled by MyService) and use that internally in the widget to control certain parts of the html (such as hiding or showing buttons). So far I have referenced these two posts as well some of the SDK. I have had minor success with the ThingworxInvoker at least returning a table as opposed to the second method of using processServiceRequest (causes the widget to fail). The difficulty I am having is accessing the data in the table.    https://community.ptc.com/t5/ThingWorx-Developers/Thingworx-UI-Widget-development-calling-standard-thingworx/m-p/587862#M33332   https://community.ptc.com/t5/ThingWorx-Developers/Calling-Thingworx-Service-Using-Java-Extension-SDK/m-p/592096#M34028 My current call is like so var invoker; var success = function (invoker) { var dataFromInvoke = invoker.result; var ro

Hi,   Is there any way to shift the X-Axis labels towards left/right or move it in any way?  Any lead on this is appreciable.   Thanks in advance, MishiK

Anyone ever used OPC Alarm & Events to bring alarm information to Thingworx ? How can this be done ? Purpose is centralizing alarms from different SCADA systems (all being OPC A&E server) into one central platform, Thingworx. Can the OPC Alarm & Event information being logged into Thingworx ?

Good afternoon,    I am trying to pull some data from Azure TSI to my ThingWorx Project/Mashup. I have checked connectors and services functionalities but I don't find the way to create this connection using the available documentation.   Could you suggest an approach or methodology (step by step) about how to do it?   Open questions How can I integrate a HTTP connector into an Oauth 2.0 schema? Is there a common method of performing it? Do I have to provide bearer token myself? Or does ThingWorx provides a way to obtain it?   Thank you very and sorry for not being more specific.   Regards, Rodrigo.

Hello everyone,   I am trying to set up ThingWorx foundation server on an Azure VM. kindly suggest what kinds of VM should I look forward to .   Regards, Aarushi

Hi, I'm developing some functions with FileRepository. I'm writing some lines of text into a .txt file. I tried service of CreateTextFile & AppendToTextFile, with them all text will be written into same 1 line, no matter '/n /r \n \r' are included or not. For example, I want to show: Line 1 Line 2 Line 3 and it always shows: Line 1Line 2Line 3   Any advise?

I have an automatic login authenticator based on http parameter as described in my earlier post   I am observing a weird behavior sometimes. When the Thingworx server restarts while a mashup (which refreshes automatically at some interval) is displayed, browser sends these following URLs without the custom parameter which is required by the Custom Authenticator to authenticate: /Thingworx/Resources/RuntimeLocalizationFunctions/Services/GetEffectiveTokens /Thingworx/Subsystems/PlatformSubsystem/Services/GetAllStateDefinitions /Thingworx/Subsystems/PlatformSubsystem/Services/GetAllStyleDefinitions /Thingworx/Subsystems/PlatformSubsystem/Services/GetAllStyleThemes The issue is these URL's drop my custom parameter, which is used to identify the user to login with. As a result, a login prompt is displayed. Other times when it works, the URL with my custom parameter gets sent to the Authenticator.   How do I control this behavior? Why do these URLs get sent to the Authenticator? I

  The scenario: Your company has settled on Azure as a cloud platform and you are currently using Azure IoT Edge as your connectivity strategy. You need a quick way to build IoT applications with your Azure devices. You’re looking for industry-proven and time-saving features like Mashup visualization, built-in connectivity to enterprise systems (like SAP or Oracle) with ThingWorx Flow, secure and scalable file transfer to your Azure-connected devices and the ability to create augmented reality (AR) experiences with Vuforia Studio. All of these options are available to you thanks to the ThingWorx-Azure IoT Hub Connector; it’s like the ice cream truck driving by on a hot summer day.   (If you’re wondering why we selected Azure as our preferred infrastructure, check out my previous interview with Neal, a Worldwide ThingWorx Center of Excellence Principal Lead here at PTC.)   I sat down with Ankit, a ThingWorx Product Manager, this week to learn more about the ThingWorx-Azu

Hi All,   I would like to place a status bar in my mashup that displays the different stages/states of a machine in a particular shift. Suppose the shift is from 7AM-7PM, the machine may come across different states such as Not Ready, Ready, Running, Waiting, Fault etc. Each of the states has to be highlighted in the status bar based on the status color coding. How can it be done?   Which widget to be used to create a status bar? How to give the proper state definition for each time interval?   Please suggest a solution. Thanks in advance.   Attaching a screenshot to give a sample look of status bar.   Regards, Airin    

Hello!   I'm trying to access a URL using the ContentLoaderFunctions snippets GetJSON. The URL I am providing is functional (checked using Postman) and the api key is defined in the header correctly. The Error Log is not providing additional information than that which is provided in the title.  Can anyone help me understand what is going on here?   Thanks!

  I saw this manual. https://developer.thingworx.com/en/resources/guides/external-databases/external-database-write but Invalid column index Error confirmed.    I used two methods. SQL (Command), SQL (Query)   And I used three methods. ([[ipvalue]], [[clocksvalue]], [[tempervalue]], [[loadvalue]], [[powervalue]], SYSDATE);('[[ipvalue]]', '[[clocksvalue]]', '[[tempervalue]]', '[[loadvalue]]', '[[powervalue]]', SYSDATE);('<<ipvalue>>', '<<clocksvalue>>', '<<tempervalue>>', '<<loadvalue>>', '<<powervalue>>', SYSDATE);   The inputs data are all strings.   Configuration is not wrong. I think my method is wrong.Can you help me?

Hi. I cannot call a service over Postman/anywhere without 403 access denied. It works fine from a mashup. Guessing I have the same issue as here: https://community.ptc.com/t5/ThingWorx-Developers/REST-API-test-of-simple-service-returns-HTTP-403/td-p/526341 However the solution there, when I try to do it and save the changes I get: INVALID SCN SET https://i.imgur.com/xCRTLWa.png "You have to go to System / Subsystems / PlatformSubsystem / Configuration. Check "Allow Request Method Switch" and uncheck "Filter Content-Type"."   What could be the issue? Am I missing something?

Hello guys,   I have an external Oracle database and it's no problem to show queried information (using a service for that of course)  inside a grid in a mashup. But how do I filter the information in this grid (InfoTable)?   I would like to know how to use a DataFilter widget on an InfoTable. Could someone provide code (inside the different services) plus bindings? I found tutorials for the bindings and different code snippets but never a complete, well explained, tutorial.   Thanks in advance    

Hi all, I have created a new XY chart widget (similar to the existing XY chart widget) in ThingWorx and I want the x-axis to be on the top of the chart so that the intersection of the x-axis with the y-axis is in the top left corner instead of the bottom left corner. The x-axis values should increase from left to right and the y-axis values should increase from top to bottom. I have no idea how to do this with my code, thus I have attached the necessary files for reference. The final result should look as shown below. Any help will be greatly appreciated!