Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Hi, Can i ask some help on this please, how can i solve this problem "JZ0SJ: Metadata accessor information was not found on this database"....I could not log into my account in my application. please help me sybase people.

Thank you in advance.

asked 18 Dec '13, 08:55

mathiascolebar's gravatar image

mathiascolebar
35337
accept rate: 0%


This can occur if jConnect metadata support is not installed in the database file. When creating the database, you have the option of installing the supporting metadata (it is installed by default). Upgrading the database file will allow you to install this support. (See this documentation page)

permanent link

answered 18 Dec '13, 09:19

Mikel%20Rychliski's gravatar image

Mikel Rychliski
2.1k1641
accept rate: 32%

Hi Thank you for the reply... On my other computer my database and my application works fine,but on this computer that i am using it right now is not working it gives me that error.. i don't know why..i tried your suggestion but the metadata checkbox is greyed out and i can't tick on the checkbox...when i continue to upgrade it fails it says that cannot upgrade when the "mydb" is in used!.Here is a little info for the sybase i use maybe the this will help you..Adaptive Server Anywhere 9 version 9.0.2.3951 and the sybase central 4.3.0.2475..thank you in advance.

(18 Dec '13, 12:43) mathiascolebar
Replies hidden

For 9.0.2, you cannot use 'ALTER DATABASE UPGRADE' to install the jConnect metadata system objects - this feature was added in SQL Anywhere 10.

For 9.0.2, you will instead need to run a specific SQL file against your database that is included with the SQL Anywhere install. See: %ASANY9%\scripts\jcatalog.sql

(18 Dec '13, 16:50) Jeff Albion
Your answer
toggle preview

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

Question tags:

×128

question asked: 18 Dec '13, 08:55

question was seen: 2,479 times

last updated: 18 Dec '13, 16:51