Re: [osdldbt-general] NULL value in TradeCleanupFrame1

[<ma...@gm...>]

On 12/28/06, ma...@gm... <ma...@gm...> wrote:
> Hi Rilson,
>
> Have you run into this yet?  I seem to be getting null values for
> s_qty_t for every transactions.  I wanted to see if you might know
> while I start digging into the code:
>
> dbt5 - Brokerage House Main
>
> Using the following settings:
>
>         Host:                   fungcho
>         Database:               dbt5
>         Postmaster port:        5432
>         Listen port:            30000
>
> Brokerage House opened to business, waiting traders...
> pqxx SQL error: ERROR:  domain trade_t does not allow null values
> CONTEXT:  PL/pgSQL function "tradecleanupframe1" line 37 at fetch
>
> Query was: 'select * from TradeCleanupFrame1('CNCL'::char(4),'PNDG'::char(4),'SB
> MT'::char(4),232704001)'
>  at BrokerageHouse::WorkerThread
> pqxx SQL error: ERROR:  domain s_qty_t does not allow null values
> CONTEXT:  PL/pgSQL function "tradeorderframe3" line 100 at SQL statement

I'm still getting this problem.  Maybe I'm not building the database
or setting the run parameters correctly:

build-db -c 1000 -i 1000 -s 500 -w 1

run-workload -f 500 -s 100 -c 1000 -e 1 -t 900 -c 1000 -u 2

I'm hoping that either I am picking illegal parameters or that you can
reproduce is like this...

Regards,
Mark