Product updates
Ideas
Groups
E-learning
Documentation
Events

Community
Search

Replies posted by Tim Waalewijn

28 Replies

Newest first

Oldest first

Mark_PlaggenborgVanguard

asked in Questions & Conversations

Multiple Indicium instances on same "product"

Dear Mark,To explicitly prevent an Indicium from taking on background work as specified by the IAM in connects to, such as system flows, you can set the Agent setting in the appsettings to false as described here:https://docs.thinkwisesoftware.com/docs/deployment/indicium_configuration#disable-background-operations{ "Agent": { // Skip registering this Indicium instance as an agent on IAM. // Also disables adding all agent related services such as the scheduled system flow runner. "Enabled": false }}Do note that only one Indicium at a time will be receiving system flow schedules from IAM. So if you, for example, disabled the agent service on the Indicium that the Universal GUI connects to and then have two others that could both process system flows only one of them will be doing so. Of course if that Indicium were to go down somehow the other one would then take over.I hope this answers your question.

kensonlatchmansingVanguard

asked in Questions & Conversations

SSRS Server Report Variants

@kensonlatchmansing Sorry it took a while to find some time to try and test the scenario you've described above.Unfortunately, I also could not find a way to use the pool user of an App Service Indicium in combination with a SSRS server. A Power BI server could probably make it work when using a managed identity on the App Service but I did not test this since the Thinkwise Platform currently does not support Power BI as a report type.Setting the MetaSourceConnection:Username/Userpassword options instead also will not work since the code only seems to override the credentials on each dataset in the report and not the credentials used to authenticate with the SSRS server itself.So, for the described scenario, the platform would probably need to support configuring a location + credentials of a SSRS server in the model itself. Like how file storage locations etc. can be provided.This is just a thought since I don't know how complicated the reports are but if they only differ in styling b

kensonlatchmansingVanguard

asked in Questions & Conversations

SSRS Server Report Variants

The error mentions that the request was unauthorized which indicates the user identity that Indicium is running as does not have access to the SSRS reporting server.If you are running Indicium on IIS this corresponds to the application pool user that was set.Have a look at https://learn.microsoft.com/en-us/sql/reporting-services/security/authentication-with-the-report-server?view=sql-server-ver15#authentication-types for some more information about SSRS server authentication types.By default it is set to RSWindowsNegotiate and RSWindowsNTLM which is why the current user of Indicium is used. RSWindowsKerberos would probably work as well but requires more setup. The other two (RSWindowsBasic/Custom) are currently not supported.Another thing to consider is that credentials for data sources might be overwritten by the user credentials set in Indicium’s MetaSourceConnection or via the pool user credentials that can be set per application since 2023.1: https://docs.thinkwisesoftware.com/blog

kensonlatchmansingVanguard

asked in Questions & Conversations

SSRS Server Report Variants

Hey,I would not recommend modifying any IAM tables, that aren’t accessible through the UI, via post-sync scripts etc.Can you provide some more information about how you envisioned setting this up for different clients? E.g. is this the development environment and are you using a single reporting server for convenience or is it meant to work this way in production as well. Are clients separated by different IAMs or by applications inside the same IAM etc.I think there used to be a way to change the path of the report being executed through binding a parameter to one of the selectable properties but I know that at least Indicium dropped support for that when all the “local” report types ended up in its file cache because you have to upload the report file itself to the model in the SF these days.I guess for SSRS reports managed by a server this could still be a valid use case since Indicium doesn’t manage the report files by itself but as I said that doesn’t work at the moment so it woul

timApprentice

asked in Questions & Conversations

DevExpress Resolution

Hi Tim.Unfortunately there is currently no way to customize this through the procedures that the reporting service uses to retrieve queued reports from the database.The reporting service is also considered to be in maintenance mode with regards to support so I also cannot say we’ll be adding support to do it this way.The only alternative I can think of right now would be to change the default resolution inside the image export properties of the report itself. Which can be found at Report properties → Behavior → Export Options → Image Export Options.Image Export Options → ResolutionThe reporting service doesn’t modify any of these settings so they will be used as is. Do however note that changing Export Mode and Format might lead to funky behavior since the service kind of expects that you are exporting to a single file PNG when exporting to an image.

Harm HorstmanSuperhero

posted in Questions & Conversations

Indicium not running, why?

Just to add to the conversation, you can use PerfView to capture the application initialization request that IIS sends to Indicium if every IIS setting has been set correctly. Which, looking at the screenshots, they appear to be.That way you can see if the request is actually being sent after the application pool has been (re)started and, if it is, you should be able to see if the response contains an error status code instead of the root page of Indicium.Please check the answer to the following post if you need an example on how to use PerfView to capture IIS traffic.

kensonlatchmansingVanguard

