Database
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 :)
I know that in webcon report there is only possibility to show only one "Item list" attribute but is there any possibility to create some technical data table or atribute to show more than one list? Or maybe you can give some example of SQL function which select more than one "Item list". Thank you in advance for your help.
Hi, I have noticed that you can create multiple content databases 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 databases, but I am not sure that is possible. What else do you know about this subject of multiple content databases on the same Webcon portal. Thanks, Razvan
Hi all! I need to create an email alert that will be triggered if a Task Assignment Workflow is created for a specific user. My goal is to check if that user is a User Cal (has a Webcon licence) and if not send me an email so I can give the user the access required. I've created a Send custom email and I'm trying to define the execution rule that will be checking the previous statement. My query is the following: SELECT UCL_BpsID FROM WFElements JOIN CacheOrganizationStructure as G O (...)
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?
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".
Hi all, do you have any information where are kept the covers in the database on the 2023 version?
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 (...)
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 (...)
Hi tehre, quick question: Somewhere in my notes I saw this string but I can't recall what it points to: /api/nav/db/1/attachments/4/preview?hash=0 In other words, I seem to remember that at some point this link displayed a preview image that was uploaded somewhere. But I don't know by which means an attachment was uploaded to this path. Right now, calling this link throws: {"type":"https://tools.ietf.org/html/rfc7231#section-6.5.4","title":"Not Found","status":404,"traceId":"00- (...)
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
Hi, I can't delete one step from my workflow. 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 fix it? Thanks advance for your help.
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 am interested in the scale and speed of the database growth at the beginning based on the (...)
Is there a supported way to change the Acronym of the content database after the installation?
Is it possible to use CTE Tables in sql commands in the attribute configuration? If yes, could someone show me an example?
Hi all, i hope you are well. We have moved our PROD-Environments Databases 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 databases are offline. Currently there is still an alias configured, that routes traffic that might go to the old SQL-Server to the new one, which is okay, but nothing we want to (...)
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
Hi, Are there any issues with deleting rows related to cyclical actions in those tables (WFActionExecutions ,AutomationSessionExecutions )? Thanks, Kuba
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?
Hi I'm looking for steps or best practices how to do it correctly - restore db prod on test env ?
+48 12 443 13 90