Fórumok
Error converting checking algorithm
Marco Ferretti, módosítva 12 év-val korábban
Error converting checking algorithm
Regular Member Bejegyzések: 100 Csatlakozás dátuma: 2010.10.04. Legújabb bejegyzések
Hi all,
I have finished upgrading a liferay instance form 5.2.3 to 6.0.6 but had to keep the legacy-5.2.properties in order to be able to do so.
Now, planning to migrate to liferay 6.1, I am trying to get rid of all the things that might cause problems. One of these is the checking algorithm. The portal instance I am upgrading is very old so the checking algorithm is 2 ( had to override the legacy properties ) . I went in the control panel and tried to fire the conversion but I get the following exception :
This looks like a bug to me ( something in an SQL ) ; is there any solution to this ?
TIA
Marco
I have finished upgrading a liferay instance form 5.2.3 to 6.0.6 but had to keep the legacy-5.2.properties in order to be able to do so.
Now, planning to migrate to liferay 6.1, I am trying to get rid of all the things that might cause problems. One of these is the checking algorithm. The portal instance I am upgrading is very old so the checking algorithm is 2 ( had to override the legacy properties ) . I went in the control panel and tried to fire the conversion but I get the following exception :
12:29:25,009 DEBUG [MaintenanceUtil:64] Executing com.liferay.portal.convert.ConvertPermissionAlgorithm
12:29:25,013 INFO [ConvertProcess:41] Starting conversion for com.liferay.portal.convert.ConvertPermissionAlgorithm
12:29:26,279 DEBUG [MaintenanceUtil:64] Processing Groups_Permissions
12:29:26,283 INFO [Table:371] Starting backup of Groups_Permissions to /tmp/tomcat6-tmp/temp-db-Groups_Permissions-1329910166283
12:29:26,288 INFO [Table:407] Finished backup of Groups_Permissions to /tmp/tomcat6-tmp/temp-db-Groups_Permissions-1329910166283 in 5 ms
12:29:26,289 DEBUG [MaintenanceUtil:64] Processing OrgGroupPermission
12:29:26,290 INFO [Table:371] Starting backup of OrgGroupPermission to /tmp/tomcat6-tmp/temp-db-OrgGroupPermission-1329910166290
12:29:26,294 INFO [Table:407] Finished backup of OrgGroupPermission to /tmp/tomcat6-tmp/temp-db-OrgGroupPermission-1329910166290 in 4 ms
12:29:26,294 DEBUG [MaintenanceUtil:64] Processing Users_Permissions
12:29:26,295 INFO [Table:371] Starting backup of Users_Permissions to /tmp/tomcat6-tmp/temp-db-Users_Permissions-1329910166295
12:29:26,298 INFO [Table:407] Finished backup of Users_Permissions to /tmp/tomcat6-tmp/temp-db-Users_Permissions-1329910166295 in 3 ms
12:29:26,299 DEBUG [MaintenanceUtil:64] Converted to RBAC permission
12:29:26,299 DEBUG [MaintenanceUtil:64] Generating ResourceAction and ResourcePermission data
12:29:26,300 INFO [Table:371] Starting backup of ResourceCode to /tmp/tomcat6-tmp/temp-db-ResourceCode-1329910166300
12:29:26,322 INFO [Table:407] Finished backup of ResourceCode to /tmp/tomcat6-tmp/temp-db-ResourceCode-1329910166300 in 22 ms
12:29:26,394 INFO [Table:371] Starting backup of ResourcePermissionView to /tmp/tomcat6-tmp/temp-db-ResourcePermissionView-1329910166394
12:29:26,396 INFO [Table:407] Finished backup of ResourcePermissionView to /tmp/tomcat6-tmp/temp-db-ResourcePermissionView-1329910166394 in 2 ms
12:29:26,406 INFO [Table:371] Starting backup of ResourcePermissionView to /tmp/tomcat6-tmp/temp-db-ResourcePermissionView-1329910166406
12:29:26,422 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: org.postgresql.util.PSQLException: ERROR: syntax error at or near "and9961"
Position: 363
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: org.postgresql.util.PSQLException: ERROR: syntax error at or near "and9961"
Position: 363
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
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:344)
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
This looks like a bug to me ( something in an SQL ) ; is there any solution to this ?
TIA
Marco
Marco Ferretti, módosítva 11 év-val korábban
RE: Error converting checking algorithm
Regular Member Bejegyzések: 100 Csatlakozás dátuma: 2010.10.04. Legújabb bejegyzések
Now a different error message :
Any clue as when we'll be able to convert the permission algorithm ?
10:21:47,186 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: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
Position: 363
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: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
Position: 363
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
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:344)
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
Any clue as when we'll be able to convert the permission algorithm ?
Marco Ferretti, módosítva 11 év-val korábban
RE: Error converting checking algorithm
Regular Member Bejegyzések: 100 Csatlakozás dátuma: 2010.10.04. Legújabb bejegyzések
I just deployed and upgraded a test portal from LF6.0.6 to LF 6.1 and I still get errors upgrading the checking algorithm :
This task is getting more and more urgent since AFAIK LF6.2 will not support anything else than algorithm 6
10:41:07,093 FATAL [ConvertProcessMessageListener:35] Unable to process message {destinationName=liferay/convert_process, response=null, responseDestinationName=null, responseId=null, payload=com.liferay.portal.convert.ConvertPermissionAlgorithm, values={principalPassword=null, principalName=51651, companyId=10112}}
com.liferay.portal.convert.ConvertException: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
Position: 363
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:65)
at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:101)
at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._runTask(ThreadPoolExecutor.java:669)
at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:580)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
Position: 363
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:183)
at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:147)
at com.liferay.portal.convert.ConvertPermissionAlgorithm.convertResourcePermission(ConvertPermissionAlgorithm.java:369)
at com.liferay.portal.convert.ConvertPermissionAlgorithm.convertToBitwise(ConvertPermissionAlgorithm.java:165)
at com.liferay.portal.convert.ConvertPermissionAlgorithm.doConvert(ConvertPermissionAlgorithm.java:693)
at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:44)
... 7 more
This task is getting more and more urgent since AFAIK LF6.2 will not support anything else than algorithm 6