Questions & Conversations

Setting a different translation on a table/subject variant requires checking the Translate column on the Subject>Variant>Settings.Now that I'm using a variant with different translation, I notice that the column translation actually should be different depending on the variant.For instance, take a product and an order table with a cross-table order_product. When order_product is linked to order, I put the translation “Product”, while seen from the product side I'll call it “Order”. This on subject/variant level. Let's say I have a column number_of_product. From the direction or order this indicates the number of this particular product. Translation could be “Aantal”. From the direction of product I want a different translation to indicate that this column says something about product and not order, such as "Aantal van product”.How do I create a different translation for a column, depending on the variant that is shown?

When you use a SVG icon for a task which is disabled in the web gui, the icon doesn't become gray like it does in the Window GUI. Is this a setting or svg trick that needs to be applied?webgui disabledwindows gui disabled 

On the Windos GUI I see that Badges on detail tiles is possible. For Universal this should also be possible, see sprint 38 - March 16. This should also work on detail tiles right?https://community.thinkwisesoftware.com/news-updates-21/release-notes-universal-gui-2021-1-14-beta-1932   

I don’t know why but (suddenly) the lookups are not working anymore in Universal.I tried everything possible. (I upgraded to all new versions 2021.2.11) I regenerated the software, there are no errors. In the windows GUI it works correctly, but in the Universal GUI I see the ID’s in stead of the lookup fields. This is the Universal windows And this is the WIndows GUI screenIn the browser debug screen I see this. The Indicium log is empty however I see every 30 seconds an error coming up. (I assume this is related to a auto-refresh of something but not on this screen)2021-06-08T12:16:00.0263234+02:00  [ERR] Unable to execute the AutoML get training options connector. The AutoML service URL is missing. (f12f751f)2021-06-08T12:16:00.1257553+02:00  [ERR] Object reference not set to an instance of an object. (f59a5554)System.NullReferenceException: Object reference not set to an instance of an object.   at Indicium.Shared.TSF.TSFMessageHandler.GetPredefinedMessages() in C:\azp\agent\_work\1

We have a report rpt_ribben_laadschema where we have set a printer to “Wanssum_lade_2” but the printer is still using the default printer instead of “Wanssum_lade_2”. Is there a way of changing that even though it is set to “Wanssum_lade_2”?  

Once in a while I get the following message when starting up the applications. I was told I need to recycle the Indicium App Pool.Just did, but the error keeps on displaying. In the log I see the following error. How can I resolve this?2021-06-08T09:28:10.9562228+02:00 [FTL] License refresh failed. Failed to contact licensing service. (ff615c83)System.Net.Http.HttpRequestException: An error occurred while sending the request. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 144.178.66.249:443 at System.Net.Sockets.Socket.InternalEndConnect(IAsyncResult asyncResult) at System.Net.Sockets.Socket.EndConnect(IAsyncResult asyncResult) at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket&amp

Recently I started to look into branches but I’m experiencing some strange behavior. After creating a branch of the latest version of our end product I immediately switch to it in the SF. Without making any changes I immediately do a “generate definition” followed by a “generate source code” using the smart method. But as soon as I select “smart” in the drop-down list I get the error message that the previous version “does not have an up-to-date program object archive”. This usually happens when that previous version needs to have its definition regenerated but that’s already the case.To rule out some weird cross project issue (the previous version is of course in the trunk project) I then copied the first version in the branch to a new version and tried to do a smart code generation there. However I got the same error message again stating that the previous version (this time within the same branch project) “does not have an up-to-date program object archive”.We’re on the very latest

In Universal GUI i cannot edit Dates while Editing in Grid. Is that a bug or do i have a wrong setting? 

We would like to delete some data (as a kind of reset) after a user has closed a screen.Is there a way to run a task after the user exits a screen (close document)?

I'm testing the upgrade from SF 2021.1 to SF 2021.2 and I noticed something in the unit tests, there's an assertion message thrown:Failed: The logic managed to rollback the unit test transaction. Please remove the random rollback statement. I've discovered that this is caused by the tasks’ “atomic transaction” feature. For example I have a task with a dbo.tsf_send_message ‘some_error’, null, 1 which will call raiserror(), that will cause the task transaction to rollback. But as a side effect the unit test no longer succeeds where it would in previous versions. How can this be fixed? I also did notice that there is a new “Is empty” assert. Which is nice, but why isn't it converted by default? I've performed this script to correct it:update t set t.unit_test_condition = 10 -- Is emptyfrom unit_test_output_parmtr_overview twhere t.project_id = @project_id and t.project_vrs_id = @project_vrs_id and t.expected_output_value is null and t.unit_test_condition = 0 -- Is equal to 

Hi, How can I overcome the error 500 when the following request is made: DELETE https://twisodev01.acto.nl/indicium/iam/5414/someview(id=576001) it gives a nice dialog in the screen that an error occurred due to this:delete instead of trigger on the view executes a delete on the realtablethe delete trigger on the realtable has some condition:    if exists (               select 1               from   deleted d               where  d.is_locked = 1              )    begin      exec dbo.tsf_send_message 'deletion_error', null, 1      rollback tran      return    end Now the magic starts:It returns a 500 error on the request, which is a server error (is it?),it registers an error in the indicium log (is it really?)and the debugger in the windows gui shows a System.Net.WebException(why?). What is the proper way to let indicium handle such a delete action where a trigger prohibits the delete and sends back the message to the user it cannot delete the record due to some constraints - in a way

