When running the MessageStatsMigration.sql Script, or durig MessageStats installation the following errors are displayed:
MessageStats Installation:
Database Creation Successful - Database Migration Failed (See below)
Details:
Attempting to load SQL Script file - C:\Program Files\Quest Software\MessageStats\SQL\MessageStatsMigration.sql
SQL Script File Successfully LoadedAttempting to Migrate Application Specific Database Objects
ERROR OCCURRED DURING DATABASE OBJECT MIGRATION WHILE EXECUTING THE FOLLOWING:IF (SELECT CAST(LEFT(CAST(SERVERPROPERTY('ProductVersion') AS NVARCHAR(10)),
CHARINDEX('.',CAST(SERVERPROPERTY('ProductVersion') AS NVARCHAR(10)))-1) AS INT)) > 8
BEGIN
EXEC ('sp_configure ''show advanced options'', 1');
EXEC ('RECONFIGURE');
EXEC ('sp_configure ''Ole Automation Procedures'', 1');
EXEC ('RECONFIGURE');
END
THE ERROR DESCRIPTION IS:
Ad hoc update to system catalogs is not supported
When Running MessageStatsMigration.sql
Killing database connections
DROP INDEX dbo.T_CustomRecipients.IX_T_CustomRecipientsDeletedObjectDate;DROP INDEX dbo.T_CustomRecipients.IX_T_CustomRecipientsOrgGUIDLastGatheringDate;DROP INDEX dbo.T_CustomRecipients.IX_T_CustomRecipientsDN;DROP INDEX dbo.T_CustomRecipients.IX_T_CustomRecipientsX500DN;DROP INDEX dbo.T_CustomRecipients.IX_T_CustomRecipientsOrgDNEmail;
Warning! The maximum key length is 900 bytes. The index 'IX_T_MailboxesMbxX500DN' has maximum length of 1024 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'IX_T_ExchMailEnabledObjectsOrgX500DN_2' has maximum length of 1040 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'IX_T_ExchMailEnabledObjectsOrgDNEmail_2' has maximum length of 1408 bytes. For some combination of large values, the insert/update operation will fail.
Changed language setting to us_english.
Changed language setting to us_english.
Changed language setting to us_english.
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
Msg 5808, Level 16, State 1, Line 1
Ad hoc update to system catalogs is not supported.
Changed language setting to us_english.
Changed language setting to us_english.
Changed language setting to us_english.
Changed language setting to us_english.
Changed language setting to us_english.
Changed language setting to us_english.
Changed language setting to us_english.
Warning! The maximum key length is 900 bytes. The index 'IX_T_LN_UsersMailConfiguration_MailFile' has maximum length of 1024 bytes. For some combination of large values, the insert/update operation will fail.
Changed language setting to us_english.
Changed language setting to us_english.
Caution: Changing any part of an object name could break scripts and stored procedures.
Changed language setting to us_english.
Changed language setting to us_english.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center