Fórumok

Error converting checking algorithm

thumbnail
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 :



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
thumbnail
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 :



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 ?
thumbnail
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 :


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