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 9155:" in SQL Remote

3 posts in General Discussion Last posting was on 2005-12-12 17:07:36.0Z
Luis Campodónico Posted on 2005-12-09 15:24:16.0Z
Sender: 1e6a.4397537a.1804289383@sybase.com
From: Luis Campodónico
Newsgroups: ianywhere.public.general
Subject: "Error 9155:" in SQL Remote
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4399a1a0.3cba.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Dec 2005 07:24:16 -0800
X-Trace: forums-1-dub 1134141856 10.22.241.41 (9 Dec 2005 07:24:16 -0800)
X-Original-Trace: 9 Dec 2005 07:24:16 -0800, 10.22.241.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5045
Article PK: 31523

Hi, in my log of ssremote I have this error message:

"E. 12/06 17:45:15. Error 9155: The date column at (673552,
10) is too small to be converted to a datetime, the date
portion will default to 'Jan 1, 1900'."

I search in internet an in Anywhere documentation and didn't
find anything about error 9155

somebody will know what is happening?

I'm Using SQL Remote 7.0.2, ASA 8.0.2 and ASE 12.5.2

Thanks!!!


Nick Elson Posted on 2005-12-09 19:05:22.0Z
From: "Nick Elson" <no_span_nicelson@sybase.com>
Newsgroups: ianywhere.public.general
References: <4399a1a0.3cba.1681692777@sybase.com>
Subject: Re: "Error 9155:" in SQL Remote
Lines: 57
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: nicelson-m20.sybase.com
X-Original-NNTP-Posting-Host: nicelson-m20.sybase.com
Message-ID: <4399d572@forums-1-dub>
Date: 9 Dec 2005 11:05:22 -0800
X-Trace: forums-1-dub 1134155122 10.25.98.215 (9 Dec 2005 11:05:22 -0800)
X-Original-Trace: 9 Dec 2005 11:05:22 -0800, nicelson-m20.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5046
Article PK: 8650

That's an ASE error. More specifically it is an error coming
from the ASE logtransfer facility.

You are seeing that error in the SSRemote output log during the
log scanning phase. Errors in the range of 9100-9199 are
associately soley to ASE's logtransfer facility; which SSRemote -i
calls to scan the log. These are documented in ASE's
Troubleshooting and Error Messge Guide, Vol. 3 [if at
all since it is not really a documented facility].

This particular error is not listed [not even in the 12.5 Core set]
but if this is a major issue for you, you should contact Sybase
Technical Support and open up a support case to raise this as
an ASE transaction log issue that needs to be investigated.

AFAIK there is nothing that can be done from the SSRemote
side unless you have commited a major replication design error;
which seems extremely unlikely given that error.

Otherwise I don't know how this could happen.

It is obvious that the value in the transaction log appears to be
something smaller than 'Jan 1, 1900' [actually something before
Jan 1 1753]. It may just be a non-date value being scanned out
of order.

I guess it could happen if you insert/update and commit values
into that column and later on alter the schema **without**
scanning the log [using ssremote -i]. But then you could get any
sort of bad behavour if you try something like that. Schema changes
without first draining the transaction log is a bad thing. Schema
changes alone are difficult enough without adding operations that
were based upon an older schema.

It is also possible there is a corruption in the transaction log;
which would definitely be an issue with your ASE database/server.

"Luis Campod ónico" <Luis Campod =?ISO-8859-1?B?825pY28=?=> wrote in message
news:4399a1a0.3cba.1681692777@sybase.com...
> Hi, in my log of ssremote I have this error message:
>
> "E. 12/06 17:45:15. Error 9155: The date column at (673552,
> 10) is too small to be converted to a datetime, the date
> portion will default to 'Jan 1, 1900'."
>
> I search in internet an in Anywhere documentation and didn't
> find anything about error 9155
>
> somebody will know what is happening?
>
> I'm Using SQL Remote 7.0.2, ASA 8.0.2 and ASE 12.5.2
>
> Thanks!!!


Luis Campodonico Posted on 2005-12-12 17:07:36.0Z
Sender: 668a.4399a09e.1804289383@sybase.com
From: Luis Campodonico
Newsgroups: ianywhere.public.general
Subject: Re: "Error 9155:" in SQL Remote
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <439dac37.1f4e.1681692777@sybase.com>
References: <4399d572@forums-1-dub>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 12 Dec 2005 08:58:31 -0800, 10.22.241.42
Lines: 67
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 12 Dec 2005 08:58:32 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 12 Dec 2005 09:07:36 -0800
X-Trace: forums-1-dub 1134407256 10.22.108.75 (12 Dec 2005 09:07:36 -0800)
X-Original-Trace: 12 Dec 2005 09:07:36 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5066
Article PK: 31526

Thanks a lot for the answer. I'm tracking the error, but it
doesn't produce again.

Again, thank you very much

Luis C.

> That's an ASE error. More specifically it is an error
> coming from the ASE logtransfer facility.
>
> You are seeing that error in the SSRemote output log
> during the log scanning phase. Errors in the range of
> 9100-9199 are associately soley to ASE's logtransfer
> facility; which SSRemote -i calls to scan the log. These
> are documented in ASE's Troubleshooting and Error Messge
> Guide, Vol. 3 [if at all since it is not really a
> documented facility].
>
> This particular error is not listed [not even in the 12.5
> Core set] but if this is a major issue for you, you should
> contact Sybase Technical Support and open up a support
> case to raise this as an ASE transaction log issue that
> needs to be investigated.
>
> AFAIK there is nothing that can be done from the SSRemote
> side unless you have commited a major replication design
> error; which seems extremely unlikely given that error.
>
> Otherwise I don't know how this could happen.
>
> It is obvious that the value in the transaction log
> appears to be something smaller than 'Jan 1, 1900'
> [actually something before Jan 1 1753]. It may just be a
> non-date value being scanned out of order.
>
> I guess it could happen if you insert/update and commit
> values into that column and later on alter the schema
> **without** scanning the log [using ssremote -i]. But
> then you could get any sort of bad behavour if you try
> something like that. Schema changes without first draining
> the transaction log is a bad thing. Schema changes alone
> are difficult enough without adding operations that were
> based upon an older schema.
>
> It is also possible there is a corruption in the
> transaction log; which would definitely be an issue with
> your ASE database/server.
>
>
>
> "Luis Campod ónico" <Luis Campod
> =?ISO-8859-1?B?825pY28=?=> wrote in message
> > news:4399a1a0.3cba.1681692777@sybase.com... Hi, in my
> log of ssremote I have this error message: >
> > "E. 12/06 17:45:15. Error 9155: The date column at
> > (673552, 10) is too small to be converted to a datetime,
> > the date portion will default to 'Jan 1, 1900'."
> >
> > I search in internet an in Anywhere documentation and
> > didn't find anything about error 9155
> >
> > somebody will know what is happening?
> >
> > I'm Using SQL Remote 7.0.2, ASA 8.0.2 and ASE 12.5.2
> >
> > Thanks!!!
>
>