Database
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?
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, Is it ok to create a custom SQL views on BPS_Content DB? Does webcon allow it? Best Regards, Bartek
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 (...)
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?
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 (...)
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 (...)
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- (...)
I am using the free version with a limit of 10GB. Recently I received a message - Failed to execute 'setitem' on Storage: Setting the value of 'ExpandFormButtonLogID' exceeded the quota. I checked and the base was 9600MB. I did a shring database and reduced it to 4500MB. Today, I have the same error with a 4600MB database. Is this the end of working with the free version?
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 (...)
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:(
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
Currently I'm migrating files from SharePoint to a custom built WEBCON DMS application. Normally the Instance number is generated according to a rule which is perfect for new files. The customer wants to keep their document numbering. For the existing files I would like to update the Instance number (Database: WFD_Signature) using a small SQL script. But is it safe and is it wise to do that? I'm aware the numbers need to be unique in the system, and I know they are unique in the old system. (...)
Hi, we would like to use the SOAP web service in WEBCON (DBVersion 2022_1_2) . How can we get the delivering result? Webcon by default marks only the "Messages" area. See screenshot. Unfortunately, other markings are not possible... Thanks a lot! Florian
Hey, now all 4 databases (Config,Content,Content_Arch,Content_Att ) are on the same MS SQL server. Do you have plans to give opportunities to host each DB in deddicated server? For example - to have 4 MS SQL Server , 1 for each BPS database.
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 (...)
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.
When trying to import an application, WEBCON BPS Designer Studio tells that the operation fails. I may check if the role "Import" as been started for the actual database. Where can I check this? Where can I activate this role? Thanks for any help. ---- Issue solved: The "basic role" message has been shown due to the fact that the BPS service was in "Safe Mode". The "Safe Mode" issue - in this case - has been solved by updating the license information and restarting the service (...)
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 :)
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 (...)
+48 12 443 13 90