Questions & Conversations

This is the first time I’ve tried a subflow. I made sure the flow parameters are fed with the values from the main process flow. However it doesn’t run.When I check debug info in the gui it says: “ExecuteSubFlow is not supported in the Windows or Web gui”Does this mean subflows don’t work at all? We’re on the latest 2022.1 version.

Hi, Lately I have been trying to group some fields in my form component to another tab. This is very easy to do in web/desktop gui (img.1). img. 1But now I’m trying to achieve the same thing in Universal but just can’t seem to figure it out. My form component in Universal is as seen on img. 2img. 2 Keep in mind I would like do achieve this without adding another table. Is there a way I can do this for Universal GUI? Thanks.

Hello, I want to create a new row in my table with certain columns from another row. It is possible?

Anyone has experience with how to set up the flow, especially how do I catch the generated PDF from de start_table_report to be able to send it by email?  Where does it, by default, get saved? 

I am using the HTTP-connector to sent a message with content-type application/json. I use a nvarchar(max) variable for the content input. I would like to know whether the http-connector sends the message UTF-8 encoded or UTF-16 encoded.I would like to use a Content-Type application/json; charset=utf-8 but I suspect I have to encode the content as UTF-8. Is this best done using a varbinary(max) or should I do this in a different way? Hope anyone can help.

When executing a JSON request (by Postman), I get an 422 - Unprocessable Entity Error. In the Indicium log, the following error message can be traced. What does this error mean? [DBG] Endpoint '"{metaSourceAliasOrID:length(2,3):regex(^iam$|^api$|^sf$)}/{guiApplAliasOrID}/{**odataRoute}"' with route pattern '"{metaSourceAliasOrID:length(2,3):regex(^iam$|^api$|^sf$)}/{guiApplAliasOrID}/{**odataRoute}"' is valid for the request path '"/iam/test/customer"' (430aaaf2)[DBG] Endpoint '"{protocolSegment:length(4,5):regex(^odata$|^open$)}/{metaSourceAliasOrID:length(2,3):regex(^iam$|^api$|^sf$)}/{guiApplAliasOrID}/{**odataRoute}"' with route pattern '"{protocolSegment:length(4,5):regex(^odata$|^open$)}/{metaSourceAliasOrID:length(2,3):regex(^iam$|^api$|^sf$)}/{guiApplAliasOrID}/{**odataRoute}"' was rejected by constraint '"protocolSegment"':'"Microsoft.AspNetCore.Routing.Constraints.LengthRouteConstraint"' with value '"iam"' for the request path '"/iam/test/customer"' (5b506098)[DBG] Endpoint '

Dear Thinkwise,Because the Universal-GUI uses the cache of the browser it is not allowed to have more than 1 webapplication of the universal-gui in 1 sub domain.But I’m having now:http://ericwebsite.acto.nl/acto-d-upgradetest-evo-indicium-universalhttp://ericwebsite.acto.nl/acto-d-upgradetest-evo-indiciumhttp://ericwebsite.acto.nl/acto-d-upgradetest-evo-universal-guiSo I want to change our IIS structure to support this. What I want to do is creating the next structure:http://ericwebsite.acto.nl/acto-d-upgradetest-evo-indicium-universalhttp://ericwebsite.acto.nl/acto-d-upgradetest-evo-indiciumhttp://acto-d-upgradetest-evo-universal-gui.acto.nlThis structure needs to use the ‘CORS’ possibilities of IIS/ThinkwiseMy questions is: do you support these new structure? And if so: how do I enable the CORS in this structure? I have read about CORS and indicium and found the next instructions and I tried them on the appsettings.json of indicium-universal, but these doesn’t seem to work.{  "Allowe

Hello all,Does anyone have an example of an t-sql request against a REST API with a Multidata/Form? We already call several REST APIs, but not with Multidata/form. Below is a setup (which does not work). The API converts a PDF document into fields in json format. It contains 2 fields that must be included:name (name of the document) document (base64 encoded string)Below is a first attempt, but it does not work :-). Thanks in advance for the reactions.declare @response table (txt nvarchar(max)); declare @object int , @url_endpoint nvarchar(200) , @response_format nvarchar(5) , @request nvarchar(250) , @json nvarchar(max) , @address address , @body varchar(max) , @status int , @d

