Answers.Body: <p>You will need to upgrade civicrm extended report to 5.13 prior to CiviCRM 5.47.2</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-03-22T03:23:41.207Z
Answers.Text: That might be enough in some situations but I think it's not fully resolved. Intermediate steps before 5.47 that need the managed entity to be there think it's not there because 5.13 only checks for the extension not the component, so in the intermediate step the extensions and managed entities thinks civigrant isn't installed. See lab ticket.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-03-22T08:01:08.947Z
Answers.Text: a) You would have to have to do that manually as that release is not offered in the extensions before 5.47 and b) you would have to know about it!  A pity that 5.47 was released with a known problem so hope that people see this first
Answers.UserDisplayName: Andy Clark
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-03-21T22:56:38.280Z
Answers.LastActivityDate: 2022-03-21T22:56:38.280Z
Answers.UserDisplayName: Pradeep Nayak
Answers.Body: <p>This is not fully resolved still: <a href="https://lab.civicrm.org/dev/core/-/issues/3101" rel="nofollow noreferrer">https://lab.civicrm.org/dev/core/-/issues/3101</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-03-21T22:40:43.220Z
Answers.Text: Thanks, glad I reversed back into 5.46.3!
Answers.UserDisplayName: Andy Clark
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-03-21T21:54:41.017Z
Answers.LastActivityDate: 2022-03-21T21:54:41.017Z
Answers.UserDisplayName: Demerit
Body: <p>In attempting to upgrade several 5.45.3 system to 5.47.2 I ran into this problem with 3 of them - &quot;[info] $CRM_Queue_Page_AJAX_runNext_error = Exception: &quot;API error: DB Error: constraint violation on ReportTemplate.create&quot; This happened when the upgrade had almost completed, but left the database still thinking it was at 5.45.3.  This looks like a problem with the 'Extended Reports' extension - should this be reported as a bug against the extension? The upgrade from 5.45.3 to 5.46.3 works OK, by the way, this problem occurs on the upgrade to 5.47.2. So, I updated systems to 5.46.3 and am avoiding 5.47.2! -<a href="https://i.sstatic.net/kfzmT.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/kfzmT.png" alt="enter image description here" /></a>  Trace back attached.</p>
  
Tags: <extension><upgrade>
Title: Upgrade to 5.47.2 failed on several systems - workaround?
ThreadText: # Upgrade to 5.47.2 failed on several systems - workaround?
  
  (Asked by: username_0 on 2022-03-21)
  
  In attempting to upgrade several 5.45.3 system to 5.47.2 I ran into this problem with 3 of them - "[info] $CRM\_Queue\_Page\_AJAX\_runNext\_error = Exception: "API error: DB Error: constraint violation on ReportTemplate.create" This happened when the upgrade had almost completed, but left the database still thinking it was at 5.45.3. This looks like a problem with the 'Extended Reports' extension - should this be reported as a bug against the extension? The upgrade from 5.45.3 to 5.46.3 works OK, by the way, this problem occurs on the upgrade to 5.47.2. So, I updated systems to 5.46.3 and am avoiding 5.47.2! -[![enter image description here](https://i.sstatic.net/kfzmT.png)](https://i.sstatic.net/kfzmT.png) Trace back attached.
  
  **Tags:** extension, upgrade
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2022-03-21. Score: 1
  
  You will need to upgrade civicrm extended report to 5.13 prior to CiviCRM 5.47.2
  
  > **Comments:**
  > **username_2**: That might be enough in some situations but I think it's not fully resolved. Intermediate steps before 5.47 that need the managed entity to be there think it's not there because 5.13 only checks for the extension not the component, so in the intermediate step the extensions and managed entities thinks civigrant isn't installed. See lab ticket.  
  > **username_0**: a) You would have to have to do that manually as that release is not offered in the extensions before 5.47 and b) you would have to know about it!  A pity that 5.47 was released with a known problem so hope that people see this first  
  
  ---
  
  ### Answer by username_2 on 2022-03-21. Score: 1
  
  This is not fully resolved still: <https://lab.civicrm.org/dev/core/-/issues/3101>
  
  > **Comments:**
  > **username_0**: Thanks, glad I reversed back into 5.46.3!  
  
  ---
  
  