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.

Dump database gives error but is executed

2 posts in General Discussion Last posting was on 2009-06-03 09:54:24.0Z
Pieter Coene Posted on 2009-06-02 12:17:20.0Z
Sender: 7c17.4a24c09e.1804289383@sybase.com
From: Pieter Coene
Newsgroups: sybase.public.workspace.general
Subject: Dump database gives error but is executed
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a251850.7f8.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Jun 2009 05:17:20 -0700
X-Trace: forums-1-dub 1243945040 10.22.241.41 (2 Jun 2009 05:17:20 -0700)
X-Original-Trace: 2 Jun 2009 05:17:20 -0700, 10.22.241.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:853
Article PK: 1088504

hi,

when i start a dump database command, the dump is executed
(and correctly), but the 'Status' of the SQL Result always
says: 'Failed'.

This is what the SQL Results say:
Backup Server session id is: 26. Use this value when
executing the 'sp_volchanged' system stored procedure after
fulfilling any volume change request from the Backup Server.
Msg 413201, Level 1, State 1:
Server 'TRSTEST_BS', Procedure 'bs_write_header',
Backup Server: 4.132.1.1: Attempting to open byte stream
device: 'compress::c:\temp\eendracht_final.bkp::00'

Greetz
Pieter


Li huang [Sybase] Posted on 2009-06-03 09:54:24.0Z
From: "Li huang [Sybase]" <lihuang@sybase.com>
Reply-To: lihuang@sybase.com
Organization: Sybase Software Co., Ltd
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.workspace.general
Subject: Re: Dump database gives error but is executed
References: <4a251850.7f8.1681692777@sybase.com>
In-Reply-To: <4a251850.7f8.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: <4a264850$1@forums-1-dub>
Date: 3 Jun 2009 02:54:24 -0700
X-Trace: forums-1-dub 1244022864 10.22.241.152 (3 Jun 2009 02:54:24 -0700)
X-Original-Trace: 3 Jun 2009 02:54:24 -0700, vip152.sybase.com
Lines: 66
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:854
Article PK: 1088509

Hi, Pieter:

If jdbc driver returns a exception, WorkSpace considers the execution is 'Failed'. And the SQL result view only display the messages returned
from the server.

So in this case, even the command executed correctly, but the driver may consider the informational messages(see below) as a exception.


Here is the explaination:
link: http://infocenter.sybase.com/help/topic/com.sybase.dc00729_1500/html/errMessageAdvRes/BGBCJDHC.htm

Error 3216
Severity
10

Message text
Backup Server session id is: %ld. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.

Explanation
Dumps and loads are performed by an Open Server program known as Backup Server. During the backup and restore process, it may be necessary to
change tape volumes. If Backup Server detects the need to change the currently mounted volume, it requests a volume change by sending messages
to either the client or its operator console. After mounting another volume, the operator notifies Backup Server by executing the sp_volchanged
system procedure on Adaptive Server.
Error 3216 is an informational message that Backup Server issues when starting a dump or load operation. The message notifies the operator of
the current session ID, which the operator needs if it becomes necessary to execute sp_volchanged during the dump or load operation.
Action
This is an informational message. No action is necessary.
Versions in which this error is raised
All versions

Pieter Coene wrote:
> hi,
>
> when i start a dump database command, the dump is executed
> (and correctly), but the 'Status' of the SQL Result always
> says: 'Failed'.
>
> This is what the SQL Results say:
> Backup Server session id is: 26. Use this value when
> executing the 'sp_volchanged' system stored procedure after
> fulfilling any volume change request from the Backup Server.
> Msg 413201, Level 1, State 1:
> Server 'TRSTEST_BS', Procedure 'bs_write_header',
> Backup Server: 4.132.1.1: Attempting to open byte stream
> device: 'compress::c:\temp\eendracht_final.bkp::00'
>
> Greetz
> Pieter

--
Thanks and regards,

Daniel(Li) Huang [Sybase]
WorkSpace Database Development Tooling Dev Manager

Sybase
Sybase Software (China) Co., Ltd
Room 1202-1203, Building One,
Zhangjiang Semiconductor Industry Park
3000 Longdong Avenue
Pudong, Shanghai 201203
Tel 8621-38657420
Email: lihuang@sybase.com