ThingWorx

Hi Team, I have a grid which is editable( left) and there is another grid ( on right side ) which is calculated based on the inputs in left gid. And I am refreshing the left grid on click of a button( Next) using validation, but the same refresh is not working on it, it is retaining the last calculated values. I have tried several event triggers but still I am not able to refresh it. How can I do this.?  

Suppose I have list of hospital in the dropdown and if I select a a hospital from the drop down it displays associated data in grid format and these columns are like 1. Doctor Name 2. Department 3.Specialization NOW what I want is I want to count these individual column unique data and show that in a Pie chart or bar chart and that chart should also vary based on hospitals how can I achieve this in Thingworx 9.1 or later version   Thanks, Lav

Iam getting this error in production which is stopping mail notification.error: Service1: error is JavaException: com.thingworx.dsl.exceptions.DSLRequestProcessingException: Execution error in service script [Service2] :: Not authorized for ServiceInvoke on CreateValues in MailFileRepositoryAttachments In Thing, Service2 is called inside Service1. This error is occurring only in production but working fine in dev servers. How to fix this?

I have mashup, where I have 1st container with a button, second with tabs, and in first tab I have mashup container with mashup AAA inside. Do not want to present this internal container, until button is not pushed.Case 1. I set tab ptcs-tabset-6 # 1, lazy loading true. I set connection of clicked button to Load Container. I open mashup... and see inside of mashup AAA  just after I've loaded mashup, without clicking button. Case 2. This same structure, but this time tab ptcs-tabset-6 # 1, lazy loading false (unticked), container 3 lazy loading true, ptcs button 5 connected with Load Container for container 3. This time it works perfectly.So I create similar structure inside my already existing mashup. Do it with this same mashup.I load mashup, click button... and I see tabs, but do not see mashup from mashup AAA. Logs confirms, service called by mashup AAA OnLoad is also not started. Why case 1 is not working? What can be wrong with on mashup already exist

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.