asked in Questions & Conversations

SSRS Server Report

Hey,For SSRS (server) reports you will have to add the URL to the reporting server through an extended property called ssrsreportserver in your application’s runtime configuration.The path field when adding the report to the Software Factory should be the relative path to the report on the server.https://docs.thinkwisesoftware.com/docs/sf/reports#ssrs-serverJust in case since you also tagged your post with “reporting service”, the same rules apply there except the ssrsreportserver value should be added to the appsettings.json file instead.

Sandro BurgerRookie

asked in Questions & Conversations

Reporting service connection error for Crystal Report

Hi Sandro,Looking at the log you’ve posted I can see that you are not running version 5 of the reporting service. It might not fix the issue you are having but I do advise you upgrade to that from whatever version you are running now because any bug fixes will not be back ported to older versions. Please have a look at https://docs.thinkwisesoftware.com/docs/kb/report_service#upgrading-from-v4-or-v3-to-v5 and the rest of that documentation page for assistance on how to upgrade.Regarding the actual issue, the log states that opening a connection failed for data source name “Leverancierscode database: 4060” of the report. The reporting service overrides the server/database name and credentials to use for the data source to match the information inside the connection string used to poll for reports to process.Given that the polling is working I do not suspect there is a problem with the credentials themselves. Having said that, Crystal Reports does end up making its own connection to the

wboelaarsRookie

asked in Questions & Conversations

Deployment Package previous version (2023.1)

Hello,By default the Software Factory selects the previous version automatically.This can be changed using the following task: Data → Data migration → Set source for data migration and upgrade.Set source for data migration and upgrade taskI do not know the specifics about how the automatic selection works but I would guess it is selecting a point in time without a name/description.This is probably a bug so I would like to ask you to please create a support ticket for this issue in TCP.

Kasper ReijndersPartner

Deployment center install option to skip database provisioningCompleted

Hey @Kasper Reijnders ,Looking at some of your other posts I assume you are running the platform on Azure?If so, I take it that the problem you are having is that the create script always creates databases in the same tier and you would rather create an empty database with the correct tier beforehand. Version 3.1.0 of the deployment center, which will be available in TCP somewhere next week, will allow you to do this by allowing installation to be performed on the empty database. It will skip that specific script in this case.Otherwise, if this idea is more about a way to skip any script like you can do in the Software Factory itself, I cannot say if or when such a feature would become available. We consider scripts in the deployment package to be “final” in the sense that they would be deployed to production environments. In my opinion it would not make sense to skip e.g. the script that applies task procedures to the database in that situation.

asked in Questions & Conversations

What is prockees(.exe)

Hey Ricky.TLDR; Indicium uses that prockees process to run code for certain features that have dependencies that cannot be run/loaded in the main process. The main example being (most) types of reports. Since the prockees process is a child of the Indicium process it should always shutdown when Indicium itself is shutdown. Indicium is currently built to run on .NET 6. The following features have dependencies on libraries that only work on .NET Framework 4.X:Crystal Reports SSRS DevExpress reports (not entirely true anymore since release 2022.2.15.0 but it still is with the default settings on Windows) Accessing DB2 databases with the old iSeries driver The print pdf action in process flowsTo make it possible to use these features Indicium spawns a child/worker process (prockees) which takes care of loading the needed libraries for the feature and then sets up some channels so Indicium can make IPC calls to it. The files for all this can be found in the “plugin” directory of the Indiciu

Sjors NiestenApprentice

Release notes Indicium 2022.2.15release notes

Regarding DevExpress: what would you recommend for Windows (.NET 6 or .NET Framework) and what is the impact? TL;DR: There might be a small performance gain with slightly increased memory usage when using the .NET 6 plugin on Windows. The gains are small enough that I would just keep on using the (default) .NET Framework version for now. They perform roughly the same at the moment.Some more details about what we encountered while implementing the feature itself:DevExpress uses System.Drawing.Common to render the reports. System.Drawing.Common is meant to work with GDI+ which is a Windows component. This is why you need to install the extra dependencies, including libgdiplus, on Linux. In addition to that their cross platform renderer requires Pango (libpango) for things like text measurements. In .NET 6 System.Drawing.Common has started to throw exceptions when used on platforms other than Windows. Because, again, it depends on a Windows component. To get around this DevExpress advise

JHarkeRookie

asked in Questions & Conversations

Printing via Thinkwize reporting service and not via webserver?

Hello JHarke,For some reason I cannot see the image you have attached so I do not know how much extra information it adds about your situation to your question.Unfortunately it is not possible to make the reporting service print files that have already been exported. This is because the service assumes it will always have to generate the report before exporting or printing it. So unless the service can also be used in the process to handle the generation step of the packing lists you will not be able to use it for printing.Also unfortunately, we will not be adding new features to the service so using it to print files without loading and generating the report first will not be possible.If you absolutely cannot install the printer on the web server or generate the packing lists using the reporting service, I think the best option for the short term would be to build something yourself. Maybe take a look at the architecture of the reporting service for some inspiration: https://docs.thin

