Modify order problems

Added by Andreas about 8 years ago

There is a problem when requesting an order modification:

2011-09-20 15:58:55 - PUT => https://api.test.nordnet.se/next/1/accounts/<accno>/orders/469068?price=144.3&volume=20

2011-09-20 15:58:55 - Incoming private feed of type trade: {"type":"trade","data":{"price":{"value":136.4,"curr":"SEK"},"orderID":469068,"instrumentID {"identifier":"3966","marketID":11},"tradeID":"B30736-20110920","volume":20.0,"side":"BUY","accno":<accno>,"counterparty":"MCF","tradetime":1316527134000}}

2011-09-20 15:58:55 - Result: {"message":"ORA-01400: cannot insert NULL into (\"TRADE\".\"LOGS\".\"LOGID\")\nORA-06512: at \"TRADE.PKG_TRADE_LOG\", line 37\nORA-06512: at \"TRADE.PKG_TRADE_CUST_ORDER\", line 634\nORA-20014: EXC_ORDER_DELETED\nORA-06512: at line 1\n","orderID":469068,"orderState":"DELETED","resultCode":"DATA_STORE_ERR","accNo":<accno>,"actionState":"MOD_FAIL"}


Replies (4)

RE: Modify order problems - Added by Nordnet Simon about 8 years ago

Hi, you got a trade before (in the same second) that you modified the order. So you tried to modify an order that already was deleted.

/Simon

RE: Modify order problems - Added by Andreas about 8 years ago

The problem (apart from the fact that this error message reveals details about the implementation of your system) is that the private feed stopped working after this. We never received any notification about the destiny of order 469069 (inserted at 15:58:54) for instance.

Furthermore, this once again points us to the problems discussed in this thread . What if the trade of the order would only have been a partial fill? Then the modification would have been accepted, and we would end up with to much volume traded in the order.

RE: Modify order problems - Added by Nordnet Simon about 8 years ago

[...] this error message reveals details about the implementation of your system

Yes- this is an issue. We are scetching on a solution that will fit all our systems.
[...] the private feed stopped working after this. We never received any notification about the destiny of order 469069 (inserted at 15:58:54) for instance.

This is strange. In the logs we can see that it was sent to your user. Did you receive any heartbeats or empty row or was it completely silent?

RE: Modify order problems - Added by Andreas about 8 years ago

No, nothing. But we shut down the system shortly (about 30 seconds) afterwards due to some other reasons, so maybe the messages would have arrived if we waited. Or maybe there was an error on our side in this case.

(1-4/4)