Sybase Central won’t work after upgrade database to version 16.0.02019

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

upgrade sybase-central dbunload

asked 06 Sep '15, 11:29

onir
45●2●2●6
accept rate: 0%

flat view

One Answer:

active answers oldest answers newest answers popular answers

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.

permanent link

answered 08 Sep '15, 12:13

Nick Elson S...
7.3k●35●107
accept rate: 32%

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

(20 Sep '15, 03:41) onir

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

sybase-central ×128
upgrade ×62
dbunload ×52

question asked: 06 Sep '15, 11:29

question was seen: 3,509 times

last updated: 20 Sep '15, 03:41

SAP SQL Anywhere

Sybase Central won’t work after upgrade database to version 16.0.02019

Follow this question

Related questions