Applies to version: 2021.1.x and above; author: Konrad Wojtycza Introduction The Run an SQL procedure action allows you to invoke SQL procedures from the WEBCON BPS form level, and to prepare the universal SQL queries with variables. This functionality is limited only by the capabilities of the SQL query language. It is possible to invoke SQL procedures using data in the WEBCON BPS form
As we develop WEBCON BPS, we strive to march in lockstep alongside other platform products, i.e. Windows Server, SQL, SharePoint, etc. We do our best to maintain backward compatibility with older versions of these platforms to accommodate our diverse client base and their preferences. However, as the publishers end support for their aging products, so must we. It’s not all d
PDF version 1. Prerequisites (SharePoint platform) 2. Prerequisites (no SharePoint platform) 3. High availability 4. WEBCON BPS databases 5. Disaster-recovery scenario (SharePoint platform) 6. Disaster-recovery scenario (no SharePoint platform) 7. Good practices in WEBCON BPS platform maintenance 8. WEBCON BPS Farm internat/external communication diagr
Applies to version: 2021.1.x and above; author: Dawid Golonka The article is an update of the already existing article, it shows the configuration in version 2021.1.x. For the original see: Import-Export – Good process design. Introduction WEBCON BPS has a mechanism that allows you to transfer process definitions between several independent environments. The DEV-TEST
Applies to version: 2021.1.x and above; author: Konrad Wojtycza Introduction The “Item list” form field is used to store any number of data rows organized into columns. In business practice, there is a need for the item list to be updated based on the values from other elements or updated automatically, and a user cannot edit it. For this purpose, you can use the “Change i
(...) Applies to version: 2021.1.x and above; author: Wojciech Mleczko Information about instances registered in WEBCON BPS is stored in the MS sql database , and in Apache Solr indexes (allows for a quick search). While the system is running, activities such as registering a new instance, following a path, or saving an instance generate entries in the queue of elements to be saved in Solr. The WebCon WorkFlow S (...)
Applies to version: 2020.1.3.x and above; author: Konrad Wojtycza Introduction Translation Tool is the unofficial tool that allows you to translate WEBCON BPS configuration elements. Currently, it is not being developed because it is stable and functional – is compatible with the system from version 2019.1.x. Using Translation Tool you can export descriptions of all configuration elem
Applies to version: 2021.1.x and above; author: Martyna Krzyżak WEBCON BPS applications frequently require integration with external systems. Microsoft Dynamics is one of the popular systems that requires integration with WEBCON BPS workflows. Business scenarios Below you can find some examples of areas shared by Microsoft Dynamics and WEBCON BPS. Cost invoice
(...) ash; if something went wrong when executing a large stack of actions, rolling back the effects inside the WEBCON BPS system was never a problem, since everything related to the system is found in the sql database on which the system is installed. Problems started when actions in a transaction affected external systems, rolling back those changes required creative solutions. In each automation, there is the (...)
PDF version Introduction Requirements towards the Customer and the Integrator General information solution requirements Initial data import into WEBCON BPS Exemplary description of integration message Introduction Document description The document sets out design and technological WEBCON BPS requirements for integration
Applies to version: 2022.1.x and above; author: Jacek Język From WEBCON BPS 2022.1.1, the lowest supported SQL Server is 2014. In the case of WEBCON BPS installations using the higher versions of SQL Server, WEBCON BPS databases work with the compatibility level set to SQL Server 2014 by default. Changing the compatibility level from SQL Server 2014 to SQL Server 2019 is possible, but
Starting with WEBCON BPS 2022.1.1, the lowest supported MS SQL Server version is 2014. Due to this, when installing WEBCON BPS, the Compatibility Level for databases is set to 120 – which corresponds to SQL Server 2014. This setting is also used when installing WEBCON BPS with newer versions of SQL Server (2016, 2019…). However, please note that when updating the WEBCON BPS platfo
Applies to version: 2021.x.x.xxx and above; author: Mateusz Syrek Introduction This article describes 3 variants for transferring WEBCON BPS databases to a different SQL server: new server has the same name as the old one, new server has a different name – applying SQL aliases, new server has a different name – no SQL aliases applied, changing configuration
Author: Paweł Drab Introduction Migration of databases to a different database environment or their recreation in such environment may require changing database name. If references to a database are present in several locations, external, logical change of database name is insufficient. The article describes the procedure of changing database name by modifying configuration.
Applies to version: 2022.1.x and above; author: Łukasz Maciaszkiewicz Introduction Increasing data volumes combined with shrinking disk space and decreased performance pose a challenge to every IT system. WEBCON BPS faces it with an extensive archiving mechanism that automatically removes data from process databases. The resulting better arrangement of disk space translates into e
Applies to version: 2022.1.x and above; author: Łukasz Maciaszkiewicz Introduction WEBCON BPS uses services to run special operations that generally do not require user interaction. Unlike Portal, which acts as a host for a website, the service can have multiple roles performing calculations and executing long operations defined previously by a user. This article describes the roles the
Applies to version: 2021.1.x and above; author: Konrad Wojtycza Introduction WEBCON BPS Designer Studio allows users to configure global business and form rules. As global rules, they are available for all applications created in a given environment and thanks to parameters they are universal and may be used in multiple processes. Global business and form rules can be
(...) SQL Server accessible from the computer running WEBCON BPS in containers. Installation steps: Creating the WEBCON BPS Search Server container and initializing Solr search indexes. Creating sql database s using the WEBCON BPS installer. Creating the WEBCON BPS Workflow Service container. Creating the WEBCON BPS Portal container. Starting Designer Studio and activating the license. All the (...)
Applies to version: 2022.3.x and above; authors: Jacek Język, Krystyna Gawryał Introduction WEBCON BPS version 2022 R3 comes with a dedicated database read account. During each new installation, a database account named bps_user is automatically created in all Content databases, which is used by BPS to read data from the database. In contrast, when upgrading the system that
Applies to version: 2023 R1 and above; author: Łukasz Maciaszkiewicz Introduction The logic behind the execution of tasks by service is a multi-faceted and complex issue. When planning tasks, application designers are often unaware of the mechanisms and rules used by the service. To fill this gap, this article describes the elements affecting the sequence in which the service exec