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.

Sybase 15.0.2 - not coming to ONLINE

2 posts in Backup and Recovery Last posting was on 2009-04-01 15:19:37.0Z
hari Posted on 2009-03-31 04:56:47.0Z
From: hari <chamundihari@gmail.com>
Newsgroups: sybase.public.ase.backup+recovery
Subject: Sybase 15.0.2 - not coming to ONLINE
Date: Mon, 30 Mar 2009 21:56:47 -0700 (PDT)
Organization: http://groups.google.com
Lines: 125
Message-ID: <476e360a-d447-4328-bec7-7b50059ece8b@v23g2000pro.googlegroups.com>
NNTP-Posting-Host: 202.63.118.146
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1238475408 23639 127.0.0.1 (31 Mar 2009 04:56:48 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 31 Mar 2009 04:56:48 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: v23g2000pro.googlegroups.com; posting-host=202.63.118.146; posting-account=JMm4ewoAAACUmjWXG-TKZfIgufyLaLuk
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; MEGAUPLOAD 2.0; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; FDM),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!v23g2000pro.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3940
Article PK: 48028

Hi all,

Good day.
This is Hari from The Jeypore Sugars,Chennai.India . We recently
bought Sybase ASE 15.0.2

We have installed the Sybase ASE 15.0.2 on Win2003 Server. Previously
we have Sybase ASE 11.9.2 from NT . The dump from the old ver is being
loaded onto the New Sybase 15.0.2 the dump is fully loaded and not
coming to ONLINE.
Before taking the dump on the old backup server we have done the
following steps on the 11.9.2 server as per sybook .

use master
go
sp_dboption test_db ,'single user', true
go
use test_db
go
checkpoint
go
sp_flushstats
go
use test_db
go
checkpoint
go
dbcc checkalloc
go
dbcc checkcatalog
go
dbcc checkdb
go
use master
go
sp_flushstats
desss
go

sp_dboption test_db ,'single user',false
go
use test_db
go
checkpoint
go

I also check all table with dbcc checktable
After this Query we take dump from old Sybase 11.9.2.

When we load in Sybase 15 is OK, but not coming to ONLINE. I also
attached log file too..

How to Solve this problem. Please kindly advise us accordingly to
connect to the Database Online.

Note:We have 4 database,2 database is loaded fine in Sybase 15.0.2 but
tow saying this error.

Thanking You,

With regards,

Hari Manikandan
Chennai



Log error:
00:00000:00028:2009/03/30 20:15:51.20 server Failed to cache
systabstats contents for database test_db (8), object
'AG_FYEAR_STATUS_0607' (1754033580).
00:00000:00028:2009/03/30 20:15:51.20 server Error: 15601, Severity:
20, State: 1
00:00000:00028:2009/03/30 20:15:51.20 server Failed to cache
systabstats contents for database test_db (8), object
'AG_FYEAR_STATUS_0607' (1754033580).
00:00000:00028:2009/03/30 20:15:51.20 server Error: 15601, Severity:
20, State: 1
00:00000:00028:2009/03/30 20:15:51.20 server Failed to cache
systabstats contents for database test_db (8), object
'AG_FYEAR_STATUS_0607' (1754033580).
00:00000:00028:2009/03/30 20:15:51.20 server Error: 15601, Severity:
20, State: 1
00:00000:00028:2009/03/30 20:15:51.20 server Failed to cache
systabstats contents for database test_db (8), object
'AG_FYEAR_STATUS_0607' (1754033580).
00:00000:00028:2009/03/30 20:15:51.20 server Error: 15601, Severity:
20, State: 1
00:00000:00028:2009/03/30 20:15:51.20 server Failed to cache
systabstats contents for database test_db (8), object
'AG_FYEAR_STATUS_0607' (1754033580).
00:00000:00028:2009/03/30 20:15:51.20 server Error: 15601, Severity:
20, State: 1
00:00000:00028:2009/03/30 20:15:51.20 server Failed to cache
systabstats contents for database test_db (8), object
'AG_FYEAR_STATUS_0607' (1754033580).
00:00000:00028:2009/03/30 20:15:51.32 server Error: 3461, Severity:
20, State: 1
00:00000:00028:2009/03/30 20:15:51.32 server Database test_db:
upgrade could not install required upgrade item '12'. Please refer to
previous error messages to determine the problem. Fix the problem,
then try again.
00:00000:00028:2009/03/30 20:15:51.32 server Error: 3452, Severity:
20, State: 1
00:00000:00028:2009/03/30 20:15:51.32 server Database test_db:
upgrade item 1134 depends on item 12, which could not be installed.
Please refer to previous messages for the cause of the failure,
correct the problem and try again.
00:00000:00028:2009/03/30 20:15:51.32 server Error: 3451, Severity:
20, State: 1
00:00000:00028:2009/03/30 20:15:51.32 server Database test_db:
upgrade has failed for this database. Please refer to previous
messages for the cause of the failure, correct the problem and try
again.
00:00000:00028:2009/03/30 20:15:51.32 server Error: 3454, Severity:
20, State: 1
00:00000:00028:2009/03/30 20:15:51.32 server Database test_db: ASE
could not completely upgrade this database; upgrade item 1134 could
not be installed.

