We have recently upgraded from 7.5 to 9.12, we also have changed server during our upgrade.
We have a scheduled Import User report which is sending out email.
The Report link and report log link in the email is broken.
Prior to the upgrade it is pointing to server_name/itg/.... now the itg is missing, it is now pointing to new_server_name/....
Will appreciate any input that you can give.
We also faced simliar issue, and it got resolved by below SQL
First take the backup
-- should check that only 1 row is updated
update KNTA_APP_SERVER_PROPERTIESset VALUE = <PPM_URL>/itg'where KEY = 'BASE_URL'and SERVER_NAME in ('__CLUSTER_DEFAULT__')
There are other alternative for this as well, you can get in touch with HP support to get the other SQLs.
Thank you for your attention.
We have been advised by the support to delete the row in
KNTA_APP_SERVER_PROPERTIES table where server_name = '__CLUSTER_DEFAULT__', we have tried but then after restarting the instance, the row is inserted again.
If we try to update the row, and restart the instance, will it revert back the changes after restart?
Do you have this kind of issue since you have this resolved?
In version 9.x SP4 also this is not resolved.
Update the Notfication TOKENS by using the below SQL.
IMP - First make the backup of below select query result.
select TOKEN_SQL from KNTA_ENTITY_TOKENS WHERE ENTITY_TOKEN_ID = 500 AND TOKEN = 'REPORT_URL';
The above SQL will give you incorrect URL, so now update it using below update statement
UPDATE KNTA_ENTITY_TOKENSSET TOKEN_SQL = 'SELECT decode (rs.status_code,''CLOSED_FAILURE'', NULL,''[AS.BASE_URL]reports/'' || rs.report_name)FROM KNTA_REPORT_types rt,KNTA_REPORT_submissions rsWHERE rt.report_type_id = rs.report_type_idAND rs.report_submission_id = :REPORT_SUBMISSION_ID'WHERE ENTITY_TOKEN_ID = 500AND TOKEN = 'REPORT_URL';
select TOKEN_SQL from KNTA_ENTITY_TOKENS WHERE ENTITY_TOKEN_ID = 501 AND TOKEN = 'REPORT_LOG_URL';
UPDATE KNTA_ENTITY_TOKENSSET TOKEN_SQL = 'SELECT ''[AS.BASE_URL]logs/reports/'' || ''rep_log_'' || to_char(rs.report_submission_id) || ''.html''FROM KNTA_REPORT_types rt,KNTA_REPORT_submissions rsWHERE rt.report_type_id = rs.report_type_idAND rs.report_submission_id = :REPORT_SUBMISSION_ID'WHERE ENTITY_TOKEN_ID = 501AND TOKEN = 'REPORT_LOG_URL';