How do you reset a user's configuration in v13 when it is corrupted?

[vtleogal]

In v12, we just had to copy the url from one "good" user to the bad user's url after the action and we could reset a user's configuration to be the default.

 

however, in v13, the configuration screen is a pop-up and we can no longer use this. The user is getting " unable to process request- Server error; --

the logs show this: (User is clicking Home >Projects or even from Favorites). He can access a project by clicking on it from the timesheet, but cannot access the project list. Naturally I cannot publish the project list globally.  SO, I was thinking it was his filter. app-ca log shows the below in case a bad filter is not his issue? He was able to access the projects list after the upgrade, but he did say he changed his filters

we have 4 servers, SQL  , Win 2008 I tested on individual servers, same error. Tested on Firefox, same error

 

 

ERROR 2014-09-11 13:55:46,221 [http-bio-80-exec-1015] niku.union (clarity:SREDDY8:75052735__4A27A98E-EF28-42F4-B995-B4EEF1A7EEF4:mainnav.work)

com.niku.union.web.WebException: net.sf.saxon.trans.DynamicError: A sequence of more than one item is not allowed as the first argument of string-length()

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)

at com.ca.clarity.uif.service.vxml.Evolution3PageProcessor.retrievePage(Evolution3PageProcessor.java:146)

at com.niku.union.web.UIPageProcessor.buildPage(UIPageProcessor.java:89)

at com.ca.clarity.uif.service.vxml.VXMLResponseHandler.processResponse(VXMLResponseHandler.java:168)

at com.ca.clarity.uif.service.vxml.VXMLService.processRequest(VXMLService.java:591)

at com.ca.clarity.uif.UIServlet.service(UIServlet.java:69)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at com.niku.union.web.filter.ClarityContentFilter.doFilter(ClarityContentFilter.java:145)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at com.niku.union.web.filter.GZIPResponseFilter.doFilter(GZIPResponseFilter.java:94)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at com.niku.union.web.filter.CharsetFilter.doFilter(CharsetFilter.java:68)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:88)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

at com.niku.union.web.valves.ErrorPageRedirectValve.invoke(ErrorPageRedirectValve.java:70)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)

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

Caused by: net.sf.saxon.trans.DynamicError: A sequence of more than one item is not allowed as the first argument of string-length()

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

at net.sf.saxon.expr.CardinalityChecker.evaluateItem(CardinalityChecker.java:179)

at net.sf.saxon.functions.StringLength.evaluateItem(StringLength.java:80)

at net.sf.saxon.expr.ValueComparison.effectiveBooleanValue(ValueComparison.java:401)

at net.sf.saxon.instruct.Choose.processLeavingTail(Choose.java:260)

at net.sf.saxon.instruct.Block.processLeavingTail(Block.java:324)

at net.sf.saxon.instruct.Template.expand(Template.java:97)

at net.sf.saxon.instruct.CallTemplate.process(CallTemplate.java:189)

at net.sf.saxon.instruct.CallTemplate.processLeavingTail(CallTemplate.java:214)

at net.sf.saxon.instruct.Choose.processLeavingTail(Choose.java:262)

at net.sf.saxon.instruct.Instruction.process(Instruction.java:90)

at net.sf.saxon.instruct.DocumentInstr.evaluateItem(DocumentInstr.java:167)

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

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

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

at net.sf.saxon.expr.LetExpression.processLeavingTail(LetExpression.java:319)

at net.sf.saxon.instruct.Choose.processLeavingTail(Choose.java:262)

at net.sf.saxon.instruct.Choose.processLeavingTail(Choose.java:262)

at net.sf.saxon.instruct.Block.processLeavingTail(Block.java:324)

at net.sf.saxon.instruct.Instruction.process(Instruction.java:90)

at net.sf.saxon.instruct.ElementCreator.processLeavingTail(ElementCreator.java:162)

at net.sf.saxon.instruct.Block.processLeavingTail(Block.java:324)

at net.sf.saxon.instruct.Choose.processLeavingTail(Choose.java:262)

at net.sf.saxon.instruct.Block.processLeavingTail(Block.java:324)

at net.sf.saxon.instruct.Choose.processLeavingTail(Choose.java:262)

at net.sf.saxon.expr.LetExpression.processLeavingTail(LetExpression.java:328)

at net.sf.saxon.instruct.Block.processLeavingTail(Block.java:324)

