(...) hin Webcon. Specifically, I am interested in understanding whether there is a possibility to visualize a document by providing a link that points to a document stored either on SharePoint or within a SQL server database. My goal is to enable the automatic display of the associated document in preview mode when a user selects a record in the application. Has anyone had experience or insights into achievi (...)
Hi, I'm sorry, if this a duplicate, but I'm not sure if I added it already or maybe someone else. If selecting a value of a choose field from a data source throws and this causes an error, it's not easily possible to see the actual "request" which was used to get the data. There are ways around this: - In case of SQL and you have access to the server you could activate the SQL profiler -
(...) test webinars I've heard that there is open 'Designer Studio' project at Webcon, so I'll give it a shot - if not now, then I'm not sure if there will be a better time ;) I think most of us have used SQL server Management Studio or Azure Data Studio to test some queries, and maybe a VSCode / Notepad++ for some powershell - all of those support autocompletion (which in most cases of recent software is suppor (...)
(...) d id columns: and {WFCONCOL_ID:544} = '{WFD_ID}' The big question is, why was it working in the first place and only failed in production? The production database contains way more data and the SQL server decided to execute the query differently. Test system: The index of the choose column wasn't used, which "magically" allowed the query to work. Production system: The index of the choose column wa (...)
(...) urce on Data Sources -> Connections -> MSSQL database as I keep getting the error message below: "Unknown error: A network-related or instance-specific error occured while establishing connection to SQL server . The server was not found or was not accessible. Verify that the instance name is correct and that SQL server is configured to allow remote connections." I have attached the image of information f (...)
(...) Hi there, Is it possible to use one datatable to show different tables from a SQL server ? Right its possible to filter the sql results based on a value in a certain column. I also want to make it possible to show the content of a different table, however account to the infobox to the right side of the textbox where i write the sql statment, its not possible. So i was wondering if there is an alternative. I (...)
Hi, We noticed some problems with vacation Gantt chart report with past vacations after update to 2024. The problem occured on 2 versions 2024.1.1.130 and 2024.1.1.161. 2024.1.1.130: #1 problem we noticed: We cannot see any past data vacations, mainly on a simpified report (black/white one). #2 problem we noticed: On a advanced report with colors we can see past vacations but not a
Hello, is there a guide on how to move both databases and the portal to new servers? I tried to backup the databases, restore them on new database server and then perform upgrade on the new application server, but the installation fails when connecting to the Search Server: 06-02-2025 19:02:51 msg: Step2 src: Upgrade 06-02-2025 19:02:55 msg: Sql version: 14.0.3480.1 src: SqlServerVersionC
(...) Does someone know how to fix this problem? The cleaner fills our SQL server with error messages that took 20gb of space after few days. This Error occours even when using a different version and virtual server.
(...) n pool. service_webcon is used for the service. So far so good. So we prepared the accounts for the dev-stage exactly like the accounts in the prod-stage (of course different servers and different SQL server ). service_webcon_iis_dev is used as application pool user, service_webcon_dev is used for the service. If we start the dev-stage with this configuration we get an exception: sql login failed for (...)
Hi, data table /rows display the values as they are returned from the data source. In case of the MSSQL data source this is fine for text fields and for choose fields, integers/decimals we can work around it. Either by using the available functions or using format functions and the current user language. In case of date time there's no work around. The issue is especially visible when user
(...) no physical data model diagram in the documentation. A visual representation of tables and their dependancies provides a very useful overview about how data is structured, maintained and related. In SQL server there is a option to add a new database diagram and thus my question: could Webcon, as a software vendor, provide and maintain the database diagram OR is it up to the implementation team to build the (...)
(...) stallation" (windows 2025 and updates, .NET Framework 4.7.2, installed automatically with the system, ASP.NET Core Runtime 8.0 Windows Hosting Bundle, MSSQL 2019 with installed full-text search , Ms SQL server Management Studio 20, IIS with Windows Authentication), also tried to fix using this thread -> https://community.webcon.com/forum/thread/1042 . When I try to log in even if I made everywhere user (...)
(...) is to set up a third environment (TEST), align it with PROD, and then perform the upgrade there. My question is: is it feasible to do this on a laptop/notebook with Windows Server, running a local SQL server instance and WEBCON on IIS? Or are there any specific requirements or limitations I should be aware of? I’d like to do this without interfering with the existing database servers or current enviro (...)
(...) Hi everyone, maybe this question asked before. I am currently working with a WEBCON BPS SaaS instance and I need to connect it to a local (on-premises) SQL server to access internal data sources. I understand that the WEBCON BPS Bridge is the recommended solution for this hybrid setup to avoid opening inbound firewall ports. However, I am having trouble locating the actual download link for the Bridg (...)
(...) tion that I must have Cumulative update 29 (15.0.4410.1) installed to continue. The problem is that I haveall the most recent updates and when I try to install the desired update manually, I get: "A SQL server update with a higher version has already been installed on SQL server instance MSSQLSERVER, so the current SQL server update cannot be applied. The version of the SQL server update that is already in (...)
(...) ound. I have a report based on some workflow, and I’m trying to add a calculated column that returns the value related to a given element in report. The value is stored in a table located on another SQL server (linked server), which is already connected to the WEBCON database. I tried using a query like this: SELECT Value FROM [serverX].[Mydatabase].[table] JOIN [serverY].[WEBCONdatabase].[dbo].[WFEl (...)
(...) 1e4eb051c", "svalue": "2026-04-23T09:06:05.0000000+02:00", "value": "2026-04-23T09:06:05+02:00" }, This represents 7:06:05 UTC / 09:06:05 local time (UTC+1:00 Amsterdam, Berlin...) The SQL server and WEBCON share the same machine and for whatever reason the time zone is also set to (UTC+1:00 Amsterdam, Berlin...). The global parameter is also set to the equivalent time zone: PRM_Name PR (...)