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

Last updated on NOVEMBER 03, 2016

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

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