| Description |
*Error Log*
2018-07-12T19:36:04.9720961Z Error SQL72014: .Net SqlClient Data Provider: Msg 213, Level 16, State 1, Procedure uspRKAutoAssignFutOptTransaction, Line 48 Column name or number of supplied values does not match table definition.
2018-07-12T19:36:04.9721320Z Error SQL72045: Script execution error. The executed script:
2018-07-12T19:36:04.9721518Z ALTER PROCEDURE uspRKAutoAssignFutOptTransaction
2018-07-12T19:36:04.9721685Z @intMatchFuturesPSHeaderId INT
2018-07-12T19:36:04.9721825Z AS
2018-07-12T19:36:04.9721984Z DECLARE @strBuySell AS NVARCHAR (90);
2018-07-12T19:36:04.9722145Z DECLARE @ysnIsAutoAssign AS BIT;
2018-07-12T19:36:04.9722324Z SELECT TOP 1 @ysnIsAutoAssign = ysnIsAutoAssign
2018-07-12T19:36:04.9722489Z FROM tblRKCompanyPreference;
2018-07-12T19:36:04.9722648Z IF isnull(@ysnIsAutoAssign, 0) = 1
2018-07-12T19:36:04.9722813Z BEGIN
2018-07-12T19:36:04.9722973Z DECLARE @tblExercisedAssignedDetail TABLE (
2018-07-12T19:36:04.9723167Z RowNumber INT IDENTITY (1, 1),
2018-07-12T19:36:04.9723342Z intLFutOptTransactionId INT,
2018-07-12T19:36:04.9723509Z intSFutOptTransactionId INT);
2018-07-12T19:36:04.9723701Z INSERT INTO @tblExercisedAssignedDetail
2018-07-12T19:36:04.9723870Z SELECT intLFutOptTransactionId,
2018-07-12T19:36:04.9724048Z intSFutOptTransactionId
2018-07-12T19:36:04.9724214Z FROM tblRKMatchFuturesPSDetail
2018-07-12T19:36:04.9724400Z WHERE intMatchFuturesPSHeaderId = @intMatchFuturesPSHeaderId;
2018-07-12T19:36:04.9724629Z DECLARE @mRowNumber AS INT;
2018-07-12T19:36:04.9724797Z SELECT @mRowNumber = MIN(RowNumber)
2018-07-12T19:36:04.9724998Z FROM @tblExercisedAssignedDetail;
2018-07-12T19:36:04.9725165Z WHILE @mRowNumber IS NOT NULL
2018-07-12T19:36:04.9725324Z BEGIN
2018-07-12T19:36:04.9725529Z DECLARE @intLFutOptTransactionId AS INT = NULL;
2018-07-12T19:36:04.9725711Z DECLARE @intSFutOptTransactionI
2018-07-12T19:36:04.9725816Z
2018-07-12T19:36:04.9725929Z
2018-07-12T19:36:04.9726080Z --- End of inner exception stack trace ---
2018-07-12T19:36:04.9726286Z at System.Management.Automation.Runspaces.PipelineBase.Invoke(IEnumerable input)
2018-07-12T19:36:04.9726563Z at System.Management.Automation.PowerShell.Worker.ConstructPipelineAndDoWork(Runspace rs, Boolean performSyncInvoke)
2018-07-12T19:36:04.9726821Z at System.Management.Automation.PowerShell.Worker.CreateRunspaceIfNeededAndDoWork(Runspace rsToUse, Boolean isSync)
2018-07-12T19:36:04.9727204Z at System.Management.Automation.PowerShell.CoreInvokeHelper[TInput,TOutput](PSDataCollection`1 input, PSDataCollection`1 output, PSInvocationSettings settings)
2018-07-12T19:36:04.9727510Z at System.Management.Automation.PowerShell.CoreInvoke[TInput,TOutput](PSDataCollection`1 input, PSDataCollection`1 output, PSInvocationSettings settings)
2018-07-12T19:36:04.9728060Z at Microsoft.TeamFoundation.DistributedTask.Handlers.LegacyVSTSPowerShellHost.VSTSPowerShellHost.Main(String[] args)
!pastedImage_d101046_0.png!
|