Questions & Conversations
Software Factory & IAM (Installation, Development, Deployment, Integration) | E-learning | Documentation | Community
- 1,788 Topics
- 6,156 Replies
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?
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
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?
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?
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
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?
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?
'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]
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?
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]
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.
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?
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?
Automatically download files in a task
We generate XML files in our system. These files currently can be approached by using a task. We have chosen for a task because we want to log all persons approaching the XML. [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/57d23ca9-0754-412b-8a16-d8da771659b0.png[/img] In this task we see the file name and the option to download this file. After pressing the green download button we have to exit the task by pressing 'uitvoeren'. [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/20948a7d-4022-4c27-9fa0-5f3558d34fcf.png[/img] Is it possible to start the downloading of the document the path is referring to automatically instead of pressing the green download button after we opened the task?
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]
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?
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.
The type initializer for 'CrystalDecisions.CrystalReports.Engine.ReportDocument' threw an exception
A customer has migrated to Windows Server 2016 (64 bit) and now our reports (Crystal Reports) don't start anymore. The error message is: The type initializer for '[b]CrystalDecisions[/b].[b]CrystalReports[/b].[b]Engine[/b].[b]ReportDocument[/b]' threw an exception The Thinkwise applicatie that the customer is working with has been developed with TSF 2017.1. The version Windows GUI is 2018.1.17. The SAP Crystal Reports runtime engine for .NET framework (64 bit) is 188.8.131.527. I have two questions: 1. What causes this error? 2. What determines which version of the SAP Crystal Reports runtime enige I should install? Could anyone help me out here?
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
Error caused by display_expression
One column of my table has the column id 'display_expression_1' and it is giving me an error (Invalid column name 'jaar') in the application when modifying a record. The column description in the SF says: "Automatically created with the upgrade to G9.5. Replacement for look-up display expression." There are other display expression columns in the same table which are not causing an error. The only difference between them is that the former column has no 'Expression dependencies' specified. See comparison of both columns below. [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/ce0cd960-f947-4320-a449-838b2aeeef93.png[/img] [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/1e32d2bd-aa63-4ba8-806c-d24c55552359.png[/img] I expect that this lack of dependencies is causing the problem, but cannot find a way to add them. Please advise how I can solve this issue. Thanks!
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?
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
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.