Project and Portfolio Management Practitioners Forum
cancel

Import User report link pointing to a different URL

Highlighted
cat_gon0208
Trusted Contributor.

Import User report link pointing to a different URL

Hi All,

 

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.

 

Thanks.

 

Catherine

4 REPLIES
Utkarsh_Mishra
Acclaimed Contributor.

Re: Import User report link pointing to a different URL

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_PROPERTIES
set 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.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
cat_gon0208
Trusted Contributor.

Re: Import User report link pointing to a different URL

Hi Utkarsh,

 

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?

 

Thanks.

 

Catherine

Celil
Acclaimed Contributor.

Re: Import User report link pointing to a different URL

Hi Catherine

Please try 9.14 in your test systems. In release notes Hp says that "Clicking URL on the report shows error. Missing “/itg” part".


PS: Please keep alive our forum via KUDOS the professionals
Celil

IT Governance Professional
& PPM Solution Architect
Utkarsh_Mishra
Acclaimed Contributor.

Re: Import User report link pointing to a different URL

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_TOKENS
SET 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 rs
WHERE rt.report_type_id = rs.report_type_id
AND rs.report_submission_id = :REPORT_SUBMISSION_ID'
WHERE ENTITY_TOKEN_ID = 500
AND TOKEN = 'REPORT_URL';

 

-----------------------


select TOKEN_SQL from KNTA_ENTITY_TOKENS WHERE ENTITY_TOKEN_ID = 501 AND TOKEN = 'REPORT_LOG_URL';

 

The above SQL will give you incorrect URL, so now update it using below update statement

 

UPDATE KNTA_ENTITY_TOKENS
SET 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 rs
WHERE rt.report_type_id = rs.report_type_id
AND rs.report_submission_id = :REPORT_SUBMISSION_ID'
WHERE ENTITY_TOKEN_ID = 501
AND TOKEN = 'REPORT_LOG_URL';

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)