-
Type:
Service Pack Request
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: 2.2.7
-
Component/s: Repository
-
Labels:None
-
Environment:Stack 3: Solaris 10 Sparc x64, Weblogic 10.3.2.0 (JDK 1.6.0_17-b04), Oracle 11.2.0.1.0 x64.
-
Bug Priority:
-
ACT Numbers:
17268
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 2.2.5.483 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.