Forums

Home » Liferay Portal » English » 3. Development

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Gwowen Fu
Server Administration > Data Migration Failure
May 31, 2012 2:49 PM
Answer

Gwowen Fu

Rank: Expert

Posts: 315

Join Date: December 27, 2010

Recent Posts

Hi,
I tried to move data from Oracle to MySQL database.

I created a new lportal database and ran Control Panel > Server > Server Administration > Data Migration but failed with the following errors, one of the error is insufficient privileges, I used the root account for MySQL, do I need admin account for Oracle?

INFO: Illegal access: this web application instance has been stopped already. C
ould not load com.liferay.portlet.usernotifications.model.impl.UserNotificationE
ventImpl. The eventual following stack trace is caused by an error thrown for d
ebugging purposes as well as to attempt to terminate the thread which caused the
illegal access, and has no functional impact.
java.lang.IllegalStateException
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoa
der.java:1587)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoa
der.java:1546)
at com.liferay.portal.convert.ConvertDatabase.getImplClass(ConvertDataba
se.java:206)
at com.liferay.portal.convert.ConvertDatabase.doConvert(ConvertDatabase.
java:109)
at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java
:44)
at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.do
Receive(ConvertProcessMessageListener.java:47)
at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.re
ceive(ConvertProcessMessageListener.java:32)
at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(In
vokerMessageListener.java:65)
at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDes
tination.java:101)
at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._r
unTask(ThreadPoolExecutor.java:669)
at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.ru
n(ThreadPoolExecutor.java:580)
at java.lang.Thread.run(Thread.java:662)
15:56:07,660 WARN [404_jsp:109] /favicon.ico
15:56:37,689 WARN [404_jsp:109] /favicon.ico
15:57:07,746 WARN [404_jsp:109] /favicon.ico
15:57:12,858 ERROR [ConvertDatabase:112] Unable to load class com.liferay.portle
t.usernotifications.model.impl.UserNotificationEventImpl
15:57:12,859 DEBUG [ConvertDatabase:106] Loading class com.liferay.portlet.wiki.
model.impl.WikiNodeImpl
15:57:12,861 DEBUG [ConvertDatabase:106] Loading class com.liferay.portlet.wiki.
model.impl.WikiPageImpl
15:57:12,862 DEBUG [ConvertDatabase:106] Loading class com.liferay.portlet.wiki.
model.impl.WikiPageResourceImpl
15:57:12,863 DEBUG [ConvertDatabase:146] Migrating database tables
15:57:12,873 INFO [Table:171] Starting backup of Counter to C:\dev\tools\tomcat
\7.0.25\temp/temp-db-Counter-1338497832873
15:57:12,915 INFO [Table:207] Finished backup of Counter to C:\dev\tools\tomcat
\7.0.25\temp/temp-db-Counter-1338497832873 in 42 ms
15:57:13,023 FATAL [ConvertProcessMessageListener:35] Unable to process message
{destinationName=liferay/convert_process, response=null, responseDestinationName
=null, responseId=null, payload=com.liferay.portal.convert.ConvertDatabase, valu
es={principalPassword=null, principalName=12901, companyId=10154}}
com.liferay.portal.convert.ConvertException: java.sql.SQLSyntaxErrorException: O
RA-01031: insufficient privileges

at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java
:53)
at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.do
Receive(ConvertProcessMessageListener.java:47)
at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.re
ceive(ConvertProcessMessageListener.java:32)
at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(In
vokerMessageListener.java:65)
at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDes
tination.java:101)
at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._r
unTask(ThreadPoolExecutor.java:669)
at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.ru
n(ThreadPoolExecutor.java:580)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:999)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1315)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatem
ent.java:1822)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java
:1787)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStateme
ntWrapper.java:280)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(Delegat
ingStatement.java:228)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(Delegat
ingStatement.java:228)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:237)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:197)
at com.liferay.portal.convert.ConvertDatabase.migrateTable(ConvertDataba
se.java:248)
at com.liferay.portal.convert.ConvertDatabase.doConvert(ConvertDatabase.
java:161)
at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java
:44)
... 7 more


Thanks!
Gwowen
David H Nebinger
RE: Server Administration > Data Migration Failure
May 31, 2012 3:38 PM
Answer

David H Nebinger

Community Moderator

Rank: Liferay Legend

Posts: 11783

Join Date: September 1, 2006

Recent Posts

Not necessarily an admin account for Oracle, but at least use the credentials that you were using for Oracle previously...
Gwowen Fu
RE: Server Administration > Data Migration Failure
May 31, 2012 8:31 PM
Answer

Gwowen Fu

Rank: Expert

Posts: 315

Join Date: December 27, 2010

Recent Posts

David H Nebinger:
Not necessarily an admin account for Oracle, but at least use the credentials that you were using for Oracle previously...


Hi David,

