Error application using Powerbuilder 7 and postgresql 7.3

From: agus liem <agus_liem(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Error application using Powerbuilder 7 and postgresql 7.3
Date: 2004-06-14 16:21:47
Message-ID: 40CDD09B.8050303@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-06-14 17:15:42 Re: Error application using Powerbuilder 7 and postgresql
Previous Message Doug McNaught 2004-06-14 14:15:56 Re: HTML output