IoT & Connectivity

Hi,   I am exploring the rest apis and java sdk apis for ThingWorx 8.5. I want to fetch the metadata of a Thing. I can do the same via REST api - <server/Thingworx/Things/{thing_name}. It returns json that contains all the services listed under key serviceMappings with their implementation under key serviceImplementations -     But the parallel java api on ConnectedThingClient getThing(<name>).getMetadata() returns _serviceDefinitionCollection and _serviceProcessors as null.  Am I missing anything here? How can I fetch the metadata for the Things' services ?   Update : Java sdk version latest - 6.1.0.679, ThingWorx Foundation version - 8.5

Hi All   I'm wondering if anyone has a solution for connecting a single instance of Kepware to two Thingworx environments ? One Dev and one Test. I have read that you can only directly connect 1:1 , but i wondered if any intermediary applications or servers have been used to split the data between Thingworx instances by anyone else .   Thanks

Hello, So I have a table in my DB which stores data along with start and end date and time(datatype is datetime). Now, I have defined two inputs to my service which is a query to select certain data where start time and end time are inputs. the baseType is datetime. When i enter the values, im getting the result as no data, but I have given the exact date and time as in the db table.

Hello,    I was wondering if Microsoft Visual C++ 2008 is required for Thingworx to run. I'm being asked to uninstall it because it has been obsoleted, but I just want to make sure that uninstalling it will not break Thingworx.   Thanks

Hi Team,   I am trying to connect to Hive tables from ThingWorx using the JDBC connection. Connection details, JDBC Driver Class Name : org.apache.hive.jdbc.HiveDriver JDBC Connection String : jdbc:hive2://<server name>/default;transportMode=http;ssl=true;httpPath=/hive2 connectionValidationString : SELECT CURRENT_DATE Database User Name : <username> Database Password : <password>   Error in Application log, Unable to Invoke Service Test on AzureDevJDBCConnectionThing : null Error Getting Tables : Cannot get a connection, pool error Unable to validate object     Appreciate if you an help me to resolve this issue.   Note:  I am able to connect to hive tables using dbvisualizer tool from my system.    

My  THINGWORX 8.5 trial version is offend getting very slow.Not at all able to load and open the composer.If i restart the Tomcat also it is not loading the composer .Can u please provide me the issue.

Let say I want to model a Car. For this I create a CarTemplate. And for the wheels, I create a WheelThingShape with 2 properties (wear% and pressure). How should I link the WheelThingShape to the CarTemplate in order to achieve a final CarThing with 4 wheels, and 8 properties liked to wheels?

The SelectedRowsChanged event is launched even if the selected row is not changed from a grid, but just after a refresh of the service returning the data.   This is what happen (note thantI switched from TWX 8.2 to 8.5):   I have a mashup with a service returning an infotable. I put this data into a grid, and here it is possible to select a row   I also have a refresh widget that calls every 30 seconds the service, just to to update values   Now I select a row, and correctly SelectedRowsChanged  is launched. After some time when the refresh widget triggers and launch the service, I also get the SelectedRowsChanged event, even if I didn't changed it from the grid. It happen with both classic grid and also grid advanced. With TWX 8.2 this was not happening.    Can this be fixed without doing other tricks ?    

 Hello,I created new mashup. I am using time series widget.  i ca able to view the data in time series chart. But i can't able to get the graph.. Can u please help me to do that? I attached my screenshot below.

Hi,   We are observing below issue frequently in Thingworx. 1. Data is not updating to Remote thing properties. After restart thing, updating the data to properties. We are using .Net SDK(Edge) to get the sensors data into Thingworx. Data is getting into edge correctly but not updating to Remote thing.   Any one have idea what is the reason data is not updating to Thing properties. After restart thing, updating the data correctly.   Thanks You.   Regards, Latha

Hi,   I tried to use JDBC Connector extension in Thingworx to connect to an external MSSQL server (to read data into Thingworx) via Windows Authentication (Integrated Security = SSPI). On the configuration section, I have tried append the connection string with "Integrated Security = SSPI" and leaving the username and password as blank, but it didnt help.   JDBC Driver Class Name: com.microsoft.sqlserver.jdbc.SQLServerDriver JDBC Connection string: jdbc:sqlserver://localhost;databaseName=AdventureWorks2012;Integrated Security=SSPI connectionValidationString: SELECT GETDATE()   Anyone can shed some light on how to connect via Windows Authentication in JDBC Connector?    *Have tried using MSSQL Relational Database Connector and still could not get it work.

I have a service returns string "Alarm"/ "Healthy"/ "Error". I want to display these string and change color based on state.   I made a state definition and binded service result to value display - data.   Now, I open "ValueFormat" but don't know how to assign state definition. How to do it? My TWX version is 8.5.0   Thanks.  

