AnsweredAssumed Answered

Performance issue - Timesheets not available

Question asked by matej256 on Apr 16, 2015
Latest reply on May 20, 2015 by matej256

Hi All,

 

We're currently facing some issue with Timesheets - from yesterday accessing them it lasts pretty long time (some minutes after clicking on TS icon).

Today also we got some errors when trying to access TS - Fatal errors.

 

We've requested AWR and ASH (DB reports) from DB admin and they showed about 78% of DB CPU time spent on Timesheet loading by app3 service engine.

 

Looking into app3 logs there are some error we can't identify. Could you please help on this? Example of error:

 

FATAL 2015-04-15 09:37:06,596 [http-bio-29082-exec-1262] web.VXSLServer (clarity:weilerer:76346079__42C122DD-515D-414C-A0D3-7990EDA32497:timeadmin.selectTimesheetTask) Transformation fatal error:A sequence of more than one item is not allowed as the 12th argument of concat(); SystemID: file:/home/clarity/niku/clarity/META-INF/projmgr/vxsl/commonTemplates.xsl; Line#: 1048575; Column#: -1

; SystemID: file:/home/clarity/niku/clarity/META-INF/projmgr/vxsl/commonTemplates.xsl; Line#: 1048575; Column#: -1

net.sf.saxon.trans.DynamicError: A sequence of more than one item is not allowed as the 12th argument of concat()

at net.sf.saxon.expr.ComputedExpression.typeError(ComputedExpression.java:622)

at net.sf.saxon.expr.SingletonAtomizer.evaluateItem(SingletonAtomizer.java:109)

at net.sf.saxon.functions.Concat.evaluateItem(Concat.java:38)

at net.sf.saxon.expr.ExpressionTool.eagerEvaluate(ExpressionTool.java:296)

at net.sf.saxon.expr.ExpressionTool.lazyEvaluate(ExpressionTool.java:244)

at net.sf.saxon.expr.LetExpression.eval(LetExpression.java:163)

 

OR

 

ERROR 2015-04-15 09:36:59,503 [http-bio-29082-exec-1263] niku.union (clarity:weilerer:76346079__42C122DD-515D-414C-A0D3-7990EDA32497:timeadmin.selectTimesheetTask)

com.niku.union.web.WebException: net.sf.saxon.trans.DynamicError: A sequence of more than one item is not allowed as the 12th argument of concat()

  at com.niku.union.web.VXSLServer.transform(VXSLServer.java:166)

  at com.niku.union.web.VXSLServer.transform(VXSLServer.java:94)

  at com.niku.union.web.XMLPageProcessor.transformDataToView(XMLPageProcessor.java:677)

  at com.niku.union.web.XMLPageProcessor.processPortletXSL(XMLPageProcessor.java:862)

  at com.niku.union.web.XMLPageProcessor.processPage(XMLPageProcessor.java:193)

  at com.niku.union.web.XMLPageProcessor.processPage(XMLPageProcessor.java:83)

I've checked for this error through communities page but found only 2 threads which didn't help me.

 

I've checked mentioned file (commonTemplates.xsl) and found concat function but don't know how to fix it...even we don't have changed this file...

 

Both reports and example of app3 log I have but can't attach there as files.

 

Thanks

 

Matej

Outcomes