Vue combinée Vue Plate Arborescence
Sujets [ Précédent | Suivant ]
toggle
Andy Harb
Migrating from Oracle to MySQl
17 juillet 2013 16:04
Réponse

Andy Harb

Rang: Junior Member

Publications: 64

Date d'inscription: 22 octobre 2009

Publications Récentes

Hi,

For cost savings we decided to shift our infrastructure off of Oracle and onto MySQL.

I ran the Server Administration --> Data Migration --> Database Migration

Everything went through and the tables where created successfully in MySQL. We have the machine configured to store images and documents in the Database. However, after I changed the server to point to the new MySQL tables and restarted the server It is unable to find the Documents. The metadata displays but anytime i try to download one i get an error saying it can't find the document.

I reconfigured the portal-ext.properties, repository.xml and workspaces.xml but am I missing anything else that may cause this?

Liferay 6.0 EE SP2 -- Oracle 11g --> MySQL (Amazon RDS)

Error:
22:55:23,265 INFO [PortalImpl:4387] com.liferay.documentlibrary.NoSuchFileException: {fileName=706, versionLabel=1.0}
com.liferay.documentlibrary.NoSuchFileException: {fileName=706, versionLabel=1.0}
David H Nebinger
RE: Migrating from Oracle to MySQl
17 juillet 2013 20:05
Réponse

David H Nebinger

Rang: Liferay Legend

Publications: 7024

Date d'inscription: 1 septembre 2006

Publications Récentes

Have you tried rebuilding the indices since you're on a new database? I wouldn't expect it to help resolve doc issues, but it could...

You changed the database, but is the data directory still the same?
Andy Harb
RE: Migrating from Oracle to MySQl
18 juillet 2013 07:20
Réponse

Andy Harb

Rang: Junior Member

Publications: 64

Date d'inscription: 22 octobre 2009

Publications Récentes

I rebuilt them last night and still am having the same issue. The data directory is still the same and hasn't changed. The only thing that was modified was the references to MySQL.

Thanks David,
Andy