Forums - Thread Details
  • State Not Answered
  • Replies 3 replies
  • Subscribers 321 subscribers
  • Views 786 views
  • Users 0 members are here
Related

Error during upgrade to 8.0.1

Enes Saridogan

Hello everybody,

We are migrating the instance of our customer, here are the detailed informations : 

  • SugarCRM v7.9.4.0
  • Flavor Enterprise
  • Oracle 12c
  • PHP 7.1.17
  • Oracle Linux 7.5
  • ElasticSearch 6.2.4
The healthcheck from v7.9.4.0 to 8.0.1 passed only with yellow flags, but when passing the upgrade to 8.0.1 we have the following error message (complete log in attachment) : 
Tue, 27 Jul 2021 15:12:09 +0200 [Upgrader] - Starting script 4_SynchronizeActivitiesRelationshipToEmailsBeansTable
Tue, 27 Jul 2021 15:12:10 +0200 [Upgrader] - part_c has an activities link named part_c_activities_1_emails
Tue, 27 Jul 2021 15:13:32 +0200 [Upgrader] - ERROR: Exception: An exception occurred while executing 'SELECT part_c.assigned_user_id, part_c.id, part_c.name FROM part_c ...
ORA-01795: maximum number of expressions in a list is 1000
Tue, 27 Jul 2021 15:13:32 +0200 [Upgrader] - Finished script 4_SynchronizeActivitiesRelationshipToEmailsBeansTable
Tue, 27 Jul 2021 15:13:32 +0200 [Upgrader] - ERROR: Post-upgrade stage failed! Error executing post scripts
After spending more than 2 hours to debug the upgrade tool (first time we're doing this at ITS4U Slight smile) we don't find any solution to fix the problem, and our instance is in a instable and not working state.
Is there anybody that faced the same issue ?
Is there any fix you can provide us or some trick to perform the next upgrades ? 
Also, how to be sure that we won't face the same issue again in the future (to V9 and V10) ?
Many thanks in advance for your answer.
Best regards,
Enes
  • 0

    Is v8 the one with all the collation changes?
    If I remember right we had a similar issue and it had to do with not enough temp space on our MySQL Database.
    Have you checked the database end to see if you can see anything there?

    Also, the collation changes were taking forever so we did them in batches before the upgrade, so our PRD would not be down for too long a span of time since many of our web forms and services rely on Sugar being up and running.

  • 0

    I haven’t seen this error before. It looks like an Oracle specific limitation with your dataset. The query used in that upgrade script might need to be changed for it to work with your instance. I don’t have the Oracle knowledge to advise on best way to do that. 

    This particular script (./modules/Emails/upgrade/scripts/post/4_SynchronizeActivitiesRelationshipToEmailsBeansTable.php) is only used when upgrading to 8.0.x. It’s not used or run again in later Sugar versions. And it’s not in the current Sugar 11.x codebase at all. So you won’t run into problems related to this particular script in future upgrades.

    App Ecosystem @ SugarCRM

  • 0

    Hello everybody,

    FInally we pass through the problem with deleting the file for the 8.0.1 migration step, and it goes well with 8.0.8 migration.

    Thanks a lot for your answers ;-)

    Enes