Erwin EkkelModerator

Add Licensing access test to indicium deployerOpen

Hey Erwin (and up-voters),Just checking but I assume rather than just a check to see if the licensing service is reachable you would probably want to be able to configure what is explained in https://docs.thinkwisesoftware.com/docs/deployment/indicium#internet-proxy as well?Since being behind a proxy is currently the most commonly encountered cause for not being able to call the service.

Diana KuipersModerator

Release notes Thinkwise Deployment Center (2.0.0)release notes

@Arie V Could you open a ticket for this in TCP?I am currently occupied working on other products and I’d probably forget your suggestion if it is left on this blog post.I agree that the order for the synchronization flow could probably be reversed.Skipping the screen might be more difficult since the deployer currently cannot know if your application uses the mentioned template variable in the post sync scripts.I am still trying to figure out some kind of sync package type for the manifest so you would be able to specify which template/parameter values are being used by the application. This could take a long while though since it might introduce some breaking changes to the manifest and likely impacts the SF team as well.Alternatively for the short term we could either:Add a setting to the twdeployerGUI settings file to always skip this screen if the product type is Application. But then you would have to make sure none of your post-sync scripts use the current db_name template. Auto

Diana KuipersModerator

Release notes Thinkwise Deployment Center (2.0.0)release notes

@Arie V The settings file uses JSON which defines backslash as the escape character in strings etc.So your example should work if you use C:\\Data. The same issue is probably why your network share path did not work if you were defining it using a UNC path since it would need to be set as \\\\share_name\\share_folder.The file picker seems to fall back onto default behavior of using the last directory you’ve selected a file in on the computer if it thinks the directory does not exist.I would also have expected that C:/Data should work but it appears the file picker control disagrees. It might be because it is a wrapper around the native windows file picker which maybe does not support forward-slash as the path separator for this property but I have not investigated if that is true.

Diana KuipersModerator

Release notes Thinkwise Deployment Center (2.0.0)release notes

@Arie V I do not know why there has not been a blog about it yet. I wrote the initial draft for the 2.0.0 release myself because so much had changed in the version but another team usually handles the creation of release note blog posts.I will contact them about it next week, perhaps there has been some miscommunication between them and me about who handles these things for the deployer.On a side note, I just released version 2.2.0 to TCP which contains a new settings file for twdeployerGUI. You can use that file to set the --manifest-selection-dir now as well as some other settings such as the default host/username for database connections.So you might want to check that version out instead.

Randolph BeekmanVanguard

asked in Questions & Conversations

Redundant Reporting Service

Hello Randolph. I would advise taking a look at the documentation for the reporting service if you have not done so already: https://docs.thinkwisesoftware.com/docs/kb/report_serviceSpecifically the architecture section https://docs.thinkwisesoftware.com/docs/kb/report_service#architecture .Basically, the service calls a couple of stored procedures to get information about which report records it must perform from the queue.The first one of which is “rpt_get_reports” https://docs.thinkwisesoftware.com/docs/kb/report_service#rpt_get_reports .The implementation of these stored procedures is usually left up to the developer so I cannot say how it has been implemented in your project.Having more than one service use the same report queue records is not recommended since there is no locking mechanism between them. This can cause the same report being generated more than once.However, the names of these procedures can be changed for a specific reporting service by modifying the configuration

Dennis van LeeuwenHero

asked in Questions & Conversations

How do we start Indicium automatically instead of manually?

The only thing I can think of right now is that app init requests are always sent using localhost as the host, while your binding is specifically set to your domain.So maybe that is why it is not going through.That is merely a guess though and I cannot remember that being a requirement for getting it to work. The servers I tested with last year were fine with not even having a http binding at all.Looking at your screenshots everything else seems correct as well.Try logging the request using PerfView and see what response (if any) you are getting back.Here is a good blog post detailing how to do that if you need help: https://www.stefangeiger.ch/2021/05/05/iis-application-initialization-troubleshooting.html

Diana KuipersModerator

Release notes Thinkwise Deployment Center (2.0.0)release notes

To be clear: is this a limitation to any Post synchronization code used already (meaning the script can only target the IAM database)?The post-sync code/scripts are being run in the same step as the sync code/script itself (basically any script found in the MetaModel directory) so unless we establish some kind of standard to run scripts on another database you are indeed currently limited to having them target the IAM database you have selected to sync to.Keep the existing behavior of the current twdeployerGUI.exe, unless specified otherwise. Then allow for setting a folder and/or a Manifest.json. In our case we would set it to below, so it always opens the root folder and never the location with the last used Manifest.json I have quickly/temporarily added this to the next release as follows:twdeployerGUI.exe --manifest-selection-dir "D:/Deployment Packages"It will probably not be mentioned in the release blog since I am not sure if I want to keep supporting it like this. I made an is

