Skip to main content

Questions & Conversations

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

  • 2,915 Topics
  • 10,067 Replies
2915 Topics
B
Rookie
BrechtvGilsRookie
asked in Questions & Conversations
Unit test type subroutine

Hi, We are implementing unit tests and want to keep track of our progress. However, we have several unit tests with the unit test type 'Subroutine’. This unit test type is not taken into account in the analysis. How can we keep track of our subroutines (i.e. functions and procedures) in the different cubes? The unit test types: And the code groups show in the cubes:

711
Mark Jongeling
Administrator
Frank Wijnhout
Thinkwise blogger
Frank Wijnhout
posted in Questions & Conversations
Make your logging data available in the GUI

This is an Archived topic. The solution is available in the Thinkstore inside the Software Factory. Goal When you have system versioned tables in your database, SQL Server logs all changes made to the data in those tables. This solution makes this logging data available for the user. This can look like this: Solution The solution in this topic creates views on all system-versioned tables. These views give the user access to the logging data. Also, all of these views get conditional layouts in the Software Factory. These conditional layouts give fields with changed values a color, which makes it easier to analyze the data. Dynamic model meta_view_history This code create a view definition for every system versioned table, along with conditional layouts to point out changed data. When you add this code to the dynamic model, you have to change a few values first: @screen_type_id Your desired screen type: You can keep this null, or change the value. @original_date_column Name of an existin

88516
P
Captain
Bas
Vanguard
BasVanguard
asked in Questions & Conversations
Indicium/Universal login flow

At a client, we’re going to deploy the universal interface in a short while. While testing the client found an interesting flow concerning login and password recovery that is undesirable. Happy flow In the universal interface, the user clicks the password recovery link. The browser is redirected to the indicium interface. The user enters their username/email and a token gets sent out. The user enters the token and new password en hits enter. The user enters a username and password to log in. The user enters their email TOTP token. The user gets redirected to the universal interface. What happened during testing? Somehow the client manually went back to the indicium interface. And started the password recovery there. The process worked the same except he didn't get redirected to the universal interface as no redirect URL was available. They also tried to log in at the indicium interface, the login was successful but the client got stuck as they didn't have an application interface avail

1233
D
Moderator
Dennis van Leeuwen
Hero
Dennis van LeeuwenHero
asked in Questions & Conversations
401 (Unauthorized) - GET $eager=profile_picture

When opening the Universal GUI login page, DevTools gives a 401 (Unauthorised) error. After logging in with a user with a picture uploaded in IAM the error is shown again. GET https://office.niverplast.com/indicium/iam/iam/i_ui_usr?$eager=profile_picture401 (Unauthorized) 401 - unauthorized. The user is not logged in to Indicium (anymore). Note that the login page will execute i_ui_user before login to validate whether the user has logged in or not. This may cause a 401 error on purpose if not. Once logged in, the profile picture is displayed correctly. Isn't this GET request an attempt to read the IAM profile picture? Isn't it unnecessary that the request is fired at the login screen?

681
Mark Jongeling
Administrator
Hugo Nienhuis
Superhero
Hugo NienhuisSuperhero
asked in Questions & Conversations
error in sql_indexes during generation after upgrading to SF2022.2

We have upgraded the SF to 2022.2. During the generation of the project the following error occurs on sql_indexes: The MERGE statement conflicted with the FOREIGN KEY constraint "ref_prog_object_item_prog_object_item_parmtr". The conflict occurred in database "sf_raijmakers", table "dbo.prog_object_item". We were unable to find missing or false keys. We analyzed the generated code which looks like this : /* Create index 'besteld' on table 'inkoop_order_regel'. */ if exists (select 1 from sys.fulltext_indexes fx join sysobjects ot on ot.id = fx.object_id join sysindexes ix on ix.id = ot.id and ix.indid = fx.unique_index_id where ot.xtype = 'U' and ot.name = 'inkoop_order_regel' and ix.name = 'besteld') drop fulltext index on "inkoop_order_regel"go if exists (select 1 from sysindexes ix join sysobjects ot on ot.id = ix.id where ot.xtype = 'U' and ot.name = 'inkoop_order_regel' and ix.name = 'besteld') drop index "besteld" on "inkoop_order_regel"go create nonclustered index "besteld"on "i

613
Mark Jongeling
Administrator
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations
Shortkey to execute task

Is there a ShortKey (e.g. Ctrl+Enter) to go directly to the 'Execute' button in a task from any field? Users wish to complete a task faster, by skipping optional fields, without having to use the mouse. Example:

341
Mark Jongeling
Administrator
S
Apprentice
SergioApprentice
asked in Questions & Conversations
Change image of forgot password page

Is it possible to change the image on the "forgot password” page and the following pages such as the "Enter token and new password” page

521
D
Moderator
N
Rookie
Nadia MittererRookie
asked in Questions & Conversations
Multi-Tenant application with IAM Tenant on one data base guideline/documentation

