Support
Login
Your Password

Sales
North America
Phone: +1 (905)-655-9262
Fax: +1 (905)-655-9395
Email: info@add-on.com

Europe
Phone: +45 7944 7000
Fax: +45 7944 7001
Support
Denmark
+45 7944 7002

Europe
+44 (0) 203 002 3889

North America
+1 (202)-536-4165
Knowledgebase: Resource Central
KB0189 - Tasks overview is not displayed

 

Symptom

When logging in as a Service Desk Agent, you might see nothing displayed in Tasks screen:

Cause

In RC 3.8, a SQL schema have been updated (stored procedures and tables) in comparison with RC 3.7 and 3.7.10. This make SQL server take long time to re-compile those changes (maybe a few minutes). After the re-compiling is completed, the issue is gone.

 

Resolution

When the RC 3.8 is installed and you have configured the application and upgraded the database (using RC Configuration Tool), run the following script in SQL server:

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spEXECsp_RECOMPILE]') AND TYPE IN (N'P', N'PC'))

DROP PROCEDURE [dbo].[spEXECsp_RECOMPILE]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

 

CREATE PROCEDURE [dbo].[spEXECsp_RECOMPILE] AS

SET NOCOUNT ON

-- 1 - Declaration statements for all variables

DECLARE @TableName varchar(128)

DECLARE @OwnerName varchar(128)

DECLARE @CMD1 varchar(8000)

DECLARE @TableListLoop int

DECLARE @TableListTable table (UIDTableList int IDENTITY (1,1), OwnerName varchar(128), TableName varchar(128), ObjType varchar(128))

-- 2 - Outer loop for populating the database names

INSERT INTO @TableListTable(OwnerName, TableName, ObjType)

SELECT u.[Name], o.[Name], o.[type] FROM sys.objects o INNER JOIN sys.schemas u ON o.schema_id  = u.schema_id WHERE o.Type in ('U','P') ORDER BY o.[type]

-- 3 - Determine the highest UIDDatabaseList to loop through the records

SELECT @TableListLoop = MAX(UIDTableList) FROM @TableListTable

-- 4 - While condition for looping through the database records

WHILE @TableListLoop > 0

 BEGIN

 -- 5 - Set the @DatabaseName parameter

 SELECT @TableName = TableName,  @OwnerName = OwnerName FROM @TableListTable WHERE UIDTableList = @TableListLoop

 -- 6 - String together the final backup command

 SELECT @CMD1 = 'EXEC sp_recompile ' + '[' + @OwnerName + '.' + @TableName + ']' + char(13)

 -- 7 - Execute the final string to complete the backups

 -- SELECT @CMD1

 EXEC (@CMD1)

 -- 8 - Descend through the database list

 SELECT @TableListLoop = @TableListLoop - 1

 END

SET NOCOUNT OFF

GO

This script is to create [spEXECsp_RECOMPILE] stored procedure, which is used to recompile all changes in RC database (tables, stored procedures, etc.). This recompiling can improve access speed to RC database when user runs the system for the first time after upgrading.

After the [spEXECsp_RECOMPILE] is created in RC database, you need to run it by executing the following statement:

exec [dbo].[spEXECsp_RECOMPILE]

 

Properties

Applies to: All revisions of RC 3.8

Reference: TFS #64965

Knowledge base ID: 0189

Last updated: Mar 14, 2016