[ts-gen] trading database error message

Bill Pippin pippin at owlriver.net
Thu Apr 16 17:30:37 EDT 2009


Nils,

> when I try to switch to the trading database I - which should be
> initially a 1-1 copy of the testing database as I understand it - I am
> facing the following errors:

Almost but not quite.  Setup inserts a few regression test order
templates into the table Testing.Template, but not into
Trading.Template .  The reason for this distinction is that you are
supposed to be responsible for the decision to be actively trading
for real money, and you are supposed to choose the order Template
flags and other parameters yourself.

> Any hints on ... messages? 

The following is definitely a failure to find an order template
record; the type tag TmpE calls for a template lookup action:

> Process rule: NonInput (TmpE)
> Process rule: Compound (ProtoCreate)
> Syntax error:
> Grammar rule: Compound ProtoCreate
> Cursor state: match; text is:

I can't tell from the the other messages if there are additional
problems; missing template records are serious enough that
everything following becomes suspect.

There might be something else as well, say missing symbols between
testing and trading, if you've updated one and not the other.
The script setup.sql creates both databases, and populates tables
as well; the script create.sql just recreates and populates tables
for a given database. 

In addition, cross-session order manipulation depends on an
existing and up-to-date journal, which will be in whichever
database your .shimrc config file told the shim to connect
with.

So, the three legitimate reasons for differences are template
differentiation, user-added symbols, and journal history.
A fourth, less specific problem might possibly be some sort of
version creep due to, say, manual fixes to one database and
not the other.

Thanks,

Bill



More information about the ts-general mailing list