Affects Version/s: 7.0.X, 7.1.X, Master
Upgrading from 6.2 to 7.1, if there are too many Organizations with logo exists under 6.2, the 7.1 upgrade process fails with ORA-01000: maximum open cursors exceeded error, if Oracle DB is used.
This might affect other DB vendors as well, but due to time constraints, I was unable to test it.
We suspect that the cause of this issue lies in UpgradeOrganization.java, where multiple prepared statements remain unclosed.
As the code for this process is unchanged on master, I did not perform any additional tests with branch bundles.
- Start Liferay Portal 6.2
- Run attached CreateOrganization.groovy script after modifying the image path to point to an existing image file to your
- Stop the Portal then run the 7.1 upgrade process