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