Error on Strategy triggering

[richa61416]

Hello, I get the following error when my strategy triggers, can you tell me what the following message relates to? Please note as far as I can see, I am not pasting anything. The strategy continues to run however.

Failed to execute DB job 'OrderUpdateJob': The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.

[NinjaTrader_Dierk]

How long are the signal names on your strategy?

[richa61416]

Here is the log generated. The Green are the error messages on my screen. The other strategy doesn't trigger this error, as you can see from the log. The strategy that generates the error, was done in the wizard.
10:40DefaultFailed to execute DB job 'OrderUpdateJob': The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.07/24/2007 10:40OrderOrder='3698439/XXXXXXXX' Name='Stop loss' New State=Cancelled Instrument='YM 09-07' Action=Sell Limit price=0 Stop price=13896 Quantity=1 Type=Stop Filled=0 Fill price=0 Error=NoError Native error=''07/24/2007 10:40DefaultFailed to execute DB job 'OrderUpdateJob': The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.07/24/2007 10:40DefaultFailed to execute DB job 'OrderUpdateJob': The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.07/24/2007 10:40PositionInstrument='YM 09-07' Account='XXXXXXXX' Avg price=0 Quantity=0 Market position=Flat Operation=Remove Currency=UsDollar07/24/2007 10:40ExecutionExecution='eCBOT 001708363602883001278700372 20070724000000040830' Instrument='YM 09-07' Account='XXXXXXXX' Exchange=ECbot Price=13961 Quantity=1 Market position=Short Operation=Insert Order='3698440' Time='07/24/2007 10:40:09 AM'07/24/2007 10:40OrderOrder='3698439/XXXXXXXX' Name='Stop loss' New State=PendingCancel Instrument='YM 09-07' Action=Sell Limit price=0 Stop price=13896 Quantity=1 Type=Stop Filled=0 Fill price=0 Error=NoError Native error=''07/24/2007 10:40OrderOrder='3698440/XXXXXXXX' Name='Profit target' New State=Filled Instrument='YM 09-07' Action=Sell Limit price=13961 Stop price=0 Quantity=1 Type=Limit Filled=1 Fill price=13961 Error=NoError Native error=''07/24/2007 9:50DefaultFailed to execute DB job 'OrderUpdateJob': The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.07/24/2007 9:50DefaultFailed to execute DB job 'OrderUpdateJob': The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.07/24/2007 9:50OrderOrder='3698439/XXXXXXXX' Name='Stop loss' New State=Working Instrument='YM 09-07' Action=Sell Limit price=0 Stop price=13896 Quantity=1 Type=Stop Filled=0 Fill price=0 Error=NoError Native error=''07/24/2007 9:50OrderOrder='3698439/XXXXXXXX' Name='Stop loss' New State=Accepted Instrument='YM 09-07' Action=Sell Limit price=0 Stop price=13896 Quantity=1 Type=Stop Filled=0 Fill price=0 Error=NoError Native error=''07/24/2007 9:50OrderOrder='3698440/XXXXXXXX' Name='Profit target' New State=Working Instrument='YM 09-07' Action=Sell Limit price=13961 Stop price=0 Quantity=1 Type=Limit Filled=0 Fill price=0 Error=NoError Native error=''07/24/2007 9:50OrderOrder='3698440/XXXXXXXX' Name='Profit target' New State=Accepted Instrument='YM 09-07' Action=Sell Limit price=13961 Stop price=0 Quantity=1 Type=Limit Filled=0 Fill price=0 Error=NoError Native error=''07/24/2007 9:50DefaultFailed to execute DB job 'OrderUpdateJob': The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.07/24/2007 9:50DefaultFailed to execute DB job 'OrderUpdateJob': The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.07/24/2007 9:50OrderOrder='3698440/XXXXXXXX' Name='Profit target' New State=PendingSubmit Instrument='YM 09-07' Action=Sell Limit price=13961 Stop price=0 Quantity=1 Type=Limit Filled=0 Fill price=0 Error=NoError Native error=''07/24/2007 9:50OrderOrder='3698439/XXXXXXXX' Name='Stop loss' New State=PendingSubmit Instrument='YM 09-07' Action=Sell Limit price=0 Stop price=13896 Quantity=1 Type=Stop Filled=0 Fill price=0 Error=NoError Native error=''07/24/2007 9:50PositionInstrument='YM 09-07' Account='XXXXXXXX' Avg price=13919 Quantity=1 Market position=Long Operation=Insert Currency=UsDollar07/24/2007 9:50ExecutionExecution='eCBOT 001708333602883001278700369 20070724000000035306' Instrument='YM 09-07' Account='XXXXXXXX' Exchange=ECbot Price=13919 Quantity=1 Market position=Long Operation=Insert Order='3698438' Time='07/24/2007 9:50:00 AM'07/24/2007 9:50OrderOrder='3698438/XXXXXXXX' Name='Buy' New State=Filled Instrument='YM 09-07' Action=Buy Limit price=0 Stop price=0 Quantity=1 Type=Market Filled=1 Fill price=13919 Error=NoError Native error=''07/24/2007 9:50OrderOrder='3698438/XXXXXXXX' Name='Buy' New State=Working Instrument='YM 09-07' Action=Buy Limit price=0 Stop price=0 Quantity=1 Type=Market Filled=0 Fill price=0 Error=NoError Native error=''07/24/2007 9:50OrderOrder='3698438/XXXXXXXX' Name='Buy' New State=Accepted Instrument='YM 09-07' Action=Buy Limit price=0 Stop price=0 Quantity=1 Type=Market Filled=0 Fill price=0 Error=NoError Native error=''07/24/2007 9:50OrderOrder='3698438/XXXXXXXX' Name='Buy' New State=PendingSubmit Instrument='YM 09-07' Action=Buy Limit price=0 Stop price=0 Quantity=1 Type=Market Filled=0 Fill price=0 Error=NoError Native error=''07/24/2007 9:20StrategyStop/target handling for strategy 'ReversalKey' set to 'ByStrategyPosition' since currency based stop order was placed.



Here are the name, and Entry and Exit signals used.




[Description("Enter the description of your strategy here")]
[Gui.Design.DisplayName("Stockn")]
publicclass StockN : Strategy

EnterLong(DefaultQuantity, "");

/
ExitLong("", "");
}

[NinjaTrader_Dierk]

Sorry, the information you pasted in is unreadable.

Let's try something different:
- is the problem reproducible? If so: Please provide detailed steps on how to reproduce.
- could you please attach your strategy?
- could you please attach a screenshot of your strategy settings?

Thanks

[NinjaTrader_Dierk]

Also: I suppose you are on latest NT6R3, no?

[richa61416]

I am on the latest release.
I will see if I can recreate the problem with a different strategy, that I would be comfortable sharing.
The problem only happens in real time, not back testing.

[NinjaTrader_Dierk]

Great. I suspect the problem is related to a signal name longer than 50 chars.

[richa61416]

OK. I am still getting this. The problem is not the signal name length as the lenth is less than 10. Is there a way I could debug this to determine what field it is trying to insert data into, and what is that data it is trying to insert?

I have the latest version of Ninja. There error happens on ALL strategies I create, AND ONLY appears when you are ACTUALLY trading. Back testing with not display this message.

[NinjaTrader_Dierk]

- backtest does not insert trades into your DB
- unfortunately there is no way to debug this

Does it even happen in the default sample strategies? If so, then your DB is corrupted. Please try Tools->Options->Misc->Repair DB

[richa61416]

I will check and see.