Questions & Conversations

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

2,069 Topics
7,086 Replies

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 13.0.13.1597. 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?

4 years ago

Randolph BeekmanVanguard

asked in Questions & Conversations

Example REST API Multipart Form using msxml2.xmlhttp

Hello all,Does anyone have an example of an t-sql request against a REST API with a Multidata/Form? We already call several REST APIs, but not with Multidata/form. Below is a setup (which does not work). The API converts a PDF document into fields in json format. It contains 2 fields that must be included:name (name of the document) document (base64 encoded string)Below is a first attempt, but it does not work :-). Thanks in advance for the reactions.declare @response table (txt nvarchar(max)); declare @object int , @url_endpoint nvarchar(200) , @response_format nvarchar(5) , @request nvarchar(250) , @json nvarchar(max) , @address address , @body varchar(max) , @status int , @d

1 year ago

JasperAdministrator

published in Questions & Conversations

Multirow task execution

When executing a task for a selection of rows, the user interface first executes the context procedure for every single row to check if the user is allowed to execute the task for that row, and then executes the task for each permitted row. This can be quite time consuming, especially for web clients where the progress is also reported back to the client.To speed up multirow task execution, a new feature has been developed to execute tasks for a selection of rows.To enable multirow execution for a task:Add an XML-typed parameter to the task Make sure Popup for each row is switched off Set the MultiselectParameterID extended property with the name of the parameterWith multirow execution enabled for a task, when the user interface executes the task, the specified XML parameter is filled with the parameter values for all rows. Even if only one row is selected.The parameter is only filled when the task is executed. The XML is therefore not visible in the popup or available in the default a

196834

9 months ago

htimmermansVanguard

asked in Questions & Conversations

A certificate is required to complete client authentication

I'm trying to get a response from a webservice, located outside our organisation. The site is secure (https), but other than that, the piece of code (dbo.make_soap_http_request in this case) is doing the trick on an internal webservice (http, not secure, Navision webservice).The parameters (url, username, password etc etc) used when executing the instruction below work fine when executed from my or another desktop (no special certificates installed by our IT department) when using SOAP-UI for example).Parameter @http_uri below contains an URL to a secure (https) site. exec dbo.make_soap_http_request @http_uri , @http_request_method , @soap_request_body , 'http://gateway.integration.volvo.com/soap/1_0/WsMqServices/processMessageRequest' , @username , @password

3 years ago

RenéRookie

asked in Questions & Conversations

Crystal Reports export to Excel: adjust column width