We are looking to upgrade our TW software to version 2022.1, and during my tests I encountered some performance issues while synchronizing our latest version. Our performance monitor pointed towards the function look_up_chain_granted. This function is called around 1.5 million times, as our application contains a high amount of Roles. At 1.25ms per execution this could take a very long time. The performance index suggested adding the index stated below and this decreased the avg execition time to 0.075ms, which helped with decreasing the total sync time from almost one hour to just ten minutes.I would suggest Thinkwise take a look at this suggestion as it has helped us very much.CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname, >] ON [dev_sf_upgrade_test_2022].[dbo].[ref_col] ([project_id],[project_vrs_id],[target_col_id]) INCLUDE ([abs_order_no]) 

The project I am working on needs to fill a form (which is developed in SF) by the candidates. This form will be sent as the link to the candidate in an email. When the candidate clicks this link it should take the candidate to the form. My question is :If the candidate does not have the log in details for SF , can he still open and save his data through the form?  Can the universal GUI url open without user id and password?

Hi. I am trying some cubes and charts. Why do only column values get shown the elements, as when they are added as a row they get their DB values. Socio Type (Combo with Elements), as a column and states as rows I see the named elements.  Socio Type (Combo with Elements), as a row I see the DB values instead of elements.  

I am trying to use the OAuth connector to make a synchronization with the tax service platform of the British Government.I have followed the docs and set everything up accordingly. However when the proces action of the OAuth login connector is reached, a white screen comes up and nothing is happening. I assume thinkwise is adding the client_id, scope and redirect_uri to the Authorization URL? I was hoping to find more information in the debug screen to find out what URL’s etc are being called, but that is not the case. Can someone tell me what I am doing wrong here? I below screenshots you can see my settings.   Settings in OAuth servers      White screen. Nothing happening.    My proces flow 

What could be the reason a query is taking way more time through the GUI than direct on SMSS? If I copy this query into SMSS and execute it, it's done instantly. While via the GUI it takes quite some milliseconds. 

What can be the reason that the initial connection takes seconds…  I have another query that runs 5 ms direct on DB..  and this time I see that it stays for seconds in initial connection.   and after 6.7 minutes it's done.. 

The license is not automatically renewed.The registration has been successful.Starting the IIS application manually also works fine; when i start it as administrator as well when i start it as de pool-user.Automatically it does not work.I'm working with the installation 2021.1I have checked the problemsolving: idle-time is set to 0 and startmodus is AlwaysRunning. The authorization on the wwwroot-map is set correctly.So beats me. What can i do? Who has any ideas?

I have a table with over 48 million records and I would like, besides some default pre-filters, to have the filter form pre-filled with an option and let the user alter these selections ( they are combo's). On of them is company type, can I give these fields by default a value and make sure that they cannot be empty? 

What is the reason that the dbEventLog is not reachable? This site can’t be reachedThe webpage at https://coragem.lef.tec.br/indicium/account/ui/dbEventLog might be temporarily down or it may have moved permanently to a new web address. The Universal is directly pointed to the SF. And will this also be available for the Indicium log?  Now I have to every time go to the indicium URL download the log file..  would be easier to see it online with the latest messages. 

Hi,Recently I have been encountering some problems with the OData api because of some code written in the stored procedures. Up till now I noticed that the layout and default CP have effect on the api. For instance: I had once written in my layout CP to set some fields on Read-Only if a certain condition is met. Turns out that these fields are also set on read-only for the api, which results in not being able to update the field via a mobile app and getting a 403 error.  Now I have this piece of code (as show below) which I thought would only effect the gui because I specifically added the ‘@cursor_from_col_id’.But now when I use the api to update a record, the status is always set to ‘RGS’ because I have a service type that is not equal to ‘OTH’. Removing the field from the request still doesn’t seem to help this issue.How can I tackle this issue? Is there something that need to be aware of?Thanks

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.