I don't get it. My Liferay portal is using Oracle DB. Do I have to configure the Oracle credentials for "Data Migration" separately?

Thanks!
Gwowen
Hitoshi Ozawa
RE: Server Administration > Data Migration Failure
June 1, 2012 5:26 AM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

David means to just use the Oracle user/password you have been using with liferay.
Gwowen Fu
RE: Server Administration > Data Migration Failure
June 1, 2012 7:39 AM
Answer

Gwowen Fu

Rank: Expert

Posts: 315

Join Date: December 27, 2010

Recent Posts

Hitoshi Ozawa:
David means to just use the Oracle user/password you have been using with liferay.


Hi Hitoshi,
I am using the Oracle user/password I have been using with liferay. Does the "Server Administration > Data Migration" allows migrate data from Oracle to MySQL?

My goal is to migrate development Liferay instance to another environment. Liferay 6.1 Community Edition and Oracle DB on both environments. For testing purpose I am testing "Server Administration > Data Migration" with my local MySQL database.

Is the function of "Data Migration" same as backing up Liferay DB and import it to another database?

Could you check if the steps are correct to migrate a Liferay instance?
1. Backup Liferay DB.
2. Import DB to new machine.
3. Install Liferay on new machine.
4. Update database connection for Liferay Instance on new machine.
5. Copy Liferay data directory over to new machine.

Thanks!
Gwowen
Hitoshi Ozawa
RE: Server Administration > Data Migration Failure
June 1, 2012 4:35 PM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

If you can migration Oracle data to Mysql without using liferay's data migration tool, that's be fine too.

I was just wondering if the current liferay version running if Oracle is also 6.1.0 GA1? Migration tool is just a migration tool to transfer data and it won't upgrade the data.
Gwowen Fu
RE: Server Administration > Data Migration Failure
June 7, 2012 9:00 AM
Answer

Gwowen Fu

Rank: Expert

Posts: 315

Join Date: December 27, 2010

Recent Posts

David H Nebinger:
Not necessarily an admin account for Oracle, but at least use the credentials that you were using for Oracle previously...


Thanks, tried on different database and everything is working.
Ranga Rao Bobbili
RE: Server Administration > Data Migration Failure -- algorithm 4 to 6
September 4, 2012 8:24 AM
Answer

Ranga Rao Bobbili

Rank: Regular Member

Posts: 152

Join Date: July 20, 2007

Recent Posts

Hi All,
I am trying to migrate permission algorithm 4 to 6 and getting below exception.

[#|2012-09-04T09:40:26.593-0500|INFO|glassfish3.0.1|javax.enterprise.system.std.com.sun.enterprise.v3.services.impl|_ThreadID=40;_ThreadName=Thread-1;|09:40:26,593 INFO [Table:407] Finished backup of ResourcePermissionView to C:\Users\rbobbili\AppData\Local\Temp\/temp-db-ResourcePermissionView-1346769626590 in 3 ms
|#]

[#|2012-09-04T09:40:26.596-0500|INFO|glassfish3.0.1|javax.enterprise.system.std.com.sun.enterprise.v3.services.impl|_ThreadID=40;_ThreadName=Thread-1;|09:40:26,596 INFO [Table:371] Starting backup of ResourcePermissionView to C:\Users\rbobbili\AppData\Local\Temp\/temp-db-ResourcePermissionView-1346769626596
|#]

[#|2012-09-04T09:40:26.608-0500|INFO|glassfish3.0.1|javax.enterprise.system.std.com.sun.enterprise.v3.services.impl|_ThreadID=40;_ThreadName=Thread-1;|09:40:26,608 FATAL [ConvertProcessMessageListener:35] Unable to process message {destinationName=liferay/convert_process, responseDestinationName=null, responseId=null, payload=com.liferay.portal.convert.ConvertPermissionAlgorithm, values=null}
com.liferay.portal.convert.ConvertException: java.sql.SQLException: ORA-00933: SQL command not properly ended

at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:53)
at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.java:47)
at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java:32)
at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:63)
at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:56)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: ORA-00933: SQL command not properly ended

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:785)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:860)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1202)
at com.sun.gjc.spi.jdbc40.PreparedStatementWrapper40.executeQuery(PreparedStatementWrapper40.java:641)
at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:383)
at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:347)
at com.liferay.portal.convert.ConvertPermissionAlgorithm.convertResourcePermission(ConvertPermissionAlgorithm.java:345)
at com.liferay.portal.convert.ConvertPermissionAlgorithm.convertToBitwise(ConvertPermissionAlgorithm.java:158)
at com.liferay.portal.convert.ConvertPermissionAlgorithm.doConvert(ConvertPermissionAlgorithm.java:660)
at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:44)
... 7 more
|#]

My Development environment:
Liferay Portal 6.0.5
Glassfish 3.0.1
Oracle9

Please give me your valuable suggestions to resolve this issue.

Thanks in advance........................

Regards,
Ranga Rao