Database

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

Different query execution contexts on environments

0 5

Hi, I have a problem with the execution of SQL queries in different environments using a Default connection (after moving the system to AZUR-e servers). SQL Server Profiler shows that on the TEST server execution of queries using the Default connection uses a different user than on the Dev server - installation seems to be the same (the same users etc.). Is there any option/installation parameter that causes the execution of TEST SQL may be different than the rest of the environments? (...)

BPS Internal View

0 5

Hi, I really need to understand and find out where in BPM_Content I can find all my BPS Internal View data sources, because I would like to use some columns from there that don't exist in WFElements (like STP_Name). But seems like I'm failing to find it everytime I try. I understand that all my dictionaries are stored in Views folder.. which makes me think that BPS internal views are stored somewhere separately as well. Is anyone kind and able to help me with this? Thank you

Fixed values list on the database

0 10

Hi everyone, I wanted to ask if anyone knows where or in which table the "Fixed values list" are stored. I am using a "Start a subworkflow (SQL)" to migrate data from our old sharepoint workflow tool to Webcon. Unfortunately, it seems that Webcon has decided that 'Choice fields' always require a GUID#Name to be populated. (Without this format I get an error and the subworkflow does not run). Now I have some Choice fields that use Fixed values lists in Webcon and I need to concatenate th (...)

Email notifications

0 2

I recently noticed a problem with sending emails from my environment. The most likely cause was the wrong password for the application pool account. I see a lot of entries in the WFMails table with a status of 0. I do not want all outstanding e-mail notifications to go out after changing the password. Is adding to the send queue based on the WFMails table, or is there another, dedicated database table for this purpose? UPDATE I have already found some important information: This queue is (...)

Direct insert of data into the database (into the WFelements table)

0 16

Hi, Is there a set of rules, an instruction on how to directly (using insert-sql) import data into the database (into the WFelements table)? Which field values should we generate so that there are no problems with the operation of the application. Of course, WFF_STPID - step ID, WFD_DTYPEDID - form ID depends on the process, and the rest, e.g. RowVersion (some hexadecimal value) ? And other?

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

Sharepointless database overwrite

0 1

Hi, Suppose I changed Webcon to a version without sharpoint. I have a PROD database and I would like to select the last year from the database and overwrite TEST, is this possible?

[Solved] Issues with database connection "subsequently assumed a new security context"

0 3

Hi everyone, I was working on a process and out of the blue I receive the following errors: In BPS Portal / testing a data table: The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction In the event viewer there's the following entry: The connection has been dropped because the principal that opened it subsequently assumed a new security context, and then tried to reset the connection under its impersonated securi (...)

Creating sql views on BPS_Content DB

0 1

Hi, Is it ok to create a custom SQL views on BPS_Content DB? Does webcon allow it? Best Regards, Bartek

Unable to delete step

0 4

Hi there, I'm unable to delete a step in the Workflow Designer window. It says (see screenshot). I can find the step in the db: SELECT * FROM WFSteps WHERE WFSteps.STP_ID = 95 But no associated Wf instances with it: SELECT WFSteps.STP_ID, WFSteps.STP_Name, WFSteps.STP_Description, WFSteps.STP_IsFinish, WFElements.WFD_ID FROM WFElements JOIN WFSteps ON WFSteps.STP_ID = WFElements.WFD_STPID WHERE WFD_STPID= 95 It's not an option to use the admin tools to delete all instances f (...)

MS SQL Server - changing the authentication mode and collation

0 1

Hi, Due to requirements of another system: 1. I need to change the authentication method of MS SQL Server from Windows to mixed. Any risks connected with such operation? Or Webcon should be working just fine? 2. A need to change the collation of the SQL Server. Are there any risks connected for running Webcon service here?

Missing KPI reports/data

0 8

Hello, Since a specifc time KPI reports don't work on my webcon enviroment. I checked a configuration according to https://community.webcon.com/posts/post/web-part-kpi-new-edition/141 and everything looks good. I've checked 'KPI elements' table in webcon database and there are some data but the data are not up to date. Old webcon apps have the kpi data but as I said the data are not up to date. New applications don't have any kpi data. Do you know what can cause the issue? How to solve it (...)

OPENJSON does not list all fields

0 1

Hello everybody. I'm trying to display all the JSON fields, but I can't. Thanks to anyone who can help me. 1 - JSON structure '{ "status": "SUCCESS", "VentaPajaros": { "codigoClient": 13216598, "composicionParcelas": [ { "id": "07" }, { "id": "08" } ], "pago": { "fechaprimerpago": "09/12/2022", "datosventa": { "valor (...)