ThingWorx

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.  

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.    

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

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

Hi,  I have to run a task for every one minute from 8:00 a.m to 4:00 p.m Monday to saturday. How to do this? 

We are creating a IoT deployment based on the MQTT protocol, which will be the only source of incoming data.Is there a sample deployment architecture for Thingworx protocol adapter toolkit (PAT) with MQTT channel and MQTT broker which is scalable? The target number of devices to be supported on the Thingworx platform is ~25k.

Hey hey Community, I have following scenario. I have Thingworx Foundation 8.5 (Trial), Imported MQTT Extension and have already created a, new thing called "VerneMQconnect", as MQTT Connect,new thing called "VerneMQsubscribe", as MQTT Subscriber But the Problem is that the VerneMQconnect always show "Disconnected" and "isConnected" never turn "True" it's always "False".  There is no firewall issue or somthing like that. I have tested the MQTT Broker in different ways ant it always worked without problems. Except in Thingworx, here it doesn't even manage to connect to the Broker. The Error Log schows:

I have Thingworx 8.4 installed on a Windows server machine and it looks works fine. But I noticed some services stopped. I have attached the screen shot with these services. Can anyone help explain if this is acceptable?

Hello, I want to create state definition for my shape. but I am only be to define only two types. Please refer the following image. I want to define a style for a range of values. Eg - Green for 1, red for 0 and yellow for  greater than 2

Hi,   My question is about Manufacturing Apps and the possibilities to be configured to monitor lines, machines, KPIs, etc. of multiple factories with differente group of users.   In our case, the intent is to use Manufacturing Apps to monitor different lines, machines, and KPIs from different factories. Each factory is going to have its own users, and once the users are logged, they only should see the lines, machines and KPIs that are configured for their factory, so they shouldn't have access information from other factories. Each factory should have its look & feel (logos, colours, etc.) which is going to be different for each factory.   Can we do it using Manufacturing Apps?   Thanks.   Olatz

can u pls help me that how to integrate chatbot in thingworx?

Hi, Thingworx version (8.4.4), chartwidget 3.0.3 1- I'd like to change the labelangle but it's not working for me     2- Another thing in view mashup instead of showing mashup name as title I'm seeing the complete address, as you can see in the second picture.   Thank You! Naeem