Questions & Conversations

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

  • 2,350 Topics
  • 8,023 Replies

2350 Topics

E
Sidekick
ericbosmanSidekick
asked in Questions & Conversations

Universal-GUI and Cors

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

8
Freddy
2 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

Sort order in API output for table functions

How can the sort order of of items for a table function be set?I am using Indicium 2021.2 (Universal)

8
Harm Horstman
Superhero
2 years ago
Sulea Ema
Vanguard
Sulea EmaVanguard
asked in Questions & Conversations

User roles

 I need to filter the data based on the user role .An employee has more items ,but each employee has his own set of items .For example if the user is logged as an employee ,I would like to see the specific items for this employee . How I should approach this problem?

8
Sulea Ema
Vanguard
1 year ago
O
Vanguard
Onno SpoorVanguard
asked in Questions & Conversations

Address of Indicium for SF

Where can we set the address of the Indicium to be used by the Software Factory?We've just upgraded to 2021.3 and now if we try to perform the ‘Generate definition’ step of the 'Creation’ process, the SF is stating that it 'stopped hearing from Indicium’.Indicium is however running.

8
O
Vanguard
2 years ago
ElenaTodirenchi
Vanguard
ElenaTodirenchiVanguard
asked in Questions & Conversations

Arithmetic overflow erroe

Hello. I added a new column to a table and I made a reference to another table. And when I tried to add a value in the column I received this error.  

8
ElenaTodirenchi
Vanguard
1 year ago
R
Hero
RolandHero
asked in Questions & Conversations

Start system flow with API call

I am trying to start a system flow via an API call to Indicium. The API URL works. When I visit it with a browser I get to log in and see the application version number. However the same URL followed with / and the system flow name gives a 404 Not Found in Insomnia. The system flow exists in IAM since I can find it there.Browser: http://[server]/indicium_universal_prod/iam/[alias]Insomnia: http://[server]/indicium_universal_prod/iam/[alias]/documenten_aanmakenWhy doesn’t the API call work?

8
R
Hero
1 year ago
R
Captain
Roy van UffelenCaptain
asked in Questions & Conversations

Custom message on delete

Our customer wants to indicate which details are depending on the (to be) deleted record.For instance you have a person with multiple addresses and an address can belong to multiple persons. When deleting an address, they want to have an error message that indicates which persons are still using this address. The user then, first has to remove these connections before it may delete the address.What's the easiest way to implement this?

8
Mark Jongeling
Administrator
2 years ago
A
Sidekick
Amel RamulicSidekick
asked in Questions & Conversations

Process flow parameters

When we execute a print task it takes the parameters planning_tekenkamer_onderdeel_id and bgs_bestand. The report doesn't import the parameters planning_tekenkamer_onderdeel_id and bgs_bestand. 

8
E
Moderator
3 years 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
1 year ago
E
Sidekick
Edwin SaanSidekick
asked in Questions & Conversations

Validation process flow requirems user input

I’m getting a “Scheduled process flow requires user input” validation. I started the process flow with a task but I will schedule this flow.So I deleted the task from the process flow, and there are only decisions and http connectors left.But the validation still gives this message.We’re on 2021.2 with SF. What can I do?

8
E
Sidekick
2 years ago
E
Sidekick
Edwin SaanSidekick
asked in Questions & Conversations

Indidicum 502.5 error

Hi tried to update Indicium this morning but Indicium will not start anymore.I have unblocked the block flag of all files with the streams.exe tool. I copied all new files to the indicium location and updated the appsettings.json. That's the normal procedure. But when opening the Indicium URL I'm getting this error. The windows event log gives the same message. The application will not start... TTP Error 502.5 - ANCM Out-Of-Process Startup FailureCommon causes of this issue:The application process failed to start The application process started but then stopped The application process started but failed to listen on the configured portTroubleshooting steps:Check the system event log for error messages Enable logging the application process' stdout messages Attach a debugger to the application process and inspectFor more information visit: https://go.microsoft.com/fwlink/?LinkID=808681  