Thingworx Analytics is offered through the User interface called Analytics Builder with some pre-configured functionality. However, should you want to create your own jobs and mashups, all features from Analytics Builder and some more are available through the Thingworx Services.  Running most functionality requires that you provide some data to run the Analytics Services. This is where the datasetRef parameter is required.        Data uploaded through Analytics Builder Any dataset uploaded through builder will require have a datasetUri as shown in the image above and format will be parquet (all small letters) datasetUri can be obtained from the list of datasets in builder Passing data as an in-body Dataset If data isn't uploaded through Analytics Builder, data can be supplied as an Infotable in the data parameter of the datasetRef. Metadata will also need to be supplied if a new dataset is being created (create Job of the AnalyticsServer_DataThing) If this

Hi, Is it possible to navigate to a page when we click on particular cell in a grid?  I have three columns which has 3 images in it. On click of one image in one particular cell I wanted to navigate to specific page. Likewise, when I click on 2nd image in another column, I want to navigate to its respective page.  How can I achieve this using grid advanced widget?   Thanks, svisveswaraiya.

Hi,   Is it possible using datafilter widget on grid which shows data from SQL database , where Datashape is not defined. how we can use Datafilter widget in this scenario .   Thanks  

How might I go about deleting all items in a datatable by timestamp? Say over a year old? I am not seeing timestamp as a parameter of the DeleteDataTableEntriesWithQuery snippet.

Hello,   I installed manufacturing apps trial and import simulation data succesfully and I did 2 guides about manufacturing apps, Controls and Asset advisor but now I have a problem because Kepware is connected with Thingworx but I can't see data simulation in my assets. I checked log and I saw this error:   An Invalid Property Value Was Sent To [PTC.MfgSegment.Kepware_Simulator-GW Property: [StoredUpdateCount]     Do you know how to solve this issue?   Thank  you in advance   Luis    

Hi All,   I would like to ask about Collection (or repeater) widget. I want to do a checklist with questions and answers. I created a database what contains the questions,at the moment I have 11.  After that I created a mashup what displays all of questions. The mashup contains 2 labels and 1 radio button . I want to display all questions ,radio buttons, and I want to store the answers according to question numbers.   I tried to display all questions, but it display only the first row How can I solve this problem, and how can I collect the answers? Can this be done with a repeater or collection widget? I tried it with grid, but I read on forum, I can not embed widgets within the cells.   Thank you in advance.    

IntroductionOracle 12c release introduced the concept of multi-tenant architecture for housing several databases running as service under a single database, I'll try to address the connectivity and required configuration to connect to one of the Pluggable database running in the multi-tenant architecture.Multi-tenant database architecture in scope of ThingWorx External Data SourceWhat is multi-tenant Database architecture ?Running multiple databases under a single database installation. Oracle 12c allows user to create one database called Container Database (CDB) and then spawn several databases called Pluggable Databases (PDB) running as services under it.Why use multi-tenant architecture?Such a setup allows users to spawn a new PDB as and when needed with limited resource requirements, easily administer several PDBs just by administering the container database - since all the PDBs are contained within a single database's tablespace structure, start and stop individual PDB leading to

Exciting news! ThingWorx now has improved support for Docker containers to help you manage CI/CD, improve development efficiency in your organization and save costs. Check out these FAQs below and, as always, reach out to me if you have any additional questions.   Stay connected, Kaya   FAQs: ThingWorx Docker Containers   What are Docker Containers? From Docker.com: “a Docker container image is a lightweight, standalone, executable package of software that includes everything needed to run an application: code, runtime, system tools, system libraries and settings”. Learn more here.   What's the difference between Docker containers and VMs? Containers are an abstraction at the app layer that packages code and dependencies together, whereas Virtual Machines (VMs) are an abstraction of physical hardware turning one server into many servers. Here are some great discussions on it on Stack Overflow.Containers vs. VMs   How can I build ThingWorx Docker

Hello all,   How to center align Grid Header and Value using style theme   /VR

Hi,   I am building an application up on manufacturing app by adding extra tails and have also done some configuring changes. Now i want to transfer this development on another instance, how do i export the complete Application? - I tried export option in Manufacturing and imported in another instance, didn't work.  - I wanted to export the Manufacturing App project from the composer, but was suggested that it won't work.   - Instead i was told to export tag wise in the composer to cover all the entities of my project.        1)  I maintained same tag name to all my extra development, which can be exported.        2) And for Manufacturing App ,there is a common tag name using which i can export.                       I am not able to determine this common tag, there are tags with various vocabulary  names.    How do i export my project (with M

We have two instances of Kepware, one Kepware is connected to DST machines, the other one is more of a central server which gets machine data in OPC UA from third party apps and feeds data to Apps for analysis. both the Kepware instances can be connected via OPC UA connection. But is there any PTC recommended way to do this?

Hi, is there any limitation of number of Advanced Tags in KepServerEx ?   Thanks

Hi, We have deployed thingworx in client place and often in logs we are getting, (CONNECTION) Server WebSocket CLOSED [session id: c149, reason: CloseReason: code [1006], reason [The WebSocket session [c149] timeout expired]]   Why does this occur and what impact does it have in the performance of thingworx?   Thanks, svisveswaraiya