Search

Ok, thanks for the instructions on the Windows to Linux move!

Sorry, I recounted it - with the possible jumps it is still 18 upgrades to go from 4.1 to 6.3.

Also, if I go with the 18 step-by-step upgrades at what point can I switch over from Windows to Linux?
Is there a Windows to Linux migration guide somewhere?

Thank you, but going from 4.1 to 6.3 would be 25 steps!
That is just crazy. Also, based on experience I would think that the chance that everything would work through all 25 upgrades and everything would be work when I finally arrive to 6.3 is pretty minimal.
Is this upgrade from subversion to the ...

Hi,
We have an old OpenKM 4.1 on Windows running on Windows Server 2003. Now that the support ends for Windows Server 2003 we are thinking to migrate it to the latest OpenKM version on linux.

Is it possible to migrate our repository of files keeping permissioning, file history, etc from 4.1 on ...

Yes, the above listed error is the first appearing in the server log.

We are planning a migration to 5.1 in a few months, but we have a fairly complicated setup including a php site using web services, MySQL used for database, big repository, etc, so it will require lot of testing of the new ...

Ok, so let me explain it in more details. I actually has two ways to reproduce the same issue:

1. Two users are logging into our Web Services at the same time. The web services reads the completed folder structure by running recursive $OKMFolder->getChilds($token, $path);. It takes about 10-15 sec ...

Hi,
Using webservices we created a front-end, where all folders a read and displayed. It works fine, if we have only one user connected, but if two users (from two different PCs) opens this up about the same time then both get stopped and the server shows NullPointerException.
We are using OpenKM ...

Hi jllort,

As you proposed adding the below has worked - the error message doesn't come up for the users anymore!

<idle-timeout-minutes>28680</idle-timeout-minutes>
<exception-sorter-class-name>com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter</exception-sorter-class-name>
<valid ...

Hi jllort,
Let me answer your questions:

"The origin could be the MySQL restarting ... but let's try understanding more."
>> I agree, that was my guess too

"1- If you've system has been 7 months running the error has started happening now it's not older problem ?"
>> The error was started happning ...

Hi jllort,
I have kept the workspace.xml as it was, I wasn't the one adding that part in what you quoted.


"When you changed the dbms from hypersonic to mysql, the folder repository was deleted ?"
>> When we changed the dbms from hypersonice to mysql the folder repository was not deleted.

"Do you ...

Hi Pavila,
Thanks for the tip. I have changed the idle-timeout-minutes to be less than the wait_time of MySQL, but it didn't solve the problem. The error message is still there.
I have the feeling that this error message is related to the fact that we run a once a day automatic restart of MySQL at a ...

Sorry, I cannot change the MySQL connection to localhost, because it's on a different server. We have a dedicated MySQL server sitting next to the OpenKM server, LAN connection between the two.

From the server logs you asked for the part where it refers to the error:
2011-02-08 23:02:28,136 ERROR ...

Here comes all the details.

openkm-ds.xml
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<!-- OpenKM User Activity -->
<local-tx-datasource>
<jndi-name>OKMActivityDS</jndi-name>
<connection-url>jdbc:mysql://10.65.96.141:3306/okm_activity?autoReconnect=true</connection-url>
<driver-class ...

No, no migration, just the regular 4.1

Unfortunately now I see a new error.
When any user logs in there is an error message popping up:
Error when communicating with server (findUserTaskInstances)
Error when communicating with server (findPooledTaskInstances)

On the server side there are messages about [DbPersistenceService ...