Share
Report
1,270Hi
I am presently doing a test upgrade of a Dynamics 7.0SP4 database to Dynamics 2015 and after the upgrade I noticed a couple of errors in the DBuild log file. I researched online and I got an article that points to changing the connection on the server to 0 so that it could fix the timeout expired message but I still encountered the message after doing another test upgrade.
In addition, one of the error message in the log file, it pointed to an invalid column. On checking, I realized that the PONbr field is not present in the INTran table in Dynamics 7.0 but it is present in Dynamics 2015. Has anyone noticed this issue on upgrading?
I have pasted some of the errors that I go from the DBuild log file. Could someone assist in pointing to what I could do to resolve these issues. Any assistance will be greatly appreciated.
Error Code: -2
Error Text: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Statement: SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULL_DFLT_OFF ON
GO
IF NOT EXISTS(SELECT sysobjects.name, syscolumns.id, syscolumns.name
FROM sysobjects JOIN syscolumns ON(sysobjects.id = syscolumns.id)
WHERE sysobjects.name = 'INTran'
AND syscolumns.name = 'PoNbr')
Error Code: -2
Error Text: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Statement: SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULL_DFLT_OFF ON
GO
-- This will clean up orphan note entries for tables with a NOTEID column that is NOT an Identity column
declare @sql nvarchar(max) = ''
select @sql = @sql + 'UPDATE ' + t.name + ' set noteid = 0 where noteid <> 0 and NOT EXISTS(select nid from snote where nid = noteid );'
from sys.tables t WHERE EXISTS(SELECT c.name FROM sys.columns c WHERE c.object_id = t.object_id AND c.name = 'NoteId' and c.is_identity = 0 )
exec sp_executesql @sql
Error Code: 207
Error Text: Invalid column name 'PoNbr'.
Invalid column name 'SrcDate'.
Invalid column name 'SrcLineRef'.
Invalid column name 'SrcNbr'.
Invalid column name 'SrcType'.
Statement: SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULL_DFLT_OFF ON
GO
CREATE VIEW [QQ_intran]
AS
/*
Negative Check
If the Inventory Setup settings does not allow negative quantities, check to keep
the costing layer from having either a negative quantity or a negative cost.
*/
If (@NegQty = @False
Or (Select RTrim(LotSerTrack) From Inventory Where InvtID = @InvtID) = 'SI')
And (@IS_QtyOnHand + Round(CONVERT(DEC(25,9),@QtyOnHand), @DecPlQty) < 0
Or (@IS_TotCost + Round(CONVERT(DEC(28,3),@TotCost), @BaseDecPl) < 0 And @IS_QtyOnHand + Round(CONVERT(DEC(25,9),@QtyOnHand), @DecPlQty) > 0
And @ValMthd <> 'U'))
Begin
/*
Solomon Error Message
*/
Insert Into IN10400_RETURN
*This post is locked for comments
All responses (
Answers (
