Delay in Management console login time and reports

Delay in Management console login time and reports

Environment: 

iVend 6.6 Patch 7747


Problem Description: 

Delay in Management console login time & reports.


Scenario: 

Clients facing an unusual time to login Management Console (dos mode screen also appears) and the reports taking more time to generate even if it is in a small volume, sometimes the system gets hanged.


Investigation/Troubleshooting: 

Need to check below points to troubleshoot the slowness

1)  Check allocation and structural integrity of all the objects. 

DBCC CHECKDB.


2) Check Fragmentation of Major tables 

"SELECT top 10 OBJECT_NAME(i.OBJECT_ID) AS TableName, i.name AS IndexName,indexstats.avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'DETAILED') indexstats
INNER JOIN sys.indexes i ON i.OBJECT_ID = indexstats.OBJECT_ID
WHERE indexstats.avg_fragmentation_in_percent > 30
AND i.index_id = indexstats.index_id
ORDER BY 3 desc


3) Check database size "SELECT DB_NAME(database_id) AS DBName,Name AS Logical_Name, Physical_Name,(size*8)/1024 SizeMB
FROM sys.master_files
WHERE DB_NAME(database_id) = 'CXSRetail66' --databasename" .


4) Check SQL Server Version Select @@VERSION .

Symptoms:


.



Resolution/Work Around: 

One of the possible reasons for slowness can be the un-optimized Database.


If DB is not optimized; it needs to be optimized. It is suggested to do the fragmentation for all the tables having values greater than 90. 


    • Related Articles

    • Unable to login to Management Console

      Issue: While login to Management console getting the error "The type initialize for"FlexNetActivationLibrary.ActivationUtility" threw an exception while login to MC" as shown below: Cause: The license Key either not activated correctly or not ...

    • Not able to login to Management Console. Appearing an error when opening the Management Console

      Environment: Not version-specific Problem Statement: Not able to login to Management Console. Appearing an error when opening the HO Management Console. Below is the screenshot of the error: Below is the error in the windows event viewer: Faulting ...

    • Unable to login in iVend Management Console

      Problem Statement Unable to login in iVend Management Console at HO. Error: While trying to login in management console at HO system gives the below error message. Solution: 1: Make sure proper database name is entered in the iVend connection ...

    • Error while login to Management Console.

      Environment: Not Version Specific Problem Statement: Getting the below error “String or binary data would be truncated “while opening Management console, as shown below: Cause: One of the known reasons for such an exception is that the application ...

    • No Management console found in the management console selection screen.

      iVend Version: 6.6 Issue: Not able to select MC in management console selection screen while login to MC. Cause: This issue generally Occurs when a Database from one machine is used in another machine, because Database may store some information of ...