With the report mailer function we export a Crystal Reports report to an Excel document. This doesn’t automatically set the column width correctly (see image below). Is it possible to change this? [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/f29957a2-cb0a-420d-aa98-b375cfc4784b.png[/img]

4 years ago

Mark JongelingCommunity manager

asked in Questions & Conversations

Best practice for inserting large amounts of rows into one table

/-This is more of a SQL question-/For the project I work on I'm in charge of realizing functionality to import large amounts of Product data (ASCII format / .txt file data). The database I work with is placed in a environment where multiple companies work on the same database. In the application, they only see their own data. For example, if 30 companies use the database and all have a pool of 1 million Products, then the 'Product’ table will have 30 million records in total but will only see their own 1 million products.The data that I will import consists possibly over a million records and will be inserted into the single ‘Product’ table. What I'm worried about is that inserting 1 million products in one go will take a very long time, so I want to look at possible ways to accelerate this process and making sure that importing big files does not take hours.I have read about removing indexes, parallel processes and such to speed up the process but I'm not fully convinced it would be t

3 years ago

Eric FrankenSidekick

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.

4 years ago

René WSuperhero

asked in Questions & Conversations

HTTP connector results into 411 - Length Required

I'm trying to convert a XML document with binary data to a zip-file via a self developed .NET Core 2.1 Web API using a process flow with a http connector. It's a follow up on this topic: [url=https://community.thinkwisesoftware.com/deployment-12/moving-to-azure-sql-database-azure-file-storage-713#post2018]https://community.thinkwisesoftware.com/deployment-12/moving-to-azure-sql-database-azure-file-storage-713#post2018[/url] When testing the POST call via Postman and a simple .NET console application I receive the result as expected. When using the process flow using a http connector, it returns an error in the SF-Debugger: The remote server returned an error: (411) Length Required. This could indicate the Content-Length header must be applied, so I did: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/1b54ac17-2d46-4aed-9add-fb03067047bc.png[/img] (Please note this is a fixed length, because the Content is also fixed value for now.) Unfortunately this results in a

3 years ago

FreddyThinkwise Local Partner Brasil

asked in Questions & Conversations

Executing API 'CreateFile' failed with error number 32.

Does anybody know a good way to catch and prevent the error, when a file for some reason is locked for reading and processing? Executing API 'CreateFile' failed with error number 32. Error code 32 is ERROR_SHARING_VIOLATION . So the mailer cannot read the attachment file because something else is reading it. Besides the fact that you cannot really reproduce it until it happens, I cannot really find a way to catch this error upfront. I am using the file_exists function to check upfront if all documents exists, and even though all attachments can be found, at the time of sending the mail at occasions you get this error. The only solution I can think of now is to set the AccountRetryAttempts to 2 times to tackle this problem. But it's not the fanciest solution, anyone has experiences with this?

3 years ago

Rianne WeideRookie

asked in Questions & Conversations

Requirement status

What is the use of the status for requirements? At this point the status of a requirement is always new and does not change during the whole project. It would be nice to have statusses like: [list] [*]In progress - requirement is being worked on. [*]Approved - The key stakeholder has agreed to the requirement and the developer has agreed that it is possible to create [*]Implemented - Code has been designed and is ready for review [*]Verified - The requirement is tested and is functioning correctly [*]Deleted - An approved requirement is deleted. An explanation is needed of why and by whom the decision was made to delete it. [*]Rejected - The requirement is not approved. The why and by whom it has been rejected is relevant. [*]Deprecated - The requirement is no longer in use and has been replaced by a new requirement. [/list] It should also be possible to filter out all of the requirements based upon the status. This way you can always refer to a certain requirement

4 years ago

René WSuperhero

asked in Questions & Conversations

Consume OData API via .NET Core

I'm trying to use the Indicium OData API via a .NET Core 3.0 console application. I receive an exception on inserting records, while the record is inserted in the database. I have no clue why. I'm not sure if this is an issue in the Indicium OData API or the .NET nuget package. For example I want to add a ‘server’ to the IAM database. By using a generated piece of code (see https://docs.microsoft.com/nl-nl/odata/client/basic-crud-operations) this is quite easy to set up; Add the indicium OData API via “Unchase OData Connected Service” Configure the metadata ($metadata.xml is the result of http://server/indicium/iam/iam/$metadata)With the following code you retrieve the ‘server’ table and insert a new record in to it: using SQLSERVER_IAM;using System;using System.Net;namespace IndiciumTest{ class Program { static void Main(string[] args) { var uri = new Uri("http://server/indicium/iam/iam"); var container = new Container(uri); container.Credentials = new NetworkCredential("userName", "p

3 years ago

René WSuperhero

asked in Questions & Conversations

HTTP Error 500.19 - Internal Server Error running Universal GUI caused by setting requestFiltering removeServerHeader="true"

Since some versions we have a problem with the Universal GUI after updating. The setting "requestFiltering removeServerHeader = true" in the web.config file causes a 500.19 HTTP error when starting the Universal GUI.If we remove the lines below from web.config, the problem is gone. <security> <requestFiltering removeServerHeader = "true" /> </security> The problem is also present with the most recent update.

2 years ago

rbiramCaptain

posted in Questions & Conversations

Powering the Thinkwise Platform with AI 🤖

Hi, everyone!If you've been keeping a close eye on the news recently, you might have noticed that AI and Large Language Models (LLMs) such as ChatGPT are making big waves. They're popping up everywhere, becoming integral parts of countless processes and applications, and for a good reason. The potential of AI is immense, and here at Incentro, we're beyond excited to explore it!In our journey to explore the power of AI, we've brainstormed countless ways to implement it within the Thinkwise platform. We've thought of various use cases, and today, we're excited to showcase one of them.Introducing TW-GPT, an application that uses the power of AI to take the Software Factory to new heights. This application incorporates a standout feature - the ability to autonomously generate descriptions for different entities within the Software Factory that currently lack descriptions.Control procedures and tables can sometimes be a mystery to those unfamiliar with them. They're crucial components of ou

2 months ago

Mark JongelingCommunity manager

posted in Questions & Conversations

Autonomously generate report and send it by e-mail

This is an Archived topic. The solution is available in the Thinkstore inside the Software Factory.GoalBased on a customer story.Every day at 06:45 a procedure runs for the customer and during that procedure, errors can occur. These errors are recorded inside the application and viewed by one particular user. This user only opens the application to look at these errors. If there are no errors at all, the user still has to look inside the application to find out. It would be more handy if the user gets an e-mail with a Report of all the errors. SolutionBy using the System Flow functionality, we can autonomously let Indicium take care of generating a Report and sending it to the user by e-mail.In this example I will show you what is needed to achieve this.Prerequisites:Indicium (Universal) - hereafter called Indicium Application in IAM SMTP server for sending the e-mail - this example uses a free SMTP server by sendinblueChaptersCreate a View in the Software Factory Create a DevExpress R

1 year ago

BasVanguard

asked in Questions & Conversations

Max file upload vs Max request body size - Azure Application Gateway

Hi there,we're running into a azure application gateway issue. We have an application where we can trigger a task on a record. In this task we upload an asset. The issue is that we can only upload files that are smaller then 128Kb. Between us and the application in a Azure Application Gateway. This application gateway has a policy that enables inspection of the request body. The MAX REQUEST BODY SIZE is set to 128Kb. The MAX FILE UPLOAD SIZE is set to 100Mb.Is seems that since Universal uses odata to communicate to indicium the file upload is parsed into the request body and thereby is limited to 128Kb in size. The clients IT department forwarded the following documentation that indicates the max request body size limit is 2Mb on the WAF.The other solution they suggested was changing the content-type to multipart/form-data. That way the file upload size limit of 100Mb would be applied. As we're using universal this isn't possible.Any other suggestions because needing to limit the file

6 months ago

Arie VSuperhero

posted in Questions & Conversations

User Experience Universal GUI - Votes collector topic

We have been live in Production with the Universal GUI since November 2020. During the past few years the functionality of the Universal GUI has been massively improved by Thinkwise. In the meantime we as Thinkwise customer have learned a lot from our end users regarding their User Experience with the Universal GUI. Based on our experience, we believe the UX can and should be improved a lot by Thinkwise!And since @Jasper promised in the Release Event 2023.1 that Community Ideas will be prioritized more, I would like to use this post to list the most important UX improvements and gather a crowd of votes from all of you at the Community!I really expect the below Ideas to improve the UX for all Thinkwise customers' end users. Please vote on each Idea listed below that you believe serves your needs too and add a comment below to keep the topic ‘alive’!And since this list is nowhere near exhaustive, feel free to add additional Ideas in the comments below! NOTE: this is topic is specifically

4 months ago

Frank Wijnhout

posted in Questions & Conversations

Make your logging data available in the GUI

This is an Archived topic. The solution is available in the Thinkstore inside the Software Factory.GoalWhen you have system versioned tables in your database, SQL Server logs all changes made to the data in those tables. This solution makes this logging data available for the user. This can look like this: SolutionThe solution in this topic creates views on all system-versioned tables. These views give the user access to the logging data. Also, all of these views get conditional layouts in the Software Factory. These conditional layouts give fields with changed values a color, which makes it easier to analyze the data.Dynamic model meta_view_historyThis code create a view definition for every system versioned table, along with conditional layouts to point out changed data.When you add this code to the dynamic model, you have to change a few values first:@screen_type_id Your desired screen type: You can keep this null, or change the value.@original_date_column Na

1 year ago

mehmet kayaRookie

asked in Questions & Conversations

An explicit DROP INDEX is not allowed on index

I created a unique index and I deployed my project. When I try to delete this index I am getting“An explicit DROP INDEX is not allowed on index ‘ sales_person.unique_sales_person’ . It is being used for FOREING KEY constraint enforcement.”error message.I tried to clean install but it didn’t work. It is in software factory version 2022.1How can I solve this?

1 year ago

Rolf GoossenSidekick

asked in Questions & Conversations

Redirect URI for connection with Exact Online

How to set up an API connection using the OAuth 2.0 with Exact Online?This resource was a good starting point.I can’t find a way to use a valid “redirect URI” in the SF.Any suggestions?

1 year ago

K.BakkenesCaptain

asked in Questions & Conversations

Assemblies for deployment

We have a number of assemblies configured on the current development environment. These assemblies need to be passed on to every development/demo/customer/production environment. Last week we've added the assembly HttpConnector to our current development environment. This assembly was also needed in the multiple demo/customer/production environments. It appears that this assembly wasn't automatically created on the different environments. Whichresulted in errors in a customer/production environment. Besides the above assembly we also have more assemblies that need to be passed on to every environment: [list=1] [*]SQLTCPExhItemSender [*]HttpConnector [*]Newtonsoft.Json [*]System_Runtime_Serialization [/list] Is it possible to configure these assemblies to be part of a deployment process? It also raises the following questions: [list] [*]How do we make the assemblies part of the deployment process and prevent manual work? [*]How do we maintain the original .dll files?

4 years ago

René WSuperhero

posted in Questions & Conversations

The specified CGI application encountered an error and the server terminated the process - HTTP Error 502.5

This morning when I tried to reach out an application using the OpenID provider, Indicium 2021.1.16 - hosted on Azure - suddenly crashed. The first message I received was:The specified CGI application encountered an error and the server terminated the process.I refreshed the browser and then I got the following error:HTTP Error 502.5 - ANCM Out-Of-Process Startup FailureCommon solutions to this issue:The application process failed to startThe application process started but then stoppedThe application process started but failed to listen on the configured portTroubleshooting steps:Check the system event log for error messagesEnable logging the application process' stdout messagesAttach a debugger to the application process and inspectFor more information visit: https://go.microsoft.com/fwlink/?LinkID=808681Then I refreshed again and it worked again.In the logs I can only find the following lines which probably have to do something with it:2021-03-09T08:25:54.2547150+00:00 [FTL] Unable

2 years ago

Harm HorstmanSuperhero

posted in Questions & Conversations

Use images in Azure file storage on SSRS reports

Has anyone found a solution to show images, which are stored in Azure file storage, in a SSRS report?SSRS = SQL Server Reporting Services

1 year ago

Page 1 / 83

Questions & Conversations

2069 Topics

The type initializer for 'CrystalDecisions.CrystalReports.Engine.ReportDocument' threw an exception

Example REST API Multipart Form using msxml2.xmlhttp

Multirow task execution

A certificate is required to complete client authentication

Crystal Reports export to Excel: adjust column width

Best practice for inserting large amounts of rows into one table

Export to xlsx in reporting service (crystal report)

HTTP connector results into 411 - Length Required

Executing API 'CreateFile' failed with error number 32.

Requirement status

Consume OData API via .NET Core

Logs folder on Azure app service

Http connector Exact online

What's the difference between the data types ROWGUID and UNIQUEIDENTIFIER

HTTP Error 500.19 - Internal Server Error running Universal GUI caused by setting requestFiltering removeServerHeader="true"

Powering the Thinkwise Platform with AI 🤖

Autonomously generate report and send it by e-mail

Max file upload vs Max request body size - Azure Application Gateway

User Experience Universal GUI - Votes collector topic

Make your logging data available in the GUI

An explicit DROP INDEX is not allowed on index

Redirect URI for connection with Exact Online

Assemblies for deployment

The specified CGI application encountered an error and the server terminated the process - HTTP Error 502.5

Use images in Azure file storage on SSRS reports

Badges

Questions & Conversations

Badges

Sign up

Login to the Thinkwise Software Community

Scanning file for viruses.

This file cannot be downloaded