 | |
ASA 11 from ASA 9 - Extremely Frustrating!
sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general
 |
| | Thread Tools | Display Modes |
#11
 
| ||||||
| ||||||
|
Re: ASA 11 from ASA 9 - Extremely Frustrating! -
05-11-2009
, 10:04 AM
|
I installed Windows 7 RC1 on my laptop and Sybase 9.02 will not run Sybase Central or start the database. It gives a JAVA Exception error. I've loaded the latest release of JAVA and this laptop was formatted and just put JAVA, Firefox and Sybase 9.02 on it. |
product management may still choose not to do so considering that 9.0.2.
will be end-of-life'd next year: http://www.sybase.com/detail?id=1061840
). That said, there could be compatibility issues that could come up -
specifically relating to the JRE trying to establish the desktop theme.
If that's the case, you might be able to circumvent that:
http://search.sybase.com/kbx/changer...?bug_id=415245
Quote:
|
(Using Unload and Reload into a new database) **** SQL error: Unable to start specified database: autostarting database failed An error occurred while attempting to unload the database c:\roommaster.db |
1. The database went down "dirty" and requires recovery (as Chris
mentioned). If this is the case, the database needs to be started on a
9.0.2 server first, allow it to undergo recovery, then upgrade it using
the v11 dbunload. (dbunload -c
"UID=dba;PWD=sql;DBF=c:\roommaster.db;ENG=reloader " -an v11.db)
See:
http://dcx.sybase.com/1101en/sachang...newjasper.html
2. Some of the support files are not available to perform the
unload/reload - we require all of these files to be installed:
http://dcx.sybase.com/1101en/dbprogr...s-3746532.html
http://dcx.sybase.com/1101en/dbprogr...ase-tools.html
And:
\scripts\unloadold.sql
\bin32\dbscript11.dll
(I assume these were present since it appears that you did a Full
install of our product).
3. You have another SQL Anywhere server running that can't start that
version of database (i.e. a v11 server is running, we find the v11
engine and attempt to autostart the v9 database on it, which we can't do).
Quote:
|
I then created a new empty database, and tried using ISQL to bring the data in from an unloaded "SQL" statement, and it's error after error about authentication violations on the user levels. |
ensure that you are creating the new v11 databases with the correct
authentication string. You should review the OEM instructions and make
note of the instructions pertaining to the "\scripts\authenticate.sql"
file that will store your authentication DB options.
http://dcx.sybase.com/1101en/dbadmin...-database.html
http://dcx.sybase.com/1101en/dbadmin...s-4632203.html
Quote:
|
Can I send this database to Sybase to look at and see why it won't work under V11? I really need this by 11AM EST on Monday (I know, I'm pretty much screwed -- my fault, I should have just left Vista on my machine - but what can I say) |
look / verify your upgrade steps.
Quote:
|
1. We need Sybase to make sure 9.02 works on Windows 7 |
is actually released, not just an RC.
Quote:
|
2. I need this database convertible to V11 along with our 150+ other customers someday - but this one test one needs to work first. |
Cheers,
--
Jeff Albion, Sybase iAnywhere
iAnywhere Developer Community :
http://www.sybase.com/developer/libr...ere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summ...&timeframe =0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/
#12
| |||
| |||
|
|
Robert, When Sybase 10 came out they were very clear that you would have to convert the db. In version 10 there was a routine in Sybase Central that would do that. I believe it was removed in Sybase 11. When I converted our ASA 9 to 10 we didn't have to manually do anything. We unloaded using 9 and then created a 10 db and everything was converted over. If you look at the reload file that comes out of 9, were the userid's not in that file? Best Regards Mike Gould "Robert Paresi" <firstinitiallastname (AT) company (DOT) com> wrote in message news:4a081696$1 (AT) forums-1-dub (DOT) .. Hello, In the final hour - before getting on the plane - I got it working somehow. I uninstalled my license and loaded a trial license. I still was unable to convert the database using a simply UNLOAD/RELOAD in Version 11.01 like I should be able to. I had to unload the database in V9.02 into reload statement, create a new database, create all the user profiles, and then run the reload.sql statement in ISQL. This is fine for me, but not fine for our support department to do this to 150 sites. We'll also not have their passwords and we don't want to have to recreate end-user passwords. Can someone at Sybase take our 9.02 database and find the reason why a V11.01 UNLOAD/RELOAD does not work and try and fix the problem in an updated EBF please? How can I do that? We would need an NDA signed first. Thank you. -Robert "Robert Paresi" <firstinitiallastname (AT) company (DOT) com> wrote in message news:4a080d16 (AT) forums-1-dub (DOT) .. Mike, That is what I did (unload and reload using ASA 11) --- it fails and says it can't unload it. -Robert "Michael Gould" <mgould (AT) firstcoast (DOT) net> wrote in message news:4a080cdb (AT) forums-1-dub (DOT) .. Robert, You cannot run a version 9 database under version 11. I have had to use ASA 10 to first convert the database to the new format. I haven't tried but you might have to do a unload in ASA 9 and reload using ASA 11. Best Regards Michael Gould "Robert Paresi" <firstinitiallastname (AT) company (DOT) com> wrote in message news:4a080bfe (AT) forums-1-dub (DOT) .. Hello, I think my issue has to do with trying to run a developer beta test database using the authentication license copy I downloaded from subscribenet. The one developer database I trying to start is not an authenticated one ... could that be the issue? -Robert "Robert Paresi" <firstinitiallastname (AT) company (DOT) com> wrote in message news:4a07b29b$1 (AT) forums-1-dub (DOT) .. Hello, What are my options on this? I can't release passwords to this database or migrate/change passwords, as they are highly sensitive and very sensitive data. We can't have support editing SQL files. I surely can't go to V10 and then to V11 ... It's best if we just stay forever on V9.02 but with WIN7 coming out, we can't do that ... unless Sybase is aware of the issue of V9.02 running properly under WIN7. Please help ASAP. -Robert |
#13
| |||
| |||
|
|
SA11 continues to have the upgrade wizard for versions prior to SA10. Michael Gould wrote: Robert, When Sybase 10 came out they were very clear that you would have to convert the db. In version 10 there was a routine in Sybase Central that would do that. I believe it was removed in Sybase 11. When I converted our ASA 9 to 10 we didn't have to manually do anything. We unloaded using 9 and then created a 10 db and everything was converted over. If you look at the reload file that comes out of 9, were the userid's not in that file? Best Regards Mike Gould "Robert Paresi" <firstinitiallastname (AT) company (DOT) com> wrote in message news:4a081696$1 (AT) forums-1-dub (DOT) .. Hello, In the final hour - before getting on the plane - I got it working somehow. I uninstalled my license and loaded a trial license. I still was unable to convert the database using a simply UNLOAD/RELOAD in Version 11.01 like I should be able to. I had to unload the database in V9.02 into reload statement, create a new database, create all the user profiles, and then run the reload.sql statement in ISQL. This is fine for me, but not fine for our support department to do this to 150 sites. We'll also not have their passwords and we don't want to have to recreate end-user passwords. Can someone at Sybase take our 9.02 database and find the reason why a V11.01 UNLOAD/RELOAD does not work and try and fix the problem in an updated EBF please? How can I do that? We would need an NDA signed first. Thank you. -Robert "Robert Paresi" <firstinitiallastname (AT) company (DOT) com> wrote in message news:4a080d16 (AT) forums-1-dub (DOT) .. Mike, That is what I did (unload and reload using ASA 11) --- it fails and says it can't unload it. -Robert "Michael Gould" <mgould (AT) firstcoast (DOT) net> wrote in message news:4a080cdb (AT) forums-1-dub (DOT) .. Robert, You cannot run a version 9 database under version 11. I have had to use ASA 10 to first convert the database to the new format. I haven't tried but you might have to do a unload in ASA 9 and reload using ASA 11. Best Regards Michael Gould "Robert Paresi" <firstinitiallastname (AT) company (DOT) com> wrote in message news:4a080bfe (AT) forums-1-dub (DOT) .. Hello, I think my issue has to do with trying to run a developer beta test database using the authentication license copy I downloaded from subscribenet. The one developer database I trying to start is not an authenticated one ... could that be the issue? -Robert "Robert Paresi" <firstinitiallastname (AT) company (DOT) com> wrote in message news:4a07b29b$1 (AT) forums-1-dub (DOT) .. Hello, What are my options on this? I can't release passwords to this database or migrate/change passwords, as they are highly sensitive and very sensitive data. We can't have support editing SQL files. I surely can't go to V10 and then to V11 ... It's best if we just stay forever on V9.02 but with WIN7 coming out, we can't do that ... unless Sybase is aware of the issue of V9.02 running properly under WIN7. Please help ASAP. -Robert |
#14
| |||
| |||
|
|
Chris, Correct ... and that is what I mentioned to Mike and what I am using and it does not work. I am using a full licensed (NON OEM) SA11 to open a NON OEM/NON AUTHENTICATED SA9.02 database that was created by a "BACKUP DATABASE .... TRANSACTION LOG TRUNCATE". It is failing. I will try the database backup again one more time ... but if it fails, can I send Sybase the database to see what is wrong with it? From what I read (here and what you wrote), I should be able to use the SA11 Unload Database Wizard to open/unload/reload a Sybase 9.02 database --- right? Thank you very much for your help. -Robert "Chris Keating [Sybase iAnywhere]" <keating_no (AT) spam_sybase (DOT) com> wrote in message news:4a081c1d$1 (AT) forums-1-dub (DOT) .. SA11 continues to have the upgrade wizard for versions prior to SA10. Michael Gould wrote: Robert, When Sybase 10 came out they were very clear that you would have to convert the db. In version 10 there was a routine in Sybase Central that would do that. I believe it was removed in Sybase 11. When I converted our ASA 9 to 10 we didn't have to manually do anything. We unloaded using 9 and then created a 10 db and everything was converted over. If you look at the reload file that comes out of 9, were the userid's not in that file? Best Regards Mike Gould "Robert Paresi" <firstinitiallastname (AT) company (DOT) com> wrote in message news:4a081696$1 (AT) forums-1-dub (DOT) .. Hello, In the final hour - before getting on the plane - I got it working somehow. I uninstalled my license and loaded a trial license. I still was unable to convert the database using a simply UNLOAD/RELOAD in Version 11.01 like I should be able to. I had to unload the database in V9.02 into reload statement, create a new database, create all the user profiles, and then run the reload.sql statement in ISQL. This is fine for me, but not fine for our support department to do this to 150 sites. We'll also not have their passwords and we don't want to have to recreate end-user passwords. Can someone at Sybase take our 9.02 database and find the reason why a V11.01 UNLOAD/RELOAD does not work and try and fix the problem in an updated EBF please? How can I do that? We would need an NDA signed first. Thank you. -Robert "Robert Paresi" <firstinitiallastname (AT) company (DOT) com> wrote in message news:4a080d16 (AT) forums-1-dub (DOT) .. Mike, That is what I did (unload and reload using ASA 11) --- it fails and says it can't unload it. -Robert "Michael Gould" <mgould (AT) firstcoast (DOT) net> wrote in message news:4a080cdb (AT) forums-1-dub (DOT) .. Robert, You cannot run a version 9 database under version 11. I have had to use ASA 10 to first convert the database to the new format. I haven't tried but you might have to do a unload in ASA 9 and reload using ASA 11. Best Regards Michael Gould "Robert Paresi" <firstinitiallastname (AT) company (DOT) com> wrote in message news:4a080bfe (AT) forums-1-dub (DOT) .. Hello, I think my issue has to do with trying to run a developer beta test database using the authentication license copy I downloaded from subscribenet. The one developer database I trying to start is not an authenticated one ... could that be the issue? -Robert "Robert Paresi" <firstinitiallastname (AT) company (DOT) com> wrote in message news:4a07b29b$1 (AT) forums-1-dub (DOT) .. Hello, What are my options on this? I can't release passwords to this database or migrate/change passwords, as they are highly sensitive and very sensitive data. We can't have support editing SQL files. I surely can't go to V10 and then to V11 ... It's best if we just stay forever on V9.02 but with WIN7 coming out, we can't do that ... unless Sybase is aware of the issue of V9.02 running properly under WIN7. Please help ASAP. -Robert |
#15
| |||
| |||
|
|
I am using a full licensed (NON OEM) SA11 to open a NON OEM/NON AUTHENTICATED SA9.02 database that was created by a "BACKUP DATABASE .... TRANSACTION LOG TRUNCATE". It is failing. |
would not have been written out to the database file. Instead they would
have be written to the transaction log while the backup occurred. Since
this is the case, upon database restore/startup, we have to apply these
transactions that currently only exist in the transaction log.
You have to do the restore on v9 software first - the v11 upgrade can't
apply outstanding operations to the v9 database. (i.e. run "dbsrv9
database.db -a database.log")
---
In later versions of the software, if you use the BACKUP statement
options "WAIT BEFORE START and WITH CHECKPOINT LOG NO COPY", you can
avoid this recovery behaviour. (See:
http://dcx.sybase.com/1101en/dbrefer...statement.html )
"To create a backup that can be started on a read-only server without
having to go through recovery, you must use both the WAIT BEFORE START
and WITH CHECKPOINT LOG NO COPY clauses. The WAIT BEFORE START clause
ensures that the rollback log is empty, and the WITH CHECKPOINT LOG NO
COPY clause ensures that the checkpoint log is empty. If either of these
files is missing, then recovery is required."
Quote:
|
I will try the database backup again one more time ... but if it fails, can I send Sybase the database to see what is wrong with it? From what I read (here and what you wrote), I should be able to use the SA11 Unload Database Wizard to open/unload/reload a Sybase 9.02 database --- right? |
Regards,
--
Jeff Albion, Sybase iAnywhere
iAnywhere Developer Community :
http://www.sybase.com/developer/libr...ere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summ...&timeframe =0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/
#16
| |||
| |||
|
|
Robert, Robert Paresi wrote: I am using a full licensed (NON OEM) SA11 to open a NON OEM/NON AUTHENTICATED SA9.02 database that was created by a "BACKUP DATABASE .... TRANSACTION LOG TRUNCATE". It is failing. If there were open transactions that occurred during the backup they would not have been written out to the database file. Instead they would have be written to the transaction log while the backup occurred. Since this is the case, upon database restore/startup, we have to apply these transactions that currently only exist in the transaction log. You have to do the restore on v9 software first - the v11 upgrade can't apply outstanding operations to the v9 database. (i.e. run "dbsrv9 database.db -a database.log") --- In later versions of the software, if you use the BACKUP statement options "WAIT BEFORE START and WITH CHECKPOINT LOG NO COPY", you can avoid this recovery behaviour. (See: http://dcx.sybase.com/1101en/dbrefer...statement.html ) "To create a backup that can be started on a read-only server without having to go through recovery, you must use both the WAIT BEFORE START and WITH CHECKPOINT LOG NO COPY clauses. The WAIT BEFORE START clause ensures that the rollback log is empty, and the WITH CHECKPOINT LOG NO COPY clause ensures that the checkpoint log is empty. If either of these files is missing, then recovery is required." I will try the database backup again one more time ... but if it fails, can I send Sybase the database to see what is wrong with it? From what I read (here and what you wrote), I should be able to use the SA11 Unload Database Wizard to open/unload/reload a Sybase 9.02 database --- right? If the database doesn't require recovery, this is correct. Regards, -- Jeff Albion, Sybase iAnywhere iAnywhere Developer Community : http://www.sybase.com/developer/libr...ere-techcorner iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals SQL Anywhere Patches and EBFs : http://downloads.sybase.com/swd/summ...&timeframe =0 Report a Bug/Open a Case : http://case-express.sybase.com/cx/ |
#17
| |||
| |||
|
|
There was significant effort put in to make the move to SA10 (the version that introduced the file format change) - and newer versions - as free of issues as possible. You should not upgrade the java that ships with SQL Anywhere and used by the java tools. These tools were only tested with the java version that shipped. Other installed java versions would not be used by the tools so upgrading those would not impact SQL Anywhere. I then created a new empty database, and tried using ISQL to bring the >> data in from an unloaded "SQL" statement, and it's error after error >> about authentication violations on the user levels. The database must have the database_authentication option set before running on an OEM (aka Authenticated) engine. This makes the database authenticated. If you are upgrading or rebuilding the database, the authenticate.sql file containing that option is used to create an authenticated database. Details of this is discussed in the SA11 documentation referenced below SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » Running the database server » Running authenticated SQL Anywhere applications » Developing an authenticated application or in the Read Me First Authenticated Edition file on the SA9 OEM edition install image. Now, I can't get my database to run whatsoever under V11! I tried >> running it, it won't run. So, you look at the help and it gives >> specific instructions on how to convert a 9.x database using UNLOAD >> which I did to the letter, and it always comes up with the following: (Using Unload and Reload into a new database) **** SQL error: Unable to start specified database: autostarting >> database failed An error occurred while attempting to unload the database c:\roommaster.db This could happen if the database needs to go into an automatic recovery at startup. Can you describe the process used to get the source database used in this process. For example, a database from a backup may be marked as needing recovery. Robert Paresi wrote: Hello, We've been a Sybase user since ASA 6.0 and have many clients -- This is the first time I've been so annoyed and frustrated with Sybase, because I've spent close to 6 hours on this issue, and I'm getting on a plane to do a demo tomorrow and work on a project and I've gotten absolutely nowhere - maybe this is from my own stupidity of loading Windows 7-RC1 instead of just keeping my laptop on Vista. We heavily use Sybase SQL Anywhere 9.02 (hundreds of installations) ... it's worked fine all the time. I installed Windows 7 RC1 on my laptop and Sybase 9.02 will not run Sybase Central or start the database. It gives a JAVA Exception error. I've loaded the latest release of JAVA and this laptop was formatted and just put JAVA, Firefox and Sybase 9.02 on it. Anyway ... after 2 hours of messing around with that...I gave up! I then when to our subscribe net and generated the license for Sybase SQL Anywhere 11, which Sybase has been asking us to use but we've been very comfortable in 9.02 land until now so we might as well be ready for Windows 7. So, I completely uninstalled 9.02 from my laptop, deleted every trace of it, rebooted. I then downloaded and installed ASA 11 and did all the updates (EBF) to 11.0.1.2052 with our newly generated license. Now, I can't get my database to run whatsoever under V11! I tried running it, it won't run. So, you look at the help and it gives specific instructions on how to convert a 9.x database using UNLOAD which I did to the letter, and it always comes up with the following: (Using Unload and Reload into a new database) **** SQL error: Unable to start specified database: autostarting database failed An error occurred while attempting to unload the database c:\roommaster.db .... So I went back to my V9.02 server at work, verified the database and upgraded it making sure it was completely fine. I then took the DB and LOG files and try an unload again, no dice - same exact error. I then created a new empty database, and tried using ISQL to bring the data in from an unloaded "SQL" statement, and it's error after error about authentication violations on the user levels. We have well over 150 customers now to convert to V11 from V9.02, and we can't have this type of hoops and issues. It needs to be smooth....and unloading and reloading a database is fine for them, but what's the deal? Can I send this database to Sybase to look at and see why it won't work under V11? I really need this by 11AM EST on Monday (I know, I'm pretty much screwed -- my fault, I should have just left Vista on my machine - but what can I say) 1. We need Sybase to make sure 9.02 works on Windows 7 2. I need this database convertible to V11 along with our 150+ other customers someday - but this one test one needs to work first. Please help me out ... I really need some answers fast. Thank you!! -Robert |
#18
| |||
| |||
|
|
There was significant effort put in to make the move to SA10 (the version that introduced the file format change) - and newer versions - as free of issues as possible. You should not upgrade the java that ships with SQL Anywhere and used by the java tools. These tools were only tested with the java version that shipped. Other installed java versions would not be used by the tools so upgrading those would not impact SQL Anywhere. I then created a new empty database, and tried using ISQL to bring the >> data in from an unloaded "SQL" statement, and it's error after error >> about authentication violations on the user levels. The database must have the database_authentication option set before running on an OEM (aka Authenticated) engine. This makes the database authenticated. If you are upgrading or rebuilding the database, the authenticate.sql file containing that option is used to create an authenticated database. Details of this is discussed in the SA11 documentation referenced below SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » Running the database server » Running authenticated SQL Anywhere applications » Developing an authenticated application or in the Read Me First Authenticated Edition file on the SA9 OEM edition install image. Now, I can't get my database to run whatsoever under V11! I tried >> running it, it won't run. So, you look at the help and it gives >> specific instructions on how to convert a 9.x database using UNLOAD >> which I did to the letter, and it always comes up with the following: (Using Unload and Reload into a new database) **** SQL error: Unable to start specified database: autostarting >> database failed An error occurred while attempting to unload the database c:\roommaster.db This could happen if the database needs to go into an automatic recovery at startup. Can you describe the process used to get the source database used in this process. For example, a database from a backup may be marked as needing recovery. Robert Paresi wrote: Hello, We've been a Sybase user since ASA 6.0 and have many clients -- This is the first time I've been so annoyed and frustrated with Sybase, because I've spent close to 6 hours on this issue, and I'm getting on a plane to do a demo tomorrow and work on a project and I've gotten absolutely nowhere - maybe this is from my own stupidity of loading Windows 7-RC1 instead of just keeping my laptop on Vista. We heavily use Sybase SQL Anywhere 9.02 (hundreds of installations) ... it's worked fine all the time. I installed Windows 7 RC1 on my laptop and Sybase 9.02 will not run Sybase Central or start the database. It gives a JAVA Exception error. I've loaded the latest release of JAVA and this laptop was formatted and just put JAVA, Firefox and Sybase 9.02 on it. Anyway ... after 2 hours of messing around with that...I gave up! I then when to our subscribe net and generated the license for Sybase SQL Anywhere 11, which Sybase has been asking us to use but we've been very comfortable in 9.02 land until now so we might as well be ready for Windows 7. So, I completely uninstalled 9.02 from my laptop, deleted every trace of it, rebooted. I then downloaded and installed ASA 11 and did all the updates (EBF) to 11.0.1.2052 with our newly generated license. Now, I can't get my database to run whatsoever under V11! I tried running it, it won't run. So, you look at the help and it gives specific instructions on how to convert a 9.x database using UNLOAD which I did to the letter, and it always comes up with the following: (Using Unload and Reload into a new database) **** SQL error: Unable to start specified database: autostarting database failed An error occurred while attempting to unload the database c:\roommaster.db .... So I went back to my V9.02 server at work, verified the database and upgraded it making sure it was completely fine. I then took the DB and LOG files and try an unload again, no dice - same exact error. I then created a new empty database, and tried using ISQL to bring the data in from an unloaded "SQL" statement, and it's error after error about authentication violations on the user levels. We have well over 150 customers now to convert to V11 from V9.02, and we can't have this type of hoops and issues. It needs to be smooth....and unloading and reloading a database is fine for them, but what's the deal? Can I send this database to Sybase to look at and see why it won't work under V11? I really need this by 11AM EST on Monday (I know, I'm pretty much screwed -- my fault, I should have just left Vista on my machine - but what can I say) 1. We need Sybase to make sure 9.02 works on Windows 7 2. I need this database convertible to V11 along with our 150+ other customers someday - but this one test one needs to work first. Please help me out ... I really need some answers fast. Thank you!! -Robert |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.