WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question

search results

for databases

(...) .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

(...) Hi Razvan, I'm only aware of "SQL Server" reasons e.g.: Performance, backup/restore time, separate drives etc. If you have a few high volume processes you could create different databases for these. In the past it was possible to export a process from one database and import this and not a template it in another. Today this is no longer possible, unfortunately. This could be used as an alternative to bus (...)

(...) Hi Razvan, based on the change log of the new version 2021.1.3.178 it's now configurable, whether you can import a process in multiple databases. I wonder why there are no other replies though. Best regards, Danie

Thanks for the info Daniel! I am still curious if WEBCON has something to add to this post.

(...) 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 Konrad Due to the WEBCON BPS architecture, there is no plan to split databases on more than one SQL server instance.

(...) 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 (...)

(...) tabase network when reinstalling the WEBCON server. However, this would have to be generated in advance and transferred to the actual target server. So you first have to create a server including the databases (on a temporary, local SQL server) and then transfer the databases to the target server. The connection to the actual SQL server can then be switched using the admin tool in the WENCON setup.

(...) Hi The procedure described by Ralph will work but you can do it easier. You (IT Team) can create empty databases on the SQL Server, (no WEBCON BPS Schema, no WEBCON BPS tables... - empty) and use the names of created databases during WEBCON BPS installation. WEBCON BPS Installer will do the rest. Remember to grant permissions (dbo) no that databases (depending on the type of authentication: SQL Log (...)

(...) Thanks a lot for the helpful answer to Pawel and Ralph. I was expecting Webcon to throw an error during installation, if a database exists. But if it allows empty databases the question is resolved for me. We will take care of necessary permissions then.

(...) 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 (...)

Hi Maciej, when you import the process the first time, than you can select which attachment database should be used. The default database, is suggested. If you haven't created any instance yet you can change the attachment database in the process. Maybe it's also possible to change it while there are no attachments. I'm not to sure about it. Afterwards you are stuck. Best regards, Dan

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 (...)