Thinkwise Platform

I’ve deployed the latest version of Indicium universal to Azure according to the instructions (https://docs.thinkwisesoftware.com/docs/deployment/azure#creating-an-azure-web-app). Unfortunately  the application does not start with message:HTTP Error 500.30 - ASP.NET Core app failed to startThe event log has more information:Application '/LM/W3SVC/1165921035/ROOT/indicium' with physical root 'D:\home\site\indicium\' hit unexpected managed exception, exception code = '0xe0434352'. First 30KB characters of captured stdout and stderr logs:Unhandled exception. Internal.Cryptography.CryptoThrowHelper+WindowsCryptographicException: Access is denied. at Internal.Cryptography.Pal.StorePal.FromSystemStore(String storeName, StoreLocation storeLocation, OpenFlags openFlags) at System.Security.Cryptography.X509Certificates.X509Store.Open(OpenFlags flags) at Indicium.Startup.getOpenIdSigningCertificate() in C:\azp\agent\_work\1\s\src\Indicium\Startup.cs:line 868 at Indicium.Startup.configure

I am working on an App and I want to incorporate the economic activities.. these are available via public API. (https://servicodados.ibge.gov.br/api/v2/cnae/subclasses) How do I process this? Because I know use a NVARCHAR(MAX) variable, but I don't think it can hold the whole result?  37.8 MB ..   However it does process but only a part of all the economic activities.  Is there a way to save the JSON as a file and later on process it? 

We have a requirement for which we need to ensure that in a set of rows at least one of the rows does not have an end-date. In below example it should not be allowed to add an end-date to test=3.@Robert Jan de Nie Is it possible to use check constraints to prevent this? 

I have added the following three icons in the menu for the Universal GUI, all svg. 1. Heart icon #0044872. Heart icon #0000003. Colour pallet  SF | Menus - DesignWhy does the Universal GUI only show the second icon? The other two icons should be visible in their original color in dark/light mode, right?   Universal GUI - 2022.1.11 b1.0 

Hi!We’re trying to automate our merging and branching with the SF. As stated in this question it’s already possible to execute a merge session, however I'm trying to also create the merge session. To do this I'm executing the following API call: POST indicium/iam/sf/start_merge_session{ "trunk_project_id": "TRUNK_ID", "trunk_base_project_vrs_id": "1.00_TRUNK_ID_BRANCH_ID_BASE", "trunk_current_project_vrs_id": "2.00", "branch_project_id": "BRANCH_ID", "branch_current_project_vrs_id": "1.00", "merge_direction": 1, "description": "Merge TRUNK_ID 2.00 into BRANCH_ID 1.00",}However this is returning a 403 Forbidden, am I doing something wrong or is it not yet possible to start a merge session with an API call?

Since Thinkwise itself doesn’t profile itself as a bookkeeping system, we have realized an integration with Exact Online for our Thinkwise application. This was recommended by Thinkwise because the integration is relatively easy due to similar code. However, it appears the integration still comes with a log of bugs and errors. Also, our customer isn’t fully satisfied with the working of Exact Online.Are there any other options/recommendations for a bookkeeping system? How do large Thinkwise customers do this (e.g. VDL Nedcar or Zeeman)?Also, how to archive invoices from Thinkwise (as they should be archived for at least 7 years)? Currently we can regenerate an invoice, but we only store data for 2 years. Could this be done efficiently in Thinkwise for 7 years? Or is it perhaps recommendable to archive every single pdf in another database?Any other ideas/suggestions?

Hi,I’m currently getting the following error on generation step “Execute: create_log_tables” in the Generate Definition step of my creation: Error messageError lineI don't know what could have caused this, is anyone able to give me a suggestion as to how to solve this?Thanks in advance.

When you make alterations to the model, especially the data part that results in an upgrade script. What are the best practices when someone create something that is not accepted by the database. In this case the you can choose to ignore and go on or to abort. To not loose data it's best to go for the abort scenario. But then you get stuck with all the renamed tables and all or partially the new tables already. When you fix the problem, there seems to be no easy way to rerun the upgrade script because with every existing you get an error..  so 130 tables renamed and 130 tables new = 260 messages.. Can there be an option to just ignore the messages?  Or can there be an option to roll back the situation by deleting the new tables and renaming the backups back to its original name? Now I just 'hack' my way through it via SMSS, but perhaps the SF can offer something more elegant. 

Hi,I have tables which have a is_deleted column. Now I want to make a clear distinction where is_deleted = 1. I can do this with conditional layout where the background color is specific color, but adding this for each table is very time consuming. fyi: My application is in Universal GUI.Is this possible with the dynamic model? If so, how should I do this? Thanks

I have a cube view with cube view columns sorted descending. When I show the cube with the SF model, it works fine. But when I synchronise it to IAM, it does not sort the columns descending anymore (2021.2). Only when I use the ‘sort by cube field’ (not mandatory) it works also in IAM. Is there a reason for this behaviour? 

Hello,We are using the Exchange connector to process e-mails, which arrive on a certain e-mail address, within our ticket system. These emails often contain attachments and are saved using the sendGetAttachment + saveAttachment. However if the attachment is an e-mail the @byte_array will be NULL and will not be saved. Does anyone have an idea why @byte_array is NULL when the attachment is an e-mail?Thanks in advance.Greetings,Randolph 

I created a unique index and I deployed my project. When I try to delete this index I am getting“An explicit DROP INDEX is not allowed on index ‘ sales_person.unique_sales_person’ . It is being used for FOREING KEY constraint enforcement.”error message.I tried to clean install but it didn’t work. It is in software factory version 2022.1How can I solve this? 

We need to transfer our real-time freight data via an XML file to our carrier. In what way can I do this safely using Thinkwise?Is an FTP link secure enough for this? 

Has anyone figured out how to implement barcode scanning in the Universal GUI. At this moment when I scan a barcode in a TEXT field the GUI does not perform an ENTER. So the value is Shown in the field but, the value is not processed by the default because the GUI does not handle the scanning action of the terminal as an entered value. (I already tried different settings on the scanner like HEX suffix 0X0A (Which is the equivalent of ENTER) But the universal GUI seems to ignore this suffix. So the result is that the value is shown in the field and the user always need to do something on the screen. We need to scan a barcode, process it’s value in a default, moves the cursor to another field or the same field. For example, scan a product barcode, scan a location, scan a product barcode, scan a location. A created a test form with only 2 fields and want the default to handle the scanned value and moves the cursor to the following ‘to-be-scanned’ field. Someone has ideas??? declare @msg v

Is there a way to change the message in the confirm update/delete in the subjects settings so the default buttons can have different messages?

My user ID in the IAM has English as application language, but I have multiple applications in the Universal. How to I set the default Application language for my User? I am create a Portuguese Brazilian App and I cannot find out how I start that one with the pt-BR language by default… 

Well, my co-worker saw the status bar in the TCP and instantly wants to have it in our system as well.How is this created? 

For my project I am trying to send an email as soon as the candidate saves his/her details in the form. I made process using the SMTP connector as per few suggestions via the community. However, the email is not auto generated. Below is my process flow. Initially I used “Activate detail” process action instead of the “Start task”. What needs to be changed in order to generate the email after the candidate saves the details in the form.Process Flow My input parametersThe variables have the details for the smtp connection to Zoho mails. 

I am trying to understand the rules that govern the height of the task window.It seems to be determined by the total height of the first column (I think) but on this occasion it is not. Context: We are using the tasks available to us through the resource scheduler extension. In this case we are trying to enforce the correct layout for the double click appointment task. Example:This task has fields that need to be hidden/shown based on the appointment clicked (type of appointment, state of appointment etc...)In our “standard” state our task looks like thisTask in natural stateNow we also have a “ready/definitive state” for our appointments this means certain actions are no longer available. So we hide them. Now our result suddenly looks like this result of hiding the 2 fieldsNow our 5th field suddenly jumps to the next column pushing all the fields further and further. None of the fields on the left have the checkmark next column. My question is:What determines this behaviour and how is

This is an Archived topic. The solution is available in the Thinkstore inside the Software Factory.In some cases it may be desirable to know the translation of a model object, such as a table, column or domain element, inside your business logic. See for example this idea: Translating domain elements | Thinkwise Community (thinkwisesoftware.com)Starting with the last releases of Indicium and soon available in the Windows and Web GUIs, a session variable is added that provides the language of the current user. This makes it possible to automatically generate a function that returns the translation of model objects in the user’s language. FunctionTo add this dynamic function to your Thinkwise application, first create a function subroutine named tsf_translate  with the following properties:Return value: scalar Return scalar domain: transl - nvarchar(200) Input parameters: type_of_object - int transl_object_id - varchar(100)  Control procedureNext, add a control procedure in the Function

Hi,Is there a setting to set the timeout of a step of a process flow or the process flow itself as a whole?If I try to run a very time consuming Process flow I get my application hang and need to refresh the page to continue using it, despite the error the process flow will continue executing in the background  in (Indicium). Any help or suggestion is appreciated. 

Is it possible to open a reference in its main screen from a reference in another table?For example: I want to open the main screen of ‘customer’ by clicking on the customer name in the table ‘task’. I know I can open a lookup screen using ctrl+L, but I want to open it in a new tab as a main screen.   

Hi, we are using both Windows as Universal UI in combination with Windows authentication.As we have users who only have a handheld device (phone or tablet), we wonder if those users would be able to change their (AD) password from within the Thinkwise application:on request on password expiration (set in AD)Currently the user is locked when the password expires and there isn't an option at that moment to create a new password.Thanks

Hello,I am implementing a resource scheduler and am using the extended property “DeleteAppointmentTaskScheduler” to delete appointments which works quite nice.However when i press the delete key when no appointment has been selected I get an index out of range error. Is there any way to prevent this error?Thanks in advance

We are trying to design a task that has a lot of arranged parameters.The problem we run into is that when the task starts the width of the dialog isn't calculated on the widest row of parameters, effectively pushing them to different tabpages.Same with the height.We can set the desired width of the dialog but in that case TW pushes a field to the next column messing up the layout.Hope my explanation is clear.. Pictures are probably a better way to show it :) When I manually resize the dialog all falls into place: Any ideas on how to do this?