Process Step:: Add Rights Where Required:: Commencing At:: ${v_sysdate}
Connecting to database
SELECT 1
FROM DUAL
Test Data Source failed: ${ex}
Project ID ${v_this}
Project ID not available, cannot continue.
select 2 sortby, to_char(const_string) retval from odf_ca_fon_code_constants where code = 'XOGUSERID'
Unable to connect to CA PPM database and retrieve Code Constants: ${v_exception}
Unable to retrieve all Code Constants. Please check XOGUSERID exists.
${v_sqlresults.rows[0].retval}
XOG User: ${XOG_USER}
Session ID: ${xogSessionId}
Username: ${v_secId.getUserName()}
Password: ${v_secId.getPWD()}
User Status: ${v_secId.getUserStatus()}
Is User Logged In: ${v_secId.isUserLoggedIn()}
Unable to retrieve a Session ID: ${v_exception}
Using XOG URL: ${v_clarityURL}
select distinct code as projcode, name as projname, user_name, email_address, first_name, last_name
from
(
select ii.code, ii.name, csu.user_name, csu.email_address, csu.first_name, csu.last_name
from inv_investments ii inner join cmn_sec_users csu on ii.manager_id = csu.id
where ii.id = ${v_this}
union all
select ii.code, ii.name, csu.user_name, csu.email_address, csu.first_name, csu.last_name
from inv_investments ii inner join odf_ca_project ocp on ii.id = ocp.id
inner join srm_resources em on ocp.fon_engagement_mgr = em.id
inner join cmn_sec_users csu on em.user_id = csu.id
where ii.id = ${v_this}
union all
select ii.code, ii.name, csu.user_name, csu.email_address, csu.first_name, csu.last_name
from inv_investments ii inner join odf_ca_project ocp on ii.id = ocp.id
inner join srm_resources pfm on ocp.fon_portfolio_mgr = pfm.id
inner join cmn_sec_users csu on pfm.user_id = csu.id
where ii.id = ${v_this})
DB ERROR: Unable to query DB to retrieve project stakeholders - ${v_sql_err}
All stakeholder fields are empty - no records returned
Retrieved Project ID ${v_projCode}, Name ${v_projName} with stakeholder ${v_stk}.
${v_stk}
${xogSessionId}
XOG return message: ${xogReturn}
Xog Write: ${xogRecordString}
${v_instRights}
${xogSessionId}
XOG return message: ${xogReturn}