Database shrink getting failed
*************************** Internal to CitiXsys ***************************
Problem Reported:
During the 365 activity or any other general DB maintenance task you may face the below error when trying to shrink database
error message ' TITLE: Microsoft SQL Server Management Studio
------------------------------
------------------------------
Shrink failed for Database 'CXSRetail_SAP'. (Microsoft.SqlServer.Smo)
------------------------------
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)'
Proposed Resolution:
As a Possible workaround you can try to shrink the DB using File option. kindly follow the below steps.
1 - Right click on database --> Property -->option -->Recovery Model -->select simple -->click ok
2 -Right click on database -->Tasks -->Shrink --> Files -->select file type -->Log -->click ok
Related Articles
ISSUES WHEN INTIALIZING MASTER TABLES FROM SAP: "iVend 6.*.*.* add-on failed to update the database"
Product version 6.5 Update 6 Problem statement Getting Error "iVend 6.*.*.* add-on failed to update the database" when initializing master tables from SAP Reason CXSINTEGRATION DATABASE IS DELETED SAP database, already initialized with iVend database ...Cannot open database 'CXSIntegration' login failed
Environment: iVend 6.6 Problem Statement: Cannot open database 'CXSIntegration' login failed Symptoms: Environment Specific Resolution/Work Around: It seems wrong SQL password is entered for user "sa". So need to check correct password for SQL login ...While applying the patch then getting an error "Patch 1 database_2021_7747 Failed."
Environment: iVend 6.6 Problem Statement: While applying the patch then getting an error "Patch 1 database_2021_7747 Failed." The below is the screenshot for the same: Solution: It was found that customer was using Windows Server 2019, which is not ...While login to management colsole getting an error "login failed for user sa"
Environment: Not Version Specific Problem Statement: We have changed the database password but getting an issue while login to management console getting an error message " login failed for user sa" Proposed Solution: You need to change the "sa" ...Found error while login MC "Error encountered found in application"
Environment: 6.6.7989 Short Description: Error found in the application Product Query: While login in Management Console found error “Error found in the application” Resolution/Work Around: Not Applicable Recommendations /Suggestion: Ivend Database ...