WSRR Oracle database character set must be in UTF-8

Technote (FAQ)


This document applies only to the following language version(s):

English

Question

How do I resolve a NotRegisteredException and SAXParseException with Oracle Database seen during or after WebSphere Service Registry and Repository (WSRR) install?

Cause

If Oracle database character set is not set to UTF-8, WebSphere Service Registry and Repository installation logs and SystemOut show the following errors:

XMetaAccessImpl executeGraphQuery com.ascential.xmeta.exception.usage.NotRegisteredException: The package with URI "http:///com/ibm/sr/Config.ecore" is not registered at com.ascential.xmeta.repository.impl.AbstractDefaultRepository.getPackage
(AbstractDefaultRepository.java:1036)

[ ... ]

org.xml.sax.SAXParseException: An invalid XML character (Unicode: 0x1b) was found in the element content of the document.]]

The installation might fail to complete. Or in some cases, WSRR installation completes, but the Service Registry application fails to start.

Answer

The Oracle Database code / character set must be UTF-8

In Oracle, the correct code / character set will appear as:

CHARACTERSET = "AL32UTF8" ,NATIONALCHARACTERSET= "UTF8 "

Related information

creating oracle database

Historical Number

52509 499 000

Product Alias/Synonym

WSRR
WebSphere Service Registry and Repository

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere Service Registry and Repository
Database

Software version:

6.0.2, 6.1, 6.2, 6.3, 7.0, 8.0

Operating system(s):

AIX, HP Itanium, HP-UX, Linux, Solaris, Windows, z/OS

Software edition:

All Editions

Reference #:

1397435

Modified date:

2013-08-05

Translate my page

Machine Translation

Content navigation