Error reading from database
Debug info: ORA-00972: identifier is too long
SELECT *
FROM (SELECT p.id AS competencyplan_id, p.name AS competencyplan_name, p.description AS competencyplan_description, p.descriptionformat AS competencyplan_descriptionformat, p.userid AS competencyplan_userid, p.templateid AS competencyplan_templateid, p.origtemplateid AS competencyplan_origtemplateid, p.status AS competencyplan_status, p.duedate AS competencyplan_duedate, p.reviewerid AS competencyplan_reviewerid, p.timecreated AS competencyplan_timecreated, p.timemodified AS competencyplan_timemodified, p.usermodified AS competencyplan_usermodified, t.id AS competencytemplate_id, t.shortname AS competencytemplate_shortname, t.description AS competencytemplate_description, t.descriptionformat AS competencytemplate_descriptionformat, t.duedate AS competencytemplate_duedate, t.visible AS competencytemplate_visible, t.contextid AS competencytemplate_contextid, t.timecreated AS competencytemplate_timecreated, t.timemodified AS competencytemplate_timemodified, t.usermodified AS competencytemplate_usermodified, u.id AS usr_id,u.confirmed AS usr_confirmed,u.policyagreed AS usr_policyagreed,u.deleted AS usr_deleted,u.suspended AS usr_suspended,u.mnethostid AS usr_mnethostid,u.username AS usr_username,u.password AS usr_password,u.idnumber AS usr_idnumber,u.firstname AS usr_firstname,u.lastname AS usr_lastname,u.email AS usr_email,u.emailstop AS usr_emailstop,u.icq AS usr_icq,u.skype AS usr_skype,u.yahoo AS usr_yahoo,u.aim AS usr_aim,u.msn AS usr_msn,u.phone1 AS usr_phone1,u.phone2 AS usr_phone2,u.institution AS usr_institution,u.department AS usr_department,u.address AS usr_address,u.city AS usr_city,u.country AS usr_country,u.lang AS usr_lang,u.calendartype AS usr_calendartype,u.theme AS usr_theme,u.timezone AS usr_timezone,u.firstaccess AS usr_firstaccess,u.lastaccess AS usr_lastaccess,u.lastlogin AS usr_lastlogin,u.currentlogin AS usr_currentlogin,u.lastip AS usr_lastip,u.secret AS usr_secret,u.picture AS usr_picture,u.url AS usr_url,u.description AS usr_description,u.descriptionformat AS usr_descriptionformat,u.mailformat AS usr_mailformat,u.maildigest AS usr_maildigest,u.maildisplay AS usr_maildisplay,u.autosubscribe AS usr_autosubscribe,u.trackforums AS usr_trackforums,u.timecreated AS usr_timecreated,u.timemodified AS usr_timemodified,u.trustbitmask AS usr_trustbitmask,u.imagealt AS usr_imagealt,u.lastnamephonetic AS usr_lastnamephonetic,u.firstnamephonetic AS usr_firstnamephonetic,u.middlename AS usr_middlename,u.alternatename AS usr_alternatename FROM a_competency_plan p
JOIN a_user u
ON u.id = p.userid
LEFT JOIN a_competency_template t
ON t.id = p.templateid
WHERE (p.status = :o_waitingforreview
OR (p.status = :o_inreview AND p.reviewerid = :o_reviewerid))
AND p.userid != :o_userid AND p.userid > 0)
WHERE rownum <= :o_oracle_num_rows
[array (
'o_waitingforreview' => 3,
'o_inreview' => 4,
'o_reviewerid' => '5',
'o_userid' => '5',
'o_oracle_num_rows' => 3,
)]
Error code: dmlreadexception
Stack trace: