Clarity

Hello All,

We have issue with TimeSlice Job and its failing The timeslice job has failed.

Can anyone please let me know which logs contains the details of the failure?

Thanks in Advance.

~Prasanth

Presumably you have a PPM background service that runs your jobs, the default log file for that information to go out to would be bg-ca.log for the first bg service installed on a system.

When looking for errors in that file, relating to the Time Slicing job, they will commonly have niku.blobcrack (as the logging category) present in the header line.

ERROR 2016-05-31 13:38:56,534 [Dispatch pool-4-thread-1 : (tenant=clarity)] niku.njs (clarity:scheduler:12723185__93BD6ED5-000E-477F-8523-AD0E9DEE8DDD:Time Slicing - Continuous) Error executing job: 5488002 error The timeslice job has failed.

This is what I see in the bg-ca.log. Any idea on this error.

Thanks in Advance

Prasanth

There isn't any detail here to indicate what may have happened.  If your log file has text between this ERROR entry and the next, that needs to be included too in order to stand a chance of understanding what happened.

Sometimes there are also multiple ERROR entries to consider, so please check the one PRECEDING and after this one you found for possible related information.   Particularly where they have the same thread name and timing (e.g. Dispatch pool-4-thread-1 in this case).

After digging more into the logs I found below details.

ERROR 2016-05-31 13:38:55,708 [Dispatch pool-4-thread-1 :  (tenant=clarity)] niku.blobcrack (clarity:scheduler:12723185__93BD6ED5-000E-477F-8523-AD0E9DEE8DDD:Time Slicing - Continuous) Exception during blobcrack process

com.niku.union.persistence.PersistenceException:

SQL error code: 1426

Error message: ORA-01426: numeric overflow

Executed:

UPDATE PRTEAM

                SET prAllocSum = ?

                WHERE prID = ?

Derived from statement:

<?xml version="1.0" encoding="UTF-8"?>

<statement batchable="true" 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>

                UPDATE PRTEAM

                SET prAllocSum = ?

                WHERE prID = ?

             </text>

    <param name="value" type="double" direction="IN" expressionListDelimiter=","/>

    <param name="objectID" type="int" direction="IN" expressionListDelimiter=","/>

  </sql>

</statement>

Referenced by:

<?xml version="1.0" encoding="UTF-8"?>

<statementRef id="blobcrack.setAllocSum_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:

{objectID=5532007, value=0.0}

{objectID=5544004, value=0.0}

{objectID=5317073, value=3648240.0}

{objectID=5532006, value=0.0}

{objectID=5546023, value=0.0}

{objectID=5337005, value=2255040.0}

{objectID=5249099, value=4505220.0}

{objectID=5283020, value=162000.0}

{objectID=5544006, value=0.0}

{objectID=5544005, value=0.0}

{objectID=5541018, value=4762800.0}

{objectID=5224022, value=0.0}

{objectID=5283017, value=907200.0}

{objectID=5224021, value=0.0}

{objectID=5429284, value=0.0}

{objectID=5544010, value=0.0}

{objectID=5544007, value=0.0}

{objectID=5224023, value=0.0}

{objectID=5253169, value=2222640.0}

{objectID=5544009, value=0.0}

{objectID=5544008, value=0.0}

{objectID=5337006, value=2609820.0}

{objectID=5039859, value=1995840.0}

{objectID=5167172, value=792.0}

{objectID=5429463, value=7095600.0}

{objectID=5429410, value=0.0}

{objectID=5429505, value=2689200.0}

{objectID=5429431, value=8229600.0}

{objectID=5429433, value=8294400.0}

{objectID=5429726, value=0.0}

{objectID=5427867, value=939600.0}

{objectID=5423189, value=0.0}

{objectID=5054873, value=0.0}

{objectID=5047144, value=0.0}

{objectID=5045220, value=0.0}

{objectID=5040370, value=0.0}

{objectID=5036381, value=486000.0}

{objectID=5429462, value=8294400.0}

{objectID=5544012, value=0.0}

{objectID=5453012, value=1620000.0}

{objectID=5429460, value=7095600.0}

{objectID=5546019, value=Infinity}

{objectID=5541015, value=668610.0000000002}

{objectID=5541014, value=668610.0000000002}

{objectID=5541013, value=668610.0000000002}

{objectID=5541012, value=2473857.0000000005}

{objectID=5538011, value=2723400.0000000005}

{objectID=5538008, value=2723400.0000000005}

{objectID=5538012, value=2723400.0000000005}

{objectID=5538010, value=2723400.0000000005}

{objectID=5538009, value=2723400.0000000005}

{objectID=5543017, value=2570400.0000000005}

{objectID=5543020, value=5140800.000000001}

{objectID=5543016, value=5140800.000000001}

{objectID=5429539, value=1.8320400000000004E7}

{objectID=5492055, value=44064.00000000001}

{objectID=5543015, value=1209600.0000000002}

{objectID=5543018, value=5140800.000000001}

{objectID=5543014, value=5140800.000000001}

{objectID=5543012, value=5140800.000000001}

{objectID=5543019, value=5140800.000000001}

{objectID=5429537, value=1.8320400000000004E7}

{objectID=5543021, value=1360800.0}

{objectID=5543013, value=2570400.0000000005}

{objectID=5429413, value=4320000.0}

{objectID=5295025, value=0.0}

{objectID=5229006, value=0.0}

  at com.niku.union.persistence.PersistenceController.createException(PersistenceController.java:2084)

  at com.niku.union.persistence.PersistenceController.handleSQLException(PersistenceController.java:2188)

  at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2822)

  at com.niku.union.persistence.PersistenceController.processStatement(PersistenceController.java:867)

  at com.niku.union.persistence.PersistenceController.processStatements(PersistenceController.java:767)

  at com.niku.union.persistence.PersistenceController.doProcessRequest(PersistenceController.java:575)

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

  at com.niku.union.persistence.PersistenceConversation.process(PersistenceConversation.java:444)

  at com.niku.blobcrack.BlobCrackDB.commit(BlobCrackDB.java:2307)

  at com.niku.blobcrack.BlobCrackDB.readCurves(BlobCrackDB.java:2023)

  at com.niku.blobcrack.BlobCrackDB.sliceCurves(BlobCrackDB.java:1747)

  at com.niku.blobcrack.BlobCrackDB.createSlices(BlobCrackDB.java:1252)

  at com.niku.blobcrack.xql2.handlers.BlobCracker.processCurrentRequests(BlobCracker.java:251)

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

  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:367)

  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

  at java.lang.Thread.run(Thread.java:745)

Caused by: java.sql.BatchUpdateException: ORA-01426: numeric overflow

  at com.ca.clarity.jdbc.oracle.ddn.b(Unknown Source)

  at com.ca.clarity.jdbc.oracle.ddn.s(Unknown Source)

  at com.ca.clarity.jdbc.oracle.ddn.r(Unknown Source)

  at com.ca.clarity.jdbc.oraclebase.ddes.v(Unknown Source)

  at com.ca.clarity.jdbc.oraclebase.dddm.executeBatch(Unknown Source)

  at com.niku.union.persistence.PersistenceController.processSql(PersistenceController.java:2817)

  ... 30 more

Please let me know if you can find anything out of this.

Thanks

Prasanth

Given the error message, the following stand out to me as suspicious:

{objectID=5546019, value=Infinity}

{objectID=5429539, value=1.8320400000000004E7}

{objectID=5429537, value=1.8320400000000004E7}

In each case, the objectID refers to a PRTeam record, and the value is the sum of the allocation found inside a blob/curve field.

The following query should help you see the project/resource combinations involved, and I would check them in the UI and possible re-allocate the resources again to see if it can fix any potential issues with those allocation records:

select t.prid, r.unique_name, r.full_name, r.email, i.name

from prteam t join srm_resources r on r.id = t.prresourceid

join inv_investments i on i.id = t.prprojectid

where t.prid in (5546019, 5429539, 5429537)

This should help:

On the Clarity Timeslice page the 'Last Run' date is not getting update for certain slices when the Timeslice job runs and completes

Document ID:  TEC1279773
Last Modified Date:  3/20/2015
  Show Technical Document Details

Description:

My 'DAILYRESOURCETIMECURVE' slice 'Last Run' date is not getting update when the Timeslice job runs and completes,

the slice_status which are set to 1 in the PrTimeentry table are not getting processed.

I have been getting these error messages flooding my log files;

ERROR message: niku.blobcrack (none:none:none) Exception during blobcrack process

1. com.niku.union.persistence.PersistenceException:

SQL error code: 1

Error message: ORA-00001: unique constraint

(CLARITY.PRJ_BLB_SLICES_M_ALC_U1) violated

Solution:

There are some preceding error messages in the log file which gives an indication the source of the issue;

ERROR message: niku.blobcrack (none:none:none) Exception during blobcrack process

1. com.niku.union.persistence.PersistenceException:

SQL error code: 1426

Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-01426: numeric

overflow

Executed:

UPDATE PRTEAM

SET prAllocSum = ?

WHERE prID = ?

Using input:

{value=Infinity, parameters=[int:objectID:5024142:, double:value:Infinity:],

objectID=5024142}

The input value is set to infinity.

This is an indication that you have a bad allocation segment with a value of <infinity>% in the Team => Staff properties page.

Check this for the resource and the project to which the resource is allocated to and correct this.

For example on the Project team page, click on the Properties Icon to open the Staff Member Properties page then delete the bad

segment with 1/1/2014 to 1/2/2014 <infinity symbol>%

and add new segment for 1/1/2014 to 1/2/2014 at 0%

Finally run the Timeslice job again so that all slices pending processing are sliced.

Source: On the Clarity Timeslice page the 'Last Run' date is not getting update for certain slices when the Timeslice job runs a…

NJ

Thanks for the update. I found the Project and Resource.

But the Allocation that  needs to be deleted is greyed out and cant be deleted.

Please let me know if there is a workaround to delete this allocation.

Thanks in Advance.

Can you share a screenshot as to where it is greyed out ?

NJ

Hello Navz ,

Kindly let us know , how to find the project  or resource details from the Object ID in the logs ?

Because of the Bad Record there are few issues that i am facing on that Particular Project.

I cant navigate to the Team Tab of the Project. And I get 'ErrorError 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator.' when I try to navigate to the Team Tab.

So I went to the Home->Resources->Allocations Tab of the Resource-> and Here also I get an error 'ErrorSystem error. Contact system administrator.'.

But I can see the Project that is allocated to the resource. PF screenshot below.

And the record that I want to delete is disabled.

Thanks in Advance.

Prasanth

Issue is resolved after modifying the record with Infinity allocation.

Where did you modify that and was that the record from which had the screenshot?