ThingWorx

Hi, I wanted to delete multiple rows in sql database. I have given the input as infotable which has default datashape that I have binded the grid to. The grid data selected rows I am giving as input to the multi delete service infotable ip. I tried using the grid advanced but the code does not work. The Things["Bobcat_DBConfig"].Delete_Organization(params) is the service which has sql query to delete the row ( WITH cte AS(SELECT ROW_NUMBER() OVER(ORDER BY org_id) AS RowFROM Organization) DELETE FROM cteWHERE Row = [[rowNum]] )   How could I resolve this?    Thanks in advance, Shalini V.

Hi, In my sql query I am trying to search words in column having letters that I search for. I am using LIKE operation to perform this but it doesn't work. It works fine in sql server but in TW it shows error.   TW: select * from (SELECT DISTINCT STUFF(WORK_ORDER.order_number,1,8,'') as JOBNum FROM WORK_ORDER) t1 WHERE t1.JOBNum LIKE '%'[[input]]'%'   OUTPUT ERROR: Unable to Invoke Service SequencedProductionOrder_JobNumMatch on NAVISTAR_DB_CONFIG : Execute Query failed: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '@P0'.   SQLSERVER: select * from (SELECT DISTINCT STUFF(WORK_ORDER.order_number,1,8,'') as JOBNum FROM WORK_ORDER) t1 WHERE t1.JOBNum LIKE '%234%' **WORKS FINE**   How can I resolve this and use the operator in TW?   Thanks in advance, Shalini V.

I sometimes have a service write to a specific field in the user extensions in the background.  Other services allow a refresh trigger to the service, but the user tab does not.  How does the user extensions list under the user tab get updated?

I have only created 3 columns in the grid. The fourth one appears as an extra and there is no need for it. Removing this extra column will greatly help in improving the look and feel of the grid. So how can the last column (unnamed column in the marked in red in the image) be removed.

Hi Team, I have installed TWRX 8.4.1 with H2 persistence provider, but is not able to start the WebApp on tomcat.The following error is displayed:   Not able to get connection from the underlying database.   I suppose starting from Thingworx 8.4+, a username & password is required in the platform-settings.json file for H2 persistence provider also.Below is the related content of my platform-settings.json file:   "PersistenceProviderPackageConfigs":{ "H2PersistenceProviderPackage":{ "ConnectionInformation":{ "password":"twadmin", "username":"twadmin" } } }   Please help regarding what is the default username & password for H2 provider.

good afternoonWhen installing ThingWorx Analytics, opt for the following error message:   WARNING: You must configure Analytics Extension to communicate with yourAnalytics Server. Open the Analytics Builder Settings page within ThingworxComposer and select the AnalyticsServer Thing you want to connect to. I used the following documentation to perform the installation: https://www.ptc.com/support/-/media/181948D67021428B90F78BA7F1231083.pdf?sc_lang=en Obs: Installing graphical mode on page 21 onwards and requirements have been met.

Hi Folks,   I have installed TWX 8.3 as per the Guide but not able to Load Composer page and getting 401 error as shown below in the attached snapshot. I have gone through all the similar posts on the community but no luck in my case. I am guessing its related to DB but not sure and thus need your help to fix this.     Steps done: 1. Apache 8.5 installed 2. JVM checked: C:\Program Files\Java\jre1.8.0_102\bin\server\jvm.dll 3. Java options added:  -Dserver -Dd64-XX:+UseG1GC-Dfile.encoding=UTF-8   4. PostgressSQL 9.4 installed 5. Added new login Role "twadmin" with required privileges and put same password as in "platform-settings.json" file. 6. DB setup and Schema scripts executed successfully but got 57 tables shown in the schema. 7. Following folders added. -ThingworxPlatform (platform-settings.json) -ThingworxPostgresqlStorage (PG_9.4_201409291) 8. Provided required access to above folders. 9. Updated Enviroment System variables with required paths of ab

Hello everyone! Using the JDBC Connector Extension and the downloaded xlSQL JDBC driver for Excel, I created my own extension for connecting to Excel as a database. But there are problems with configuration. Here are two options:   JDBC Driver Class Name: com.xlSQL.jdbc.DriverJDBC Connection String: jdbc:xlSQL://localhost:8085;databaseName=DBconnectionValidationString: Sheets("Sheet1").Select   or   JDBC Driver Class Name: com.excel.jdbc.DriverJDBC Connection String: jdbc:excel://localhost:8085;databaseName=DBconnectionValidationString: Sheets("Sheet1").Select   In both cases, the connection to the database doesn't occur. First of all, I don't know exactly where my database ("DB") should be for the proper connection. Maybe there is someone here who worked exactly with Excel and will indicate what other mistakes I made when filling out.

suppose i have written a service in which i want to use session variable within a range that will be provided dynamically from URL and it should loop in that accordingly. will it work fine if i provide different ranges in two different in two different systems at a time? same service will work fro bot ranges at a time?   Thnaks in Advance Aditya

Hello Everyone;   I am using ThingWorx 8.3.0 Version with MS SQL Database connection. After installing ThingWorx analytics, ThingWorx start to do not accept any Save requests. For Example i try to add a property a thing and hit save button. It shows me a diolog box which says "Active Edit ... user is currently using this entity". It doesnt matter that pressing Overwrite or Discard buttons. Also i cant create a new thing. When i look the Active Users section, my username seems to repeat so many times with same Last Connection timestamp.  Database connections seems to be fine. For example when i execute a SQL Select service , it works. Current services also works but i cant make any permanent changes.   Did anyone encounter such a problem or how can i solve this issue.    Any help will be appreciated.    Thank you. Murat Can Berber

