SYMPTOM:
“Strategy Error Instance” error occurs when executing an incremental refresh cube subscription in Strategy 2020 Update 4. Below error is observed on both Intelligence Server nodes (Asymmetric cluster) in Linux.
[SERVER:CastorServer][PID:103401][THR:140293531031296][Query Engine][Error][0x8004FFFA][UID:F455D35B430AE0EB227AF59076E37E88][SID:FD16EE673DFD2B4509FCED1C56818A04][OID:797E44E311E982B41FB80080EFB5C02F] Strategy Error Instance:[30C8EFC440D7F2D7364FB79A1EFD60E6]
[SERVER:CastorServer][PID:103401][THR:140297515288320][Distribution Service][Error][UID:F455D35B430AE0EB227AF59076E37E88][SID:FD16EE673DFD2B4509FCED1C56818A04][OID:797E44E311E982B41FB80080EFB5C02F] FAILED SUBSCRIPTION. Subscription ‘XXXXXXXXX' (ID = 8A1B0E1B11EC1575F4BD0080EF050C23), Contact ‘XXX’ (ID = F455D35B430AE0EB227AF59076E37E88) User (XXXX, F455D35B430AE0EB227AF59076E37E88) Error Message: MSIJob Execution Error: Job ID = 6721, Comp Error code = -2147155974; Error Code 0x800437FD: (Strategy Error Instance:[30C8EFC440D7F2D7364FB79A1EFD60E6]Error in Process method of Component: QueryEngineServer, Project Top Seller, Job 6721, Error Code= -2147155974.) Stop in 'hPreTransmissionNotificationWithErrorCode, Delivery Component of Distribution Service'
Refer to Product Manual on Defining an incremental refresh report
CAUSE:
This is a known issue with Strategy 2020 related to cube incremental refresh and may impact both MTDI cube and partitioned OLAP cube.
ACTION:
Currently this issue is being reviewed by Strategy for a potential code fix on an upcoming Strategy release.
WORKAROUND:
Disable the Cube Health Check Feature on the effected environment by adding the following key:
[HKEY_LOCAL_MACHINE\SOFTWARE\MicroStrategy\DSS Server\Castor]
"CubeHealthCheckAfterPublish"=dword:00000000
