ThingWorx Developers

When creating a scheduler or timer, I do create a dedicated user for it. And it's local TWX user, no some Active Directory user, etc.This user is given permissions for all Things/services which are required when scheduler/timer is triggered. Everything works perfectly at development server.Unfortunatelly, during deployment, this user is not deployed to production server. Because user are never deployed. And I have no admin rights at production to create this user, and set permissions again.I could set administrator as user context for timers/schedulers, because such user already exists at every server... but as far as I know it is recommended not to do so, for security reasons.Is there any other solution to cope with that? 

Hi, I have a mashup that displays data from a Data table. I need mashup to auto refresh/update data whenever a row is added/deleted/updated in the Data table.I can use auto-refresh function, but i need data to refresh only in case of changes to row in Data table.   

Hi, I am trying to explicitly name the sheet that is exported when using the Data Export widget in a mashup. Currently the filename is copied to the sheet name, however the sheet name can only hold 31 characters and the file name will always be longer. 

i wanted to know is there any Third party application available to check storage space, type of file stored (.jpg or .bmp), date of file created in ANF storage.and that third party application will able to send that data to thingworx. if it is available how to do it ?

I am new to Thingworx. I have developed a custom extension where i have created one service that is generating excel sheet in form of blob from an infotable input. now when i call the service using snippet, the file is getting stored in FileExportRepository in thingworx instead of downloading in local system.  Is there a way to download the file directly in local system? 

Is there any setting to configure message duration of Status Message function?Currently, the status message would disappear in about 5s. How can I increase the duration of the status message?

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 ??