Forums

Covering OroCommerce, OroCRM, OroPlatform topics, including community updates and company announcements.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

Forum Replies Created

Viewing 15 replies - 1 through 15 (of 21 total)
  • Author
    Replies
  • in reply to: New installation / Email sync issues #27737

    ianfp
    Participant

    I’m having a similar problem when running ’email-body-sync’ on OroCRM v2.4.2:

    in reply to: Emails not syncing #27837

    ianfp
    Participant

    Upgrading to 2.4.2 does not appear to have solved the problem.

    in reply to: Process doesn't work after upgrade from 1.10 to 2.2 #27709

    ianfp
    Participant

    We found the answer here:

    https://oroinc.com/orocrm/forums/topic/send-email-to-case-assignee-when-assignee-is-changed#post-29887

    (We moved the process definition from config/process.yml to config/oro/processes.yml and put the contents under a top-level “processes:” key.)

    Now the process works and the email is sent when a case is reassigned, but I got this error:

    in reply to: Send email to Case assignee when assignee is changed #29993

    ianfp
    Participant

    Mike,

    That seems like a great solution. Thanks for your help. I’ll post back once I have a chance to try it out.

    in reply to: Email sync problems #28790

    ianfp
    Participant

    Mike,

    I’ve had no problems since switching to utf8mb4. Thanks for following up!

    in reply to: Email sync problems #28788

    ianfp
    Participant

    I’m running on Amazon RDS, MySQL Server version: 5.6.23-log MySQL Community Server (GPL).

    I’ve since switched that server to utf8mb4, but the original settings were:

    in reply to: Email sync problems #28783

    ianfp
    Participant

    Mike,

    Thanks for the suggestion — I’ll try it out.

    But I’d argue that this is still buggy behaviour on OroCRM’s part. As it stands, if one email contains a 4-byte character, then the *entire* IMAP sync process fails and I don’t get any of the subsequent emails! Shouldn’t each email insertion perhaps be its own database transaction so that one problematic email doesn’t halt the whole system?

    in reply to: Email sync problems #28781

    ianfp
    Participant

    Our email has been syncing very poorly lately — many emails appear in the inbox but are never imported into Oro. When I looked at System -> Job Queue and filtered by failed jobs, I saw why. Here’s a job result that appears to have two different errors:


    ianfp
    Participant

    Here’s an update: the following error occurs every time I try to log in. I wonder if the database exception is being caught and interpreted (incorrectly?) as an authentication exception:

    [2016-06-10 11:11:27] security.DEBUG: Check an access using “oro_email_email_view” ACL annotation. [] []
    [2016-06-10 11:11:27] security.DEBUG: ACL found, permission granted. Voting to grant access. [] []
    [2016-06-10 11:11:27] security.DEBUG: Check an access using “oro_calendar_view” ACL annotation. [] []
    [2016-06-10 11:11:27] security.DEBUG: ACL found, permission granted. Voting to grant access. [] []
    [2016-06-10 11:11:27] security.DEBUG: Check an access using “orocrm_task_view” ACL annotation. [] []
    [2016-06-10 11:11:27] security.DEBUG: ACL found, permission granted. Voting to grant access. [] []
    [2016-06-10 11:11:27] security.DEBUG: Invoked controller “Oro\Bundle\EmailBundle\Controller\EmailController::placeholderLastAction”. (SUB_REQUEST) [] []
    [2016-06-10 11:11:29] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘INSERT INTO oro_email_body (created, body, body_is_text, has_attachments, persistent) VALUES (?, ?, ?, ?, ?)’ with params [“2016-06-10 18:11:28”, “\x3c\x68\x74\x6d\x6c\x20\

    [very long hex email body]

    SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xF3nico …’ for column ‘body’ at row 1” at /home/ubuntu/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:”[object] (Doctrine\\DBAL\\Exception\\DriverException: An exception occurred while executing ‘INSERT INTO oro_email_body (created, body, body_is_text, has_attachments, persistent) VALUES (?, ?, ?, ?, ?)’ with params [\”2016-06-10 18:11:28\”, \”\\x3c\\x68\\x74\\x6d\\x6c\\x20\\

    [very long hex email body]

    SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\\xF3nico …’ for column ‘body’ at row 1 at /home/ubuntu/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\\DBAL\\Driver\\PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\\xF3nico …’ for column ‘body’ at row 1 at /home/ubuntu/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\\xF3nico …’ for column ‘body’ at row 1 at /home/ubuntu/orocrm/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)”} []
    [2016-06-10 11:11:31] security.DEBUG: Calling Authentication entry point. [] []

    It appears to be failing to insert an oro_email_body record into the database. I have a guess as to which email message is causing the problem. Can I send you the original email via a non-public channel?

    UPDATE:
    I archived the Gmail message that I suspected was causing the problem. This solved the problem and allowed me to log in. This seems like a bug in how that database error was handled, no?


    ianfp
    Participant

    Alex,

    Thanks for getting back to me so quickly. The prod.log file is fairly large (3.2M). Is there a secure way for me to send it to you?

    In the meantime, here’s a snippet:

    [2016-06-08 13:49:20] security.DEBUG: Check class based an access using “orocrm_magento_order_view” ACL annotation. [] []
    [2016-06-08 13:49:20] security.DEBUG: ACL found, permission granted. Voting to grant access. [] []
    [2016-06-08 13:49:23] security.DEBUG: Check an access using “oro_email_email_view” ACL annotation. [] []
    [2016-06-08 13:49:23] security.DEBUG: ACL found, permission granted. Voting to grant access. [] []
    [2016-06-08 13:49:23] security.DEBUG: Check an access using “oro_calendar_view” ACL annotation. [] []
    [2016-06-08 13:49:23] security.DEBUG: ACL found, permission granted. Voting to grant access. [] []
    [2016-06-08 13:49:23] security.DEBUG: Check an access using “orocrm_task_view” ACL annotation. [] []
    [2016-06-08 13:49:23] security.DEBUG: ACL found, permission granted. Voting to grant access. [] []
    [2016-06-08 13:49:23] security.DEBUG: Invoked controller “Oro\Bundle\EmailBundle\Controller\EmailController::placeholderLastAction”. (SUB_REQUEST) [] []
    [2016-06-08 13:49:25] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: “An exception occurred while executing ‘INSERT INTO oro_email_body (created, body, body_is_text, has_attachments, persistent) VALUES (?, ?, ?, ?, ?)’ with params [“2016-06-08 20:49:25”, “\x3c\x68\x74\x6d\x6c\x20\x78\x6d\x6c\x6e\x73\x3a\x76\x3d\x22\x75

    The hex body that you see there is clipped — the actual body is huge and comprises most of the log file.

    in reply to: Find all Emails associated with a Case #25174

    ianfp
    Participant

    Worked perfectly! Thank you!

    in reply to: reopen case when a new email arrives #28831

    ianfp
    Participant

    This approach seems to have worked perfectly — thank you!

    in reply to: Email sync problems #28766

    ianfp
    Participant

    Artem,

    Thanks very much for your ongoing support — I’m very grateful.

    I realized yesterday your point about updating both “synchronized” columns — thanks for confirming.

    I’ll mark this thread as resolved once 1.9.1 is released and I’ve confirmed the fix.

    in reply to: Email sync problems #28764

    ianfp
    Participant

    Here’s some more information about #2. In the afternoon, imap-sync stops working entirely. Here’s what happens:

    – The Job Queue will show, say, 11 emails.
    – I’ll send an email to the mailbox.
    – One minute later, the next run of imap-sync shows 12 emails, and says the new email was skipped because it was sent earlier than the last run.

    Things work in the morning, but in the afternoon I feel like emails are “falling through the cracks”, if you know what I mean. Could this be a timezone or clock synchronization issue? My server is running ntpd and the time is correct.

    in reply to: Email sync problems #28763

    ianfp
    Participant

    Artem, I have more information about #2. If I edit a system mailbox, it updates the last sync time (the oro_email_origin.synchronized column). I have a few emails that didn’t get imported; they were sent at about the time I was tweaking the mailbox configuration. I can see in the Job Queue that they were skipped because they were “sent earlier than the last synchronization was done”.

    Is that a possibility? If so, it would be bad to miss customer emails just because I was changing the mailbox configuration.

Viewing 15 replies - 1 through 15 (of 21 total)
Back to top

You will be redirected to [title]. Would you like to continue?

Yes No

You will be redirected to [title]. Would you like to continue?

Yes No