Questions & Conversations

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

  • 2,344 Topics
  • 7,993 Replies

2344 Topics

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: 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

2
Gosia
Apprentice
4 months ago
Sulea Ema
Vanguard
Sulea EmaVanguard
asked in Questions & Conversations

Http connector error

Hello!I have this error in the error log "Process action "connect_to_api" in process flow "process_flow_test_api" in application 2 returned the following message: "The external webserver (…..) responded with the following error: 'The remote server returned an error: (401) Unauthorized.". I have tried to call the process flow from Postman with the Post method and I get status 201 Created .We have a client certificate on that server and my ip address and the ip address of the app are whitelisted.Do you know what can cause this error in the error log ? 

2
V
Moderator
3 months ago
M
Apprentice
martijngaasbeekApprentice
asked in Questions & Conversations

Application crashes with red crosses

Normally the top menu and the filter (in the menu) are shown there. But sometimes the application crashes and there are red crosses shown…  there is no error shown before or something.  

2
M
Apprentice
3 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
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
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
Captain
Alban_TCaptain
asked in Questions & Conversations

exclude images from html control

Can we exclude the usage of images in an HTML control?We need HTML formatted text but the users are not allowed to insert images.I'm hoping to find something better than issueing a message AFTER saving the record :pWould be a pity if someone is typing a big long text with images only to discover afterwards that he/she shouldn't have used the images...

2
A
Captain
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
4 months ago
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
A
Superhero
Arie VSuperhero
asked in Questions & Conversations

Universal GUI 2023.3.13 BETA: Questions about new features

We deployed the latest Universal GUI 2023.3.13 BETA and we're trying to figure out a couple of new features. However, we don't see the Screen types or Details options in the Overflow menu. Apart from the setting ‘Available for user preference’ on Screen Type, what other pre-requisites apply?NOTE: We are still on TWP 2023.2 and ran all Hotfixes. The Release Notes also state this:Another change is that you can now place both a taskbar and a task tiles component on a screen. Previously, the taskbar would be removed. Multiple taskbars on one screen are also possible.That sounds great, but what is the use of showing multiple taskbars and/or task tiles if it's not possible to assign Tasks to a specific bar or tile component? Or is it an indication that the below Idea will be delivered with TWP 2024.1?Assign tasks, reports and prefilters to a bar like details | Thinkwise Community (thinkwisesoftware.com)

2
A
Superhero
3 months ago
Hugo Nienhuis
Superhero
Hugo NienhuisSuperhero
asked in Questions & Conversations

between operator in universal gui

As of version 2023.3.12 the between operator has been added to the filter in the universal gui. However, when I apply this operator on a nvarchar, int or date field, the filter field remains unusable/read only. Does it require an extra setting to function or is this a bug? I am currently using 2013.3.13. Operator ‘contains’ and  ‘equal to’ result in an editable field, operator ‘between’ does not: 

2
Hugo Nienhuis
Superhero
3 months ago
NickJanssen
Sidekick
NickJanssenSidekick
asked in Questions & Conversations

Unable to show row totals in pivot grid in Universal

Despite checking the following fields on the cube view I created:Screenshot of cube settingsI am unable to show the row totals in a pivot grid. Both the row total & row grand total are not working at the moment. Is this a known issue or am I doing something wrong with the settings?Next to checking the 2 boxes, I experimented with adding a “Total” for the cube view field (of type “Data”) I want to be summarized with no success so far. It seems that adding a column total is working.I just upgraded Universal to the newest version (2023.3.13).

2
Erik Brink
Moderator
2 months ago
P
Captain
Peter KruisCaptain
asked in Questions & Conversations

Dynamic report

I would like to generate dynamic Crystal Reports, where the customer (not the client which runs the application) can put the RPT files somewhere on disk, and via the Thinkwise Universal API I would like to run that RPT with passing parameters given in the API and save the pdf somewhere. I does not need to open the report itself in the application.For now I need to upload my RPT file in the Software factory and do a deploy each time. This is not realistic as the customer has their own developer and has about 1k reports do change

2
Jeroen van den Belt
Administrator
2 days ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

