After Upgrade to Sites 11gR1 Unable To Save Asset With PickOrderAsset Attributes: ORA-00972: identifier is too long
(Doc ID 1543650.1)
Last updated on APRIL 30, 2021
Applies to:
Oracle WebCenter Sites - Version 11.1.1.6.0 and laterInformation in this document applies to any platform.
Symptoms
User gets "Error 0 encountered while saving." while trying to save a Flex asset.
The logs contain an exception:
[2013-04-04 11:47:59,710 EST] [ERROR] [http-8080-2] [fatwire.logging.cs.db] SQLException executing query: SELECT status FROM MyAssetType_C WHERE id=Attribute_myAttributeWithPickOrderAsset
java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:780)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:855)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4219)
at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4348)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1774)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:299)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at COM.FutureTense.Servlet.JDBCConn.ExecuteQuery_trans(JDBCConn.java:983)
at COM.FutureTense.Servlet.JDBCConn.ExecuteQuery(JDBCConn.java:611)
at COM.FutureTense.Common.ftDBTable.doSQL(ftDBTable.java:2190)
at COM.FutureTense.CatalogManager.CatalogEngine.runSQL(CatalogEngine.java:2731)
at COM.FutureTense.CatalogManager.CatalogEngine._queryAndCache(CatalogEngine.java:4940)
at COM.FutureTense.CatalogManager.CatalogEngine._queryAndCacheTrans(CatalogEngine.java:4913)
at COM.FutureTense.CatalogManager.CatalogEngine.processSQL(CatalogEngine.java:4880)
at COM.FutureTense.Common.CS.SQL(CS.java:1105)
at COM.FutureTense.Common.CS.SQL(CS.java:1053)
at com.openmarket.assetframework.complexasset.ComplexAsset.QuerySQL(ComplexAsset.java:1639)
at com.openmarket.assetframework.complexasset.ComplexAsset.isLegalAsset(ComplexAsset.java:1729)
at com.openmarket.gator.common.AttributeValue.MapValues(AttributeValue.java:2415)
at com.openmarket.gator.common.AttributeValue.setImmediateAttributes(AttributeValue.java:1782)
at com.openmarket.gator.common.AttributeIndex.setImmediateAttributes(AttributeIndex.java:1361)
at com.openmarket.gator.flexassets.FlexAssetManager.incrementalSave(FlexAssetManager.java:425)
at com.openmarket.gator.flexassets.FlexAssetManager.writeLocalData(FlexAssetManager.java:279)
at com.openmarket.assetframework.common.BulkTransactionalAssetManager.writeLocalData(BulkTransactionalAssetManager.java:85)
at com.openmarket.assetframework.common.BulkTransactionalAssetManager.saveAllNoPubLock(BulkTransactionalAssetManager.java:305)
at com.openmarket.assetframework.complexasset.ComplexAsset.SaveAllNoPubLock(ComplexAsset.java:2450)
Changes
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 |
Changes |
Cause |
Solution |
References |