Обсуждение: Error application using Powerbuilder 7 and postgresql 7.3

Hai..
I introduce myself, my name : Agus, from Indonesia.
Im develop application using POwerbuilder 7 and postgresql 7.3.

I have serveral error, and cannot solve yet. Anybody help me?

This is the error :
1. When I connecct postgresql using powerbuilder , there is message like
this ...
Catalog tables could not be created and are not available for use
Why ?

2.  When I login to my application , sometimes raise error like this...
SQLSTATE = 28000
FATAL : Sorry, too many clients already

Why? What is the solution

2. There are 5000 rows, then there are report call query like this
SELECT  so_hd.*
          so_dt.kd_barang ,
          so_dt.qty_kecil ,
          so_dt.harga ,
          so_dt.mod_date ,
          so_dt.user_id ,
          so_dt.no_so ,
          so_dt.qty_besar ,
          so_dt.outstanding_qty_besar ,
          so_dt.outstanding_qty_kecil ,
          so_dt.kd_kelompok_brg ,
          so_dt.price_list ,
          so_dt.potongan ,
          so_dt.jumlah ,
          so_dt.keterangan ,
          so_dt.disc_total ,
          mst_salesman.nama_salesman ,
          so_dt.disc ,
          mst_salesman.komisi ,
          mst_barang.kd_satuan ,
          po_dt.disc ,
          po_dt.harga        FROM {oj so_hd  LEFT OUTER JOIN so_dt  ON
so_hd.no_so = so_dt.no_so} ,
          mst_barang ,
          mst_salesman ,
          po_dt          WHERE ( so_dt.kd_barang = mst_barang.kd_barang
) and          ( so_dt.kd_kelompok_brg = mst_barang.kd_kelompok_brg )
and          ( so_hd.kd_salesman = mst_salesman.kd_salesman )
and          ( so_dt.no_so = po_dt.no_so ) and          (
so_dt.kd_barang = po_dt.kd_barang ) and          ( so_dt.kd_kelompok_brg
= po_dt.kd_kelompok_brg ) and          ( ( so_hd.tgl_so >= :adt_tgl1 )
and          ( so_hd.tgl_so <= :adt_tgl2 ) and          ( so_hd.closed =
'1' ) )

when running aplication call this report, application become hang. Why ?
there is solution?

4.  There are some  report become hang . The transaction is few but
design report using sub report. Is it cause hang?
is there the solustion ?


3. There is error like this...
Sybase Inc. Product File has encountered a problem and needs to close

When I using report window for query and access thousand record
transcaction. Why ? Any suggestion


thx

Agus

agus liem wrote:
> Hai..
> I introduce myself, my name : Agus, from Indonesia.
> Im develop application using POwerbuilder 7 and postgresql 7.3.
>
> I have serveral error, and cannot solve yet. Anybody help me?

Hi Agus, I'll do my best.

> This is the error :
> 1. When I connecct postgresql using powerbuilder , there is message like
> this ...
> Catalog tables could not be created and are not available for use
> Why ?

Don't know. This doesn't sound like a PostgreSQL error - is it something
from PowerBuilder? You'll have to turn statement logging on in the
postgresql.conf file and see what sql is being sent unless powerbuilder
can tell you more. Details on setting statement logging are in the manuals.

> 2.  When I login to my application , sometimes raise error like this...
> SQLSTATE = 28000
> FATAL : Sorry, too many clients already
>
> Why? What is the solution

It sounds like you have too many connections. How many do you have, and
is this larger than the limit set in postgresql.conf? Details in the
manuals.

> 2. There are 5000 rows, then there are report call query like this
> SELECT  so_hd.*
[snip]
>
> when running aplication call this report, application become hang. Why ?
> there is solution?

Don't know. Is the database doing anything? What do ps and top show? Are
there any errors recorded in postgresql's logs?

> 4.  There are some  report become hang . The transaction is few but
> design report using sub report. Is it cause hang?
> is there the solustion ?

What do the logs show? What hangs? What transactions would you be using
to create a report?

> 3. There is error like this...
> Sybase Inc. Product File has encountered a problem and needs to close

I'm not sure what relevance a "Sybase Inc. Product File" has to
postgresql - it's presumably something to do with Sybase.

> When I using report window for query and access thousand record
> transcaction. Why ? Any suggestion

Sorry - I don't understand what you mean here. What I'd suggest is:

1. Pick one problem (to start with)
2. Turn statement-logging on in the postgresql.conf file
3. Restart the database
4. Reproduce the problem
5. Post details here, along with any errors/warnings in the logs.

--
   Richard Huxton
   Archonet Ltd