Failed to execute DB

[trend]

Hi Dierk,
i installed beta 5 about 12 h ago. I got under the Default Category

Message

Failed to execute DB job 'ExecutionUpdateJob': A duplicate value cannot be inserted into a unique index. [ Table name = nt_execution,Constraint name = PK__nt_execution__00000000000000CC ]

several times. Never got athg like this with 6.5.
Sthg to do with SubmitOrder maybe or the new SQL DB?

Also, is there a way to push all these messages into a single window?
so that you don't have to click trhough out the day to get rid off them,

Thanks,

[NinjaTrader_JoshP]

trend,

Please try SampleMACrossOver and see if you get the same. Thanks.

[trend]

Hi Josh,
I set SampleMACrossOver for a couple of days now and
after many trades, I haven't seen the message
"Failed to execute DB job 'ExecutionUpdateJob': A duplicate value cannot be inserted into a unique index. [ Table name = nt_execution,Constraint name = PK__nt_execution__00000000000000CC ]"

but in another instance of NT and after I set reload Historical Data on a chart, while a strategy was on, the message started appearing (many times so far)

Don't know if this is a hint on this error message

thanks,

[NinjaTrader_Dierk]

To double check: you are on NT7B5?

[trend]

That's correct

[NinjaTrader_Dierk]

Thanks for checking. Could you please mail your logs and traces e.g. by Help->Mail to support, reference this thread, subject "for Dierk"? Thanls

[trend]

Hi Dierk,
I attach a small excerpt from the trace file.
I restarted the simulator yesterday evening, after
I made a change in the script (not one that would affect
the signals). So I recompiled, exited the program and restarted.
Today in the morning I realized by looking in a chart that there a was a gap in the data, so I Reloaded Historical. The script calculates on Historical, so apparently a few trades that were already executed,
were recalculated with the Reload and hence the message appeared.
I guess on restarting the simulator I should have done the Reload
before starting the simulator(?)

Further on, and after resetting and restarting scripts in the Strategies tab, ethg looked alright, till the moment that I opened a chart which plotted already executed trades. Following that, the messages as in the
attached text started appearing again. The trace shows also
Warning messages of the sort:
Db.Globals.StrategyUpdateJob2: WARNING: Execution='170efa3e09b64383a0425c26153da2e9'

where the program is trying to reinsert already executed trades in the database (?)
Could it be that bringing up the chart (NT is set for historical)
there are slight changes in the bar data (Gain does not time stamp ?)
that alters some signals?

Thanks,

[NinjaTrader_Dierk]

Thanks. Could you please send me a mail to "dierk AT ninjatrader DOT com" and reference this thread for follow up?