Clarity

 View Only
Expand all | Collapse all

Time Slice Job failing with blobcrack error

  • 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.



  • 11.  RE: Time Slice Job failing with blobcrack error

    Posted Nov 28, 2022 09:58 AM
    Since there is no final info or resolution for this problem, which would have helped me a lot, since we ran into it too, here is what helped me (thanks Joxi for pointing me there!) - check if:

    a) there are no leftover slices for attributes/objects, which have since been deleted,
    b) there are no slices for attributes/objects, which were included in DWH at some point and then un-included again.

    As a rule of thumb, you can simply include all the object with time-sliced attributes into DWH, just to be sure.

    We had an object with time-sliced attribute included in DWH, it was un-included some time after the TS creation and it caused the issue. After I re-included the object into DWH, the problem disappeared.

    Petr


  • 12.  RE: Time Slice Job failing with blobcrack error

    Broadcom Employee
    Posted Nov 29, 2022 04:09 AM
    Thanks Peter and Joxi. 

    To add to it any meta data change with objects and attributes need to be checked for dependencies and also during the non usage hours and any external dependencies like jobs/integration should be put on hold while making these configuration

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------