Solved

Hey All,i have a lookup that looks at a table, the table does have multiple identical values for a specific collom.Universal gives me the duplicates : on the other hand in Web GUI the same column in the same environment in this case lab does not:What could be the reason for this?

I have the same problem as in this post, but in another context.Some info about our application:Built for Windows GUI RDMBS: SQL Server  Dozens of customers will use our application (installed at their SQL server) Users are logging in using ‘Windows authentication’ We're still on IAM/Indicium 2022.2 (planning to upgrade) Indicium is running as a service process, listening on port 5000 What I want to achieve: users log in with their own name, so IAM application roles and rights can be used users do not need to be known in SQL security; so the SQL connection from the IAM application should be handled by either: - a service account; - or a SQL account; - or an application role.Question 1:How can I achieve this for the Windows GUI?Related to this, I created a user with ‘Authentication’ set to ‘IAM', and changed the password.I started the application using an INI file containing "Authentication = iam”. When starting, the IAM login shows but after entering username and password, the error “L

Hi, Found a bit of a bug perhaps, but i'm not sure if it's me or Software Factory/ gui. I have 2 tables; Order and Order_unit. Order_unit is a detail of Order, hidden by default. When a 'order_type’ field in Order is set to ‘unit’- we show the detail tab through ctx. I have a process flow with these steps; Add row Order --> Decision (check if 'unit’ or not)If not - stop. If yes - Activate Detail Order_unit → add row Order_unit. (in grid) This works fine, the second time OR when you select an old Order row, and open the unit detail. It feels/seems that Universal does not completely load the page/adding or something. The second row Order, and it works fine, also when 'previewing’ Unit tab. We are up to date with our gui and all. Any thoughts? Blommetje 

Hi,in Azure SQL Database in Query Performance Insight → Long Running Queries I have a query (see screenshot) and I can’t seem to find what is triggering this query. In the second screenshot you can see that every execution takes about 7 seconds.I have an item table with a system versioning table called item_history in Azure database but I already checked in Software Factory if there is anything that could trigger the query but can’t seem to find anything.Does someone have an explanation for this ? Or can give me some pointers to look elsewhere.Thank you. Query in text:SELECT [tsf_valid_from],[tsf_valid_to],[$S],[$tabType] FROM (SELECT [tsf_valid_from],[tsf_valid_to],LAG ([tsf_valid_to]) OVER (PARTITION BY [item_id] ORDER BY [tsf_valid_from],[tsf_valid_to]) AS [$S],[$tabType] FROM (SELECT [item_id],[tsf_valid_from],[tsf_valid_to], 0 AS [$tabType] FROM [dbo].[item_history] UNION ALL SELECT [item_id],[tsf_valid_from],[tsf_valid_to], 1 AS [$tabType] FROM [dbo].[item]) AS R) AS T query item

I've made a report in TSF DevExpress Report Designer with one sql server data source using two versions of the same view (table). In DevExpress the report works perfectly, however in Thinkwise universal GUI it does not... I'm getting the following error message: ``2023-11-10T15:30:00.3996411+01:00 80002581-0001-fb00-b63f-84710c7967bb [ERR] An unhandled exception occurred while processing the request. (ffba027a)Prockees.Bootstrapper.ExecutionException: DevExpress.XtraReports.DataRetrievalException: Error when trying to populate the datasource. The following exception was thrown:Failed to connect to the database. To learn more, see the exception details.Exception details: Connection name: localhost_TCNTW_CREDITEUR_Connection Error message:A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) ---> DevExpress.DataAccess.Sql.

Hello, My question: Is there a setting or a easy way to make it so that it always starts on page 1 of your detailed overview incase you select a new article?Case setting information:We have created a overview of all our productes, with the current stock (Left side). On the right side you can see a detailed overview of the articles selected. In the image seen below, I've selected an article with 140 in stock. On the right side you can see a detailed overview of all the indiviual 140 products. which are devided over 3 pages. In this example I've now clicked on page 2. But when I click on anotherarticle on the left, with less products (this time 18 products).The detailed overview shows that there are no results.The overview is stuck on Page 2. For the newly selected article it wants to show a detailed overview of the products on page 2.But for the articles there are only 18 products, so they are all on page 1. If I want to see the detailed overview of page 1 for this product, I’ve must fi

Hi All, We want to create a new app for getting Applicants to submit their details for job postings we have within the Group.The process that will be followed is first the applicant is reviewed and secondly upon approval they can get further access to complete their profile putting more details. If an applicant is Approved to be a suitable candidate for a position then he will be transfered to our main system for hiring process and further checks.I know we can have OPENID providers configured in IAM and we can do auto-provisioning, basically they can authenticate with the external provider and we can add them to a default User group. We have currently this configured for our main system with Azure which auto provisions new users within our organization. How can I achieve auto-provisioning for creating IAM users to a default user group? the users will not be part of our organization thus we need them as IAM users instead of External connected to an OPENID provider. Would it be possible

