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}