Database

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?

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

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

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

Save space on SQL server with ATF_IsDeleted?

0 9

Dear Community, I have a question regarding attachments database. Size of the database is quite large and I'm trying to find optimizations here. Table / index compression is not a solution - compression ratio is barely reaches 0,5% level. I have found a lot of records in this database where attachments are deleted (column ATF_IsDeleted = 1). Is it safe to remove such records from database or it will make inconsistency of the data? Do you have any experience in it? Looking forward for any (...)

SQL Update on WFElements table

0 9

Hi! I have a process which generates subprocess (list is from sql query). The subprocesses generates correctly but there is one thing that I need to change - the author of the subprocess document should be change for the employee from field. I tried to change the login by update the WFD_CreatedBy column in WFElements table but it's not possible. I've received an error: "One or more errors occurred. Operacja została wycofana Concurrency Error Concurrency Error" In attachement you can (...)

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?

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

Attachments saving in a different place

0 8

Hi, I have a project where I can't save attachment in a webcon database storage(becouse of company policies). I am looking for a solution to store attachments on network drive. Is there possibility to change localization of attachment ? May be some workaround? Some action, rule, ect? I thought about action which will create a folder on shared drive and webcon form will show information to user where to store attachment. But I don't know how to achieve this:/ Any idea?

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!

Extracting [Comments] field (column WFD_Description from WF_Elements) to external report

0 6

Hi Guys, Has Webcon any function or script to extract the [Comments] field in the "human eadible" way? Lets say DATE | AUTHOR | COMMENT TEXT. Selecting from WFD_Description for particular ID gives me output like below. It is becoming more complicated if I have two or more comments, divided by ','. SELECT WFD_ID ,WFD_Description FROM [BPS_Content].[dbo].[WFElements] where wfd_id=xxxxx output: [{"d":"2022-02-21T14:40:40.086895","l":"username@domain.com","a":"Name Surname","c":"Text (...)

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

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?

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

Hash in front of ID of choice field value

0 4

Hi, I noticed something strange in the database values for a choice field - a hash in front of the ID (screenshot attached). Has the behavior of the database changed? In the documentation I still find it's supposed to be ID#Name, no mention of a hash. Best regards

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

"Incorrect data for translation" error message during application export

0 3

Hello, I have a strange thing that prevents any application from being exported: When the assistant analyzes the environment the following error message is delivered: see below Using the GUID given in the error message on the table 'dbo.translates' I receive one line with columns that seems to deliver the error. Sadly I am lacking information on the columns 'TRANS_ELEMID' and 'TRANS_OBJID' to furtherly investigate this issue. My assumption: An application group with an existing name ha (...)

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

SQL statement with "ROW_NUMBER" function working in MSSQL Management Studio but not in Webcon designer.

0 3

Hello folks, The query in the attached image is not working in the designer, but working flawlessly on the same DB in the MSSQL Management Studio. Is there the possibility that the designer somehow does not like "ROW_NUMBER" function? Or is it a Webcon bug? I hope someone has experience with this already. Thanks in advance :)