IoT & Connectivity

Hi, I am trying to fetch data from postgresql property_vtq table for external application.But the data is coming in binary format for value column as seen below. Further checking the data type of value column, it is showing as bytea.How can we get this format converted to represent some sensible data as string, integer or datetime according to the property basetype configured.  Thanks and Regards,Bhushan

i want to loop through each row of infotable and pass the whole row as an argument. is it possible in thing worx.While writing infotable.rows[0] its  showing error as : (Error executing service. Message ::Unable To Convert From com.thingworx.types.collections.ValueCollection to INFOTABLE)

Hello, I was wondering if the thingworx project from the iot gallery were downloadable.For example, this one: https://iot.gallery.video/detail/videos/thingworx-for-manufacturing/video/6256448383001/scp-accelerator-overview-demo-videoDoes anyone know?

Hi,  There is a requirement of storing large data in data table dynamically. We are facing an indexing issue while deleting the data. Does anybody knows how to configure custom Datatable in Thingworx

Hi,    A JavaScript service can be configured as sync or Async  during design time .    but is it possible to decide it during runtime ? that is , calling javascript service sync or async by passing into a indicator parameter .     Regards, Sean

Can anyone help solve the problem I'm having in using redundancy master?   when using Redundancy master, only the primary server can read data, when the primary server is down, the secondary server does not work. for the secondary server, it can only be read on the quick client as long as it fills in the prog id and remote machine name manually, whereas if you import tags via "device" in kepware, an error appears as shown in the picture. can anyone help solve this problem?

I am trying to install TWX9.3 with the installer and I am using the Linux version with PostgreSQL (MED-61111-CD-093_SP2_ThingWorx-Foundation-Installer-postgresql-linux-9-3-2). The OS that I am using is CentOs8 64bits.  I have the right version of java (11) which is installed and setup in the path and I have also setup the PostgreSQL path. When i run the installer, it gets all the way to 96% and there it freezes at the step: "ThingWorx Foundation for PostgreSQL Installation in Progress" and I get a generic message: "There has been an error. foundation Installation Failed The application will exit now. When running the installer I have used the default location: /opt/ThingWorxFoundation. I am not able to see any logs (not even before i close the message error box). Also, i have found several topics open for issue with the installer and on one article (https://www.ptc.com/en/support/article/CS329897) i have even found the message: "Since ThingWorx Foundation 9.3.1 Inst

Do you work in the engineering department responsible for product design?  We know that designers and engineers must address issues around cost, compliance, and product redesigns. In many cases, this requires pulling data from different systems. We have created a solution vision that we want your feedback on. Through this approach, we would collect data automatically and deliver it via Windchill (PLM) to help you make data-driven design decisions and speed up the process of collecting and analyzing this data. The call will be hosted remotely using MS Teams or Zoom, and last approximately 45 - 60 minutes. You will be rewarded with a $50 honorarium in the form of an e-gift card. Interested?  Register here:  https://www.userinterviews.com/projects/6g1pRnFf_A/apply

Hi,   i want to upload a file created by the TWX Platform to an external System. The external api accepts POST requests with multipart/form-data. It requires that the file is attached to the "files" key. A correct CURL command (that is working) is: curl -u REDACTED:REDACTED -x POST --url "http://172.18.0.6:1080/archive" -F files=@testarchive.zip Now i have two options with "ContentLoaderFunctions.PostMultipart" from TWX (that i know so far):   Send File from Repository   let params = { repository: "SystemRepository" /* STRING */, url: "http://172.18.0.6:1080/archive" /* STRING */, password: "REDACTED" /* STRING */, pathOnRepository: "/archive.zip" /* STRING */, username: "REDACTED" /* STRING */, }; // result: JSON result = Resources["ContentLoaderFunctions"].PostMultipart(params);       This creates a correct Multipart Request but the api requires that the File is attached to a "files" key not the created "file" key. The intercepted request

hello. i want my service to run only when all the input parameters are present or valid. i see this pop-up but not sure how to implement that into the script itself. please advise 

Hello,I have built the different doocker image.When i try to run my docker-compose-postgresql.ymlI have an issue stating:  postgresql-init_1 | psql: error: connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused postgresql-init_1 | Is the server running on that host and accepting TCP/IP connections? postgresql-init_1 | connection to server at "localhost" (::1), port 5432 failed: Cannot assign requested address postgresql-init_1 | Is the server running on that host and accepting TCP/IP connections? postgresql-init_1 | [06-09-22 13:03:33] [INFO] Postgres is unavailable - Waiting...  My PostgreSQL server is running and i can even connec to It using pgAdmin4 on those port.Does anyone have a clue?

Hello,   I tried to connect with ThingWorx Kepware Server.However, it does not work. I connect to the composer locally by doing: http://127.0.0.1:8080/ThingworxHere is my configuration:   Does anyone have an idea of how to solve this issue?  

As per this thread- same issue:   Hi @PaiChung    I am doing the exact same exercise. I've already changed the property aspect to Always. Still my property values do not update. Is this a permissions issue? Do I need to do something differently?   Many Thanks

