Hi,
We have a form that uses labkey's javascript API to insert form data into a labkey list. The form works fine in 12.2, but on our 12.3 staging server, we get this error back from the LABKEY.Query.insertRows() function:
"ERROR: Functions cannot have more than 100 arguments."
And in tomcat's error logs:
ERROR Table 2012-12-03 10:40:46,167 http-8080-Processor17 : SQL Exception
org.postgresql.util.PSQLException: ERROR: functions cannot have more than 100 arguments
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:372)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:364)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
at org.labkey.api.data.dialect.StatementWrapper.execute(StatementWrapper.java:984)
at org.labkey.api.data.Table.execute(Table.java:189)
at org.labkey.api.data.SqlExecutor.execute(SqlExecutor.java:71)
at org.labkey.api.data.LegacySqlExecutor.execute(LegacySqlExecutor.java:39)
at org.labkey.api.data.Table.execute(Table.java:442)
at org.labkey.api.data.StatementUtils.createStatement(StatementUtils.java:542)
at org.labkey.api.data.StatementUtils.insertStatement(StatementUtils.java:116)
at org.labkey.api.etl.TableInsertDataIterator.init(TableInsertDataIterator.java:76)
at org.labkey.api.etl.TableInsertDataIterator.onFirst(TableInsertDataIterator.java:102)
at org.labkey.api.etl.StatementDataIterator.next(StatementDataIterator.java:157)
at org.labkey.api.etl.TableInsertDataIterator.next(TableInsertDataIterator.java:33)
at org.labkey.api.etl.MapDataIterator$MapDataIteratorImpl.next(MapDataIterator.java:112)
at org.labkey.api.etl.WrapperDataIterator.next(WrapperDataIterator.java:67)
at org.labkey.api.query.AbstractQueryUpdateService$1.next(AbstractQueryUpdateService.java:190)
at org.labkey.api.etl.Pump.run(Pump.java:60)
at org.labkey.api.query.AbstractQueryUpdateService._pump(AbstractQueryUpdateService.java:199)
at org.labkey.api.query.AbstractQueryUpdateService._importRowsUsingETL(AbstractQueryUpdateService.java:172)
at org.labkey.api.query.AbstractQueryUpdateService._insertRowsUsingETL(AbstractQueryUpdateService.java:231)
at org.labkey.list.model.ListQueryUpdateService.insertRows(ListQueryUpdateService.java:78)
at org.labkey.query.controllers.QueryController$CommandType$1.saveRows(QueryController.java:2870)
at org.labkey.query.controllers.QueryController$BaseSaveRowsAction.executeJson(QueryController.java:3062)
at org.labkey.query.controllers.QueryController$InsertRowsAction.execute(QueryController.java:3129)
at org.labkey.query.controllers.QueryController$InsertRowsAction.execute(QueryController.java:3122)
at org.labkey.api.action.ApiAction.handlePost(ApiAction.java:152)
at org.labkey.api.action.ApiAction.handleRequest(ApiAction.java:87)
at org.labkey.api.action.BaseViewAction.handleRequestInternal(BaseViewAction.java:172)
at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at org.labkey.api.action.SpringActionController.handleRequest(SpringActionController.java:353)
at org.labkey.api.module.DefaultModule.dispatch(DefaultModule.java:1058)
at org.labkey.api.view.ViewServlet.service(ViewServlet.java:157)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.labkey.api.data.TransactionFilter.doFilter(TransactionFilter.java:36)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.labkey.core.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:118)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.labkey.api.module.ModuleLoader.doFilter(ModuleLoader.java:697)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.labkey.api.security.AuthFilter.doFilter(AuthFilter.java:170)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:679)
Any ideas as to what could be going on? |