After upgrading with the latest patch delivered on November 11, 2016 you may see the MAGE log start generating the following errors.
Replace the stored procedure in the database by following these instructions:
Using SQL Studio Management run the following Query against the Quest Migration Manager database.
1. Set to our database in the Studio.
2. Select “New Query”
3. Cut and paste the below script into the new query screen.
4. Press “Execute” button. Should see “Command Executed Successfully”
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GET_ORGANIZATION_DETAILS]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GET_ORGANIZATION_DETAILS]
GO
CREATE PROCEDURE [dbo].[GET_ORGANIZATION_DETAILS]
@ORGANIZATION_ID INT
AS
BEGIN
SET NOCOUNT ON;
SELECT ORG.ID, ADM_GRP.ID, SRV.ID, PROP.* FROM
EXCH_ORGANIZATION AS ORG
LEFT JOIN EXCH_ADMINGROUP AS ADM_GRP ON ADM_GRP.ORG_ID = ORG.ID
LEFT JOIN EXCH_SERVER AS SRV ON SRV.ID = (SELECT TOP 1 ID FROM EXCH_SERVER WHERE AG_ID = ADM_GRP.ID)
LEFT JOIN EXCH_SERVER_PROPERTY AS PROP ON PROP.EXCH_SERVER_ID = SRV.ID
WHERE ORG.ID = @ORGANIZATION_ID
FOR XML AUTO, ELEMENTS
END
GO
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center