Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Error: 1105, Severity: 17, State: 4

8 posts in General Discussion Last posting was on 2012-04-30 15:38:52.0Z
newbiz Posted on 2012-04-17 07:21:39.0Z
Sender: 2755.4f8d1848.1804289383@sybase.com
From: newbiz
Newsgroups: sybase.public.ase.general
Subject: Error: 1105, Severity: 17, State: 4
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f8d1a03.2796.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 17 Apr 2012 00:21:39 -0700
X-Trace: forums-1-dub 1334647299 172.20.134.41 (17 Apr 2012 00:21:39 -0700)
X-Original-Trace: 17 Apr 2012 00:21:39 -0700, 172.20.134.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31030
Article PK: 73920

Hi,

Anyone who can help me with this error? (Error: 1105,
Severity: 17, State: 4). Came out in the logs. I am a newbie
trying to learn sybase ASE.


Rob V Posted on 2012-04-17 20:59:32.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko/20120327 Thunderbird/11.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Error: 1105, Severity: 17, State: 4
References: <4f8d1a03.2796.1681692777@sybase.com>
In-Reply-To: <4f8d1a03.2796.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f8dd9b4$1@forums-1-dub>
Date: 17 Apr 2012 13:59:32 -0700
X-Trace: forums-1-dub 1334696372 10.22.241.152 (17 Apr 2012 13:59:32 -0700)
X-Original-Trace: 17 Apr 2012 13:59:32 -0700, vip152.sybase.com
Lines: 29
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31035
Article PK: 73925


On 17-Apr-2012 09:21, newbiz wrote:
> Hi,
>
> Anyone who can help me with this error? (Error: 1105,
> Severity: 17, State: 4). Came out in the logs. I am a newbie
> trying to learn sybase ASE.

1105 means that something is full.
See this:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00729.1500/html/errMessageAdvRes/X100549.htm

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide" (new!)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------


newbiz Posted on 2012-04-18 00:24:59.0Z
Sender: 48d0.4f8e06b0.1804289383@sybase.com
From: newbiz
Newsgroups: sybase.public.ase.general
Subject: Re: Error: 1105, Severity: 17, State: 4
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f8e09db.491b.1681692777@sybase.com>
References: <4f8dd9b4$1@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 17 Apr 2012 17:24:59 -0700
X-Trace: forums-1-dub 1334708699 172.20.134.41 (17 Apr 2012 17:24:59 -0700)
X-Original-Trace: 17 Apr 2012 17:24:59 -0700, 172.20.134.41
Lines: 38
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31036
Article PK: 73930


> On 17-Apr-2012 09:21, newbiz wrote:
> > Hi,
> >
> > Anyone who can help me with this error? (Error: 1105,
> > Severity: 17, State: 4). Came out in the logs. I am a
> > newbie trying to learn sybase ASE.
>
> 1105 means that something is full.
> See this:
>
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00729.1500/html/errMessageAdvRes/X100549.htm
>
> --
> HTH,
>
> Rob V.
> ----------------------------------------------------------
> ------- Rob Verschoor
>
> Certified Professional DBA for Sybase ASE, IQ, Replication
> Server
>
> Author of Sybase books (order online at
> www.sypron.nl/shop): "Tips, Tricks & Recipes for Sybase
> ASE" "The Complete Sybase IQ Quick Reference Guide" (new!)
> "The Complete Sybase ASE Quick Reference Guide"
> "The Complete Sybase Replication Server Quick Reference
> Guide"
>
> rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
> @rob_verschoor Sypron B.V., The Netherlands | Chamber of
> Commerce 27138666
> ----------------------------------------------------------
> -------

Hi rob, thanks for the link. I was trying a few of the
procedure but everytime I try to make the db online it shows
the same message.


Bret Halford Posted on 2012-04-18 15:03:48.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko/20120327 Thunderbird/11.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Error: 1105, Severity: 17, State: 4
References: <4f8dd9b4$1@forums-1-dub> <4f8e09db.491b.1681692777@sybase.com>
In-Reply-To: <4f8e09db.491b.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f8ed7d4@forums-1-dub>
Date: 18 Apr 2012 08:03:48 -0700
X-Trace: forums-1-dub 1334761428 10.22.241.152 (18 Apr 2012 08:03:48 -0700)
X-Original-Trace: 18 Apr 2012 08:03:48 -0700, vip152.sybase.com
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31041
Article PK: 73933


On 4/17/2012 6:24 PM, newbiz wrote:
>> On 17-Apr-2012 09:21, newbiz wrote:
>
> Hi rob, thanks for the link. I was trying a few of the
> procedure but everytime I try to make the db online it shows
> the same message.

It is generally a good idea to post the full actual
error messages you are encountering as well as details
on the circumstances they are being raised.


newbiz Posted on 2012-04-19 00:28:48.0Z
Sender: 77ec.4f8f58b0.1804289383@sybase.com
From: newbiz
Newsgroups: sybase.public.ase.general
Subject: Re: Error: 1105, Severity: 17, State: 4
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f8f5c40.7853.1681692777@sybase.com>
References: <4f8ed7d4@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 18 Apr 2012 17:28:48 -0700
X-Trace: forums-1-dub 1334795328 172.20.134.41 (18 Apr 2012 17:28:48 -0700)
X-Original-Trace: 18 Apr 2012 17:28:48 -0700, 172.20.134.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31045
Article PK: 73935


> On 4/17/2012 6:24 PM, newbiz wrote:
> >> On 17-Apr-2012 09:21, newbiz wrote:
> >
> > Hi rob, thanks for the link. I was trying a few of the
> > procedure but everytime I try to make the db online it
> > shows the same message.
>
> It is generally a good idea to post the full actual
> error messages you are encountering as well as details
> on the circumstances they are being raised.
>

