Description |
2019-01-17T18:13:27.4230169Z ##[section]Starting: Run i21Database.dacpac
2019-01-17T18:13:27.4236261Z ==============================================================================
2019-01-17T18:13:27.4236394Z Task : PowerShell on Target Machines
2019-01-17T18:13:27.4236460Z Description : Execute PowerShell scripts on remote machine(s)
2019-01-17T18:13:27.4236540Z Version : 1.0.51
2019-01-17T18:13:27.4236593Z Author : Microsoft Corporation
2019-01-17T18:13:27.4236658Z Help : [More Information]( [https://go.microsoft.com/fwlink/?linkid=627414] )
2019-01-17T18:13:27.4236753Z ==============================================================================
2019-01-17T18:13:27.4246353Z Preparing task execution handler.
2019-01-17T18:13:27.6247860Z Executing the powershell script: D:\a\_tasks\PowerShellOnTargetMachines_3b5693d4-5777-4fee-862a-bd2b7a374c68\1.0.51\PowerShellOnTargetMachines.ps1
2019-01-17T18:13:29.0548414Z Deployment started for machine: 'i21server.eastus.cloudapp.azure.com:5986'
2019-01-17T18:17:09.0600664Z Deployment started on target machine...
2019-01-17T18:17:09.0600921Z
2019-01-17T18:17:09.0601007Z System.AggregateException: Failed to execute the powershell script. Consult the logs below for details of the error.
2019-01-17T18:17:09.0601062Z
2019-01-17T18:17:09.0601140Z *** Could not deploy package.
2019-01-17T18:17:09.0601210Z +At C:\i21PowerShellCom\AllVersions\RunCommand.ps1:12 char:5
2019-01-17T18:17:09.0601274Z + & $command
2019-01-17T18:17:09.0601427Z + ~~~~~~~~~~
2019-01-17T18:17:09.0601497Z CategoryInfo :NotSpecified: (*** Could not deploy package.:String) [], RemoteException
2019-01-17T18:17:09.0601593Z FullyQualifiedErrorId :NativeCommandError
2019-01-17T18:17:09.0601636Z
2019-01-17T18:17:09.0601714Z Warning SQL71005: Error validating element [dbo].[uspICUnpostFIFOIn]: The reference to the column Changes.Action could not be resolved.
2019-01-17T18:17:09.0601905Z Warning SQL71005: Error validating element [dbo].[uspICUnpostFIFOInFromStorage]: The ref
2019-01-17T18:17:09.0602000Z +At C:\i21PowerShellCom\AllVersions\RunCommand.ps1:12 char:5
2019-01-17T18:17:09.0602087Z + & $command
2019-01-17T18:17:09.0602142Z + ~~~~~~~~~~
2019-01-17T18:17:09.0602202Z CategoryInfo :NotSpecified: (:) [], RemoteException
2019-01-17T18:17:09.0602296Z FullyQualifiedErrorId :NativeCommandErrorMessage
2019-01-17T18:17:09.0602337Z
2019-01-17T18:17:09.0602397Z erence to the column Changes.Action could not be resolved.
2019-01-17T18:17:09.0602513Z Warning SQL71005: Error validating element [dbo].[uspICUnpostLIFOIn]: The reference to the column Changes.action could not be resolved.
2019-01-17T18:17:09.0602595Z Warning SQL71005: Error validating element [dbo].[uspICUnpo
2019-01-17T18:17:09.0602690Z +At C:\i21PowerShellCom\AllVersions\RunCommand.ps1:12 char:5
2019-01-17T18:17:09.0602761Z + & $command
2019-01-17T18:17:09.0602816Z + ~~~~~~~~~~
2019-01-17T18:17:09.0602898Z CategoryInfo :NotSpecified: (:) [], RemoteException
2019-01-17T18:17:09.0602965Z FullyQualifiedErrorId :NativeCommandErrorMessage
2019-01-17T18:17:09.0603019Z
2019-01-17T18:17:09.0603109Z stLotIn]: The reference to the column Changes.Action could not be resolved.
2019-01-17T18:17:09.0603199Z Warning SQL71005: Error validating element [dbo].[uspICUnpostLotInFromStorage]: The reference to the column Changes.Action could not be resolved.
2019-01-17T18:17:09.0603296Z Warning SQL72015: The column [db
2019-01-17T18:17:09.0603369Z +At C:\i21PowerShellCom\AllVersions\RunCommand.ps1:12 char:5
2019-01-17T18:17:09.0603431Z + & $command
2019-01-17T18:17:09.0603509Z + ~~~~~~~~~~
2019-01-17T18:17:09.0603569Z CategoryInfo :NotSpecified: (:) [], RemoteException
2019-01-17T18:17:09.0603660Z FullyQualifiedErrorId :NativeCommandErrorMessage
2019-01-17T18:17:09.0603701Z
2019-01-17T18:17:09.0603779Z o].[tblSMUserSecurityMenuFavorite].[intUserSecurityId] is being dropped, data loss could occur.
2019-01-17T18:17:09.0603897Z Warning SQL72030: If this deployment is executed, changes to [dbo].[uspCMImportBanksFromOrigin] might introduce run-time errors in [dbo].[uspEMImportCustomerEF
2019-01-17T18:17:09.0605446Z +At C:\i21PowerShellCom\AllVersions\RunCommand.ps1:12 char:5
2019-01-17T18:17:09.0605510Z + & $command
2019-01-17T18:17:09.0605594Z + ~~~~~~~~~~
2019-01-17T18:17:09.0605653Z CategoryInfo :NotSpecified: (:) [], RemoteException
2019-01-17T18:17:09.0605745Z FullyQualifiedErrorId :NativeCommandErrorMessage
2019-01-17T18:17:09.0605788Z
2019-01-17T18:17:09.0605839Z TInfo].
2019-01-17T18:17:09.0605945Z Warning SQL72030: If this deployment is executed, changes to [dbo].[uspCMImportBanksFromOrigin] might introduce run-time errors in [dbo].[uspEMImportEmployees].
2019-01-17T18:17:09.0606037Z Warning SQL72030: If this deployment is executed, changes to [dbo].[uspARCreatePrePay
2019-01-17T18:17:09.0606244Z +At C:\i21PowerShellCom\AllVersions\RunCommand.ps1:12 char:5
2019-01-17T18:17:09.0606334Z + & $command
2019-01-17T18:17:09.0606392Z + ~~~~~~~~~~
2019-01-17T18:17:09.0606486Z CategoryInfo :NotSpecified: (:) [], RemoteException
2019-01-17T18:17:09.0606555Z FullyQualifiedErrorId :NativeCommandErrorMessage
2019-01-17T18:17:09.0606598Z
2019-01-17T18:17:09.0606685Z ment] might introduce run-time errors in [dbo].[uspARImportPayments].
2019-01-17T18:17:09.0606778Z Warning SQL72030: If this deployment is executed, changes to [dbo].[uspAPPostPayment] might introduce run-time errors in [dbo].[uspAPPostOriginPayment].
2019-01-17T18:17:09.0606855Z Error SQL72014: .Net SqlClient
2019-01-17T18:17:09.0606952Z +At C:\i21PowerShellCom\AllVersions\RunCommand.ps1:12 char:5
2019-01-17T18:17:09.0607016Z + & $command
2019-01-17T18:17:09.0607093Z + ~~~~~~~~~~
2019-01-17T18:17:09.0607154Z CategoryInfo :NotSpecified: (:) [], RemoteException
2019-01-17T18:17:09.0607228Z FullyQualifiedErrorId :NativeCommandErrorMessage
2019-01-17T18:17:09.0607384Z
2019-01-17T18:17:09.0607473Z Data Provider: Msg 205, Level 16, State 1, Procedure vyuAPReceivedItems, Line 4 All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
2019-01-17T18:17:09.0607595Z Error SQL72045: Script execution error. The e
2019-01-17T18:17:09.0607669Z +At C:\i21PowerShellCom\AllVersions\RunCommand.ps1:12 char:5
2019-01-17T18:17:09.0607737Z + & $command
2019-01-17T18:17:09.0607819Z + ~~~~~~~~~~
2019-01-17T18:17:09.0607880Z CategoryInfo :NotSpecified: (:) [], RemoteException
2019-01-17T18:17:09.0607968Z FullyQualifiedErrorId :NativeCommandErrorMessage
2019-01-17T18:17:09.0608010Z
2019-01-17T18:17:09.0608062Z xecuted script:
2019-01-17T18:17:09.0608145Z ALTER VIEW [dbo].[vyuAPReceivedItems]
2019-01-17T18:17:09.0608205Z AS
2019-01-17T18:17:09.0608284Z SELECT CAST (ROW_NUMBER() OVER (ORDER BY intInventoryShipmentItemId, intInventoryReceiptItemId, intPurchaseDetailId) AS INT) AS intReceivedItemId,
2019-01-17T18:17:09.0608392Z Items.*
2019-01-17T18:17:09.0608450Z FROM (SELECT A.[intEntityVendo
2019-01-17T18:17:09.0608553Z +At C:\i21PowerShellCom\AllVersions\RunCommand.ps1:12 char:5
2019-01-17T18:17:09.0608617Z + & $command
2019-01-17T18:17:09.0608672Z + ~~~~~~~~~~
2019-01-17T18:17:09.0608756Z CategoryInfo :NotSpecified: (:) [], RemoteException
2019-01-17T18:17:09.0608823Z FullyQualifiedErrorId :NativeCommandErrorMessage
2019-01-17T18:17:09.0608864Z
2019-01-17T18:17:09.0608940Z rId] AS [intEntityVendorId],
2019-01-17T18:17:09.0609003Z A.dtmDate AS [dtmDate],
2019-01-17T18:17:09.0609090Z A.strReference AS [strReference],
2019-01-17T18:17:09.0609162Z tblReceived.strReceiptNumber AS [strSourceNumber],
2019-01-17T18:17:09.0609238Z A.strPurchaseOrderNumber AS [strPurchaseOrderNumber],
2019-01-17T18:17:09.0609305Z
2019-01-17T18:17:09.0609376Z +At C:\i21PowerShellCom\AllVersions\RunCommand.ps1:12 char:5
2019-01-17T18:17:09.0609440Z + & $command
2019-01-17T18:17:09.0609517Z + ~~~~~~~~~~
2019-01-17T18:17:09.0609577Z CategoryInfo :NotSpecified: (:) [], RemoteException
2019-01-17T18:17:09.0610025Z FullyQualifiedErrorId :NativeCommandErrorMessage
2019-01-17T18:17:09.0610092Z
2019-01-17T18:17:09.0610124Z
2019-01-17T18:17:09.0610186Z B.intPurchaseDetailId AS [intPurchaseDetailId],
2019-01-17T18:17:09.0610277Z B.intItemId AS [intItemId],
2019-01-17T18:17:09.0610347Z B.strMiscDescription AS [strMiscDescription],
2019-01-17T18:17:09.0610414Z C.strItemNo AS [strItemNo],
2019-01-17T18:17:09.0610503Z C.strDescription AS [strDe
2019-01-17T18:17:09.0610572Z +At C:\i21PowerShellCom\AllVersions\RunCommand.ps1:12 char:5
2019-01-17T18:17:09.0610661Z + & $command
2019-01-17T18:17:09.0610715Z + ~~~~~~~~~~
2019-01-17T18:17:09.0610774Z CategoryInfo :NotSpecified: (:) [], RemoteException
2019-01-17T18:17:09.0610946Z FullyQualifiedErrorId :NativeCommandErrorMessage
2019-01-17T18:17:09.0610988Z
2019-01-17T18:17:09.0611040Z scription],
2019-01-17T18:17:09.0611130Z NULL AS [intPurchaseTaxGroupId],
2019-01-17T18:17:09.0611199Z tblReceived.dblOrderQty AS [dblOrderQty],
2019-01-17T18:17:09.0611296Z tblReceived.dblPOOpenReceive AS [dblPOOpenReceive],
2019-01-17T18:17:09.0611370Z tblReceived.dblOpenReceive AS [dblOpenReceive],
2019-01-17T18:17:09.0611432Z
2019-01-17T18:17:09.0611521Z +At C:\i21PowerShellCom\AllVersions\RunCommand.ps1:12 char:5
2019-01-17T18:17:09.0611585Z + & $command
2019-01-17T18:17:09.0611640Z + ~~~~~~~~~~
2019-01-17T18:17:09.0611724Z CategoryInfo :NotSpecified: (:) [], RemoteException
2019-01-17T18:17:09.0611790Z FullyQualifiedErrorId :NativeCommandErrorMessage
2019-01-17T18:17:09.0611856Z
2019-01-17T18:17:09.0611908Z (tblRe
2019-01-17T18:17:09.0611952Z
2019-01-17T18:17:09.0611984Z
2019-01-17T18:17:09.0612069Z +At C:\i21PowerShellCom\AllVersions\RunCommand.ps1:12 char:5
2019-01-17T18:17:09.0612132Z + & $command
2019-01-17T18:17:09.0612194Z + ~~~~~~~~~~
2019-01-17T18:17:09.0612277Z CategoryInfo :NotSpecified: (:) [], RemoteException
2019-01-17T18:17:09.0612343Z FullyQualifiedErrorId :NativeCommandErrorMessage
2019-01-17T18:17:09.0612443Z ---> System.Management.Automation.RemoteException: *** Could not deploy package.
2019-01-17T18:17:09.0613006Z --- End of inner exception stack trace ---
2019-01-17T18:17:09.0613152Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Deployment.PowershellExecutor.Invoke(String errorContextMessage, Boolean writeResultToLog, Boolean isCancellable, ActionPreference errorActionPreference)
2019-01-17T18:17:09.0613307Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Deployment.ScriptExecutor.ExecuteScript(IPowerShell powerShell, String script, String arguments, Boolean isScriptDotSourced, Boolean useHttp)
2019-01-17T18:17:09.0613493Z at Microsoft.VisualStudio.Services.DevTestLabs.RemoteDeployer.Deployment.DeploymentService.RunPowerShellScripts(DeploymentMachineSpecification deploymentMachine, ScriptSpecification scriptSpecification, ScriptSpecification initializationScriptSpecification, String applicationPath, IPowerShell powerShellSession)
2019-01-17T18:17:09.0614001Z ---> (Inner Exception #0) System.Management.Automation.RemoteException: *** Could not deploy package.<---
2019-01-17T18:17:09.0614088Z
2019-01-17T18:17:09.0614189Z ---> (Inner Exception #1) System.Management.Automation.RemoteException: Warning SQL71005: Error validating element [dbo].[uspICUnpostFIFOIn]: The reference to the column Changes.Action could not be resolved.
2019-01-17T18:17:09.0614313Z Warning SQL71005: Error validating element [dbo].[uspICUnpostFIFOInFromStorage]: The ref<---
2019-01-17T18:17:09.0614364Z
2019-01-17T18:17:09.0614441Z ---> (Inner Exception #2) System.Management.Automation.RemoteException: erence to the column Changes.Action could not be resolved.
2019-01-17T18:17:09.0614567Z Warning SQL71005: Error validating element [dbo].[uspICUnpostLIFOIn]: The reference to the column Changes.action could not be resolved.
2019-01-17T18:17:09.0614818Z Warning SQL71005: Error validating element [dbo].[uspICUnpo<---
2019-01-17T18:17:09.0614862Z
2019-01-17T18:17:09.0614965Z ---> (Inner Exception #3) System.Management.Automation.RemoteException: stLotIn]: The reference to the column Changes.Action could not be resolved.
2019-01-17T18:17:09.0615065Z Warning SQL71005: Error validating element [dbo].[uspICUnpostLotInFromStorage]: The reference to the column Changes.Action could not be resolved.
2019-01-17T18:17:09.0615167Z Warning SQL72015: The column [db<---
2019-01-17T18:17:09.0615210Z
2019-01-17T18:17:09.0615293Z ---> (Inner Exception #4) System.Management.Automation.RemoteException: o].[tblSMUserSecurityMenuFavorite].[intUserSecurityId] is being dropped, data loss could occur.
2019-01-17T18:17:09.0615495Z Warning SQL72030: If this deployment is executed, changes to [dbo].[uspCMImportBanksFromOrigin] might introduce run-time errors in [dbo].[uspEMImportCustomerEF<---
2019-01-17T18:17:09.0615561Z
2019-01-17T18:17:09.0615628Z ---> (Inner Exception #5) System.Management.Automation.RemoteException: TInfo].
2019-01-17T18:17:09.0615748Z Warning SQL72030: If this deployment is executed, changes to [dbo].[uspCMImportBanksFromOrigin] might introduce run-time errors in [dbo].[uspEMImportEmployees].
2019-01-17T18:17:09.0615837Z Warning SQL72030: If this deployment is executed, changes to [dbo].[uspARCreatePrePay<---
2019-01-17T18:17:09.0615907Z
2019-01-17T18:17:09.0615985Z ---> (Inner Exception #6) System.Management.Automation.RemoteException: ment] might introduce run-time errors in [dbo].[uspARImportPayments].
2019-01-17T18:17:09.0616083Z Warning SQL72030: If this deployment is executed, changes to [dbo].[uspAPPostPayment] might introduce run-time errors in [dbo].[uspAPPostOriginPayment].
2019-01-17T18:17:09.0616192Z Error SQL72014: .Net SqlClient <---
2019-01-17T18:17:09.0616233Z
2019-01-17T18:17:09.0616361Z ---> (Inner Exception #7) System.Management.Automation.RemoteException: Data Provider: Msg 205, Level 16, State 1, Procedure vyuAPReceivedItems, Line 4 All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
2019-01-17T18:17:09.0616467Z Error SQL72045: Script execution error. The e<---
2019-01-17T18:17:09.0616510Z
2019-01-17T18:17:09.0616615Z ---> (Inner Exception #8) System.Management.Automation.RemoteException: xecuted script:
2019-01-17T18:17:09.0616686Z ALTER VIEW [dbo].[vyuAPReceivedItems]
2019-01-17T18:17:09.0616771Z AS
2019-01-17T18:17:09.0616850Z SELECT CAST (ROW_NUMBER() OVER (ORDER BY intInventoryShipmentItemId, intInventoryReceiptItemId, intPurchaseDetailId) AS INT) AS intReceivedItemId,
2019-01-17T18:17:09.0616947Z Items.*
2019-01-17T18:17:09.0617008Z FROM (SELECT A.[intEntityVendo<---
2019-01-17T18:17:09.0617070Z
2019-01-17T18:17:09.0617254Z ---> (Inner Exception #9) System.Management.Automation.RemoteException: rId] AS [intEntityVendorId],
2019-01-17T18:17:09.0617328Z A.dtmDate AS [dtmDate],
2019-01-17T18:17:09.0617405Z A.strReference AS [strReference],
2019-01-17T18:17:09.0617501Z tblReceived.strReceiptNumber AS [strSourceNumber],
2019-01-17T18:17:09.0617651Z A.strPurchaseOrderNumber AS [strPurchaseOrderNumber],
2019-01-17T18:17:09.0617818Z <---
2019-01-17T18:17:09.0617871Z
2019-01-17T18:17:09.0617939Z ---> (Inner Exception #10) System.Management.Automation.RemoteException:
2019-01-17T18:17:09.0618036Z B.intPurchaseDetailId AS [intPurchaseDetailId],
2019-01-17T18:17:09.0618104Z B.intItemId AS [intItemId],
2019-01-17T18:17:09.0618173Z B.strMiscDescription AS [strMiscDescription],
2019-01-17T18:17:09.0618263Z C.strItemNo AS [strItemNo],
2019-01-17T18:17:09.0618338Z C.strDescription AS [strDe<---
2019-01-17T18:17:09.0618379Z
2019-01-17T18:17:09.0618469Z ---> (Inner Exception #11) System.Management.Automation.RemoteException: scription],
2019-01-17T18:17:09.0618619Z NULL AS [intPurchaseTaxGroupId],
2019-01-17T18:17:09.0618710Z tblReceived.dblOrderQty AS [dblOrderQty],
2019-01-17T18:17:09.0618783Z tblReceived.dblPOOpenReceive AS [dblPOOpenReceive],
2019-01-17T18:17:09.0618856Z tblReceived.dblOpenReceive AS [dblOpenReceive],
2019-01-17T18:17:09.0618943Z <---
2019-01-17T18:17:09.0618978Z
2019-01-17T18:17:09.0619046Z ---> (Inner Exception #12) System.Management.Automation.RemoteException: (tblRe
2019-01-17T18:17:09.0619117Z
2019-01-17T18:17:09.0619167Z <---
2019-01-17T18:17:09.0619200Z
2019-01-17T18:17:09.0619231Z
2019-01-17T18:17:09.0641926Z Deployment status for machine 'i21server.eastus.cloudapp.azure.com:5986' : 'Failed'
2019-01-17T18:17:09.1070257Z
2019-01-17T18:17:09.1070374Z
{color:#ff0000}2019-01-17T18:17:09.2478105Z ##[error]System.Management.Automation.RuntimeException: *** Could not deploy package.Warning SQL71005: Error validating element [dbo].[uspICUnpostFIFOIn]: The reference to the column Changes.Action could not be resolved.{color}
2019-01-17T18:17:09.2478979Z Warning SQL71005: Error validating element [dbo].[uspICUnpostFIFOInFromStorage]: The reference to the column Changes.Action could not be resolved.
2019-01-17T18:17:09.2479756Z Warning SQL71005: Error validating element [dbo].[uspICUnpostLIFOIn]: The reference to the column Changes.action could not be resolved.
2019-01-17T18:17:09.2480279Z Warning SQL71005: Error validating element [dbo].[uspICUnpostLotIn]: The reference to the column Changes.Action could not be resolved.
2019-01-17T18:17:09.2480769Z Warning SQL71005: Error validating element [dbo].[uspICUnpostLotInFromStorage]: The reference to the column Changes.Action could not be resolved.
2019-01-17T18:17:09.2481235Z Warning SQL72015: The column [dbo].[tblSMUserSecurityMenuFavorite].[intUserSecurityId] is being dropped, data loss could occur.
2019-01-17T18:17:09.2481953Z Warning SQL72030: If this deployment is executed, changes to [dbo].[uspCMImportBanksFromOrigin] might introduce run-time errors in [dbo].[uspEMImportCustomerEFTInfo].
2019-01-17T18:17:09.2482443Z Warning SQL72030: If this deployment is executed, changes to [dbo].[uspCMImportBanksFromOrigin] might introduce run-time errors in [dbo].[uspEMImportEmployees].
2019-01-17T18:17:09.2482897Z Warning SQL72030: If this deployment is executed, changes to [dbo].[uspARCreatePrePayment] might introduce run-time errors in [dbo].[uspARImportPayments].
2019-01-17T18:17:09.2483371Z Warning SQL72030: If this deployment is executed, changes to [dbo].[uspAPPostPayment] might introduce run-time errors in [dbo].[uspAPPostOriginPayment].
2019-01-17T18:17:09.2483847Z Error SQL72014: .Net SqlClient Data Provider: Msg 205, Level 16, State 1, Procedure vyuAPReceivedItems, Line 4 All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
{color:#ff0000}2019-01-17T18:17:09.2484559Z Error SQL72045: Script execution error. The executed script:
2019-01-17T18:17:09.2485006Z ALTER VIEW [dbo].[vyuAPReceivedItems]{color}
2019-01-17T18:17:09.2485405Z AS
2019-01-17T18:17:09.2485845Z SELECT CAST (ROW_NUMBER() OVER (ORDER BY intInventoryShipmentItemId, intInventoryReceiptItemId, intPurchaseDetailId) AS INT) AS intReceivedItemId,
2019-01-17T18:17:09.2486249Z Items.*
2019-01-17T18:17:09.2486675Z FROM (SELECT A.[intEntityVendorId] AS [intEntityVendorId],
2019-01-17T18:17:09.2487071Z A.dtmDate AS [dtmDate],
2019-01-17T18:17:09.2487518Z A.strReference AS [strReference],
2019-01-17T18:17:09.2487960Z tblReceived.strReceiptNumber AS [strSourceNumber],
2019-01-17T18:17:09.2488390Z A.strPurchaseOrderNumber AS [strPurchaseOrderNumber],
2019-01-17T18:17:09.2488825Z B.intPurchaseDetailId AS [intPurchaseDetailId],
2019-01-17T18:17:09.2489240Z B.intItemId AS [intItemId],
2019-01-17T18:17:09.2489661Z B.strMiscDescription AS [strMiscDescription],
2019-01-17T18:17:09.2490873Z C.strItemNo AS [strItemNo],
2019-01-17T18:17:09.2491310Z C.strDescription AS [strDescription],
2019-01-17T18:17:09.2491707Z NULL AS [intPurchaseTaxGroupId],
2019-01-17T18:17:09.2492104Z tblReceived.dblOrderQty AS [dblOrderQty],
2019-01-17T18:17:09.2492996Z tblReceived.dblPOOpenReceive AS [dblPOOpenReceive],
2019-01-17T18:17:09.2493499Z tblReceived.dblOpenReceive AS [dblOpenReceive],
2019-01-17T18:17:09.2493930Z (tblRe
2019-01-17T18:17:09.2494302Z
2019-01-17T18:17:09.2494727Z ---> System.Management.Automation.RuntimeException: *** Could not deploy package.Warning SQL71005: Error validating element [dbo].[uspICUnpostFIFOIn]: The reference to the column Changes.Action could not be resolved.
2019-01-17T18:17:09.2495827Z Warning SQL71005: Error validating element [dbo].[uspICUnpostFIFOInFromStorage]: The reference to the column Changes.Action could not be resolved.
2019-01-17T18:17:09.2496292Z Warning SQL71005: Error validating element [dbo].[uspICUnpostLIFOIn]: The reference to the column Changes.action could not be resolved.
2019-01-17T18:17:09.2496723Z Warning SQL71005: Error validating element [dbo].[uspICUnpostLotIn]: The reference to the column Changes.Action could not be resolved.
2019-01-17T18:17:09.2497517Z Warning SQL71005: Error validating element [dbo].[uspICUnpostLotInFromStorage]: The reference to the column Changes.Action could not be resolved.
2019-01-17T18:17:09.2498573Z Warning SQL72015: The column [dbo].[tblSMUserSecurityMenuFavorite].[intUserSecurityId] is being dropped, data loss could occur.
2019-01-17T18:17:09.2499258Z Warning SQL72030: If this deployment is executed, changes to [dbo].[uspCMImportBanksFromOrigin] might introduce run-time errors in [dbo].[uspEMImportCustomerEFTInfo].
2019-01-17T18:17:09.2499754Z Warning SQL72030: If this deployment is executed, changes to [dbo].[uspCMImportBanksFromOrigin] might introduce run-time errors in [dbo].[uspEMImportEmployees].
2019-01-17T18:17:09.2500261Z Warning SQL72030: If this deployment is executed, changes to [dbo].[uspARCreatePrePayment] might introduce run-time errors in [dbo].[uspARImportPayments].
2019-01-17T18:17:09.2501016Z Warning SQL72030: If this deployment is executed, changes to [dbo].[uspAPPostPayment] might introduce run-time errors in [dbo].[uspAPPostOriginPayment].
2019-01-17T18:17:09.2501541Z Error SQL72014: .Net SqlClient Data Provider: Msg 205, Level 16, State 1, Procedure vyuAPReceivedItems, Line 4 All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
2019-01-17T18:17:09.2502395Z Error SQL72045: Script execution error. The executed script:
2019-01-17T18:17:09.2503433Z ALTER VIEW [dbo].[vyuAPReceivedItems]
2019-01-17T18:17:09.2504350Z AS
2019-01-17T18:17:09.2504971Z SELECT CAST (ROW_NUMBER() OVER (ORDER BY intInventoryShipmentItemId, intInventoryReceiptItemId, intPurchaseDetailId) AS INT) AS intReceivedItemId,
2019-01-17T18:17:09.2505442Z Items.*
2019-01-17T18:17:09.2505919Z FROM (SELECT A.[intEntityVendorId] AS [intEntityVendorId],
2019-01-17T18:17:09.2506854Z A.dtmDate AS [dtmDate],
2019-01-17T18:17:09.2509588Z A.strReference AS [strReference],
2019-01-17T18:17:09.2510477Z tblReceived.strReceiptNumber AS [strSourceNumber],
2019-01-17T18:17:09.2510834Z A.strPurchaseOrderNumber AS [strPurchaseOrderNumber],
2019-01-17T18:17:09.2511004Z B.intPurchaseDetailId AS [intPurchaseDetailId],
2019-01-17T18:17:09.2511075Z B.intItemId AS [intItemId],
2019-01-17T18:17:09.2511172Z B.strMiscDescription AS [strMiscDescription],
2019-01-17T18:17:09.2511242Z C.strItemNo AS [strItemNo],
2019-01-17T18:17:09.2511324Z C.strDescription AS [strDescription],
2019-01-17T18:17:09.2511416Z NULL AS [intPurchaseTaxGroupId],
2019-01-17T18:17:09.2511484Z tblReceived.dblOrderQty AS [dblOrderQty],
2019-01-17T18:17:09.2511753Z tblReceived.dblPOOpenReceive AS [dblPOOpenReceive],
2019-01-17T18:17:09.2511828Z tblReceived.dblOpenReceive AS [dblOpenReceive],
2019-01-17T18:17:09.2511973Z (tblRe
2019-01-17T18:17:09.2512012Z
2019-01-17T18:17:09.2512046Z
2019-01-17T18:17:09.2512101Z --- End of inner exception stack trace ---
2019-01-17T18:17:09.2512200Z at System.Management.Automation.Runspaces.PipelineBase.Invoke(IEnumerable input)
2019-01-17T18:17:09.2512289Z at System.Management.Automation.PowerShell.Worker.ConstructPipelineAndDoWork(Runspace rs, Boolean performSyncInvoke)
2019-01-17T18:17:09.2512402Z at System.Management.Automation.PowerShell.Worker.CreateRunspaceIfNeededAndDoWork(Runspace rsToUse, Boolean isSync)
2019-01-17T18:17:09.2512576Z at System.Management.Automation.PowerShell.CoreInvokeHelper[TInput,TOutput](PSDataCollection`1 input, PSDataCollection`1 output, PSInvocationSettings settings)
2019-01-17T18:17:09.2512690Z at System.Management.Automation.PowerShell.CoreInvoke[TInput,TOutput](PSDataCollection`1 input, PSDataCollection`1 output, PSInvocationSettings settings)
2019-01-17T18:17:09.2512810Z at Microsoft.TeamFoundation.DistributedTask.Handlers.LegacyVSTSPowerShellHost.VSTSPowerShellHost.Main(String[] args)
2019-01-17T18:17:09.2683450Z ##[error]LegacyVSTSPowerShellHost.exe completed with return code: -1.
2019-01-17T18:17:09.2684945Z ##[section]Finishing: Run i21Database.dacpac
|