Recently active
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.
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, 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
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!
Hello everyone, I have the following problem, everytime I try to start an analysis event I get this message "Unable to process Analysis based on event: DataChange on source: MyThing and property: SENSORVALUE! Error in getting matching Analysis Event" I don't know how to fix this problem.Best regards
I am following the instructions here: https://developer.thingworx.com/en/resources/guides/foundation-linux-install-guide/foundation-linux-create-ssl Using JDK 1.8_131and Ubuntu 18.04 LTS I keep getting the error above. I found this article, https://www.ptc.com/en/support/article?n=CS147810, but it requires a maintenance subscription.
Hi, I'd like to add some logs to expression and validation, I tried console.log() and logger.debug() , but both of them don't work. How should I add the logs ? Regards, Sean
hi everyone my issue is as follows: 1- i get data from backend sever. data image: 2-after clicking mapit button, a popup mashup opens as below: 3- after closing the popup mashup, datepickers becomes unclickable. Thingworx version: 8.2 No date related extensions installed.
Dear PTC community, I have been working on a ThingWorx project for some weeks. Today I have realized that when I try to save my main Mashup after update it with new widgets or services, the following message appears: Saving : Unable to update mashup As a possible solution, I have also tried to duplicate it in order to use the new one. After clicking in duplicate, a new window has appeared with this message: "Could not load "New Mashup - 1". Reason: 404 - Entity Not Found : [New Mashup - 1]" Then the new duplicate mashup has been created but the behavior is exactly the same that with the original one: "Unable to update mashup" It only happens with this specific mashup, I have achieved to generate changes in other entities of the same project as other mashups, styles or media. Any idea what could have happened? Any possible solution? Thank you very much, Rodrigo.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.