ThingWorx

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 -    I'm working on a solution to transfer data between a PLC and MSSQL Database using KEPServerEX. I was able to implement the push (data from PLC being transferred to the MSSQL DB ) using the ODBC client and writing to a stored procedure.   However, I'm having issues with pulling the data to KEPServerEX with a parameter (i.e. ID). I would like to call a stored procedure or function with the parameter 'id' to limit the result set to a single row from the SQL Server.   I've attempted the data pull on a test database with a stored procedure (returning no results), a function (also returning no results), a query that selects from the function (which returns results, but no parameter), and several other attempts only to reach a dead end.   Wondering if anyone has experience with the ODBC client driver that may have found a solution to this. The simplest way would be to have an input tag used in the query and do something like: SELECT * FROM ufn_GetDevices(&nbs

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

Hi, Greetings!                  I do have a tree structure like Plant --> Module --> Area etc. I want to display all the modules from the selected plant (selected from dropdown) in a rectangular box so that on module click it will show underlying areas(rectangular box with text).                 I have tried repeater widget with shape widget but shape widget showing only first value from data service. I want to display all the values with separate rectangular boxes. Could you please help me. Thanks.      

I am trying to run code provide from https://developer.thingworx.com/en/resources/guides/thingworx-java-sdk-tutorial   put threads are executing repeatedly, no error occures. I have not provided  Thingworx username and password in my code. I had only set appKey , which i created from Thingworx composer Application key.     After executing i get Logs as shown in file.