"ORA-01795: Maximum Number Of Expressions In A List Is 1000" When Editing an Asset
(Doc ID 1588525.1)
Last updated on NOVEMBER 04, 2022
Applies to:
Oracle WebCenter Sites - Version 11.1.1.6.1 and laterInformation 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)
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 |