Hi, We use often code with XML in our templates, like for processing the response of an SOAP API or using multirow parameter.Then we have the square brackets in the code, like what also is needed for parametrized template.When we make changes in the code and save it, then the error below is popping up in the Deploy tab.For now we copy the code and apply the changes in the related template and then we need to generate the control procedure again before deploying it, but that is lot of extra work.We are using the TW 2023.2.12 release. Is there a better solution for this or can the interpretation of the code being improved that it is coming from XML?

In SF 2023.1, after completing a merge session that had a conflict on a control procedure template, the control procedure of the template that had the conflict will not get the status ‘Ready for review’ from the merge session. This results in developers not knowing which control procedures should be reviewed after a merge.When a developer manually puts the control procedure on status ‘Ready for review’, the resolved conflict from the merge is marked as a change however.Expected result: Completing a merge session should put all control procedures of templates with resolved conflict automatically on status ‘Ready for review’. I remember this worked in prior SF versions.

The user had a login account. The user maybe used the button remeber me, but this is not sure. That in IAM the user is removed. It ends up in a situation that the user gets a login screen, but the username and password are grayed out.We tried clear cache and remove history. On this browser no access is longer possible to Thinkwise. Anyone a clue how to clear this one?

The past months I have worked on an old app (2021.3) which runs in the Microsoft cloud (Azure, SQL Server and Web App).Now I have upgraded the 2021.3 version to 2023.2 (IAM and SF/Application), but I receive the message above and its blocking me from getting it to work. My question is: how do I fix this problem and get my apps to work?  

After upgrading he SF from 2022.1 tot 2023.1, an existing model (± 5 years of development), is giving the following error: The error, stating ‘Unique index is equal to the full primary key’The consequence, according to the SF is the following: The consequence of this error, stating ‘Foreign key constraints may introduce dependencies on this unique index, causing it to become difficult to delete or re-apply. This will also result in errors during full code execution’However, when going through all the steps of creation, no errors occur.The solution, according to the SF:The solution of this error, stating that ‘Changing the index columns to not be equal tot he full primary key or delete the index’Since this was fine in version 2022.1, it is unclear what to do here.This was developed in collaboration with the professional services of Thinkwise. The usage if mainly for primary keys that include a date. All these indexes have the extension _unieke_datum (_unique_date but in Dutch). The exac

Hi, I have to generate an xml for importing invoice into EXACT globe. The xml will be generated using a sql code within a task. Can you please guide in what should be the CDATA format for the code? I tried below code for processing it: '<![CDATA[ ' +cast(i.display_invoice_number as varchar) + ' ]]>' as        Description Below is the error after its processed in excat : Image from EXACT Removed the CDATA and sent it as below : CONCAT('< ', cast(i.display_invoice_number as varchar), ' >') as        Description Still it was not processed in EXACT, and no error message was provided In the exact knowledge base its mentioned that below characters can be used :    string Strings in XML can contain all normal characters except &, <, >, " and '. These characters need to be replaced by &, <, >, " and ' respectively So updated the Descritption to below code :  '<![CDATA[ ' +cast(i.display_invoice_number as varchar) + ' ]]&amp

I am starting the Universal GUI (2023.2.11.0.0) on Android (android versie 13) with a firefox browser (version 119.0.1).Login as a user and do my thing. Continue with other work. Phone turns into lock. Want to continue on my phone. Unlock it and the universal gui pops up, but it shows a black screen (mostly, sometimes white).Only solution is killing the application and start this again.How to fix the black screen situation?Addition on the topic. Chrome doesn't give a black or white screen hang. In chrome we see a hang situation, visible by continous turning of the refresh button. Firefox a black or white screen (hang situation)Also happening in the latest GUI version 2023.3.11.0.0Does anyone recognize this behavior?

hi,When I select multiple rows in a grid and execute a templated task, this will be executed once for every selected row. But when I have a table task at the start of a processflow, and start this task with 3 selected rows, the task is only executed once.Is there something I’m missing? I don’t need a multiselectparameter solution, cause the tasks can be executed one by one. I am using the multiselectparameter for another task, can this be interrupting the default handling?

Hello! I am trying to edit an usr_id for an IAM user and the patch request from the http connector fails. I have also tried to call the “task_rename_usr_general” in a process or a task, but it returns an error: “"not_authorized_usr_admin"”. I have to mention that if I want to execute the exact same task manually from IAM, it works, it just fails if I try to call it externally (in a SF process/task or in the SSMS). Do you have any idea what could be the problem or if I should try another approach?