8
Mark Jongeling
Administrator
2 years ago
R
Sidekick
rustieSidekick
asked in Questions & Conversations

Copy existing user preferences

The Copy existing user preferences does not work.I am on version 2022.2 and there are many users that i need to change the preferences for (config, time zone, language). according to Users | Thinkwise Documentation (thinkwisesoftware.com) it should be possible to do this. but after it executes and i refresh i see no changes to the user. anyone alse here have a solution for this?It’s tedious to change user preferences one by one if you have a hundred plus users.

8
R
Sidekick
1 year ago
R
Superhero
René WSuperhero
asked in Questions & Conversations

Call default on editing

I'm trying to convert some trigger logic to default logic, because I would like to use the 'system versioned tables'. Having triggers causes a lot of records in the history table, which isn't necessary.I'm currently using a trigger to update the 'update_user' and 'update_date_time', and also an update_counter for preventing concurrent editing. I've tried to set up a default which sets the update_user and update_date_time. Problem is that it's only fired when a column has default logic enabled and the value is changed. What I want is that the default is also triggered when the user starts editing. Or maybe after he's done editing. Then I would like to update the update user / datetime. When inserting a record this happens (e.g. @cursor_from_col_id is null), but when editing it isn't.A work around is passing all table columns to the default, but I don't want this because it's unneccesary and a performance killer.Any suggestions on this case, preventing unneccesary records in the history

8
A
Superhero
2 years ago
P
Sidekick
Peter de WitSidekick
asked in Questions & Conversations

Creation keeps handling certain tables

Every time I run ‘Creation’ de upgrade-file gives me back 4 tables which not have been changed for months. Luckily, these are not the biggest tables but it is very confusing to see not only he tables that really needs to be converted. What could be the reason they keep coming back ?

8
P
Sidekick
2 years ago
Rucha Naik
Rucha NaikPartner
asked in Questions & Conversations

Can one process variable be used as the variable in another process variable?

Let me give some context: I am making a process for an employee when he initiates his resignation, an email will be sent to the HR and his manager.In this process I have an process variable which store the employee id of current user. Now I want to use this in the email body of the smtp connector where the name of the employee will be sent.The email is getting generated, however the place for the name of the employee is blank.Attaching the flow below.Process to start the resignation tab and send the email after the row is added.Below is the process variable to get the name of the employee from the employee idprocess variable using another process variable {employee_id} The SMTP input:   

8
Rucha Naik
1 year ago
J. de Lange
Captain
J. de LangeCaptain
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
Captain
1 year ago
Hugo Nienhuis
Superhero
Hugo NienhuisSuperhero
asked in Questions & Conversations

sending a pdf with the http connector

I am trying to upload a pdf file to an external server. The http-connector should sent a multipart/form-data message, consisting of an application/json part and an application/pdf part.I have constructed the message and I am able to upload a file to the server. However, the pdf file seems to be corrupted or somehow transferred incorrectly.I am reading the pdf file as a varbinary and since I am unable to insert a binary in the content-variable of the http-connector, I am forced to convert the varbinary to a varchar. I use the following code to do so:convert(varchar(max), @file_data, 1)To evaluate I have sent the message from the Thinkwise http-connector as well as from Postman to RequestBin.com. The messages arrive differently: Postman, raw, looks like this (only part of the data copied)0000000 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 0000010 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 2d 32 34 33 39 0000020 37 33 36 39 30 35 31 32 39 35 31 33 37 37 36 38 0000030 31 37 34 32 0d 0a 43 6f 6e

8
Hugo Nienhuis
Superhero
1 year ago
Dennis van Leeuwen
Hero
Dennis van LeeuwenHero
asked in Questions & Conversations

Messages Audio file

I’ve added an .mp3 file to a message that goes off from a default under certain conditions. Unfortunately, it does not seem to work in both the Windows and Universal GUI. 🔇 No audio; ⬜ No preview available; .mp3 and .wav No preview available.Am I missing something? The new feature to add a sound to your message by uploading an Audio file in not yet in the (TCP) feature matrix. 

