05-31-2013 11:48 AM - edited 03-14-2019 11:49 AM
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!!
06-04-2013 02:01 AM
Hi
I've seen issues similar (but not quite the same) as this one - what version are you upgrading from?
Aaron
06-08-2013 07:35 PM
From version 8.5 SR2 to 9.0.1 SR4, i didnt find the answer yet...
07-30-2013 02:35 AM
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
04-22-2014 07:14 AM
Did you contact Calabrio?
04-21-2014 01:19 PM
Anyone find a fix yet? I ran into this last week during our upgrade.
04-21-2014 10:43 PM
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
04-24-2014 05:15 AM
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.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: