Thinkwise Platform

I did a merge from our production db to our test db, plus a restore of both iam and db itself, to have a clean slate and start over with the exact same data.Yet when I do a creation now, on the test, I get these added checks everywhere, which result in errors.They look like this:alter table "relatie"add constraint "c_relatie_opmerking" check ("opmerking" in ('0', '1', '2', '3'))goOpmerking is a varchar(5000) column, so obviously this will fail. But no one here has any idea why these get added. The live doesn’t have them. To illustrate:This is the production, with 5 constraintsthis is the test with 11I can not delete them, only add (nor would I want to manually delete them to be honest, because there are a lot)Why doesn’t a merge and restore fix this problem?

I've had this issue before but this time I have more time to find a solution. On my database I can see that a specific column is set to nullable:[single_xml_file] [dbo].[checkbox] NULL CONSTRAINT [DF__label_hea__singl__628FA481] DEFAULT ('0'), But in Thinkwise this column is set as mandatory and when I look in the creation sql code I can see that it is set to NOT NULL.But when I execute “Create Definition”: And then “Execute All Validations” and after that “Generate Sourcecode...”: Next I connect to my DEV database and the SQL output shows:   When I select create and search in the source code for the table this column belongs to I see:  But because the db connection was succesfull create will not be executed and there isn't an ALTER Table being executed as well!?Last time I had a similar issue Anne advised to change the value, create it to the db and change it again to force TW to get back in sync.But in this case that doesn’t seem to work…Any suggestions on how to tackle this? I'll le

we have a web connection where we (temporarily) receive the bearer tokens via another way (yes i know, not ideal, hence temporary) and store them in a table. i have modelled the web connection with authentication type: bearer token and the bearer token as {token}.my question is: how do i fill this with the value in the table for every tennant?

Hallo everyvone,we currently have a customer who would like to use the database in MS Fabric. We are having some difficulty setting up the Thinkwise platform.Has anyone ever got the platform to work in MS Fabric? Is this even supported?Thanks and best regards from Germany.

All,From our thinkwise application we send email via SQl msdb. This works fine for years, but now I deployed a test application and emails with an attachment will not be sent. It’s a rights issue, the attachment is on another share, so not on the SQL server. If I start the application via the SF it works fine. If I start the application via IAM (not via Indicium so in the ini file RDBMS = SQLSERVER)an email without attachment is sent, an email with an attachment will not be sent.I added logging in my send mail script.EXEC xp_fileexist @FilePath;Die geeft 0 terug, wat betekent dat de Thinkwise app de bijlage NIET ziet.De SQL USER function heb ik ook in de logging gezet en die geeft terug: [domain]\srv_indiciumThe SUSER_NAME() is diezelfde gebruiker.En de ORIGINAL_LOGIN() is mijn eigen account.Zowel mijn eigen account als de srv_indicium hebben rechten op de share waar de bestanden staan.Als ik in de verkenner het pad met het bestand kopieert onder mijn eigen login, dus dat is ook de log

We have several tables where an image upload is possible. For end users it feels awkward that they first have to add a row, then push a "button” to actually have the GUI open the camera (or gallery) to actualy fill the field. Is there a way to have the GUI automatically open the camera (or gallery) to actually take a picture into the application?We are currently on version 2025.2 of the platform. I havent found a flow automation step that could handle this an automate what I want. 

In universal when a screen or connection takes a long time to load the data you first get a no results message in the grid. This is kind of confusing since it’s still loading the data. The message in the grid suggest there is nothing to show however the loading icon is still doing its thing. After a while the data shows. Can we replace the no result message with a: loading data, spinner icon or whichever makes sense.    

We are almost completely rid of the use of the old WIndows and Web GUI's, and users are more or less getting convenient with the Universal GUI's look and feel. But we are missing some functionality when it comes to Startobjects that users could define in the WIndows (or Web) GUI. When a users switched from the old to the new GUI, the startobjects are there (like menu items with tables that are by default opened). The sorting is not clear and different compared to the old gui's, but at least the open. But when we reset, for whatever reason, the user's preferences, there is no way to re-create the, for instance, startobjects, for that user. I haven't found the functionality in Universal yet to do this. So the user needes to go back to the Windows or Web GUI to reconfigure his or hers startobject(s), to get them working again in Universal.Any idea if this functionalitity exists in Universal, and if not when we can expect it there?