Hi,   I was wondering regarding web frames. I have attached a picture of a static mashup and a web frame. There is a grey border around the web frame which in this case shows a .jpg of the google logo. This is also the situation in responsive mashup with layouts.   My question is. Is it possible to get rid of the grey border? - If not, where do I propose a change/improvement?  

Hi,     I'm trying to get data from weather web API. var params = {//proxyScheme: undefined /* STRING */,//headers: undefined /* JSON */,ignoreSSLErrors: true/* BOOLEAN */,//useNTLM: undefined /* BOOLEAN */,//workstation: undefined /* STRING */,//useProxy: undefined /* BOOLEAN */,//withCookies: undefined /* BOOLEAN */,//proxyHost: undefined /* STRING */,url: "https://api.openweathermap.org/data/2.5/weather?lat=16.4974&lon=80.6458&appid=appid", /* STRING *///timeout: undefined /* NUMBER */,//proxyPort: undefined /* INTEGER */,password: "password" /* STRING */,//domain: undefined /* STRING */,username: "username" /* STRING */}; // result: JSONvar myJson = Resources["ContentLoaderFunctions"].GetJSON(params);result = myJson;//me.Outside_Temperature= myJson.main.temp-273.15;//me.Outside_Humidity = myJson.main.humidity; It is giving output as below [message: Execution error in service script [OutSideTemp] :: sun.security.validator.ValidatorException: PKIX path building fail

Hi!   I develop a C SDK based application, which uses encryption. A server certificate is loaded with twApi_LoadCACert() function and everything works fine except tunneling.   When I try to establish a VNC connection (with using of the Remote Access Widget), I get this error: "TW_VALIDATE_CERT: Certificate rejected. Code: 20, Reason = unable to get local issuer certificate".   By default, the twTunnelManager should use the same twConnectionInfo structure as twApi so that all twConnectionInfo settings should be shared by twApi and twTunnelManager. So, I don't understand why I have this issue with tunneling only. Other subsystems, including the file manager, work fine.   I tried to load the certificate file for the tunnel manager with using of twTunnelManager_LoadCACert() function, but it didn't help. What really helps is just calling of twTunnelManager_DisableCertValidation(), but I want to have the connection to be secured.   I have found this article: "TW

Hi all,   I'm beginning with ThingWorx Analytics and I'm using the guide below for orientation:   https://developer.thingworx.com/en/resources/guides/analytics-builder-quickstart   I can do the example from guide, however, I'm with very difficult to understand how the Analytics works. Someone to indicate some other guide that it can help me?

Hi   I want to update menu group association and menu items group association  from service/ i cpuldnt able to find any snippets or service?   (By using Rest API (get request)  i can able to  see menu and sub menu items  but i cant able to update menu items from Rest API)

Is it possible to configure SSO on ThingWorx without using PingFederate?  All the documentation seems to be forcing Ping, but if possible, we would like to simply use SAML 2.0 with a direct connection to our IdP. For reference, we would be using ThingWorx version 8.3.

How to install thingwatcher for analytics?

For some reason, my service stopped working.  It used to work, but I think after I duplicated the mashup and started using the duplicate mashup, it stopped working.  When I run the service by itself in the helper Thing, it works.  I get the error when I run it from the mashup.  The bindings are still correct and there seems to be no issue with the service and the inputs to the service.  The input for the user group name comes from the value field of a list.  When I bind the service that populates the list to a grid, the value field is there so it is not "null".  Please see the code below.  It seems that for some reason, the AddMember method is not getting or cannot get the name of the user group entity. The error message I get is as follows:   "User Creation Error: TypeError: Cannot call method "AddMember" of null"   I added try/catch since it created a ghost user every time I ran the service from the mashup.   ********************

Hello guys,   I'd like some help with some questions I'm facing based on the GoogleMaps Extension and the Thingworx data structure and how they interact with each other: - How to store data such as routes defined by the user in the GoogleMaps Widget; - Track vehicles circulating along these routes; - User defined stops added that are independent (multiples routes can have the same stop) and how to store them. Basically, I need help understanding WHAT these entities will be and HOW they will be stored (remembering that they will be defined by the user).

Hi, I am trying to disable selection of a particular row in list widget(drop down) This option is not dependent on any functionality. That particular field should always be present on drop down menu but it should be unselectable.   Similarly, I am also trying to disable selection of a particular row in advanced grid.That particular field should always be present in advanced grid but it should be unselectable.  Any lead on this is appreciable.   Regards, MishiK

Hi, Could any one help with the java script to check whether the entered input (text box) contains special characters or not?   Thanks in advance, Shalini V.

@slangley    On click of an icon in the header i need to display some user details. And In that we need to have a logout button and make the user logout.   Can we implement it in thingworx??

Hi,   I have installed Thingworx 8.4 and after i logged in, i am trying to change composer preference from general information view to normal view but it is not changing. Attached the screenshot.Please help me with this.    

Hi,   This issue is really testing me right now.Yesterday I had this issue, couldn't get ThingWorx to launch - url returned "HTTP Error 404. The requested resource is not found." Through a combination of restarts and clearing the cache I got it working, did my configuration in Thingworx, got data moving into my mashup etc...Then I installed the Experience Service, still everything in thingworx was working - I was able to connect from local and remote (external IP).   Today - nothing was working, Tomcat was shutting down automatically. Moved the "-Djava.library.path=C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps" to Windows Environmental Settings. Tomcat then started and stayed running. I still get Error 404 on the http://Localhost:80/Thingworx/  (yes, I used port:80 on the tomcat install).   I've attached the Thingworx Platform logs, Tomcat Logs & Platform-Settings.json.   This is all hosted on my own Azure VM, Windows Server 2016.   An