Solved

I try to run the creation steps for a TW application on our DEV environment and I get this error: An unknown error occurred while executing '/* Create or alter stored procedure saveAttachment. */create or alter procedure saveAttachment @directory_path exh_parameter_nvarchar , @file_name exh_parameter_nvarchar , @byte_array exh_return_binary , @overwrite exh_no_yes , @output_path exh_information outputas external name SQLTCPExhItemSender.UserDefinedProcedures.saveAttachment;'. Error: 'Assembly 'SQLTCPExhItemSender' was not found in the SQL catalog of database 'BRB'.'.I wonder if this is still required, it appears this is a DLL file used to extract the attachments from an email.Is this something that comes from Thinkwise or is this something a former colleague of mine thought up before I was working here?I seem to remember we have had issues before with emails when the customer started using the new Office 365 outlook interface. We had

In the Web GUI when you choose “Export immediately”, it only exports the visible columns. When I use this same option in the Universal GUI, it uses all columns of the table/view.How can I enable the same functionality, as we do not want users to see the hidden data?

Hi all, I’m using the web connection process action to interact with a third party API. There are two issues I run into:“Path” is a fixed property, requiring me to define many endpoints for the web connection; “Method” is a fixed property for the endpoint, but not part of the key for that record. It does not allow multiple methods per endpoint.For the path there are two ways I tried to work around this: defining “Path” as {path} in order to turn it into a parameter defining `url_path` as a parameter to the web connection.The method is a domain with elements in the endpoint definition, not allowing to enter {method} as “Method”. I did define `http_request_method` as parameter to the web connection. I was not able to get either option to work as I intended. Does the web connection process action support this kind of abstraction? Should I model this as a custom / message protocol independent flow?

Hi A couple of weeks ago I implemented the following topic to work in my on premise application. When I tested the drag and drop functionality myself, everything worked fine. This week however, the tester ran into an unauthorized error. After some testing myself I found something weird.When I log into my application via: https://my-appl/universal and I try to upload a file I get the following error:However, when I log in via https://my-appl/indicium and then navigate to https://my-appl/universal my file is uploaded successfully:It seems like that logging in via the universal link doesnt give me the rights to upload a file, while logging into the indicium page does. On both pages, I log in with the same account, so there is no difference there. The upload URL that is used in the javescript code is https://my-appl/indicium/iam/appl/(table_refence). I am struggling to find where the problem lies. My guess is that this has something to do with the server settings of the on premise environm

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.

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

In de U-GUI the data does not show a thousand separator for the integer value, as we have not used a numeric control for that column.U-GUI value Domain setting of specific columnWhen the data is exported to Excel it however does have the thousand separator set for the cell.Excel export valueAs this value is also used for external purposes by our users, it becomes quite a burden that they have to change the value as that dot (in my case) also ends up in their other program/tool, which is undesirable.How can i prevent this behaviour from happening?

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?

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.