TomConnery

Can't Login to NSA

Discussion created by TomConnery on Jun 11, 2010
Hey, guys and gals... I'm sure I messed something up, but what... I just recently setup a new test environment using Tomcat and Clarity.
The install of Clarity finished but I can't log into the NSA. I know the password was set to default 'admin'. Please examine the log below and advise. Hopefully this is a simple one. Thanks

SYS 2010-06-11 16:27:57,010 [main] niku.union (none:none:none) Destroying: tower...
SYS 2010-06-11 16:28:02,869 [main] niku.union (none:none:none) Destroying: nsa...
SYS 2010-06-11 16:28:02,869 [main] niku.union (none:none:none) Destroying: wmd-init...
SYS 2010-06-11 16:29:08,737 [main] niku.union (none:none:none) Clarity 8.1.0.03.4373 initializing...
SYS 2010-06-11 16:29:10,112 [main] niku.union (none:none:none) Initializing: tower...
SYS 2010-06-11 16:29:12,580 [main] niku.union (none:none:none) Initializing: nsa...
SYS 2010-06-11 16:29:12,689 [main] niku.union (none:none:none) Initializing: wmd-init...
SYS 2010-06-11 16:29:14,189 [main] niku.union (none:none:none) Clarity 8.1.0.03.4373 ready.
ERROR 2010-06-11 16:29:14,236 [main] core.StandardContext (none:none:none) Error starting static Resources
java.lang.IllegalArgumentException: Document base D:\niku\clarity\acweb does not exist or is not a readable directory

at org.apache.naming.resources.FileDirContext.setDocBase(FileDirContext.java:141)

at org.apache.catalina.core.StandardContext.resourcesStart(StandardContext.java:3895)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4064)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)

at org.apache.catalina.core.StandardService.start(StandardService.java:448)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)

at org.apache.catalina.startup.Catalina.start(Catalina.java:552)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
ERROR 2010-06-11 16:29:14,252 [main] core.StandardContext (none:none:none) Error in resourceStart()
ERROR 2010-06-11 16:29:14,252 [main] core.StandardContext (none:none:none) Error getConfigured
ERROR 2010-06-11 16:29:14,252 [main] core.StandardContext (none:none:none) Context [acweb] startup failed due to previous errors
ERROR 2010-06-11 16:30:29,041 [http-8090-Processor4] niku.xql2 (sa:Tx8hUh0POqsDVL88X9ccHzjO8eIDrIFgHK5zgA7P4Q8=:security.loginAction) Internal Processing exception
com.niku.union.persistence.PersistenceException:
SQL error code: 208
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid object name 'CMN_SEC_USERS'.
SQL error code: 8180
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
Executed:
update CMN_SEC_USERS set LAST_LOGGED_IN_DATE = ? where user_name = ?
Derived from statement:
<?xml version="1.0" encoding="UTF-8"?>
<statement 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 CMN_SEC_USERS set LAST_LOGGED_IN_DATE = ? where user_name = ?
</text>
<param replace="timestamp" direction="IN" expressionListDelimiter=","/>
<param name="user_name" type="string" direction="IN" expressionListDelimiter=","/>
</sql>
</statement>

Referenced by:
<?xml version="1.0" encoding="UTF-8"?>
<statementRef id="security.updateLoginDetails_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:
{user_name=sa}


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

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

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

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

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

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

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

at com.niku.security.handlers.LoginHandler.executeStatement(LoginHandler.java:199)

at com.niku.security.handlers.LoginHandler.postProcess(LoginHandler.java:126)

at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1355)

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.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:239)

at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:280)

at com.niku.xql2.binding.ServiceControlBindingXql.processFile(ServiceControlBindingXql.java:393)

at com.niku.xql2.binding.ServiceControlBindingXql.getDocument(ServiceControlBindingXql.java:258)

at com.niku.xql2.binding.ServiceControlBindingXql.processRequest(ServiceControlBindingXql.java:142)

at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:759)

at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:213)

at com.niku.union.web.WebServiceAdapter.processRequest(WebServiceAdapter.java:188)

at com.niku.union.web.PortletController.processServiceRequest(PortletController.java:1322)

at com.niku.union.web.PortletController.processProcessActionRequest(PortletController.java:229)

at com.niku.union.web.PortletController.processRequest(PortletController.java:156)

at com.niku.union.web.WebActionController.processAction(WebActionController.java:1087)

at com.niku.union.web.WebActionController.processRequest(WebActionController.java:170)

at com.niku.union.web.WebControlServlet.service(WebControlServlet.java:319)

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

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

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

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

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

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

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

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

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

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

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

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

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)

at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:500)

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

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

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:873)

at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)

at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)

at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)

at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)

at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid object name 'CMN_SEC_USERS'.

at com.ca.clarity.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.ca.clarity.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.ca.clarity.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)

at com.ca.clarity.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)

at com.ca.clarity.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)

at com.ca.clarity.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

at com.ca.clarity.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)

at com.ca.clarity.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)

at com.ca.clarity.jdbc.base.BaseStatement.postImplExecute(Unknown Source)

at com.ca.clarity.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)

at com.ca.clarity.jdbc.base.BaseStatement.commonExecute(Unknown Source)

at com.ca.clarity.jdbc.base.BaseStatement.executeInternal(Unknown Source)

at com.ca.clarity.jdbc.base.BasePreparedStatement.execute(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:68)

at org.logicalcobwebs.cglib.proxy.Proxy$ProxyImpl$$EnhancerByCGLIB$$639a9874.execute(<generated>)

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

... 48 more

Outcomes