Database

Support for Azure SQL

4 10

Hi there, as far as I know there is no official support for Azure SQL for the WEBCON BPS databases today. If we implement WEBCON BPS in a customer's own Azure tenant as their private cloud, it would be smart to use Azure SQL, because of the integrated HA features, scalability and low maintenance effort. WEBCON BPS is very well integrated with Microsoft technology and has great integrations with Microsoft services, i.e. M365. I would strongly appreciate, if support for Azure SQL could be added in (...)

Remove data of instances no longer in archive database not working

1 1

Hello, As usually, after encountering an error during tests, I have tried to Remove data of instances no longer in archive database option. Unfortunatelly, it is not working. Blue bar is sliding from left to right for about 10 minutes now. In Designer Studio, I can't remove the steps associated with the corrupted task, and the task also can't be removed because it doesn't load. Is there any tip, how to remove that? Best regards

Downloading attachments to a local disk

1 0

I would like to print attachments that are attached to selected tasks (with specific IDs) so that I can print them. It would be enough if I could automatically save them to the local disk. Does anyone have any idea how to do this? Plese help:(

WEBCON tables via MS SQL Server Management Studio

1 2

Hello, Does anyone can help me, how can I see WEBCON tables via MS SQL Server Management Studio? What the process of connecting to the WEBCON server looks like? When I tried to enter the server name (test.company.corp) into MS SQL Server connection dialog box it didn't work. Regards

SOLVED: Creating a Data Table with Attachment-Links from a WFD_ID

1 3

Hi folks, today I have a special problem and hopefully somebody of you already has a solution. I am working on an internal Knowledge-Database. One given requirement is: In case of an update, the old entry has to be archived and a new entry with all previous information should be created to be edited. So far no problem - except for the attachments. I dont want the old attachment files to be copied to attachment section. Instead of that it would be nice to have a DATA TABLE with _li (...)

Experience with updated Database Compatibility Level

1 4

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

report permission

0 1

Hi is there a way to get from the database all the permissions to all the reports that we have ? I was not able to find any column with that information and I do not know how to get such info

Tables: WFActionExecutions ,AutomationSessionExecutions

0 1

Hi, Are there any issues with deleting rows related to cyclical actions in those tables (WFActionExecutions ,AutomationSessionExecutions )? Thanks, Kuba

Sql query to list all of the application

0 1

HI I need by sql query to outline the list of the appliacation that we have and a workflows to a choice field. How can I do if the app is on Main_Db and we have apps on Main_db and main_db2?

How to transfer the database to a new server ?

0 2

Hello, how to transfer the database to a new server? I have no problem with transferring processes in WEBCON Designer Studio, but how to transfer data?

All uses of connections and data sources via SQL query

0 8

In Designer Studio it is possible to check the use of a single connection or data source in the context of all processes. Is it possible to get such a list for all connections and sources using an sql query?

Best practices steps to backup and restore db PROD on TEST

0 1

Hi I'm looking for steps or best practices how to do it correctly - restore db prod on test env ?

Information about deleted instances

0 2

Hi, Does anyone know where in the database I can look for recent activities? I mean the ones that are on the Dashboard, specifically "Delete of instance".

Portal Logged Users

0 1

Hello everyone. Is it possible to select all authenticated users in the portal with the date and time of authentication?

How to update a record in wfelementTasks ?

0 1

I used to update this table and chagne wft_user and WFT_user name. But from the version 2023 i got Update or insert of view or function 'WFElementTasks' failed because it contains a derived or constant field. Is there any other way to udpate the column in wfelementtasks?

Recovery Pending and HTTP error 502.5

0 4

My database goes into "Recovery Pending" mode which causes a program HTTP error 502.5. Restarting the SQL Server service solves the problem, but this has happened several times, does anyone know why this is happening?

Substitutions in 2023 version

0 2

Hi all, do you have any information where are kept the covers in the database on the 2023 version?

How to handle a big content database?

0 7

Hi, We have a project in Webcon that has many processes and dictionaries (more than 150). The application has been in production for, let's say, two years. In the first year, the database size was manageable, but now it's getting out of hand. Does anyone have any tips, tricks, or suggestions for dealing with large amounts of data? Are there optimization techniques we can employ? Any opinions are welcome! Thanks!

CLR Assembly Permission Sets to SAFE_ACCESS in SQL SERVER

0 1

Hi, Following a security audit, we are compelled to set the CLR Assembly Permission Sets to SAFE_ACCESS in SQL SERVER. I'm not an expert in SQL. What impact does this setting have on Webcon? Thanks, Raluca

Problem calling the data source

0 10

After installing a new development environment, I have a problem with performing an SQL query to the BPS_Config database. The environment was installed with my administrative account. From the database level, I can also see that the users of the service and the application pool (db owner) have permissions to the database. The application pool is the account indicated in the installer as the user to connect to the database. The message itself points to a SID that I don't have in my domain. Every (...)