Immigration Financial Information Bangladesh Gateway General World Cup Entertainment Programing University and College Scholarship Job Interview Health Job
Showing posts with label vector. Show all posts
Showing posts with label vector. Show all posts

Monday, December 7, 2009

VECTOR MQT problem

Problem:
There are values in MATCH_Q_TRAN table but there is no value in BUSY_SCRIPS_TRAN table.
Solution:
Update MatchCopyNo in MATCH_Q_TRAN table for that scrip with the value = 0

Symptom:
There were two values in MATCH_Q_TRAN which were not in BUSY_SCRIP table.
These values were not executing.
Occured after deletion of 57 scrips.It didn't come in MOCK session but occured in live on next day.

Solution:
MatchCopyNo is updated to 9 and ran 9th copy of HMserver manually.

==============================================================================================

1> select * from MATCH_Q_TRAN;
RecId ScripId XactId XactType TradingMode BSFlag
DtTime BPrice BTotalQty
BReplenishQty BPendQty SPrice STotalQty
SReplenishQty SPendQty BrokerCd TraderCd ClientCd OrderDuration
TillDtTime MatchCopyNo LastBTradeId LastSTradeId
TradeSessNo ReferenceCd ShortSellFlag
-------------------- ----------- ----------- -------- ----------- ------
-------------------------- ------------------------ -----------
------------- ----------- ------------------------ -----------
------------- ----------- -------- -------- -------- -------------
-------------------------- ----------- ------------ ------------
----------- -------------- -------------
25888.000000 23004 15960 D H S
Dec 8 2009 1:14PM 0.00 0
0 0 4,320,000.00 200
100 100 SES CTG01 CTG421 GFD
Jan 1 1900 12:00AM 2 0 0
1 NULL N
26798.000000 32009 21378 L H S
Dec 8 2009 1:20PM 0.00 0
0 0 3,722,000.00 500
0 500 SHLCT DHK01 875 GFD
Dec 8 2009 1:20PM 1 0 0
1 NULL N