SQL

INTERNAL USE ONLY - Correcting SIOs values in READER and ALARMPANEL tables

03/10/2022Content Creator
Symptom Readers and Alarm panels might be added to READER and ALARMPANEL tables with incorrect SIO values. There can be three types of this issue: SIOs equal 0 two readers/alarmpanels from same board with different SIO two readers/alarmp...

Unique Constraint Errors on Serial Number

02/11/2022April Daniels
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 export results.

02/07/2022April Daniels
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. ...

Database Error, unable to archive database

02/07/2022April Daniels
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:      R...

SQL Server Data Source drivers used with OnGuard

02/04/2022April Daniels
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 in...

“Events Polling Stopped” errors appear in logs

10/30/2020Steve Goldstein
How to identify and correct issues with event polling stopped error message

Migrating an Existing SQL Database to Azure SQL

10/11/2018April Daniels
Migrating an Existing SQL Database to Azure SQL   Procedure Steps It is not possible to use the MDF files when migrating an existing OnGuard SQL database into Azure SQL.        Options for migrating an existing OnGuar...

Installing OnGuard on SQL Azure

10/11/2018April Daniels
Installing OnGuard on SQL Azure   Procedure Steps Installing OnGuard on SQL Azure requires manual configuration changes because:   The field for the Database server name during installation expects a "valid hostname" (su...

How to setup ODBC Logging

07/02/2018April Daniels
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...

Improving indexes and providing a performance increase when running reports

03/28/2018April Daniels
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 questi...