Skip to main content
Solved

Error upgrade Commserv

  • July 10, 2023
  • 3 replies
  • 367 views

Forum|alt.badge.img

Hello there,

We’ve tried to upgrade our commserv from 11.24 to 11.28, but it failed ob the database upgrade

with this error :

Cannot create more than one clustered index on table 'JMJobOptions'. Drop the existing clustered index 'JMJobOptions_jobId_commCellId_attributeId_idx' before creating another

our commserv is a Microsoft Server 2022, SQL version 2019.

Does anybody has already met with a similar issue?

Best answer by Orazan

@fco I would recommend opening a case with our Server team to have one of our engineers review.  This could be caused by several things, all which are hard to troubleshoot via the forums.

3 replies

Forum|alt.badge.img+15
  • Vaulter
  • July 10, 2023

Good afternoon.  Can you please tell me which Maintenance Release the 11.28 that you are trying to upgrade to is?  Are you able to update to 11.30?  


Forum|alt.badge.img
  • Author
  • Novice
  • July 10, 2023

we didn’t arrive until the maintenance release, juste upgraded it from 11.24 xto the 11.28 using the entreprise kit, we were planning to install after the lastest maintenance release, but it failed long before at the upgrade of the database.

we had to rollback.


Forum|alt.badge.img+15
  • Vaulter
  • Answer
  • July 10, 2023

@fco I would recommend opening a case with our Server team to have one of our engineers review.  This could be caused by several things, all which are hard to troubleshoot via the forums.