AQM 9.0.1 error

[eeelizondo]

Hi experts,

After I upgrade AQM to version 9.0.1  SR4 i get the following error during the post install:

The following database error ocurred:

Schema program failed: The index 'Ccr_evaStateFK_personFK_evaluatorFK_localStartime_Covering_Index' is dependent on column 'icmCallId'

I have windows 2008 standard

SQL 2008 standard

CUCM 8.6.2a

UCCX 9.0

Anyone knows what can be happening?

Thanks in advance!!

[Aaron Harrison]

Hi

I've seen issues similar (but not quite the same) as this one - what version are you upgrading from?

Aaron

[eeelizondo]

From version 8.5 SR2 to 9.0.1 SR4, i didnt find the answer yet...

[Mathew Varghese]

Hello,

Did you find a fix for the issue,we are facing this issue ditto !!!

Upgrade from AQM 8.5 SR2 to 9.0.1 SR4

CCX : 9.x

CM : 9.1

Appreciate any help

Mathew

[rossporubski]

Did you contact Calabrio?

[robloeber]

Anyone find a fix yet?  I ran into this last week during our upgrade.

[Mathew Varghese]

Hello Rob,

This issue normally occurs when there is an agent or team that has been changed and the database did not recognize the change. 

I would suggest you to raise a case with PDI Calibrio support and get the database fixed.

Mathew

[Michael Gross]

Here is what Calabrio sent me and fixed this issue for me. 

Here is the initial query to run on your SQMDB database once you run into that error message: 

IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Ccr]') AND name = N'Ccr_evalStateFK_personFK_evaluatorFK_localStartTime_Covering_Index') 
DROP INDEX [Ccr_evalStateFK_personFK_evaluatorFK_localStartTime_Covering_Index] ON [dbo].[Ccr] WITH ( ONLINE = OFF )

At that point you may see this error (I did):
Agent_personFK_deactivated_id_activated' already exists on table 'Agent'

If you do, run this query:
IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[Agent]') AND name = N'Agent_personFK_deactivated_id_activated') 
DROP INDEX [Agent_personFK_deactivated_id_activated] ON [dbo].[Agent] WITH ( ONLINE = OFF )

At that point, you should be able to complete Post Install.

Apparently this is a knows bug/issue that doesn't seem to be published anywhere.