on 2015 Sep 06 12:29 PM
After upgrading from version 10.0.1.3794 -> (in the middle 12.0.1.3519) -> 16.0.02019, when trying to connect Sybase Central we received the following message:
“You are attempting to connect to a version 10 database running on version 16.0.0.2018 server. In order for Sybase Central to use this database, it must be unloaded and reloaded into a new database (Sybase Central only supports databases created by version 11 and later software)”
And it gives me the option to use the unload database wizard.
First, the database is files are fully upgraded (include the use of ALTER DATABSE command).
It seems that only Sybase Central affected by this, as we can connect through Interactive SQL without a problem.
Second, when trying to unload database we received the following error (tried from Sybase Central wizard and from command line using dbunload utility as well):
“* SQL error: Invalid option 'timestamp_with_time_zone_format' -- no PUBLIC setting exists”
What can we do in order to:
a) Using Sybase Central
b) Unload database successfully
Thanks in advance,
Ohad Nir
DB Software Engineer
Allot Communications
Tel +972 09 7619245
Cell +972 58 6658096
onir@allot.com
www.allot.com
Request clarification before answering.
The data type timestamp_with_time_zone and option "timestamp_with_time_zone_format" were introduced in version 12.
This may be due to a small (but undiagnosed) bug exposed by your upgrade sequence but you should try setting the public option and see if that is your only issue here.
Do let us know what your results with that change show.
For what it is worth, upgrades do not fully upgrade a database. Some features will require a rebuild (as in dbunload) ran from the newest version's utilities.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Sorry for the late answer.
This actually solved the issue.
We set the option as follows:
set option PUBLIC.TIMESTAMP_WITH_TIME_ZONE_FORMAT = 'YYYY-MM-DD HH:NN:SS.SSS ';
thanks and best regards
User | Count |
---|---|
61 | |
8 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.