When upgrading from 6.X to 7.X or 7.0.X to 7.1.X the...

Expand / Collapse
 

When upgrading from 6.X to 7.X or 7.0.X to 7.1.X the Configuration Wizard fails on SQL Change Scripts


Article ID: 52358 - Last Review: October 26, 2015

PROBLEM

When upgrading a database from 6.X to a 7.X or from 7.0.X to a 7.1.X deployment, the configuration wizard stops on SQL Change Scripts with an error. 



SYMPTOMS

In the Configuration Wizard logfile found in [InstallDir]\Logs\ you see errors that look like the following:

Error 2015-Jul-24 12:03:22.814 Exception caught while attempting to execute task: System.Exception: Script Block Failed::
IF NOT EXISTS (SELECT name FROM sys.indexes WHERE name = 'IX_NC_FKSubscriberPKey_MidnightStartDate')
BEGIN
CREATE NONCLUSTERED INDEX [IX_NC_FKSubscriberPKey_MidnightStartDate] ON [dbo].[tblData_CA_Trace] ([FKSubscriberPKey], [MidnightStartDate], [FKDayOfWeek]) INCLUDE ([AccountCode], [ANI], [CallerID], [CallID], [CallStartTime], [DigitsDialed], [DNIS], [Duration], [Extension], [FKCallCostingType], [FKCallDirection], [FKCarrierCallRate], [FKThirdPartyType], [Location], [NumberOfCostUnits], [PegCount], [Pkey], [RoutingDigits], [SubscriberCost], [ThirdParty], [TimeToAnswer], [Trunk])
END

 



CAUSE

The default 7.0.0.0 change script attempts to create a number of indexes.  In large databases this can take a large amount of time to complete, resulting in a timeout. 



RESOLUTION

1. Download the attached ZIP file to the Enterprise Server.
2. Unzip the package into a folder.
3. Rename 7.0.0.0.noIndex.sql to 7.0.0.0.sql .
4. In [InstallDir]\Database\Change Scripts\ move the existing 7.0.0.0.sql file to another location as a backup.
5. Copy the new 7.0.0.0.sql file in your folder on the desktop to [InstallDir\Database\Change Scripts\ .
6. Run the Configuration Wizard normally.
7. When finished, double-click 7.0.0.0.postIndexCreate.sql in your unzipped folder to open the script in SQL Management Studio (Ensure you are connected to the MiCC database).
8. Click Execute and allow the indexing script to complete.

NOTE: Depending on the size of your database this can take several hours to complete.



APPLIES TO

MiCC Version 7.X 

Keywords: upgrade database large configuration wizard sql change script scripts block



Rate this Article:
     

Attachments


7.0.0.0.indexRip.zip 7.0.0.0.indexRip.zip (408.24 KB, 424 views)

Add Your Comments


Name: *
Email Address:
Web Address:
Verification Code:
*
 

Details
Last Modified:Tuesday, October 27, 2015
Last Modified By: dfountaine
Type: FIX
Article not rated yet.
Article has been viewed 7,358 times.
Options