I have installed 9.0. When I open Sybase Central and try to connect to a 5.5
database I am informed that the database must be unloaded and reloaded. This
is fine and I run the wizard, the unload procedure proceeds until.

.................
Unloading "irsaims"."motorvehiclespecialdriver" into
motorvehiclespecialdriver (relative to server)
Unloading "irsaims"."driveraccidents" into driveraccidents (relative to
server)
Reloading data
Adding foreign key and index definitions
Creating functions
Creating views
***** SQL error: Procedure 'FullName' not found
Could not unload the database 'irsaim
Status : Failed

'FullName' is a function that we created and is used within several other
functions/procedures.

Any ideas why I would be getting this error?

Thank you.

Bill

Try separating the "unload" step from the "reload" step. Unloading will get
you a directory full of .DAT files with one .SQL file. Then you can edit
the SQL file and ensure that the FullName function gets created before the
views that depend on it before reloading it back in (by executing the
reload.sql on an empty database)

"Bill Urbanovsky" <burbanovsky (AT) irsaims (DOT) com> wrote

Thanks for the response. I verified that the "FullName" function is being
created before the
view. Even after the unload/reload in Sybase Central fails I can open the
database and see the "FullName" function. So it is there. I was able to get
past the "create views" section by setting the maximum view dependency level
to 2. However, it then failed on the "checking view definitions" section.
With a "Table xxxxxxx not found" . By deleteing all views before hand, then
unloading and reloading the database, then recreating the views I am able to
finally update the database.

There appears to be bug in the Sybase Central upgrade procedures.


"Erik Anderson" <erikba (AT) teamworkgroup (DOT) com> wrote

I suspect that this problem has more to do with visablity of the procedure
at the time the view is being created. Is the procedure fully qualified
i.e., owner.proc_name? If it is not qualified, is it visible to the view at
the time that it is created. See the 'SETUSER xxxxx' at the start of the
view section in the unload/reload.

BTW
You may want to have this reviewed by technical support in case it is a bug.

Within North America, you can reach Technical Support by calling
1-800-8SYBASE. If you are located outside of North America, you can find
the contact information for your local Sybase Support Center by going to the
Sybase home page at http://www.sybase.com, clicking on the "Support" link at
the top of the page, and then choosing "Support Centers" from the left hand
frame.

You can always report a bug for free by visiting CaseXpress at
http://casexpress.sybase.com/cx/cx.stm. When submitting calls through
CaseXpress, please make sure to give an accurate description of the steps
you take to reproduce the bug, and include any files that may be needed
(database, source code) to reproduce the problem.


--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

************************************************** **************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

************************************************** **************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

************************************************** **************************
*

"Bill Urbanovsky" <burbanovsky (AT) irsaims (DOT) com> wrote