Orchestrator 5.10. update 4 to update 5 failed

[Lokaalbeheer]

Hi All,

ePOupdater.log shows:

2019-11-25T13:06:35.975Z - info: Copying file from C:\Admin\Software\ePO_5.10.0_Update_5\resources\app\release\webapps\EPOCore\sql\down\5.10.0cu-5.10.0\CU-5\7_ePO_Indexes.sql to C:/PROGRA~2/McAfee/EPOLIC~1/updates/CU-5/down/CU-5/EPOCore/7_ePO_Indexes.sql

2019-11-25T13:06:36.015Z - info: Successfully got connection

2019-11-25T13:06:36.044Z - info: Sucessfully executed SQL -- Copyright (C) McAfee, LLC. All Rights Reserved.

PRINT '<<< EXECUTING 5.10.0-5.10.0.CU CU-5/7_ePO_Indexes.sql : ' + CONVERT(VARCHAR(100), GETDATE()) + ' >>>'

2019-11-25T13:06:36.105Z - error: Failed to execute SQL DECLARE @Query        NVARCHAR(MAX);

SET        @Query        = N'

USE [' + DB_NAME() + '_Events]

IF NOT EXISTS(SELECT * from sys.indexes where name = 'IX_EPOEvents_AutoID' and object_id = OBJECT_ID(''EPOEvents''))

CREATE INDEX IX_EPOEvents_AutoID on dbo.EPOEvents

(

AutoID,

ReceivedUTC

) INCLUDE (AutoGUID) ';

IF dbo.EPOUtil_IsPartitionSupported() = 1

SET        @Query += 'ON EventsMonthRangePScheme(ReceivedUTC);';

ELSE

SET        @Query += 'ON Events_CatchAll;';

PRINT @Query;

EXEC (@Query);

 execution failed with error : RequestError: Incorrect syntax near 'IX_EPOEvents_AutoID'.

2019-11-25T13:06:36.105Z - error: Error executing script file 7_ePO_Indexes.sql

2019-11-25T13:06:36.106Z - info: SQL script execution failed

2019-11-25T13:06:36.106Z - info: Add update with id CU-5 to failed update list

2019-11-25T13:06:36.107Z - info: Total files processed : 212 success : 26 failure : 1

Any idea?

Regards

Richard

[cdinet · Accepted solution]

Please open a ticket on that - there is a defect open for that error that they have a fix for, but you need an SR at the moment.

[Lokaalbeheer]

Cheers cdinet!! .. SR created

[cdinet]

Thanks!  It should be a pretty quick process to get you the fix for that.