Error: Could not drop constraint. See previous errors. 'idx_tblLogonSession' is not a constraint

Error: Could not drop constraint. See previous errors. 'idx_tblLogonSession' is not a constraint

Cause:

This usually happens when upgrading from an older of GLOBODOX which uses a SQL Server based MainDB

Resolution:

IMPORTANT: Please make sure you take the backup of the GLOBODOX databases before performing the actions given below.

1. Start SQL Server Management Studio on the server machine
2. Provide credentials for the user 'sa' and login
3. Click the New Query button on the toolbar. A blank query window will open
4. Copy the query text (in blue) below and paste it in the blank query window. 

Please Note: We are assuming that the name of the GLOBODOX Main Database is named MainDB. If not, please replace MainDB in the text below with the name of the GLOBODOX Main Database listed in SQL Server Management Studio


USE [MainDB]
GO

DROP TABLE [dbo].[tblLogonSession]
GO

CREATE TABLE [dbo].[tblLogonSession](
[UserID] [int] NULL,
[MachineName] [nvarchar](255) NULL,
[AppType] [int] NULL,
[LogonDateTime] [datetime] NULL,
[LastAccessedDateTime] [datetime] NULL,
[LicenseType] [int] NULL,
[AppName] [nvarchar](255) NULL,
[ServiceTicket] [ntext] NULL,
[SessionPointer] [nvarchar](32) NULL,
[ActivationCount] [int] NULL,
[TicketID] [nvarchar](255) NOT NULL,
 CONSTRAINT [idx_tblLogonSession] PRIMARY KEY CLUSTERED 
(
[TicketID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


5. After pasting the text in the query window click the Execute button on the toolbar
6. You should see a message Commands completed successfully.
7. Run GLOBODOX

    • Related Articles

    • Error installing ODBC driver MySQL ODBC 5.3 Driver

      Error: Error 1918. Error installing ODBC driver MySQL ODBC 5.3 ANSI Driver, ODBC error 13: The setup routines for the MySQL ODBC 5.3 ANSI Driver ODBC driver could not be loaded due to system error code 126: The specified module could not be found ...
    • Creating FTP Based File Stores in GLOBODOX

      Creating FTP Based File Stores in GLOBODOX Requirements: You must have already configured FTP. If not, refer the below article to configure FTP. Configuring FTP in IIS Step 1: Create FTP File Store in GLOBODOX In the folder configured for FTP (e.g., ...
    • Configuring FTP in IIS

      Configuring FTP in IIS This document provides the steps to configure IIS. Follow the below steps to install IIS … Go to the Windows Start menu and type Windows Powershell. You should see the option of Windows Powershell. Right click on Windows ...
    • Check the version of GLOBODOX installed.

      To check the version of GLOBODOX installed in your machine please follow the steps listed below... Start GLOBODOX and login. Click the big round button on the top-left corner of the screen. Now click the About GLOBODOX... option. On the top-left ...
    • Install MS SQL Server 2014 Express Edition using GLOBODOX DB Engine utility

      Please download the GLOBODOX DB Engine utility from the link below... For Windows 64 bit: http://downloads.itaz.com/dbengine/latest/gdx-db-engine-package-sqle-x64.exe For Windows 32 bit: ...