AnsweredAssumed Answered

Question on bg-niku log warnings from Processes

Question asked by LoriHagewood on Mar 19, 2010
Latest reply on May 2, 2013 by another_martink
We have a number of warnings showing up in our bg-niku log files and are wondering if anyone has thoughts on what may be causing them.   We have a number of processes in our environment, some using the basic process engine configuration and some that use custom GEL.   These errors are seen repeatedly, and we're wondering if anyone has thoughts as to what could be throwing these.   Thanks in advance for any feedback!  Excerpt below: WARN   2010-03-18 13:31:36,257 [Event Handler Thread-762] com.niku (none:none:none) For info only - SQL statement not supported by OMP: WARN   2010-03-18 13:31:36,257 [Event Handler Thread-762] com.niku (none:none:none) SQL message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression. WARN   2010-03-18 13:31:36,257 [Event Handler Thread-762] com.niku (none:none:none) Statement Id: omp.dynamic.select-object.map::risk:NIKU.ALL:1:probability, asu_pro_pro_typ, status_code, priority_code, asu_maj_por_des, asu_prj_act_yn, asu_sta_ind WARN   2010-03-18 13:31:36,257 [Event Handler Thread-762] com.niku (none:none:none) SQL statement: SELECT         s0.id odf_pk, s0.PROBABILITY_ENUM AS probability,         (SELECT odf_ca_project.prj_type FROM odf_ca_project (NOLOCK), rim_risks_and_issues (NOLOCK), odf_ca_risk (NOLOCK) WHERE   1=1   AND rim_risks_and_issues.id = odf_ca_risk.id) asu_pro_pro_typ, s0.STATUS_CODE AS status_code, s0.PRIORITY_CODE AS priority_code,         (SELECT odf_ca_project.portfolio FROM odf_ca_project (NOLOCK), rim_risks_and_issues (NOLOCK), odf_ca_risk (NOLOCK) WHERE   1=1   AND rim_risks_and_issues.id = odf_ca_risk.id) asu_maj_por_des,         (SELECT inv_investments.IS_ACTIVE FROM inv_investments (NOLOCK), rim_risks_and_issues (NOLOCK), odf_ca_risk (NOLOCK) WHERE   1=1   AND rim_risks_and_issues.id = odf_ca_risk.id) asu_prj_act_yn,         (SELECT inv_investments.STATUS_INDICATOR FROM inv_investments (NOLOCK), rim_risks_and_issues (NOLOCK), odf_ca_risk (NOLOCK) WHERE   1=1   AND rim_risks_and_issues.id = odf_ca_risk.id) asu_sta_ind FROM     rim_risks_and_issues s0 (NOLOCK)   WHERE (     s0.id=?   and (exists(select 'x' from (select user_id from cmn_sec_chk_user_r_v0 where object_id=50760 and permission_code='READ') odf_view_all where odf_view_all.user_id = ?) or s0.id in (select object_instance_id from (SELECT                 rim.id object_instance_id,                 security.user_id                 FROM                 cmn_sec_assgnd_obj_perm_v0 security,                 inv_investments investments,                 rim_risks_and_issues rim                 WHERE                 security.object_id = 50760                 And security.permission_code='READ'                 And investments.id = rim.pk_id                 And security.object_instance_id = investments.id                 And rim.type_code='RISK') odf_view_instance where odf_view_instance.user_id = ?))) WARN   2010-03-18 13:31:36,257 [Event Handler Thread-762] com.niku (none:none:none) Parameter 1: 5071010 WARN   2010-03-18 13:31:36,257 [Event Handler Thread-762] com.niku (none:none:none) Parameter 2: 5021352 WARN   2010-03-18 13:31:36,257 [Event Handler Thread-762] com.niku (none:none:none) Parameter 3: 5021352 WARN   2010-03-18 13:33:24,583 [Event Handler Thread-763] com.niku (none:none:none) For info only - SQL statement not supported by OMP: WARN   2010-03-18 13:33:24,583 [Event Handler Thread-763] com.niku (none:none:none) SQL message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression. WARN   2010-03-18 13:33:24,583 [Event Handler Thread-763] com.niku (none:none:none) Statement Id: omp.dynamic.select-object.map::risk:NIKU.ALL:1:probability, asu_pro_pro_typ, status_code, priority_code, asu_maj_por_des, asu_prj_act_yn, asu_sta_ind WARN   2010-03-18 13:33:24,583 [Event Handler Thread-763] com.niku (none:none:none) SQL statement: SELECT         s0.id odf_pk, s0.PROBABILITY_ENUM AS probability,         (SELECT odf_ca_project.prj_type FROM odf_ca_project (NOLOCK), rim_risks_and_issues (NOLOCK), odf_ca_risk (NOLOCK) WHERE   1=1   AND rim_risks_and_issues.id = odf_ca_risk.id) asu_pro_pro_typ, s0.STATUS_CODE AS status_code, s0.PRIORITY_CODE AS priority_code,         (SELECT odf_ca_project.portfolio FROM odf_ca_project (NOLOCK), rim_risks_and_issues (NOLOCK), odf_ca_risk (NOLOCK) WHERE   1=1   AND rim_risks_and_issues.id = odf_ca_risk.id) asu_maj_por_des,         (SELECT inv_investments.IS_ACTIVE FROM inv_investments (NOLOCK), rim_risks_and_issues (NOLOCK), odf_ca_risk (NOLOCK) WHERE   1=1   AND rim_risks_and_issues.id = odf_ca_risk.id) asu_prj_act_yn,         (SELECT inv_investments.STATUS_INDICATOR FROM inv_investments (NOLOCK), rim_risks_and_issues (NOLOCK), odf_ca_risk (NOLOCK) WHERE   1=1   AND rim_risks_and_issues.id = odf_ca_risk.id) asu_sta_ind FROM     rim_risks_and_issues s0 (NOLOCK)   WHERE (     s0.id=?   and (exists(select 'x' from (select user_id from cmn_sec_chk_user_r_v0 where object_id=50760 and permission_code='READ') odf_view_all where odf_view_all.user_id = ?) or s0.id in (select object_instance_id from (SELECT                 rim.id object_instance_id,                 security.user_id                 FROM                 cmn_sec_assgnd_obj_perm_v0 security,                 inv_investments investments,                 rim_risks_and_issues rim                 WHERE                 security.object_id = 50760                 And security.permission_code='READ'                 And investments.id = rim.pk_id                 And security.object_instance_id = investments.id                 And rim.type_code='RISK') odf_view_instance where odf_view_instance.user_id = ?))) WARN   2010-03-18 13:33:24,583 [Event Handler Thread-763] com.niku (none:none:none) Parameter 1: 5071011 WARN   2010-03-18 13:33:24,583 [Event Handler Thread-763] com.niku (none:none:none) Parameter 2: 5021352 WARN   2010-03-18 13:33:24,583 [Event Handler Thread-763] com.niku (none:none:none) Parameter 3: 5021352 WARN   2010-03-18 13:36:55,329 [Event Handler Thread-765] com.niku (none:none:none) For info only - SQL statement not supported by OMP: WARN   2010-03-18 13:36:55,329 [Event Handler Thread-765] com.niku (none:none:none) SQL message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression. WARN   2010-03-18 13:36:55,329 [Event Handler Thread-765] com.niku (none:none:none) Statement Id: omp.dynamic.select-object.map::risk:NIKU.ALL:1:probability, asu_pro_pro_typ, status_code, priority_code, asu_maj_por_des, asu_prj_act_yn, asu_sta_ind WARN   2010-03-18 13:36:55,329 [Event Handler Thread-765] com.niku (none:none:none) SQL statement: SELECT         s0.id odf_pk, s0.PROBABILITY_ENUM AS probability,         (SELECT odf_ca_project.prj_type FROM odf_ca_project (NOLOCK), rim_risks_and_issues (NOLOCK), odf_ca_risk (NOLOCK) WHERE   1=1   AND rim_risks_and_issues.id = odf_ca_risk.id) asu_pro_pro_typ, s0.STATUS_CODE AS status_code, s0.PRIORITY_CODE AS priority_code,         (SELECT odf_ca_project.portfolio FROM odf_ca_project (NOLOCK), rim_risks_and_issues (NOLOCK), odf_ca_risk (NOLOCK) WHERE   1=1   AND rim_risks_and_issues.id = odf_ca_risk.id) asu_maj_por_des,         (SELECT inv_investments.IS_ACTIVE FROM inv_investments (NOLOCK), rim_risks_and_issues (NOLOCK), odf_ca_risk (NOLOCK) WHERE   1=1   AND rim_risks_and_issues.id = odf_ca_risk.id) asu_prj_act_yn,         (SELECT inv_investments.STATUS_INDICATOR FROM inv_investments (NOLOCK), rim_risks_and_issues (NOLOCK), odf_ca_risk (NOLOCK) WHERE   1=1   AND rim_risks_and_issues.id = odf_ca_risk.id) asu_sta_ind FROM     rim_risks_and_issues s0 (NOLOCK)   WHERE (     s0.id=?   and (exists(select 'x' from (select user_id from cmn_sec_chk_user_r_v0 where object_id=50760 and permission_code='READ') odf_view_all where odf_view_all.user_id = ?) or s0.id in (select object_instance_id from (SELECT                 rim.id object_instance_id,                 security.user_id                 FROM                 cmn_sec_assgnd_obj_perm_v0 security,                 inv_investments investments,                 rim_risks_and_issues rim                 WHERE                 security.object_id = 50760                 And security.permission_code='READ'                 And investments.id = rim.pk_id                 And security.object_instance_id = investments.id                 And rim.type_code='RISK') odf_view_instance where odf_view_instance.user_id = ?))) WARN   2010-03-18 13:36:55,329 [Event Handler Thread-765] com.niku (none:none:none) Parameter 1: 5071012 WARN   2010-03-18 13:36:55,329 [Event Handler Thread-765] com.niku (none:none:none) Parameter 2: 5021352 WARN   2010-03-18 13:36:55,329 [Event Handler Thread-765] com.niku (none:none:none) Parameter 3: 5021352   

Outcomes