EXCEL Importer Exception

Hi, We are running our MENDIX application on an ORACLE database. We are using the EXCEL importer to import a bunch of data. When the number of lines exceed a certain amount (we have 545 lines on the sheet) we get the following error: Server error: com.mendix.core.CoreException: com.mendix.core.CoreException: com.mendix.core.CoreException: ab: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded ORA-01000: maximum open cursors exceeded After some google-ing we found the following : http://www.orafaq.com/forum/t/34813/0/ They suggest a couple of solutions on the database side and at the end they say "And it is a BAD solution. The correct one is to fix the application to make it close the no more cursors." Your comments would be greatly appreciated. We would prefer not to make any changes to our database setup, but if you are sure that the problem is not on the MENDIX side we can. Regards Frikkie
2 answers

Hi Frikkie,

We are currently researching this situation. At the moment Mendix needs more than the default number of open cursors to run on Oracle. In another project they raised the value from 300 to 1000. After that everything worked fine.


Has anybody got any comments on this?