"ORA-01795: Maximum Number Of Expressions In A List Is 1000" When Editing an Asset (Doc ID 1588525.1)

Last updated on JULY 07, 2017

Applies to:

Oracle WebCenter Sites - Version 11.1.1.6.1 and later
Information in this document applies to any platform.

Symptoms

The user is unable to edit any content assets. The browser shows a 500 error.

The sites.log show errors:

[2013-09-26 21:50:29,626 CST] [ERROR] [.kernel.Default (self-tuning)'] [fatwire.logging.cs.db] SQLException executing query: SELECT cs_ownerid AS ownerid,cs_tname AS tname FROM Template_TName WHERE cs_tname LIKE '/%' AND cs_ownerid IN ({more than 1000 IDs})
java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
  at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:851)
  at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
  at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4656)
  at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4789)
  at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1894)
  at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1855)
  at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:304)
  at weblogic.jdbc.wrapper.Statement.execute(Statement.java:466)
  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.access$800(CatalogEngine.java:44)
  at COM.FutureTense.CatalogManager.CatalogEngine$8.execute(CatalogEngine.java:4921)
  at com.fatwire.cs.core.db.NestedTransactionBlock.execute(NestedTransactionBlock.java:180)
  at COM.FutureTense.CatalogManager.CatalogEngine._queryAndCacheTrans(CatalogEngine.java:4927)
  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.basic.common.BaseTable.querySQL(BaseTable.java:293)
  at com.openmarket.basic.common.BaseTable.querySQL(BaseTable.java:268)
  at com.openmarket.xcelerate.common.CalledTable.getTypelessChildren(CalledTable.java:204)
  at com.openmarket.xcelerate.asset.TemplateManager.listTNames(TemplateManager.java:2409)
  at com.openmarket.xcelerate.asset.TemplateManager.listUniqueNames(TemplateManager.java:1921)
  at com.openmarket.xcelerate.commands.TemplateManagerDispatcher.GetTemplateNames(TemplateManagerDispatcher.java:83)
  at sun.reflect.GeneratedMethodAccessor301.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:597)
  at com.openmarket.framework.commands.Dispatcher.Execute(Dispatcher.java:145)
  at COM.FutureTense.XML.Template.DynTag.execute(DynTag.java:269)
  at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
  at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
  at COM.FutureTense.XML.Template.IfChild.execute(BlockTag.java:397)
  at COM.FutureTense.XML.Template.IFTag.execute(BlockTag.java:496)
  at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:144)
  at COM.FutureTense.XML.Template.BlockTag.execute(BlockTag.java:120)
  at COM.FutureTense.XML.Template.Root.execute(BlockTag.java:365)
  at COM.FutureTense.XML.Template.XMLEval.run(XMLEval.java:331)
  at COM.FutureTense.Common.ContentServer.evalTheXML(ContentServer.java:3199)
  at COM.FutureTense.Common.ContentServer.evalTemplate(ContentServer.java:2460)
  at COM.FutureTense.Common.ContentServer.processElement(ContentServer.java:1908)
  at COM.FutureTense.Common.CS.CallElement(CS.java:1603)
  at com.divine.ics.jsp.CallElement.doEndTag(CallElement.java:84)
  at com.openmarket.framework.jsp.Base.doEndTag(Base.java:143)
  at jsp_servlet._jsp._cs_deployed._openmarket._gator._flexibleassets._flexassets.__contentform1._jspService(__contentform1.java:1490)
  at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)

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