IoT & Connectivity

Hi,   I am to using TW Industrial Connectivity for connect my TAGs from PLC with TW Foundation, like the imagem below:   I have connection with the TAGs from PLC!   Now I would like to connect that TAGs with, for example, a pie chart, and when each one of my values change in the value of TAG my pie chart change too.   How I make this?   Regards. Leonardo

We are trying to import entities from 7.0 to 8.4 The persistence provider is changing but we aren't worried about the data now.   Can this be done? Appreciate your help with this! Should we go 7.0 => 8.0 => 8.4   Thanks Sabarish

Hi,I am facing same problem.Data from TWX SQL SERVICE & SQL retrieved values are not matching for one column data. Number of rows returned are same in both cases.Please share if you have any resolution... This is very critical for me.Thanks in advanceSarma

In java sdk, if I set a property more than 100 times and then call updatesubscribedproperties, lets say 200 times. I observe that only 100 values are sent to the server. I assume there must be some buffer size/ stack size which determines this depth of stack. Is there a way I can increase the "buffer" size to more than 100 ?   Thanks -Manas

Hi Community,   I tried connecting a OPC server to Thingworx using this guide and it already shows "connected: true" in Thingworx. I`m also able to bind the variables with "manage bindings", but the values are not transmitted (all are 0). On the server side the session is activated for a second but then goes over into a endless loop of "Closed by server":    [2019-05-23 10:34:44.699 (UTC+0100)] info/network TCP network layer listening on opc.tcp://raspberrypi2:4811/[2019-05-23 10:34:44.800 (UTC+0100)] info/network Connection 5 | New connection over TCP from ::1[2019-05-23 10:34:45.120 (UTC+0100)] info/channel Creating a new SecureChannel[2019-05-23 10:34:45.120 (UTC+0100)] warn/securitypolicy No PKI plugin set. Accepting all certificates[2019-05-23 10:34:45.120 (UTC+0100)] info/channel Connection 5 | SecureChannel 1 | Opened SecureChannel[2019-05-23 10:34:45.224 (UTC+0100)] info/channel Connection 5 | SecureChannel 1 | CloseSecureChannel[2019-05-23 10:34:45.225 (UTC

Navigating from one Mashup to another.   Hi All,  I am new to Thingworx Platform. I want to develop a dashboard screen where I have a dropdown list with multiple options. Options may include Machine1, Machine2, Machine3 and Other. On clicking 'Other', it should take me to another mashup where user can manually search for an asset. The 'OtherPage' mashup and dropdown list is already ready.    How can I link two mashups together so that once I click particularly on Other, it should navigate to 'OtherPage' mashup?   Kindly provide a solution. Thanks in advance.  

Hi all,    I am using following the C SDK guide: https://developer.thingworx.com/en/resources/guides/thingworx-c-sdk-tutorial/sample-code-c-sdk-tutorial   At the guide, I am trying to follow the 'ExampleClient' example (step 3). I am building the example code properly, and I establish a connection to the platform. However, when I monitor the 'thing', I see it as an 'unbound', unlike the example. I have tried using the 'Administrator' user for the application key, but it didn't help.    What am I doing wrong?   Thank you for your time

Hi,   I have a set of data coming in to thingworx from an industrial thing via opc aggregator. The data is fine in a Mashup as i can control the number of places of decimal in the mashup control... But when I send this data to vuforia, there is no control of places of decimal so I'm getting huge data values.   Is there any way to control this in thingworx to control places of decimal at the "industrial thing" level?   Thanks, Paul. 

@slangley    After successfully logging in using the ThingWorx Default Login page, the user will land on the home page mashup which i have created. If the user clicks on the browser back button while on this home page, we need to reload the page.  But if the user navigates to other mashups/ pages and clicks the back button it can navigate to the previous screen.   So basically Immediately after logging in i need make the Browsers back button behave like a reload and not allow the user to go back to the login page. How can i achieve this in thingworx??

I installed both Thinngworx foundation server and Industrial Connectivity, version 8.3 trial. The Thingworx foundation server is working well, I can connect to composer in Browser. However, I tried to configure IC to connect to Thingworx, and then get an error:    Date Time Level Source Event1/8/2019 10:50:18 AM Error ThingWorx Native Interface Connection to ThingWorx failed. | Platform = localhost:80/Thingworx/WS, error = could not initialize a secure socket connection.   Thanks a lot!

Installing an Open Source Time Series Platform For testing InfluxDB and its graphical user interface, Chronograf I'm using Docker images for easy deployment. For this post I assume you have worked with Docker before.   In this setup, InfluxDB and Chronograf will share an internal docker network to exchange data.   InfluxDB can be accessed e.g. by ThingWorx via its exposed port 8086. Chronograf can be accessed to administrative purposes via its port 8888. The following commands can be used to create a InfluxDB environment.   Pull images   sudo docker pull influxdb:latest sudo docker pull chronograf:latest   Create a virtual network   sudo docker network create influxdb   Start the containers   sudo docker run -d --name=influxdb -p 8086:8086 --net=influxdb --restart=always influxdb sudo docker run -d --name=chronograf -p 8888:8888 --net=influxdb --restart=always chronograf --influxdb-url=http://influxdb:8086     InfluxDB should now be r

Hello Community,   In this document from page 206 onwards, OPC UA Services are described. How would i use these services in Thingworx? I`m currently looking for an alternative to OPC Aggregator (Kepware Server) to connect a OPC Server running on a Raspberry Pi to the platform and thought I could maybe use the Services?   Thank you!

