IoT & Connectivity

Hi all,   I am trying do download to Eclipse Plugin for ThingWorx from Marketplace.   But when I click on continue button load the same page. Follow image below:   Someone is with the same problem?      

I can't start thingworx which return 503 error. But the tomcat works.   thingworx application log: 2019-09-03 10:07:28.968+0800 [L: INFO] [O: c.t.s.ThingWorxPersistenceHandler] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Default Persistence Provider Package Name = PostgresPersistenceProviderPackage2019-09-03 10:07:28.982+0800 [L: INFO] [O: c.t.p.p.PostgresDatasource] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Reading configuration from configTableCol2019-09-03 10:07:29.311+0800 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Managers...INITIALIZED2019-09-03 10:07:29.315+0800 [L: INFO] [O: c.t.s.ThingWorxServer] [I: ] [U: SuperUser] [S: ] [T: localhost-startStop-1] Database initialization started...2019-09-03 10:07:59.782+0800 [L: WARN] [O: c.m.v.r.BasicResourcePool] [I: ] [U: ] [S: ] [T: C3P0PooledConnectionPoolManager[identityToken->2rwcn5a41vy09sjfb4gy5|5e7a8bf1]-HelperThread-#0] com.mchange.v2.resourcepool.Basic

Hi. Now I am doing single aggregate function for real data and I want to proceed to multiple field aggregate function. Like I want to calculate each target and real data number for average using one service because I want to show both of them in one label chart. how to combine them in one service?   var result = Resources["InfoTableFunctions"].RenameField({ t: Resources["InfoTableFunctions"].Aggregate({ t: me.QueryDataTableEntries({ maxItems: undefined, query: query, values:undefined, source: undefined, tags:undefined }), columns: 'value,Target', aggregates: 'AVERAGE', groupByColumns: 'month' }), from: "AVERAGE_value,AVERAGE_Target", to: "value,Target" }); After that, thingworx will show Error executing service QueryByMonth_Cost_Cheese_OE_LineA. Message:: Wrapped java.lang.NullPointerException - See Script Error Log for more details 

Hi, are there any built in services that allow you to modify stream & value stream entries? We have a requirement to remove all customer/user data upon request. However, we would like to retain some of the data we hold to aid in data analysis and so we are looking to modify that data if possible so that it cannot be connected to an individual customer. I can see that there are services to purge/delete entries which we will use in most cases, but there are other circumstances where we might wish to retain the event.  Examples of this might be: Streams: where we record a 'log in' event on a remote asset. The data for that event holds the username. If possible we would like to keep the event, but overwrite the username value with some anonymous data. Value Stream: where we log the name of the current 'job' being carried out on the remote asset. This might be customer specific.   One thought that we had was to add a new entry (with modified data) using the old event timestamp

Hi. I made a service which calls an Influx endpoint with a Flux query, using an HTTP POST (Resources["ContentLoaderFunctions"].PostText())   This works great, but how do I show the result of this query in a mashup? I can't figure out how to invoke a service from a mashup.

Hi Team,    I'm using the C-SDK 2-2-3-1545 to connect to a device to ThingWorx 8.4.2 and although I can connect and interact (READ/WRITE) with remote properties, I'm still having this error :   [ERROR] 2019-08-29 09:08:07,812: subscribedPropsMgr_UpdateSavedValues: spm->persistedValues not initialized   How can I deal with that error ? How to solve that ? If I don't solve that, which implication will it have in the future ? Thanks in advance.   Best Regards, Yaniel Barbosa.

Dear Community!   we have S7-PLC here connected to a KepServer transfering the data to ThingWorx. All the data connection, management and so on is working great but still an issue with Timestamp-Tags of type Date.  OPC-UA and I think also the KepServer define UTC as std. Timezone for all Timestamp data, they do not attach timezone information to the timestamp. So when Thingworx recieves the data from KepServer it takes the data as UTC and stores it to the bound properties. But our S7-PLCs clock is running at local time, not UTC. So all timestamps recieved by ThingWorx are based on the wrong timezone. I looked around if there is any possibility to "shift" or adjust this inside Kepware.   Our current only possible workaround seems to be: - Define two Date Properties for the Thing, one bound to the Kepserver Tag and a subscription to calculate the shift and write the correct value to the second one.   Any other ideas??    

Unable to connect ThingWorx 8.3.0-b349 to MS SQL external Database. I use the extension pointed by the various tutorials about, then I create a thing using the ThingTemplate MsSQL server. I've tried to change different parameters for the configuration tab. In the application log i receive the messages : [message: Entity Not Found : [JdbcCreator]] [message: Entity Not Found : [MySqlServer]] (note that I use the Template and parameters for Ms SQl not MySql)[message: Unable To Convert From java.lang.String to NUMBER] I verified that in the Tomcat folder lib there is the MsSql.jar file.I used a similar procedure for Postgres Database and works, but I keep failing with MsSql.

This post indicates there was a Trial Edition Docker container at one time.  Is it still available?  Does anyone know where to download it from?

Hi, is there a source for the Scemas and Data Models for Manufacturing Apps?   I'm in the proces of adding customized apps in Mfg and having the Schemas and Data Models and a document like the Thingworx Operator Advisor Guide for Mfg would be handy.   Please advice

  When it’s time to make pizza, most of us head to the fridge for our bag of dough; we don’t head for the flour and yeast to start from scratch. So, why would your ThingWorx apps be any different? Start with pre-built solutions like Asset Advisor to rapidly create health monitoring apps and dramatically reduce your development time.   We previously introduced Asset Advisor on Episode 04 of “ThingWorx on Air.” Today, we dive deeper into Asset Advisor with Greg Huet, Asset Advisor’s technical product manager (aka product owner). Listen to Ep. 06: Rapidly Build IIoT Apps for Service & Monitoring with Asset Advisor to hear Greg share our strategy of studying existing use cases and finding similarities that we can pre-build into solutions so that you don’t have to build them from scratch. Hear how you can use Asset Advisor out-of-the-box with tweaks for your company’s configurations or as an accelerated starting point where you can add as much customization as your use case d

