My Oracle Support Banner

Publish fails with "ORA-00907: missing right parenthesis" (Doc ID 1913238.1)

Last updated on NOVEMBER 01, 2022

Applies to:

Oracle WebCenter Sites - Version 7.6.2 and later
Information in this document applies to any platform.

Symptoms

Publish to target fails and the following exception is found in the logs on target:

2014-07-26 09:57:11,267 BST] [ERROR] [http-bio-12121-exec-1] [fatwire.logging.cs.db] SQLException executing statement: CREATE TABLE tt1406353797882 (id NUMBER(38) PRIMARY KEY NOT NULL, reskey VARCHAR(255) NOT NULL, bdata Btrueecure.TreeManager=true NULL, bdatasize NUMBER(38) NULL, encoding VARCHAR(255) NULL, type VARCHAR(32) NULL, pubsession NUMBER(38) NOT NULL, pubgroup VARCHAR(256) NULL)
java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.