Questions & Conversations

Software Factory & IAM (Installation, Development, Deployment, Integration) | E-learning | Documentation | Community

  • 2,338 Topics
  • 7,951 Replies

2338 Topics

Rucha Naik
Rucha NaikPartner
asked in Questions & Conversations

Can the process action refresh table be used in a system flow?

Hi, Is it allowed to use a refresh table inside a system flow. When I use it, it do not seem to refresh the table.I have a task to send email on → email table, after the task is pressed (it updates value for system flow),a system flow triggers and sends the email. The status in the table do not change unless manually refreshed. What can be the solution for this issue?

2
Rucha Naik
3 months ago
htimmermans
Captain
htimmermansCaptain
asked in Questions & Conversations

DEFAULT_TESTCASES base project missing in our SF?

Hi,In the Thinkwise documentation we read something about Default Testcases (Process tests | Thinkwise Documentation (thinkwisesoftware.com)). We wanted to have a look at this, but much to our supries no base project can be found called DEFAULT_TESTCASES. Is this something that has been added in versiions 2023.2 or 2023.3? I can't tell if the documentation is suitable for all versions or just the latest. We are running version 2023.1 of the SF. 

1
Mark Jongeling
Administrator
3 months ago
L
Linde van DyckPartner
asked in Questions & Conversations

filter condition 'between' not visiable in GUI 2023.3

Hi, I want to add a filter form to a screen to make it possible to filter the results. in the grid. since the added_on is generated, i can't use it in the filter form. I added a lookup field to show the generated added_on field with the following expression: (select cast(convert(varchar(11), added_on, 105) as nvarchar))The expression field has the domain ‘name’ which is a NVARCHAR(200).  In subjects i've set the filter condition to ‘Between', but it only shows ‘Equal to’ in the grid. I can change it to ‘Contains’ and this does change and shows in the GUI.  I would like to know what i can do.Kind regards,Linde

2
rbiram
Hero
3 months ago
M
Sidekick
Mark LeunissenSidekick
asked in Questions & Conversations

How to set up the Process flow monitor in universal

Hi, With the recent release, I was curious to use the process flow monitor in Universal.However, after trying via different routes (IAM, indicium in developer mode) the monitor stays empty.  The documentation about this new feature is quite brief. Could anyone explain what steps must be followed, other than having Developer mode in IAM? Kind regards,Mark

7
A
Superhero
3 months ago
J
Rookie
JimQRookie
asked in Questions & Conversations

Any idea when we can expect the release of the Import wizard?

In the release notes for 2023.12 b1.0 on September 1, 2023 is stated that the import wizard is being built.Do you have any idea when we can expect the release of this wizard? We're eager to try this. 

1
S
Moderator
3 months ago
P
Apprentice
Pierius Lycklama A NijeholtApprentice
asked in Questions & Conversations

How to restrict OpenID connect authentication on a client application