“ “

“ “
At End


Sherlock, Kevin [TeamSybase] Posted on 2009-04-01 15:19:37.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.backup+recovery
References: <476e360a-d447-4328-bec7-7b50059ece8b@v23g2000pro.googlegroups.com>
Subject: Re: Sybase 15.0.2 - not coming to ONLINE
Lines: 132
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49d38609$1@forums-1-dub>
Date: 1 Apr 2009 07:19:37 -0800
X-Trace: forums-1-dub 1238599177 10.22.241.152 (1 Apr 2009 07:19:37 -0800)
X-Original-Trace: 1 Apr 2009 07:19:37 -0800, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.backup+recovery:3941
Article PK: 48029

Please don't post the same question to mulitple newsgroups.

http://www.sybase.com/detail?id=47613

"hari" <chamundihari@gmail.com> wrote in message
news:476e360a-d447-4328-bec7-7b50059ece8b@v23g2000pro.googlegroups.com...
Hi all,

Good day.
This is Hari from The Jeypore Sugars,Chennai.India . We recently
bought Sybase ASE 15.0.2

We have installed the Sybase ASE 15.0.2 on Win2003 Server. Previously
we have Sybase ASE 11.9.2 from NT . The dump from the old ver is being
loaded onto the New Sybase 15.0.2 the dump is fully loaded and not
coming to ONLINE.
Before taking the dump on the old backup server we have done the
following steps on the 11.9.2 server as per sybook .

use master
go
sp_dboption test_db ,'single user', true
go
use test_db
go
checkpoint
go
sp_flushstats
go
use test_db
go
checkpoint
go
dbcc checkalloc
go
dbcc checkcatalog
go
dbcc checkdb
go
use master
go
sp_flushstats
desss
go

sp_dboption test_db ,'single user',false
go
use test_db
go
checkpoint
go

I also check all table with dbcc checktable
After this Query we take dump from old Sybase 11.9.2.

When we load in Sybase 15 is OK, but not coming to ONLINE. I also
attached log file too..

How to Solve this problem. Please kindly advise us accordingly to
connect to the Database Online.

Note:We have 4 database,2 database is loaded fine in Sybase 15.0.2 but
tow saying this error.

Thanking You,

With regards,

Hari Manikandan
Chennai



Log error:
00:00000:00028:2009/03/30 20:15:51.20 server Failed to cache
systabstats contents for database test_db (8), object
'AG_FYEAR_STATUS_0607' (1754033580).
00:00000:00028:2009/03/30 20:15:51.20 server Error: 15601, Severity:
20, State: 1
00:00000:00028:2009/03/30 20:15:51.20 server Failed to cache
systabstats contents for database test_db (8), object
'AG_FYEAR_STATUS_0607' (1754033580).
00:00000:00028:2009/03/30 20:15:51.20 server Error: 15601, Severity:
20, State: 1
00:00000:00028:2009/03/30 20:15:51.20 server Failed to cache
systabstats contents for database test_db (8), object
'AG_FYEAR_STATUS_0607' (1754033580).
00:00000:00028:2009/03/30 20:15:51.20 server Error: 15601, Severity:
20, State: 1
00:00000:00028:2009/03/30 20:15:51.20 server Failed to cache
systabstats contents for database test_db (8), object
'AG_FYEAR_STATUS_0607' (1754033580).
00:00000:00028:2009/03/30 20:15:51.20 server Error: 15601, Severity:
20, State: 1
00:00000:00028:2009/03/30 20:15:51.20 server Failed to cache
systabstats contents for database test_db (8), object
'AG_FYEAR_STATUS_0607' (1754033580).
00:00000:00028:2009/03/30 20:15:51.20 server Error: 15601, Severity:
20, State: 1
00:00000:00028:2009/03/30 20:15:51.20 server Failed to cache
systabstats contents for database test_db (8), object
'AG_FYEAR_STATUS_0607' (1754033580).
00:00000:00028:2009/03/30 20:15:51.32 server Error: 3461, Severity:
20, State: 1
00:00000:00028:2009/03/30 20:15:51.32 server Database test_db:
upgrade could not install required upgrade item '12'. Please refer to
previous error messages to determine the problem. Fix the problem,
then try again.
00:00000:00028:2009/03/30 20:15:51.32 server Error: 3452, Severity:
20, State: 1
00:00000:00028:2009/03/30 20:15:51.32 server Database test_db:
upgrade item 1134 depends on item 12, which could not be installed.
Please refer to previous messages for the cause of the failure,
correct the problem and try again.
00:00000:00028:2009/03/30 20:15:51.32 server Error: 3451, Severity:
20, State: 1
00:00000:00028:2009/03/30 20:15:51.32 server Database test_db:
upgrade has failed for this database. Please refer to previous
messages for the cause of the failure, correct the problem and try
again.
00:00000:00028:2009/03/30 20:15:51.32 server Error: 3454, Severity:
20, State: 1
00:00000:00028:2009/03/30 20:15:51.32 server Database test_db: ASE
could not completely upgrade this database; upgrade item 1134 could
not be installed.

“ “

“ “
At End