IoT & Connectivity

Hi, I'm running Thingworx 8 server locally, my DB is Postgresql - Value Streams are exhibiting very odd behavior, when I create a value stream (using ThingworxPersistenceProvider), connect it to a thing & run QueryPropertyHistory - I get an error saying Data Store Unknown. Switched on stack trace and this is what I got: 2020-02-21 16:55:35.516+0400 [L: ERROR] [O: E.c.t.p.p.PostgresDataExceptionTranslator] [I: ] [U: Administrator] [S: ] [T: http-nio-8080-exec-8] [message: [1,018] Data store unknown error: [Error occurred while accessing the data provider.]] org.postgresql.util.PSQLException: ERROR: relation "value_stream" does not existPosition: 32at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)at or

Here is the situation: I have a mashup that is essentially just a collection widget I am using a service (getCollectionWidgetData) to populate the collection widget Each row in the collection is a contained mashup which has some action buttons on it that allow the user to kick-off other services (when clicked, each button launches a pop-up for the user to confirm, then when confirmed the service is executed and pop up closed - so technically the service is executed from the popup mashup) Each row in the collection is also displaying data that should change based on those services being executed Here is what I have tried: I created a global session variable named "refreshCollection" as a BOOLEAN when one of the above services is ServiceInvokeCompleted, I am then calling SetGlobalSessionBooleanValue({ name: "refreshCollection", value: true }) on the mashup with the collection widget, I am executing getCollectionWidgetData based on the refreshCollectionChanged event I have also tried

The parseDate function works when I run it in a service for testing purposes, but it does not work when I try to use it in a subscription that calls a service that uses the parseDate function. Please see below:   Working example: Converts PST time to JST time   Not working: Service called by subscription   Error: "Invalid format"   For reference: https://www.ptc.com/en/support/article/CS219448 https://www.joda.org/joda-time/apidocs/org/joda/time/format/DateTimeFormat.html

I can't import Manufacturing Apps.I installed DataExporterExtensionPackage.zip and then MED-61227-CD-085_F000_ThingWorx-Apps-8-5-0-extension-bundle.zip but I get an installation error. I send the Thingworx log files. Thank's

I want to store the Infotable data temporarily for some purpose. Is it possible to store the infotable data in Thingworx storage instead of storing in Database.  Kindly let me if there any solution available for my requirement.   Thanks in Advance, Sankarapandian.L.S

For some reason, I cannot display images in a grid widget. My service displays the images in the output window when I run it in the composer; however, when bound to a adv grid widget in a mashup, the image column does not display the images. The data type I'm using is IMAGE. I followed the steps in the instructions below, but the grid is not displaying the images. https://www.ptc.com/en/support/article/CS237433   This is my service output.  It displays the images.  This service is called within the other serviced that is called in the mashup.   This is the composer view of the mashup. This is the grid column format configuration window.   This is the grid column renderer & state formatting window.

