RE: about upgrade process and issues

Scarletake Bwi, modified 4 Years ago. Expert Posts: 327 Join Date: 12/20/10 Recent Posts

hi

i try migrade my LR from 6.2 to 7.3. 
i got many issues, could anyone please help me to check my process?

step 1. copy document_library from 6.2

step 2. create 3 config files
com.liferay.portal.search.configuration.IndexStatusManagerConfiguration.config
indexReadOnly="true"

com.liferay.portal.store.file.system.configuration.AdvancedFileSystemStoreConfiguration.config
rootDir="C:/liferay-ce-portal-7.3.5-ga6/data/document_library"

com.liferay.portal.upgrade.internal.configuration.ReleaseManagerConfiguration.config
autoUpgrade="false"

step 3. modify 3 properties files in tools
app-server.properties

portal-upgrade-database.properties

portal-upgrade-ext.properties
liferay.home=../../
module.framework.base.dir=../../osgi
dl.store.impl=com.liferay.portal.store.file.system.AdvancedFileSystemStore


step 4. run db_upgrade.bat

 

step 5. delete

com.liferay.portal.search.configuration.IndexStatusManagerConfiguration.config

com.liferay.portal.store.file.system.configuration.AdvancedFileSystemStoreConfiguration.config

com.liferay.portal.upgrade.internal.configuration.ReleaseManagerConfiguration.config

 

step 6. start server via develop studio. 


issue 1. not only navigation menu, many portlet inactivate. 

the log show in console, but i don't know how to add Resource Permissions for me and all users.

User 0 is not allowed to serve resource for http://localhost:8080/signin on com_liferay_product_navigation_personal_menu_web_internal_portlet_PersonalMenuPortlet: User 0 must have ACCESS permission for Personal Menu com_liferay_product_navigation_personal_menu_web_internal_portlet_PersonalMenuPortlet 
User 0 is not allowed to serve resource for http://localhost:8080/signin on com_liferay_product_navigation_applications_menu_web_internal_portlet_ProductNavigationApplicationsMenuPortlet: User 0 must have ACCESS permission for Simulation com_liferay_product_navigation_applications_menu_web_internal_portlet_ProductNavigationApplicationsMenuPortlet 


issue 2. i check user_ and orgnization_, all data still there, but i cannot find any user and org via control panel. 

question 1. is my porcess right? what different between trigger portal-tools-db-upgrade-client from develop studio and db_upgrade.bat?
question 2. in document of upgrade to 7.2, i have to type command during updating db, but now it just run untill finish.
question 3. if my user only use my custon portlets, no wiki, no blog or any else. is there any way JUST move user, orgnization and role data from 6.2 to 7.3 and use an new server? 

 

thank you

 

update 

after i try reindexing: Control Panel / Configuration / Search / Index Actions / Reindex all (or just the entities in question)

all user and org shows.

thumbnail
Alberto Chaparro, modified 4 Years ago. Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts

Hi Scarletake,

I have a question about the steps you provided:

  • Why are setting com.liferay.portal.upgrade.internal.configuration.ReleaseManagerConfiguration.config
    autoUpgrade="false"? With that configuration you are disabling auto upgrade for modules so you need to run manually with the Gogo Shell.

My guess is that the modules haven't been upgraded so that's the reason you are getting those errors. Can you rerun the upgrade with that property set to true (default value)

 

 

Scarletake Bwi, modified 4 Years ago. Expert Posts: 327 Join Date: 12/20/10 Recent Posts

hi Alberto

in fact, i have no idea, i just follow the article

Running-the-Upgrade-Process

but even i don't set this config, it doesn't change.

i will redo again and set autoUpgrade="true".

could you please tell me how to do with gogo?

thank you

Scarletake Bwi, modified 4 Years ago. Expert Posts: 327 Join Date: 12/20/10 Recent Posts

hi Alberto

i just did it again.

it's strange, db_upgrade.bat create an folde named "${catalina.base}", it had a folder "webapps" inside, and the webapps is empty.

and navigation menu still inactive.

 

and the first time run server, have many error message.

