Questions & Conversations

Hi All,We have upgraded to the latest version and that went ok. Our automated deployment however, is off. Before, after all merges where done, we copied the latest version to a new version. So for example from 1.125.06 to 1.26. Set this as ‘production’ - set the previous version to 1.125 and the 020-upgrade script came out great. We then keep track of the executed scripts in _schemaversions, so we know if the script is executed on the db or not.  Yesterday I found out that this is no longer working ok. Lot of Db issues, and as stated here that it might ruin the Db. Well, it does.  In model Overview, I have a Branch ‘Main’ (prev. trunk) and several model versions. My build tool Calls the ‘deployment package task’. But all upgrades scripts are based on the version since the upgrade. So now in my repo I have three version; Version 004; 020 upgrade script “print 'Upgrade from MAIN (2023-02-07 16:21:11.24) to MAIN (2023-02-09 15:48:52.72)”Version 005; 020 upgrade script “print 'Upgrade from

Hi, I have a table; with a start_date and a end_date column. Both are a DATE domain. The end_date column has a domain with a constraint on it; start_date < end_date. However, I don't see anything happening in the gui. What should it do? I assume you know what I want here.. and I would like to display a custom message, explaining what's going on. Any advice on this? Thanks! Alex

Is there an easy way to monitor the status of Indicium. And also send notifications to application admins if the service is down?If Indicium is down for whatever reason, Windows GUI end-users should not immediately notice it, while external applications have no access.It might be an idea to have a status indicator (such as a traffic light) somewhere in the GUI for admins.

I’m having an issue with my charts inconsistently loading in the universal web gui. After a couple of refreshes, sometimes they load all at once, I sometimes get one or two to load  and sometimes they just dont load at all. I have 4 charts like this in one screentype.   

Hi, Is there an option to disable the Resize Columns button in the Menu Bar for the grid?Some users have customized the width of some of the columns in the grid, but then when they click by mistake on that button, that custom configuration is gone and they have to do the setup again. Regards,HJ van Dalfsen

Can I start Universal from the SF rather than doing a Creation, Validation, Sync to IAM every time I made a small change? 

Thursday 9/2/2023About 3 years ago my college Hugo Nienhuis asked about a SFTP-connector.The answer that time from Vincent was:Hi Hugo,The FTP Connector only supports FTP (File Transfer Protocol) and FTPS (File Transfer Protocol over SSL). It does not support SFTP (SSH File Transfer Protocol).Hugo made it a wish and 10+ people voted for it. Is there fresh news about this topic ? 

How do I turn this off? I have a view that calculates real-time timings, however I notice that because of lookups the view gets queried once for itself but then also for every lookup. There are many performance issues with this:Why the OR statements and not the actual pre-filter, they tend to be less performant than the exists clause in the pre-filter. Why all lookups are based on the base-table with a left join? Why not directly lookup on the lookup table?This setup is really killing me. Any advice here on how to optimize this situation? declare @handle int;exec sp_prepexec @handle output, N'@p0 int, @p1 int, @p2 int, @p3 int, @p4 int, @p5 int, @p6 int, @p7 int, @p8 int', N'SELECT t1.[process_id], t1.[process_task_id], t1.[tenant_id], t2.[description] AS [lookup_636502171]FROM [process_task_view] t1LEFT OUTER JOIN [tenant_definition_status] t2 ON t1.[tenant_id] = t2.[tenant_id] AND t1.[process_status_id] = t2.[domain_status_id]WHERE (t1.tenant_id = convert(int,SESSION_CONTEXT(N'tenant

What happened to the documentation on the FTP-connector?

The mobile UI has option for density : compact and comfortable.Currently by default its set to comfortable.Is there a way to set it to compact by default?I got the required information for Universal UI from , but not for mobile:  

Hey there,I have recently encountered an error - which might seem like a bug - about a look-up column. In this case we have a sounding date which I would like to attach to a report. Therefore I would like to see the most recent time up until the seconds, which was also confirmed, by a third party. So the column itself has a control type - date, but in the GUI this will be set to varchar, which ends up like thisThis is not the most charming. So I came up with a 2nd option, by adding a new column to this specific table with a varchar domain. Is there maybe a better approach not having the date-time-short domain converted to varchar?

Hi all,Currently when i double click on a row in Universal it opens the form detail as a new tab.is it possible to double click on a row and open a form detail as a pop up, just like a lookup?   