Hi, We have deployed thingworx in client server  and 3 mashups which load dynamically every 15 seconds autorefresh interval  in a single mashup. In the mashup, we have services that are connected with SQL and not with Kepware. Suddenly, the screens freezed and shows blank and doesnt load.   In logs, We are seeing this issue. Is this issue related to the below mentioned log? We are often getting this log.  2020-02-13 06:32:24.796-0500 [L: WARN] [O: c.t.c.s.c.j.Jsr356ServerConnection] [I: ] [U: ] [S: ] [T: http-nio-8061-exec-109] Server WebSocket closed unexpectedly, unregistering from Server Endpoint [ws session id: b9d1, endpoint id: 47567, endpoint name: Navistar_TrackingScreen_KepwareConfig] An existing connection was forcibly closed by the remote host 2020-02-13 06:32:24.656-0500 [L: ERROR] [O: c.t.c.p.m.DispatchingServerCommunicationModule] [I: ] [U: SuperUser] [S: ] [T: http-nio-8061-exec-3] Bind request failed: [message: BindRequestMessage [requestId: 44546, m

How do I give color only to xaxis as in attached file?

Hi everyone,   I am using 8.5 and instead of of tab i want to use left column for choice(panel) . Example i want to make a 4 different pages and i want to have list of choices in left column. is there is any document or tips i can follow. below is the example-    

Please let me know the various levels of security which can be implemented in ThingWorx.   Thanks in advance.

Hey,   I try to evaluate the possibilities of the EMS Stuff. Today I try the file transfer functionality with no success.   I have a device where the ems runs on (as gateway) and a twx instance on a ec2 in aws.   My config.json lookes like this:   { "ws_servers": [{ "host": "xxx.xxx.xxx.xxx", (TWX IP) "port": 443 }], "appKey": "xxxxxxxxxxxxxxxxx", "logger": { "level": "INFO", "publish_directory": "/microserver/logs", "publish_level": "INFO", "max_file_storage": 2000000, "auto_flush": true }, "http_server": { "host": "xxx.xxx.xxx.xxx", (IP EMS runs on) "port": 8000, "ssl": false, "authenticate": false }, "ws_connection": { "encryption": "ssl" }, "certificates": { "validate": false }, "tunnel": { "buffer_size": 8192, "read_timeout": 10, "idle_timeout": 300000, "max_concurrent": 4 }, "file": { "buffer_size": 8192, "max_file_size": 8000000000, "virtual_dirs": [ {"other": "/microserver/other"}, {"tw": "/microserver/tw"}, {"updates": "/microserver/updates"} ], "staging_di

Hi all,   I'm trying to configure SSO for Thingworx, I followed this link, I got stuck at 'Browser SSO' configuration. (PFB PNG for reference)     Could any one help me with this.   Thanks in advance   /VR

can i add second persistence provider different from first persistence provider? ex. first persistence provider: postgresql second persistence provider: MSSQL Is a combination like this possible ?

Hello, I have installed PostgreSQL and Thingworx Founder Installer on two different VMware in RHEL . I want to use remote database connections to connect the Thingworx . I tried to install following command on Thingworx, yum install rh-postgresql10-postgresql-syspaths But it is showing no packages is available to install. Please do the needful as soon as possible. 

Hi,   While I am trying to copy file using File transfer Subsystem Copy from local to thingworx repository , I am getting error : "File transfer subsystem encountered an error: Source file 'sourcefile' not found"   Does anyone know what Permissions are required to setup for this as if I use Administrator login to copy. It worked fine.   Thanks, Harpreet

Hello ,  I created a geofence using an infotable inside an infotable,i.e (outer infotable as columns id and location ,column location contains one more infotable along with columns again id and location region.).The location region column is with location base type and id has a GUID as base type.I need to increment a id value in outer infotable. So that I can close the geo fence set. Service as  follows : region = me.map_regionCopy;if(!region) {params = {infoTableName : "InfoTable",dataShapeName : "Region"}; // CreateInfoTableFromDataShape(infoTableName:STRING("InfoTable"), dataShapeName:STRING):INFOTABLE(Region)region = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params);} //var result = region;var params = {infoTableName : "InfoTable",dataShapeName : "shape_for_geo1"}; // CreateInfoTableFromDataShape(infoTableName:STRING("InfoTable"), dataShapeName:STRING):INFOTABLE(shape_for_geo1)var result = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(par

hi ,  how can I put an interval in state definition using just < and <= , i want to do this :   alert1 : measure <10 alert 2: 10< = measure <20 alert 3 : 80< = measure <100 alert 4 measure >= 100   thank you in advance

hi community , how can i access to alertName from a service called in mashup ? - I made a service that update alert threshold for all things of a template. - I want to modify threshold from mashup (see picture) using textfield widget and call the first service when I click on a button (validate). please help , and thank you in advance.      

Subscription is not updating value to Things Using Thingworx Composer.   I have configured Template and Things. Set Alert and Subscription using JS. But, it is not updating values to Things Properties. Please help me.    Subscription Code: me.LastAlertLocation = 'East Weather Station'me.Destination = 'Dust Storm'

hi, I want to display a pdf file in a mashup (webframe), I Set the good url, but the problem is that when i click on a grid i download the pdf file instead of display it in  a webframe.   help please.

Hi everyone!   I have created one style theme to use in the value display widget in my dashboard and it is work well.   But I have created other style theme to use in other value display widget in other  mashup and when I binded that style theme on my value display all others changed too.   Is there any way to use one style theme to each value display?   Regards Leonardo

Hi,   I am using Thingworx Execute Service connector to execute a service from other Thingworx instance(consider as X), The entity type is not loading even after successful connection.       If I connect to the local server or other than X, I could able to load everything. How can I trace the problem in this case?       Regards, Janakiraman P

Hi, I'm copying the csv file from EMS to Repository in Thingworx. So often in Application Log I'm seeing these kind of errors. I think it is because of conflict between (1. copying file in Thingworx Repository and 2.another program is updating the same file at the same time). Is there any idea?   Thank you! Muhammad Naeem

Hi,   I have just started exploring the ThingWorx and tried to fetch the historical data (time series) using get QueryPropertyHistory service. We can fetch using filters like date, record count, sorted etc. I want to write a custom service that does aggregation operations on this data and persist this aggregated data in some form.  What are the supported ways for handling such huge data, transform it and persist?   Thank you

Hi ,   I am unable to see columns in Configure grid columns window ,  i have used external database and  getting data using query service  . output will be in infotable. already i have bound all data to grid and i can see data in grid . but i want some space in Grid columns you can see attached files.   Thanks