Questions & Conversations

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

1,802 Topics
6,202 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?

3 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

11 months 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

180034

3 months ago

RenéRookie

asked in Questions & Conversations

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

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

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

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

René WSuperhero

asked in Questions & Conversations

Logs folder on Azure app service

I have the web gui on an Azure App Service. But I notice the “Logs” folder isn't created, and if it exists the files aren't placed there. I use this ini settings: Server = server.database.windows.netDatabase = iam-databaseRuntimeConfiguration = RDBMS = SQLSERVERMetasource = IAMLanguage = engAuthentication = rdbmsExecutionmode = developerCSVLogging = TrueLogToFile = Yes When I copy the GUI folder with the same ini to a local IIS application it does create the folder and a Debug.log on start-up. Do I have to do a bit more on Azure, or am I looking at a bug?

2 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

3 years ago

Marc FerketCaptain

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

Edwin SaanSidekick

asked in Questions & Conversations

Http connector Exact online

I’ve maganged to setup the connection to the Exact Online API from postman.Now I try to setup the connection from the SF but we running into an invalid_request error as a result.I’ve used the same input variables and keys, so at the moment I’ve not a clue why this result is happening: Has anybody in the community succesfully connected to the Exact Online API.

1 year ago

Roy van UffelenCaptain

posted in Questions & Conversations

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

When creating a domain you must choose the data type. In this case I want to create a Global Unique Identifier (GUID). Clicking on the data type lookup I am able to see more details for each data type (figure sorted by type).In this list there are two Data types of Type “Guid”.First question is what is the difference between these Data types?Also what is the meaning of each attribute? And in particular does Calculated mean that columns of this type will not be stored in the database?

2 years 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

8 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

7 months 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?

3 years ago

René WSuperhero

asked in Questions & Conversations

Moving to Azure SQL database & Azure File Storage

I'm trying to move our product to the Cloud using this blog post: [url=https://community.thinkwisesoftware.com/blogs-21/to-the-cloud-leveraging-microsoft-azure-paas-155]https://community.thinkwisesoftware.com/blogs-21/to-the-cloud-leveraging-microsoft-azure-paas-155[/url]. I'm facing some difficulties regarding the differences between an on-premise environment (SQL Server and a file system) and Azure (Azure SQL Database and Azure File Storage). To start with, it's the difference in handling files. In the on-premise setting I'm able to upload files and read them using methods in SQL Server like xp_DirTree for reading a directory, and openrowset / bulk insert reading the contents of the file. In an Azure environment this isn't possible. Lets say the steps for the end user are currently as following: [list=1] [*]The user starts a task where it can upload a file using a 'File upload' control. This upload is bound to an Azure File Storage location, so it'll upload immediately. [*]The use

3 years 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

Frank Wijnhout

posted in Questions & Conversations

Trace your changes by adding trace fields

This is an Archived topic. The solution is available in the Thinkstore inside the Software Factory.GoalThe goal of this solution is to automatically add trace fields to all tables so the user can see who added the record or who made the last change. This solution adds these fields to a separate tab page on a form. This looks like this in the GUI: You can choose at what moment you want the fields to be filled: During editing or after saving the record.SolutionThe solution consists of code for Dynamic Model (for adding the fields) and two Control Procedures (for filling the fields). Depending on the moment you want the fields to be filled (during editing or after saving), you can choose either for a control procedure for defaults or for a control procedure for triggers.Dynamic model add_trace_columnsThis code adds trace columns to every table.The trace fields are: update_user update_date_time insert_user insert_date_time If you add the tag 'no_trace' to a table, no trace columns

1 year 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

1 month 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

RonyApprentice

asked in Questions & Conversations

Resource Scheduler & Extender

This is going to be a lengthy post about the Resource Scheduler extender. Instead of making a couple of threads, I’ve bundled all questions we have regarding the resource scheduler into one. [h3][b]Extender properties[/b][/h3] Let’s start with the extender properties of the resource scheduler. In addition to the extensive amount of properties you’re presented with, the description of said properties leaves a lot to be desired. Most of the time there’s little to nothing added to make clear what a certain property really does or how to properly set up one. For example: [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/9f645efa-a3f3-4f1f-a866-6a58824adeff.jpg[/img] As you can see the value type of the ‘Days’ property is Int. But if I, let’s say, enter 5 as a value and refresh my model I get the following warning. [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/8a8acf96-7e1f-46e1-9e58-9ff821e3cef5.jpg[/img] That leaves me with a lot of questions as

3 years ago

Harm HorstmanHero

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

9 months ago

Page 1 / 73

Questions & Conversations

1802 Topics

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

Example REST API Multipart Form using msxml2.xmlhttp

Multirow task execution

Crystal Reports export to Excel: adjust column width

A certificate is required to complete client authentication

Export to xlsx in reporting service (crystal report)

Best practice for inserting large amounts of rows into one table

HTTP connector results into 411 - Length Required

Consume OData API via .NET Core

Executing API 'CreateFile' failed with error number 32.

Logs folder on Azure app service

Requirement status

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

Http connector Exact online

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

Autonomously generate report and send it by e-mail

Make your logging data available in the GUI

Assemblies for deployment

Moving to Azure SQL database & Azure File Storage

Redirect URI for connection with Exact Online

Trace your changes by adding trace fields

User Experience Universal GUI - Votes collector topic

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

Resource Scheduler & Extender

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