search results

(...) Hi, I'd like to build SQL query that uses 'current BPS Database ' and at the same time uses linked server that exists on that server. So I want to do sth like that: Select * from BPS_Content.dbo.WFElements t1 left join [my_linked_server].[Database ].[schema].[my_table] t2 on t1.id = t2.id Unfortunately it doesnt work. I got an error in Webcon Studio "Access to the remote server is denied because t (...)

(...) Hello, I would like to create a new data source in the MSSQL Database category that would retrieve information from a list of values ​​​​from the form and other attributes on the same form, but I don't know what such a correct query should look like. Currently, my query is only able to retrieve information from the attributes themselves, but not from the list of values. Edit: I found the solution.

(...) ity. What makes this situation even more paradoxical is that, from a configuration standpoint, both reports and views (whether application-based or those set up on the dashboard) are stored in the Database as identical elements in the same table. The only difference is that the functionality has been stripped from the front-end. WEBCON: Is there any chance this feature will be reinstated in the futu (...)

(...) verything we have run into a "License expired" error. This was raised by the "Start /Stop performance indicator" action. I didn't want to waste any more time and deactivated these action on the Database level. While this is an option, I think it would be better, if the action wouldn't be executed then throwing an error. This is probably a partner only problem as it's unlikely that end customer (...)

(...) Hello. Is it possible to somehow remove the entries that are in the recent activities section under each application from the Database ? In what specific table are they located? I would like to remove entries older than 30 days. Thank you for your answer. Maciej

(...) accounts. This had been build in to the Designer Studio and there was also a stored procedure. It would really be great if the this functionality could be restored. While we have access to old Database where the stored procedure still exists, new customers don't have this option. When they rename their domain for various reasons, they are stuck. Best regards, Daniel

(...) adgodziny (zrodlo danych). (Step: Rozliczenie nadgodzin, path: Pobierz nadgodziny) Error getting data for DataSource name: [Pracownicy] wszyscy - poszerzone (Licencje) ID: 597 Multiple concurrent Database operations on the same TransactionInstance object are not supported. Additional log with stack trace of all operations is possible.

(...) d a custom SQL query to split the long string into individual rows with email addresses. This approach seems to work when executed via SQL COMMAND, but it doesn't work when used directly in the MSSQL Database or the Item List initialization. Am I on the right track? Any idea what might be going wrong?

(...) assigned tasks) to passively wait for the scheduled task to complete. The scheduled task retrieves its parameters either from the command line (passed during job creation) or by connecting to the BPS Database . It’s essential that the scheduled job issues a PATCH API call back to the originating workflow instance to continue the process flow. Although the solution might sound complex, it has been running r (...)

(...) s and the base 64 encoded values of their attached images. This data table is used to create a word document. The standard SQL connection uses the bps_user which neither can read data from a separate Database nor is the user allowed to read the attachment file table: "The SELECT permission was denied on the object 'WFAttachmentFiles', Database 'BPS_1f6af8fb_Content', schema 'dbo'.." In "normal" envir (...)

(...) et a red popup error on the frontend: “Unknown exception.” Troubleshooting done so far: • Restarted the server • Verified available disk space Questions: 1. Can I safely reindex the whole Database via Designer Studio > Reports > SOLR indexer queue > Add > Reindex all Database s? 2. Should this reindexing be performed during night time/weekend to avoid disruption? Webcon version: 2023.1.3.1 (...)

(...) ecurity relevant features like last login/access timestamp to WEBCON portal, Designer Desk and Designer Studio should get saved seperately. Right now there seems to be no information available in the Database when a user last used one of the modules. The audit log could also contain login events for failed logins for easier debugging. The audit log could also store activities e.g. CRUD of WF-instances (...)