17.3 RC SQL script is failing

Issue No: GL-3688
Created 8/22/2017 6:21:56 AM
Type Bug
Priority Blocker
Status Closed
Resolution Fixed
Fixed Version 17.3
Description Error SQL72014: .Net SqlClient Data Provider: Msg 208, Level 16, State 1, Line 6 Invalid object name 'tblGLCompanyPreference'. 2017-08-22T09:41:21.6049484Z Error SQL72045: Script execution error. The executed script: 2017-08-22T09:41:21.6059485Z PRINT 'BEGIN POST DEPLOYMENT'; 2017-08-22T09:41:21.6059485Z 2017-08-22T09:41:21.6059485Z 2017-08-22T09:41:21.6059485Z GO 2017-08-22T09:41:21.6059485Z DECLARE @vygerImportHeader AS INT; 2017-08-22T09:41:21.6059485Z 2017-08-22T09:41:21.6059485Z IF ((SELECT COUNT(\*) 2017-08-22T09:41:21.6059485Z FROM tblSMImportFileHeader 2017-08-22T09:41:21.6059485Z WHERE strLayoutTitle = 'Voyager') = 0) 2017-08-22T09:41:21.6059485Z BEGIN 2017-08-22T09:41:21.6059485Z INSERT [dbo].[tblSMImportFileHeader] ([strLayoutTitle], [strFileType], [strFieldDelimiter], [strXMLType], [strXMLInitiater], [ysn<--- 2017-08-22T09:41:21.6059485Z 2017-08-22T09:41:21.6059485Z ---> (Inner Exception #32) System.Management.Automation.RemoteException: Active], [intConcurrencyId]) 2017-08-22T09:41:21.6059485Z VALUES (N'Voyager', N'Delimiter', N'Space', NULL, NULL, 1, 24); 2017-08-22T09:41:21.6059485Z SET @vygerImportHeader = SCOPE_IDENTITY(); 2017-08-22T09:41:21.6059485Z INSERT [dbo].[tblSMImportFileRecordMarker] ([intImportFileHeaderId], [strRecordMarker], [intRowsToSkip], [intPosition], [strCondition], [intSequence], [intConcurrencyId], [strFormat]) 2017-08-22T09:41:21.6059485Z VALUES (@vygerImportHeader, N'Transaction Date', 0, 163, NULL, 1, 6, N'YYYYMMDDHHMM'); 2017-08-22T09:41:21.6059485Z <--- 2017-08-22T09:41:21.6059485Z 2017-08-22T09:41:21.6059485Z ---> (Inner Exception #33) System.Management.Automation.RemoteException: INSERT [dbo].[tblSMImportFileColumnDetail] ([intImportFileHeaderId], [intImportFileRecordMarkerId], [intLevel], [intPosition], [strXMLTag], [strTable], [strColumnName], [strD 2017-08-22T09:41:21.6059485Z 2017-08-22T09:41:21.6059485Z <--- 2017-08-22T09:41:21.6069495Z 2017-08-22T09:41:21.6069495Z 2017-08-22T09:41:21.6069495Z Deployment status for machine 'i21server.eastus.cloudapp.azure.com:5986' : 'Failed' 2017-08-22T09:41:21.6279488Z ##[error].[uspICUnpostFIFOIn]: The reference to the column Inserted.intInventoryTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOIn]: The reference to the column Inserted.intTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOIn]: The reference to the column Inserted.strTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOIn]: The reference to the column Inserted.intRelatedTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOIn]: The reference to the column Inserted.strRelatedTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOIn]: The reference to the column Inserted.intTransactionTypeId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOIn]: The reference to the column Changes.intInventoryTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOIn]: The reference to the column Changes.intTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOIn]: The reference to the column Changes.strTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOIn]: The reference to the column Changes.intRelatedTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOIn]: The reference to the column Changes.strRelatedTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOIn]: The reference to the column Changes.intTransactionTypeId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOIn]: The reference to the column Changes.Action could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOInFromStorage]: The reference to the column Inserted.intInventoryTransactionStorageId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOInFromStorage]: The reference to the column Inserted.intTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOInFromStorage]: The reference to the column Inserted.strTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOInFromStorage]: The reference to the column Inserted.intRelatedTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOInFromStorage]: The reference to the column Inserted.strRelatedTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOInFromStorage]: The reference to the column Inserted.intTransactionTypeId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOInFromStorage]: The reference to the column Changes.intInventoryTransactionStorageId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOInFromStorage]: The reference to the column Changes.intTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOInFromStorage]: The reference to the column Changes.strTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOInFromStorage]: The reference to the column Changes.intRelatedTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOInFromStorage]: The reference to the column Changes.strRelatedTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOInFromStorage]: The reference to the column Changes.intTransactionTypeId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOInFromStorage]: The reference to the column Changes.Action could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOOut]: The reference to the column Inserted.intInventoryTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOOut]: The reference to the column Inserted.intTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOOut]: The reference to the column Inserted.strTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOOut]: The reference to the column Inserted.intRelatedTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOOut]: The reference to the column Inserted.strRelatedTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOOut]: The reference to the column Inserted.intTransactionTypeId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOOut]: The reference to the column Changes.intInventoryTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOOut]: The reference to the column Changes.intTransactionId could not be resolved.\r\nWarning SQL71005: Error validating element [dbo].[uspICUnpostFIFOOut]: The reference to the column Changes.strTransactionId could not be resolved.\r\nWarning