Questions &amp; Conversations

Manual selection in Creation Process

It is very unfortunate that the 'Manual' option is no longer available.We used this option very often to have more control over the scripts that are run on the database. For example, it is not always desirable to perform the Checks and Indexes scripts, especially with larger databases.I would appreciate it if this option comes back in the platform.The Release plan blog mentioned that the creation process has been simplified, in my opinion it is not.

11412

Peter de WitSidekick

Upgrade SF to 2018.3

Last week we upgrade the SF from 2018.02 to 2018.03 and since then we have trouble with the performance. Our application starts normal but when we choose for the first time a (simple) menu-option the waitingtime is more then 6 minutes before it shows a result. The same after every 'refresh model'. Similar problem occurs when we start the SF itself, if freezes about 15 seconds before we can chosse an option. See the screendumps below

33212

6 years ago

Tejo van de BorCaptain

Extra fields and translations for enduser

hi,As an ISV we deploy our solution to different customers, and some customers need extra fields in a table to add information. The fields are not part of other processes, just as an extra bit a information on the form.We created these extra freefields as freefield_01 to 10 and thats working fine. But is it possible to change the translation for these fields, so the enduser can see where the field is for? The translations should be entered in the end solution, and be save during an update of the model.Sounds like dynamic model, but has anyone done this before?

22811

Marco KleiwegSidekick

Business Intelligence - Repeating data on each row in cubes.

How to ensure that data is displayed on each row instead of suppressing duplicate data.So in the example hereunder I want to have “AVE” on 10 times instead of 1 time.Who can help?

13711

martijngaasbeek

502 in api-calls depending on the authentication

Since we upgraded the indicium to the latest version, we have the following scenario: We perform the same API-call: {{BASE_URL}}/api_call_a?$expand=detail_ref_api_call_a_api_call_b,detail_ref_api_call_a_api_call_c,api_call_a_api_call_dIf we perform this API-call using “Basic Auth” it is working as expectedif we perform this API-call using “Bearer token” it is not working (error 502) If I remove the latest 2 expands, it works with the “Bearer token” again. The error-logs are clean and this case is reproducable in Postman. Bearer token is a token based on the same user as the basic-auth login. Prefilters are used in these API's502 error: <html> <head> <title>502 Bad Gateway</title></head> <body> <center> <h1>502 Bad Gateway</h1>

23211

posted in Questions & Conversations

Andre te RaaCaptain

Is it possible to sum an average in a cube?

In a cube I would like to have the average of columns (e.g. year, quarter, month), totalized in the rows (e.g. group, device). How could I achieve this?

39111

techniekwebshopApprentice

Trouble with Docker image

The Docker containers are deployed on this page: https://docs.thinkwisesoftware.com/docs/deployment/container_deployment_docker_composeThe Indicum container is connected to the database (it is managed in the logs) and the Universal container is also connected in the logs and warnings are given for errors.I've tried many things in YAML including ENABLE_REVERSE_PROXY and FALSE which says "404 page not found".Please help!This is my YAML (but apparently also with the standard and with just about all possible current ones). Original in Dutch - Above translated:Ik heb de Docker containers gedeployed zoals op deze pagina: https://docs.thinkwisesoftware.com/docs/deployment/container_deployment_docker_comp

29711

Linde van Dyck

Data being cut off in excel column DevExpress

HI!I have an issue with displaying the data in a cell. We created a report in DevExpress and want to make it displayable in an excel sheet. All data is shown correctly in every cell. However in one cell the data is cut off and not all data is visible.The cell has the options 'Can shrink', 'Can grow', 'Multiline' and 'Word Wrap' enabled.What can I do to ensure that the entire text is visible?Attached are printscreens of the report.Kind regards,Linde

25411

tiagoCaptain

Machine to Machine with openID

I've created a client application that is supposed to log every x minutes in the thinkwise database to know it's alive. There will be around 1500 clients that would basically use the same access token, as I will use a local parameter to diferentiate the different logs. To prevent having 1500 logins every x minutes, I presume it's preferable to use the token / refresh token. I'm trying to configure the opeid Machine-Machine integration as described here:Client applications | Thinkwise Documentation (thinkwisesoftware.com)The big question for me is: Now what? I've looked for documentation about how to test the configuration in insomnia/postman, but I've not found any help here. Could you help me with these questions for configuring in insomnia: To use

27311

Mike HeijsteeSidekick

how to fill bearer token in multitennant situation when token is stored in SQL table

we have a web connection where we (temporarily) receive the bearer tokens via another way (yes i know, not ideal, hence temporary) and store them in a table. i have modelled the web connection with authentication type: bearer token and the bearer token as {token}.my question is: how do i fill this with the value in the table for every tennant?

9211

6 months ago

Johan van EijsdenCaptain

Error: Task can not be executed because a component is missing

