Dear Audience, In Recent days I was mentoring a project for SP update. As general practice, we have updated the Sandbox / Dev and Quality before we do the same in Production.

We were ready with all issues log and actions to be taken to ensure no delay will happen while performing the SP upgrade in Production.

After completing the SP update as per the process, while login to application we have faced a dump saying ”  Wrong Database Collation “.

Solution : Before starting the Update procedure , please check the collation type maintained in SQL server is SQL_Latin1_General_CP850_BIN2 for  SQL server 2012 or above. This need to be maintained in two places.  In my case when the collation type was maintained differently. So based on SAP suggested solution, we tried to change the collation type but since it was taking longer to get effective, we have re-installed the MS SQL and restored the backup which we have taken post Update.

The other error we have faces is

Error 1: ‘Ret Code 1024: SQL-Error “2714- there is already an object named “xxxxxx” in the database”in the DDL statement for …..’

This happend in the phase MAIN_SHDIMP/PARMVNT_SHD

Resolution : Please follow Note 460271 to fix the issue. You should remove the indexes for these objects directly in the DB.  Other way is reset the SUM procedure and restart the Update once again.  This happend when the log full situation occurred and we have shrink the log to provide space for further logs.

 

Please share your questions in the below. we will reply you.