As mentioned in the documentation, OpenID Connect allows a client application to let users authenticate via the Thinkwise Platform (https://docs.thinkwisesoftware.com/docs/iam/client_apps#openid-connect-authentication)How can you give specific IAM users the right to authenticate on the client application?I don't want all IAM users to be able to authenticate on the 3rd party client application.

6
V
Moderator
4 months ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

Universal back from detail to form

I wonder how you can navigate back from a detail screen to a form in Universal, in case the detail screen is opened via a detail button. Like the scenario below:    

4
Harm Horstman
Superhero
4 months ago
Rucha Naik
Rucha NaikPartner
asked in Questions & Conversations

Email connector from address gives error

Hi,For the process flow to send out email from the application , earluier SMPT connector was used. However after the client updated to microsoft365, SMTP connector is not supported and the emails were no longer sent.To overcome this Email connector is used instead of SMTP connector. However, I am getting the error for the From address in the email provider:  2023-12-07T16:50:16.8980307+01:00  [ERR] Process action "email_connector" in process flow "send_email_from_queue" in application 147 threw an exception. (dedd009e)Status Code: ForbiddenMicrosoft.Graph.ServiceException: Code: ErrorAccessDeniedMessage: Access is denied. Check credentials and try again. process flow :  Email providerPlease let me know if I am missing something?Using Email connector instead of SMTP connector and giving the known credentials in the email provider to set up should be sufficient, isnt?Also the emails needs to be sent out from address provided in the application (that may differ) How can this be encorporat

2
Mark Jongeling
Administrator
4 months ago
A
Rookie
avanderveldenRookie
asked in Questions & Conversations

block username

Is it possible to block the use of a specific username. We see some hacking attempts with a specific username. Is there an option that username cannot be created? Or can we create a blacklist?

3
Jeroen van den Belt
Administrator
4 months ago
E
Sidekick
Ezgi EsenSidekick
asked in Questions & Conversations

Refreshing a table after closing a pop-up

Hi!I’ve checked the community regarding refreshing tables in process flows. But I could not find a solution which complies with the wishes of our users.Our users mostly work in the windows GUI. One of the processes includes a view with a task. A pop-up containing another view appears after the user clicks on the table task. When the user is done with the pop-up, it is closed automatically. The previously mentioned view is still present after the pop-up is automatically closed. But I want to refresh that view. I have tried the following:Open document (try to use an existing tab = yes). Change filter (to open the record) Activate detail Refresh tableThis does work. But is not practical because it clears the filters applied by the user. It also takes some time because it tries to re-open the view. Auto refresh is also not very practical in our case because the view can vary from a couple of records to thousands. Can you help me finding a solution which might be faster and does not clear t

5
Jeroen van den Belt
Administrator
4 months ago
R
Hero
RolandHero
asked in Questions & Conversations

Correct environment variable for user's documents folder in all situations

Our users are logged in through various methods. Some have managed systems, others log in via RDP. Sometimes a user has their files synced with Onedrive, others have a profile folder on a shared drive via redirection. This leads to reports with export to pdf setting being saved in various locations.For a process flow we were able to program one of these file paths by putting a username variable as part of the path but this renders the flow unusable for quite a few of our users. The flow uses a move file action but it often can't find the exported pdf file. Therefor we need a more generic approach.What folder does the export to pdf option use internally to determine where to save a file? I've tried %USERPROFILE%\Documents but already in my own case this leads me to the wrong folder.

3
Eric F
Rookie
4 months ago
T
Vanguard
Timothy MentowidjojoVanguard
asked in Questions & Conversations

Difference Web GUI & Universal lookup

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?

5
M
Moderator
4 months ago
W
Apprentice
Wilfred BossenbroekApprentice
asked in Questions & Conversations

IAM login : Login failed for user 'test'

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

3
Erik Brink
Moderator
4 months ago
Blommetje
BlommetjePartner
asked in Questions & Conversations

Process flow add row fails on first run

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 

2
A
Superhero
4 months ago
T
Apprentice
timApprentice
asked in Questions & Conversations

Azure : Query Performance Insight → Long Running Queries

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

2
Jeroen van den Belt
Administrator
4 months ago
L
Rookie
Laurens WolfRookie
asked in Questions & Conversations

Devexpress with multiple queries

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.

2
Jeroen van den Belt
Administrator
4 months ago
M
Rookie
MVeldkampRookie
asked in Questions & Conversations

Detailed form view page selection

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

4
E
Moderator
4 months ago
mperrott
Hero
mperrottHero
asked in Questions & Conversations

IAM auto-provisioning of Users

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

7
A
Superhero
4 months ago
H
Sidekick
HJ van DalfsenSidekick
asked in Questions & Conversations

Parametrized template error due to XML in the code

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?

2
E
Moderator
4 months ago
P
Rookie
PeterKeerisRookie
asked in Questions & Conversations

SF 2023.1 bug: Resolved conflict templates not ready for review after merge

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.

1
Jeroen van den Belt
Administrator
4 months ago
H
Rookie
Heini VenebergRookie
asked in Questions & Conversations

Login in Thinkwise is greyedout and no other username can be entered

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?

2
H
Rookie
4 months ago
A
Apprentice
AlfonsMApprentice
asked in Questions & Conversations

Newbie question: No project version has been entered.

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?  

5
A
Apprentice
4 months ago
X
Rookie
Xavier de BondtRookie
asked in Questions & Conversations

Validation Error after upgrading SF - Unique index is equal to the full primary key

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

2
X
Rookie
4 months ago
Rucha Naik
Rucha NaikPartner
asked in Questions & Conversations

Creation of xml (exact globe) from sql for importing invoice

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

2
Rucha Naik
4 months ago
H
Rookie
Heini VenebergRookie
asked in Questions & Conversations

Black screen with universal GUI on Android

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?

1
E
Moderator
4 months ago

Badges

Show all badges
Terms & ConditionsCookie settings