search results

(...) tion When creating support for business processes in WEBCON BPS, it is important to remember that even the simplest workflow with a minimum number of steps and form fields will be reflected in the database – all of its instances and settings are represented in the content database – which is the main place of the system’s operation. There are also “virtual tables” automati (...)

(...) .xlsx, tiif, and zip. Their storage location is a particularly important aspect of the system configuration. When organizing your document management system, you can decide to create a separate database to store the attachments. What is the attachments database and why is it created? An attachments database is a dedicated database that stores the attachment files. After creation, the database (...)

(...) 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 database s.   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’ (...)

(...) .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 database s 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 database s 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 database s on SQL server higher than 2 (...)

(...) Author: Paweł Drab Introduction   Migration of database s 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.3 and above; author: Maciej Kieblesz   Introduction This article describes a method of maintaining database s 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 dat (...)

(...) Hello everyone, did someone update the database compatibility level from the default 'SQL Server 2008 (100)' to a newer one and can share their experience? I really would like to make use of those "new" functions instead of using hard to read workarounds. Best regards, Daniel

(...) Hi all, i hope you are well. We have moved our PROD-Environments database s to a different SQL Server last night. Except from some annoying trouble with Sharepoint and the Webcon solutions we managed to get everything running smoothly again. We uninstalled everything except from SOLR, and installed it again. The old database s are offline. Currently there is still an alias configured, that routes traff (...)

(...) Hello everyone, before you install/upgrade BPS check the default schema of the database user under which the installation/upgrade will be executed. Make sure that the default schema is dbo. If this is a different schema new objects may be created using this schema. This may lead to unexpected errors later on which will be hard to debug. Here's a little script to change it. SELECT name AS [Name], (...)

(...) Currently selection attributes, such as picker, poll the database in such a way that LIKEs are always placed in the WHERE clause. The data that the database returns are then filtered according to the picker configuration (exact match, contains phrase, starts with). In my company, we collect customer data from several CRM systems. For one of them, we have the customer's data materialized in the dictiona (...)

(...) Hi, I have noticed that you can create multiple content database s 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 database s, but I am not sure that is possible. What else do you know about this subject of multiple content database s on the same Webcon portal. Thanks, Razvan

(...) Is there a supported way to change the Acronym of the content database after the installation?

(...) Hi, I add new connection (MSSQL database ) - test it with success. Next I add new data source with some SQL query which returns some data when I test it. If I save that connection Webcon shows the error: "Failed to retrive column from data source XXX. No connection settings." If I want to test that data source in choice form field I've returned: Nieznany błąd: The ConnectionString property has n (...)

(...) Can anyone recommend some good calculator or formula to calculate the database size increment for demo applications and N users over time? Condition (no attachments are uploaded) something like: application A or B * user or process * month = yMB data size Rather, it is an order of magnitude to evaluate for these ready-made sample demo applications As far as the attachments can be estimated, (...)

(...) I copied businessRule from one process to another and after save I can't open this process anymore. Message=The given key (432) was not found in WFBusinessRuleDefinitions cache for current content database . Source=WebCon.WorkFlow.Data StackTrace= at WebCon.WorkFlow.Data.Caching.Collections.WFBusinessRuleDefinitionCacheEntityCollection.ByID(Int32 id) at WebCon.WorkFlow.Studio.Logic.Managers.Busi (...)

(...) When trying to import an application, WEBCON BPS Designer Studio tells that the operation fails. I may check if the role "Import" as been started for the actual database . Where can I check this? Where can I activate this role? Thanks for any help. ---- Issue solved: The "basic role" message has been shown due to the fact that the BPS service was in "Safe Mode". The "Safe Mode" issue - i (...)

(...) flow. First problem that I have is there is some active elements associated with this step. I deleted it on webcon portal but after that operation I still have comunicate at workflow designer: "The database contains workflow instances associated with this step. You must delete those elements first in order to delete the step". On which SQL table I can find that archive elements? Any ideas how can I fi (...)

(...) Hey, now all 4 database s (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, I haven't realized before that the REST Api doesn't contain any information about the database column. I agree in most cases this is of no use and would only create unnecessary traffic. There's one use case though were one needs it. When you read the metadata information so that you can provide a configuration option in another system to start a workflow using the URL parameters: ...?com_id=1&A (...)