Page 1 of 1

ERROR IMPORT

PostPosted:Thu Oct 03, 2019 1:27 pm
by Cristina890
Hello,

I’m running a script provided in the documentation to import documents and folders.
But the import is not completed successfully.

java oracle ora-01000 maximum open cursors exceeded

Re: ERROR IMPORT

PostPosted:Sun Oct 06, 2019 7:52 am
by jllort
That's caused because the script it is opening more connections than what you have configured as maximum by default (usually 300) or because there's something wrong in the code and it is not closing the connections what is creating. What is the documentation URL of the script?

Re: ERROR IMPORT

PostPosted:Mon Oct 07, 2019 1:20 pm
by Cristina890
Hi Jlort,

This is my URL https://docs.openkm.com/kcenter/view/ok ... orter.html and server.xml:

Code: Select all
<Resource auth="Container" driverClassName="oracle.jdbc.driver.OracleDriver"
         maxTotal="-1" maxIdle="30" maxWaitMillis="10000" name="jdbc/OpenKMDS" password="xxx"
         type="javax.sql.DataSource" url="xxxxx"
         username="xxxx" validationQuery="select 1 from dual"/>

Re: ERROR IMPORT

PostPosted:Tue Oct 08, 2019 9:52 pm
by jllort
after how many elements the error has been raised? try to print count in the browser:
Code: Select all
print(count+"<br/>");
count++;
I would like you to create a loop of creating folders, to check if that is causing the issue, or the issue is with document creation. Or maybe in the loop caused by calling the autoImport method. Might be something that is not closing the database connection.