ERROR IMPORT

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.
Post Reply
Cristina890
Fresh Boarder
Fresh Boarder
Posts: 7
Joined: Mon Aug 12, 2019 12:32 pm

ERROR IMPORT

Post by Cristina890 » Thu Oct 03, 2019 1:27 pm

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

jllort
Moderator
Moderator
Posts: 10911
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: ERROR IMPORT

Post by jllort » Sun Oct 06, 2019 7:52 am

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?

Cristina890
Fresh Boarder
Fresh Boarder
Posts: 7
Joined: Mon Aug 12, 2019 12:32 pm

Re: ERROR IMPORT

Post by Cristina890 » Mon Oct 07, 2019 1:20 pm

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"/>

jllort
Moderator
Moderator
Posts: 10911
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: ERROR IMPORT

Post by jllort » Tue Oct 08, 2019 9:52 pm

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.

Post Reply