Hello, Is there a way by which we can get certain limited number of rows from infotable, without writing any custom service/code. For example I have 10 rows in my infotable, and I want first 5 rows, is there any service available which I can use to get that? Thanks in advance Regards Aditya Mittal

Hi, I wanted to delete multiple rows in sql database. I have given the input as infotable which has default datashape that I have binded the grid to. The grid data selected rows I am giving as input to the multi delete service infotable ip. I tried using the grid advanced but the code does not work. The Things["Bobcat_DBConfig"].Delete_Organization(params) is the service which has sql query to delete the row ( WITH cte AS(SELECT ROW_NUMBER() OVER(ORDER BY org_id) AS RowFROM Organization) DELETE FROM cteWHERE Row = [[rowNum]] )   How could I resolve this?    Thanks in advance, Shalini V.

Hi, In my sql query I am trying to search words in column having letters that I search for. I am using LIKE operation to perform this but it doesn't work. It works fine in sql server but in TW it shows error.   TW: select * from (SELECT DISTINCT STUFF(WORK_ORDER.order_number,1,8,'') as JOBNum FROM WORK_ORDER) t1 WHERE t1.JOBNum LIKE '%'[[input]]'%'   OUTPUT ERROR: Unable to Invoke Service SequencedProductionOrder_JobNumMatch on NAVISTAR_DB_CONFIG : Execute Query failed: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '@P0'.   SQLSERVER: select * from (SELECT DISTINCT STUFF(WORK_ORDER.order_number,1,8,'') as JOBNum FROM WORK_ORDER) t1 WHERE t1.JOBNum LIKE '%234%' **WORKS FINE**   How can I resolve this and use the operator in TW?   Thanks in advance, Shalini V.

I sometimes have a service write to a specific field in the user extensions in the background.  Other services allow a refresh trigger to the service, but the user tab does not.  How does the user extensions list under the user tab get updated?

I have only created 3 columns in the grid. The fourth one appears as an extra and there is no need for it. Removing this extra column will greatly help in improving the look and feel of the grid. So how can the last column (unnamed column in the marked in red in the image) be removed.

Hi Team, I have installed TWRX 8.4.1 with H2 persistence provider, but is not able to start the WebApp on tomcat.The following error is displayed:   Not able to get connection from the underlying database.   I suppose starting from Thingworx 8.4+, a username & password is required in the platform-settings.json file for H2 persistence provider also.Below is the related content of my platform-settings.json file:   "PersistenceProviderPackageConfigs":{ "H2PersistenceProviderPackage":{ "ConnectionInformation":{ "password":"twadmin", "username":"twadmin" } } }   Please help regarding what is the default username & password for H2 provider.

good afternoonWhen installing ThingWorx Analytics, opt for the following error message:   WARNING: You must configure Analytics Extension to communicate with yourAnalytics Server. Open the Analytics Builder Settings page within ThingworxComposer and select the AnalyticsServer Thing you want to connect to. I used the following documentation to perform the installation: https://www.ptc.com/support/-/media/181948D67021428B90F78BA7F1231083.pdf?sc_lang=en Obs: Installing graphical mode on page 21 onwards and requirements have been met.

Hi Folks,   I have installed TWX 8.3 as per the Guide but not able to Load Composer page and getting 401 error as shown below in the attached snapshot. I have gone through all the similar posts on the community but no luck in my case. I am guessing its related to DB but not sure and thus need your help to fix this.     Steps done: 1. Apache 8.5 installed 2. JVM checked: C:\Program Files\Java\jre1.8.0_102\bin\server\jvm.dll 3. Java options added:  -Dserver -Dd64-XX:+UseG1GC-Dfile.encoding=UTF-8   4. PostgressSQL 9.4 installed 5. Added new login Role "twadmin" with required privileges and put same password as in "platform-settings.json" file. 6. DB setup and Schema scripts executed successfully but got 57 tables shown in the schema. 7. Following folders added. -ThingworxPlatform (platform-settings.json) -ThingworxPostgresqlStorage (PG_9.4_201409291) 8. Provided required access to above folders. 9. Updated Enviroment System variables with required paths of ab

Hello everyone! Using the JDBC Connector Extension and the downloaded xlSQL JDBC driver for Excel, I created my own extension for connecting to Excel as a database. But there are problems with configuration. Here are two options:   JDBC Driver Class Name: com.xlSQL.jdbc.DriverJDBC Connection String: jdbc:xlSQL://localhost:8085;databaseName=DBconnectionValidationString: Sheets("Sheet1").Select   or   JDBC Driver Class Name: com.excel.jdbc.DriverJDBC Connection String: jdbc:excel://localhost:8085;databaseName=DBconnectionValidationString: Sheets("Sheet1").Select   In both cases, the connection to the database doesn't occur. First of all, I don't know exactly where my database ("DB") should be for the proper connection. Maybe there is someone here who worked exactly with Excel and will indicate what other mistakes I made when filling out.

Hi Developers,   I have a use case where i have 50 assets and from each asset i'm going to configure 10 data tags. Also the data tags from Kepware will be visualized in 6 TV screens and 4 HMI Tablets.   So how can i calculate how much internet speed (upload and Download) is required for the above mentioned use case?     Thanks and Regards, Saran    

suppose i have written a service in which i want to use session variable within a range that will be provided dynamically from URL and it should loop in that accordingly. will it work fine if i provide different ranges in two different in two different systems at a time? same service will work fro bot ranges at a time?   Thnaks in Advance Aditya

Hello Everyone;   I am using ThingWorx 8.3.0 Version with MS SQL Database connection. After installing ThingWorx analytics, ThingWorx start to do not accept any Save requests. For Example i try to add a property a thing and hit save button. It shows me a diolog box which says "Active Edit ... user is currently using this entity". It doesnt matter that pressing Overwrite or Discard buttons. Also i cant create a new thing. When i look the Active Users section, my username seems to repeat so many times with same Last Connection timestamp.  Database connections seems to be fine. For example when i execute a SQL Select service , it works. Current services also works but i cant make any permanent changes.   Did anyone encounter such a problem or how can i solve this issue.    Any help will be appreciated.    Thank you. Murat Can Berber

Hi,   I was wondering regarding web frames. I have attached a picture of a static mashup and a web frame. There is a grey border around the web frame which in this case shows a .jpg of the google logo. This is also the situation in responsive mashup with layouts.   My question is. Is it possible to get rid of the grey border? - If not, where do I propose a change/improvement?