Hi there,for a client we have multiple interfaces to access the same application. Currently we're running two URLSclients.domain.com staff.domain.comBoth interfaces use the universal interface. Client wan't to implement OpenID for the staff to use.How do I configure the clients.domain.com Universal interface to only show the local account login and not the OpenID feature?Can't seem to find this answer in the documentation.With kind regard,Bas van Ginkel 

So currently as far as i know you can only run a schedule via process schedules in process flows. But the frequency values can only be edited by the developer and not by a superuser.The scheduler should come in "Technical Settings(table)".The options should be:Auto task trigger interface file(Invoices) :a. Off b. Hourly (Every (value) Minutes) c. Daily (Every (value) Time) d. Weekly (Every (value) Day)When the superuser changes the values in the Technical Settings table in the web gui the process schedule values should be altered. In conclusion Is it possible for a superuser to alter the frequency of a process schedule outside of software factory? How would i be able to achieve this?Is there an easier way?     

All of the tables and views created by the Software Factory are created with the ‘dbo’-schema in SQL.For reporting purposes I also have some views created directly in the database with an other schema, ‘rpt’ for example. I want to maintain these views also in SF, but I can't find (or I do overlook it) where to specify the schema. I see the field ‘View schema’, but that doesn't do anything. (Creation method = Template).Does anyone know how to get this working, or is this currently not possible?

Hi All,The scenario is simple.I have a User which logged in the application in Universal GUI 2022.10 and since then has not accessed the app. We upgrade the GUI to 2023.1.12 in the mean time.  They then try to access it now and get the top popup for New version is out etc.. but they ignore it.Not having latest GUI version will be mising optimizations, improvements, and functionality supported by latest version right ?How can we force the GUI update on the Users, so that when a new GUI version is out they automatically get it when loging in?Thanks

Is there a "Windows Gui"-like application for Apple computers?I see there is an “Indicum” app on App Store, is that one? I’ve config it with IAM and https://192.168.0.5/indicum/iam/iam link but it does not work (the ssl certificate is not a trusted one, of course)

We're using the deployment center to deploy our application. The test and production environment currently are on version 2.18 (from a TW 2022.2 instance). Now I've upgraded the Thinkwise platform and want to deploy the application again but now with the new version. This fails because ‘2.18 is not a supported upgrade version’ I can't find the ‘previous version’ option in the model, that used to be there, but I also cannot upgrade the application from the main branch.  How do I upgrade my application, using deployment center?   

We experience an error during the upgrade of the SF to 2023.1 regarding data mapping.Is this a known error? I am cleaning up our current projects and will investigate some more around the related data which could trigger such an error. But if you guys/girls have any clue, please help me.

Hi,I have some screens with auto edit/save, but when these are open and I want to log out, it gives a message that it is not possible to log out because there is still a change in a document, while this is not the case. Logout is only possible after closing all the documents.  

Why are scroll bars in the Universal GUI so very small and light grey? Users barely recognize them the first time.Or is it easy to adjust them with custom CSS? 

Hi,A small question about creating deployment packages. Where is the (previous) ‘version’ in this screenshot from the manifest coming from. In our case with models and model versions, we cannot get this filled with the previous version for which a deployment package was created:​​​Thanks in advance!

We recently started using temporal tables for example to retrieve an address as it was at a certain time in the past. However none of the ‘_history’ tables underneath their regular respective temporal tables get any users or roles appointed to them. For example our ‘adres’ table contains 7 roles whereas the ‘adres_history’ table has none.This is a problem because we want to use this for invoices for example where the invoice retrieves the address as it was on the invoice date. This is vital for invoice retention as is dictated by law. Temporal tables are a great alternative to having to print out all documents to PDF and keeping them in a backup.I can of course apply these roles manually and that’s probably what I have to do if this is intended behavior. I would like to read some other thoughts on this though before I proceed.

Hi,I read the ‘Code review’ blog but I think this will be mandatory for each project. But is it possible to set ‘Code review required’ for specific projects in Software Factory?

Hi. Where does the part of the deployment gets build up?alter table "process_task_dependency"add constraint "c_process_task_dependency_connection_type" check ("connection_type" in (-1, 0, 1))I have a domain connection_type that is used in 2 tables..  for some reason one table doesn't propagate the latest element in its check construction. There is a value 2 now as well. One table is going correct. The one shown here not.