Solved

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

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

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

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?

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?

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

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

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 credentialsExpected flow: User is redirected to the redirect url that is provided with the initial requestCurrent 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:   

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?

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!

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  

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  

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

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 

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

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 

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

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 nothin

Hi, I want to hide the default null value of a combo element without setting it a default value type.Basically I want to hide the first empty row of a combo element that contains elements. Kind regards,Paul

Does anyone have experience with printing SSCC barcodes (GS1-128) on a SSRS report?Font Code128 doesn't seem to work for this type of barcode. How can this be resolved?I'm trying to get an output (Pallet Label) like below: 

Hi, I have a subroutine ‘delete_project’. When I call this, it deletes the project. When a record has Referential Integrity and ‘No Action’, Indicium nicely respond with a base64 encoded message that it ‘ can’t delete due to Related <tablename>’ . So far, all good. However, when I don’t want to delete the project because it has for example a [status] = ‘active’ - so deleting is not allowed. In the gui we can display a message. Or with importing some data from an API, at the end we show a success/failure message; perhaps with a Process flow.  Is it possible - and if so, how - to pass these messages through Indicium? If a user connects with the end-point, it will make a lot more sense then a 422 - unprocessable entity when something is not allowed, or processed correctly.Thanks! Blommetje 

We made a track and trace Webservice (= Message Independent Protocol system flow) for external usehttps://xxx.xxxxxxxxx.com/indicium/open/sf/api/public_track_traceIt works fine as POST request within Postman and I asume that it must be possible to use the API when running it in website in a browser.Now the developer of our public website wants to implement the Webservice but runs into CORS related errors and it looks like we have to make some adjustment at our side.Any ideas on what must be done in the setup of indicium to let it work? Or do we have to add something special in the response headers?   

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

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?

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.