Questions & Conversations

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

  • 2,376 Topics
  • 8,116 Replies

2376 Topics

A
Vanguard
AshwiniVanguard
asked in Questions & Conversations

Calendar Scheduler

We have to create an event schedular in which we get dates entries from database. How do we create event schedular in software ?

20
C. Lousberg
Warrior
10 months ago
Tom van Druten
Warrior
Tom van DrutenWarrior
asked in Questions & Conversations

Combined filter searching like '%string with spaces%'

Right now you can make cool lookups which works with the 'Suggestion contains" control working as follow: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/a9e1abe6-5c9d-43a4-acca-a83cdfdaf763.jpg[/img] The thing I'm looking for right now is to achieve the same thing in the combined filter of that table, if you hit the lookup, but when i look search for "4022 635 9" in the combined filter, it will search as: [code]where (((((t1.[artikel_en_oms] like '%4022%'))) and (((t1.[artikel_en_oms] like '%635%'))) and (((t1.[artikel_en_oms] like '%9%'))))) [/code] I want to achieve: [code]where (((((t1.[artikel_en_oms] like '%4022 635 9%'))) [/code] Changing the filter condition in subjects -> data -> filter does not work. Is there a way to achieve this?

1
Anne Buit
Community Manager
4 years ago
Hugo Nienhuis
Superhero
Hugo NienhuisSuperhero
asked in Questions & Conversations

Error: Invalid object name 'project_vrs'.

I created a new project, generated it, executed it. I want to start the application but keep getting this error: Invalid object name 'project_vrs'. I am using the SF, not IAM. Help is appreciated, since I have no clue...

5
Hugo Nienhuis
Superhero
4 years ago
E
Moderator
Erwin EkkelModerator
asked in Questions & Conversations

Information panel reload makes all tasks disappear from the tasks bar

When you have an information panel on your screen the reload of this information panel makes all tasks disappear from the tasks/reports bar, probably due to the row loosing it's focus. Is there a way to prevent this from happening without creating a process flow to retain the focus?

3
E
Moderator
4 years ago
John Sangers
Apprentice
John SangersApprentice
asked in Questions & Conversations

Error message using FILESTREAM to save documents

I am trying to use FILESTREAM for saving documents in the database. I have a table containing these columns: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/21ec255c-73a0-4ce0-9a42-68589a664298.jpg[/img] The domains are defined as folows: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/3e914ab9-c492-4168-9108-c680e175eebf.jpg[/img] When I insert a document using T-SQL in SQL Mangement Studio in the GUI I see the documents as expected and can also open them using the lookup button. When I try to upload a new document I get the folowing error message: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/b33cf9da-9772-49a1-86b5-f4d5374d85f9.jpg[/img] This makes sense because the filestream_id is inserted with a null value, running the same command in SQL management studio without the field filestream_id and the null value works because the field has a default value (newsequentialid()). What should I change to make the GUI surpress the f

4
John Sangers
Apprentice
4 years ago
poonam
Moderator
poonamModerator
asked in Questions & Conversations

Any ideas/tricks to running tasks from different parts of the same screen?

Hi! I have a screen, and it looks like this one below. As you see, I have 2 taskbars on the same screen. [b]What I'm attempting to do here is to activate a detail tab (via a processflow) by allowing a user to click on a huge button on the bottom right of the screen, while keeping most of the tasks on the left side of the screen .[/b] [b][/b] My first attempt to solve this was via a dummy task which would direct the user to the detail tab. That's where I found myself building this screentype, trying to place 9 out of 10 of my table tasks on the left and one huge one on the bottom right. If you have tried this before, you know that it doesn't work that way and now [b]all[/b] of the 10 table tasks are in both places :sweat_smile: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/d7662395-887b-406c-99f5-928fe6c8bd80.png[/img] A couple of solutions I've already tried to achieve my separated tasks objective: 1 . Adding the task as a detail tile. This doesn't work

3
poonam
Moderator
4 years ago
Tom van Druten
Warrior
Tom van DrutenWarrior
asked in Questions & Conversations

Bad performance on inserting. 2nd insert is way faster

I have a problem with performance. The thing is there is a huge insert trigger which does all kinds of things when inserting an order. The insert trigger also inserts in a lot of other tables, causing a lot of insert triggers to go off. The strange thing is. The first time I insert something, the performance is just awful. The 2nd time I insert in the table, the performance is way better. I bet this has something to do with the SQL server caching stuff. An example is inserting an order based on a huge calculation took 13 seconds. The second time i did this it only took 2.8 seconds. We know this big 'trigger party' is a problem, but this is the way it works; the 3 seconds is acceptable, but 13 is not! I'd love to know if there's a way to see what is increasing this performance this much (like a cache) and is there a way to always achieve this? Like force caching stuff? Who can help me with this issue?

4
Robert Jan de Nie
Thinkwise blogger
4 years ago
R
Hero
RolandHero
asked in Questions & Conversations

Control procedure parameter - default value

First I created a control procedure with a parameter. Then I filled in a default value for the parameter in the task parameter tab. However the produced SQL code that actually creates the procedure does not set this default value on the database. Is this the correct behavior? The generated code in the software factory includes this part: [code]create procedure task_procedure_name ( @from_date date ) as begin [/code] However I would expect something like this: [code]create procedure task_procedure_name ( @from_date date = '1970-01-01' ) as begin [/code] My goal is to create a procedure which includes a parameter with a default value which I can override if necessary when calling the procedure using the execute command. Can this be accomplished?

8
R
Hero
4 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

'proc_application_startup' generated an error while deriving the parameters

What causes this error message during startup? [b][i]Stored procedure 'proc_application_startup' generated an error while deriving the parameters.[/i][/b] [b][i]Information:[/i][/b] [b][i]Parameter 0 - project_id (project_id):[/i][/b] [b][i]An SqlParameter with ParameterName '@project_id' is not contained by this SqlParameterCollection.[/i][/b] [b][i]Parameter 1 - message (message):[/i][/b] [b][i]An SqlParameter with ParameterName '@message' is not contained by this SqlParameterCollection.[/i][/b]

4
V
Moderator
4 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

Run WebGUI over SF (2019.1)

For developent purposes I like to run the WebGUI over SF. Is it still possible in SF version 2019.1? Are any additional settings needed, compared to 2018.3? Following message appears: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/741ba373-8a3c-40f0-97c7-a81f0bd7aab9.png[/img]

1
Erik Brink
Moderator
4 years ago
Eric Franken
Vanguard
Eric FrankenVanguard
asked in Questions & Conversations

Export to xlsx in reporting service (crystal report)

We created a report in Crystal Reports which we want to export to xlsx format and not to xls format. Is this possible? We want to do this because after generating several Excel files using the Thinkwise reporting Service we want to combine them as separate worksheets in one excel file. The component we use for this needs to have xlsx and not xls.

1
Jasper
Administrator
4 years ago
Mark Jongeling
Administrator
Mark JongelingCommunity manager
asked in Questions & Conversations

List pages in the Windows GUI

I know that with the Web GUI we have pages in Lists, capping the amount of rows you see to a certain amount. Now I'm trying to do that too in the Windows GUI for the project I'm working on because we sometimes have a huge list of maybe above 6000 rows. In the Software Factory we can set a limit to how many rows are displayed, and even the page sizes. But it looks like the page size doesn't work for the Windows GUI. How can I introduce list pages in the Windows GUI or is this not possible and can we only set a maximum?

1
Erik Brink
Moderator
4 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

Fields locked in combination with columns groups in grids, possible?

The grid property 'Fields Locked' seems to be ignored in case column groups exist in a grid. Is this a bug or desired behavior?

2
Harm Horstman
Superhero
4 years ago
Tom van Druten
Warrior
Tom van DrutenWarrior
asked in Questions & Conversations

Rename Template task failed because of related 'program object item parameters'

We're still on 2018.2. When i rename a Template, which has been assigned AND has parameters in the assignment, the rename task fails, because it has related parameters. Apparently the task is not working with these. Is this fixed yet in a later version of the SF?

4
Tom van Druten
Warrior
4 years ago
Hugo Nienhuis
Superhero
Hugo NienhuisSuperhero
asked in Questions & Conversations

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?

11
Hugo Nienhuis
Superhero
4 years ago
Harm Horstman
Superhero
Harm HorstmanSuperhero
asked in Questions & Conversations

How to use extended property 'ShowLoginInfo'

I tried to not show database details to end users in the production environment by adding the extended property 'ShowLoginInfo' with a value 'No' to a Runtime Configuration called 'PROD'. In the INI file the setting 'Configuration' with value 'PROD' was also added. Finally it did not work in the Windows GUI. Any ideas, how to solve this?

6
Harm Horstman
Superhero
4 years ago
R
Hero
RolandHero
asked in Questions & Conversations

Invalid value 'POST' for http method

For a process flow which processes both POST and PUT api calls it is necessary to use a variable for the HTTP method. However the HTTP connector produces this error: [quote]The process action with id 'http_connector' was provided with the invalid value 'POST' for its 'Http method' parameter.[/quote] What are the correct values for PUT and POST in case a variable is used?

2
R
Hero
4 years ago
G
Vanguard
gariensVanguard
asked in Questions & Conversations

conditions of buttons in a remote folder control

What are the conditions under which the buttons in the remote folder control are available? In my case I have the exact same rights in two different folders, however in one of two folders the remote folder control will let me use the buttons and in one folder it doesn't. I can use the functionality if I first move the folder with the move folder connector in a process flow and then open the location using the remote folder control. Still, the rights are completely the same. [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/f8d67711-cbd8-4e26-ab1c-ecad44a6ee3e.png[/img]

2
G
Vanguard
4 years ago
Arjan Sollie
Thinkwise blogger
Arjan SollieThinkwise blogger
asked in Questions & Conversations

Configure task, report and prefilter bars

In our current Graphical User Interface it is not possible to configure task, report and prefilter bars. Meaning that either all objects within the bar are being displayed or non at all. I have been told, that there is an extender, which allow you to configure these bars. I was wondering if the option to configure bars will be introduced within the Universal Graphical User Interface? Instead of having to set up an extender outside the Software Factory.

2
Arjan Sollie
Thinkwise blogger
4 years ago
A
Captain
Andre te RaaCaptain
asked in Questions & Conversations

How can I show a graph for an editable cube?

I want to show a cube and graph for an editable cube, to be able to show the details (tab) of the selected cel in the cube. Is this possible?

3
Erik Brink
Moderator
4 years ago
K.Bakkenes
Captain
K.BakkenesCaptain
asked in Questions & Conversations

Add a default constraint on (trace) columns

Is it possible to add a 'DEFAULT' constraint to columns via the TSF? Currently we fill trace columns via insert and update triggers but this results in unwanted trigger actions. The insert trigger will update the same table and thereby triggers the update trigger. Which in return executes the whole update trigger. (See code below) We have multiple places where this trigger nesting causes errors or wrong results. If we could add a DEFAULT constraint to the insert columns the code of the insert trigger won't be necessary anymore.[img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/0b4f2bf9-9b43-492f-9028-9013896fa316.png[/img]

8
Frank Wijnhout
Thinkwise blogger
3 years ago
G
Vanguard
gariensVanguard
asked in Questions & Conversations

Using task logic type 'windows command' in combination with powershell to retrieve 'MyDocuments' file path

I would like to use the task logic type 'windows command' in combination with powershell to execute the following command: [Environment]::GetFolderPath('MyDocuments'). In powershell this will retrieve the MyDocuments path and it should be passed into an output variable so I can use it in a processflow. Is this possible?

1
Jasper
Administrator
4 years ago
htimmermans
Captain
htimmermansCaptain
asked in Questions & Conversations

Window color

Where in the Theme can the color of the window be changed? I've tried so many fields so far entering the most rediculous colors where "nothing" was the default (I think I have them all). I want to change the color blue to a different blue or even white that matches the corporate color scheme. Perhaps a font has to be changed in the theme (with a different background color). I know for a fact that the color can be changed, as I have several projects with a different window color, but I'm stuck finding the right setting..... This particular blue is probably a default window color... [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/fc8324e7-5dca-4aa8-9d97-f7b8959d5e9a.png[/img] Another application has a white top border. That's what I'm trying to achieve in the Theme. [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/e0da50f1-b330-4841-85ab-ae4d242879f3.png[/img] In short: where can the top bar (blue in my case) be changed to a diffe

2
htimmermans
Captain
4 years ago
E
Sidekick
ericbosmanSidekick
asked in Questions & Conversations

Required permissions for Indicium in databases

I'm working on the automated deployment of Indicium via Octopus Deploy. I understand that for the use of Indicium and logging in, it is necessary that the application pool user of indicium has 'all rights' to the IAM and the ActoProject database. Preferably I want to make as little db_owner as possible, so now my question is: what is all the permissions? On IAM I see 16 roles in the SQL database. Can I indicate to which role the Application Pool User of Indicium should be linked? For ActoProject we have a role 'all_rights', I assume that these are the right rights for the Application Pool User. Is that right? Is it also possible to give a short description of the purpose of each role? (But it's probably better to publish it on your website) Greetings, Eric Bosman

3
Anne Buit
Community Manager
4 years ago
htimmermans
Captain
htimmermansCaptain
asked in Questions & Conversations

Where does my (answered) question go????

I've seen this twice this week now... I receive an e-mail from the community with a link to the subject, but (even after logging on) I'm told I don't have access. This is fine by me, if the question or idea is no longer relevant and might pollutes the community with unnecessary topics. But if that is the case, please stop mailing about changes when the link is no longer available.... [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/f748328f-8637-430c-9d01-64515ded6e09.png[/img]

4
Moller Toma
Captain
4 years ago

Badges

Show all badges
Terms & ConditionsCookie settings