Forums - Thread Details
  • State Not Answered
  • Replies 3 replies
  • Subscribers 319 subscribers
  • Views 792 views
  • Users 0 members are here
Forum Actions
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
Parents
  • 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

Reply
  • 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

Children
No Data