Because of an earlier issue (https://community.thinkwisesoftware.com/deployment-12/what-is-causing-the-clear-panel-message-in-the-panel-informatie-1030), I installed the latest web GUI (2020.1.14). Unfortunately that caused another problem. I am getting the following error: Deze taak kon niet worden uitgevoerd omdat er een component mist. Raadpleeg uw systeembeheerder voor advies. Well, I could ask my system administrator, but I don't think he will be able to help me with this, so I am asking you guys for help. The situation is that there are a few tasks that are being executed managed by a process flow. The first one is a SP and the second one is a task that

28911

5 years ago

ericbosmanSidekick

Create a password in iam

I want to create a user in IAM which is only for service purposes. Nobody has ever to login on this user.Because we have many environments, I want to automate this.Creating the user is not a problem, but i do not know how to set the password with encryption.I see i need the password, a salt and the password-hash and then i understand that i can use the sql script:insert into usr_authentication ( [tenant_id] ,[usr_id] ,[password_hash] ,[password_salt] ,[password_algorithm]) Values ( … )but in what way can i determine the values of the hash?

24211

Jeroen de KlerkVanguard

Cannot read files saved in AWS S3

We are testing an S3 bucket for our Thinkwise application in preparation for a possible migration away from on-prem file storage.We are successfully able to upload a file to AWS S3, however we are unable to read it again in the GUI. If we open the file in AWS S3 itself, it is exactly the same as when we uploaded it.Currently, the file column is defined as a NVARCHAR(max) column, in which we save the link to the file in AWS.What is the behaviour in Thinkwise when it comes to downloading a file from S3? What column type should we use for this?Thanks in advance!

21911

Stijn SchuurmanVanguard

Session expiration

Hello, is it possible to set the Session expiration for an OpenID provider, or stay logged in for longer than 30 minutes when using external OpenID provider. See above the screenshot of SF 2025.2, in which it is possible to set the expiration for the external provider. We are in the process of assessing our chances to upgrade to this new SF version. But for now we wish to have the `Stay signed in` option like logging in with the local account.

18711

8 months ago

René WSuperhero

Improving the previewer experience

We're currently using the Web GUI and the (DocUltimate) previewer component. What we do is showing a preview of a subject. This preview is a SVG-document, which the previewer component converts to a PDF file, and previews. We use this especially because of the zoom functionality. We've received some feedback of our end users that the previewer is too slow. What they do is they open a record, check the preview and continue on to the next one (it's a grid + a preview). Caching is useless in this process, as it's most likely the document will be opened only once. Now the problem is that I somehow want to increase the performance, or better said, the user experience. Currently it's not loaded 'with a blink of the eye'. Causes of this can be: - Not enough resources on the server - The convertion from SVG to PDF that DocUltimate has to do - The contents of the SVG These cases we've tested and try to influence. We scaled the Azure environment up, but you'll

45911

6 years ago

Mark LeunissenHero

How to abort a failed synchronization to IAM?

Hi all, I have a question concerning a failed synchronization to IAM. As can be seen on the image below, the synchronization to IAM has failed on the step ‘Synchornizing: project’. However, it doesn't seem possible to abort the failed synchronization. So, how do I abort a failed synchronization to IAM.I have tried to cancel it via maintenance → jobs, but this doesn't seem to work. Additionally, in maintenance → Jobs, the ‘active job’ isn't listed as an active job (second image) Thanks in advance. Failed synchronizationNo active job

19311

Hugo NienhuisSuperhero

http connector status code -1

I am trying to use the http-connector to connect to a website/webshop (http://webshop.coffeefresh.nl). The http connector is returning error code -1. When I do the same request to http://bol.com for instance I receive status code 0 / http 200 OK. I can reach the URL without any problems using a browser or insomnia. Just not with the http connector. What can be the cause of the -1 error code, or, where do I look for the problem?

33611

6 years ago

Hugo NienhuisSuperhero

color of selected rows depend on theme color

I have noticed that with the change of the universal theme color, the contrast of the selected rows also changes. This means, that if I select a lighter shade for my main menu, the selected rows become virtually the same as the unselected rows. Is there a way to change these independently?

15011

FreddyThinkwise Local Partner Brasil

Email provider Graph

Is there any link, documentation or whatsoever to help a non microsoft person to get the email provider using graph working. I just don't get it to work, and there are no logs with error messages to get me started. Where do I make the client, and how I see if it works. I added as a test a graph client/secret (made it via de azure identity > Applications), made a notification template and send myself a notification via email. I just see status 'failed to send' but cannot find anything in any logs.

30711

BlommetjeSuperhero

Can I access the display number ?

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

13011

5 years ago

Niels KoopVanguard

Enabling trigger in unit test

Hi,We are in the process of implementing unit testing in our application, and I wanted to create a unit test where I check a value of a certain column.We have a table where we store different posts on an individual invoice, with an amount. The sum of the amounts of the different posts are calculated into the actual_amount column. This is done with a trigger. In the unit test, the triggers are disabled on the table, so we cannot assert the actual_amount column to have the correct amount. We are using mock data by the way. How can we create a test for this? Is this even something that we have to do in the unit test section, since it seems to be more of an integration test if you ask me?

12011

FreddyThinkwise Local Partner Brasil

502 bad gateway indicium with logo_data

Any indications what's the issue here? With getting the logo_data for a tree view I get a bad gateway (502) error.. followed by a similar request that gives a 200 OK.

17711

Johan van EijsdenCaptain

The character "&" is exported to Excel as "&"

When exporting data to Excel the character “&” is being shown as “&amp;”. This is done by the button “Exporteren” in the toolbar of the Windows GUI. Can this be fixed please?

27811

5 years ago

Harm HorstmanSuperhero

posted in Questions & Conversations

Using a barscanner in combination with the Windows GUI

I'm looking for a simple way to process barcodes read with a wireless barcode scanner. I can configure the barcode scanner in such a way that it sends a TAB after every barcode that is read.I have already tried to get it done with a table task and also with a detail form with auto save option. Both solutions do not work flawlessly.A multi-line field could also be possible, but the GUI expects an ALT+TAB at the end of each line.What is the best approach for an application running the Windows GUI?

18010

FreddyThinkwise Local Partner Brasil

performance tree universal GUI

For one of our customers we are trying to populate a tree view with 29800 nodes. It feels sluggish. The base query takes 1 second. How can we investigate further where delays are coming from?

19610