Questions & Conversations

I have a UG version 2021.2.14 in place pointing to the SF (2021.2). Worked fine until I got an application error. Logged out but when trying to log back in it threw me this error.   ClientConnectionId:d37ec395-fb12-4a7a-90b2-81c235e8aaaeError Number:2812,State:62,Class:162021-09-07T16:00:51.2883957+02:00 0HMBI0NRHE62R:00000005 [ERR] TSFMessagesMiddleware: An unhandled exception occurred while processing the request. (fffadd8a)System.Data.SqlClient.SqlException (0x80131904): Could not find stored procedure '--'.   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataRead

I tried to copy a project and got this error as a result:  We analysed  the sf stored procedure task_copy_project and we think the order of the templates/code is wrong. After we inserted the project_vrs table directly after inserting the project table, and before inserting into the help_index, the project was copied correctly.

I deployed a version of our application to IAM with the OAuth server implemented. This worked fine when using 1 application, but we have situations with multiple applications per IAM. In the future we also like to use the tenants so that we have multiple clients using 1 IAM. The following error occurred with more than 1 application:Er bestaat al een waarde met sleutel 'azure' in het woordenboek. (Primary key already exists.)Stored procedure: get_gui_oauth_serverColumn: request_refresh_tokenoauth_server_id = 'azure', authorization_url =…. I tried to delete the key but this is impossible. Is there another solution to this? How should we configure IAM to be able to use an OAuth server for each application with different URL's?

Previous versions, without quotes:ALTER TABLE dbo.[voyage_completeness_check_period] ADD CONSTRAINT [c_voyage_completeness_check_period_reservation_month] CHECK ([reservation_month]>=1 AND [reservation_month]<=12)New version, with quotes while the datatype is integer:ALTER TABLE dbo.[voyage_completeness_check_period] ADD CONSTRAINT [c_voyage_completeness_check_period_reservation_month] CHECK ([reservation_month]>='1' AND [reservation_month]<='12') 

I have a lookup field, with a Suggestion Contains. Say, I start type for PIET, it can be found. However, if I type PR and then click the magnifier, a popup will open, but that is already searching with the value 'PR’. So, this limits a free search for all account. Is it possible to clear the field when clicking the magnifier?  

Hi. Is hierarchical grouping already available for grids? And if not, is there a way to make a part of the tree-text bold or of a certain color? Thanks, Freddy

I'd like to add an image upload column to my table and have these images stored in the database.How do I create something like this?What columns & domains do I have to include, etc.?

I would like to upgrade multiple applications at the same time. The applications are exactly the same with the same version number, structured within one iam with the use of multiple tenants. Is that possible with the tw deployer for example?Or, to put it a little different: when I have multiple customers with the same (standard) saas-application, it would reduce the time needed for upgrading if I could do that with just one click. Even better if I could schedule this. I know that I could create a script to do this, and upload the iam model once, but I guess my main question is: does Thinkwise have a smart way to do this?

Hi, I’m fairly certain I used to have a feature matrix in TCP.I cannot find it anymoreCan someone assist me finding that again? rgds Ricky

Hi,In my grid I use the aggregate functions to show a total. However, some grid lines must be ignored. Can I control the aggregate (e.g with sql). Or, any suggestions on how to this otherwise? e.g ; Instead of 600,- I want the first grid line to be ignored, and show 500,-  

Hey guys,i have a situation where i created a screentype with 6 different detail groups represented by views.Each of the detail groups uses the translation of the view represented. Is it possible to somehow make these translations a little bolder. Help would be very much appreciatedThanks !!!

Hi, How can I create a message like this?  

We get a 403 Forbidden status when calling a sqlserver database procedure using POST. The procedure has execute rights for public. What can be the reason why?

Perhaps a simple question; but I can’t find it in the manual/docs. Where are these images displayed? And all the other images in the IAM? I want to set some icons here and there, but some for some reason… no show. And, why aren’t they displayed on the fly? Sometimes after 24 hours I suddenly (and for me without reason) I do see an icon change.  

Hi, Numeric domain is not listed at creating a sequence, and I can work around it by changing the type to BIGINT or INT, but is this a defect?Manual says:Note that this domain must be either of an integer type or a numeric type with precision 0. The lookup automatically filters domains that match this requirement.Sequences / Settings / Domain

