| christian zimmermann 2006-12-08, 7:40 am |
| Hi all,
I have a out of the box installation of WPS 6 with a DB2 and tivoli
directory server. After the database export to DB2 and lookaside=true I get
the following error in my SystemLog.out
Any ideas?
TIA
Christian
08.12.06 10:19:12:060 CET] 00000038 WSMM Message E
com.ibm.ws.wmm.lookaside.db.LookAsideAdapter get(String extId, String
reposId, StringSet attributeNames, String
context) Die folgende SQL-Ausnahmebedingung ist während der Verarbeitung
aufgetreten: "ERROR 42Y03: 'TIMESTAMP' is not recognized as a built-in
function, procedur
e, method alias, or aggregate.
at db2j.de.b.newException(Unknown Source)
at db2j.b.bb._qv(Unknown Source)
at db2j.b.bq._qv(Unknown Source)
at db2j.b.am._qv(Unknown Source)
at db2j.b.ed._je(Unknown Source)
at db2j.b.h._je(Unknown Source)
at db2j.b.bk._je(Unknown Source)
at db2j.b.ch._je(Unknown Source)
at db2j.b.bk._je(Unknown Source)
at db2j.b.ch._je(Unknown Source)
at db2j.b.bk._je(Unknown Source)
at db2j.b.ch._je(Unknown Source)
at db2j.b.bk._je(Unknown Source)
at db2j.b.ch._je(Unknown Source)
at db2j.b.bk._je(Unknown Source)
at db2j.b.ch._je(Unknown Source)
at db2j.b.dt._je(Unknown Source)
at db2j.b.dt._zm(Unknown Source)
at db2j.b.p._zm(Unknown Source)
at db2j.b.dj._zm(Unknown Source)
at db2j.bo.c._ll(Unknown Source)
at db2j.bo.c.prepare(Unknown Source)
at db2j.bn.f.prepareInternalStatement(Unknown Source)
at db2j.ai.p.<init>(Unknown Source)
at db2j.ax.e.<init>(Unknown Source)
at db2j.aw.b.<init>(Unknown Source)
at
com.ibm.db2j.jdbc.EmbeddedDriver30.newLocalPreparedStatement(Unknown
Source)
at db2j.ai.c._wd(Unknown Source)
at db2j.ai.c.prepareStatement(Unknown Source)
at db2j.bh.b.prepareStatement(Unknown Source)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.pmiPrepareStatement(WSJdbcConnection.java(Compiled
Code))
at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java(Compiled
Code))
at
com.ibm.ws.wmm.lookaside.db.LookAsideAdapter. retrieveAllAttributesForMember(LookAside
Adapter.java:4216)
at
com.ibm.ws.wmm.lookaside.db.LookAsideAdapter.get(LookAsideAdapter.java:1147)
at
com.ibm.ws.wmm.MemberRepositoryManager.getMember(MemberRepositoryManager.java:3406)
at
com.ibm.ws.wmm.MemberRepositoryManager.getMember(MemberRepositoryManager.java:3192)
at
com.ibm.ws.wmm.objectimpl.MemberServiceBeanBase.getMember(MemberServiceBeanBase.java:583)
at
com.ibm.websphere.wmm.objects. EJSRemoteStatelessMemberService_14d751a3
.getMember(Unknown
Source)
at
com.ibm.websphere.wmm.objects._MemberService_Stub.getMember(_MemberService_Stub.java:855)
at
com.ibm.wps.services.puma.SystemWMMAccessBean$31.run(SystemWMMAccessBean.java:711)
at
com.ibm.ws.security.auth.distContextManagerImpl.runAs(distContextManagerImpl.java:2782)
at
com.ibm.ws.security.auth.distContextManagerImpl.runAsSystem(distContextManagerImpl.java:2659)
at
com.ibm.wps.services.puma.SystemWMMAccessBean.getMember(SystemWMMAccessBean.java:717)
at
com.ibm.wps.services.puma.DefaultURManager.fetch(DefaultURManager.java:2149)
at
com.ibm.wps.services.puma.AbstractURManager.fetch(AbstractURManager.java:1310)
at
com.ibm.wps.services.puma.PumaServiceImpl.fetch(PumaServiceImpl.java:397)
at com.ibm.wps.puma.User.put(User.java:1138)
at com.ibm.wps.puma.User$14.run(User.java:1506)
at java.security.AccessController.doPrivileged1(Native Method)
at
java.security.AccessController.doPrivileged(AccessController.java(Compiled
Code))
at com.ibm.wps.puma.User.setAttribute(User.java:1515)
at
com.lotus.cs.services.platformdata.portal.PortalUser.setAttribute(PortalUser.java:356)
at
com.lotus.cs.services.sametime.serverapp.STUtil.getSTToken(STUtil.java:251)
at
com.lotus.cs.services.sametime.serverapp.STUtil.getSTUserInfo(STUtil.java:148)
at
com.lotus.cs.services.people.tags.PeopleInitTag.getSTUserInfo(PeopleInitTag.java:251)
at
com.lotus.cs.services.people.tags.PeopleInitTag.writeOutSTLinksFunctions(PeopleInitTag.java:286)
at
com.lotus.cs.services.people.tags.PeopleInitTag.doStartTag(PeopleInitTag.java:170)
at com.ibm._jsp._Default._jspx_meth_pa_peopleinit_
(_Default.java:2751)
at com.ibm._jsp._Default._jspService(_Default.java:556)
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:91)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1239)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:113)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:82)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:670)
at
com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:117)
at
com.ibm.ws.jsp.webcontainerext.JSPExtensionServletWrapper. handleRequest(JSPExtensionServletWrapper
.java:178)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.include(WebAppRequestDispatcher.java:613)
at
com.ibm.wps.services.dispatcher.DispatcherServiceImpl.handleRequest(DispatcherServiceImpl.java:87)
at
com.ibm.wps.services.dispatcher.DispatcherServiceImpl.include(DispatcherServiceImpl.java:52)
at
com.ibm.wps.services.dispatcher.Dispatcher.include(Dispatcher.java:45)
at
com.ibm.wps.engine.templates.themes.Default.render(Default.java:142)
at
com.ibm.wps.engine.templates.ThemeTemplate.render(ThemeTemplate.java:67)
at
com.ibm.wps.engine.phases.WPRenderPhase.processRendering(WPRenderPhase.java:322)
at
com.ibm.wps.engine.phases.WPRenderPhase.execute(WPRenderPhase.java:137)
at
com.ibm.wps.state.phases.AbstractRenderPhase.next(AbstractRenderPhase.java:106)
at
com.ibm.wps.engine.phases.WPAbstractRenderPhase.next(WPAbstractRenderPhase.java:93)
at com.ibm.wps.engine.Servlet.callPortal(Servlet.java:791)
at com.ibm.wps.engine.Servlet.doGet(Servlet.java:629)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1239)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:136)
at
com.ibm.wps.state.filter.StateCleanup.doFilter(StateCleanup.java:86)
at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:142)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:121)
at
com.ibm.wps.mappingurl.impl.URLAnalyzer.doFilter(URLAnalyzer.java:257)
at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:142)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:121)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:82)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:670)
at
com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:89)
at
com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1897)
at
com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411)
at
com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:101)
at
com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:566)
at
com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:619)
at
com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:952)
at
com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1039)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled
Code))
".
[08.12.06 10:19:12:094 CET] 00000038 User E com.ibm.wps.puma.User
setAttribute <Null Message>
com.ibm.wps.util.DataBackendException:
EJPSG0015E: Fehler bei Datenausgabe -
com.ibm.websphere.wmm.exception.WMMSystemException: Di
e folgende SQL-Ausnahmebedingung ist während der Verarbeitung aufgetreten:
"{0}".
at
com.ibm.wps.services.puma.DefaultURManager.fetch(DefaultURManager.java:2182)
at
com.ibm.wps.services.puma.AbstractURManager.fetch(AbstractURManager.java:1310)
at
com.ibm.wps.services.puma.PumaServiceImpl.fetch(PumaServiceImpl.java:397)
at com.ibm.wps.puma.User.put(User.java:1138)
at com.ibm.wps.puma.User$14.run(User.java:1506)
at java.security.AccessController.doPrivileged1(Native Method)
at
java.security.AccessController.doPrivileged(AccessController.java(Compiled
Code))
at com.ibm.wps.puma.User.setAttribute(User.java:1515)
at
com.lotus.cs.services.platformdata.portal.PortalUser.setAttribute(PortalUser.java:356)
at
com.lotus.cs.services.sametime.serverapp.STUtil.getSTToken(STUtil.java:251)
at
com.lotus.cs.services.sametime.serverapp.STUtil.getSTUserInfo(STUtil.java:148)
at
com.lotus.cs.services.people.tags.PeopleInitTag.getSTUserInfo(PeopleInitTag.java:251)
at
com.lotus.cs.services.people.tags.PeopleInitTag.writeOutSTLinksFunctions(PeopleInitTag.java:286)
at
com.lotus.cs.services.people.tags.PeopleInitTag.doStartTag(PeopleInitTag.java:170)
at com.ibm._jsp._Default._jspx_meth_pa_peopleinit_
(_Default.java:2751)
at com.ibm._jsp._Default._jspService(_Default.java:556)
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:91)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1239)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:113)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:82)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:670)
at
com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:117)
at
com.ibm.ws.jsp.webcontainerext.JSPExtensionServletWrapper. handleRequest(JSPExtensionServletWrapper
.java:178)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.include(WebAppRequestDispatcher.java:613)
at
com.ibm.wps.services.dispatcher.DispatcherServiceImpl.handleRequest(DispatcherServiceImpl.java:87)
at
com.ibm.wps.services.dispatcher.DispatcherServiceImpl.include(DispatcherServiceImpl.java:52)
at
com.ibm.wps.services.dispatcher.Dispatcher.include(Dispatcher.java:45)
at
com.ibm.wps.engine.templates.themes.Default.render(Default.java:142)
at
com.ibm.wps.engine.templates.ThemeTemplate.render(ThemeTemplate.java:67)
at
com.ibm.wps.engine.phases.WPRenderPhase.processRendering(WPRenderPhase.java:322)
at
com.ibm.wps.engine.phases.WPRenderPhase.execute(WPRenderPhase.java:137)
at
com.ibm.wps.state.phases.AbstractRenderPhase.next(AbstractRenderPhase.java:106)
at
com.ibm.wps.engine.phases.WPAbstractRenderPhase.next(WPAbstractRenderPhase.java:93)
at com.ibm.wps.engine.Servlet.callPortal(Servlet.java:791)
at com.ibm.wps.engine.Servlet.doGet(Servlet.java:629)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1282)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1239)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:136)
at
com.ibm.wps.state.filter.StateCleanup.doFilter(StateCleanup.java:86)
at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:142)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:121)
at
com.ibm.wps.mappingurl.impl.URLAnalyzer.doFilter(URLAnalyzer.java:257)
at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:142)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:121)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:82)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:670)
at
com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:89)
at
com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1897)
at
com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:84)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411)
at
com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:101)
at
com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:566)
at
com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:619)
at
com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:952)
at
com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1039)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled
Code))
Caused by: com.ibm.websphere.wmm.exception.WMMSystemException: Die folgende
SQL-Ausnahmebedingung ist während der Verarbeitung aufgetreten: "{0}".
at
com.ibm.ws.wmm.lookaside.db.LookAsideAdapter.get(LookAsideAdapter.java:1398)
at
com.ibm.ws.wmm.MemberRepositoryManager.getMember(MemberRepositoryManager.java:3406)
at
com.ibm.ws.wmm.MemberRepositoryManager.getMember(MemberRepositoryManager.java:3192)
at
com.ibm.ws.wmm.objectimpl.MemberServiceBeanBase.getMember(MemberServiceBeanBase.java:583)
at
com.ibm.websphere.wmm.objects. EJSRemoteStatelessMemberService_14d751a3
.getMember(Unknown
Source)
at
com.ibm.websphere.wmm.objects._MemberService_Stub.getMember(_MemberService_Stub.java:855)
at
com.ibm.wps.services.puma.SystemWMMAccessBean$31.run(SystemWMMAccessBean.java:711)
at
com.ibm.ws.security.auth.distContextManagerImpl.runAs(distContextManagerImpl.java:2782)
at
com.ibm.ws.security.auth.distContextManagerImpl.runAsSystem(distContextManagerImpl.java:2659)
at
com.ibm.wps.services.puma.SystemWMMAccessBean.getMember(SystemWMMAccessBean.java:717)
at
com.ibm.wps.services.puma.DefaultURManager.fetch(DefaultURManager.java:2149)
... 60 more
Caused by: SQL Exception: 'TIMESTAMP' is not recognized as a built-in
function, procedure, method alias, or aggregate.
at db2j.ai.j.generateCsSQLException(Unknown Source)
at db2j.ai.g.wrapInSQLException(Unknown Source)
at db2j.ai.g.handleException(Unknown Source)
at db2j.ai.c.handleException(Unknown Source)
at db2j.ai.e.handleException(Unknown Source)
at db2j.ai.p.<init>(Unknown Source)
at db2j.ax.e.<init>(Unknown Source)
at db2j.aw.b.<init>(Unknown Source)
at
com.ibm.db2j.jdbc.EmbeddedDriver30.newLocalPreparedStatement(Unknown
Source)
at db2j.ai.c._wd(Unknown Source)
at db2j.ai.c.prepareStatement(Unknown Source)
at db2j.bh.b.prepareStatement(Unknown Source)
at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.pmiPrepareStatement(WSJdbcConnection.java(Compiled
Code))
at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java(Compiled
Code))
at
com.ibm.ws.wmm.lookaside.db.LookAsideAdapter. retrieveAllAttributesForMember(LookAside
Adapter.java:4216)
at
com.ibm.ws.wmm.lookaside.db.LookAsideAdapter.get(LookAsideAdapter.java:1147)
... 70 more
|