Error upgrade Commserv

  • 10 July 2023
  • 3 replies

Badge +1

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 10 July 2023, 22:27

View original

3 replies

Userlevel 6
Badge +15

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?  

Badge +1

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.

Userlevel 6
Badge +15

@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.