Type: Service Pack Request
Status: Closed (View Workflow)
Affects Version/s: 2.2.7
Environment:Stack 3: Solaris 10 Sparc x64, Weblogic 10.3.2.0 (JDK 1.6.0_17-b04), Oracle 188.8.131.52.0 x64.
Both for 2.2 SP6 (build 514) and SP7 (build 531) used with Oracle database ORA-01795 (maximum number of expressions in a list is 1000) exception appears on attempt to create new user as soon as certain number of users was created (83 for all the tests performed; creation of the 84th fails).
09:14:18,199 ERROR [org.alfresco.web.ui.common.Utils] Failed to create Person due to error: could not execute query
org.hibernate.exception.SQLGrammarException: could not execute query
. . .
Caused by: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000
(please find screen and full log in attach)
As well it seems to be regression since 2.2 SP5: the same tested against 184.108.40.2063 worked fine (including upgrade-to-3.2.0 testing performed in December 2009).
Alfresco versions: 2.2 SP5 (build 483) / 2.2 SP6 (build 514) / 2.2 SP7 (build 531)
JDBC driver: ojdbc14.jar.