Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Marco Ferretti
Error converting checking algorithm
February 22, 2012 3:36 AM
Answer

Marco Ferretti

Rank: Junior Member

Posts: 62

Join Date: October 4, 2010

Recent Posts

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 :


 1
 212:29:25,009 DEBUG [MaintenanceUtil:64] Executing com.liferay.portal.convert.ConvertPermissionAlgorithm
 312:29:25,013 INFO  [ConvertProcess:41] Starting conversion for com.liferay.portal.convert.ConvertPermissionAlgorithm
 412:29:26,279 DEBUG [MaintenanceUtil:64] Processing Groups_Permissions
 512:29:26,283 INFO  [Table:371] Starting backup of Groups_Permissions to /tmp/tomcat6-tmp/temp-db-Groups_Permissions-1329910166283
 612:29:26,288 INFO  [Table:407] Finished backup of Groups_Permissions to /tmp/tomcat6-tmp/temp-db-Groups_Permissions-1329910166283 in 5 ms
 712:29:26,289 DEBUG [MaintenanceUtil:64] Processing OrgGroupPermission
 812:29:26,290 INFO  [Table:371] Starting backup of OrgGroupPermission to /tmp/tomcat6-tmp/temp-db-OrgGroupPermission-1329910166290
 912:29:26,294 INFO  [Table:407] Finished backup of OrgGroupPermission to /tmp/tomcat6-tmp/temp-db-OrgGroupPermission-1329910166290 in 4 ms
1012:29:26,294 DEBUG [MaintenanceUtil:64] Processing Users_Permissions
1112:29:26,295 INFO  [Table:371] Starting backup of Users_Permissions to /tmp/tomcat6-tmp/temp-db-Users_Permissions-1329910166295
1212:29:26,298 INFO  [Table:407] Finished backup of Users_Permissions to /tmp/tomcat6-tmp/temp-db-Users_Permissions-1329910166295 in 3 ms
1312:29:26,299 DEBUG [MaintenanceUtil:64] Converted to RBAC permission
1412:29:26,299 DEBUG [MaintenanceUtil:64] Generating ResourceAction and ResourcePermission data
1512:29:26,300 INFO  [Table:371] Starting backup of ResourceCode to /tmp/tomcat6-tmp/temp-db-ResourceCode-1329910166300
1612:29:26,322 INFO  [Table:407] Finished backup of ResourceCode to /tmp/tomcat6-tmp/temp-db-ResourceCode-1329910166300 in 22 ms
1712:29:26,394 INFO  [Table:371] Starting backup of ResourcePermissionView to /tmp/tomcat6-tmp/temp-db-ResourcePermissionView-1329910166394
1812:29:26,396 INFO  [Table:407] Finished backup of ResourcePermissionView to /tmp/tomcat6-tmp/temp-db-ResourcePermissionView-1329910166394 in 2 ms
1912:29:26,406 INFO  [Table:371] Starting backup of ResourcePermissionView to /tmp/tomcat6-tmp/temp-db-ResourcePermissionView-1329910166406
2012: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}
21com.liferay.portal.convert.ConvertException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "and9961"
22  Position: 363
23    at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:53)
24    at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.java:47)
25    at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java:32)
26    at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:63)
27    at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:56)
28    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
29    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
30    at java.lang.Thread.run(Thread.java:662)
31Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "and9961"
32  Position: 363
33    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
34    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
35    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
36    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
37    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
38    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
39    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
40    at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:383)
41    at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:347)
42    at com.liferay.portal.convert.ConvertPermissionAlgorithm.convertResourcePermission(ConvertPermissionAlgorithm.java:344)
43    at com.liferay.portal.convert.ConvertPermissionAlgorithm.convertToBitwise(ConvertPermissionAlgorithm.java:158)
44    at com.liferay.portal.convert.ConvertPermissionAlgorithm.doConvert(ConvertPermissionAlgorithm.java:660)
45    at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:44)
46    ... 7 more


This looks like a bug to me ( something in an SQL ) ; is there any solution to this ?

TIA


Marco
Marco Ferretti
RE: Error converting checking algorithm
April 27, 2012 1:27 AM
Answer

Marco Ferretti

Rank: Junior Member

Posts: 62

Join Date: October 4, 2010

Recent Posts

Now a different error message :


 1
 210: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}
 3com.liferay.portal.convert.ConvertException: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
 4  Position: 363
 5    at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:53)
 6    at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.java:47)
 7    at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java:32)
 8    at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:63)
 9    at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:56)
10    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
11    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
12    at java.lang.Thread.run(Thread.java:662)
13Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
14  Position: 363
15    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
16    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
17    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
18    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
19    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
20    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
21    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
22    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
23    at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:383)
24    at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:347)
25    at com.liferay.portal.convert.ConvertPermissionAlgorithm.convertResourcePermission(ConvertPermissionAlgorithm.java:344)
26    at com.liferay.portal.convert.ConvertPermissionAlgorithm.convertToBitwise(ConvertPermissionAlgorithm.java:158)
27    at com.liferay.portal.convert.ConvertPermissionAlgorithm.doConvert(ConvertPermissionAlgorithm.java:660)
28    at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:44)
29    ... 7 more



Any clue as when we'll be able to convert the permission algorithm ?
Marco Ferretti
RE: Error converting checking algorithm
May 2, 2012 1:44 AM
Answer

Marco Ferretti

Rank: Junior Member

Posts: 62

Join Date: October 4, 2010

Recent Posts

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 :

 1
 210: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}}
 3com.liferay.portal.convert.ConvertException: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
 4  Position: 363
 5    at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:53)
 6    at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.java:47)
 7    at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java:32)
 8    at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:65)
 9    at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:101)
10    at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._runTask(ThreadPoolExecutor.java:669)
11    at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:580)
12    at java.lang.Thread.run(Thread.java:662)
13Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
14  Position: 363
15    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
16    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
17    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
18    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
19    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
20    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
21    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
22    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
23    at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:183)
24    at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:147)
25    at com.liferay.portal.convert.ConvertPermissionAlgorithm.convertResourcePermission(ConvertPermissionAlgorithm.java:369)
26    at com.liferay.portal.convert.ConvertPermissionAlgorithm.convertToBitwise(ConvertPermissionAlgorithm.java:165)
27    at com.liferay.portal.convert.ConvertPermissionAlgorithm.doConvert(ConvertPermissionAlgorithm.java:693)
28    at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:44)
29    ... 7 more


This task is getting more and more urgent since AFAIK LF6.2 will not support anything else than algorithm 6