Questions, discussions, news and updates regarding the Thinkwise Platform.
Recently active
Upgraded to 2025.2 and encountered issues with the Task “Assign rights” under the roles: Another location was in our Base model which we use for the translations of de GUI objects for our 33 languages. The option to use the task “Translate using AI” seemed handy. The error appearing was the following: As this is a functionality of the SF, the though went to the direction of the base models of the SF itself, as the SF is developed in the SF.It turn out that I was wrong and my own Model requires the base model “Enrichtments” for these task to work. (Thanks to Thinkwise support to figure this out).Why make it so that the developer Model requires these for even a fundamental feature as assigning rights to roles? Why is this not part of the SF side of the model?In a work model I can accept it a bit more, but to require this in our base model just to use the AI method for translations, I kind of see it as polluting the model. I can remove it again afterwards, but that is working around the i
Hello CommunityI am currently working on debugging a slow “preview document” response and am not sure where to look for a root cause.I have a development server running on Azure and an acceptance server running locally on IIS. Azure serverIIS ServerThe azure response time is like 6 seconds while the IIS takes a minute. I am currently considering the following root causes:Some IIS setting is not set/optimalised The machine the IIS is running on is not powerfull enough Some firewall is scanning the document I am however struggling to pinpoint the issue since the indicium and iis logs (inetpub → logs) dont show anything. Do you have any ideas?
Is there a possibility to visually represent data in a scrum board format.Everyone is familiar with the Trello / Jira / Scrum board and I’d like to display the progress of certain entities in such a setup.I have been able to get the closest by creating a view that fills the column accordingly, and therefore maintains the connection to the underlying entity (defined by the row).Additionally, I have attempted to display them in a Cube / PivotGrid. This leads to the same ‘empty row’ result.Is there another component or method to construct such a scrum board view?
For a view I have a simple update handler, which naturally expects all the values of the view as parameters, as far as I know there is no way to change which variables are expected.Here’s the generated code:/* Create or alter stored procedure upd_preview_with_label. */create or alter procedure "upd_preview_with_label"( @upd_preview_id preview_id, -- Key values of row to update @preview_id preview_id, @definition_id definition_id, @production_run_id production_run_id, @filepath filepath, @printer_id printer_id, @template_type template_type, @width number, @height number, @print_buffer number, @print_amount number, @printer_assignment_name name, @image_data_id image_data_id, @image_format image_format, @image_id uniqueidentifier, @image_data varbinary(max), @image_name im
Maybe an unusual question…Problem → We want to upgrade our Software Factory to 2025.2. Nice and all, but we have a Software Factory which is 335 GB. Many tables contain irrelevant data of some years ago (old branches). If I am correct, in 2025.2 data will be cleaned via a scheduled flow of Thinkwise (the scheduled flow existed already but contained a bug which got fixed). Manually cleaning data took me already alot of evenings and is still not done... (I did this for a few weeks… Call me crazy ;) ). I am a bit worried this schedule will slow our server/environment down because cleaning will not be done in one evening...Another problem: running tsf_optimize on our Software Factory results into our server running out of resources which also sounds problematic.Possible solution → We wanted to start with a clean Software Factory, and import our model into it. This way we do not have to clean data, and our Software Factory database will be small once again. We DO want to keep important hist
When utilizing the database function `dbo.tsf_user()` in a stored procedure, the value does not resolve the user requesting/executing the stored procedure, while using Indicium to do the request.To sketch 2 similar, but different situations.A process flow is executed through the Windows GUI. Stored procedure is executed while generating a report in DevExpress. Stored procedure utilizes `dbo.tsf_user()`, which results in the currently logged in user, the one executing the query. A process flow is executed through the Universal GUI. Stored procedure is executed while generating a report in DevExpress. Stored procedure utilizes `dbo.tsf_user()`, which does not result in the currently logged in user, the one executing the query. For other features in SQL, this error does not occur, for example for building certain views, functions, etc…However, for the stored procedure that is being used in the DevExpress report the currently logged in user is not being retrieved. Causing our reports to
I had a long break (a weekend) between starting the execute source code step, and addressing the errors it came across. After the weekend I resumed, and skipped the error it came across in the tasks step (renamed column was not yet renamed in a template, happens all the time).For the past 2 hours it’s been stuck on 55%: Generating new definition is still blocked: I don’t see any processes that relate to thinkwise in sp_who2, though I might not be looking for the right thing. How do I resume or force-quit the execute source code task?
I have a column with a lookup that shows the “Name” value. I have set the Filter to “Contains”. In my filter it does stick with “Equal to”. Lookup Filter conditionU-GUI filter form resultIf I now try to search for component that have “Engine” in the name, I cannot get this result:Filter box Grid snippet with component names that I wish to see by only using Contains “Engine”Tried with several lookup controls, but does not seem to enable the option. How can I make it change to “Contains”?Usage: Platform 2025.2
AI provider type: Azure OpenAIChat completion model: o3-miniDoes anybody have experience with the LLM Chat Completion action and solved the cleanup needed on the Chat History output to bring it back to a usable format?I had encountered a Status Code -4 of the action, which turns out to mean: “ Unsuccessful (invalid history). See the input parameter Chat history in the table above on how the chat history should be formatted.”In my example I just put the Output Parameter of the LLM Chat completion in a Process variable and use that again as input of the next request. Turns out the output is so enriched, it does not follow the required format anymore.Here my example:Prompt: “Pick a number between 1 and 10”Received chat message: “Alright, I'll go with the number 7.”Prompt: “Now add 3 to it”This fails and that is because the history does not look like mentioned here: https://docs.thinkwisesoftware.com/docs/sf/llm#example-customer-support-with-llm-chat-completion[ { "role": "system",
We're experiencing performance issues in Universal with a certain view. I already tried using ForceRecompile in extended properties to make it load faster but that doesn’t seem to have an effect. I rewrote the sp_prepexec statement to a regular select query and it's just as slow. This is the query that’s being run on SQL Server: declare @p0 tinyint, @p1 nvarchar(6), @p2 int, @p3 int, @p4 intselect @p0=200, @p1=N'%A%', @p2=1, @p3=201, @p4=200000SELECT t1.[tsf_row_number], t1.[bedrijf_nummer], t1.[klant_groep_nummer], t1.[klant_nummer]FROM (SELECT ROW_NUMBER() OVER (ORDER BY t1.[klant_nummer] ASC, t1.[bedrijf_nummer] ASC, t1.[klant_groep_nummer] ASC) AS [tsf_row_number], t1.[bedrijf_nummer], t1.[klant_groep_nummer], t1.[klant_nummer]FROM (SELECT t1.*FROM [vw_example] t1) t1WHERE t1.[klant_groep_soort] = @p0 AND (isnull(t1.klant_geblokkeerd_voor,0) in (0,1)) AND (exists (select kg.klant_groep_nummer_hoofd from klant_groep kg where kg.bedrijf_nummer = t1.bedrijf_nummer and kg.klant_groep_
Hallo, Is it possible to combine Cube and Chart in one page? Now I can toggle between this Cube and Chart, possible to make it in one screen? Thank you
Hallo, How can we apply colors or apply conditional layout in cube?example for below cube column KPI 1I wanted to apply a text color to the result, if the average is less than 30 the text value will change to a different color Thank you
Hallo, applying image in conditional layout is not showing, even if i remove the background color it doesn’t display the image, are there other configuration needed to set? thank you
How can I show an image in grid based on a public URL? I have a field with a varchar domain and UI control ‘Image link’. When configuring the storage location as storage type ‘AWS S3’ we get exactly what we want, however we want it to work using a public URL instead of an S3 bucket. We have tried ‘File system’ and setting the base path in the ‘path’ definition of the File System configuration. This does not show the image - see screenshot below. Unfortunately the indicium logs do not show anything related to fetching/showing the image/thumbnail. The developer tools show two requests related to the thumbnail. One does a count (no clue why) and the other seems to do something with filtering and returns the extracted file name from the URL and shows the indicator IsInvalid = TRUE probably meaning the file, url or request is invalid:URL:http://server_name/indicium/sf/1111/work_order_view.trade_work_order_kind_normal?useControlBasedFiltering=true&$filter=((subsidiary_id%20eq%201186)%20a
Hi,We have a view with a auto-edit and auto-save form, we have 1 editable field which is a barcode, after entering a barcode and hitting <tab> (which a barcode scanner does) in universal the focus goes onto the next object and does not save the record, is that intended? (2022.2.14 gui) Focus is on the 3 dots, top right.Also: When entering the screen, I cannot change records because of the form being in edit mode, we first have to cancel the row and select a new row. For us not a big problem for now, but I don't think this is intended?
It is not clear on what the checkbox ‘Available’ depends. And there is the option ‘Make Available’ is also not visible when using the Grant task.Can someone explain this?
We have some processes developed which import Excel-files, for example for Sales Order creation.This process looks like:Excel-file will be placed on a network-location 1 time per minute a Microsoft SQL Agent job will run and determine if there is a file in the network folder if there is a Excel-file in the folder, some T-SQL code will open this file via an OPENROWSET action (using ACE OLEDB 16.0, and modified registry setting TypeGuessRows from 8 to 1 to support more rows to be analyzed for data type determination) the data of the excel-file will be stored in a general Import-table a procedure will then analyze the new imported data based on predefined rules per customerSo we have several templates to import for the Sales Orders as several customers want to use their own Excel-file format.Then the issue we have:Now and then (say once per year), the ACE OLEDBD-drive in MS SQL Server will stop working out of a sudden by also providing the following error-message: Cannot initialize the d
We try to get a detail screen refreshed after closing a modal document. The document pops up by means of a table task + process flow from a detail grid.Solution 1:Trigger a process flow on closing the modal popup Not working, the Close Document seems to not work as a start action in process flowsSolution 2:Trigger a process flow with a table task that closes the popupNot working, the popup closes, but after this, nothing happens Any better ideas?
Hallo, How to create a dropdown list as filter for Year and MonthFrom Period = This will display Year & Month To Period = This will display Year & Month The selection will retrieve those within the selected year and month from the table. Please advice Thank you in advance
found above topic because i have the same issue.Is there any option to passthrough sas-token through a parameter in the task?Security wise it's not an option to store the token in a table or hardcoded in the report
Hallo, I have a field from which I can toggle between delivery and warehouse Delivery it will display other related address fielddelivery Warehouse - will display another fileds and hide the address fields (above) warehouse If I select 'Delivery' and enter some address information, then switch to 'Warehouse', how can I clear the address information values from the delivery? and vice versa if I switch to Delivery then the value on warehouse will be cleared. I tried to incorporate the clearing of fields to layout function but it doesn't work Please advice. Thank you
Hi, We have several apps calling Indicium, and using the data. This works fine, but sometimes clients complain about performance. We have a feeling that someone is calling the endpoint a bit too often.. or requesting a bit too much data.What options do I have to see how often someone (an app) is calling certain endpoints, and at what moment? Thanks! Blommetje
Hello everyone,In our custom components I am trying to integrate the event listener so I can switch to dark or light mode depending on what mode our application is in. But the code, which the documentation suggests, does not seem to work. I did the following:We use TypeScript so typing has been added.This is, aside from a few console.warn statements, a copy from what is in the TW docs. This is the suggestion from the TW docs with a few console.warns added so every log pops out.And this is the output of this bit of code: As you can see it does not get into the window.addEventListener. But if I change it to the following I get another result:The result is as follows: It does more, it gives me the console.warns I was after, but I don't get the TW status, which I was expecting. I am fairly certain I am doing something wrong somewhere, what could it be, as I am out of ideas.
Hello,I am currently trying to install the icon set bootstrap thinkstore solution. However i can not get it working in my own model.I am currently following these steps1. Turn model into base model (this might be wrong but if i don’t it does not show up as a linkable model?)2. Link to project.3. Generate project.Error Message:The MERGE statement conflicted with the FOREIGN KEY constraint "ref_validation_sf_upgrade_validation_msg". The conflict occurred in database "SF", table "dbo.validation".I have one more thinkstore solution installed the “Application Log“. I think i’m missing a step somewhere or i am incorrectly changing it to a base project?Kind RegardsAnne Vries
How can i add Dutch to the Thinkwise SF application in IAM can only choose english in form
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.