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
