1. Home
  2. Development
  3. RE: Issue Upgrading Database from 6.2 to 7.2.1-ga2

RE: Issue Upgrading Database from 6.2 to 7.2.1-ga2

srini vasulu, modified 4 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_
 

Attachments:

thumbnail
Christoph Rabel, modified 4 Years ago.
RE: Issue Upgrading Database from 6.2 to 7.2.1-ga2
Liferay Legend Posts: 1555 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 4 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 4 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?
thumbnail
Olaf Kock, modified 4 Years ago.
RE: Issue Upgrading Database from 6.2 to 7.2.1-ga2
Liferay Legend Posts: 6441 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.