at net.sf.saxon.instruct.Template.expand(Template.java:97)

at net.sf.saxon.instruct.CallTemplate$CallTemplatePackage.processLeavingTail(CallTemplate.java:352)

at net.sf.saxon.instruct.CallTemplate.process(CallTemplate.java:191)

at net.sf.saxon.instruct.ForEach.processLeavingTail(ForEach.java:222)

at net.sf.saxon.instruct.Block.processLeavingTail(Block.java:324)

at net.sf.saxon.instruct.Instruction.process(Instruction.java:90)

at net.sf.saxon.instruct.ElementCreator.processLeavingTail(ElementCreator.java:162)

at net.sf.saxon.instruct.Block.processLeavingTail(Block.java:324)

at net.sf.saxon.instruct.Instruction.process(Instruction.java:90)

at net.sf.saxon.instruct.ElementCreator.processLeavingTail(ElementCreator.java:162)

at net.sf.saxon.instruct.Choose.processLeavingTail(Choose.java:262)

at net.sf.saxon.instruct.Instruction.process(Instruction.java:90)

at net.sf.saxon.instruct.ForEach.processLeavingTail(ForEach.java:222)

at net.sf.saxon.instruct.Block.processLeavingTail(Block.java:324)

at net.sf.saxon.expr.LetExpression.processLeavingTail(LetExpression.java:328)

at net.sf.saxon.instruct.Block.processLeavingTail(Block.java:324)

at net.sf.saxon.instruct.Instruction.process(Instruction.java:90)

at net.sf.saxon.instruct.ElementCreator.processLeavingTail(ElementCreator.java:162)

at net.sf.saxon.expr.LetExpression.processLeavingTail(LetExpression.java:328)

at net.sf.saxon.instruct.Block.processLeavingTail(Block.java:324)

at net.sf.saxon.instruct.Instruction.process(Instruction.java:90)

at net.sf.saxon.instruct.ForEach.processLeavingTail(ForEach.java:222)

at net.sf.saxon.expr.LetExpression.processLeavingTail(LetExpression.java:328)

at net.sf.saxon.instruct.Choose.processLeavingTail(Choose.java:262)

at net.sf.saxon.instruct.Block.processLeavingTail(Block.java:324)

at net.sf.saxon.instruct.Instruction.process(Instruction.java:90)

at net.sf.saxon.instruct.ElementCreator.processLeavingTail(ElementCreator.java:162)

at net.sf.saxon.instruct.Block.processLeavingTail(Block.java:324)

at net.sf.saxon.expr.LetExpression.processLeavingTail(LetExpression.java:328)

at net.sf.saxon.instruct.Block.processLeavingTail(Block.java:324)

at net.sf.saxon.instruct.Template.expand(Template.java:97)

at net.sf.saxon.instruct.CallTemplate.process(CallTemplate.java:189)

at net.sf.saxon.instruct.CallTemplate.processLeavingTail(CallTemplate.java:214)

at net.sf.saxon.instruct.Block.processLeavingTail(Block.java:324)

at net.sf.saxon.instruct.Instruction.process(Instruction.java:90)

at net.sf.saxon.instruct.ElementCreator.processLeavingTail(ElementCreator.java:162)

at net.sf.saxon.expr.LetExpression.processLeavingTail(LetExpression.java:328)

at net.sf.saxon.instruct.Template.expand(Template.java:97)

at net.sf.saxon.instruct.Template.processLeavingTail(Template.java:80)

at net.sf.saxon.instruct.ApplyTemplates.applyTemplates(ApplyTemplates.java:290)

at net.sf.saxon.instruct.ApplyTemplates.defaultAction(ApplyTemplates.java:325)

at net.sf.saxon.instruct.ApplyTemplates.applyTemplates(ApplyTemplates.java:283)

at net.sf.saxon.Controller.transformDocument(Controller.java:1417)

at net.sf.saxon.Controller.transform(Controller.java:1242)

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

... 39 more

ERROR 2014-09-11 13:55:46,221 [http-bio-80-exec-1015] vxml.VXMLService (clarity:SREDDY8:75052735__4A27A98E-EF28-42F4-B995-B4EEF1A7EEF4:mainnav.work) Exception in processing

com.niku.union.web.WebException: Portlet view processing failed for portlet: projmgr.projectList_odf

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

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

