Using Sybase with Powerhouse
Steve Franklin
steve_franklin@yahoo.com
Tue, 23 Oct 2001 07:56:57 -0500
This is a multi-part message in MIME format.
------=_NextPart_000_0039_01C15B98.4AC36300
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
Thanks for the suggestions. I changed the commit to 1 and that helped some.
I still fill the log quickly, but not quite as quick. I am going to work
with Sybase to see if I can execute a stored procedure to clear the log.
-----Original Message-----
From: Jon.Kvisli@lindorffapplications.com
[mailto:Jon.Kvisli@lindorffapplications.com]
Sent: Tuesday, October 23, 2001 1:43 AM
To: Steve Franklin
Subject: RE: Using Sybase with Powerhouse
Suggestion 1: Try truncate/dump log in Sybase (DBA task)
Suggestion 2: Try using COMMIT AT 100 (or less) TRANSCATIONS in QTP
Jon Kvisli
----------------------------------------------
Senior systemkonsulent
Lindorff Applications as
Hellandtunet forsknings- og næringssenter
Postboks 4, 3833 Bø i Telemark
tlf: 35 06 15 71
fax: 35 06 15 01
e-post: jon.kvisli@lindorffapplications.com
www.lindorffapplications.com
----------------------------------------------
"Steve Franklin" <steve_franklin@yahoo.com>
Sent by: powerh-l-admin@cube.swau.edu
22.10.2001 23:23
To: "'John Penney'" <JPENNEY@co.pierce.wa.us>
cc: <powerh-l@lists.swau.edu>
Subject: RE: Using Sybase with Powerhouse
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
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
------=_NextPart_000_0039_01C15B98.4AC36300
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4807.2300" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D785315412-23102001><FONT face=3DVerdana =
color=3D#0000ff=20
size=3D2>Thanks for the suggestions. I changed the commit to 1 and =
that=20
helped some. I still fill the log quickly, but not quite as =
quick. I=20
am going to work with Sybase to see if I can execute a stored procedure =
to clear=20
the log.</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B>=20
Jon.Kvisli@lindorffapplications.com=20
[mailto:Jon.Kvisli@lindorffapplications.com]<BR><B>Sent:</B> Tuesday, =
October=20
23, 2001 1:43 AM<BR><B>To:</B> Steve Franklin<BR><B>Subject:</B> RE: =
Using=20
Sybase with Powerhouse<BR><BR></FONT></DIV><BR><FONT face=3Dsans-serif =
size=3D2>Suggestion 1: Try truncate/dump log in Sybase (DBA =
task)</FONT>=20
<BR><FONT face=3Dsans-serif size=3D2>Suggestion 2: Try using COMMIT AT =
100 (or=20
less) TRANSCATIONS in QTP</FONT> <BR><BR><FONT face=3Dsans-serif =
size=3D2>Jon=20
Kvisli<BR>----------------------------------------------<BR>Senior=20
systemkonsulent<BR>Lindorff Applications as<BR>Hellandtunet =
forsknings- og=20
n=E6ringssenter<BR>Postboks 4, 3833 B=F8 i Telemark<BR>tlf: 35 06 15 =
71<BR>fax: 35=20
06 15 01<BR>e-post:=20
=
jon.kvisli@lindorffapplications.com<BR>www.lindorffapplications.com<BR>--=
--------------------------------------------</FONT>=20
<BR><BR><BR><BR>
<TABLE width=3D"100%">
<TBODY>
<TR vAlign=3Dtop>
<TD>
<TD><FONT face=3Dsans-serif size=3D1><B>"Steve Franklin"=20
<steve_franklin@yahoo.com></B></FONT> <BR><FONT =
face=3Dsans-serif=20
size=3D1>Sent by: powerh-l-admin@cube.swau.edu</FONT>=20
<P><FONT face=3Dsans-serif size=3D1>22.10.2001 23:23</FONT> =
<BR></P>
<TD><FONT face=3DArial size=3D1> =
</FONT><BR><FONT=20
face=3Dsans-serif size=3D1> To: =
=20
"'John Penney'" =
<JPENNEY@co.pierce.wa.us></FONT>=20
<BR><FONT face=3Dsans-serif size=3D1> =
cc: =20
<powerh-l@lists.swau.edu></FONT> =
<BR><FONT=20
face=3Dsans-serif size=3D1> Subject: =
=20
RE: Using Sybase with=20
Powerhouse</FONT></TR></TBODY></TABLE><BR><BR><FONT face=3D"Courier =
New"=20
size=3D2>The QTP code is quite simple:<BR><BR>cancel clear<BR><BR>set =
input=20
limit 400<BR><BR>run LoadImportBillings<BR><BR>Request=20
CreateBillings<BR><BR>access *$STWIMPORT/import_billing<BR><BR>output=20
bl_billings add<BR> =
=20
item customer_sort_name final CustomerSortName<BR> =
=20
item service_date final=20
nconvert(ServiceDate)<BR> =
=20
item service_sequence final t-seq<BR> =
=20
item application_code final AppCode<BR> =
=20
item employee_number final=20
employee_number of import_billing<BR> =
=20
item total_hours final nconvert(units) =
=20
* 100<BR> =
=20
item hours_to_bill final nconvert(units) * =
100<BR> =20
item amount_to_bill =
final=20
nconvert(Amount) * 100<BR> =
=20
item processed_by_billing final Billed<BR> =
=20
item billed_date final=20
nconvert(BilledDate)<BR> =
=20
item work_performed1 final t-work-performed1<BR> =
=20
item work_performed2 final=20
t-work-performed2<BR> =
=20
item printed_work_performed1 final t-work-performed1<BR> =
=20
item printed_work_performed2 final=20
t-work-performed2<BR> =
=20
item date_modified final sysdate<BR> =
=20
item userid_modified final =
logonid<BR>build<BR><BR><BR>The Error=20
is the following.<BR><BR>[SQL Server: ] Can't allocate space for =
object=20
'syslogs' in database<BR>'billing'<BR>because 'logsegment' segment is =
full/has=20
no free extents. If you ran out of<BR>space in syslogs, dump the =
transaction=20
log. Otherwise, use ALTER DATABASE or<BR>sp_extendsegment to increase =
size of=20
the segment.<BR> File: bl_billings<BR> =
Linkitem:=20
customer_sort_name =
=20
JASPER<BR> Linkitem: service_date =
=20
02/28/1998 =
00:00:00<BR> =20
Linkitem: service_sequence =
=20
3<BR> Linkitem:=20
processed_by_billing =20
Y<BR><BR><BR><BR>-----Original Message-----<BR>From: John Penney=20
[mailto:JPENNEY@co.pierce.wa.us]<BR>Sent: Monday, October 22, 2001 =
4:06=20
PM<BR>To: steve_franklin@yahoo.com<BR>Subject: Re: Using Sybase with=20
Powerhouse<BR><BR><BR>Hey, Steve, snippet of the source code, and a =
copy of=20
the error message<BR>would help.<BR><BR>QTP does commits to Relational =
Databases either explicitly using COMMIT<BR>syntax or by default at =
end-of-run=20
IIRC, i.e. by record, or entire =
QTP<BR>run/Request.<BR><BR><BR><BR>John M=20
Penney<BR>Systems Programmer<BR>Production Services<BR>Information =
Services=20
Department<BR>Pierce County<BR>Tacoma,=20
WA<BR>253-798-6215<BR>jpenney@co.pierce.wa.us<BR><BR>>>> =
"Steve=20
Franklin" <steve_franklin@yahoo.com> 10/22/01 01:39PM =
>>><BR>I=20
have been trying to use Sybase ASE 11.9.2 with Axiant 3.0 and =
the<BR>database=20
I have defined keeps getting errors that the syslog is full.=20
This<BR>occurs while trying to add data to one table in a QTP =
job.=20
Does anyone know<BR>how QTP inserts data into a Sybase table. =
Is=20
in one SQL Insert per record,<BR>or is it batched into one =
transaction?=20
My log file is almost as big as my<BR>database. Normally =
the log=20
is about 25% the size of the database. The<BR>table in question =
does not=20
have any blob type columns.<BR><BR>Thanks for any insight you have on =
this=20
issue.<BR><BR>Steve<BR><BR>Steve Franklin<BR>Stw Inc.<BR>Email:=20
=
steve_franklin@yahoo.com<BR><BR><BR><BR>_________________________________=
________________________<BR>Do=20
You Yahoo!?<BR>Get your free @yahoo.com address at=20
http://mail.yahoo.com<BR><BR><BR>=3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D=20
=3D =3D =3D =3D =3D<BR>Mailing list: =
powerh-l@lists.swau.edu<BR>Subscribe: "subscribe"=20
in message body to powerh-l-request@lists.swau.edu<BR>Unsubscribe:=20
"unsubscribe" in message body=20
=
to<BR>powerh-l-request@lists.swau.edu<BR>http://lists.swau.edu/mailman/li=
stinfo/powerh-l<BR>This=20
list is closed, thus to post to the list you must be a=20
=
subscriber.<BR><BR><BR>__________________________________________________=
_______<BR>Do=20
You Yahoo!?<BR>Get your free @yahoo.com address at=20
http://mail.yahoo.com<BR><BR><BR>=3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D=20
=3D =3D =3D =3D =3D<BR>Mailing list: =
powerh-l@lists.swau.edu<BR>Subscribe: "subscribe"=20
in message body to powerh-l-request@lists.swau.edu<BR>Unsubscribe:=20
"unsubscribe" in message body to=20
=
powerh-l-request@lists.swau.edu<BR>http://lists.swau.edu/mailman/listinfo=
/powerh-l<BR>This=20
list is closed, thus to post to the list you must be a=20
subscriber.<BR></FONT><BR><BR></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0039_01C15B98.4AC36300--
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com