Clarity PPM1

Expand all | Collapse all

Again a question about time slicing job

Jump to Best Answer
  • 1.  Again a question about time slicing job

    Posted 01-18-2017 02:02 AM

    Hi all,

     

    When invastigating  LDAP job error I have seen another job issue

    Does any one has any idea about this issue? Where can I start to dig?

     

    I have check PRJ_BLB_SLICE_RESET_ALL_SP and does not have a sub query.

     

    Regards

     

    ERROR 2017-01-18 08:28:15,108 [Dispatch Time Slicing : bg@S0134CAAPP01 (tenant=clarity)] niku.njs (clarity:admin:5644473__5369318E-9BE3-4519-BEBC-23528CFD2CBE:Time Slicing) Error executing job: 1030 error The timeslice job has failed.
    ERROR 2017-01-18 08:29:15,614 [Dispatch Time Slicing : bg@S0134CAAPP01 (tenant=clarity)] niku.blobcrack (clarity:admin:5644476__AFB37282-4E11-472C-B3D2-684F200B4606:Time Slicing) Exception during blobcrack process
    com.niku.union.persistence.PersistenceException:
    SQL error code: 512
    Error 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.
    SQL error code: 3621
    Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The statement has been terminated.
    Executed:
    {call PRJ_BLB_SLICE_RESET_ALL_SP(?,?)}
    Derived from statement:
    <?xml version="1.0" encoding="UTF-8"?>
    <statement sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="map" xmlns="http://schemas.niku.com/2002/pmd">
    <sql dbVendor="all">
    <text>
    {call PRJ_BLB_SLICE_RESET_ALL_SP(?,?)}
    </text>
    <param type="string" direction="IN" constantValue="PRJ_RESOURCES" expressionListDelimiter=","/>
    <param name="sliceStatusFlag" type="int" direction="IN" expressionListDelimiter=","/>
    </sql>
    </statement>

    Referenced by:
    <?xml version="1.0" encoding="UTF-8"?>
    <statementRef id="blobcrack.setAllResourcesModified_set_nested_0" inputSource="map" inputMapIndex="0" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" defaultSliceSize="20" ignoreIfError="false" hideResultSets="false" xmlns="http://schemas.niku.com/2002/pmd"/>

    Using input:
    {sliceStatusFlag=3, parameters=[int:sliceStatusFlag:3:]}

    at com.niku.union.persistence.PersistenceController.createException(PersistenceController.java:2085)
    at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:2189)
    at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2823)
    at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:869)
    at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:769)
    at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:577)
    at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:307)
    at com.niku.xql2.pmd.PMDDataSource.execute(PMDDataSource.java:213)
    at com.niku.blobcrack.BlobCrackDB.resetRequest(BlobCrackDB.java:306)
    at com.niku.blobcrack.BlobCrackDB.resetRequests(BlobCrackDB.java:336)
    at com.niku.blobcrack.BlobCrackDB.prepareSliceStatus(BlobCrackDB.java:1996)
    at com.niku.blobcrack.BlobCrackDB.sliceCurves(BlobCrackDB.java:1720)
    at com.niku.blobcrack.BlobCrackDB.createSlices(BlobCrackDB.java:1252)
    at com.niku.blobcrack.xql2.handlers.BlobCracker.processExpiredRequests(BlobCracker.java:233)
    at com.niku.blobcrack.xql2.handlers.BlobCracker.postProcess(BlobCracker.java:45)
    at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1419)
    at com.niku.union.xml.dom.DOMWalker.postProcess(DOMWalker.java:210)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:94)
    at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
    at com.niku.xql2.handlers.TryHandler.preProcess(TryHandler.java:54)
    at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1385)
    at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
    at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:36)
    at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:257)
    at com.niku.njs.xbl.XBLService.process(XBLService.java:127)
    at com.niku.njs.xbl.XBLService.process(XBLService.java:75)
    at com.niku.njs.listeners.XBLJob.scheduledEventFired(XBLJob.java:44)
    at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:395)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
    Caused by: java.sql.SQLException: [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.
    at com.ca.clarity.jdbc.sqlserverbase.ddcw.b(Unknown Source)
    at com.ca.clarity.jdbc.sqlserverbase.ddcw.a(Unknown Source)
    at com.ca.clarity.jdbc.sqlserverbase.ddcv.b(Unknown Source)
    at com.ca.clarity.jdbc.sqlserverbase.ddcv.a(Unknown Source)
    at com.ca.clarity.jdbc.sqlserver.tds.ddr.v(Unknown Source)
    at com.ca.clarity.jdbc.sqlserver.tds.ddr.a(Unknown Source)
    at com.ca.clarity.jdbc.sqlserver.tds.ddq.a(Unknown Source)
    at com.ca.clarity.jdbc.sqlserver.tds.ddr.a(Unknown Source)
    at com.ca.clarity.jdbc.sqlserver.tds.ddr.q(Unknown Source)
    at com.ca.clarity.jdbc.sqlserver.dda_.a(Unknown Source)
    at com.ca.clarity.jdbc.sqlserverbase.dddd.j(Unknown Source)
    at com.ca.clarity.jdbc.sqlserverbase.ddea.next(Unknown Source)
    at com.niku.union.persistence.PersistenceResponse.extractNormalResultSet(PersistenceResponse.java:191)
    at com.niku.union.persistence.PersistenceController.extractResultSet(PersistenceController.java:1833)
    at com.niku.union.persistence.PersistenceController.extractResultSets(PersistenceController.java:1882)
    at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2796)
    ... 31 more



  • 2.  Re: Again a question about time slicing job

    Posted 01-18-2017 02:22 AM

    Check these:

     

    V13.1 Datamart extraction failures

    https://communities.ca.com/message/105627812 

     

     

    Database Connection Issues

    https://communities.ca.com/thread/241736943  

     

     

    NJ



  • 3.  Re: Again a question about time slicing job

    Posted 01-18-2017 04:28 AM

    I have checked these notes. We do not have any db connectivity issue. Also the message says "Subquery returned more than 1 value."  May there be a bad value in PRJ_RESOURCES table?

     

    Regards



  • 4.  Re: Again a question about time slicing job

    Posted 01-19-2017 02:16 AM

    Any recommendation on this issue ?



  • 5.  Re: Again a question about time slicing job

    Posted 01-19-2017 09:18 AM

    Hi all,

    May this issue has an effect on mu JasperReport? especially resource related reports? I cannot run any resource related report (allocation vs capacity, resource availability etc.). 

     

    Regards



  • 6.  Re: Again a question about time slicing job
    Best Answer

    Posted 01-19-2017 12:33 PM

    related with "Time Slicing Job" is failing constantly . Solved. 

     

    Regards