at com.ca.clarity.uif.service.vxml.Evolution3PageProcessor.retrievePage(Evolution3PageProcessor.java:146)

at com.niku.union.web.UIPageProcessor.buildPage(UIPageProcessor.java:89)

at com.ca.clarity.uif.service.vxml.VXMLResponseHandler.processResponse(VXMLResponseHandler.java:168)

at com.ca.clarity.uif.service.vxml.VXMLService.processRequest(VXMLService.java:591)

at com.ca.clarity.uif.UIServlet.service(UIServlet.java:69)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at com.niku.union.web.filter.ClarityContentFilter.doFilter(ClarityContentFilter.java:145)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at com.niku.union.web.filter.GZIPResponseFilter.doFilter(GZIPResponseFilter.java:94)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at com.niku.union.web.filter.CharsetFilter.doFilter(CharsetFilter.java:68)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:88)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)

at com.niku.union.web.valves.ErrorPageRedirectValve.invoke(ErrorPageRedirectValve.java:70)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)

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

Caused by: com.niku.union.web.WebException: com.niku.union.web.WebException: net.sf.saxon.trans.DynamicError: A sequence of more than one item is not allowed as the first argument of string-length()

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

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

[Deactivated User]

You can still do that. The URL is just clearly evident, you have to modify it a little.

[Deactivated User]

See

https://communities.ca.com/message/99959727#99959727

There was another thread created by Lisa Kolin with and example, but don't seem to be able to locate it with the search. Maybe you can.

The point was that an admin with a sense of selfprotection would have these URL precreated for the common list views.

[Robert_Ensinger]

If this is a bad filter, here's my filter fixer.

 

-- use this to find the default filter for the user

select id , name , is_default

from

cmn_attribute_value_sets

where user_id = ( select user_id from srm_resources where unique_name =

'<user id here>' )

and view_code = ( select cast(id as char) from cmn_portlets where

portlet_code = '<portlet ID here>' )

order by id desc

 

-- use this to clear the default

update

cmn_attribute_value_sets

set is_default = 0

where id = <id for default found in above query>

[navzjoshi00]

Thanks for sharing this useful bit

 

NJ

[Jerin Sebastian]

Hi,

You can install a freeware FIDDLER. This is a very easy tool to get the URL.

Open the fiddler and get into  the config in project list page for a 'good' user. Copy the URL and use the same for the 'bad' user. It should take the user directly to the config page and hit RESTORE DEFAULT.

 

Thanks,

Jerin

[Deactivated User]

Are you  saying Fiddler will give you the URL in format you can navigate to? Please educate me.

What I get in v13.3 is

javascript:navigateToURLTarget('modalrefresh','app?action=npt.filterUserLayoutEntry','ui.page.space=mainnav.work','ui.page.template=union.appPage','url=/niku/app?action=mainnav.work&classCode=project','pageId=projmgr.projectList','portletInstanceId=projmgr.projectList_odf','object=project','component=projmgr','id=projmgr.projectList','view_code=projectList','filter_view_code=projectList','isFilter=true')

 

which does not take me anywhere until I do the modifications I describe.

[vtleogal]

Updated : the url setting worked above.. Thank you!!!

 

Thanks everyone. I will look at those suggestions Unfortunately, I am not about to download the freeware.. I am in IT and let's say that would not go over too well

 

Anyway, funny I searched the discussions quite a bit and never saw that post. And, I read a lot of them. Rob, appreciate the input as well. I will spend some time on it today as this user cannot do anything with projects:)

 

Thanks

Lynn

[Anon Anon]

Try this.

 

Log into Clarity as your "OK" user.

 

Go to the Projects page.

Duplicate that tab within the browser/application (i.e. your browser has two "Projects" pages open in the same Clarity session) - lets call them "Tab A" and "Tab B".

 

In "Tab A" select the "Configure" option - the modal popup comes up OK.

 

In "Tab B" logout of Clarity.

In "Tab B" log back into Clarity as your problem user.

 

Back in "Tab A" (which still has the configure window open), click "General"

This will display a System Error in the header (at least it did for me) - lets ignore that for now.

Click "Restore Defaults".

 

Log out of everything and log back in again as the problem user - has that fixed it?

 

(this worked for me in a quick test; in that I could reconfigure the "Projects" layout like this ok (ignoring those System Errors))

 

--

 

EDIT : should have read that thread Martti linked to first; that is a better (easier) answer