Questions & Conversations

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

  • 1,912 Topics
  • 6,615 Replies

1912 Topics

R
Hero
RolandHero
asked in Questions & Conversations

Temporal table "for system time" makes task very slow

For a certain task it’s required to query a system-versioned aka temporal table at a certain point in the past. Let’s call this table temporal_table for simplicity.Here’s an example query:select v.*from temporal_table for system_time as of '2021-2-27 14:59:46' vIn SQL Server Management Studio (SSMS) this runs in about 2 seconds for this particular table. Using this in a lengthy select statement with a bunch of joins also runs rather fast in SSMS as it takes about 10 seconds to finish.The problem happens when this code is used in a task in our end product. As soon as the for system_time flag is used in the SQL code the task goes from running 10 seconds to what’s basically forever. This is the same code used in SSMS, with the exact same datetime for testing purposes. (This date will be replaced by a parameter in a later stage as it needs to be dynamic.)I’ve tried to get around the issue with this alternative query:select v.*from temporal_table for system_time all vwhere '2021-2-27 1

3
R
Hero
2 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
F
Thinkwise blogger
2 years ago
Dennis van Leeuwen
Hero
Dennis van LeeuwenHero
posted in Questions & Conversations

Gantt chart planning

I'm curious or there are customers who using Thinkwise for company-wide planning. We would consider the options for a planning module in Thinkwise. But because we are still a bit skeptical we would like to hear who has already developed something similar. Important requirements are at least to plan projects and resources and show and edit them in a Gantt Chart diagram. Of course there will be a set of basic requirements like the possiblity to create some dependencies between taks, assign tasks to people and monitoring the progress of a task.  Example Gantt Chart to develop in the SF At the moment we're using Timewax as our project & resource planning software. With the open Timewax API we can create seamless integrations with our own Thinkwise system. We can retrieve, create, edit and delete both master and transaction data in Timewax.   Gantt Chart planning  Planning board 

6
A
Superhero
1 year ago
Arjan Sollie
Thinkwise blogger
Arjan SollieThinkwise blogger
posted in Questions & Conversations

Email queue with email attachments

