Skip to main content

Questions & Conversations

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

  • 2,884 Topics
  • 9,949 Replies
2884 Topics
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.Da

1972
Jeroen van den Belt
Administrator
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 mus

714
E
Moderator
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 possibl

2757
Arie V
Community Manager
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?

512
E
Moderator
P
Captain
PeterKeerisCaptain
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.

411
Jeroen van den Belt
Administrator
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?

472
H
Rookie
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?

755
A
Apprentice
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

532
X
Rookie
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 &amp;, &lt;, &gt;, &quot; and &apos; respectively So updated the Descritption to below code : '&lt;![CDATA[ ' +cast(i.display_invoice_number as varchar) + ' ]]&gt;' as Description The output after processed in Exact : Image from

642
Rucha Naik
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.0 Does anyone recognize this behavior?

672
E
Moderator
Tejo van de Bor
Captain
Tejo van de BorCaptain
asked in Questions & Conversations
Executing procesflows from multiple rows

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?

923
Tejo van de Bor
Captain
DenisaViulet
Sidekick
DenisaViuletSidekick
asked in Questions & Conversations
Edit usr_id in IAM

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?

963
V
Moderator
Gosia
Apprentice
Gosia
asked in Questions & Conversations
After upgrade the stored procedure get_gui_elemnt is running slow

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: 436721 GUI 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 pro

1302
Gosia
Apprentice
Rucha Naik
Rucha NaikPartner
asked in Questions & Conversations
The badge on tiles color format

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

672
Rucha Naik
M
Sidekick
martijngaasbeekSidekick
asked in Questions & Conversations
Redirect session lost after 4 minutes

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 credentials Expected flow: User is redirected to the redirect url that is provided with the initial request Current 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:

1254
V
Moderator
R
Sidekick
Richard EldermanSidekick
asked in Questions & Conversations
Creating IAM Users in scheduled flow in custom application leads to not_authorized_usr_admin error

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?

606
R
Sidekick
Sulea Ema
Vanguard
Sulea EmaVanguard
asked in Questions & Conversations
Http request headers

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!

661
Ricky
Superhero
ElenaTodirenchi
Vanguard
ElenaTodirenchiVanguard
asked in Questions & Conversations
Change the way of how the data is shown

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

1163
Jeroen van den Belt
Administrator
Blommetje
BlommetjePartner
asked in Questions & Conversations
Show data from connecting tables without a view

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

784
Jeroen van den Belt
Administrator
M
MatteoSangiorgiPartner
asked in Questions & Conversations
Scheduled sysytem flow stops running

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:34 Than 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. (09f

1117
V
Moderator
Dennis van Leeuwen
Hero
Dennis van LeeuwenHero
asked in Questions & Conversations
Conditional layout colour instead of theme settings

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

461
E
Moderator
M
Rookie
MVeldkampRookie
asked in Questions & Conversations
Apply user rights to data base with mu

In the documentation for the tenats, an example is shown for multiple applications (multiple Idiciums) linked to a single data base is shown. Where each application has there own tenants URL: https://docs.thinkwisesoftware.com/docs/iam/tenants We have created two applications, one for the operations and one for requesting data through the API. Where each applications has there own tenants, with different names. Now if we want to apply user rights to database, we get the following error message; “Could not apply rights for the application because there are multiple tenants assigned to the application” I can't find what I'm doing wrong in this instance. Can someone explain what I have to change, in order to setup the two application correctly, that I can apply the rights to the database.

581
E
Moderator
M
Captain
Marc FerketCaptain
asked in Questions & Conversations
Error message popup too small in DevExpress

The error pop up in devexpress is too small. When you get an error, for example when your query is invalid while managing queries, a pop up will appear with the error message. The text will, in this case, first show the query and always put the actual error information at the end of the text, however the query text is often too long to fit on the screen. The first image shows an example where the error information is only just visible and the second image shows an example of a longer query where the error information is not visible. It would be useful if there was a way to show the entire message, for example: Being able to drag to make the pupup bigger or being able to click on "more" which automaticly makes the popup larger. A quick easy fix could be to at least show the error information first in the message and then the entire query. Is there a way we can make the entire error message visible? Image 1 Image 2: error message is not visible

391
E
Moderator
Dennis van Leeuwen
Hero
Dennis van LeeuwenHero
asked in Questions & Conversations
Upgrade Windows GUI - Select GUI executable

For the deployment of a new Windows GUI, does it matter whether you choose the TSF_ClickStarter or the TSF_dotNET .exe?

581
E
Moderator
Ricky
Superhero
RickySuperhero
asked in Questions & Conversations
Previewing outlook items and how to handle MSG's

So we have this fancy way of letting our customers upload documents into our application. We then try to show them a preview when possible in the preview component. If said preview is not possible to generate a message will appear according to the documentation: “If a preview cannot be generated for a file, the preview component will state 'No preview is available'.” Now things do get hairy sometimes – when a “.msg” is uploaded, there is currently no way to determine what kind of file this is, it can be an email, an appointment, a note or any other kind of thing. When you are familiar with the msg extension, you probably are aware that this can be any kind of Outlook item. Most of the less tech savvy users are actually not that familiar with this phenomenon. When the current preview component is provided with anything other than an msg file that is actually an email, the preview component will either crash in the foreground(Windows GUI – up until latest version (2023.3.11)) or show not

892
Ricky
Superhero

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