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.
Announcement
Collapse
Looking for a User App or Add-On built by the NinjaTrader community?
Visit NinjaTrader EcoSystem and our free User App Share!
Have a question for the NinjaScript developer community? Open a new thread in our NinjaScript File Sharing Discussion Forum!
Have a question for the NinjaScript developer community? Open a new thread in our NinjaScript File Sharing Discussion Forum!
See more
See less
Partner 728x90
Collapse
NinjaTrader
Error on Strategy triggering
Collapse
X
-
Error on Strategy triggering
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.Tags: None
-
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("", "");
}
Comment
-
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.
Comment
-
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.
Comment
-
Latest Posts
Collapse
Topics | Statistics | Last Post | ||
---|---|---|---|---|
Started by smartromain, 03-13-2024, 01:42 AM
|
5 responses
92 views
0 likes
|
Last Post
by AndreiBig
Today, 06:08 AM
|
||
Started by Noerclou, Today, 04:55 AM
|
0 responses
4 views
0 likes
|
Last Post
by Noerclou
Today, 04:55 AM
|
||
Started by llanqui, Yesterday, 09:59 AM
|
2 responses
17 views
0 likes
|
Last Post
by llanqui
Today, 04:00 AM
|
||
Started by ThoriSten, Today, 03:56 AM
|
0 responses
6 views
0 likes
|
Last Post
by ThoriSten
Today, 03:56 AM
|
||
Started by PhillT, 04-19-2024, 02:16 PM
|
3 responses
25 views
0 likes
|
Last Post
by mangel2000
Today, 03:04 AM
|
Comment