Hi, I'm trying to create a SAAS project with thinkwise. My request is to store the data of all customers in a single datadase. I did read the Tenants documentation and I think, that I need to create a "Multi-tenant IAM & Multi-tenant product" solution. Is there any documentation of best practices on how to create a Multi-tenant product? Thank you in advance

1032
Mark Jongeling
Administrator
D
Vanguard
Dennis BeerenVanguard
asked in Questions & Conversations
How to display percentage in the UI (when value in DB is in decimals)?

I am looking for a way to display a percentage in the UI, while the column contains decimal values in the database. E.g. 0.51 in database displays 51 in UI. I expected that the domain control field 'Percentage’ would do the trick, but it doesn't. The documentation is not very specific about what the Percentage control does when it is selected in a domain: I cannot be the first to deal with this issue, hence I hope that somebody here can point me in the right direction. Thanks in advance!

3695
Freddy
A
Anne VriesPartner
asked in Questions & Conversations
Process flow open document filter performance

Hello I have an issue with the performance of one of my screens which is opened with a process flow.The main problem is that I want a filter to apply to the open document action before it retrieves all rows.This images might clarify my problem I was wondering if somebody had a solution/workaround which allows me to apply filters to open document actions like this? I think a possible solution in my case is to make a reference to the document I'm trying to open and just present it to the user as a detail screen then the reference columns become my filter in the WHERE condition. But I would rather just open it as a new document.

1443
A
eurban
Captain
eurbanCaptain
asked in Questions & Conversations
focus tasks butoon

Is it possible to set focus on task button

575
Mark Jongeling
Administrator
ElenaTodirenchi
Vanguard
ElenaTodirenchiVanguard
asked in Questions & Conversations
Task parameters

Hello, I created a task a week ago and today I added a new task parameter, but when I edited the functionality the new parameter didn't show up. How can I make it appear?

482
ElenaTodirenchi
Vanguard
mperrott
Hero
mperrottHero
asked in Questions & Conversations
Azure AD single sign on in Universal GUI

Dear all, As per subject I’m trying to setup the SSO on the Universal GUI for part of my users and facing an issue. The documentation mentions the setup of the SSO from Thinkwise perspective which is sufficient, but there is no documentation at least for the setup for Azure/AWS/Google perspective what is actually needed. My Setup: I have a Resource group (RG) called TEST I have a VNET for the RG I have SQL server and App service in the VNET I have a Front Door having the default *.azurefd.net and my custom domain The Front Door points to my App service and redirects traffic correctly. The Indicium and Universal are installed on the App service. The whitelist of client redirect URLs in IAM is my custom domain only. For the SSO: I have done the App registration I have added the new configuration in App Service for the OpenID Microsoft authentication I have added my custom domain on App service Problem I face and would like some input is that, The App registration requires that the Redire

2964
Sjors Niesten
Apprentice
Alex Kerschkamp
Captain
Alex KerschkampCaptain
asked in Questions & Conversations
Microsoft Graph issue

Hello everyone,Because the new Exchange connector that is scheduled for the month November of this year will not give adequate possibilities for our client, we're trying our luck with Microsoft Graph. We created a call and made it fit our needs using Postman.We configured and use all the right credentials (client ID, tenant ID and client secret) for token generation. Actually, we created a call for getting data, and one for patching data. The call types are, of course, get and patch respectively. All calls are successful, and perform as expected, using Postman.Next, we went to our Software Factory, to make Thinkwise perform the same calls. Using a process flow, we make the proper call, the same as we did using Postman.We get a correct token in Thinkwise. When we copy this token from the debugger, and check it with jwt.ms, we get a valid token. In fact, when we use this token in Postman to make calls, it works perfectly. So, token generation works properly.However, the calls that work i

99315
Alex Kerschkamp
Captain
E
Sidekick
ericbosmanSidekick
asked in Questions & Conversations
Create a password in iam

I want to create a user in IAM which is only for service purposes. Nobody has ever to login on this user.Because we have many environments, I want to automate this.Creating the user is not a problem, but i do not know how to set the password with encryption. I see i need the password, a salt and the password-hash and then i understand that i can use the sql script: insert into usr_authentication ( [tenant_id] ,[usr_id] ,[password_hash] ,[password_salt] ,[password_algorithm]) Values ( … ) but in what way can i determine the values of the hash?

18211
E
Sidekick
pauloportu
Apprentice
pauloportuApprentice
asked in Questions & Conversations
cube view universal generates dateTime from date fields?

When producing cube view graphs in Windos GUI we see an expected row where we have a Date type field: However, the Universal GUI shows this Date field as follows: Question: how can we have a cube view where the row Date only shows a date without 'T00:00:00’? Please advise, thank you, Paul

945
Mark Jongeling
Administrator
Bas
Vanguard
BasVanguard
asked in Questions & Conversations
Base64 encoding

