Questions, discussions, news and updates regarding the Thinkwise Platform.
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.
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.
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
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 →
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.
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.
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.
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?
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
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?
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?
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.
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?
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.
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.
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
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.
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?
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.
Login to the Thinkwise Software Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.