Hi,Probably something small, but I've seen than I can set the label name for a Form somewhere; but can't find it. In Translation I set this;  And Local I get this; (which is good) However, when creating a new version, It's reverted to  'Form’. Can anyone give me a push in the Right Direction to set this once and for good? Thanks! Alex   

Because our System Flows can be running quiet sometime, sometime hours, and I don’t want my deployment killing a running system flow I have developed a way to check whether a system flow is still running.What I do is: deactivated all running system flows check if there is a system flow running (is there an empty  [end_date_time] in [process_flow_schedule_log]) If so wait sometime and check again If not start deployment.And of course I put on a max time the deployment will wait, if it takes more time, the deployment is aborted.But now I’m seeing quite often that the [end_date_time] is not filled. It looks like that if a system flow encounters an error, it aborts and doesn’t write the  [end_date_time] in it’s [process_flow_schedule_log].Therefor my checks are failing and deployments are aborted much to often.I would think that the [end_date_time] should always be filled.Is there a solution for my problem or is this a flaw? 

As an ISV we're dealing with different customers and because of that with different customer needs. Although we came up with a standard application, with a standard order of the menu-items, every customer works slighty different and want to change this order. From this perspective it would help us a lot if we could configure the order of the menu-items within a tenant (in IAM we configure a tenant per customer).I hope there is a solution. Otherwise this question can be converted into a new idea.

I have a form with 2 input columns, one with an image-combo (select a type - touch) and one to enter a value (scan). When I have selected a value from the combo box, I want to move directly to the column to scan the value. How can I achieve this? When I use the @cursor_to_col_id in the default procedure, the cursor stays in the combo box.      

Hi,Is it possible to force our RDBMS users to change their password the next time they log in?

Hi, in some of our processes we generate different reports (with devexpress), export these reports to pdf and send the pdf's by e-mail. For instance invoices with attachments. Our customers would like to merge these pdf's to one pdf file and afterwards send the merged pdf file by e-mail. Devexpress itself has functionality (api) to merge pfd's. Is this api supported? If not, is there another way to merge different pdf file?

Hi all,I always look with my arms over each other to @Robbert van Tongeren working in TSF. But now I’m on my own and have a simple question:He uses search code very quickly but when I open "Code search" in TSF I cannot directly start typing into "search string". After some clicks, switching fields it was possible to enter the code but there must be a magic trick to input and start searching the code directly. (TSF 2021.1)Please share this trick here :-)​ 

Hi all,I have something weird in my web gui. In the lookup fields, I check in the table 'location’ with a comboThis will show suggestions; When I enter a invalid value, i get prompted and can't save the record. However, on web, I can save the record;  Saved the record, with an error messageBUT, when i check the record, it is not saved in the Db;When I refresh, it's still there. When I change between tabs, still there. In Subjects specified; When I close the table, and open it, it's gone (as it should be). GUI; 2021.2.12.Is this a bug, did something change? What's going on?

Hi i’m running IAM/SF/Indicium on my Windows Server 2019. I’ve downloaded 2021.2 installation pack from TCP.The setup ask me to upgrade Indicium via IIS Web Api.I’ve downloaded IISAdministrationSetup.exe 2.3.0 from Microsoft but MSI installer always fails with error code 0x80070643.Is there a way to upgrade Indicium without IIS Web Api? Or, is there a way to install IIS Web Api without MSI?

I upgraded to webgui 2021.2.17 (using TW platform 2021.2) which resulted in a different layout of the e-mails sent in case of 2FA. I receive the following:U, of iemand die gebruik maakt van uw inloggegevens, heeft een poging gedaan om toegang te krijgen tot uw account. Als u recentelijk geen poging heeft gedaan om toegang te krijgen tot uw account, negeer dan alstublieft de rest van dit bericht en neem direct contact op met uw applicatiebeheerder.<p style="font: 11pt calibri">Het validatieproces kan voltooid worden door de onderstaande validatiecode te gebruiken: </p><h1 style="font-family: calibri">259408</h1> It used to be in html, thus with the code in bold, big Calibri font.I tried a shortcut to make this a bit better: I wanted to change the translation in the SF (as mentioned in the documentation). To my surprise there was a completely different message in the SF:  So, I have 2 questions:Why do I receive the e-mails suddenly as plain text and not html? Wher