Thread Details
  • State Suggested Answer
  • +1 person also asked this people also asked this
  • Replies 17 replies
  • Answers 2 answers
  • Subscribers 354 subscribers
  • Views 3991 views
  • Users 0 members are here
Forum Actions
Related

Error during upgrade 11.0.3 to 12

Jeroen Somhorst

Hi,

I'm currently in the process of upgrading my local development instance of a customer from 11.0.3 Enterprise to 12.0.0. The problem currenty is that it fails after the healtcheck (or during, the logs arent really clear) with the following SQL error: 

Mon, 02 May 2022 12:32:13 +0000 [Upgrader] - ERROR: Exception: An exception occurred while executing 'SELECT outbound_email.id, outbound_email.eapm_id, outbound_email.name, outbound_email.type, outbound_email.user_id, outbound_email
.email_address_id, outbound_email.authorized_account, outbound_email.mail_authtype, outbound_email.reply_to_name, outbound_email.reply_to_email_address_id, outbound_email.mail_sendtype, outbound_email.mail_smtptype, outbound_email.m
ail_smtpserver, outbound_email.mail_smtpport, outbound_email.mail_smtpuser, outbound_email.mail_smtppass, outbound_email.mail_smtpauth_req, outbound_email.mail_smtpssl, outbound_email.deleted, outbound_email.team_id, outbound_email.
team_set_id, outbound_email.acl_team_set_id, teams_tn.name tn_name, teams_tn.name_2 tn_name_2 FROM outbound_email LEFT JOIN teams teams_tn ON (outbound_email.team_id = teams_tn.id) AND (teams_tn.deleted = ?) WHERE (outbound_email.id
 = ?) AND (outbound_email.deleted = ?) LIMIT 1' with params [0, "d717dbfa-e3dc-11eb-b061-0242ac170007", 0]:

I just checked the database prior upgrading to 12.0 and indeed this table does not have a acl_team_set_id column. When I truncate that specific table and start the upgrade all seems to work as expected. But whenever I import the data again and do a QRR the application is broken with the same error. 

Did someone see this behaviour in the past? 

Parents
  • 0

    The column acl_team_set_id does exist in Sugar 11.0.x

    Sugar 11.0.3

    desc outbound_email;
+---------------------------+--------------+------+-----+---------+-------+
| Field                     | Type         | Null | Key | Default | Extra |
+---------------------------+--------------+------+-----+---------+-------+
| id                        | char(36)     | NO   | PRI | NULL    |       |
| eapm_id                   | char(36)     | YES  |     | NULL    |       |
| name                      | varchar(255) | YES  |     | NULL    |       |
| type                      | varchar(15)  | YES  | MUL | user    |       |
| user_id                   | char(36)     | NO   |     | NULL    |       |
| email_address_id          | char(36)     | YES  |     | NULL    |       |
| authorized_account        | varchar(255) | YES  |     | NULL    |       |
| mail_authtype             | varchar(10)  | YES  |     | NULL    |       |
| reply_to_name             | varchar(255) | YES  |     | NULL    |       |
| reply_to_email_address_id | char(36)     | YES  |     | NULL    |       |
| mail_sendtype             | varchar(8)   | YES  |     | SMTP    |       |
| mail_smtptype             | varchar(20)  | YES  |     | other   |       |
| mail_smtpserver           | varchar(100) | YES  |     | NULL    |       |
| mail_smtpport             | int(5)       | YES  |     | 465     |       |
| mail_smtpuser             | varchar(100) | YES  |     | NULL    |       |
| mail_smtppass             | varchar(255) | YES  |     | NULL    |       |
| mail_smtpauth_req         | tinyint(1)   | YES  |     | 0       |       |
| mail_smtpssl              | int(1)       | YES  |     | 1       |       |
| deleted                   | tinyint(1)   | YES  |     | 0       |       |
| team_id                   | char(36)     | YES  |     | NULL    |       |
| team_set_id               | char(36)     | YES  | MUL | NULL    |       |
| acl_team_set_id           | char(36)     | YES  | MUL | NULL    |       |
+---------------------------+--------------+------+-----+---------+-------+

    Sugar 12.0.0

    mysql> desc outbound_email;
+---------------------------+--------------+------+-----+---------+-------+
| Field                     | Type         | Null | Key | Default | Extra |
+---------------------------+--------------+------+-----+---------+-------+
| id                        | char(36)     | NO   | PRI | NULL    |       |
| eapm_id                   | char(36)     | YES  |     | NULL    |       |
| name                      | varchar(255) | YES  |     | NULL    |       |
| type                      | varchar(15)  | YES  | MUL | user    |       |
| user_id                   | char(36)     | NO   |     | NULL    |       |
| email_address_id          | char(36)     | YES  |     | NULL    |       |
| authorized_account        | varchar(255) | YES  |     | NULL    |       |
| mail_authtype             | varchar(10)  | YES  |     | NULL    |       |
| reply_to_name             | varchar(255) | YES  |     | NULL    |       |
| reply_to_email_address_id | char(36)     | YES  |     | NULL    |       |
| mail_sendtype             | varchar(8)   | YES  |     | SMTP    |       |
| mail_smtptype             | varchar(20)  | YES  |     | other   |       |
| mail_smtpserver           | varchar(100) | YES  |     | NULL    |       |
| mail_smtpport             | int(5)       | YES  |     | 465     |       |
| mail_smtpuser             | varchar(100) | YES  |     | NULL    |       |
| mail_smtppass             | varchar(255) | YES  |     | NULL    |       |
| mail_smtpauth_req         | tinyint(1)   | YES  |     | 0       |       |
| mail_smtpssl              | int(1)       | YES  |     | 1       |       |
| preferred_sending_account | tinyint(1)   | YES  |     | 0       |       |
| deleted                   | tinyint(1)   | YES  |     | 0       |       |
| team_id                   | char(36)     | YES  |     | NULL    |       |
| team_set_id               | char(36)     | YES  | MUL | NULL    |       |
| acl_team_set_id           | char(36)     | YES  | MUL | NULL    |       |
+---------------------------+--------------+------+-----+---------+-------+

    If you look in the sugarcrm.log is there more information about the error?

  • 0 in reply to Jeff Bickart

    Interesting, my outbound_email table is also missing the acl_team_set_id

    Though I'm on 11.0.2 Professional not Ent.

  • 0 in reply to Francesca Shiekh

    Yesterday we upgraded a copy of PROD instance of a customer from PRO 10.0.2 to ENT 12.0.0.

    The steps were:

    • PRO 10.0.2 -> PRO 10.0.6
    • PRO 10.0.6 -> PRO 11.0.3
    • PRO 11.0.3 -> ENT 11.0.3
    • ENT 11.0.3 -> ENT 12.0.0

    All steps ran successfully without any big deal, no db issue or red flag or anything else. That customer have some custom js controllers, custom modules, dependencies and some other customizations.

    André Lopes
    Lampada Global
    Skype: andre.lampada
  • 0 in reply to André Lopes

    Good morning ,
    Based on your experience, would you recommend doing the conversion and upgrade in one big downtime or convert and then upgrade in a subsequent phase?

  • 0 in reply to Francesca Shiekh

    Hi . Believe me, all 4 upgrades finished below 2 hours, including committing each milestone into GIT and backupping every database (390 MB).

    André Lopes
    Lampada Global
    Skype: andre.lampada
  • 0 in reply to André Lopes

    Thank you.

    Our DB is 580GB so it may take a little longer... ;)

Reply Children
No Data