AnsweredAssumed Answered

Error during upgrade 6.3.1RC1 to 6.3.0 (MSSQL)

Question asked by stekosto stekosto on Feb 19, 2015
Latest reply on Feb 23, 2015 by stekosto stekosto
Hi,
i am trying to upgrade 6.3.0RC1 to 6.3.0 by using upgrade wizard and file SugarCE-Upgrade-6.3.0RC1-to-6.3.0.zip.
System passes the first 3 steps but on 4th step gives the following error:

SQL Error : [Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated.. [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated..

Viewing the log file:
02/20/15 00:05:00 [1616][1][FATAL] [Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated.. [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated.. :  ALTER TABLE email_cache ALTER COLUMN fromaddr nvarchar(100) NULL.

Now, when i re-run the update wizard, it's trying to complete the 4th step but gives the same above error and so on.

Click Next to run additional upgrade scripts.

Upgrade Steps: 
1: System Check 
2: Upload Upgrade Package 
3: Preflight Check 
4: Commit Upgrade >>> 
5: Confirm Layouts

Next

Sugarcrm community edition is running on IIS 7.5, Windows 2008R2, PHP Version 5.3.19.

Any assistance would be greatly appreciated.

Outcomes