Passing parameters in a DevExpress report

It is the first time I am using the DevExpress report designer and it is not clear to me how report parameters can be passed to a query.I am unable to report the desired data from the Windows GUI.Can someone explain? 

2
Harm Horstman
Superhero
5 months ago
A
Rookie
avanderveldenRookie
asked in Questions & Conversations

No filter options in grid

Extended filter is empty, where in a simular view, it is available. Why does it not show any options?  

2
A
Rookie
5 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
R
Sidekick
Robert Wijn 2Sidekick
asked in Questions & Conversations

Cancel a form with empty mandatory fields using a task

Hi,I would like to know if it is possible to cancel editing an auto-edit/auto-save form using a task.The situation is next: we have several actions a user can perform within a form, based on table tasks like, submit, print and cancel. We have choosen to place these buttons at the right bottom corner of the form. The default behaviour of the tasks is that Thinkwise will perform a save and with that validate if all mandatory fields have a value. If not, a message will be shown and the task will not be executed. For the submit and print tasks this is the way to go. For cancel however, the save and mandatory field validation should not occur. Any empty mandatory field will show the exception message and prevent the task from executing.I know it is possible to first use the generic cancel button and then the task button, but this needs two actions by the end-user instead of one.Is there a way for a task to bypass the mandatory field validation and be executed regardless of the subjects stat

2
R
Sidekick
4 months ago
D
Rookie
Dennis1690Rookie
asked in Questions & Conversations

Column sorting date doesnt sort accordingly

Hi, I'm fresh, sorry for any mistakes.Usecase: Users want to column sort respective tables on date, this doesnt work as we intended. (Screenshot below post)What doesnt work?  Datenotation(timezone) in the date domain (widely used) is set to local (Netherlands) but the grid still shows a MM/DD/YYYY Notation.  Sorting doesnt seem to work as intended. It drops a random 2022 row between a 2023 rows. What have I tried?Tried to set the datenotation(timezone) to ‘Show as stored’ and back to ‘Local’. Tried looking for hidden sorts on the grid, there isnt any. Checked if the date is stored as something different than a date (like string, int, etc)When is my problem solved?The moment sorting works again as intended, even better would be a small explanation why it does(n't) work. Thanks in advance. 

2
D
Rookie
4 months ago
Guido Bijl
Apprentice
Guido BijlApprentice
asked in Questions & Conversations

Auto generated update handler

In our project we have added trace fields, the ‘problem’ we are having with auto generated update handlers is that [added_by] and [added_on] are part of the update handler. This means they are either overwritten of you have to do a select of the current added_by/added_on when exec an auto generated update handler. Is there a better way around this problem? Other than manually making each update handler or doing a select before executing, this feels like wasted performance. I understand that trace_fields is a seperate project that we’ve added, but i’ve seen it in many thinkwise projects, also the SF itself uses trace fields.

2
Guido Bijl
Apprentice
5 months ago
D
Rookie
Dennis1690Rookie
asked in Questions & Conversations

Same code, different message behavior.

Hi, I've written a SQL statement that checks if value A > value B. If thats false Value A gets a reset and the system throws a tfs_msg. The code is ‘copied’  from an already working functioning pop up message, however it work significantly different. Does anyone know the source of this issue and how I can solve/ troubleshoot it?Thanks in advance. Error (code supplied in screenshot): Expected result (same code construction, different properties, code supplied in screenshot): Code: Upper code is screenshot 2, error code is screenshot 1. 

2
D
Rookie
4 months ago
T
Vanguard
Timothy MentowidjojoVanguard
asked in Questions & Conversations

How can i disable paging and disable max no of records?

I have an issue where i have a procesflow that opens a document which then filters on a specific activity id. The activity has more that 100 items connected to it. Currently i have this as my configuration: This gives me 1 page but limits me to 100 records. if i set the maximum to 300 for example i would be able to get all the records(items) but not if another activity has 600 items.Is there a solution for this?

2
E
Moderator
4 months ago
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.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

2
Rucha Naik
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
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
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

Badges

Show all badges
Terms & ConditionsCookie settings