Questions & Conversations

I don't get this error. If I do the statement directly on the database it's fine.. but for some reason Indicium spits out a max recursion error.  2023-02-24T16:15:02.3806392-03:00 8000004c-0001-eb00-b63f-84710c7967bb [ERR] An unhandled exception occurred while processing the request. (ffba027a)Indicium.Shared.TSF.FatalDbException (0x80004005): The following query failed with an exception: 'DELETE t1FROM [service_task_view] t1WHERE t1.[tenant_id] = @p0 AND t1.[service_id] = @p1 AND t1.[service_flow_id] = @p2' ---> Microsoft.Data.SqlClient.SqlException (0x80131904): The statement terminated. The maximum recursion 100 has been exhausted before statement completion. 

Currently when i set my @add_button_type to hidden in the layout logic, my process flow that contains an add row process action does not work.Is there a way i can keep it hidden in the GUI but still be able to use it by clicking on a task which then activates a process flow to add a row?

While configuring two universals on a single web server, to create a setup in which the functionality asked for in the topic linked above can be deployed, we run in some issues.We like to setup a separate DNS record for each universal, such that depending on the DNS name the user is redirected to the correct login screen. Also on our development environment we like to have two universals, each using their own indicium, all on the same webserver, and have a separate DNS record for each universal.In both scenarios we face the challenge of how to correctly perform the DNS mapping. Our main questions are currently:what would be the best place to have the redirection take place? Users should just go to the domain name, without providing a path, and routing/redirections based on the browsed DNS name must take place which makes them land on the correct login screen OR the correct home screen, dependent on if auto login can be performed. to which path should we redirect? We figured out that th

