AnsweredAssumed Answered

Timeslice Job not completing

Question asked by RKP on May 25, 2017
Latest reply on Jun 8, 2017 by SHUBHAM BHATIA

Hi,

Since morning timslice job is running and seems like its stuck. BG log is showing the error as :

 

Statement Id: omp.dynamic.select-object.map::llist_obj_pls:NIKU.ALL:0:prodyears
WARN  2017-05-25 05:31:07,207 [Post Condition Transition Pipeline 2 (tenant=clarity)] com.niku (clarity:process_admin:222312001__5A4B7CB0-8B9C-4C38-B402-AA8E2DAB7EC3:none) SQL statement: SELECT  s0.id odf_pk,     (SELECT odf_ca_project.prodyears FROM odf_ca_project, odf_ca_llist_obj_pls WHERE  1=1 ) prodyears FROM   odf_ca_llist_obj_pls s0  WHERE (   s0.id=? )
WARN  2017-05-25 05:31:07,207 [Post Condition Transition Pipeline 2 (tenant=clarity)] com.niku (clarity:process_admin:222312001__5A4B7CB0-8B9C-4C38-B402-AA8E2DAB7EC3:none) Parameter 1: ######
INFO  2017-05-25 05:31:07,754 [Dispatch Time Slicing - 25/05 :  (tenant=clarity)] niku.blobcrack (clarity:GuptaA12:222351584__41DF0222-C3C6-4977-A7C4-218616F9B25C:Time Slicing - 25/05) ### Curve set size is 1000
WARN  2017-05-25 05:31:08,909 [Post Condition Transition Pipeline 0 (tenant=clarity)] com.niku (clarity:process_admin:222312001__5A4B7CB0-8B9C-4C38-B402-AA8E2DAB7EC3:none) For info only - SQL statement not supported by OMP:
WARN  2017-05-25 05:31:08,909 [Post Condition Transition Pipeline 0 (tenant=clarity)] com.niku (clarity:process_admin:222312001__5A4B7CB0-8B9C-4C38-B402-AA8E2DAB7EC3:none) SQL message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01427: single-row subquery returns more than one row

 

Kindly help!

 

Regards

Ritesh

Outcomes