(...) .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 you need to disable the TSQL_SCALAR_ (...)
(...) Starting with WEBCON BPS 2022.1.1, the lowest supported MS SQL Server version is 2014. Due to this, when installing/updating 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…). When installing BPS databases on SQL server higher than 20 (...)
(...) Applies to version: 2022.1.3 and above; author: Maciej Kieblesz Introduction This article describes a method of maintaining databases to ensure the highest possible performance of the SQL engine, and thus the BPS application itself. In practice, this will mean a reduction in the number of 'timeout' errors, for example, when loading a report. This mechanism is tailored to BPS data (...)
(...) Hi, I have noticed that you can create multiple content databases on one Webcon installation. Why and how would you actually use that? It would be great if you could segregate the instances of different business entities in different databases , but I am not sure that is possible. What else do you know about this subject of multiple content databases on the same Webcon portal. Thanks, Razvan
(...) Hey, now all 4 databases (Config,Content,Content_Arch,Content_Att ) are on the same MS SQL server. Do you have plans to give opportunities to host each DB in deddicated server? For example - to have 4 MS SQL Server , 1 for each BPS database.
(...) Hi all! We have a new customer who has a central IT service department. As for the database, we can just order a certain amount of databases , which we then have access to. The question is, is it even possible to install Webcon into existing databases (e.g. Config, Content, Att,...) or do we need a fresh SQL instance from the customer and an admin account with db_creator or sysadmin rights (as describ (...)
(...) We have two attachment databases , one for testing and one for production: BPS_Content_Att_test BPS_Content_Att_test2 BPS_Content_Att BPS_Content_Att2 In this application we use BPS_Content_Att_test2 for testing and BPS_Content_Att2 for production. Unfortunately we don’t have a database with identical name, so when we import from test to production, the default attachment database specified in th (...)
WEBCON: Business Process Automation and Management as its best WEBCON develops the Low-Code Business Process Automation Platform, WEBCON BPS (Business Process Suite). This enterprise-grade system allows organizations to embrace digital transformation by digitalizing their workflows and building comprehensive, scalable, process-centric and future-proof applications applying t
(...) hor: Dawid Golonka Introduction Some processes in WEBCON BPS require data from some other source to operate correctly. This data can be provided from external data sources such as SQL databases or SharePoint lists. Internal sources can also be created in the system such as Fixed value lists or references to data contained in WEBCON BPS workflows. Any WEBCON BPS process can be used as a sour (...)
(...) Due to the number and size of attachments for the selected processes (e.g. invoice cost, contracts), the size of the database may reach even several Terabytes. The backup/recovery procedures for such databases are very time consuming. Division into a dedicated database allows you to simplify the procedures and save time. Unlike the main database containing metadata and entire instance history (lots of op (...)
(...) allows creating reports based on the SearchIndex (SORL) data source. This article below will show you how we can configure such a report and explain how it differs from existing reports based on SQL databases . What are and when to use reports based on the SearchIndex source? Reports based on SearchIndex data source provide acceleration of system response time and simultaneously won’t (...)
(...) es should have the following privileges: They must be a system administrator of the Designer Studio, They must have privileges in the ‘configuration’ and ‘content’ SQL databases at least at dbowner level, In the case of a SharePoint installation, the user should also be an administrator of the site collection. Connection with Portal The Designer Studio installation (...)
(...) rver 2012 R2, Windows Server 2016, Windows Server 2019 MS SQL Server 2012 or higher. This does not have to be a separate machine, The WEBCON BPS installer must have the ability to create and modify databases on the designated server. Accounts and privileges: Local or AD account for the IIS application pool. BPS service account – same requirements as the application pool account. SQL login w (...)
(...) ores 16GB (minimum); 20GB (recommended) Storage for system files 140G Storage for SOLR search indexes: 100GB Notes: SharePoint databases will reside on SQL Server All WEBCON BPS components will be installed on SharePoint server (except database). 1.2.4.Recommended installation – setup for over 10 000 users The (...)
(...) ed based on the instance workflow ID – the “Based on instance ID” mode Adding attachments from other workflows from the external WEBCON BPS content database or external attachment databases selected based on the SQL query – the “Based on SQL query” mode The workflow The simple Invoice workflow has been created on the “Copy PO to attachments&rdqu (...)
(...) Applies to version 2020.1.3; author: Dawid Golonka Introduction One of the types of data stored in WEBCON BPS databases is the configuration of the elements that make up applications and processes. The configuration settings entered by a user are stored in the tables appropriate for the configured elements. The article provides a summary that schematically shows which table is responsibl (...)
(...) 2014, broken down by industry. The selected datasheet that contains over 1300 records, has been imported to the UK_JOB_CHANGE database (created and configured for this article). The following databases have been configured in the test workflow: Data table – connection – the Data table form field with the directly configured connection to the database containing the example data. T (...)
(...) d after the configuration change. Changing the WEBCON BPS Classic interface to BPS Modern and breaking all references to SharePoint will make sure that the application continues to work after the databases have been transferred to the StandAlone installation. Additionally, during the change, you can refactor the implemented applications by facilitating the configuration or completing the process docume (...)
(...) quired level, without violating e.g. company secrets. This article describes the rules for configuring Task delegation substitutions, taking into account user privileges in the context of multiple databases , as well as the roles of WEBCON BPS Workflow Service and global system settings. Basic information Task delegation substitutions can be defined by users: Globally – (...)
(...) " action should be limited, as this action allows interference with the data stored in the database. The use of this action with API provided by WEBCON BPS allows you to save data from external databases such as ERP systems or a non-standard organizational structure. Downloading data from external systems can be organized in time and take place cyclically (e.g. at night). This functionality can be he (...)