I don’t understand the drag and drop interface.I have a table “ams_location_object” and both a list and a tree view, in both the same happens.I select and item A, and I go to the side bar, drag another item B, onto an item C.I would expect that I get task parameters from B and C (I don’t know which one should be the task parameters and which one the drag drop parameters, that is the second question), but I do get task parameters for B and A. I don’t get anything from C.Trying it with an other setting I found that the task is from the target.So; task parameter = drop target, drag drop parameter = drag source.But I somehow don’t get the item I dropped on, but the selected item as parameter. That is only useful if you drop on the table, not on a row. It should work as you can reorder items in the software factory. Here I want to assign the parent on drop, so that reorganizing the tree view can be done without editing items.Please help, I thought I could speed up a little reorder job, but

Hi,I am running into an issue with going to the universal login page. Normally, when proceding to the weblink of universal (acc/prod) I get the following page. Continuing results in the following webpage: However, some users deleted the cookies for the universal webpage. Normally, this wasn't a problem. Simply refreshing the page results into the pages above and the user can login. But this time the users get the following screen: Since these users need to login via the SSO, this page doesn't work for them. The curious thing is that there is a difference between the ACC and PROD environments. ACC keeps working fine after removing the cookies, but PROD results in the page above for the users that removed them.Since I didn't change any settings on the server side (both environments are hosted on premise), I am oblivious as to what the cause of this behaviour is.How do I get the users to the right universal SSO login page? Kind regards,Mark

Is there a reason the dots on grid header for filtering are on different locations?  

Hallo,Would like to check, how to add a new user group to a user in IAM? I have a process flow to add a new user group to a user but the store procedure I'm calling seems wrong. Below is the sample of adding user group in user manually: For auto created user group I use the task_copy_usr_grp store procedure in my endpoint url on web connector process action.  Path: /indicium/iam/iam/usr_grp_usr(tenant_id=1,usr_grp_id='{to_copy_user_name_2}')/task_copy_usr_grp But not sure if the store procedure is correct as i'm having an error   Thank you in advance

in our proces flow we use a taask to fill a column which is used as the body of an email that is then send via the email connector.proces flow monitor is all ok, until the actual sending of the email, then the time-out occurs.credentials are checked and ok, smtp server is functioning. any tips on what could be causing this issue?

We have an editable grid and we need to enter some numbers on different records.After saving a line the grid looses focus related to the up and down keys.We have to select the line again with the mouse before we can move to the next line with the down arrow key. If we use the down arrow key directly after saving, the grid is scrolling, instead of moving the highlighted (=selected) line to the next record. 

The thinkwise documentation states that the end date of a user in the IAM controls the access of a user to the application. However, the user is still able to access the application after i fill in the end date. If i fill in the end dates in the user group of which the user is a member of then the user has no access to the application. I expected the end date on user level would be the primary end date. Am i mistaken about what the end date of a user does? We are using windows GUI and version 2025.1. The user is not an admin or have any other role in the IAM and authentication is through windows.

Hello everyone,As the title suggests I have the that error on indexes:I did see a post where a validation is supposed to be in place to prevent this from happening. But does that also count for when you create a unique constraint on multiple primary keys? Because I cannot find the validation and now I cannot (re)build my database anymore. I would need to fix this first, but in the newest validations by Thinkwise, a validation on this table would pop up urging it needs a unique constraint on the two primary keys used in the constraint. So what can I do to fix this? Did anybody else experience this problem? 

I’m experiencing a strange difference between previewing a PDF file, and a PNG image. The source of the files looks similar, but the PDF works, while the PNG gives a 403 error:PDF: https://domain.nl/Indicium_sf/sf/40/preview_with_label(7386)/TW_MODEL.preview_image_name(file_id='A259CDC87766E9A69B05A09FD7A33EE95838FF9CB6F18552E1D66F9208B2A70A') PNG: https://domain.nl/Indicium_sf/sf/40/preview_with_label(7384)/TW_MODEL.download_image_name(file_id=%27B79079422762AB11E4B466A35CEF645A745FB0D8E44687CB5AC8F9D8516D1BAE%27)A noticeable difference is the function preview_image_name vs download_image_name, could this be the cause of the “forbidden” error? Do I need to enable the download permissions somewhere?A few months ago PNG worked fine. Since then we only used PDF, but it is strange that now PNG does not seem to work anymore. Am I missing anything?Data looks like this:  

