IoT & Connectivity

Has anyone found a way to store all ThingWorx time series data in a Historian?   Could ThingWorx act as an OPC UA server? Alternatively could one configure Kepware to pull data from ThingWorx and then make that available via OPC UA?

The ThingWorx persistence provider may be a SQL database, but it is most certainly not a good idea to try and access the time series data with a DB tool to run analytics on it.   What would be the best mechanism to make data available for external analytics tools to analyse data acquired by ThingWorx?

Good day All,We have developed an extension and mobile applications to enable an alerting mechanism, that is free to use, in Thingworx. The extension is called WorxAlert and is available from the Thingworx marketplace.  (https://marketplace.ptc.com/apps/230548/worxalert#!overview) The mobile application is available on the Google Play Store, as well as the iOS app store with the name WorxAlert Messenger.Description:Receive free push notifications and alerts directly to your smartphone device from your ThingWorx based IoT application. WorxAlert makes integrating real-time alerting into your applications a breeze.  No need for expensive SMS messaging services anymore. Now you can use WorxAlert Messenger with your ThingWorx IoT platform to send free notifications and alerts to all your users. Our platform extension is available free of charge and is easy to install on your own ThingWorx instance. You can send unlimited free messages to any user registered on your platform and bu

I believe this question has already been asked on here, but I still cannot find a solution for it despite trying the solutions provided so I'm asking this again. I have imported the timeSeriesChartV2 extension from the PTC marketplace and attached below is the default time series chart and the time series chart v2 extension.   The default time series chart is showing the data correctly whereas the time series chart v2 isn't despite both of their data being binded the same way. I have set the X-AxisField to timestamp and DataField1 to TimeSeriesProperty which is a number under the property of my Thing. Any idea why the timeSeriesChartV2 is not displaying anything?

Hi,  It seems that the global parameter only works after the page get rendered , otherwise the value is always undefined,  is it true ?    For example,  if you have text box and bind it to a global parameter and bind the <ParamterName>Changed event to a service in the inner mashup,  then you change the text box after the page get loaded , you'll see the global parameter get assigned in the inner mashup . so it works.   But,  if you put some initial value to the text box and expect the initial value can be passed as global parameter, then whatever event you bind in the inner mashup(including the expression with auto evaluate),  the global parameter in the inner mashup is ALWAYS undefined.     Regards, Sean

Hi, I would like to start a big application that will take data from multiple datasources (SQL servers, APIs etc.) and I would say will be a complex one.    The thing is, in the last couple of days i was trying to find some differences between dashboards (which look way better and are easier to configure) and mashups and i could not. Till now i've only worked with mashups and i found some documentation about dashboards but it did not answer my questions. (e.g. are they better for a bigger application? are they scalable and easy to deploy to more than 1 server?)   thanks! anything would be helpful as i know almost nothing 🙂

Hi, Can anybody provide an overview of how to push notification from Thingworx server to Android devices? We are planning to integrate push notification to Android & Ios mobile devices whenever any events are generated on thingworx server.    

IP Address of our network?   Re:  post

Hi,   I got an error when trying to import an new extension package,   i tried to follow the document and add ExtensionPackageImportPolicy config into the platform-settings.json However, the system could not start due to an error 2019-08-16 15:45:42.008-0500 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Database initialization started... 2019-08-16 15:46:12.179-0500 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->1hgfaf5a417c0yjea1f13u|3aa17561]-HelperThread-#3] com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@384fd923 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (3). Last acquisition attempt exception: 2019-08-16 15:46:12.181-0500 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [T: C3P0PooledCo

Hi, i am trying to use anomaly detection with the alert system on a Thing that is created from a generic thing. The sensor readings are coming in via REST and i can plot a time series chart on the mashup. However after i tried using the anomaly detection alert in the new composer platform, it shows initialization failed.   Is this because i am using a Generic thing instead of Remote Thing as mentioned in tutorials?? I am still a student so i do not have access/ connection to industrial software like kepserverex to connect to. I assume it can work since i can access the functionality on the new composer.  

Hi, I'm using security-common-cli-1.0.0.26 to encrypt the password  but got the errors below.  And If set the plain password in the platform-settings.json , I got the same error in the tomcat's log.    2019-08-16 11:00:32.223+0800 [L: INFO] [O: c.t.s.SecurityManagerBootstrapper] [T: main] initializing KeyStore provider 2019-08-16 11:00:32.489+0800 [L: ERROR] [O: c.t.s.SecurityManagerBootstrapper] [T: main] Unable to load SecretProvider, {} java.security.UnrecoverableKeyException: Password verification failed ... 13 common frames omitted Wrapped by: java.io.IOException: Keystore was tampered with, or password was incorrect at com.sun.crypto.provider.JceKeyStore.engineLoad(JceKeyStore.java:879) at java.security.KeyStore.load(KeyStore.java:1445) at com.thingworx.security.provider.keystore.KeyStoreProvider.loadKeystore(KeyStoreProvider.java:154) at com.thingworx.security.provider.keystore.KeyStoreProvider.<init>(KeyStoreProvider.java:44) ... 9 common fr

