Clarity

 View Only
  • 1.  Time Slice Job failing with blobcrack error

    Posted Jul 25, 2016 12:42 PM

    Hi,

     

    Just did a setup for data warehouse on our system (v14.3) and getting following error while running the time slice job.

     

    ERROR 2016-07-25 04:44:44,909 [Dispatch Time Slicing LB : bg@hqidlppmap51.hqh.intra.aexp.com (tenant=clarity)] niku.blobcrack (clarity:xxxxx:*********__xxxx:Time Slicing LB) Exception during blobcrack process

    com.niku.union.persistence.PersistenceException: An error occurred getting statement set: odf-pmd.assignment.reset-TSV-status-actcost_curve.map from resolver

      at com.niku.union.persistence.PersistenceCache._getStatementSet(PersistenceCache.java:353)

      at com.niku.union.persistence.PersistenceCache.getStatementSet(PersistenceCache.java:305)

      at com.niku.union.persistence.PersistenceController.<init>(PersistenceController.java:342)

      at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:306)

      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.processNewRequests(BlobCracker.java:214)

      at com.niku.blobcrack.xql2.handlers.BlobCracker.postProcess(BlobCracker.java:44)

      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.lang.NullPointerException

      at com.niku.odf.object.query.PMDResolver.createSingleResetTSVSet(PMDResolver.java:1708)

      at com.niku.odf.object.query.PMDResolver.createSet(PMDResolver.java:2336)

      at com.niku.odf.object.query.PMDResolver.getStatementSet(PMDResolver.java:2458)

      at com.niku.union.persistence.PersistenceCache.getStatementSetFromResolver(PersistenceCache.java:188)

      at com.niku.union.persistence.PersistenceCache._getStatementSet(PersistenceCache.java:345)

      ... 30 more

    ERROR 2016-07-25 04:44:44,910 [Dispatch Time Slicing LB : bg@hqidlppmap51.hqh.intra.aexp.com (tenant=clarity)] niku.blobcrack (clarity:xxxxx:*********__xxxx:Time Slicing LB) Exception during blobcrack process

    com.niku.union.persistence.PersistenceException: An error occurred getting statement set: odf-pmd.assignment.reset-TSV-status-actcost_curve.map from resolver

      at com.niku.union.persistence.PersistenceCache._getStatementSet(PersistenceCache.java:353)

      at com.niku.union.persistence.PersistenceCache.getStatementSet(PersistenceCache.java:305)

      at com.niku.union.persistence.PersistenceController.<init>(PersistenceController.java:342)

      at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:306)

      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.processNewRequests(BlobCracker.java:214)

      at com.niku.blobcrack.xql2.handlers.BlobCracker.postProcess(BlobCracker.java:44)

      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.lang.NullPointerException

      at com.niku.odf.object.query.PMDResolver.createSingleResetTSVSet(PMDResolver.java:1708)

      at com.niku.odf.object.query.PMDResolver.createSet(PMDResolver.java:2336)

      at com.niku.odf.object.query.PMDResolver.getStatementSet(PMDResolver.java:2458)

      at com.niku.union.persistence.PersistenceCache.getStatementSetFromResolver(PersistenceCache.java:188)

      at com.niku.union.persistence.PersistenceCache._getStatementSet(PersistenceCache.java:345)

      ... 30 more

    ERROR 2016-07-25 04:44:44,930 [Dispatch Time Slicing LB : bg@hqidlppmap51.hqh.intra.aexp.com (tenant=clarity)] niku.njs (clarity:xxxxx:*********__xxxx:Time Slicing LB) Error executing job: 6900147 error The timeslice job has failed.

     

    Any help is appreciated.



  • 2.  Re: Time Slice Job failing with blobcrack error

    Posted Jul 25, 2016 12:58 PM

    Seems to be issue with assignment

     

    NJ



  • 3.  Re: Time Slice Job failing with blobcrack error

    Posted Jul 25, 2016 02:19 PM

    Thanks NJ,

     

    Is there a way by which I can pinpoint what is the exact issue with assignment.

     

    Thanks

    Nikunj



  • 4.  Re: Time Slice Job failing with blobcrack error

    Broadcom Employee
    Posted Jul 25, 2016 02:21 PM

    1.From the CSA > Logs > Edit Configuration

     

    For each server running BG, the following component should be set accordingly:

    ERROR logging level on the

    component: com.niku.blobcrack STDOUT

     

    Is there a checkmark on 'Detect Log Configuration Changes Automatically'?

       If checked, the BG service does not have to be restarted.

       If it is not checked, the BG does have to be restarted.

     

    2. Run the Time Slicing job and review the BG logs for the additional logging to see if any additional information appears.

     

    Regards,
    Tuan



  • 5.  Re: Time Slice Job failing with blobcrack error

    Posted Jul 25, 2016 05:14 PM

    Getting the following details in logs now:

     

    INFO  2016-07-25 11:26:01,943 [Dispatch Time Slicing : bg@hqidlppmap51.hqh.intra.aexp.com (tenant=clarity)] niku.blobcrack (clarity:xxxxxxxxxxxxxxxxx:Time Slicing) Resetting all objects to be sliced: (5008058) odf-pmd.assignment.reset-TSV-status-actcost_curve.map to 4

    INFO  2016-07-25 11:26:01,943 [Dispatch Time Slicing : bg@hqidlppmap51.hqh.intra.aexp.com (tenant=clarity)] niku.blobcrack (clarity:xxxxxxxxxxxxxxxxxxxxxxxxxxxxxE:Time Slicing) Resetting all objects to be sliced: (5008058) odf-pmd.assignment.reset-TSV-status-actcost_curve.map to 4

    ERROR 2016-07-25 11:26:01,943 [Dispatch Time Slicing : bg@hqidlppmap51.hqh.intra.aexp.com (tenant=clarity)] niku.blobcrack (clarity:xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx:Time Slicing) Exception during blobcrack process

    com.niku.union.persistence.PersistenceException: An error occurred getting statement set: odf-pmd.assignment.reset-TSV-status-actcost_curve.map from resolver

      at com.niku.union.persistence.PersistenceCache._getStatementSet(PersistenceCache.java:353)

      at com.niku.union.persistence.PersistenceCache.getStatementSet(PersistenceCache.java:305)

      at com.niku.union.persistence.PersistenceController.<init>(PersistenceController.java:342)

      at com.niku.union.persistence.PersistenceController.processRequest(PersistenceController.java:306)

      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

     

    After analyzing it looks like and issue with with following Time slice requests:

     

    assignment::actcost_curve::dwh_month
    assignment::actcost_curve::dwh_week
    assignment::actcost_curve::dwh_fiscal

     

    The setup for these slices are as follows

     

     

    Any more ides what could be going wrong.



  • 6.  Re: Time Slice Job failing with blobcrack error

    Broadcom Employee
    Posted Jul 25, 2016 05:43 PM

    Based on the screenshot, it does not appear the DWH time slices have been set up.
    Can you review if the following have been set up?

     

    1.
    https://communities.ca.com/thread/241730797

    CA PPM Tech Tip: Getting Jaspersoft Advanced Reporting to work after upgrading to 14.2+

     

    2.
    https://docops.ca.com/ca-ppm/14-3/administrating/configure-advanced-reporting#ConfigureAdvancedReporting-ConfiguretheDataWarehouseTimeSlices



  • 7.  Re: Time Slice Job failing with blobcrack error

    Posted Jul 26, 2016 07:29 PM

    Hi Tuan,

     

    I followed the steps mentioned by you in the link one. But still getting the same error and the second link is not working.

    Do you think there is any other reason why that 3 time slice requests are causing issues ?

    Could it be a data issue ?

     

    Thanks

    Nikunj Jain



  • 8.  Re: Time Slice Job failing with blobcrack error

    Broadcom Employee
    Posted Jul 27, 2016 09:35 AM

    Hi Nikunj,

     

    Let's go ahead and open a support case and reference the link to this discussion.

     

    Regards,
    Tuan



  • 9.  Re: Time Slice Job failing with blobcrack error

    Posted Aug 01, 2016 03:03 PM

    Hi NikunjJain - We're you able to resolve this issue with Support's help? Thanks!



  • 10.  Re: Time Slice Job failing with blobcrack error

    Posted Aug 05, 2016 12:19 AM

    No Chris. I have raised a support ticket for the same. Will update this post once I find the solution.