SQL

Symptom Database-intensive OnGuard operations present a noticeable performance loss when the database is hosted in SQL Server 2022 and the OnGuard login for SQL (the SQL-authentication login) does not have db_owner permission to the database. Re...

Symptom In the log, you may encounter errors referring to duplicate serial numbers. The following example is for an Oracle database: Database error encountered: Serial Number: 1360725739, Event: 0-0, Panel: 5281: ORA-0001; unique constraint (LEN...

How to capture a SQL Profiler trace, and then export the results. Procedure Steps Log into SQL Management Studio and select Tools > SQL Server Profiler .   Log into the SQL Server database as a user with permission to perform a trace. Select t...

Symptom  When attempting an archive or purge your database, you see one of the following errors:            When observed in System Administration, you see the following connection error:      Resolution  In most cases, the issue is reso...

Symptom  SQL Server Data Source drivers used with OnGuard  Resolution  OnGuard 7.3 and earlier installed with SQL Server requires that SQL Server Data Sources use the SQL Server Native Client 11.0 driver . OnGuard 7.4 and later installed with SQ...

Procedure Prepare an empty database on the Azure server (preferably with the same name as existing on-premises database) for each of your existing databases (for example, the live, reports, and archival databases). From the Microsoft download...

Installing OnGuard on Microsoft Azure SQL requires manual configuration changes because: The field for the database server name during installation expects a valid hostname (such as   DBSERVER0002 , but not tcp:databasename.database.windows....

There are some cases where configuring ODBC logging might provide additional information to troubleshoot application connections that use ODBC.   Procedure Steps Open 32 bit ODBC Data Source Administrator (C:\Windows\Syswow64\odbcad32.exe)...

Improving indexes and providing a performance increase when running reports   Procedure Steps   The first 3 SQL commands provide the most improvement. The other 2 are also necessary for overall improvement. If you have any questions, pleas...

Symptom When attempting to open OnGuard applications on the server and workstations, users will receive "Cannot establish communication with the login driver" and when opening SQL Server Management Studio users will see "Package 'Microsoft SQL ...