my predecessor left me with database that im not sure if it
is corrupted or problematic. I was trying to resolve it
through reading about the error. And from what Rob sent and
by definition of the error, the log seems to have been
filled or full(state4). Do you have any other idea on to
resolve this?


Bret Halford Posted on 2012-04-19 15:11:48.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko/20120327 Thunderbird/11.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Error: 1105, Severity: 17, State: 4
References: <4f8ed7d4@forums-1-dub> <4f8f5c40.7853.1681692777@sybase.com>
In-Reply-To: <4f8f5c40.7853.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f902b34$1@forums-1-dub>
Date: 19 Apr 2012 08:11:48 -0700
X-Trace: forums-1-dub 1334848308 10.22.241.152 (19 Apr 2012 08:11:48 -0700)
X-Original-Trace: 19 Apr 2012 08:11:48 -0700, vip152.sybase.com
Lines: 42
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31046
Article PK: 73936


On 4/18/2012 6:28 PM, newbiz wrote:
>> On 4/17/2012 6:24 PM, newbiz wrote:
>>>> On 17-Apr-2012 09:21, newbiz wrote:
>>>
>>> Hi rob, thanks for the link. I was trying a few of the
>>> procedure but everytime I try to make the db online it
>>> shows the same message.
>>
>> It is generally a good idea to post the full actual
>> error messages you are encountering as well as details
>> on the circumstances they are being raised.
>>
> my predecessor left me with database that im not sure if it
> is corrupted or problematic. I was trying to resolve it
> through reading about the error. And from what Rob sent and
> by definition of the error, the log seems to have been
> filled or full(state4). Do you have any other idea on to
> resolve this?

first try

dump tran <dbname> with truncate_only
go


If that command itself gets an 1105 error, try

dump tran <dbname> with no_log
go

If that still doesn't clear things up, let us know.

You will eventually want to work out your backup strategy -
how often to do a full backup of the database and whether
you want to dump the transaction log to disk (to allow
recovery to points in time between full dumps) or just
truncating the log and relying only on the full database
dumps for recovery.

-bret


tom-tom Posted on 2012-04-30 08:39:13.0Z
Sender: 7451.4f9e4f06.1804289383@sybase.com
From: tom-tom
Newsgroups: sybase.public.ase.general
Subject: Re: Error: 1105, Severity: 17, State: 4
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f9e4fb1.7478.1681692777@sybase.com>
References: <4f902b34$1@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 30 Apr 2012 01:39:13 -0700
X-Trace: forums-1-dub 1335775153 172.20.134.41 (30 Apr 2012 01:39:13 -0700)
X-Original-Trace: 30 Apr 2012 01:39:13 -0700, 172.20.134.41
Lines: 44
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31059
Article PK: 73948


> On 4/18/2012 6:28 PM, newbiz wrote:
> >> On 4/17/2012 6:24 PM, newbiz wrote:
> >>>> On 17-Apr-2012 09:21, newbiz wrote:
> >>>
> >>> Hi rob, thanks for the link. I was trying a few of the
> >>> procedure but everytime I try to make the db online it
> >>> shows the same message.
> >>
> >> It is generally a good idea to post the full actual
> >> error messages you are encountering as well as details
> >> on the circumstances they are being raised.
> >>
> > my predecessor left me with database that im not sure if
> > it is corrupted or problematic. I was trying to resolve
> > it through reading about the error. And from what Rob
> > sent and by definition of the error, the log seems to
> > have been filled or full(state4). Do you have any other
> > idea on to resolve this?
>
>
> first try
>
> dump tran <dbname> with truncate_only
> go
>
>
> If that command itself gets an 1105 error, try
>
> dump tran <dbname> with no_log
> go
>
> If that still doesn't clear things up, let us know.
>
> You will eventually want to work out your backup strategy
> - how often to do a full backup of the database and
> whether you want to dump the transaction log to disk (to
> allow recovery to points in time between full dumps) or
> just truncating the log and relying only on the full
> database dumps for recovery.
>
> -bret

The first one was ok, though my database now is
transactionaly inconsistent because the transaction log was
cleared.thanks


Bret Halford Posted on 2012-04-30 15:38:52.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:11.0) Gecko/20120327 Thunderbird/11.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Error: 1105, Severity: 17, State: 4
References: <4f902b34$1@forums-1-dub> <4f9e4fb1.7478.1681692777@sybase.com>
In-Reply-To: <4f9e4fb1.7478.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f9eb20c$1@forums-1-dub>
Date: 30 Apr 2012 08:38:52 -0700
X-Trace: forums-1-dub 1335800332 10.22.241.152 (30 Apr 2012 08:38:52 -0700)
X-Original-Trace: 30 Apr 2012 08:38:52 -0700, vip152.sybase.com
Lines: 37
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31062
Article PK: 73951


On 4/30/2012 2:39 AM, tom-tom wrote:

>> first try
>>
>> dump tran<dbname> with truncate_only
>> go
>>
>>
>> If that command itself gets an 1105 error, try
>>
>> dump tran<dbname> with no_log
>> go
>>
>> If that still doesn't clear things up, let us know.
>>
>> You will eventually want to work out your backup strategy
>> - how often to do a full backup of the database and
>> whether you want to dump the transaction log to disk (to
>> allow recovery to points in time between full dumps) or
>> just truncating the log and relying only on the full
>> database dumps for recovery.
>>
>> -bret
> The first one was ok, though my database now is
> transactionaly inconsistent because the transaction log was
> cleared.thanks

Why do you think the database is now transactionally inconsistant?
The DUMP TRANSACTION command issues a checkpoint command,
so all changes to data in cache are flushed to disk,
and can only truncate committed log records from the
beginning of the syslogs table to the beginning of the
oldest transaction.