Hello,I am trying to upgrade my applications to the Universal GUI, however when testing I am experiencing the following problem.I have a screen, which has parameters which are dependent on each other. In this case, I first need to choose a 'Gebouw’ (facility), after that, the related Naar ruimte: (area) can be chosen based on the chosen facility. So when I choose 114. It will only show the area's in that facility:The area which has been chosen also should be not a 'usage_area’. As this task can be used for multiple purposes, this is being done with a task parameter.The lookup for the area is defined as below.Which says, give me the area's which are available in te facility, and has the column usage_area to what the parameter value has.When running a trace on the database, I can see in the Windows GUI the following statement:DECLARE @p0 bit,@p1 bit,@p2 int,@p3 bitSELECT @p0=1,@p1=1,@p2=1,@p3=0SELECT t1.[area_name], t1.[area_id], t1.[facility_id], t1.[usage_area]FROM [area] t1WHERE (t1.f

Is it possible to use the Exchange connector on Azure? We have the Thinkwise platform deployed on an Azure instance and want to send mails from this. Or is it easier to implement the Graph API?  

Every now and then I have a system flow that does not get abandoned, whilst it should. For example last weekend we had a flow that kept on running but threw an error somewhere. There seems to be no other way to force cancel it than rebooting the server. I did however find this documentation: https://docs.thinkwisesoftware.com/docs/indicium/process_flows But I couldn't get it to work. DELETE/iam/appl/{process_flow_id}({id})/I figured appl would be my app id or short name (in my case: 12 or pp) and {process_flow_id} would be ‘flow_export_messages’ (for example)What is the {id} that the documentation is referring to?

Hello all,Thanks to @Leroy Witteveen  I´ve been able to integrate my custom screen in the universal needly.Access to the authentication-cookies | Thinkwise Community (thinkwisesoftware.com) off course, the next question is, how to update any changes I make in this custom screen back to the database. I was testing the addition of a newly created link between to entities using a post request as described in the documentation here And if I understand this documentation about Resource staging , I wouldn´tt have to bother about it. I´m using insomnia as an API tester with basic authentication: method: POST url: https://prova.lef.tec.br/indicium/sf/esm/service_task_dependencyJsonBody: {    "tenant_id": 1,    "service_id": 1106,    "service_task_id": 743,    "previous_service_task_id": 740,    "connection_type": 0,    "tsf_user": "PROVA\tiago",    "transaction_date": "2023-01-19T11:29:27.067Z"}I only get a 403 message. CAn someone shed a Light on what I´m doing wrong? 

HI @Mark Jongeling ,In this item you mention  The page will have access to the authentication-cookies of the GUI and therefore can make use of all of Indicium's functionalities.Custom script integration in Universal GUI | Thinkwise Community (thinkwisesoftware.com)Can you tell me HOW exactly this can be accessed? any help will be highly appreciated,Tiago Krommendijk

Recently we've upgraded to SF2023.1 (with all hotfixes including 202300116 - Subrouting option copying from base models’ applied). Everything went well and we done some model generations with this version of the SF.However, after merging a branch recently, we’re facing an error during the execution of the functions. The creation of the function ‘tsf_original_login’ fails because the script contains duplicate lines for ‘returns varchar(128)’ and ‘with schemabinding’ How to solve this? Any help would be appreciated.

I want to setup an tw applicatio mainly for retrieving data by indicium, using the odata functionality. The data itself is already in the tables. I want to setup a user or role thet canb only read data, while another user/role can write also. The external parties want to access the api by a bearer token.Is there any documentation how to setup this? 

We noticed that the documentation for setting up OAuth doesn't correspond with what they see in Azure config panel, step 6 is the problem, Azure states that legacy API's are no longer supported since June 2022https://docs.thinkwisesoftware.com/docs/kb/exchange#configure-oauthHow do we set up Azure in order to get this working?

Hi. I'm a IAM administrator for some reason my own user is blocked for updates (cannot update my timezone and application language). What is causing this? I cannot find it. 

We are in the process of updating from TW2021 to TW2023 and during testing I noticed that in the windows gui one of our VIEWS no longer works as it used to do.When I open the VIEW I see the expected records and the debug shows the SELECT exactly as I would expect it (for readability I changed it to * instead of the individual fields):SELECT *FROM complaint_action_follow_up_action_gui AS t1WHERE (t1.complaint_header_id = 1682) AND (t1.action_id = 5);But as soon as I select one of the rows (form grid) I get a message that the selected row no longer exists:When I press OK the message dissapears and comes back again…. infinate loop…Looking at the data that is going thru the SQL server using an Extended event shows me this query (for readability I changed it to * instead of the individual fields):SELECT *FROM complaint_action_follow_up_action_gui AS t1WHERE 1 = 0;It seems to have lost all prefilter data causing it to always return NULL.When I do the exact same thing in the Uni

Is there a way to actually show the menu items (not groups) dynamically? I have a menu group with some options for employees and managers..  the fact if someone is a manager or employee is defined by the application. If someone is only an employee they don't need to see the manager option(s) ..  

Hi,When I make a change in a translation from say “Vat” to “VAT” this is not picked up. I works local, but my deployment pack does not make any changes in the web gui. Only when I add something (VAT.) it changes. Then I have to deploy this to all Client Environments (which can take some time, and needs to be tracked). Then I need to change it back to “VAT” in a new deploy. Quite a hassle, and for some reason this happens way more than I’d like to, with all the abbreviations everywhere..Is this a minor bug in the system, or do I do something wrong? Thanks, Alex   

My own plugin application is working fine from  inside a Previewer component in the Windows and WebGUI and also in the Universal GUI when the application in opened in the browser on the server that hosts IIS. But when I start the application from another PC the previewer remains empty. What can be the reason?  The plugin application is running from the same IIS instance as Indicium and UniversalIIS: The previewer should show https://test.xxxxx.nl/smartextenderWhat can be the problem and how can it be solved? 

We want to be able to check if an IAM application is active. We could sent an API request to Indicium to select the ACTIVE indicator from the GUI_APPL table for the GUI_APPL_ALIAS. But I was wondering if there is an easier and better way.  

In our use case, we have a history table which shows the value in grid as below:In order to get the valid from and valid to time as local but not UTC, the domain has been updated with time zone as Local from Show as stored.After this update, the data is not returning all the columns:Could someone help with this scenario?

Since the introduction of temporal tables, code history tables are gone. But when we make changes in templates, we sometimes like to simply see the complete code history, also changes made in previous project versions (/ branches).I don't think code the Code Review tab doesn't work that easy. Or do we miss something? 

Hi,In our application, the user selects a row and in the detail tab of that row there are multiple items. When all these items have been completed, the row in the main screen disappears from the view. This leads to issues, as the following error pops up: "Request error: The object cannot be found. You may not have sufficient permissions or the object may have been deleted." Or in Dutch: “Fout in de aanvraag. Het object is niet gevonden. U heeft mogelijk geen rechten of het object bestaat niet meer.”I tried resolving this by putting the task in a process flow which closes the document when there are no more items, but the error pops up anyway. How can I resolve this? 

Hi for a external application we would like to update records using the ODATA API. but we’ve noticed that updating foreign keys returns a `403 Forbidden`, but mutating the normal columns update fine.We’ve tried this using a PATCH/POST request and a STAGED record, both fail in the end. curiously the STAGED record only adds the non-key values to the STAGED record even when u try to pot a key in, it does not accept it.We currently work around this using a subroutine, but would be alot better if we could just mutate the record directly instead of writing subroutines for every table we need. Using a patch:Using a POST requestUsing a staged record, adding the key values in the initial post request results in only 1 column being added instead of 5 

hi,We have added a data conversion for a new, mandatory column in a table. The default value is an expression, getting the value from another table “settings”.The problem is, that this table “settings” also has some changes in this update, and the tabel is also rebuild during the update. So at the time the value should be calculated, the table setting is renamed __setting__ and the new table is empty. So no value is found and the update fails.Is it possible to have some sort of sequence in rebuilding the tables? Or how can I solve this issue?  

Hi all,  Is it possible to change filter form label to "Search on item#"?

The delete functionality does not seem to work on multiple rows at once, it only deletes one. Is there a setting I’m missing to make it applicable to all selected rows?

Hi, I need to process a large number of files in a folder, one by one. The files are in a folder on the local machines of the users. At the start of the process I do not know the name of the folder, and I do not know the names of the files. The application is using the Windows GUI. In a process flow I first ask the user to select the folder. This goes well. Then I need to find the names of the files. I would like to use the List Folder connector, but that is only supported in the Universal UI. And we are on Windows. - Because the files are on the local machine of the user, using SQL Server to get the file names also is not an option. Placing the files on a server instead of local machines also is not an option. How do I create an equivalent of the List Folder process action that will work for my application?