This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C15B97.E3393110
Content-Type: text/plain
I found two references to possible solutions, the details are below,
1.
These errors are indicating the logs for the database are full and MS SQL
Server is unable to recover cleanly. The solution is to install Service Pack
5 for SQL Server (as per Microsoft Tech Support). Contact your vendor or
Microsoft for further information.
2.
To resolve this issue, truncate the transaction log for the database. Open
Microsoft SQL Enterprise Server, right-click on the database that is causing
the problem, select edit and then Transaction Log - Truncate.
-----Original Message-----
From: Steve Franklin [mailto:steve_franklin@yahoo.com]
Sent: 22 October 2001 22:23
To: 'John Penney'
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_001_01C15B97.E3393110
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
RE: Using Sybase with Powerhouse
I found two references to possible solutions, the =
details are below,
1.
These errors are indicating the logs for the =
database are full and MS SQL Server is unable to recover cleanly. The =
solution is to install Service Pack 5 for SQL Server (as per Microsoft =
Tech Support). Contact your vendor or Microsoft for further =
information.
2.
To resolve this issue, truncate the transaction log =
for the database. Open Microsoft SQL Enterprise Server, right-click on =
the database that is causing the problem, select edit and then =
Transaction Log - Truncate.
-----Original Message-----
From: Steve Franklin [mailto:steve_franklin@yahoo.com=
]
Sent: 22 October 2001 22:23
To: 'John Penney'
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 &n=
bsp; 3
Linkitem: =
processed_by_billing &nbs=
p; 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
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
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
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
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_001_01C15B97.E3393110--