ThingWorx

Hello Everyone, I had few question related to service execution and associated subsystem 1. Does anyone know if Datatable related services (like Add, Update, Delete) etc are handled through 'Stream Processing Subsystem' ? I do see a separate subsystem for valuestream but there is nothing specific to Datatable so I was wondering if the services are queued for processing (when multiple threads are trying to access the same data table) using Stream Processing Subsystem ?   2. The other question I had was with respect multithreading ! When Thing service (same or different) is called from an external system using REST api, will Thingworx spin up a new thread for each call ? Please clarify, 3. Also which subsystem handles the execution of thing services ? Are they executed innediately or queued based on active threads and other parameters? 4. Finally is there a way to monitor what threads are active in memory ? which processes are taking long time than usual etc ?   Appreciate

I want each cell of one entire column in a grid to have drop-downs, so that the user can select the value from the drop-down when the table is editable. Is it possible to achieve this functionality using any of the grid widgets (grid, advanced grid ..etc ) in Thingworx? What should i do to implement this functionality?

Hello, I am creating an external Thingworx widget, and am passing a Thingname (string) as a property of widget. Now inside widget I would like to call the generic services like 'GetBooleanPropertyValue' or 'GetIntegerPropertyValue' or for that matter any other custom service that I have defined in that Thing (Thing is created in composer). I am not able to figure out a way to do so. What I have realised is , we have something like ..'TW.Runtime..' using which we can do so. for ex, if I need to access current session information I use something like 'TW.Runtime.Session.SetSessionValue'. Also there is one more function, 'TW.IDE.getThingInfo' regrading which I am not able to find any details.   Another part to my question is , do we have any standard documentation/guide which provides information on list of Js functions like TW.Runtime or TW.IDE ... I referred to https://community.ptc.com/t5/ThingWorx-Developers/Where-can-I-get-a-list-of-all-Thingworx-s-Js-function/td-

Hi, Whenever a datashape is created from a sql query it becomes static. If I make any changes in the query like adding a new column or removing I have to again create a new datashape. But is it possible that the datashape becomes dynamic and adjusts according to the query whenever it is changed?   Thanks, Shalini V.

Hi,   i have many Things with "Database" as Thing Template and i would like to make a service which sets the password to the database automatically (on running the service).  i looked into the snippets and found nothing so i thought it might be a security policy.   is it possible? Thanks 🙂

Does anyone know if there is an Event that is triggered upon server startup?  I want to send the admins an email when the server boots in case of unexpected reboot.  

I need to know how the thread works in ThingWorx, how the server gets busy and hoe does the internal queue process the threads later, for the application and when is contented to a DB. 

How to export data table entries directly to Excel file rather than .CSV file without using data export extension tool?

Hello All, I created datatable contains 2 primary key(col1, col2).I insert 2 records("a","bc")("ab", "c") into the table, but auto generated key field conflicts and updated(not insert). How can I insert these two records in that datatable?    

Hi,I need to retrieve data from JSON and store in datatable. JSON is having a multiple tags. Please refer a below JSON data. Please let me know if anyone have a solution for it. Thanks in advance. {"PhoneLocationList": {"PhoneLocation": [{   "PhoneNo": "1234567890",   "Status": "Success",   "Location":    {      "latitude": 50.3,      "longitude": 20.2,      "altitude": 3000,      "accuracy": 60,      "timestamp": "2013-06-24T10:50:57.000+0530"   }}]}}Thanks and Regards,Vaibhav Sharma

Hi,   I would like to know how to refresh mashup data on the hour (E.g 1pm, 2pm, 3pm, etc), instead of refreshing after an hour once the page has loaded. I have tried using the Auto refresh widget and time selector widget but that sets the start time to when the page loads, not according to a set time. If anyone out there has tried this, and it worked for them, please let us know.   Thanks

Hello Team,   Currently developing an extension to get connectionId from hub using SignalR in java.   When importing the extension in thingworx it is showing following error   Import Failed: io/reactivex/SingleSource   Included following library implementation 'com.microsoft.signalr:signalr:1.0.0' Since getting error tried adding compile group: 'io.reactivex', name: 'rxjava', version: '1.3.1'   but still no luck getting the same import failed error as above.   Any help  will be appreciated    Thanks, Vijay5  

Hi Team,   from today morning, not able to login to thingworx composer, after giving the credentials its still asking for the user name and password.   i have not changed the credentials.

We're using ThingWorx 8.2 and our developers are complaining that the Composer web UI is very slow, even on relatively fast computers. I tested this myself and it was fast until about 30 minutes into editing mashups, when it becomes quite slow (often eventually taking 1-2 seconds to click a button, sometimes more).   I see that Chrome memory usage is very high and the web app itself seems very inefficient. I see that a potentially big problem with ThingWorx - as it keeps our developers from being productive. We tested on a MacBook Pro with 16GB memory (both Chrome, Safari), a Macbook Air, and also a powerful Windows PC with 64GB of memory in 3 different browsers including IE.  In all cases, it turned out ThingWorx Composer eventually gets slow.   It is of course driving our developers mad.  Is there a remedy for this - or is it just that ThingWorx web interface is old and clunky by nature?

