Export does not work

[bambergc]

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 export the whole repository to an .acp file. So I select the Company Home space which includes all the data I want to migrate and select Export in the Administration Console. When I run this nothing happens. No acp created. Tried with multiple parameter values, as checking "Include this Space" or not, selecting different destinations,running as background process or not.

I let Alfresco run the whole night, so it's not that I didn't wait for the export to finish. CPU usage close to 0% and no files created on the system.

We are running on Red Hat Enterprise Linux Server release 5.5 (Tikanga) and JRE 6.0_18

[bambergc]

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

[mrogers]

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?

[bambergc]

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 ….

[bambergc]

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
…..

[bambergc]

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.