Unable To Install Content Folios Component. ORA-00911: invalid character Error. (Doc ID 602680.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle WebCenter Content - Version: 10.1.3.3.2 and later   [Release: 10gR3 and later ]
Information in this document applies to any platform.
Oracle Universal Content Management - Version: 10.1.3.3.2 and later   [Release: 10gR3 and later ]

Symptoms

When installing Folios the following error occurs and the Content Server will not start:

Error 6/10/08 7:41 PM Error creating primary key on CpdLinks table Unable to execute SQL statement
'ALTER TABLE CpdLinks MODIFY dRevisionType VARCHAR(30) NOT NULL;'. ORA-00911: invalid character
java.sql.SQLException: ORA-00911: invalid character [ Details ]
An error has occurred. The stack trace below shows more information.

!$Error creating primary key on CpdLinks table!csDbUnableToExecuteSql,ALTER TABLE CpdLinks MODIFY
dRevisionType VARCHAR(30) NOT NULL;!$ORA-00911: invalid
character<br>!syExceptionType2,java.sql.SQLException,ORA-00911: invalid character<br>
intradoc.data.DataException: !csDbUnableToExecuteSql,ALTER TABLE CpdLinks MODIFY dRevisionType
VARCHAR(30) NOT NULL;!$ORA-00911: invalid character

at intradoc.jdbc.JdbcWorkspace.executeSQL(JdbcWorkspace.java:867)
at folios.FolioInstallFilter.contentFoliosUpgrade(FolioInstallFilter.java:438)
at folios.FolioInstallFilter.doFilter(FolioInstallFilter.java:62)
at intradoc.shared.PluginFilters.filter(PluginFilters.java:92)
at intradoc.server.IdcExtendedLoader.executeFilter(IdcExtendedLoader.java:268)
at intradoc.server.IdcExtendedLoader.extraBeforeCacheLoadInit(IdcExtendedLoader.java:238)
at intradoc.server.IdcSystemLoader.loadCaches(IdcSystemLoader.java:925)
at intradoc.server.IdcServerManager.init(IdcServerManager.java:79)
at IdcServerNT.init(IdcServerNT.java:76)
at IdcServerNT.main(IdcServerNT.java:52)
Caused by: java.sql.SQLException: ORA-00911: invalid character

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4039)
at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4191)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1618)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579)
at intradoc.jdbc.JdbcWorkspace.executeSQL(JdbcWorkspace.java:857)
... 9 more


.

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