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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.