I am a iOS developer and i use this iOS SDK on marketplace to connect our Thingworx server.I user our host,post.apikey to connect,it failted.But when i use Java SDK to connect,it could be successed. The Xcode output log told me,that the server is in a recycle loop connection. The iOS SDK version is version.major=1 version.minor=1 version.revision=0 version.build=98.Xcode version is 10.1 my code is : TWXSecurityClaims * securityClaims = [TWXSecurityClaims securityClaimsWithAppKey:kDefaultApiKey]; TWXClientConfigurator *clientConfig = [TWXClientConfigurator clientConfiguratorWithHost:kDefaultHost hostPort:kDefaultPort securityClaims:securityClaims isAutoReconnectEnabled:YES]; clientConfig.isSelfSignedCertificatesAllowed = NO; NSError *err = [ThingWorx initializeWithConfigurator:clientConfig]; err = [[ThingWorx connectedThingClient] connect]; log is: : [ERROR] Error intializing SSL connection Jan 7 11:04:28 WebSocketTest[8416] : [ERROR] twWs_Connect: Error restarting socket. Error 0 Jan 7

Hello, I have  a thing "ptc-windchill-demo-thing" which is imported /created at time of Navigate Installation process. Their is a service in that Thing   , named as GetPartByNumber.   I just created another thing just like "ptc-windchill-demo-thing" and created a service same as "GetPartByNumber". When I run the service I get error as: JSON Server error HTTP 404   The JS code in service is : var numbers = {}; //To be used to get cost data ERPvar result = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({    infoTableName: "InfoTable",    dataShapeName: "ptc-part-demo-shape"});if (number) {    occurrencePathFilter = occurrencePathFilter? occurrencePathFilter : occurrencePathFilterFromTree;var dataShapeFields = result.dataShape.fields;var properties = '';for (var fieldName in dataShapeFields) {    properties += ',' + fieldName;}properties = properties.replace(/--/g, ".");var selectedTypeId =

Hello all, I have installed thingworx 8.3 trail pack. it frequently stopped its functionality.  i checked the log. it shows java heap space increased. also it shows 1018 db error.   can anyone kindly help me to solve this issue.   Thanks  Sugumar

I'm using Axeda Platform 6.6 and when I tried to add  DownloadInstruction to Software Package and create or update the package with V2 API SoftwarePackageBridge I received the error: An unexpected error has occurred. If you continue to receive this error please contact support and report the event   Some other instruction like RestartAgentInstruction added successfully.   What can  be a reason of such behavior? Best regards, Vadim Duchovny, Senior Software Engineer

Hi,       Is it possible to use AMChart or google chart in Thingworx?  ThanksHema

Hi,   I am using automated script for pingfederate , after configured my thingworx and windchill.When starting thingworx , I got the following error:   2019-01-04 14:32:14.579+0800 [L: ERROR] [O: o.o.s.m.p.SignatureValidationFilter] [I: ] [U: ] [S: ] [T: Metadata-reload] Signature trust establishment failed for metadata entry tom.wcserver.com 2019-01-04 14:32:14.579+0800 [L: ERROR] [O: o.o.s.m.p.AbstractReloadingMetadataProvider] [I: ] [U: ] [S: ] [T: Metadata-reload] Error filtering metadata from D:\THINGW~1\THINGW~2\SSOSEC~1\PF_IDP_metadata.xml 2019-01-04 14:32:14.579+0800 [L: ERROR] [O: o.o.s.m.p.AbstractReloadingMetadataProvider] [I: ] [U: ] [S: ] [T: Metadata-reload] Error occurred while attempting to refresh metadata from 'D:\THINGW~1\THINGW~2\SSOSEC~1\PF_IDP_metadata.xml' 2019-01-04 14:32:14.594+0800 [L: ERROR] [O: o.o.s.m.p.AbstractMetadataProvider] [I: ] [U: ] [S: ] [T: Metadata-reload] Metadata provider failed to properly initialize, fail-fast=true, halting tom.wcse

Hello, I am  fetching a WTPart / CAD document from windchill . Now I want to save the image/thumbnail/.drw drawing  on local system. I want to provide a option i.e button to user to download that image in pdf format.     How can I achive this?    

1. Import Extensions2. Select File  3. Widgets PrintButton Drag & Drop4. chart parent panel name to printbutton UnitName Copy4. View Mashup5. print button Click View

Hi,   I am looking for a demonstration of ThingWorx prescriptive analysis. Could you please share any related information?

Hi, I followed the step before the installation recommended    by the guide but the installation has ended with this post-installation error(look the photo). after i read the log file and there were not all the components of descriptive service. I don't know the reason of this. Someone has some advice?   

Hi,   My TW Connector crashes after a while. This is the error I get: # There is insufficient memory for the Java Runtime Environment to continue. # Native memory allocation (mmap) failed to map 12288 bytes for committing reserved memory. # An error report file with more information is saved as: # /opt/Thingworx-Azure-IoT-Hub-Connector-2.0.0.141/connector/bin/hs_err_pid15517.log # [ timer expired, abort... ] Aborted (core dumped)   At first site this looks like a memory lead for me. The Connector runs on a VM (7GB Memory) and I think the resources should be enough for a dev env. I have connected just one agent and there is not much stress on the Connector.    Are there are any Java settings recommended for running the Azure Connector?   Thanks