Product updates
Ideas
Groups
E-learning
Documentation
Events

Community
Thinkwise Platform

Thinkwise Platform

Questions, discussions, news and updates regarding the Thinkwise Platform.

1681 Topics

Recently active

Most replies Most views Newest first

RolandCaptain

asked in Questions & Conversations

Authentication for Azure and other off-premise databases in SF

Here’s a very simple question I somehow cannot figure out. How does one authenticate a connection to an off-premise SQL Server instance such as Azure in software factory? I’ve added a runtime configuration for the Azure database but there is no means here to store a username and password.I assume the current runtime configurations pick up the domain user credentials to connect to on-premise databases but this obviously doesn’t work with Azure databases.

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Windows GUI - Filter in Grid (what steers functionality)

What settings steer the functionality of filtering in the grid? I have 4 similar lookup fields, ID with lookup to base table.. and as far as I can see 2 have a filter option like below and 2 don't.. what setting causes this difference? I want all fields to have a similar filter option.

asked in Questions & Conversations

Making a GET request to a 3rd party API

So, Currently i`m using a 3rd party api. This one is currently divided by 2 parts. 1 where we call an api endpoint to retrieve a list of objects. From there we scrape them one by one and push them to our database.Part 2 is where we select every row where a certain status = 0. Now here comes the weird part. Due that the api endpoint has a need for a certain id. So the most smartest decision would be : SET @url = CONCAT('<secret_api_endpoint>/', @documentId)Sadly enough the last part where we insert the information to the database hasnt even reached. So something went wrong when calling for the api endpoint

Dennis van LeeuwenCaptain

posted in Questions & Conversations

Improve start-up speed application

When the application is started for the first time, the reports are stored locally in the "C:\Users\UserName\AppData\Local\ThinkwiseSoftware\GUI\GUI\Cache\Images\NIVERPLAST_4.50\Report" folder. With the release of a new GUI, I understand that the system will replace the local GUI folder and it will also take a little longer. However, how can the performance be improved for the daily start-up of the Windows GUI without any changes having taken place. For example, is it really necessary that the reports are replaced in the ..\Cache\Images\NIVERPLAST_4.50\Report" folder every time? First start-up of the applicationIsn't it possible to a verify or the application if a report has been modified within a project version and only updates the report then? ← Left| First start-up / Start-up when local folder incl. files are already exist | Right →

asked in Questions & Conversations

443 in file upload link

Hi,After I upload a file I am getting “:443” in the upload link. Which means I can't access it via external app with the preview link.Link after file upload:But if the document is generated it doesn’t get “:443” in the link.What is causing this? And how to fix it?

Harm HorstmanHero

asked in Questions & 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.

TristanApprentice

asked in Questions & Conversations

Universal GUI - Filter condition not changing for numeric field

We have a filter issue for a non-reference field with datatype NUMERIC. The filter condition set in the SF doesnt reflect the filter in the GUI. In the SF ‘equal to’ is set to filter condition, but in universal it keeps showing up as ‘bigger then or equal to’. When set to ‘equal to’ in the SF, we would like to see a combobox populated with all existing values in the table.

Alex KerschkampWarrior

asked in Questions & Conversations

Lookup problem regarding SQL performance

Hi Everyone,We're populating a table with over 9 million addresses. These addresses serve an auto-complete lookup. Whenever a user starts typing, the lookup displays results that match what the user typed thusfar. This worked great when we had 10 addresses in the database. Now that the database is filled with over a million addresses, the lookup grinds to a halt whenever the user starts to type, uses the caret or clicks the looking glass to open the selection form. How do we handle tables containing a large amount of records with an auto-complete lookup?The database is still getting filled. Once filled, we'll create an index on the table. This will speed it up. What other things can we do to keep the UI user-friendly and responsive? Can the looking glass and/or the caret be removed from the field, for instance?We're using Universal, but the Windows GUI suffers from the same lag. Our database is an Azure hosted database.Thanks,- Alex.

MartinRookie

asked in Questions & Conversations

IAM - Rename user API

Hi, in our application we create users and with the API endpoints mentioned in the topic below we also create and maintain them in IAM.Intelligent Application Manager - API on UserIn some cases it is necessaryto rename the user id and for that I want to use the task “rename_usr_general” in IAM. Is there a way to use this task as a API endpoint or is there a complete list of all the endpoints Indicium offers?

sujitSidekick

asked in Questions & Conversations

Unable to send File Location & File data to SMTP Connector from Process Action write_file & attachment_to_disk

Hi Team,I have a process flow which send email with attachment(multiple attachment are separated by semicolon)& file_location when ever any email_status is open.When I run that task to send email - The process Flow 1st run the process action - excute_tab_task then move to → decision → decision_attachment_to_disk → write_file,After the write_file Process Action ,an infinite loop will run which always then goto process action (decision_attachment_to_disk → write_file) from where the process flow Nevers Go to the Process Action SMTP_Connector.Here I attached both Process Flow Design & Process Monitor windowCan anyone suggest me ,how to move SMTP_Connector Process action Also attached the functionality which written under process template attachment_to_disk.I have attached input parameters for wite_file Process action If this information is not sufficient, Please free to reach me i am waiting for your ReplyRegards,Sujit

HJ van DalfsenSidekick

asked in Questions & Conversations

Performance issues

Hi, For our application, we are facing on several screens performance issues since we are in production and the set of data is growing.Some examples:For a table we moved some big fields containing json content already to a separate table, and made them visible in a form tab. But when click on the form tab, it still will take > 30 sec before it is loaded. It looks like the full table is loading before the related record is shown. For a screen we have defined a form layout to show (summary) details of related child records. This is currently build in a view, but when loading that tab it will take some time before the (filtered) data is shown. For a table we are showing lot of extra data with expression fields as the base data is not stored in that table, but in related tables. It is not preferred to have that data stored twice, als in the ‘header’ table to reduce the number of expression fields.Are there suggestions to improve the performance for loading the data in a form detail?

Sulea EmaApprentice

asked in Questions & Conversations

Conditional label

Hi! I have put speciifc label for each group of columns as you can see below .I did this from subjects->compomontes>grid->group label .I want this label to be automatically generated based on the current month as the data is now hard coded .It there any possibility to do that with a layout or maybe other procedure?

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

TCP Downloads more often fail than succeed.

I have a problem, perhaps because of the distance, that my downloads from TCP are failing more than they are successful. Looks like a download link is generated and doesn't persists.. because after a ‘network failure’ somewhere between Brazil and the Netherlands there is no way to restart or resume the download. I sometimes have to try 10 times before I successfully have downloaded updates and upgrades. Would be great if somebody could have a look at this.

rbiramApprentice

asked in Questions & Conversations

Image upload Universal

Hi,I've set up an image column with an image_upload domain.This is how the domain is set up:The ‘azure image’ storage location is configured like this:Where the user name is the storage account name and the password is key 1 from the Acces keys page for that particular storage. All seems right to me so far. But when I opend the tab where this column is located I get an unknown error:This error can't be found in the logs and Redux isn't showing me anything to fix either. I know it's the image column that causes the error, because when I change the domain to something random like a varchar, the page loads fine. I'm on Universal GUI 2022.2.15 Anyone has an idea what it could be?

Harm HorstmanHero

asked in Questions & Conversations

Show HTML in Previewer in Universal GUI

It seems like not possible to show HTML in the previewer component in Universal.Is this not yet possible in the Universal GUI or can it be realized in another way?See below an example of a HTML page shown in de Windows GUI versus Universal Universal:

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

BEFORE trigger

How do I create a BEFORE trigger on a table still have the AFTER trigger working? I just noticed there is only the INSTEAD OF and AFTER trigger, can we create a BEFORE trigger with the SF?

WertherApprentice

asked in Questions & Conversations

URL control different label

I want to show a different text in a URL control type. It always shows the URL link, Is there a way to do this?

UshaVanguard

asked in Questions & Conversations

Replacing with new domain is not working.

We tried to change our existing domain to new format (*.*.*.nl) to (*.*.nl), it is not working.Currently we are using non SSL url and when we changed it to SSL domain and updated indicium and SSL configuration files. But it is not showing the application as expected but the indicium page.(indicium.png). We don’t understand what we are missing here.Attaching the config files and error log too for your reference. Note: We are using Linux server with nginx.Hope someone could help us to resolve this issue. Thank you.

asked in Questions & Conversations

Universal and Model changes

What is the way to refresh the data model in the Universal GUI?I have an application built for the Windows GUI and now I want to use it in Universal but that needed some changes in the model. I am running the Universal GUI directly to SF.For example; I disabled the Layout input of a column, but Universal keeps giving an error about a missing parameter in the layout procedure.The only way to stop all these errors was to recycle Indicium, but there must be a nicer/easier way.

Rucha NaikPartner

asked in Questions & Conversations

HTTP connector giving -1 output for user creation

Hi,While trying to create user in IAM, the user is getting created when using Insomnia (after disabling SSL). The GUI version is : 2022.2.16.0The complete process worked form SF when the URL did not have SSL certificate.However for the URL with SSL certificate, the HTTP connector returned -1 .Can you please guide, how can I get it correct?it worked for insomniaHTTP connector input

asked in Questions & Conversations

Universal 2022.2.4 not displaying data properly

Hi all,we are having the following issues in Universal:where the data is not displaying properly. and Universal is changing the data. See attachmentsAnyone know what causes these issues? Datatype is bigint

FreddyThinkwise Local Partner Brasil

posted in Questions & Conversations

Universal GUI - Filter condition not changing

Since the latest Universal GUI you can change the filter condition. I have a key field that keeps showing up as 'contains' in stead of 'equal to' (as defined in the SF).. It's a numerical field. Any ideas?

AndreKemmerenSidekick

asked in Questions & Conversations

Open SQL connections for all scheduled flows

We are getting errors on our Indicium when executing process flows, it seems that Indicium opens a SQL connection for every scheduled process flow.On paper this sounds not to bad but our development environment we run into the limitations of Azure SQL. Azure SQL only has a limited amount of open connections which we are running into on our current tier (which is for all other metrics plenty). Currently it results in SQL errors regarding to many open connections.It also seems a bit strange to have constant open connections even for process flows that might only run once per day, week or even less.

J. de LangeWarrior

asked in Questions & Conversations

with inline = on - iTVF subroutine causing errors

I’m trying to create an inlineable Table Valued Function. I’ve created a subroutine with option INLINE set to ON. The function has a nearly empty template only containing:return;whenever I try to execute the source code I get this error:Msg 487, Level 16, State 1, Procedure get_calculation_component_overview, Line 47 [Batch Start Line 6]An invalid option was specified for the statement "CREATE/ALTER FUNCTION".The function executes fine when I remove the linewith inline = onThe database compatibility is 150 and we’re using SQL server 2019: Why isn’t this working?

asked in Questions & Conversations

Prevent users from editing the same record simultaneously.

Hi, I am looking for a solution to a challenge we seem to have with the possibility of two users editing the same record simultaneously. Now, any changes made by the first user to save his or her changes will be overwritten by the changes of the second user.Is there any known way to prevent this from happening? (Preferably using some form of user feedback, “User X is editing this record, it is not possible to update it at this time”) I'm not familiar with whether/what kind of session information is available in Thinkwise. Thanks in advance.

1
2
3
4
...
68

Page 1 / 68

Badges

Freddyhas earned the badge Problem solver
Dick van den Brinkhas earned the badge Problem solver
Vincent Doppenberghas earned the badge Superhero
Renée Evertzenhas earned the badge Advertiser
Rickyhas earned the badge Publisher

Show all badges

Powered by inSided

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login

Login to the Thinkwise Software Community

Login

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK