CRM contact search not working properly

Suggestions on Community Server Installation/Functionality
Post Reply
sanjaya
Posts: 6
Joined: Fri Nov 24, 2017 1:26 pm

CRM contact search not working properly

Post by sanjaya » Fri Oct 11, 2019 3:36 pm

we are running onlyoffice community server Version 10.0.4.959 on CentOS 7 using docker
the CRM search seems to be not working properly - it did not shows some contact which are already in the contacts.
Did anyone having similar issues with onlyoffice CRM ?

Andrew
Posts: 101
Joined: Mon Apr 01, 2019 1:09 pm

Re: CRM contact search not working properly

Post by Andrew » Thu Oct 24, 2019 7:08 am

Hello sanjaya,

Looks like it was an issue with insufficient operative memory available for Elasticsearch, solution for this:

1. Enter the Community Server container

Code: Select all

docker exec -it onlyoffice-community-server bash
2.

Code: Select all

service god stop
3.

Code: Select all

service onlyofficeIndex stop
4. Open the config /etc/elasticsearch/jvm.options and comment out the line

Code: Select all

#-XX:+HeapDumpOnOutOfMemoryError 
This parameter is responsible for spawning lots of java_pid files. These are memory dump files that are created each time elastic crashes when it is out of memory.

5. In the same config, you can also increase the amount of RAM dedicated to elastic. From our experience, the most optimal amount is 4 GB (default value is 1 GB)

Code: Select all

# Xms represents the initial size of total heap space
# Xmx represents the maximum size of total heap space

-Xms4g
-Xmx4g
6. Now you need to remove all created indexes.

Code: Select all

curl http://localhost:9200/_cat/indices
curl -X DELETE http://localhost:9200/mail_mail
curl -X DELETE http://localhost:9200/files_file

and all others...

Code: Select all

​mysql -h onlyoffice-mysql-server -u onlyoffice_user -ponlyoffice_pass -D onlyoffice 
delete from webstudio_index; 
exit; 
7.

Code: Select all

service onlyofficeIndex start
8.

Code: Select all

service elasticsearch restart
9.

Code: Select all

service god start
Wait for indexing process to complete.

jmr
Posts: 2
Joined: Thu Feb 13, 2020 7:34 am

Re: CRM contact search not working properly

Post by jmr » Thu Feb 13, 2020 8:00 am

Hello everyone,

using this post instead of opening a new one, we also have "problems" with CRM search functionality. We've installed a Community Server on Windows Server 2012. Currently, everything is working great. We've imported all our client companies and contacts to CRM module without any problem. Filters are working fine also.

But our "problem" is that when we use the global search functionality (using magnifying glass icon at the top of the page) and we search for a company by name, for instance, the result is that 'anything has been found', even when the company has been created correctly and exists in DB.

Please, can anyone tell us if we are doing something wrong? Could be anything installed wrongly? Any configuration parameter missed? Any idea?

Thanks in advance and best regards,
Juan

Carl
Posts: 267
Joined: Thu Apr 12, 2018 10:00 am

Re: CRM contact search not working properly

Post by Carl » Thu Feb 13, 2020 12:34 pm

Hello Juan,

Please specify the technical specs of the server where your Community Server is installed and also the version of Community Server.

You can try to re-index all the portal data following the guide above. The difference for Windows is that you need some kind of a poster client (Postman for example) to send curl requests to the server. Use the same commands:
curl http://localhost:9200/_cat/indices to get the list of indexes
curl -X DELETE http://localhost:9200/[item] to delete all the items from the output of the previous command.

Another difference is that you need HeidiSQL utility to connect to MySQL (username is root and password can be found in CommunityServer\WebStudio\web.connections.config).

So the order is:

1. Stop ONLYOFFICE Server in IIS.
2. Stop ONLYOFFICE Indexer service.
3. Run all curl commands.
4. Clear the webstudio_index table in the DB.
5. Restart ONLYOFFICE Indexer and Elasticsearch.
6. Start ONLYOFFICE Server in IIS.

Please note: we strongly recommend to create a backup of the server before any manipulations with it.

jmr
Posts: 2
Joined: Thu Feb 13, 2020 7:34 am

Re: CRM contact search not working properly

Post by jmr » Thu Feb 13, 2020 3:18 pm

Hi Carl,

thanks for your answer.

The Community Servir is installed on a Windows Server 2012 Essentials. The Community Server version is 'Versión 10.5.780'

We'll act as you've suggested and try your solution as soon as possible. I'll share the result.

Thank you!!

Post Reply