Announcement

Collapse
No announcement yet.

Partner 728x90

Collapse

Failed to Execute error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Failed to Execute error

    I am using Ver 5.0.1000.7. I placed an order to the PATsystems and the order failed with the following message in an error window:

    Failed to executeDB job 'StrategyUpdateJob':You cannot add or change a record because a related record is required in table 'nt_strategy'

    What do I do know?

    Warren

    #2
    imported post

    Tools-->Options, Misc tab, Press repair dbase.
    RayNinjaTrader Customer Service

    Comment


      #3
      imported post

      Attached is the log file for the DB failure. It shows that an order was filled, then that the Stop was working, then the Target was rejected, then that NT arbitrarily/incorrectly cancelled my valid working Stop.

      It appears thatthere are several code issues in NT.

      The first is that a DB error occurred because the Stop was accepted and working, while the Target was rejected.

      The second is that NT incorrectly cancelled a valid working Stop.

      The third is that there was no notification from NT that a valid working order was cancelled (the Stop).

      In addition to the above, the cancellation of the valid working Stop, without authorization or input from me, resulted in a $340 loss that would not have otherwise occurred. NT only notified my that the Target had been rejected, so I was dealing with that issue with my broker, while the price blew through my stop price. By the time I was aware that NT incorrectly cancelled my valid working Stop, the result was a net additional loss of $340. Since this was caused by improper actions in NT, I am requesting re-imbursement for this loss (I am willing to forego the additional $116 I also lost by missing another trade to deal with this becausethe broker had a settings problem with the margins on my account, so it might not have happened). I am willing to accept this as a cash re-imbursement, or as credit on my Ninja Trader subscription.

      Please let me know how you would like to handle this.

      Regards,

      Warren Rosenfeld (214-460-6335)
      Attached Files

      Comment


        #4
        imported post

        Please send traces and logs (Help->Mail to support).

        Thanks
        DierkNinjaTrader Customer Service

        Comment


          #5
          imported post

          files sent

          Comment


            #6
            imported post

            We have reviewed your files. In your log it is very clear that you reached account margin limitations and thus the stops/targets were rejected which in turn cancelled the OCO tied stop order.

            Here is the part in the log.

            08:32:02:312XXXXXX Pats.Callback.Order5: pos=0 status=Rejected orderId='XXXXX' orderType='Limit' contractName='MINI R2000' price=716.3/716.3 price2=0/0 lots=1 amountFilled=0 averagePrice=0/0 status=Rejected nonExecReason='PATS host rejected due to insufficient margin'

            You can either ask your broker to increase your account limitations or reduce the lot size you trade.

            Ray
            RayNinjaTrader Customer Service

            Comment


              #7
              imported post

              OK, I understand now that this was an internal OCO issue which is why you cancelled the working STOP, so you really aren't responsible for the loss.

              Can you address the issue of the DB error?

              Also, I would highly recommend that you add an error message if there is a failure, for whatever reason, in the execution of placing the Target/Stop orders so that the trader immediately knows they have an open positionthat is not protected with a Stop. Expecting the trader to automatically assume this is probably not a good idea. I have added my own codein eSignal to recognize this condition and deal with it should the need arise.

              Comment


                #8
                imported post

                Thanks for suggestion. DB issue under investigation.
                RayNinjaTrader Customer Service

                Comment

                Latest Posts

                Collapse

                Topics Statistics Last Post
                Started by bjgjkhjuhgtybg, Today, 04:38 AM
                0 responses
                2 views
                0 likes
                Last Post bjgjkhjuhgtybg  
                Started by varun12343, Today, 03:09 AM
                1 response
                7 views
                0 likes
                Last Post NinjaTrader_Marco  
                Started by Lance El Camino, Yesterday, 04:14 PM
                2 responses
                24 views
                0 likes
                Last Post NT-Roland  
                Started by MatthewLesko, Yesterday, 11:13 PM
                1 response
                14 views
                0 likes
                Last Post NT-Roland  
                Started by kevinenergy, Today, 01:44 AM
                0 responses
                6 views
                0 likes
                Last Post kevinenergy  
                Working...
                X