weblogic.store.io.jdbc.JDBCStoreException: [Store:280065] (Doc ID 1395613.1)

Last updated on AUGUST 07, 2017

Applies to:

Oracle WebLogic Server - Version 10.3 and later
Information in this document applies to any platform.

Symptoms

Customers report being unable to start the server. The following error is received:

<Jan 6, 2012 1:20:21 PM EST> <Error> <Store> <BEA-280072> <JDBC store "p13nJMSPersistenceStore_auto_1" failed to open table "qa-_1WLStore".
weblogic.store.io.jdbc.JDBCStoreException: [Store:280065][Store:280068]JDBC store failed to initialize. It did not find its database table and failed trying to create a new empty table using the commands in file "/weblogic/store/io/jdbc/ddl/oracle.ddl". (server="qa-ucxportal_m01" store="p13nJMSPersistenceStore_auto_1" table="qa-_1WLStore")Linked Cause, "java.sql.SQLSyntaxErrorException: ORA-00922: missing or invalid option")
at weblogic.store.io.jdbc.JDBCStoreIO.createTable(JDBCStoreIO.java:609)
at weblogic.store.io.jdbc.JDBCStoreIO.open(JDBCStoreIO.java:346)
at weblogic.store.internal.PersistentStoreImpl.recoverStoreConnections(PersistentStoreImpl.java:332)
at weblogic.store.internal.PersistentStoreImpl.open(PersistentStoreImpl.java:323)
at weblogic.store.admin.AdminHandler.activate(AdminHandler.java:135)
Truncated. see log file for complete stacktrace

Changes

Following is configuration snippet in config.xml:

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms