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.
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
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