Hi tried to update Indicium this morning but Indicium will not start anymore.I have unblocked the block flag of all files with the streams.exe tool. I copied all new files to the indicium location and updated the appsettings.json. That's the normal procedure. But when opening the Indicium URL I'm getting this error. The windows event log gives the same message. The application will not start... TTP Error 502.5 - ANCM Out-Of-Process Startup FailureCommon causes of this issue:The application process failed to start The application process started but then stopped The application process started but failed to listen on the configured portTroubleshooting steps:Check the system event log for error messages Enable logging the application process' stdout messages Attach a debugger to the application process and inspectFor more information visit: https://go.microsoft.com/fwlink/?LinkID=808681  

When I register my environment I get the message:What is the problem and what can I do about it?

For a certain task it’s required to query a system-versioned aka temporal table at a certain point in the past. Let’s call this table temporal_table for simplicity.Here’s an example query:select v.*from temporal_table for system_time as of '2021-2-27 14:59:46' vIn SQL Server Management Studio (SSMS) this runs in about 2 seconds for this particular table. Using this in a lengthy select statement with a bunch of joins also runs rather fast in SSMS as it takes about 10 seconds to finish.The problem happens when this code is used in a task in our end product. As soon as the for system_time flag is used in the SQL code the task goes from running 10 seconds to what’s basically forever. This is the same code used in SSMS, with the exact same datetime for testing purposes. (This date will be replaced by a parameter in a later stage as it needs to be dynamic.)I’ve tried to get around the issue with this alternative query:select v.*from temporal_table for system_time all vwhere '2021-2-27 1

Hi All,Is it possible to turn off (e.g. ctx proc) for when Multiple Records are selected?I have an invoice overview, and the user can reset the invoice. But I want this to be done per grid row. When I select multiple records, the task is still selectable. Can I turn off a task when more records are selected? Feels like a very simple thing, but somehow I don’t see it. Thnx! 

Is there any functionality already available related to this I did not get any reply yet to this idea.

Is it possible to export a particular project or a project version? In order to be able to import it again when necessary.

With the latest version of the Universal GUI the checkbox “Remember me” is added. When tabbing through the fields from password to remember me, I expected it would go to remember me, but it didn't, it went to the “Eye” from “Show password”.If you hit spacebar immediately, your password is shown. We've discussed this internally and think this is not appropriate. Lets say I was lucky that there was no colleague standing next to me or I was sharing a screen .Maybe should the “Eye” be excluded from the tab stops?Other applications I've seen you can only use the ‘click’ to show te password (e.g. Windows login) or have an explicit link / button that is more clear that it is a button / part of the tab sequence. I didn't expect the eye to be part of the tab sequence, because it's inside the password box.  

Hi all,I have two tables; purchase_header and purchase_line.  This is all ok, but I keep running (also with other situations, this is just an example). When I select this Purchase_header line (displayed as 2), and i got to the Cost Lines tab (table Purchase_line).  In this purchase_line screen I need to use the purchase_header_id (the 2 in this case). Can I access this data? Because it is super needed! I have a feeling this can be accessed; yet I can’t find it. I would be very happy is this can be used. Anyone out there that can shine a light in my dark world? Alex 

Is it possible to set up conditional formatting for form only? I like to keep my grid clean, but would like to make some fields (e/g date) when certain things are (not) set. Any thoughts on this? 

Hello there,I’ve been searching through the documentation to find how exactly is determined which process action step is taken in a process flow.A new feature requires me to accurately predict (in a process) which process action is next in the flow. This would be easy if there is only one route to follow but when there are multiple, I need to check the values of the process step parameters.Let’s say there are three routes in a process flow originating from a decision node. To determine which route will be taken we can check variables @thisStep_nextOne, @thisStep_nextTwo, @thisStep_stop.This is how I thought it worked:All routes set to 0 or lower are ignored The route with the lowest number above 0 is selected In case of a tie, the route with the lowest order_no is selectedThis is giving me wrong results so I must be getting these logic rules wrong. Can anyone tell me how exactly this works?

With every new to add item our field BookingNr is auto set by for example Last high BookingNr + 1.This works fine when using the Add button (Ctrl ++), however, this does not work for the Copy button (Ctrl + Alt ++).A very tedious workaround could be to create a ‘copy’ task which copies all fields from an existing row, except for the one we wish to set separately, but this is far from ideal. Furthermore, we can refer to ‘Add new’ by verifying with@import_modebut this only separates ‘Add new’ from ‘Update’ - of course Copy would be same as Add new. I would like to know if there is a quick and simple way to do what we need without above mentioned workaround?Please advise. Thank you,Paul

If you are using a Windows GUI, which is connected to the database using the Indicium Basic, to use any form of single sign on?Currently I have set this up for a client of mine. They will have to insert their username or email address and password. But their Windows Credentials match their account in IAM. So you would kind of expect that the Authentication option MSWINDOWS would be available when using the Indicium Basic as your server. Is there any way to set this up?

Hi all,in the web gui, is it possible to double click a grid row, and then show a form with details from a lookup?I have a feel this can be done, but so far I do not get any results. Would be great to get a hint!Thnx! Alex      

Hi,I have a filter form with a date field. Is this date available for me to do some calculations with? So in this case I want to have 5/1/2021, so that I can use this to calculate the amount of days before the date of the search. Is this possible?  Thanks! Alex