This is an Archived topic. The solution is available in the Thinkstore inside the Software Factory.GoalSending emails from within your application is a common feature and can be implemented in many ways. However the traceability of sending emails from your application is often difficult. Therefor it is very usefully to gain some insights into which emails have been sent to whom and whether the email has exactly been sent. This topic demonstrates a basic setup for gaining insight into your email traffic. SolutionFirst of you will have to set up some tables. This example will also contain tables used by the Thinkwise Reporting Service. This topic will allow you to email attachments created by the Thinkwise Reporting Service. This topic will not explain how the configure sending emails with a template. If you would to know how to do that, look at this topic: Example email module. Create the following tables (if you do not use the Thinkwise Reporting Service, ignore the reporting_service_r

1
Robert Jan de Nie
Thinkwise blogger
2 years ago
A
Superhero
Arie VSuperhero
posted in Questions & Conversations

Notification options with the Thinkwise platform?

One of the major trends in IT is the tighter integration of Communication, Collaboration and Core System tools. Microsoft Teams and Slack are communication channels that not only replace email for many conversations and notifications, but also provide great added value for collaboration. Microsoft Teams far outperforms any of their competitors on collaboration, thanks to being embedded in Office/Dynamics 365 and allowing for custom in-Teams apps, integrations, etc. Slack has been acquired by SalesForce recently with the same purpose of tightly integrating a collaboration tool with a Core (CRM) System:Together, Salesforce and Slack will deliver the Slack-first Customer 360 that gives companies a single source of truth for their business, and a single platform for connecting employees, customers, and partners with each other and the apps they use every day, all within their existing workflows.In light of these trends and the high adoption rates of tools like Teams and Slack, I am surpris

7
Jasper
Administrator
6 months ago
R
Hero
RolandHero
asked in Questions & Conversations

Run Indicium on Linux

Does Indicium run well in a Linux environment? I haven't tried Mono yet but apparently it is capable of running .net core applications. Is the current version of Indicium ready for it?

8
V
Moderator
7 months ago
Harm Horstman
Hero
Harm HorstmanHero
asked in Questions & Conversations

Output JSON data via Indicium

I am trying to make a link from a third party application to my Thnikwise application via Indicium. For this I prefer the use of tasks/stored procedures with output parameters, which works fine. To minimize the amount of requests I like to return detail data in JSON format as output. It works almost as expected, except that Indicium ads escape characters (backslashes). Like this: [code]{ "@odata.context":"https://dev-mob.smarttt.nl/sf/stt/$metadata#STT.complex", "row_id": "BBF3801D-2E9C-42FC-9D33-182C326867EB", "item_id": "Jhlkd2awEQLiPSK7B", "child_rows": "[{\"row_id\":\"80E2F8FDD3B3\",\"image_id\":\"1231\"}, {\"row_id\":\"47F6978E83EE\",\"image_id\":\"1232\"}, {\"row_id\":\"2D40689AFEA2\",\"image_id\":\"1234\"}]" } [/code] I there any way or trick to get this solved?

9
V
Moderator
2 months ago
Alex Kerschkamp
Captain
Alex KerschkampCaptain
asked in Questions & Conversations

Microsoft Graph issue

Hello everyone,Because the new Exchange connector that is scheduled for the month November of this year will not give adequate possibilities for our client, we're trying our luck with Microsoft Graph. We created a call and made it fit our needs using Postman.We configured and use all the right credentials (client ID, tenant ID and client secret) for token generation. Actually, we created a call for getting data, and one for patching data. The call types are, of course, get and patch respectively. All calls are successful, and perform as expected, using Postman.Next, we went to our Software Factory, to make Thinkwise perform the same calls. Using a process flow, we make the proper call, the same as we did using Postman.We get a correct token in Thinkwise. When we copy this token from the debugger, and check it with jwt.ms, we get a valid token. In fact, when we use this token in Postman to make calls, it works perfectly. So, token generation works properly.However, the calls that work i

15
Alex Kerschkamp
Captain
10 months ago
Blommetje
BlommetjePartner
asked in Questions & Conversations

use comma instead of point

Hi,for the entire app we use a lot of fields with values with a comma. However, TW by defaults uses a point. Now this is not too bad for our friends in the us of a. But here in Europe, I would very much like to offer a comma in values. Is this possible? It is needed for money, size, weight, etc.  

21
Mark Jongeling
Administrator
2 years ago
htimmermans
Vanguard
htimmermansVanguard
asked in Questions & Conversations

Layout procedure and expression field

We are using SF 2019.1 since a couple of weeks, and in a project I'd like to add one Calculated field (Expression) and use that value in a layout procedure to dertermine wether to show some fields in the form and/or make them mandatory.I could be mistaking, but wasn't this possible in an earlier release of the SF? Now I only can set the field available for a Default procedure. The rest, including the layout procedure, are read-only, If this was available in a previous version of the SF, and I've used it before, than those layout procedures probably won't compile in this version of the SF. If it has always been this way, why not make the Expression fields available to the layout procedure. Taking a possible performance degradation into account is up to the developer. In this case it is a small table, without a view. This way I'm forced to create a view, instead of trigger and what have you...   

6
Anne Buit
Community Manager
2 years ago
R
Superhero
René WSuperhero
asked in Questions & Conversations

Bulk import CSV / Excel data

I'm trying to let the end user import ‘large’ sets of data (CSV/Excel) into the database via the Web GUI. It's not that large as in this (https://community.thinkwisesoftware.com/development-13/best-practice-for-inserting-large-amounts-of-rows-into-one-table-837) thread, but large enough to let the web interface time-out. The problem then is that the import is partially done: It could have imported for example 3k of 50k records. The end-user doesn't know what to do: What part is partially imported? And how to fix it? I'm trying to speed this up, but I can't really increase it's performance. When I take a look at the debugger in de Windows GUI I see a lot of database-calls per row. For each row the default and layout concept are triggered, and the record is inserted per piece. Imagine you want to insert 50k records, and each cycle takes only 5ms, but when it's multiplied with 50k it's 250 seconds. From a user point of view this is absolutely unacceptable (besides it probably crashes in t

4
Erik Brink
Moderator
3 years ago
Ricky
Captain
RickyCaptain
asked in Questions & Conversations

Deployment generation automation

One of our strategic goals is to completing the DEVOPS spirit of working @Acto in an Agile way of thinking. This means that most of the complete development cycle has to be automated DevOps software lifecycle management @ActoCurrently one of our projects is working on automating and speeding up the biggest part of the generation of the deploy package, one could say that these are the steps between Build and Test, which currently takes about 3 to 6 hours for each cycle (without testing, just generating). Our goal is to have several cycles a day if not many more, which of course can only be achieved when (almost) fully automated   We want everything that can be automated to be automated. We want it to run mainly in the background.   It would be helpful if the whole thing could be automated by Thinkwise  – but until then, there are things we can do ourselves, but for certain parts we are unable to automate them in the process of creating a deploy package.   The process consists out

2
Jeroen van den Belt
Administrator
1 year ago
A
Vanguard
AshwiniVanguard
asked in Questions & Conversations

Screen Type

We have to create detailed grid so how can we bind multiple values in that ?

14
Mark Jongeling
Administrator
3 years ago
mperrott
Hero
mperrottHero
asked in Questions & Conversations

Azure SMTP configuration

We have setup the SMTP on our Azure Acceptance env with all the required information, however we fail to send an email from our Azure AD user using the O365 smtp. O365 configuration:SMTP Host: smtp.office365.comSMTP Port: 587SSL Protocol: OFFTLS Protocol: ONIndicium configuration with SSL ON: "Email": {            "TwoFactorEmailMessageService": "TSFSmtpMessageService",            "SmtpServer": "smtp.office365.com",            "SmtpPort": 587,            "UseSSL": true,            "SmtpEnableSsl": "Yes",            "SmtpUsername": "notificationsuat@hartmannship.onmicrosoft.com",            "SmtpPassword": "*******",            "SmtpFrom": "notificationsuat@hartmannship.onmicrosoft.com",              "SmtpFromDisplayName": "UAT Notifications",            "DefaultPasswordResetTemplate": {                  "FromEmail": "notificationsuat@hartmannship.onmicrosoft.com",                  "FromDisplay": "UAT Reset Password",                  "Title": "Password reset token",                  "B

3
Jasper
Administrator
2 years ago
Harm Horstman
Hero
Harm HorstmanHero
posted in Questions & Conversations

Indicium not running, why?

Again we run into problems, because Indicium stopped for some reason.I am quiet sure that everything is set up as mentioned in the documentation. But I am still not sure if all settings that are needed to let Indicium running are set. It would be helpful to have a simple checklist for this in the documentation. Now is it too much fragmented.Any ideas what else can be the reason for Indicium to stop running? In this case the customer has a on-premise configuration, so we cannot make use of Azure to monitor te webservice. For this it would be really a good idea to have the idea @Erwin Ekkel available in the GUI.  As a workaround I am now considering to make system flow that updates a sort of 'heartbeat’ date field in a little application status table and use a task + badge as in indicator when the last 'heartbeat’ is longer than 5 minutes ago. 

20
Harm Horstman
Hero
1 month ago
R
Superhero
René WSuperhero
asked in Questions & Conversations

How to specify accept header in http connector?

I have a http connector in a process flow which communicates with a .net core 3.0 web api. The API can both produce XML and JSON: [HttpPost][Produces("application/xml", new string[] { "application/json" })]public IActionResult Post() If I do a call with no accept headers specified, this API returns the content as application/json. According to the documentation you can add headers to the HTTP connector: [ { "Key": "Accept", "Value": "application/json" } ] or: [ { "Key": "Accept", "Value": "application/xml" } ] To specify the expected result content type, so if XML is required, the last header should be applied. When I add this and execute the http connector it shows me the following message: The 'Accept' header must be modified using the appropriate property or method. Parameter name: name With a stack trace: The 'Accept' header must be modified using the appropriate property or method. Parameter name: name    at System.Net.WebHeaderCollection.ThrowOnRestrictedHeader(String headerNa

2
Roel
Moderator
3 years ago
P
Warrior
PimWarrior
asked in Questions & Conversations

Filtered lookup

Sometimes we want to make a lookup in which you can only pick items that are not already used. Up till now I have been able to come up with three solutions, the first being a view in which the used items are left out, the second being a view in which these items get an 'in-use' flag where a prefilter takes them out of the lookup. Option 1 is not great since it empties the lookup for all saved records Option 2 works much better, but as soon as the user edits the record, the lookup responds by going empty (the selected item is no longer available for selection) Option 3 create a view with a cross join between the source records and the target records, filtered on items that are in use. This allows perfect use with existing records, from them you can pick all available lookup items and keep seeing the selected lookup item. Problem is though that if you create a record the identity is null, now I can make my view include a null value for the key, but then the prefilter checks for

2
P
Warrior
4 years ago
Raj Rozendaal
Sidekick
Raj RozendaalSidekick
asked in Questions & Conversations

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?

8
Erik Brink
Moderator
4 years ago
Dennis van Leeuwen
Hero
Dennis van LeeuwenHero
asked in Questions & Conversations

How do we start Indicium automatically instead of manually?

I have a challenge when it comes to automatically starting the indicium application.  We're working with the Software Factory Version 2021.3 where the Indicium layer is used in the generation process. Correct me if I'm wrong but the message We stopped hearing from Indicium is given when Indicium does not pick up new system flows for at least 60 seconds. This usually means that Indicium is not running anymore and should be reactivated. Scheduled every 30 secondsThis is explainable behavior after rebooting the web server, when the IIS manage server is stopped or when the application pool is stopped or recycled. For all these examples IIS is not automatically starting the indicium application. We should always start Indicium manually by accessing the URL. Indicium will always be accessed by https based on a IIS redirect rule.  When Indicium is running the SF will continue his Generate definition job IIS || Application Pool | Advanced Settings | Start Mode "AlwaysRunnings” | Regular Time I

13
Mark Jongeling
Administrator
1 year ago
P
Sidekick
Peter de WitSidekick
asked in Questions & Conversations

OData null values

I've created a API-routine to collect article-items. The purpose is to use these items to refresh webshop-information by a third party. The following problem occurs: when a description of an article is emptied in the ERP OData seems to skip the field in the output because it is NULL. The third party will not recieve any data so the description in the webshop stays filled. Is there a way to force NULL-fields to be in the API-output without using spaces oslt in empty fields where the third party has to coop with.

10
Hugo Nienhuis
Hero
2 years ago
A
Captain
Andre te RaaCaptain
posted in Questions & Conversations

Is it possible to sum an average in a cube?

In a cube I would like to have the average of columns (e.g. year, quarter, month), totalized in the rows (e.g. group, device). How could I achieve this? 

11
Mark Jongeling
Administrator
17 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: 

18
Erik Brink
Moderator
1 month ago
R
Superhero
René WSuperhero
asked in Questions & Conversations

Inline manual - onboarding users

This topic is kind of a follow up on this topic:https://community.thinkwisesoftware.com/development-13/open-a-screen-first-time-and-ignore-it-the-next-time-1251 Because our application is a bit overwhelming the first time you start it, or the first time you’ll use features / subjects in the application, we want to help the user. We’ve found a tool called “Inline manual”. A video about what it does can be seen here: https://inlinemanual.com/product-demo/. In short you can “walkthrough” a user, show tooltips to help the user etcetera. Easily explain some actions step by step what to do. Simple things how the look-ups work, how you can add records etcetera. First time users really need some help, and that could be perfectly done by such tool. This could be an enormous improvement in “User onboarding”. Please note we only use the Web GUI, and are tempting to use the universal GUI as soon as it is feature complete for us. As we’ve tried to see if it’s interesting for us we’ve encountere

5
Erik Brink
Moderator
2 years ago
Hugo Nienhuis
Hero
Hugo NienhuisHero
asked in Questions & Conversations

nesting level exceeded (limit 32)

I want to set some role rights on a specific table but I keep getting this error: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/298aaba4-58e5-440d-be61-48f3191208b3.png[/img] What is the cause of this error? Or, where do we exceed a limit?

2
Hugo Nienhuis
Hero
4 years ago
P
Sidekick
Peter de WitSidekick
asked in Questions & Conversations

Upgrade SF to 2018.3

Last week we upgrade the SF from 2018.02 to 2018.03 and since then we have trouble with the performance. Our application starts normal but when we choose for the first time a (simple) menu-option the waitingtime is more then 6 minutes before it shows a result. The same after every 'refresh model'. Similar problem occurs when we start the SF itself, if freezes about 15 seconds before we can chosse an option. See the screendumps below [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/80c9780c-4403-4491-abb6-d5122ab614a0.png[/img][img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/c79f50d4-8f3f-412e-ada9-37069d4f03f0.png[/img]

12
Hugo Nienhuis
Hero
3 years ago

Badges

Show all badges
Terms & ConditionsCookie settings