ThingWorx

I am trying to install  Thingworx Analytics to use the transform feature. Here are the details of install. Thingworx Version - 9.3.7-b1432 Analytics Version installing - MED-61287-CD-093_SP8_Platform-Analytics-windows-9-3-8 VM1 - Thingworx is installed with Azure SSO - Thingworx is working fineVM2 - Thingworx Analytics trying to install Installation said successful, I am able to see transform property but its disconnected and I am getting below errorI used the same SSL cert used for thingworx app for rabittMQ and Fling when ask for  Below are the error logs on VM2 Flink logs2024-05-20 23:57:10 [main] INFO c.t.a.d.c.s.FlinkConfigurationService - connecting to the flink cluster at: localhost:80812024-05-20 23:57:10 [main] ERROR c.t.a.d.c.s.FlinkConfigurationService - Unable to connect to Flink at the following location: localhost:80812024-05-20 23:57:10 [main] WARN o.s.c.s.ClassPathXmlApplicationContext - Exception encountered during

Hi,   I have a service, for example, GetDataTableEntries, which gets the data from the DataTable, which has around 5000 Entries.   I have another service, holdData, which has an input of infotable, which gets the data from GetDataTableEntries. GetDataTableEntries ---> holdData.   When a button is pressed, holdData just outputs the Input data as Ouptut. However, it takes around 25 to 40 Seconds, but why?   Thanks,

Hi,I have a remote thing that is responsible for getting files from FTP. When running the remote thing exe, I get the following error message:An item with the same key has already been added. What is this error message reffering to? I Can not see thhat the thing is connected prior to this error occuring.As this is work for a client, it is imposible for me the share any more details than this. Kindly Oskar Berntorp  

Hi all, I have to run a query on MS SQL Database table, which has columns with spaces in their names (ex: 'SA03 LH CS BRG DEPTH (mm)').How do I query this successfully?Here is an example query: SELECT *FROM <<tableName>>WHERE <<tagName>> != 0; Here <<tagName>> is a column with space in its name. 

This same thing(Link) has just happened to me on ThingWorx 9.4.4, no grid widget is available. Did you just restart Tomcat?I restarted tomcat but the grid is still missing.  

dear friend, my customer want to make grid like some page in MFG, as attachments pic, put a green circle shape under the OEE number, how can I make it happen in TWX9.5

Hi I am using thingworx version 9.2 and I want to select the text from Tree Grid advanced cloumns. So please let me know if it possible and How we can enable this functionality.

I want to delete data in the infotable by checking from the _time field. If there are any duplicate time periods, check from the day, month, year. Then delete rows that have a value of 0 from the infotable. What methods can be used to do this? 

I have installed KEPServerEX 6 in a windows computer. I am reading data from the PLC. I want to store some of the tag values in a SQLIte database running in a Linux server in the same network. I am aware of DataLogger to storing data from kepware to a database. I am storing data in a sqlite database in the local machine with help of DataLogger. But I need to store data in sqlite database which is present in a different Linux server. What are the possible methods are available for this. Please help.

Is it possible to bring the data videos, photos, snaps from Vuforia Expert capture to ThingWorx mashup?As per my understanding Vuforia Expert Capture is on PTC cloud, it doesn't provide any On Premise solution.My requirement is I want to integrate the Vuforia expert capture data like videos, instructions, snaps, photos into ThingWorx mashup. is it possible to do so? i know its possible somehow....how to achieve this?can anyone help me to know more this integration?how to connect thingworx and vuforia expert capture?

We are currently using Thingworx Foundation 9.3.3.We have a collection used to display a series of KPIs in a scoreboard.  In previous versions of our application, we had a fixed MashupWidth and MashupHeight and the FlowLayoutGravity set to spaced.  This, very nicely, left justified all the cells in a row.Old Scoreboard After implementing an enhancement that allows for additional information in the cells, we needed to remove the fixed cell width and height and, instead, use the CellHeightField and CellWidthField.  Now, with the same layout settings, the cells spread across the width of the browser.  This is much less desirable.New ScoreboardIs there any way to get the cells to layout in the old way, while still having the variable width/height?  We are experiencing this on both Chrome and Edge browsers.I admit that this is a little strange, as none of the documented layouts seem like they would produce the original layout, but we would very much like to hav

Hey,im currently working on TWX  9.4.1-b313.I was wondering, if there is a way to check if the current mashup is opened as popup/modal popup? Thanks in advance Markus 

Hello, I am pretty new for Thingworx, I am using the Labelchart widget and would like to change the XAxis marker format from DD/MM to MM/DD to line up my host server setup, now my system shows MM/DD/YYY but my Labelchart X Axis shows DD/MM, the setting for the Labelchart is as follow:XAxisLabelType: DateTime, XAxisFormat is MM/DD and XAixsField is dt, this setting is always shows DD/MM on my XAxis, only when I changed the XAxisField to nCount, I will get the MM/DD but the XAxis is not line up with current time. Seems the Labelchart cannot be localized

I tried to access OPC Aggregator using third party OPC DA client such as Matrikon Explorer and OPCExpert, but not successful. Matrikon Explorer and OPCExpert is the same PC as OPC Aggregator. Error in OPCExpert said that cannot access because no proper license in OPC Aggregator, but as far as I know the OPC Aggregator doesn't need license. So can ThingWorx OPC Aggregator act as OPC DA server? or only can be OPC DA client?

Hi,Does anyone know how to set up a function perhaps an expression to send the "true" boolean to the Visible property of a widget or container in a mashup?My mashup displays a grid with data and with a button below the grid to allow the user to export/download a CSV of the data displayed. I would like this button to become visible only when the data has finished loading in the grid.  TIA

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