The error in Solution Output is

 *** ERROR ***                           CP =      12.386   TIME= 17:43
 No modes are available for the harmonic frequency evaluation.           

The corrective action is to link the Solution of the Modal Analysis to the Setup of the Harmonic Response, and delete the Fixed Support from the Harmonic Response.

However, the Frequency Response is all zero, but that is because the same faces that are the fixed support were selected.
Selecting the faces at the other end would be an improvement.