Hi, We recently conducted a production upgrade, and as a result, the end application has become significantly slower. We've observed that the following procedure is being invoked for each user. It appears that this procedure is called during startup, leading to a prolonged delay. How can we address and resolve this issue?/* Create or alter stored procedure get_gui_elemnt. */ session_id 151, cpu_time: 212742, total_elapsed_time: 750783 session_id 153, cpu_time: 251607, total_elapsed_time: 1344832 session_id 160, cpu_time: 240716, total_elapsed_time: 1293270 session_id 178, cpu_time: 250101, total_elapsed_time: 623093 session_id 231, cpu_time: 133600, total_elapsed_time: 436721GUI version: 2023.1.10.0.1 Windows GUI and Universal are slow. My second question is: Can someone explain to me the origin of this query and why it is consistently running or suspended?(@source nvarchar(256))SELECT type, data FROM sys.fn_MSxe_read_event_stream (@source, 0)session info: host_name: DB4C000001 program

Hi,I want to change the color for badge number on the tiles.requirementcurrently the tile is as below : current situationI updated below in theme for it: from the documentSynced IAM, however the changes are not reflected in the windows GUI. Am I missing anything? Please advice. Thanks,Rucha Naik

If the user doesn't login within 4 minutes on the login screen, the redirect is lost and the user gets the “Indicium is running”-page. We have received multiple emails from confused users because the 'Indicium is running' page does not provide any further instructions on how to proceed. Reproduction steps: From any app, go to the login-page (This is a request with a redirect URL) Stay on the page for longer than 4 minutes Fill in the correct credentialsExpected flow: User is redirected to the redirect url that is provided with the initial requestCurrent flow: User is redirected to the root URL of the indicium and sees a page with “Indicium is running”   Additional technical information:The cookie: “CookieTempDataProvider” has an expiration date of 4 minutes in the future. After that the cookie is lost and this is needed for the redirect URL.   Possible related issues:   

We like to automatically create users in IAM based on data in our custom application in that very IAM. It is intended to do this in a stored procedure which is involved in an automated process, started by a scheduled flow. This does not work. The error not_authorized_usr_admin is logged in the indicium log when trying to insert User records into the IAM database.It seems that the pooluser somehow does not have permissions to insert records in these IAM tables. We did some extra tests, which resulted in the observations that the code that creates the User records in IAM works fine in the situation when it is executed in Azure Studio in the same circumstances, even with the same authentication (being the pool user). This seems to indicate that the problem is somehow more complex. Can you please help us out in this matter?

Hello!What is the correct way to write the format of a header in SF? I have tried as example the way explained on this link: https://docs.thinkwisesoftware.com/docs/sf/process_flows#enable-the-message-protocol-independent-web-service , but it didn't worked for me.Thank you!

Hello,  I want to make some of the fields, which they are private, to be shown something like this: ******ing.Is there a possibility for that? Thank you  

Hi, When I have a table Activity with a connecting table to Item. This is the table Activity_item. Since I can connect several items to several activities. The connection table has 2 columns, activity_id and item_id, both the pk. The end user however would like to see more data from the item_table  weight, owner, position, etc. Currently we can one get this data by creating a view from the connection table, join the tables and show all data needed. This is quite unpractical. What other ways would be possible to solve this, since connecting tables will (almost) always need more data from the other tables. I do not want to save duplicate data of course..  Thanks! Blommetje  

I have a scheduled sysrem flow (Check_Machine_JobsRunn) that runs every 5 seconds.My sysytem flow check if there are any changes data on the machine and stores them on the database.I get data from my external resource till 31/11/23 alt 01:34Than it seems that, Indicium stops and restarts (i don’t know the reason) and kills the old process flows and create a ne ones (maybe with a new id).I see this on indicum logs: 2023-11-30T01:40:36.4418807+01:00  [WRN] No persistent storage location for data protection is configured. The Encrypt and Decrypt process actions are disabled.See the Thinkwise documentation on how to configure data protection. (51a9e278)2023-11-30T01:40:36.9161048+01:00  [INF] Initiating startup license check (a070e428)2023-11-30T01:40:36.9238294+01:00  [INF] Reading license from IAM. (d4563d62)2023-11-30T01:40:36.9297918+01:00  [INF] License successfully read from IAM. (66b06fb5)2023-11-30T01:40:37.1040291+01:00  [INF] License refresh scheduled for 2023-12-05 09:34:26. (09

Is there any way to deviate from the default selected-row theme for a conditional layout so that the conditional colour is also visible at the selected line (especially important if only 1 record is present).  SF Theme Conditional layout