Diana KuipersModerator

Release notes Thinkwise Deployment Center (2.0.0)release notes

Hi @Arie V.Thank you for sharing your experiences/feedback about the deployer.I understand that 2022.1 Thinkwise Platform release is planned for end of the month, when can a new Thinkwise Deployment Center version be expected?I am not sure I will be able to get the next deployer version out by the end of the month but if not then it should be released in early February.I do not think I will be able to get every point stated in the blog post into the release but skipping the model import during an install/upgrade and the separate import model deployment option are almost done.There will be a minor limitation in that you will not be able to use any other variables in the post-sync code that the IAM/SF/Upcycler scripts do not already do. This means for this release you will only be able to modify the <@db_name,,> template string. I am still thinking how this can be made more flexible for use with custom applications. This will probably require some changes/additions to the manifest

Hugo NienhuisSuperhero

asked in Questions & Conversations

Passing parameters to DevExpress with Reportingservice

Hey Hugo, Assuming you didn’t change anything to the logging section inside the appsettings.json file you should have seen confirmation messages being logged that the database is being polled.E.g. something similar to the image below:You’re saying that nothing happened after you restarted the executable.Does that also mean the command line window does not stay open like in the example above?If so try starting it from an opened cmd or powershell prompt and see if the program exits immediately with an error.If nothing shows up there might be an issue with the settings in the configuration file, possibly/probably somewhere in the Logging section.

Hugo NienhuisSuperhero

asked in Questions & Conversations

Passing parameters to DevExpress with Reportingservice

Hey everyone,Just letting you know we've confirmed this issue happened when using a stored procedure as the data source for the report.Updating the DevExpress libraries seemed to fix it on our end but in doing so we had to update the .NET Framework version requirements to a version higher than 4.5.In the end we determined the best choice would be to update all the way to the last version of .NET Framework 4.x which is 4.8.Doing so also caused a bunch of other cascading work that needed to be done of which the TLDR; version is:Updated to .NET Framework 4.8. Installer project refused to work after the update so that is gone now. Instead of a ReportingConsole.exe and ReportingService.exe only ReportingService.exe is left. To run ReportingService.exe as a Windows service one must now use sc.exe. NLog had to be replaced with another logging library. All settings, including logging, are now contained in an appsettings file similar to the one that Indicium uses.We are still working on updatin

BlommetjePartner

asked in Questions & Conversations

icons in web gui via Azure - issue with new SF version

Hi Blommetje,Azure App Services by default uses an application pool with the identity set to ApplicationPoolIdentity. Which means you will indeed not have an actual user profile without setting Load User Profile to true.To reiterate my answer on a similar question about IndiciumAccording to the Kudu wiki (https://github.com/projectkudu/kudu/wiki/Configurable-settings#add-user-profile-support-for-a-site) this can be achieved by adding a WEBSITE_LOAD_USER_PROFILE app setting to your Azure app and setting it to 1.As stated in the wiki link this will only work for apps running in a Basic, Standard or Premium tier so make sure you are using one of those. You should be able to set this in the configuration section of your Azure app before uploading the Web GUI:

René WSuperhero

asked in Questions & Conversations

Indicium not starting on Azure

Hi René,Going by that stack trace you’ve posted Indicium seems to have detected an OpenID configuration inside your IAM test database.When this happens Indicium tries to load/create a certificate, from the user profile of the user that the application pool on IIS is running on, to sign tokens with.The problem is that when the IIS application pool uses ApplicationPoolIdentity, which is the case on Azure App Services, there is no actual user profile unless the “Load user profile” option is set to true in the pool settings.According to the Kudu wiki (https://github.com/projectkudu/kudu/wiki/Configurable-settings#add-user-profile-support-for-a-site) this can be achieved by adding a WEBSITE_LOAD_USER_PROFILE app setting to your Azure app and setting it to 1.As stated in the wiki link this will only work for apps running in a Basic, Standard or Premium tier so make sure you are using one of those.Alternatively you could of course also remove the OpenID configuration from the test IAM databas

1
2

Page 1 / 2

Badges

Robert Wijn 2has earned the badge Adapter
Guido Bijlhas earned the badge Adapter
Dave Bieleveld Starcodehas earned the badge Critical Thinker
Theo Neeskenshas earned the badge Critical Thinker
Niels Koophas earned the badge Geek

Show all badges

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login

Login to the Thinkwise Software Community

Login

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK