ThingWorx

Hi,   We have a TWX 8.2.5 on a Windows Server with MSSQL DB in an offline Production Environment. We tried to update some parts of the running TWX Application (Mashups and some backend functionality in Things etc.) But we can not update entities in Composer or import new Extensions because of this generic error: [[1'018] Data store unknown error: [......"   What are possible causes of this error? - Space on devices is good >20GB on the two harddrives. - Memory is ok with room for more - Tomcat and MSSQL restarted serveral times - Tomcat configurations without Memory Settings   What can we try to fix this error? We didn't have access to the instance all the time. So I want to check all possibilities before connecting again. Attached a small screenshot from logview

 Hi All , i have created table contain Arabic language as show   and create Export Widget to export all data from infotable in to excel sheet but all Arabic letters shown as you see    Dose anyone have solution for this ?

Hi,   I have a mashup in which on button click I am showing a list as sub menu to that button. The submenu is having a service binding which is providing items list as well as mashup name to which the navigation should happen. I am showing that navigated mashups as popups.   This thing is working well on first sub menu selection. It shows the popup according to our selection. If the popup is closed and the button is clicked for showing list of sub menus then it shows the previous selected popup (mashup) automatically. It looks that there is some issue with the binding and 'selectedRowChanged' event.   The same implementation is working in Thingworx version 8.3.1 and not working in 8.3.3.   I am expecting some help to fix this issue. Please comment below if you need any more information.   Thanks, Chetan Purohit

I have not been able to set the MaxHeaderHeight on the Advanced Grid using the JSON Configuration option.    I've tried: "maxHeaderHeight":"18", "maxHeaderHeight":"18px", "MaxHeaderHeight":"18", "MaxHeaderHeight":"18px",   at the root of the JSON and in other locations and nothing. Has anyone been able to do this and could share the solution please?

Hey, did you get a response for this? I'm experiencing the same on twx 8.2.6. Thanks Nico  

I cant able to figure out the following Error I am Downloading Json Files from FTP to System Repository and the parsing the file one by one and update to the Corresponding Thing If I Check Script Log Given Follwing Error "[message: Execution error in service script [HT_IP_Data_Entry_Services] :: File Does Not Exist]"  But if Check in Application Log it will given following error  it.sauronsoftware.ftp4j.FTPException [code=550, message= The system cannot find the file specified. __ Win32 error: The system cannot find the file specified. __ Error details: File system returned an error.__End]__ at it.sauronsoftware.ftp4j.FTPClient.download(FTPClient.java:3479)__ at ftp_extension.FTP_Utils.DownloadFile(FTP_Utils.java:170)__ at ftp_extension.FTP_Server.DownloadFile(FTP_Server.java:114)__ at sun.reflect.GeneratedMethodAccessor205.invoke(Unknown Source)__ at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)__ at java.lang.reflect.Method.invoke(Unknown Source)__ at com.

hey Can a javascript service auto updates its own results each minute? Thanks to understand the problem better i have a too long message to display on a value display widget, so i divided it to 3 services and i want every service to appear like after 20 sec from the other repeatedly 

Hi, I try to create a metadata file but my data contains double or null value. When i try to create a dataset Analytics show me this error: Dataset Create Job with jobId: 56537633-72c0-46eb-ad6a-9e3206c2f659 failed with error:java.lang.NumberFormatException: empty String I think that in the file i don't accept the value null but i don't know how do. Some advice ? below a part of my metadata file. {"fieldName": "L0_S2_F36","values": null, "range": null,"dataType": "DOUBLE","opType": "CONTINUOUS"},

I am trying to set properties of a remote thing from mashup dashboard. I can set properties using one of the following 1.Mashup only service -SetProperties 2.Snippets that can be called from custom service -UpdatePropertyValues -UpdateSubscribedPropertyValues -SetPropertyValues   All of the above have output type NOTHING.I want to retrieve the output(i.e http response if any) and display error message in mashup if service call failed due to some reason. Eg: Edge device not connected or some custom error message from remote thing's script handler   Is there any way to retrieve the response/output when trying to set properties to remote thing from service?   Note: Thingworx Composer displays error message when trying to set property from Thing's properties.Looking to implement  a similiar functionality from thingworx dashboard.

Hi, we are having an issue with how the time string is displaying in a grid widget (in fact all relevant widgets). We are using the  default format token 'dateTimeFormat_Default'  which has the value(s) 'yyyy-MM-dd HH:mm:ss' in the Default localization table 'yyyy-MM-dd HH:mm:ss.SSS' in the System table all other tables have no value. In the grid widget the text displayed is 'Thu Jan 17 2019 16:52:04 GMT+0000 (Greenwich Mean Time)' . Column Renderer & State Format settings are: Renderer = DATETIME Format = dateTimeFormat_Default Fixed Style If I bind the single rows time value to a Value display widget and set the renderer to DATETIME & dateTimeFormat_Default I don't see any value. If I set it to STRING I see 'Thu Jan 17 2019 16:52:04 GMT+0000 (Greenwich Mean Time)'. I have tried changing to other date format tokens but they have no effect at all and I see the same strings. We have just upgraded to 8.2 (from 7.3). Everything worked fine in 7.3.

I executed a sql query service, when i am sending the output to a datashape and trying to name that datashape, an error is displayed as "INVALID NAME"   Though, I am not giving spaces in datashape name..    

Hello, I am uisng Thingworx 8.3 and Windchill 11.1. In Windchill connector there is a service called "GetCreoDataView" .  This service returns thumbnail, structure, files. Files in service consist of file name, linkHTML, URL, icon . But, I am not able to download file. linkHTML is not working and also URL.   How to use them, or is their any other way to download representation files?       linkHTML I get is ,         http://gt026.galaxy.com:8080/Thingworx/MediaEntities/ptc-windchill-integration-connector-proxy/Content/servlet/WindchillAuthGW/wt.content.ContentHttp/viewContent/tank_drw.pdf?u8&HttpOperationItem=wt.content.ApplicationData%3A586480&ofn=tank_drw.pdf&ContentHolder=wt.viewmarkup.DerivedImage%3A586468&forceDownload=true&wt.effectiveUid=Administrator

I am getting Object Object written in infotable if I make a cloumn editable and the value is null there and that cell comes as non-editable   Related to previous post

Hello Guys,I have big difficulties with configuration of LDAP authentication in ThingWorx 7.3.2-b39 (I am not LDAP expert at all).I have created DS entity using com.thingworx.security.directoryservices.LDAPDirectoryService and configure it to some publicly available LDAP, and it works correctly:Obviously I had to create user Entity in ThingWorx manually - which is very bad and I believe with this DS it is not possible to create users automatically. But stil - I can login to ThingWorx using LDAP credentials (not ThingWorx credentials).Although, I've figured out that I can use different class for DS Entity: com.thingworx.security.directoryservices.ActiveDirectoryDirectoryService, which has all necessary functionalities for user/group management. Unfortunately, I am struggling to get it work, I have tried hundreds of different configuration combinations and the DS authentication seems to not work at all (there is nothing in the logs, HTTP basic authentication is activated so eventually I

Hi, i want to create a model with a dataset of industrial plant. I have  found only the file.cvc but Analytics want also the file json. I search to do the file json by the file csv but i don't know well how i can do. After this i want to use the model that i will create with this dataset( i know how create a model by a dataset) to test it with other data to know if it predict the failure or not but i haven't idea how to do this. Someone have any advice for these questions ? Thanks. 

I have a collection widget made up of cells which act as columns. Each column is comprised of value displays which, when clicked, open a pop-up with more information (5-8 value displays per column).   The client using the mashups have reported an issue with the value displays not being clickable within the collection widget.   The client is viewing the mashups on an iPad Air 2, has tried in Chrome and Safari, and is running the latest version of iOS (12.x).   I have tried changing the z-index of the value displays to ensure they sit on top of the stack, but I have quickly run out of other ideas for workarounds. This issue did not occur when formerly using the repeater widget (although there was a separate issue with load/unload that made the repeater not viable either).   Are there any known issues with compatibility with iOS 12.x? Or are there any other ideas for trouble shooting? The issue coincides with other buttons/value displays necessitating double clicks to

Where do I run this command?   Re:  post

Hi, After reading “Deployment Architecture Guide for ThingWorx Version 8.x, version 1.1”, I can’t find documentation to install and configure Thingworx foundation on Google cloud. I heard that it is supported but I can’t find any oficial documentation to implement it.I will appreciate any help to install the platform on Google. Thanks in advanced.

Hi,   In Thingworx composer v7.4.1, I could duplicate a service in a Thing and save it as a new service, however i don't see the same function in a ThingShape.   Is there any suggestion?   My Bests, Hung Tran

Hello Everyone,   I would like to use the SpotlightSearch function from System/Resources/SearchFunctions. When using Postman to execute this service with a Rest Call I get a "405 Method not allowed Status". I use the following call: POST https://IP-Address:Port/Thingworx/Resources/SearchFunctions/SpotlightSearch The Authorization credentials are correct and the calls work for services of normal Things.   Am I missing something, or why is that not working?   Another Thing I would like to know is how to define the "Tags" parameter for the SpotlightSearch in the body.   Any help is appreciated very much.   Best Regards, Dominik

When I run the thingworxPostgresDBSetup.bat script, I am getting the following error:   psql:./thingworx-database-setup.sql:14: ERROR: could not create directory "pg_tblspc/16404/PG_9.4_201409291/16405": No such file or directorypsql:./thingworx-database-setup.sql:16: ERROR: database "thingworx" does not existPressione qualquer tecla para continuar. . .    

Hi, So I have a mashup which selects a number of properties for a thing. It then loops through each of these properties and Queries the property history. The goal is to take each history infotable and add it to an overall history table with all of the properties and timestamps. The following tables may give more of an idea:   table1 - overall table (starts without any values) timestamp Property1 table2 - property1 history table timestamp Property1 1 x 2 y So after the first iteration table1 will look the same as table2. For the second iteration/property the overall table should become: timestamp Property1 Property2 1 x   2 y   Table3 - property2 history table timestamp Property2 1 z 3 x After joining the overall table to the second property table, it should become: timestamp Property1 Property2 1 x z 2 y - 3 - x The method for this should work for any number of properties. I tried using a full join then a distinct but

Hi, after an installation on windows server 2016 of thingworx fondation 8.3.2 and thingworx analytics 8.3 on the same pc, i try to do this guide https://developer.thingworx.com/en/resources/guides/analytics-builder-quickstart/abq-conclusion. The server apparead connected but when i try to do a model the validation set is nan and i don't see the prediction scroed and the model result. I don't know well the reason, any suggestions?

  Hi, I have followed  https://community.ptc.com/t5/ThingWorx-Developers/rest-api-returns-an-html-page-How-to-access-the-data/m-p/501682 But still it seems there is some problem.    I am using this piece of code from a node application, to get a property value using REST.   var data = JSON.stringify(false); var XMLHttpRequest = require("xmlhttprequest").XMLHttpRequest; var xhr = new XMLHttpRequest(); xhr.withCredentials = true; xhr.addEventListener("readystatechange", function () { if (this.readyState === 4) { console.log(this.responseText); } }); xhr.open("GET", "http://localhost:8080/Thingworx/Things/ThingName_Example/Properties/uploadPath"); xhr.setRequestHeader("Content-Type", "application/json"); xhr.setRequestHeader("Accept", "text/xml"); xhr.setRequestHeader("appKey", "PPPP9f16-XXXX-XXXX-XXXX-1b719e2UUUUU"); xhr.send(data);       and the result i get is :-  <HTML><HEAD><TITLE>Property Value For CMU_TH_DOCUMENT

Hi,   I am trying to retroactively insert an alert via a service into the alert summary and history with a custom date time. I know I can insert into the alert history by just inserting into the AlertHistoryStream. However, I am not sure how to insert into the Alert Summary. If this is not possible another option would be to retroactively fire the alert even with a custom date. We are trying to achieve complex alerting, but we want to leverage as much of the built in alerting as we can.   Thanks, Brandon