You’re offline. This is a read only version of the page.
5
Hi All,
I am doing the Business Portal upgrade from BP4.0 to 5.1 for GP2010. while installing i am getting "One or more system SQL objects have failed to upgrade". I checked in BPSQL.log file, it is showing Query Timout Expired error. Please help me to resolve this issue.
/* TimeStamp: 11/13/2012 1:26:53 PM Database: "DYNAMICS" Actor: "C:\Program Files\Microsoft Dynamics\Business Portal\Utilities\SQL\Upgrade\4.0.2475.0\System\GP_COMMON\data.AssemblyVersionUpgrade.sql" */
-- [dbo].[MbfProcessAlias] [SerializedValue] ntext
UPDATE [MbfProcessAlias]
SET [SerializedValue]= cast(replace(cast([SerializedValue]as nvarchar(max)),'2.5.0.0','5.1.0.0') as ntext)
WHERE [SerializedValue]like '%2.5.0.0%'
UPDATE [MbfProcessAlias]
SET [SerializedValue]= cast(replace(cast([SerializedValue]as nvarchar(max)),'2.7.0.0','5.1.0.0') as ntext)
WHERE [SerializedValue]like '%2.7.0.0%'
UPDATE [MbfProcessAlias]
SET [SerializedValue]= cast(replace(cast([SerializedValue]as nvarchar(max)),'3.0.0.0','5.1.0.0') as ntext)
WHERE [SerializedValue]like '%3.0.0.0%'
UPDATE [MbfProcessAlias]
SET [SerializedValue]= cast(replace(cast([SerializedValue]as nvarchar(max)),'4.0.0.0','5.1.0.0') as ntext)
WHERE [SerializedValue]like '%4.0.0.0%'
UPDATE [MbfProcessAlias]
SET [SerializedValue]= cast(replace(cast([SerializedValue]as nvarchar(max)),'5.0.0.0','5.1.0.0') as ntext)
WHERE [SerializedValue]like '%5.0.0.0%'
~~The above statement produced the following error:
~~Query timeout expired
Thanks in advance.
*This post is locked for comments
I have the same question (0)
Share
Report
All responses (
Answers (