Toad World® Forums

error on load database


#1

another post,
I try to make a load database but i’ve got an error :

Category Timestamp Duration Message Line Position
Error 07/02/2011 17:03:17 0:00:00.171 - Msg 3216, Level 10, State 22, Server convsrv, Line 1 - Sybase Database Error: Backup Server session id is: 17. Use this value when executing the ‘sp_volchanged’ system stored procedure after fulfilling any volume change request from the Backup Server.
2 0

after executing the sql I search for the error and click on “Query plan” tab, toad display the result after a long long time, and the result is nothing besause I have an error on fisrt statement.

After a deeper search, I found the problem is the size of my device.

1st question :
is it possible to have clearer message?

2nd question
is there a way to make shorter time to display the result about a query plan of an error?

thanks for all
Helder


#2

Hello Helder,

I created CR 82,133 for these issues.

Would it be possible to post the SQL that was used when the query plan tab took a long time to display?

Also, could you please post the ASE server version?

Thanks.


#3

ASE version :12.5.3 on windows 2k3

here the sql making long time for display query plan (it makes an error) :
load database mydb from “compress::1::d:\dumpfile\mydb.dmp”
online database mydb

thanks


#4

I will add the information to the CR.

Thanks.


#5

hi all,
probably same bug
try a load database with an incorrect fileName, the message “No such file or directory” don’t appear.


#6

I will add this information to the CR as well.

Thanks.