• ERROR IMPORT

  • We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
We tried to make OpenKM as intuitive as possible, but an advice is always welcome.
Forum rules: Please, before asking something see the documentation wiki or use the search feature of the forum. And remember we don't have a crystal ball or mental readers, so if you post about an issue tell us which OpenKM are you using and also the browser and operating system version. For more info read How to Report Bugs Effectively.
 #49009  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
 #49028  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?
 #49037  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"/>
 #49051  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.

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.