IoT & Connectivity

Hello Velkumar,   I am also curious on this topic. Were you able to find a solution?   Regards,

Hi, Im trying to connect to SQL Server DB, and this error is shown, any idea how to fix it? Error Getting Tables : The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target". ClientConnectionId:######-####-###... 

Hi! I have previously worked with ThingWorx Edge ADO Service and connected to Excel-spreadsheet to get some information. Now this extension, as I understand it, is no longer available, so I can't download and install it on my new computer. What other extensions/services can be used for the above task? That is, speaking more broadly - for remote access and collecting data from certain database (including Excel)?

Hello Everyone, I created one column of Boolean type and made it as a edited column.Some times back when user selecting that column from any row it is calling another service and it was working fine.But today I am facing an issue that it does not working now means when I am selecting that column from any row it does not populated data into edited table and does not coming with infotable. Can any of the you faced the same issue so you can help me I need it on urgent basis. Thanks & Regards,Yash Malik

All, >I'm trying to connect Microsoft Excel with Kepware through DDE. for the same i need to do some changes in settings configuration.   >But settings field asking for User Manager Credentials which im unable to enter. >Can Anyone suggest which one will be the credentials or where can i find these details !!!   Awaiting response !

I am storing same date in three variables. And subtracting days in one variable. But all variables value getting changed. Can someone pls explain why this is happening?  This is the code: Input & Output Datatype is datetime: var d1 = DateInp;var d2 = DateInp;var d3 = DateInp;for (var sol=1;sol<=7;sol++){ d1.setDate(d1.getDate()-1); }var result = d3;      

Hello, I want to navigate to File Repository's folder from UI through service.Is anybody knows any approach? Please share. Thanks,Meghna

How to send simulated datas to thingworx remote thing for development and testing ?

Hi! After installing ThingWorx Flow I go to Google Chrome and enter the address in the line according to the first section of this article: http://support.ptc.com/help/thingworx_hc/thingworx_8_hc/en/#page/ThingWorx/Help/Integration_Orchestration/InstallingTwxFlowInstallationAccess.html After that I get such an error.  How can I fix it?

we have provided organization url to the client like - "ip-address:PortNumber/Thingworx/FormLogin/OrgName"If client tried the url -"ip-address:PortNumber/Thingworx/", they should not landed in composer page. Instead we can show message "Access denied". How to do this?

Hello I am trying to implement sorting in advance grid but i am not able to do so. Any help will be appreciated. Thanks 

Hello I have a use case where i want to freeze a column in advance grid widget during Runtime. Is there a way in thingworx through which we can do it? ThanksRohan

Hey @zyuan1 ,same use case over here, shifting from Postgres to the Influx as an second persistence provider. Do you know any best practices to transfer the data of Value stream from the Postgres to the Influx ?, since moving forward it is influx for us.ThanksShashi.

The Explore ThingWorx Asset Monitoring and Utilization in the Guides have a Demo Link,but it doesn't work now.  Guides Link：https://developer.thingworx.com/en/resources/guides/thingworx-asset-monitoring-amu-app Demo Link：https://pp-2108182053lk.portal.ptc.io/Thingworx/Runtime/index.html?master=PTC.FSU.COREUI.MenuConfiguration.MasterContainer_MS&mashup=PTC.FSU.COREUI.MenuConfiguration.MasterContainer_EP&appKey=072bdfe6-7c51 -468d-a237-a3de91c526c0&x-thingworx-session=true 

can we add some more properties in user extensions. how to do that?

Any extension available to provide browser option for user in mashup to upload images to thingworx server.

In thingworx, How to give option for user to rest their password through mashup?

Hi,I have installed Thingworx 9.2 and imported the licenses correctly (I can see them correctly from the Licensing Subsystem Settings).  I was wondering if there was a way to get rid of them in case of errors, in order to import the correct licenses. Thank you.

Hi,i have created Organization and login page and give the permissions to all entities so that after login all entities should be visible but after login i didn't see menu and in logs it's showing an error like "Invalid Request Exception: File Repository [SystemRepository] does not exist"  please share some solution on this.

Hi,i have created mashup and using collection widget. In base mashup i used bar chart and gave some state definition according to the values and color code. but after binding the base mashup with collection widget it's not showing data according to state definition. Below sharing screenshots of color code and collection mashup:-1:- color codes according to values2:- collection widget screenshot  

It seems that when I combine infotables with "union" their meta data do not get combined.  Is there a way to combine the meta data as well?  Meta data are fields such as source, timestamp, tags, location, etc.  The infotables are query results from a data table.  When I set the output of the service as "INFOTABLE" and "infotable type" to "is Data Table", I still do not get the meta data.   let tableLength = someInfoT.rows.length; for (let x = 0; x < tableLength; x++) { let row = someInfoT.rows[x]; //Your code here let query = { "filters": { "type": "And", "filters": [{ "type": "EQ", "fieldName": "SomeID", "value": row.SomeID }, { "type": "LT", "fieldName": "SomeDate", "value": oneYearAgo } ] } }; let queryResult = Things["SomeDataTable"].QueryDataTableEntries({ maxItems: undefined /* NUMBER */ , values: undefined /* INFOT

Hello,I have 10 things(eg.) which has a common service called fun1() which outputs Infotable as result by making an external API call.I would like to union the infotable results from all the 10things fun1() call finally.Instead of looping through each thing and waiting for the output, I would like to run them in parallel as the output is independent of each other and finally once we get the result of all i have to union them to give one result. What is the best approach in Thingworx.  Thank You!! 

This is so sad news for iOS user's including me. are you sure there is no iOS version of this app is available on Apple App store or any extension for the apple.   gb whatsapp        

Hi Team,I'd like to check whether KB5004442 impact on all connections between TW(9.2.3) tools and other servers or not.

Hi All,There was an error while creating things with the service as a non-administrator user. (I also granted permissions in to the EntityServices for user and Usergroup. In theThingWorx version  : 9.1I'm getting this error:        JavaException: com.thingworx.common.exceptions.InvalidRequestException: Not authorized for Create.>>Concerning the issue, I need assistance.regards,hareef