I am new to Thingworx and thought the requirement below must has been solved many times before. Is there sample source code or documents I can review? Requirements: I would like to build a dropdown box (for user to select 5 production lines) in Thingworx: when user click “Line 1”, Line 1 data is shown on the rest of screen; when user click “Line 2”, Line 2 data is shown on the rest of screen. Questions: (1) how can I populate dropdown widget with “Line 1”; “Line 2” etc.?; (2) how can I populate the rest of screen data when user select “Line 1” or “Line 2”, etc.? Thank you!

This UNC path is a shared network drive which is given full control permissions.When I started the Tomcat, The tomcat application is started after sometime its stopped, I saw the logs of tomcat but it doesn't show any errors and also the Thingworx logs and other folders which is usually created under the ThingworxStorage is not created on that UNC path.  its appreciated if any having solutions on exactly what i have to do to run the application, and i must have to use shared network drive as my Storage and file root repositary.

Hello Team,   Thingworx Composer free trial (30 days) link doesn't appear on PTC university site, Earlier it was there and it's very useful for beginners.   So could you please help me out on this.   THanks

Hi, there I have converted my JSON object to string (by means of the .parse) so that I could split the values. Now I want to update my thing properties with the values from my JSON object.This JSON object and the thing properties are all on one thing. I only managed to update the value at [0] index. When I try index [1] or higher, it throws an error.Could you direct me if this issue has been solved already or any suggestions on how to achieve the updating of thing properties with the respective json values? Much appreciated. 

Hi all,I am facing the issue of after a certain no. of devices I am not able to connect more devices to ThingWorx. My application structure is as belowDevices -> proxy server(nginx) -> connection server -> ThingWorx.Each device will have 872 properties. We were able to connect around 3800 devices but after this count, devices will not get reflected on Thingworx. After checking logs found the below warning at the connection server.[vert.x-acceptor-thread-0] WARN i.n.channel.DefaultChannelPipeline - An exceptionCaught() event was fired, and it reached at the tail of the pipeline. It usually means the last handler in the pipeline did not handle the exception.java.io.IOException: Too many open filesat sun.nio.ch.ServerSocketChannelImpl.accept0(Native Method)at sun.nio.ch.ServerSocketChannelImpl.accept(ServerSocketChannelImpl.java:422)at sun.nio.ch.ServerSocketChannelImpl.accept(ServerSocketChannelImpl.java:250)at io.netty.util.internal.SocketUtils$5.run(SocketUtils.java:110)at io.

We have a Test mashup which is opened in runtime and we restarted the Tomcat and the ThingWorx is down. Can we automatically reload the Test Mashup in runtime once again after the ThingWorx is up and running again? Is there any way to do so?

Hi, Is it possible to trigger the tablet PC camera when a button is clicked? Is there any service that can be used to achieve this use case?

Hi Team,   I have to implement one functionality in which if I click on google map open tooltip should close. Is it possible in thingworx?

On starting ThingWorx and InfluxDB instance simultaneously QueryNamedPropertyHistory service is giving below error:Execution error in service script [QueryNamedPropertyHistory] :: com.thingworx.common.exceptions.DataAccessException: [1,018] Data store unknown error: [Error occurred while accessing the data provider.] After running the ConnectDataSource service in the Persistence Provider configured to connect with InfluxDB the issue gets resolved. But with every instance start, the issue is reoccurring. Also if the InfluxDb instance is started ahead of ThingWorx this issue does not occur.Has anyone faced a similar issue?Any inputs would be very helpful.

As per this thread - same issue:   Hi @CGinus , Facing the same issue, can you help with css ? Thanks,Shashi.  

Hi,How to configure "ThingWorx Foundation File Storage" for HA cluster? I am using twx 9.3 (HA) on windows 2019 and "ThingworxStorage" folder is available on different VM (Shared over the network and have proper read/write permissions to the NETWORK SERVICE which runs the tomcat). I have configured the parameter in platform-settings.json as below."Storage": “\\\\W19PRD004\\ThingworxStorage”, I am getting below error in tomcat logs.error trying to initialize Platform storage [setting: \\W19PRD004\ThingworxStorage\database] Can anyone help me on this? Note: In ThingWorx 9.3 High Availability clustering is now supported on Windows 2019 as per this article, 

Hello,  Im trying to get the response body from a Resources["ContentLoaderFunctions"].PostJSON(params) call. When I try the POST call from Postman I get the following as a response in a response Headers and Body: HTTP/1.1 200 OKContent-Type: application/json;charset=ISO-8859-1Content-Length: 15Server: Jetty(7.x.y-SNAPSHOT)RC: 1 SuccessWhen I try the same call from Thingworx PostJSON I only get the headers JSON object of the request as the response object looking like this (xxxx = the auth code):  {"headers":{"Authorization":"xxxx"}}Anyone now why? And more specifically how I get the RC: 1 Success value from the response body?Using ThingWorx 9.1.8-b845