Using Sybase with Powerhouse

[Steve Franklin]

The QTP code is quite simple:

cancel clear

set input limit 400

run LoadImportBillings

Request CreateBillings

access *$STWIMPORT/import_billing

output bl_billings add
	item customer_sort_name final CustomerSortName
	item service_date final nconvert(ServiceDate)
	item service_sequence final t-seq
	item application_code final AppCode
	item employee_number final employee_number of import_billing
	item total_hours final nconvert(units)	* 100
	item hours_to_bill final nconvert(units) * 100
	item amount_to_bill final nconvert(Amount) * 100
	item processed_by_billing final Billed
	item billed_date final nconvert(BilledDate)
	item work_performed1 final t-work-performed1
	item work_performed2 final t-work-performed2
	item printed_work_performed1 final t-work-performed1
	item printed_work_performed2 final t-work-performed2
	item date_modified final sysdate
	item userid_modified final logonid
build


The Error is the following.

[SQL Server: ] Can't allocate space for object 'syslogs' in database
'billing'
because 'logsegment' segment is full/has no free extents. If you ran out of
space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or
sp_extendsegment to increase size of the segment.
   File:  bl_billings
     Linkitem:  customer_sort_name               JASPER
     Linkitem:  service_date                     02/28/1998 00:00:00
     Linkitem:  service_sequence                    3
     Linkitem:  processed_by_billing             Y



-----Original Message-----
From: John Penney [mailto:JPENNEY@co.pierce.wa.us]
Sent: Monday, October 22, 2001 4:06 PM
To: steve_franklin@yahoo.com
Subject: Re: Using Sybase with Powerhouse


Hey, Steve, snippet of the source code, and a copy of the error message
would help.

QTP does commits to Relational Databases either explicitly using COMMIT
syntax or by default at end-of-run IIRC, i.e. by record, or entire QTP
run/Request.



John M Penney
Systems Programmer
Production Services
Information Services Department
Pierce County
Tacoma, WA
253-798-6215
jpenney@co.pierce.wa.us

>>> "Steve Franklin" <steve_franklin@yahoo.com> 10/22/01 01:39PM >>>
 I have been trying to use Sybase ASE 11.9.2 with Axiant 3.0 and the
database I have defined keeps getting  errors that the syslog is full.  This
occurs while trying to add data to one table in a QTP job.  Does anyone know
how QTP inserts data into a Sybase table.  Is in one SQL Insert per record,
or is it batched into one transaction?  My log file is almost as big as my
database.  Normally the log is about 25% the size of the database.  The
table in question does not have any blob type columns.

Thanks for any insight you have on this issue.

Steve

Steve Franklin
Stw Inc.
Email: steve_franklin@yahoo.com



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com