Hello,   I have a problem when I try to connect Fanuc 30i-A PMC with Industrial Connectivity. The failure is the next:     I selected the appropiate channel and device, I downloaded Fanuc focas library I and II and I installed on Windows System32 folder, but the problem continue. Anyone knows about these libraries or how to connect with Fanuc PLC/CNC?   Thank you in advance BR,   Luis

Hi, Can someone help me to fix this problem ASAP? thank you.

Hi all,   i have my stored procedure runs perfectly in MSSQl, but when I create the 'SQL Query' service and execute this stored procedure, it shows 'Executing' all the time until timeout without any error. In the same Thing I have other service executes stored procedure which runs with no problem.   Anyone may know something? Thank you

can anybody tell, how to automatically remove the thingworx catche from the browser using code?    Regards Sugumar R

In my situation, I can do aggregate function and data filter function in different services. but now I want to combine these two in one service. how to do that? Could someone show me an example.   here is my code in service:  var result = Resources["InfoTableFunctions"].RenameField({t: Resources["InfoTableFunctions"].Aggregate({t: me.QueryDataTableEntries({ maxItems: 1000000 }),columns: 'value',aggregates: 'SUM',query: query,groupByColumns: 'month'}),from: "SUM_value",to: "value"});var query = {"filters": {"type": "EQ","fieldName": "KPI_Details","value": "Volume1"}}; and result only show each month number and value

Once the machine gets started, after 30 minutes it has to check the pressure value weather it is less than 100. If not it has to trigger the alarm (the value of pressure decreasing constantly) Variables: 1. machine start - boolean (1&0) 2. pressure - number 3. alarm- boolean (1&0)

How to create Automatic Backup to thingworx entites and data instead of exporting into xml or twx files using export option in composer. I have ThingworxBackupStorage folder in my c drive, but it empty, there are no backup files. Is there anything to be added in platform settings file or do I need to enable any option in composer or do I need to run a service. Please suggest me right approach.  

I am getting a socket error when I try to import entities from file, which is strange as I am importing from a local file. Binary and xml return the same error. The app log only returns the 5 lines below. Any help is appreciated.   2019-08-20 17:42:16.193-0400 [L: WARN] [O: c.t.s.s.p.PlatformSubsystem] [I: ] [U: ] [S: ] [T: pool-13-thread-1] Thingworx System Metrics_-----------------------------------------------------------------$2019-08-20 17:42:26.271-0400 [L: ERROR] [O: E.c.t.w.Importer] [I: ] [U: Administrator] [S: ] [T: https-jsse-nio-443-exec-6] [message: java.net.SocketTimeoutException]2019-08-20 17:42:26.274-0400 [L: ERROR] [O: c.t.w.Importer] [I: ] [U: Administrator] [S: ] [T: https-jsse-nio-443-exec-6] Invalid request: org.apache.catalina.connector.ClientAbortException: java.net.Soc$2019-08-20 17:42:26.274-0400 [L: INFO] [O: c.t.migration] [I: ] [U: ] [S: ] [T: https-jsse-nio-443-exec-6] Start post migrating from version [8.3.0] to version [8.3.0] ...2019-08-20 17:42:26

Please provide a link are document to install asset advisor and prerequisites to install 

Would like to know can we use Extension SDK v8.3 for development Thingworx 8.4 widget? As my test, some downloaded widget in marketplace cannot use in Thingworx 8.4 Thank you

Hi, I want to know how ThingWorx keep data consistent during concurrent update.  I asked a similar question days ago and got reply that if set a persistent property then the thread will be locked and will be executed one by one.    However,  I tested the approach but still got inconsistent data.   Any suggestions ?    I created a reproducible case:  1. Import the attached XML 2. Find the data table ConCurrentDataTable 3. Execute ResetTestData,  it will call Async service _Update to simulate concurrent update.  4. Execute ConCurrentUpdate, it will update the properties of entry [Type=station1] with new value.  5. Check the table ConCurrentDataTable,  you will find only a few properties get updated .   Regards, Sean

Hi,   I have a requirement where I need to display a particular value in tool tip of label chart. That value should not be displayed in any form(bar/line) in label chart,should only be displayed in tool tip field. I have already tried changing styles of that data field to transparent and it works but the problem here is the calibration of Y Axis is getting changed.  Is there any way to add data directly in the tool tip field without adding it in label chart. Any lead on this is appreciable.   Thanks in advance, MishiK

Hello.   I want to know if there is any way to make the collection cells centered to the collection itself, so instead of having the cells at the top of the collection, have them centered.   Does anyone know if it is possible?   Thank you.

I would like to take an input string and check if it matches any expression in a DataTable of expressions.   For example, if the input string is "SomeError1", and the expressions in the DataTable are:   "SomeError.*" "SomeOtherError.*" ".*Error"   I want to query if the input string matches any of the expressions in the table. In this case, it would match "SomeError.*".   I've tried querying the DataTable entries with LIKE and Matches queries:  "filters": {  "type": "Matches",   "fieldName": "item",   "expression": "SomeError1"}   "filters": {    "type": "LIKE",    "fieldName": "item",     "value": "SomeError1"}   but it only returns a result if the value/expression field is the expression.   Is there any way to accomplish this?   Thanks!