8
Dani
Moderator
1 year ago
R
Captain
Roy van UffelenCaptain
asked in Questions & Conversations

How to browse for filename with path, without actually uploading the data?

Using the File upload control it is possible to upload a file. Using File upload requires a Storage location in the database.Is there an option to browse for a file (or folder) and only import the selected path (with filename), but without actually having to upload a file?I want to use this in combination with BULK INSERT, so don't need an uploaded folder in the application.

8
Mark Jongeling
Administrator
2 years ago
rbiram
Hero
rbiramHero
asked in Questions & Conversations

Universal CSS question

Hi, In our application we have some expression fields in a form which has auto-edit enabled. When auto-edit is enabled the text in this field gets greyed out like this:We want this text to be black eventhough auto-edit is enabled. I've tried doing this with a conditional layout specifically set for this field, but even then the color gets overwritten somehow. So the next step is doing this by changing the css values.I've checked which element and  css class I need to edit the color, which are the following:I've changed the alpha channel from 0.38 to 1 and the text color changes to black:So I took the css class and made the change in my custom.css file. Restarted my application. But nothing's changed. Anyone know what I'm missing? Thanks!

8
rbiram
Hero
1 year ago
A
Vanguard
André RomijnVanguard
asked in Questions & Conversations

Using tsf_user() in a default value expression

Using the dbo.tsf_user() in a default value expression (see image below) leads to an error in execution of a model (after an upgrade from SF2021.2 to SF2022.2) We experience the following error during execution of the source code:  Error: 'Column "dbo" is not allowed in this context, and the user-defined function or aggregate "dbo.tsf_user" could not be found.'.Any ideas?

8
Freddy
1 year ago
Jaap van Beusekom
Vanguard
Jaap van BeusekomVanguard
asked in Questions & Conversations

Code search field, the magic trick?

Hi all,I always look with my arms over each other to @Robbert van Tongeren working in TSF. But now I’m on my own and have a simple question:He uses search code very quickly but when I open "Code search" in TSF I cannot directly start typing into "search string". After some clicks, switching fields it was possible to enter the code but there must be a magic trick to input and start searching the code directly. (TSF 2021.1)Please share this trick here :-)​ 

8
Mark Jongeling
Administrator
2 years ago
A
Superhero
Arie VSuperhero
posted in Questions & Conversations

Synchronize to IAM without downtime (Universal GUI)

Dear Community,We only use Universal GUI as GUI in our Production environment, and of course always look for ways to push functionality to our end users as fast and with as little downtime as possible. In that regard I would like to verify whether or not it is safe to do Sync to IAM without taking the Application down?A couple of remarks:I understand that for older GUIs the User session is actively terminated, this is not the case in Universal GUI. I am talking about doing a Sync to IAM of the current Active project version in a Production environment. Example use cases: After PROD deploy of new functionality we need to straighten up some UI or Roles issues Simple User Interface-related changes requested by End users The untranslated error message in the Universal GUI is not understandable for an end user, this should be fixed so end users actually understand that some functionality might have changed due to an update: I just performed the following test (see below GIF): Login with

8
A
Superhero
2 years ago
R
Superhero
René WSuperhero
asked in Questions & Conversations

Override short cuts

For some subjects we've disabled the default CRUD elements and replaced it by tasks.For the ‘Edit’ I can assign Ctrl + E to “override” the default edit shortcut. However, for the add and delete I cannot select the + and - sign. The Ascii code table is unfortunately read only. Is this somehow possible to do?It would make more sense to our users the shortcuts are generic and not mixed (Ctrl+- and Alt+X for example). I'm aware that this idea would probably fix our problem, but I don't really expect that to be implemented soon.

8
Mark Jongeling
Administrator
2 years ago
M
Sidekick
Marco KleiwegSidekick
asked in Questions & Conversations

Problem Automatic license renewal 2021.1

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?

8
V
Moderator
2 years ago

Badges

Show all badges
Terms & ConditionsCookie settings