2021-01-20 10:06:41.311 ERROR [http-nio-8080-exec-4][ImageImpl:69] Error reading image 34502
java.lang.IllegalStateException: Store is not available
    at com.liferay.portlet.documentlibrary.store.StoreFactory.getStore(StoreFactory.java:115)
    at com.liferay.portlet.documentlibrary.store.DLStoreImpl.getFileAsStream(DLStoreImpl.java:285)
2021-01-20 10:07:08.065 ERROR [http-nio-8080-exec-10][ImageImpl:69] Error reading image 34502
java.lang.IllegalStateException: Store is not available
    at com.liferay.portlet.documentlibrary.store.StoreFactory.getStore(StoreFactory.java:115)

thumbnail
Alberto Chaparro, modified 4 Years ago. Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts

Hi Scarletake,

Here you have the documentation about the gogo shell commands related to upgrades:

https://help.liferay.com/hc/en-us/articles/360017897392-Gogo-Shell-Commands-for-Module-Upgrades

Anyway, with the property set to true, the upgrades should run automatically (we specify in the documentation you pointed out that it can be set to false but it is not required, the default value is the optimal for most of the cases)

You have to check the whole upgrade log before starting up. After share it here of you have any question. 

Regarding the Catalina folder, please, check all properties are properly set before the upgrade.

Scarletake Bwi, modified 4 Years ago. Expert Posts: 327 Join Date: 12/20/10 Recent Posts

hi

i tried two ways to upgrade. from develop studio and directly by db_upgrade.bat

from develop studio, i just settel up the server and run it, it will trigger db upbrade process autometially. i do not know it read the config of osgi or not, i got many duplicate issue in initResourceActions.

from db_upgrade.bat, it strate from start to the end, no error. but, when i start server, got NoSuchFileException, when i checked the folder in document_library, it's empty, and i really sure it exist after i restore from old server. however, after i restore again, the exception do not show again.

db_upgrade.bat way is better so far, but nevigation menu cannot show in both upgrade way. 

any suggestion?

again, thank you.

thumbnail
Alberto Chaparro, modified 4 Years ago. Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts

Hi Scarletake,

Don't worry about that folder, it's just a temporary folder.

Regarding this:
java.lang.IllegalStateException: Store is not available

Can you attach the whole log file to take a look?

Thanks.

Scarletake Bwi, modified 4 Years ago. Expert Posts: 327 Join Date: 12/20/10 Recent Posts

hi mr. alberto

first, thank you very much for reply, i almost give up.

and, very sorry for reply late, too busy.

i do not know how to upload file attachment, i paste my memo and install log. i try many times to upgrade, and each time's log in memo the process and what i did not did not. try to find way out.

output.2021-01-21.log

i also try open all log level to ALL, too many log.

and i also try create a new navigation bar, doesn't work.

thank you.

 

 

thumbnail
Alberto Chaparro, modified 4 Years ago. Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts

Hi Scarletake,

The upgrade seems that have been completed successfully. Regarding the error trying to find the image, you shouldn't remove the file:

com.liferay.portal.store.file.system.configuration.AdvancedFileSystemStoreConfiguration.config

Before the startup since it's required to tell Liferay where are the document files.

In regards to the permission errors, I am not sure what is happening but be sure you have copied all old portal-ext.properties to the new installation and migrated the ones that have been moved to OSGi.

Scarletake Bwi, modified 4 Years ago. Expert Posts: 327 Join Date: 12/20/10 Recent Posts

hi mr. alberto

i just do it again, and this time i did not remove 

com.liferay.portal.store.file.system.configuration.AdvancedFileSystemStoreConfiguration.config

i do not understand what 

migrated the ones that have been moved to OSGi

mean. 

fail again. 

i do not sure, the folder hierarchy and file name and database are different

my first time start, log shows

com.liferay.document.library.kernel.exception.NoSuchFileException: {companyId=0, repositoryId=0, fileName=34502.png, cause=java.io.FileNotFoundException: C:\liferay-ce-portal-7.3.5-ga6\data\document_library\0\0\34\50\34502.png\34502_1.0.png (蝟餌絞?銝????楝敺??)}
    at com.liferay.portal.store.file.system.FileSystemStore.getFileAsStream(FileSystemStore.java:140)

from my backup, the file is

data\document_library\0\0\34502.png\1.0

 

i will try it again tonight.

 

