cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Walkthrough Wednesdays
660
Views
10
Helpful
7
Replies
eeelizondo
Beginner

AQM 9.0.1 error

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!!

7 REPLIES 7

Hi

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

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!

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

Mathew Varghese
Beginner

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

Did you contact Calabrio?

robloeber
Beginner

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

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

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.

Content for Community-Ad

Spotlight Awards 2021