18.3Dev Script Deployment Error

Issue No: AR-7640
Created 6/4/2018 9:53:50 PM
Type Bug-QC
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 18.3
Description Error on vsts 18.3   2018-06-05T01:00:23.7628471Z D:\a\1\s\i21Database\dbo\Stored Procedures\uspAPCreateVoucherDetailClaim.sql(36,3,36,3): Build error SQL71501: Procedure: [dbo].[uspAPCreateVoucherDetailClaim] has an unresolved reference to object [dbo].[tblAPBillDetail].[dblFranchiseAmount]. [D:\a\1\s\i21Database\i21Database.sqlproj] 2018-06-05T01:00:23.7628781Z D:\a\1\s\i21Database\dbo\Views\vyuARCommissionDetail.sql(28,8,28,8): Build error SQL71501: View: [dbo].[vyuARCommissionDetail] contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: [dbo].[tblARCommissionDetail].[I]::[intInvoiceId], [dbo].[tblARInvoice].[I]::[intInvoiceId] or [dbo].[vyuARCommission].[I]::[intInvoiceId]. [D:\a\1\s\i21Database\i21Database.sqlproj] [https://irely.visualstudio.com/i21/_build/index?buildId=113168&_a=summary&tab=details]