thank you, 

have a nice day

 

Scarletake Bwi, modified 4 Years ago. Expert Posts: 327 Join Date: 12/20/10 Recent Posts

hi

i try upgrade many times

2021-02-01.log

i still have two issues

issue 1. navigation bar inactive (no exception message)
issue 2. root organization inactive(NoSuchResourcePermissionException)

i also find that, if want avoice document_library folder hierarchy issue. 

use dl.store.impl=com.liferay.portal.store.file.system.FileSystemStore in portal-upgrade-ext.properties and portal-ext.properties

 

thumbnail
Alberto Chaparro, modified 4 Years ago. Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts

Hi Scarletake,It is weird you have a company with id 1. How many companies are you using? Can you provide the content of the Company table before the upgrade? I would like to check it? 

You can also try to run the verifyResourcePermission in 6.2 before the upgrade. You can do that, setting the following properties and then restarting the server:

verify.frequency=-1
verify.processes=com.liferay.portal.verify.VerifyResourcePermissions
Don't forget to remove those properties after the execution!
Scarletake Bwi, modified 4 Years ago. Expert Posts: 327 Join Date: 12/20/10 Recent Posts

hi, mr. alberto

thank you so much for you reply.

one, only one company, and only one record in table Company, before and after are same.

and thank you for your verify salution, is it in portal-ext.properties? or system-ext.properties?

 

have a nice day!

Scarletake Bwi, modified 4 Years ago. Expert Posts: 327 Join Date: 12/20/10 Recent Posts

i got it, is portal-ext.properties

UserGroup not checked by VerifyResourcePermissions

thank you

Scarletake Bwi, modified 4 Years ago. Expert Posts: 327 Join Date: 12/20/10 Recent Posts

10:28:42,316 INFO  [localhost-startStop-1][DialectDetector:136] Found dialect org.hibernate.dialect.MySQLDialect
10:28:47,107 ERROR [localhost-startStop-1][ImageToolImpl:105] Default company logo is not available
10:28:47,108 ERROR [localhost-startStop-1][ImageToolImpl:121] Default organization logo is not available
10:28:59,767 INFO  [localhost-startStop-1][StartupAction:97] There are no patches installed
10:29:00,214 INFO  [localhost-startStop-1][BaseDB:484] Database does not support case sensitive queries
10:29:00,633 INFO  [localhost-startStop-1][VerifyProcess:65] Verifying com.liferay.portal.verify.VerifyResourcePermissions
10:29:00,840 INFO  [pool-3-thread-16][VerifyResourcePermissions:169] Processed 100 resource permissions for com.liferay.portlet.messageboards.model.MBMessage
10:29:01,024 INFO  [pool-3-thread-8][VerifyResourcePermissions:169] Processed 100 resource permissions for com.liferay.portlet.documentlibrary.model.DLFileEntry
10:29:01,222 INFO  [pool-3-thread-16][VerifyResourcePermissions:169] Processed 100 resource permissions for com.liferay.portlet.messageboards.model.MBMessage
10:29:01,399 INFO  [pool-3-thread-16][VerifyResourcePermissions:169] Processed 100 resource permissions for com.liferay.portlet.messageboards.model.MBMessage
10:29:01,491 INFO  [pool-3-thread-13][VerifyResourcePermissions:169] Processed 100 resource permissions for com.liferay.portal.model.Layout
10:29:01,562 INFO  [pool-3-thread-24][VerifyResourcePermissions:169] Processed 100 resource permissions for com.liferay.portal.model.User
10:29:01,607 INFO  [pool-3-thread-16][VerifyResourcePermissions:169] Processed 100 resource permissions for com.liferay.portlet.messageboards.model.MBMessage
10:29:02,138 INFO  [pool-3-thread-24][VerifyResourcePermissions:169] Processed 100 resource permissions for com.liferay.portal.model.User
10:29:02,667 INFO  [pool-3-thread-24][VerifyResourcePermissions:169] Processed 100 resource permissions for com.liferay.portal.model.User
10:29:02,833 INFO  [pool-3-thread-13][VerifyResourcePermissions:169] Processed 100 resource permissions for com.liferay.portal.model.Layout
10:29:03,091 INFO  [pool-3-thread-24][VerifyResourcePermissions:169] Processed 100 resource permissions for com.liferay.portal.model.User
10:29:03,270 INFO  [pool-3-thread-16][VerifyResourcePermissions:169] Processed 100 resource permissions for com.liferay.portlet.messageboards.model.MBMessage
10:29:03,546 INFO  [pool-3-thread-24][VerifyResourcePermissions:169] Processed 100 resource permissions for com.liferay.portal.model.User
10:29:03,899 INFO  [pool-3-thread-24][VerifyResourcePermissions:169] Processed 100 resource permissions for com.liferay.portal.model.User
10:29:04,717 INFO  [pool-3-thread-24][VerifyResourcePermissions:169] Processed 100 resource permissions for com.liferay.portal.model.User
10:29:05,169 INFO  [pool-3-thread-24][VerifyResourcePermissions:169] Processed 100 resource permissions for com.liferay.portal.model.User
10:29:05,918 INFO  [localhost-startStop-1][VerifyResourcePermissions:169] Processed 100 resource permissions for com.liferay.portal.model.Layout
10:29:06,791 INFO  [localhost-startStop-1][VerifyResourcePermissions:169] Processed 100 resource permissions for com.liferay.portal.model.Layout
10:29:07,312 INFO  [localhost-startStop-1][ServerDetector:140] Server supports hot deploy

