1. Home
  2. Development
  3. RE: Unable to view users in Control Panel Post DB Migration to LiferayDXP7.

RE: Unable to view users in Control Panel Post DB Migration to LiferayDXP7.

sharath a, modified 6 Years ago.
Unable to view users in Control Panel Post DB Migration to LiferayDXP7.1
New Member Posts: 3 Join Date: 1/13/17 Recent Posts
Hi

     I have done DB migration from Liferay6.2 t o7.1. The migrated DB has 20Users in 'user_' table.
     While trying to view the users from ControlPanel, i am unable to view users.

     Also played with default avialble filters and Executed 'All Re-indexes' from Server Administration but was of no use.

     But while trying to Export Users, I got all users list, which i have seen in 'user_' table of my migrated DB.

     Do i need to update anything in portal-legacy.properties file.

      Need help here.



Regards.
thumbnail
Jorge Díaz, modified 6 Years ago.
RE: Unable to view users in Control Panel Post DB Migration to LiferayDXP7.
Liferay Master Posts: 753 Join Date: 1/9/14 Recent Posts
Hi Sharath,

While trying to view the users from ControlPanel, i am unable to view users.

     Also played with default avialble filters and Executed 'All Re-indexes' from Server Administration but was of no use.

     But while trying to Export Users, I got all users list, which i have seen in 'user_' table of my migrated DB.

If you are only having problems with users list in Control Panel, but users are working fine in other places, your problem is in Indexation/Search functionality.

Did you check your log file for error/exception traces?

Which search engine are you using? (Embedded Elasticsearch, Remote Elasticsearch or Solr)
(Notice that Embedded Elasticsearch is not supported for production environments)

Try reindexing your search index and check your log file. If you that doesn't help you, try manually deleting your index and reindex again.

You can also try my "Index Checker" portlet:

It detects which objects are not correctly indexed and you can reindex only the wrong ones without executing a full reindex.

Regards,
Jorge
sharath a, modified 6 Years ago.
RE: Unable to view users in Control Panel Post DB Migration to LiferayDXP7.
New Member Posts: 3 Join Date: 1/13/17 Recent Posts
After my POSTGRESQL-DB Migration, I am able to view the sites(which were created Liferay6.2) in the ControlPanel->Sites.

Now i have seen the USERS, where i didnt find anyone in ControlPanel(including the LOGGED-IN user).
While DB Migration, i didnt found any errors.

Also Did have any error in my Log after couple of RESTART's for Liferay 7.1.
I was using the default Search Engine.

Is there any LOG to crosscheck the status of my DB MIGRATION.
thumbnail
Jorge Díaz, modified 6 Years ago.
RE: Unable to view users in Control Panel Post DB Migration to LiferayDXP7.
Liferay Master Posts: 753 Join Date: 1/9/14 Recent Posts
Hi,

About:
Now i have seen the USERS, where i didnt find anyone in ControlPanel(including the LOGGED-IN user).

As I said in my previous comment, If Users are not displayed in Control Panel, but they are in database and you can login without any problem, the root cause of your problems is in Indexation/Search functionality.

Control Panel retrieves user list from Search Engine, it doesn't use database, so in case your Search Engine has any indexation problem, Control Panel doesn't display anything.

Perhaps your search engine is deactivated: If you deactivated search engine during upgrade process, after finishing this process, you have to re-enable it.
Double check search engine configuration. Have a look to:
After checking your search engine configuration, reindex again.


About:
I was using the default Search Engine.

Default search engine in Liferay 7.0 and 7.1 is "Embedded Elasticsearch". This search engine will work for development or demo purposes, but it is not suitable for production environment.
For production environments you should install a Elasticsearch server and configure Liferay in "Remote Elasticsearch" mode, more information see:
sharath a, modified 6 Years ago.
RE: Unable to view users in Control Panel Post DB Migration to LiferayDXP7.
New Member Posts: 3 Join Date: 1/13/17 Recent Posts
Thanks a lot Jorge Díaz for your response.

I was also trying to have 'INDEX SEARCH' portlet from marketplace.
Also i will check the status of Search Engine & do accordingly 


Regards