Reports fail with "Error: Service Profile with UID '#########@#######' does not exist" when running report after copying report template from another server in a cluster

Document ID : KB000033216
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue: 

Error: Service Profile with UID '#########@#######' does not exist

Environment: 

All versions
All platforms

Cause:

Report template was copied form another server in the cluster and contained
the machine ID of the originating cluster member.

Resolution/Workaround: 

1) Update the report template to add the correct machine id

   a) Locate the report template associated with the report.

   b) The template file will have the name of the Report Template followed by .rpt,

       and be located under $NH_HOME/reports/<reportType>/<ReportTemplate>.tpt

   c) Find the line which reads:

          analysisCtrlsName <machineId>@<profileId>

      Change the machine id to reflect the machine id of the current system.

      You can get the current machines machine id from the command:

      nhListClusterMembers -host <hostname of current server>

      The MemberID is the Machine ID

   d) Delete the old job and recreate the scheduled job after the file have been updated.