i did it, but looks well

thumbnail
Alberto Chaparro, modified 4 Years ago. Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts

Great Scarletake!

Now can you try to upgrade to 7.3 with that database where you executed the VerifyResourcePermission?

Thanks.

Scarletake Bwi, modified 4 Years ago. Expert Posts: 327 Join Date: 12/20/10 Recent Posts

hi, mr. alberto

i always use same db to upgrade.

should i use same property in 7.3's portal-ext.properties?

thumbnail
Alberto Chaparro, modified 4 Years ago. Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts

No, remove those properties before upgrading

Scarletake Bwi, modified 4 Years ago. Expert Posts: 327 Join Date: 12/20/10 Recent Posts

hi, alberto

if there have nothing i have to fix, i do not know what i can do.

only root org(company) is inactive.

thumbnail
Alberto Chaparro, modified 4 Years ago. Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts

I asked you to execute the verifyResourcePermissions in 6.2 and then upgrade, have you done that?

Scarletake Bwi, modified 4 Years ago. Expert Posts: 327 Join Date: 12/20/10 Recent Posts

hi mr. alberto

i did, still same result

021-02-04 02:39:40.234 ERROR [http-nio-8080-exec-2][IncludeTag:128] Current URL /user/vic.chen/manage?p_p_id=com_liferay_users_admin_web_portlet_MyOrganizationsPortlet&p_p_lifecycle=0 generates exception: java.lang.IllegalArgumentException: Someone may be trying to circumvent the permission checker: {companyId=1, name=com.liferay.portal.kernel.model.Organization, primKey=22, scope=4}
com.liferay.portal.kernel.exception.NoSuchResourcePermissionException: {companyId=1, name=com.liferay.portal.kernel.model.Organization, primKey=22, scope=4}
    at com.liferay.portal.service.impl.ResourcePermissionLocalServiceImpl.hasResourcePermission(ResourcePermissionLocalServiceImpl.java:1032)
    at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:50)
    at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:69)
    at com.liferay.portal.spring.aop.AopMethodInvocationImpl.proceed(AopMethodInvocationImpl.java:57)

 

Scarletake Bwi, modified 4 Years ago. Expert Posts: 327 Join Date: 12/20/10 Recent Posts

hi 

i add a new org via control panel(ui) to be an new root org, and move all org under the new org.

new the root org can be saw.

but navegation bar still not working. i beleve it because something wrong in resource of conpany.

is there any way to crate an new company and switch to new one?

thumbnail
Alberto Chaparro, modified 4 Years ago. Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts

Hi Scarletake,

We had a similar issue in Support and we were able to solve using the autoupgrade feature, can you set this property to true and startup the 7.3 server to execute the upgrade? You have more information about it here:
https://learn.liferay.com/dxp/7.x/en/liferay-internals/reference/7-3-breaking-changes.html#replaced-osgi-configuration-property-autoupgrade