RE: RE: LP CE v.7.4 - db_upgrade_client.bat errors for missing default values.

thumbnail
Ivano Carrara, modified 2 Years ago. Expert Posts: 350 Join Date: 7/3/05 Recent Posts

I use to remove from portal-ext.properties the out-of-the-box configurations from the 'Company' section.

In default.admin.screen.name=test I remove 'test' and put for example 'myuser'
In company.default.web.id=liferay.com I remove 'liferay.com' and put for example 'someco.com'

In Liferay Portal CE v.7.4 while running the db_upgrade_client.bat procedure I get the following errors:

ERROR [main][BatchEngineUnitProcessorImpl:181] Unable to get default company ID
com.liferay.portal.kernel.exception.NoSuchCompanyException: No Company exists with the key {webId=liferay.com}

ERROR [main][BatchEngineUnitProcessorImpl:197] Unable to get default user ID
com.liferay.portal.kernel.exception.NoSuchUserException: No User exists with the key {companyId=0, screenName=test}

At the end of the upgrade process I get the below INFO message:

INFO  [main][UpgradeRecorder:162] Micro upgrade finished with result failure

But as you can see below the migration 'Looks good':

Completed Liferay upgrade process in 86 seconds
Checking to see if all upgrades have completed...
Looks good.

Can anyone explain me why and if this causes problems in the upgraded database?

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

Hi @Ivano,

The inconsistent upgrade result message is fixed here:
https://liferay.atlassian.net/browse/LPS-186413

​​​​​​​Regarding the error, can you add company.default.web.id with the webId for your default Company in the portal-upgrade-ext.properties?

​​​​​​​

thumbnail
Ivano Carrara, modified 2 Years ago. Expert Posts: 350 Join Date: 7/3/05 Recent Posts

Hello Alberto, thank you for your comment.

About the inconsistent upgrade result message, it is clear.

About portal-upgrade-ext.properties contents I just saw here: https://learn.liferay.com/w/dxp/installation-and-upgrades/upgrading-liferay/reference/database-upgrade-tool-reference#configuring-the-upgrade-tool

but I can't see there is the company.default.web.id option.

Please where I can find the complete list of options I can use in *.properties configuration files?

Thank you in advance for your support.
​​​​​​​Ivano

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

Hi Ivano,

the portal-upgrade-ext.properties admits the same properties than the regular portal-ext.properties:
https://docs.liferay.com/portal/7.4-latest/propertiesdoc/portal.properties.html

except for the ones to specify the database connection which is handled in a separate file.

It's highly recommended to copy all your properties into the portal-upgrade-ext.properties before the upgrade. This is mentioned here:
https://learn.liferay.com/w/dxp/installation-and-upgrades/upgrading-liferay/reference/database-upgrade-tool-reference#manual-configuration
​​​​​​​
That will solve the issue.
​​

thumbnail
Ivano Carrara, modified 2 Years ago. Expert Posts: 350 Join Date: 7/3/05 Recent Posts

Hi Alberto,

That solved the issue.

Thank you very much.
​​​​​​​Ivano