Publish fails with "ORA-00907: missing right parenthesis"
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.
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
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