IoT & Connectivity

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!

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.

Hello!   I have an infotable with the following data:     When displaying this data in the Pie Chart the second and third records are displayed in different colors:   Can this widget combine records with the same Label-field and color them in one color so that there are no such repetitions?

Hi,    I notice some error log "Exception: Cannot read property 'BM_recycled' of undefined" in the runtime mashup log,  although it seems that the error doesn't affect my current page behavior , I'm afraid of the potential risk.   The error doesn't tell me more reason about it ,  does anyone has clue on analyzing it ?     =============one of the complete log ======================================== Runtime exception handling data update for binding {"Id":"248e8b98-608c-4d4c-847c-b8482a528207","SourceArea":"Session","SourceSection":"Session","SourceId":"Session","SourceDetails":"AllData","TargetArea":"Mashup","TargetSection":"","TargetId":"mashup-root","PropertyMaps":[{"SourceProperty":"OperatorConfirmStartWorkOrderId","SourcePropertyType":"Data","SourcePropertyBaseType":"STRING","TargetProperty":"StartWorkOrderId","TargetPropertyBaseType":"STRING"}],"isBoundToSelectedRows":false}Exception: Cannot read property 'BM_recycled' of undefined &nbs

I have already configure my Tomcat serve for CORS still i am not able to access my api and i am getting " Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource."   When i am trying to access the API using Postman i am getting 403 error. For reference please check attached images.   

I create SQL command for purge all data in table.   DELETE FROM [[tableName1]]; [[tableName1]] is the input table.   When execute this service. It error like below code Unable to Invoke Service purgeTable on MTH.FC2.ASSY.SQLConnector : Execute Update failed: com.microsoft.sqlserver.jdbc.SQLServerException: Must declare the table variable "@P0". But, If I put the table name inside the service code. It can execute without error. DELETE FROM test;   How I should to do ?

In composer on a particular machine all datetimes are listed as yyyy/mm/dd h:m:s instead of yyyy-mm-dd h:m:s. Is there a default setting somewhere like in platform settings where this can be changed?

Created a connection from Kepware to a 3rd party OPC server, and connection is normally running. Every evening the connection goes down, and Kepware returns the error: 'Channel Failed to connect | Status Description='Could not establish a network connection to remote server' Status Code=0x80AC0000' In the morning Kepware returns the error : ‘Socket error occurred connecting. | Error = 10061’ Details=’Impossibile stabilire la connessione. Rifiuto persistente del computer di destinazione’. --> Not possible to establish the connection, Destination computer deny And then, for each Tag, the following error: … Add item failed on device. | Tag address ….. Status description = ‘The node id refers to a node that does not exist in the server address space’ Status code = 0x80340000 In the Manufacturing Apps the device is in error and data are not good. Restarting the KepServerEX 6.6 Runtime service the connection is running again. Which is the right way to manage this case? Are there s

Hi   i wanted to know how we can bind remote datashapes and other components to Composer.   Thanks Shyam

Hi,    I am currently working with gridadvance widget (8.1 TW version), and I want to being able to sort each column. I defined my datashape, bind my data into the grid, etc. But when I go under my widget's properties, I select EnableSorting and run it. Unfortunately when I try to sort the column (number type), the table header shows me that its trying to sort (triangles are showed), but the the rows does not get sort. Am I skipping any step or there is a problem with this widget?    I appreciate any help   Thanks