topic Re: Export does not work in Alfresco Archive

Export does not work

bambergc — Wed, 21 Sep 2011 07:26:01 GMT

We are trying to migrate data from Alfresco 3.4.0, which caused us a lot of problems, to Alfresco 3.4.d, which seems to work fine (after upgrading pdfbox and fontbox jars).Just copying the database and the dir.root to the new installation didn't work, would have been too easy.Now we are trying the e

Re: Export does not work

bambergc — Wed, 21 Sep 2011 09:14:07 GMT

Forgot to mention: no error message in alfresco.log.

Re: Export does not work

mrogers — Wed, 21 Sep 2011 09:26:25 GMT

Even if you could generate an ACP it's is not suitable for data migration of an entire repository since its only a subset of information.

What went wrong when you tried upgrading?

Re: Export does not work

bambergc — Thu, 22 Sep 2011 06:02:39 GMT

Bascically the connection to the database is refused:

WARN [org.hibernate.cfg.SettingsFactory] Could not obtain connection metadata org.apache.commons.dbcp.SQLNestedException: cannot create PoolableConnectionFactory (Access denied for user 'alfresco'@'localhost' (using password: YES))

I did check in the meantime into this, and it looks like a conflict between the databases. As both databases have the same name, just a different password. I tried to manually startup the copied database and can't connect with the password used on the 3.4.0 database, but can connect with the new password used on the 3.4.d database. Does MYSQL store passwords outside the database? I'm thinking now about reinstalling alfresco and use a different database name for the new install to make sure there can't be a name conflict.

Anyway, this won't resolve my ultimate problem, as my boss wants to use an Oracle DB now, and he says that you can migrate any Jira content using the acp export/import way, so it should also work for Alfresco ….

Re: Export does not work

bambergc — Thu, 22 Sep 2011 07:34:14 GMT

This morning I tried to reinstall Alfresco3.4.d, using the same password for the database as on the old 3.4.0 install. The error message I get now when trying to connect to share:

WARN [org.springframework.jdbc.support.SQLErrorCodesFactory] Error while extracting database product name - falling back to empty error codes
org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed by the driver.

Now MYSQL is trying contantly to restart mysqld_safe:

mysqld_safe Number of processes running now: 0
mysqld_safe mysqld restarted
mysqld_safe Number of processes running now: 0
mysqld_safe mysqld restarted
mysqld_safe Number of processes running now: 0
mysqld_safe mysqld restarted
…..

Re: Export does not work

bambergc — Thu, 22 Sep 2011 13:02:42 GMT

I reinstalled again and tweaked around with the MYSQL database, creating a new database as root user, giving alfresco user all rights, then dumping the database from old server and importing into newly created database, changed the config files to point to the new database …. and now I get the info from the old Alfresco 3.4.0 database on the server with the Alfresco 3.4.d installation.

But, helas, now Alfresco randomly hangs on pdf uploads. Not the process on the server side, but the client browser.

And still no news about the acp export.