When migrating our SF, we noticed our SF has several stored procedures that are invalid. For example the stored procedure ins_usr_branch, which has an insert statement with columns that don’t exist in table usr_branch ("read_only","read_only_allow_merging"). So I looked at the 2025.3 install script 115_Handlers.sql and I noticed that ins_usr_branch is not included, so it seems ins_usr_branch should not exist.I found that the upgrade from 2024.3 to 2025.1 (TSF_2025.1\SF\Upgrade\2024.3.11\115_Handlers.sql) created this stored procedure and in all upgrade scripts that came after this, it was never dropped. We started with the SF 2024.1 installation and we always used the Deployment center GUI to upgrade our SF (up to 2025.3). So why are these stored procedures never dropped? And could there be more ‘old’ objects in our SF database schema that should not be there?To fix this, is it safe to just execute the install code files 030-150 from the 2025.3 install package?

We use a printer called dummy_printer to print on various printers from a table using the overwrite printer name parameter. This worked until we had a windows update a few days ago, after which the printer suddenly ignores all defaults and preferences set on the printer server (PRN01).The addresses we use for the printers look like this: \\ROVEGPRN01.Roveg.local\Label1_Test_KBS.We checked all defaults and preferences on the printer server to make sure they are set up correctly, and they are. We also tried local printers (installed on the indicium server), which equally do not use the printing defaults and preferences. Instead we get a zoomed in (not fit to page) and un-rotated version.Does anyone know where to set the printing defaults/preferences for printing from thinkwise?

Reading the following here: https://docs.thinkwisesoftware.com/blog/2025_3#web-domains---improvements-for-web-domains“When you make a change to a web domain, Indicium will be notified and will read the new configuration of the web domain. Changes made to a web domain are visible within a minute.”I am mainly looking for a direct update of the Login Page Notice to be changed so we can use it to announce upcoming Maintenance, but so far the changes never seem to go through unless I restart the Azure Web app. Also having changed “Allow Stay Signed In” in case it had to be a change on the entity directly, but does not do anything either.Is this not the configuration that the guide is talking about or does it not seem to function then?Platform: 2025.3Indicium: 2025.3.11.3

When I set a lookup reference to “Visible for filter” = “Always”, it appears in the filter form.It seems that regular fields set under “Subject” → “Data” → “Filter” will show first (which is fine). After that the reference lookups, but I cannot figure out what controls the order in which those reference lookups appear in the form.In a situation I have made 3 available and for clarity I would like to change the order to a more fitting one. What can I influence to change this?  

Hello everyone,We found a strange issue with one of the task pop ups. It seems to auto scale after opening the popup, and it does not matter what type of screen you're on (desktop, mobile, doesn't matter). Seeming a video might help better than trying to explain it, here is a GIF that showcases it:What could be going on, I could not find a setting or something like that to prevent this from happening, but it seems to be happening whenever I hit the task with the checkmark. And this is the only task that does this.

As an example case we have a pivot grid with sales orders that default is grouped by customer, but the user is allowed to change the cube view. So for example he could remove the customer category, but group on order type instead.How can we make it possible that the user could open specific orders when the orders are aggregated in the pivot grid? We tried adding a detail tab with the orders, but it will only show the first row.Of course double clicking on a pivot grid cell opens a popup that shows all the orders of the aggregation, but we cannot use that to open the orders with all details (I created an idea for that: Pivot grid zoom in - normal grid functionality | Thinkwise Community).The only thing I can currently think of is creating a field with a html link that points to a deeplink of the order in our application and show that field in the popup screen. But this unfortunately means it will open a new browser tab for each order.

How can I add a Database message as explained here?: https://docs.thinkwisesoftware.com/docs/sf/messages#database-messagesThe screen is lacking the group “Database message capture” or the relevant fields Screen after pressing “Add”When removing the prefilter there are records existing that have such values and they are from a Base model, but I do not see a way to make the relevant fields appear myself: Example of existing Database messageI could use a “Copy” action on this one, but I do not think that was the intended method.In case relevant: Platform 2025.2