Questions & Conversations

Software Factory & IAM (Installation, Development, Deployment, Integration) | E-learning | Documentation | Community

  • 1,563 Topics
  • 5,311 Replies

1563 Topics

R
Captain
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.

3
A
Superhero
4 hours ago
Freddy
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.   

2
Freddy
3 days ago
A
Rookie
AnthonyRookie
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

3
A
Rookie
3 days ago
Dennis van Leeuwen
Captain
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 →  

4
Mark Jongeling
Administrator
3 days ago
N
Rookie
najambiaRookie
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?    

7
D
Moderator
4 days ago
Harm Horstman
Hero
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.

12
Harm Horstman
Hero
4 days ago
T
Apprentice
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.

8
Erik Brink
Moderator
4 days ago
Alex Kerschkamp
Warrior
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.

6
Alex Kerschkamp
Warrior
4 days ago
M
Rookie
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?

1
Anne Buit
Community Manager
4 days ago
S
Sidekick
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

3
Mark Jongeling
Administrator
4 days ago
H
Sidekick
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?

8
Mark Jongeling
Administrator
4 days ago
Sulea Ema
Apprentice
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?

1
Mark Jongeling
Administrator
4 days ago
Freddy
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.     

3
Freddy
4 days ago
R
Apprentice
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? 

2
R
Apprentice
4 days ago
Harm Horstman
Hero
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: 

8
Erik Brink
Moderator
4 days ago
Freddy
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?

2
Freddy
5 days ago
Werther
Apprentice
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?

1
Werther
Apprentice
5 days ago
U
Vanguard
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.  

4
U
Vanguard
5 days ago
P
Sidekick
PatrickW
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.

4
P
Sidekick
5 days ago
R
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 

4
R
5 days ago
Z
Rookie
ZacheryRookie
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

4
Erik Brink
Moderator
6 days ago
Freddy
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?

6
Mark Jongeling
Administrator
6 days ago
AndreKemmeren
Sidekick
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.

6
Kasper Reijnders
6 days ago
J. de Lange
Warrior
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?

8
J. de Lange
Warrior
7 days ago
MtHoen
Apprentice
MtHoen
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.  

2
MtHoen
Apprentice
7 days ago

Badges

Show all badges
Terms & ConditionsCookie settings