Race to the finish line of IoT app development with ThingWorx Edge!     Hi everyone,   Today’s post comes fully packed with an intro to our ThingWorx Edge strategy. Learn how to connect your machine data to ThingWorx, how our SDKs work, why you’d want to use them and how you can deploy agents.   To learn more about the Edge with ThingWorx, I spoke with Shravan. When Shravan’s not following Formula 1, learning about the latest trends in AI or playing cricket, he’s leading our development teams as the PM for the Edge. Check out what he had to say:   Kaya: How can I connect my machine data to ThingWorx through a protocol that the platform does not natively support?  Shravan: If you’re looking to connect your machine data to ThingWorx through a proprietary protocol and you require a 1:1 connection with the platform, we have two paths you can take. You can either: Utilize PTC’s Edge MicroServer (EMS) out-of-the-box solution. This is a stand-alone application

Looking for ideas here: The requirement is to display some dashboards (with auto refresh widget) on TV screens and no user interaction is expected once setup. Need to automatically login the user and should survive Thingworx restarts.   I have developed a custom authenticator that automatically logs in a user depending on custom parameters passed in the initial URL which is a REST GET URL like http://server:port/Thingworx/Mashups/MyMashup?myCustomParam=<value of interest>   Although this works for the initial login, the page gets redirected to an URL with anchor tag of the format - http://server:port/Thingworx/Runtime/index.html#....MyMashup...   If the Thingworx server restarts, there is a prompt for login as the redirected URL has a anchor tag and the request is trimmed off at the '#' and the authenticator does not receive the originally params that are used for automatic login.   How can I overcome this issue? Is there a way to pass headers or set cookies t

I have a main mashup with contained mashup with footer showing bunch of icons representing mashups (using collection widget). Based on the icon selection on this menu I can navigate to different mashups in that contained mashup area.   One of the mashup shown in contained mashup area has a Navigation button. I am looking to navigate the user to a different mashup instead of showing a pop or modal popup. Though when using the replace window option, the new mashup completely replaces the current view, including the footer and thus loosing the foot completely.   Is there an efficient way to replace the mashup only in that contained mashup area instead of navigating completely away from the current mashup.   Thanks.

Has anyone implemented Two-Factor authentication in Thingworx, either by using custom code or a third party ? I have to create a solution that has 2 factor Authentication, but I have never done it so any help would be appreciated    

Hi,   We are having a 503 service error with Thingworx for maybe the 5th time. It is not a trial edition. This happens whenever we install a software, or when we have a Windows update. Please help because it is getting frustrating to spend this much time solving thingworx problems (Also sometimes random crashes that is solved by restarting the computer.)

Hello everybody,   I have a manufacturing process with different stages. In order to have a specific screen for every single stage, I am using Tabs Widget. This way, I have one tab per stage (e.g. Mixing, Cutting, etc)   I want to link information of a Data Table into Text Areas. Is there any way of fixing the value of Selected Row as the name of the tab?   This would mean that if I click in the tab "Mixing", the service will select "Mixing" as Selected Row (There is a column in the Data Table called Stages with this name and it is the Key Field) and give back the rest of values of this row.   Thank you very much   Sincerely    Rodrigo Avilés  

Hi, I wanted to return current date and time in August 13, 2019 03:54 PM format using Java script.Could someone help me in achieving this because I am not able to find the appropriate js to achieve this format. Thanks in advance, Shalini V.    

Hi all,   I have a query where one of the columns I'm selected is named "Value", so in my query it appears as:SELECT .... PM.Value   It appears as if ThingWorx/SQL is treating this as a reserved keyword of some sort, nothing I do will allow me to have the word "Value" in SELECT statement. It always fails and returns the error: Unable to Invoke Service <ServiceName> on <ThingName> : The connection is closed.   I have tried aliasing the column name: PM.Value [Othername] PM.Value AS [Othername]   I have tried creating an input parameter string, setting it to "[Value]" and then putting it into my SQL statement as <<inputparam>>.   Microsoft SQL Server Management Studio handles the query completely fine, no issues at all.   Any help would be greatly appreciated.   Thanks.      

Dear Team,   My requirement is to show live tracking data on google maps in thingworx.   And I get continuous feed data from the device.   Need to show live tracking line of the vehicle on mashups.   Request you to provide support on this ASAP   Thanks, Regards, Vijay

May I know where I can find the JavaScript code (ide.js and runtime.js) for ThingWorx widgets? The following path is what I am trying on my computer but to no avail as there are only images inside the widget folders. C:\Program Files (x86)\ThingWorxH2Trial-8.4.0-SNAPSHOT\tomcat\apache-tomcat-8.5.23\webapps\Thingworx\Common\thingworx\widgets

Hi, I am using remote things to store few properties of a sensor. The connection was good and was getting data well and was getting store. But suddenly after few days, there is loss of connection and data is not not getting pushed. when checked on the connector side data was present but the same was not reflecting in the remote thing property.I observed that the remote thing had lost connection with the connector thing. What might be the root cause for this? and how can I solve this issue permanently? 

Hello, I have a server running Thingworx 7.4 and I would like to migrate to a new server that runs 8.4. Do I need a separate license to do this? Or can I transfer the old license when I move the data. Thank you Connor

Hi, I'm trying to change the running time for pooling trigger (created with Thingworx Flow CLI). By default they run every 30 minutes. How to set the interval using a configuration of Thingworx Flow server? Or maybe there is another possibility?

Would like to know the best practice to calculate machine downtime by running signal, For example: running signal was collected and storage in Stream Table, data are timestamp and value 0 (stop) and 1(run) timestamp0    :   1 timestamp1    :   0 timestamp2    :   1 timestamp3    :   0 timestamp4    :   1 .... Stop time should be: (timestamp2-timestamp1) + (timestamp4-timestamp3) + .... What is best way to calculate/query in historian value in stream table?  Thank you so much!