Issue Upgrading Database from 6.2 to 7.2.1-ga2

Message Boards

srini vasulu, modified 3 Years ago.

Issue Upgrading Database from 6.2 to 7.2.1-ga2

Regular Member Posts: 139 Join Date: 2/22/11 Recent Posts

Hi
After i followed the steps to upgrade https://help.liferay.com/hc/en-us/articles/360028711612-Introduction-to-Upgrading-to-Liferay-DXP-7-2
i am getting the below error.

com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: cannot drop table user_ because other objects depend on it
Detail: view v_user_emails depends on table user_
view "users-roles_v" depends on table user_
Hint: Use DROP ... CASCADE to drop the dependent objects too.
   at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:101)
   at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:173)
   at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:140)
   at com.liferay.portal.kernel.upgrade.util.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:122)
   at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:154)
   at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:85)
   at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:174)
   at com.liferay.portal.tools.DBUpgrader.main(DBUpgrader.java:105)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:498)
   at com.liferay.portal.tools.db.upgrade.client.DBUpgraderLauncher.main(DBUpgraderLauncher.java:55)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: org.postgresql.util.PSQLException: ERROR: cannot drop table user_ because other objects depend on it
Detail: view v_user_emails depends on table user_
view "users-roles_v" depends on table user_

Christoph Rabel, modified 3 Years ago.

RE: Issue Upgrading Database from 6.2 to 7.2.1-ga2

Liferay Legend Posts: 1554 Join Date: 9/24/09 Recent Posts

v_user_emails and users-roles_v are not Liferay standard. I guess, somebody in your company has created those views manually for some purpose. You probably need to delete them before upgrading the database and if they are still needed, restore them later on.

srini vasulu, modified 3 Years ago.

RE: Issue Upgrading Database from 6.2 to 7.2.1-ga2

Regular Member Posts: 139 Join Date: 2/22/11 Recent Posts

Christoph Rabel:

v_user_emails and users-roles_v are not Liferay standard. I guess, somebody in your company has created those views manually for some purpose. You probably need to delete them before upgrading the database and if they are still needed, restore them later on.

Thanks Christoph Rabel and after removed the views then upgraded database.
but i got again one more issue is users and organizations are not displaying in control pane users tab and organization tabs.But we can see users in site membership place.even i am added below propertiy in portal-ext.properties and restarted server but still same issue# when starting time reindex
database.indexes.update.on.startup=true

Thanks,Srini

srini vasulu, modified 3 Years ago.

RE: Issue Upgrading Database from 6.2 to 7.2.1-ga2

Regular Member Posts: 139 Join Date: 2/22/11 Recent Posts

srini vasulu:

Christoph Rabel:

v_user_emails and users-roles_v are not Liferay standard. I guess, somebody in your company has created those views manually for some purpose. You probably need to delete them before upgrading the database and if they are still needed, restore them later on.

Thanks Christoph Rabel and after removed the views then upgraded database.
but i got again one more issue is users and organizations are not displaying in control pane users tab and organization tabs.But we can see users in site membership place.even i am added below propertiy in portal-ext.properties and restarted server but still same issue# when starting time reindex
database.indexes.update.on.startup=true

Thanks,

Srini

Hi Any one faced the above issue when upgrade to 7.2.1?

Olaf Kock, modified 3 Years ago.

RE: Issue Upgrading Database from 6.2 to 7.2.1-ga2

Liferay Legend Posts: 6403 Join Date: 9/23/08 Recent Posts

srini vasulu:

Hi Any one faced the above issue when upgrade to 7.2.1?

Can you try manual reindexing in ControlPanel? There's a specific reindex activity just for the User data. Typically, when users aren't shown, this is a function of an index being out of date.