imap sync not working – identifier id is missing

OS: Gentoo Linux (kernel: 4.12.5)
OroCRM: 2.3.0 (community edition)
Apache 2.4.27
MySQL 5.6.37
PHP 7.0.21

I can send e-mails but I can’t receive them in OroCRM. In the prod.log the following lines are repeating themselves over and over again:

Shell

[2017-09-12 09:59:30] app.ERROR: Consume messages command exception. "The identifier id is missing for a query of Oro\Bundle\SalesBundle\Entity\LeadEmail" {"exception":"[object] (Doctrine\\ORM\\ORMException(code: 0): The identifier id is missing for a query of Oro\\Bundle\\SalesBundle\\Entity\\LeadEmail at /var/www/localhost/htdocs/orocrm/vendor/doctrine/orm/lib/Doctrine/ORM/ORMException.php:294)"} [] [2017-09-12 09:59:30] console.ERROR: An error occurred while running command "--env=prod --no-debug 'oro:message-queue:consume'". The identifier id is missing for a query of Oro\Bundle\SalesBundle\Entity\LeadEmail {"exit_code":0,"arguments":{"command":"oro:message-queue:consume"},"options":{"env":"prod","no-debug":true}} []

1 2 3

[2017-09-12 09:59:30] app.ERROR: Consume messages command exception. "The identifier id is missing for a query of Oro\Bundle\SalesBundle\Entity\LeadEmail" {"exception":"[object] (Doctrine\\ORM\\ORMException(code: 0): The identifier id is missing for a query of Oro\\Bundle\\SalesBundle\\Entity\\LeadEmail at /var/www/localhost/htdocs/orocrm/vendor/doctrine/orm/lib/Doctrine/ORM/ORMException.php:294)"} []   [2017-09-12 09:59:30] console.ERROR: An error occurred while running command "--env=prod --no-debug 'oro:message-queue:consume'". The identifier id is missing for a query of Oro\Bundle\SalesBundle\Entity\LeadEmail {"exit_code":0,"arguments":{"command":"oro:message-queue:consume"},"options":{"env":"prod","no-debug":true}} []

I am not using GMAIL but another provider. IMAP and SMTP is configured correctly, and IMAP folders are selected.

Please advise!
Christian

Topic

[msulimaModerator]

Hi, Christian.

Not enough information to reproduce your problem. What provider do you use? Some examples of configuration of application can help. Please, give as many information as you can.

Previously, I had testing session with Gmail IMAP and have no problem (as you told), but no idea in what place that error can happen in your case.

---

Check our free technical guide ”How to Build a Reliable and Secure Infrastructure for OroCommerce”.

[ChristianParticipant]

Here is my imap configurtion:

IMAP:
host: imap.issp.at
port: 993
encryption: ssl

SMTP:
host: smtp.issp.at
port: 465
encryption: ssl

I also provided username and password for login into those hosts.

I clicked on the “Check connection/retrieve folders” button and that worked just fine.
I have a list of all imap folders and I seleced a few of them.

What does the error message in the log file mean?

[msulimaModerator]

> What does the error message in the log file mean?

Some query for entity ‘Oro\Bundle\SalesBundle\Entity\LeadEmail’ with ‘id’ equals to NULL.

But I don’t want why it happen. Need to investigate IMAP provider that you use. Without that I can’t say more.

---

Check our free technical guide ”How to Build a Reliable and Secure Infrastructure for OroCommerce”.

[ChristianParticipant]

Well… there is nothing wrong with my IMAP provider. I use it with Thunderbird every day. And since the check you have incorporated into your config page says that everything is ok, I assume, the issue is somewhere on my machine, either with my setup or with the orocrm config.

Well, I dont’ have the expertise to investigate the matter any further. Maybe some day in the future it will work. Until then I will use my trusted Thunderbird.

Thanks for your time.

[msulimaModerator]

Just, maybe, OroCRM does not support IMAP of your provider.

---

Check our free technical guide ”How to Build a Reliable and Secure Infrastructure for OroCommerce”.

[jnetoParticipant]

try this

php app/console oro:cron:imap-sync

and after
php app/console oro:cron:email-body-sync

to import the mail manualy and then check the logs.

I don’t think your error in the log is related with the problem.

It seems that the oro:message-queue:consume is trying to to something to a record already deleted, so the id is NULL. I don’t know if this error stop the cron to run other tasks.

[Author]

Replies