Ask a question or have a conversation about the Thinkwise Platform
Recently active
Is there a way to start a process flow when a user used the import functionality of the Universal GUI?I have tried the ‘Add row’ process action, but it doesn’t trigger the process flow. I would like to start a task after a user imported rows in a specific table.
In the universal, there is pagination (e.g. 100 rows). How can a user perform a task for all the rows in the table, instead of only the 100 that is currently shown?
We are on version 2025.2. We have an issue that in one of our tables we have two columns with a bit type domain and default value 0, but when we add a new record, the form doesn’t fill in anything (checkbox shows -). We want these fields to be hidden, but then we get an error because they are mandatory columns. And in Windows we don’t have this problem.To fix it currently we define at the start of the default script that these values are 0, but this shouldn’t be necessary.
What are the prerequisites for the background image using web domains? I am trying to upload our existing background image, but it fails to upload. If I reduce it's size to 100x79 pixels it is possible to upload, but a blurred image appears since it is resized.
In Universal GUI it is not possible to search on special characters, in Windows GUI this works using the extended property as mentioned in Can this also be made possible for the Universal GUI?
Sometimes it's desirable to display views with transaction isolation level read uncommitted, especially when dealing with large, complex datasets/cubes.Is there a way to achieve this? Or could this be added as an option in the table/view settings?
Would be nice it the white space before / after radio buttons can be reduced.
hi,In data migration you can set default values for mandatory fields in an upgrade. But how do you fix this when this new mandatory field is a reference to the fk of a new table. There are no records yet in this new table, so you have to create a dummy record. When the field is not mandatory I use a MANUAL code to insert the dummy record, but the MANUAL code is executed in the last part of the update process, so the constraints will error before you can insert the record.How can we fix this?
I am investigating a slow IAM sync and stumbled upon the problem below. We sync our IAM by first syncing to disk and then use the twdeployer to sync the target IAM. I sync a branch to disk with the task in the SF. I open the file MODEL_SYNC.sql and copy the varbinary of sync_col for example I convert the varbinary with convert(xml, decompress( sync_data)) to take a look at the xml If i look at the xml there no nodes for model_id and branch_id in the XML (which could be logical as the sync file has been generated for a specific model and branch) However the procedure sync_col on the IAM databse expects model_id and branch_id in the XML. In the temp table model_id and branch_id are now NULL because they are not in the XML. And then in the merge So as no match can be made because model_id and branch_id are NULL all rows are inserted from the temp table and all the old rows are deleted.Is the above correct? Or am i missing a setting that causes the model_id and branch_id not be included
In my subject when I set "Add row visibility” to "Always”, I expected an empty row to always be visible, at the top or the bottom of the grid.In reality it seems to make no difference at all, here I have a table and a view, that both have the option to add rows with "add row visibility: always", and they do not show the add-row until the + button is pressed.Without the need for the + button I could remove the entire action bar.Is this a bug?
For stored procedures in the SF, is there an option to disable the default for code group (without changing the SF default code ourselves)? We are not using prefixes for layouts/defaults/contexts in our stored procedure names (we use suffix), so it is annoying that the SF default enters the wrong code group.
hi all, we have several reports that are created in DevX. in some of these resports we use customer adjustable text from description column in customer company report setting table. i can change the font of all bands and content in DEvX and this all works fine, but somehow things change for the “rich text”. There the font chosen is ignored and it keeps spitting out times roman.does anyone know how to fix it, other than via hard coded scripting in template view report?in other words: i am looking for a devx solution.
Hi, I've created a process flow that sends emails using the email connector, which connects to Microsoft (Graph). The connector works fine, but the only thing I'm missing is the ability to save the emails to the "Sent Items" folder in the mailbox. Is there a way to modify the "saveToSentItems" attribute?
I tried to add my new colleague to the SF users but when he starts a model (windows gui) for testing most text is like this: How to fix this?
On Sept 10th, around 18:00 we got issues with the TSF generation, the Write code files to storage failed. Nothing was changed, we did earlier generations that day. No direct clues in Indicium found. Just a log entry Writing to storage failed because of an unknown error.Path: CENTER_PMS\1.00.032\Deploy\Install\010_Db.sql We tried to change the output location, same result. It failed for multiple projects. Restarted servers but nothing worked. Strange enough, we noticed that for example the document site from Thinkwise was also not available. Later that night I tried again, and strangely enough it worked again.Today Sept 15th, I have the same issue again. Write code files does not work anymore. Tried again different options, no success. I hope that it will resolve itself again…..Funny enough I see this message on the community website: "We are currently experience problems with user login”. Is that a coincidence? Is writing code files trying to connect to a Thinkwise server and failing b
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_
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.