After copying the SSAS cube and SSIS packages there is processing problem

Question

After copying the SSAS cube and SSIS packages that run its recalculation in Analysis Services Processing Tasks, something strange happens. It doesn't matter whether a new SSIS is launched or an old one, the old cube is still recalculated not new one. Double checked the SSISDB connections and SSISDB configuration and are different in the new and old SSIS package. Cubes are also processed without any problems at the SSMS level. The cube IDs have also been changed so that the new SSIS package uses the connection to newSSASCubeID. Yet it somehow triggers oldSSASCubeID processing. Any tips?

Answer 1

I found the place where Task keeps the ID of the old cube.

In ProcessingCommands property there is generated XMLA with old IDs:

  <Process>
    <Object>
      <DatabaseID>OldDatabaseID</DatabaseID>
      <CubeID>OldCubeID</CubeID>
      <MeasureGroupID>SomeMeasureGroupID</MeasureGroupID>
    </Object>
    <Type>ProcessClear</Type>
    <WriteBackTableCreation>UseExisting</WriteBackTableCreation>
  </Process>

I originally only replaced OldCubeID, but I should have also replaced OldDatabaseID. So this solves the problem completely.