search results

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