I'm having some trouble getting things to work. For a webservice we need to base64 encode our message before transmitting it. This worked fine untill we encountered a diacritical mark (ë, î, ú, etc) in the message we want to encode. Then the webservice we're contacting start throwing errors. I've created a test script to show the exact problem and to provide a starting point to hopefully find a solution to this issue. I contains a sample for a correctly encoded message and an invalid one. declare @source varbinary(max) ,@encoded varchar(max) --SAMPLE MESSAGES ONE WITH AND ONE WITHOUT DIACRITICAL MARKS DECLARE @message varchar(max) = 'Dit zijn diekrieten ë, î en ú.'; DECLARE @message2 varchar(max) = 'Dit zijn geen diekrieten e, i en u.'; --KNOW CORRECT BASE64 RESULTS AS CALCULATED WITH THE OPENSSL LIBRARY DECLARE @message_base64 nvarchar(max) = 'RGl0IHppam4gZGlla3JpZXRlbiDDqywgw64gZW4gw7ou'; DECLARE @message2_base64 nvarchar(max) = 'RGl0IHppam4gZ2VlbiBkaWVrcmlldGVuIGUsIGkgZW4gdS4='; --B

4816
Bas
Vanguard
Mark Leunissen
Captain
Mark LeunissenCaptain
asked in Questions & Conversations
How to limit API access

Hi all, Is it possible to limit the access to OData API apart from the rights (insert/copy/delete/update) on a table given in the SF? Since we do not want every user / user group to have access to the OData API, we would like to limit certain users / user groups. Thanks in advance.

2116
Mark Leunissen
Captain
Mark Leunissen
Captain
Mark LeunissenCaptain
asked in Questions & Conversations
How to abort a failed synchronization to IAM?

Hi all, I have a question concerning a failed synchronization to IAM. As can be seen on the image below, the synchronization to IAM has failed on the step ‘Synchornizing: project’. However, it doesn't seem possible to abort the failed synchronization. So, how do I abort a failed synchronization to IAM. I have tried to cancel it via maintenance → jobs, but this doesn't seem to work. Additionally, in maintenance → Jobs, the ‘active job’ isn't listed as an active job (second image) Thanks in advance. Failed synchronization No active job Error

14911
Mark Leunissen
Captain
Jeroen de Klerk
Vanguard
Jeroen de KlerkVanguard
asked in Questions & Conversations
Indicium Universal login URL

We have an internal API which consumes data from our Thinkwise application through Indicium. Up until recently we had been using Indicium Basic, however recently we have started our upgrade to Universal. For authenticating users with Indicium through the API, in Basic we used the URL indicium/(sf|iam)/<app_id>/$logout, to which we would send a basic authentication header supplied by the client calling the API. However, in Universal this endpoint does not seem to exist anymore. Is there a similar endpoint in Universal which allows us to authenticate users through a basic auth header? Other ways of authenticating users are of course also welcome, but some form of username/password authentication is preferred. Thanks in advance!

27010
V
Moderator
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations
Multiple instances of TSF in IAM

Is it possible to maintain multiple instances of the SF application in one IAM environment? I would like to do this in this way, because I want to store the model of various customer applications in separate databases. In this way, customer-specific knowledge stored in the model can be properly secured. It didn't seem to be a problem to do this, but when I opened the IAM environment I found out that only 1 SF application could open a project. The Project Tab is only visible for Environment B

933
Renée Evertzen
Moderator
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations
How to schedule a process flow?

I am trying to simply execute a task, without parameters with a process flow every hour. Indicium Universal (2020.2.2) is running, but I don't see any activity. The version of IAM is 2020.1 and al hotfixes are done. Could someone explain, step by step, what to do?

57028
Harm Horstman
Superhero
Kasper Reijnders
Kasper ReijndersPartner
posted in Questions & Conversations
Environmental badge to easily spot the difference between ACC, DEV and PRD

For a new customer I was setting up the environments and after everything was set up I found something missing. Since the application looks exactly the same on all environments (dev, acc and prod) I was missing a feature to easily spot the difference between them. Therefore I've implemented a simple css in the custom.css file. Between environments I've modified two parameters. content (‘DEVELOPMENT’ for dev and 'ACCEPTATION’ for acc) background (red for dev and blue for acc) For the production environment we did not implement this code. So if you see a badge in the left bottom corner it is not production. body > div:first-of-type::after { content: 'ACCEPTATION'; display: block; position: absolute; bottom: 1px; left: 1px; background: blue; z-index: 999999999999999999999999999999; color: white; padding: 10px 20px;} Since it is implemented in Universal it works for any application, including IAM. This is what it looks like:

971
Arie V
Community Manager
S
Rookie
Sandro BurgerRookie
asked in Questions & Conversations
Is there a way to check if a user is logged in and when his last activity was?

We need this because in the application we have workflow module and we have assign work items to active user only. Active user: user is logged in and his last activity is less then 45 minutes ago.

1783
Arie V
Community Manager
U
Warrior
UshaWarrior
asked in Questions & Conversations
Translated objects are not getting reflected in GUI

Hi Team, In GUI, translations are not getting reflected after refreshing object model. In SF all the objects are in translated state still it is showing as untranslated in GUI. Other user interface changes are getting reflected correctly. How to resolve this? Note: we recently migrated our projects to new environment and we are not sure, this could be the reason.

263
U
Warrior

Badges

Show all badges
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings