ThingWorx

Hello,   I'm having an issue with sql queries in thingworx that gives this error:     "Unable to Invoke Service DBL_datalabdb_R_EQUIPER_SelectAll_SQL on DBL_datalabdb_SQLFourFusion : Execute Query failed. Please check Database logs for more details."    any clue why it is giving this error?    Ps: i have data coming in on applications (indirect link with db : ok)  which is strange 

Hello Previously I got a link where i was able to get sample entities for Grid to utilize dynamic configuration. Can some one please provide the same or may be can share any sample entities to set columns dynamically. Thanks

Hello I am not able to apply Filter in Data table mashup in Thingworx 9.4Any help will be appreciated Thanks

Have noticed big efficiency problems during our DevOps are preparing all their starts and write/checks their scripts and I try to use Composer.Normally server works correctly, reaction on anything is "immediate", mostly <1 sec delay, sometimes can happens 5-10 seconds delay in reaction on saving, opening entities, etc. But longer delay happens... once per hour?When DevOps tests are made... it takes 1-2 minute to load page, sometimes even 5 minutes.Is that normal? Any solutions (different than organisational/time slot reservation for DevOpS and developers)?

Hello,with the service: result = Things[thingName].GetServiceDefinitions({    category: category /* STRING */, ,    type: undefined /* BASETYPENAME */, ,    dataShape: undefined /* DATASHAPENAME */}); i can get all servicedefinitons of services of a special category.But which Sting do I need to use if i want to get all uncategoriezed services?I've tried *Uncategoriezed*", "'Uncategoriezed*", "**Uncategoriezed**", " ", "", "uncategoriezed", "*uncategoriezed*", "**uncategoriezed**", nothing.All of them are wrong.Does anyone have any idea what the right string is? We use thingworx 9.1.8 and 9.3.7.

Every 30 minutes, without fail, my Application Log is inundated with 22 SystemMetricLogRepository messages at the Warning level. This can make it hard to read my own error logs and has become a source of frustration for me. Is there any way I can make it so that I don't see these logs, reduce them down to a single Debug/Trace level message that tells me the metrics were measured, or have them be set to the Debug/Trace level altogether so they are out of my usual log viewing level?

 let entry = Things["Allied_Entries_SCW1.DT"].GetDataTableEntryByKey({key:"1713786015000SCW1E-AS-02"}); logger.info(entry.rows); entry.rows[0].versionData.RemoveRow(0); versionData is an infotable but i am still not able to remove the row with its index. As you can see this is an infotable why i am unable to remove it. any idea please? <========================================================================================================> FURTHER TESTING  I am removing row and updating that entry with removing that row but it is removing row at run time means i get what i want as an output but it not updating it in datatable. Anyone has an idea?

I had configured SSO to ThingWorx(which had SSH configured) using Azure AD SAML authentication.Now I want to setup SSO for ThingWorx with no SSH configured. And I found somewhere that it had to be done without using SAML authentication. Need suggestion on how to achieve this.    

Scenario:I have three mashups in total 1) Main Mashup2) Popup Mashup 13) Popup Mashup 2 On Main Mashup I am navigating to these above two popup mashups. I have opened Popup Mashup 1 then Popup Mashup 2 means The popup mashup 1 was still opened when i open popup mashup 2 then i close the mashup 2 and onclose of this mashup i evlautate this EXPRESSION which returns Output=true I send this output = true through the mashup parameters in popup mashup 1 there i have event router and i want to close this popup mashup 1 and i have bind the closeifpopup event with changed event of this event router as below you can see. but it does not work when i close the popup mashup 2. The popup mashup 1 remains opened BUT when i close the popup mashup 1 manually and then open it right after then it closes automatically means now logic is working. Now if i open it again it gets close.  Any one has an idea that how it could be resolved? I have tried Autoevaluate and fire on

How to get an output as float with 2 decimal values from valuestream without using for loop- we tried using querynumberpropertyhistory to get an output as float values with2 decimal points with for loop. but for loop is creating an performance issues on server. so tried to bind querynumberpropertyhistory service to line chart and tried to to achieve y axis values as float with 2 decimals but its not working on line chart. its working only on y axis labels not values. can anyone knows how to achieve this? Thanks!!!

Hi, everybody.Why is it that a database query has 5000 pieces of data, but a query in thingworx only has 500 pieces of data?

hi expert , i can not solve problem , please  how to solve problem  var params = {FileRepository:"filetest/" /* THINGNAME */,Rotated90Deg: false /* BOOLEAN */,AppKey: "8204jef3-7l1f-45b7-a2cd-jf55547e7c0e"/* STRING */,ServerAddress:"http://delbi3dev.analytics.com:8080/Thingworx/Runtime/index.html?mashup=attachment3" /* STRING */,OutputFileName: "FileName.pdf" /* STRING */,Resolution:"1240*1775"/* STRING */};Resources["PDFExport"].CreatePDF(params);    Error executing service pdfRenderingcreate. Message :: Could not launch browser. Build info: version: '2.52.0', revision: '4c2593cfc3689a7fcd7be52549167e5ccc93ad28', time: '2016-02-11 11:22:43' System info: host: 'PTC-DEV-SERV-AWS', ip: '172.16.0.59', os.name: 'Windows Server 2019', os.arch: 'amd64', os.version: '10.0', java.version: '11.0.14' Driver info: driver.version: JBrowserDriver - See Script Error Log for more details.  

Has anyone else been able to connect Thingworx to a database using Kerberos authentication and provide any tips or high level steps on what files must be created and where? I'm trying to connect to a Hive database using a Persistence Provider with the "GenericJdbcPersistenceProviderPackage".  I've also tried connecting using a "Database" Thing with no luck.

Hello Everyone,Good Afternoon, I have a folder named "photos" in a ThingWorx repository Thing which keeps on updating as & when new images are added to it. I wan to download this folder "photos" which contains multiple images on click of a button from Mashup. Can anyone help me out with this. Thanks in advance. Regards,Aditya Gupta.

For ThingWorx in windows, iam using Ctrl+Alt+F9 shortcut to debug mashup. But what is the shortcut to use debug for mashup in Linux, Ubuntu ??

I am giving the input false but still validator is taking it as a true. Can anyone has similar experience about it? MASHUP 1 and from here i am sending the value to another mashup which is false but another mashup is still taking it as a true why?     MASHUP 2 : this validator execute when the value of the mashup parameter will change which i am sending from mashup 1. 

Hello all TWX masters. I installed TWX  9.3.6-b1323 from installer  and I have strange behaviors with time. I have some records in MSSQL DB with time 14:05:56 but when I execute it from TWX side I have 16:05:56... I checked server time - its okI checked DB time - its okI execute TWX service like getDate() - its okI checked Tomcat JVM setting (-Duser.timezone=UTC) so its ok...I have empty mind where it could be a problem... Best regards,Jan

In Master mashup, How to get data from a service which output is infotable. I getting "no data to display" in grid from an infotable service . while , that service is  working properly in other mashups.

root@iotbblr1l002:/home/ubuntu/ThingWorks_Kepware# lsb_release -aLSB Version:core-11.1.0ubuntu2-noarch:printing-11.1.0ubuntu2-noarch:security-11.1.0ubuntu2-noarchDistributor ID:UbuntuDescription:Ubuntu 20.04.4 LTSRelease:20.04Codename:focalUnable to install edge on 20.04 . Getting following error .is the agent is supported in 20.04? if not what i have to do to make it run in 20.04 ? any containerized way is available?

Iam generating n number of text boxes in collection based on the user input. If user provided value 10 in main mashup, 10 textboxes will be created in collection. Once User entered values in all 10 textboxes, the requirement is to collect all 10 values in main mashup in form of 10 rows in infotable. How to achieve this? Tried Methods:I tried with global mashup parameters, the first value is repeatedly replacing with next consecutive values while fetching in main mashup.When I tried saving values in UserExtension properties from childmashup, some of the values are missing when service tried to update n number of rows at same time. Both these methods doesnt worked.

Could you please share a sample or template of the specification sheet to create a content using ThingWorx?I would like to create an AR content using ThingWorx and Vuforia Studio.However, I am a beginner in ThingWorx and do not know what items and values should be specified in ThingWorx.Therefore, I would like to know what items typically need to be specified in ThingWorx when creating a content.I expect that each category, such as "Thing" and "ThingShape," has standard items that need to be specified.If I can get their information, I will be able to create content smoothly, I guess.

Hello Developers,  I have a mashup and in that i have collection. In collection i have around 12 or 14 images with 2 3 PDF's. I would like to add here the next and previous button so that user do not always have to open and close each image. Currently my implementations are that i have two navigators and i check if its pdf then this mashup and if pic then this mashup and the url / photourl etc i am sending it with mashup parameters. Anyone has an idea or some insights about this requriement would be really nice. I am already doing brainstorming but listeneing to your insights would be great.   Collection in mashup   when you click on any photo 

Hi Developers,I have a service which loads the data on mashup in gridadvanced. I have a textfield which takes searchinput so  if (searchinput !== "") {then i run the service to get data for that input which is given in text field} else if (searchinput === ""){means i have not written anything in textfield then i am just showing a complete datatable entries on grid}Now new requirement came that the user can select startdate enddate and get that entries on mashup. Any suggestions for best practices how can i do that? I think i have limited the existing service to run on  only in two conditions. how can i expand it. any ideas or suggestions?

We have installed Thingworx Foundation with "ThingWorxFoundationMSSQL-9.1.9-x64" installer with Windows 10 For some other issues, we had reset the entire windows system. So, every software installed in the system removed including Thingworx and MSSQL. Now, I'm trying to re-install again Thingworx Foundation with "ThingWorxFoundationMSSQL-9.1.9-x64". But we are getting an error...There has been error. This version of thingworx foundation already installed​.   If I'm trying to install some other version of Thingworx... How to resolve this issue and install Thingworx Foundation?    

Hello,everyone!Why does the log report an error when using alert as a subscription input?This is the property I entered:Here's the subscription I wrote: This is the log after triggering the subscription:Why is that? Please help me.