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.(Unknown Source)
at db2j.ax.e.(Unknown Source)
at db2j.aw.b.(Unknown Source)
at
com.ibm.db2j.jdbc.EmbeddedDriver30.newLocalPrepare dStatement(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.pmiPrep areStatement(WSJdbcConnection.java(Compiled
Code))
at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepare Statement(WSJdbcConnection.java(Compiled
Code))
at
com.ibm.ws.wmm.lookaside.db.LookAsideAdapter.retri eveAllAttributesForMember(LookAsideAdapter.java:42 16)
at
com.ibm.ws.wmm.lookaside.db.LookAsideAdapter.get(L ookAsideAdapter.java:1147)
at
com.ibm.ws.wmm.MemberRepositoryManager.getMember(M emberRepositoryManager.java:3406)
at
com.ibm.ws.wmm.MemberRepositoryManager.getMember(M emberRepositoryManager.java:3192)
at
com.ibm.ws.wmm.objectimpl.MemberServiceBeanBase.ge tMember(MemberServiceBeanBase.java:583)
at
com.ibm.websphere.wmm.objects.EJSRemoteStatelessMe mberService_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.r un(SystemWMMAccessBean.java:711)
at
com.ibm.ws.security.auth.distContextManagerImpl.ru nAs(distContextManagerImpl.java:2782)
at
com.ibm.ws.security.auth.distContextManagerImpl.ru nAsSystem(distContextManagerImpl.java:2659)
at
com.ibm.wps.services.puma.SystemWMMAccessBean.getM ember(SystemWMMAccessBean.java:717)
at
com.ibm.wps.services.puma.DefaultURManager.fetch(D efaultURManager.java:2149)
at
com.ibm.wps.services.puma.AbstractURManager.fetch( AbstractURManager.java:1310)
at
com.ibm.wps.services.puma.PumaServiceImpl.fetch(Pu maServiceImpl.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(Nativ e Method)
at
java.security.AccessController.doPrivileged(Access Controller.java(Compiled
Code))
at com.ibm.wps.puma.User.setAttribute(User.java:1515)
at
com.lotus.cs.services.platformdata.portal.PortalUs er.setAttribute(PortalUser.java:356)
at
com.lotus.cs.services.sametime.serverapp.STUtil.ge tSTToken(STUtil.java:251)
at
com.lotus.cs.services.sametime.serverapp.STUtil.ge tSTUserInfo(STUtil.java:148)
at
com.lotus.cs.services.people.tags.PeopleInitTag.ge tSTUserInfo(PeopleInitTag.java:251)
at
com.lotus.cs.services.people.tags.PeopleInitTag.wr iteOutSTLinksFunctions(PeopleInitTag.java:286)
at
com.lotus.cs.services.people.tags.PeopleInitTag.do StartTag(PeopleInitTag.java:170)
at com.ibm._jsp._Default._jspx_meth_pa_peopleinit_
(_Default.java:2751)
at com.ibm._jsp._Default._jspService(_Default.java:55 6)
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJsp Base.java:91)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.ser vice(ServletWrapper.java:1282)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.ser vice(ServletWrapper.java:1239)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.d oFilter(WebAppFilterChain.java:113)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain._ doFilter(WebAppFilterChain.java:82)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.han dleRequest(ServletWrapper.java:670)
at
com.ibm.wsspi.webcontainer.servlet.GenericServletW rapper.handleRequest(GenericServletWrapper.java:11 7)
at
com.ibm.ws.jsp.webcontainerext.JSPExtensionServlet Wrapper.handleRequest(JSPExtensionServletWrapper.j ava:178)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.include(WebAppRequestDispatcher.java:613)
at
com.ibm.wps.services.dispatcher.DispatcherServiceI mpl.handleRequest(DispatcherServiceImpl.java:87)
at
com.ibm.wps.services.dispatcher.DispatcherServiceI mpl.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.processRen dering(WPRenderPhase.java:322)
at
com.ibm.wps.engine.phases.WPRenderPhase.execute(WP RenderPhase.java:137)
at
com.ibm.wps.state.phases.AbstractRenderPhase.next( AbstractRenderPhase.java:106)
at
com.ibm.wps.engine.phases.WPAbstractRenderPhase.ne xt(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.ser vice(ServletWrapper.java:1282)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.ser vice(ServletWrapper.java:1239)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.d oFilter(WebAppFilterChain.java:136)
at
com.ibm.wps.state.filter.StateCleanup.doFilter(Sta teCleanup.java:86)
at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapp er.doFilter(FilterInstanceWrapper.java:142)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.d oFilter(WebAppFilterChain.java:121)
at
com.ibm.wps.mappingurl.impl.URLAnalyzer.doFilter(U RLAnalyzer.java:257)
at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapp er.doFilter(FilterInstanceWrapper.java:142)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.d oFilter(WebAppFilterChain.java:121)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain._ doFilter(WebAppFilterChain.java:82)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.han dleRequest(ServletWrapper.java:670)
at
com.ibm.ws.webcontainer.servlet.CacheServletWrappe r.handleRequest(CacheServletWrapper.java:89)
at
com.ibm.ws.webcontainer.WebContainer.handleRequest (WebContainer.java:1897)
at
com.ibm.ws.webcontainer.channel.WCChannelLink.read y(WCChannelLink.java:84)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLi nk.handleDiscrimination(HttpInboundLink.java:472)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLi nk.handleNewInformation(HttpInboundLink.java:411)
at
com.ibm.ws.http.channel.inbound.impl.HttpICLReadCa llback.complete(HttpICLReadCallback.java:101)
at
com.ibm.ws.tcp.channel.impl.WorkQueueManager.reque stComplete(WorkQueueManager.java:566)
at
com.ibm.ws.tcp.channel.impl.WorkQueueManager.attem ptIO(WorkQueueManager.java:619)
at
com.ibm.ws.tcp.channel.impl.WorkQueueManager.worke rRun(WorkQueueManager.java:952)
at
com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worke r.run(WorkQueueManager.java:1039)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava(Compiled
Code))
".
[08.12.06 10:19:12:094 CET] 00000038 User E com.ibm.wps.puma.User
setAttribute
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(D efaultURManager.java:2182)
at
com.ibm.wps.services.puma.AbstractURManager.fetch( AbstractURManager.java:1310)
at
com.ibm.wps.services.puma.PumaServiceImpl.fetch(Pu maServiceImpl.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(Nativ e Method)
at
java.security.AccessController.doPrivileged(Access Controller.java(Compiled
Code))
at com.ibm.wps.puma.User.setAttribute(User.java:1515)
at
com.lotus.cs.services.platformdata.portal.PortalUs er.setAttribute(PortalUser.java:356)
at
com.lotus.cs.services.sametime.serverapp.STUtil.ge tSTToken(STUtil.java:251)
at
com.lotus.cs.services.sametime.serverapp.STUtil.ge tSTUserInfo(STUtil.java:148)
at
com.lotus.cs.services.people.tags.PeopleInitTag.ge tSTUserInfo(PeopleInitTag.java:251)
at
com.lotus.cs.services.people.tags.PeopleInitTag.wr iteOutSTLinksFunctions(PeopleInitTag.java:286)
at
com.lotus.cs.services.people.tags.PeopleInitTag.do StartTag(PeopleInitTag.java:170)
at com.ibm._jsp._Default._jspx_meth_pa_peopleinit_
(_Default.java:2751)
at com.ibm._jsp._Default._jspService(_Default.java:55 6)
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJsp Base.java:91)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:856)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.ser vice(ServletWrapper.java:1282)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.ser vice(ServletWrapper.java:1239)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.d oFilter(WebAppFilterChain.java:113)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain._ doFilter(WebAppFilterChain.java:82)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.han dleRequest(ServletWrapper.java:670)
at
com.ibm.wsspi.webcontainer.servlet.GenericServletW rapper.handleRequest(GenericServletWrapper.java:11 7)
at
com.ibm.ws.jsp.webcontainerext.JSPExtensionServlet Wrapper.handleRequest(JSPExtensionServletWrapper.j ava:178)
at
com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.include(WebAppRequestDispatcher.java:613)
at
com.ibm.wps.services.dispatcher.DispatcherServiceI mpl.handleRequest(DispatcherServiceImpl.java:87)
at
com.ibm.wps.services.dispatcher.DispatcherServiceI mpl.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.processRen dering(WPRenderPhase.java:322)
at
com.ibm.wps.engine.phases.WPRenderPhase.execute(WP RenderPhase.java:137)
at
com.ibm.wps.state.phases.AbstractRenderPhase.next( AbstractRenderPhase.java:106)
at
com.ibm.wps.engine.phases.WPAbstractRenderPhase.ne xt(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.ser vice(ServletWrapper.java:1282)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.ser vice(ServletWrapper.java:1239)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.d oFilter(WebAppFilterChain.java:136)
at
com.ibm.wps.state.filter.StateCleanup.doFilter(Sta teCleanup.java:86)
at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapp er.doFilter(FilterInstanceWrapper.java:142)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.d oFilter(WebAppFilterChain.java:121)
at
com.ibm.wps.mappingurl.impl.URLAnalyzer.doFilter(U RLAnalyzer.java:257)
at
com.ibm.ws.webcontainer.filter.FilterInstanceWrapp er.doFilter(FilterInstanceWrapper.java:142)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain.d oFilter(WebAppFilterChain.java:121)
at
com.ibm.ws.webcontainer.filter.WebAppFilterChain._ doFilter(WebAppFilterChain.java:82)
at
com.ibm.ws.webcontainer.servlet.ServletWrapper.han dleRequest(ServletWrapper.java:670)
at
com.ibm.ws.webcontainer.servlet.CacheServletWrappe r.handleRequest(CacheServletWrapper.java:89)
at
com.ibm.ws.webcontainer.WebContainer.handleRequest (WebContainer.java:1897)
at
com.ibm.ws.webcontainer.channel.WCChannelLink.read y(WCChannelLink.java:84)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLi nk.handleDiscrimination(HttpInboundLink.java:472)
at
com.ibm.ws.http.channel.inbound.impl.HttpInboundLi nk.handleNewInformation(HttpInboundLink.java:411)
at
com.ibm.ws.http.channel.inbound.impl.HttpICLReadCa llback.complete(HttpICLReadCallback.java:101)
at
com.ibm.ws.tcp.channel.impl.WorkQueueManager.reque stComplete(WorkQueueManager.java:566)
at
com.ibm.ws.tcp.channel.impl.WorkQueueManager.attem ptIO(WorkQueueManager.java:619)
at
com.ibm.ws.tcp.channel.impl.WorkQueueManager.worke rRun(WorkQueueManager.java:952)
at
com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worke r.run(WorkQueueManager.java:1039)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava(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(L ookAsideAdapter.java:1398)
at
com.ibm.ws.wmm.MemberRepositoryManager.getMember(M emberRepositoryManager.java:3406)
at
com.ibm.ws.wmm.MemberRepositoryManager.getMember(M emberRepositoryManager.java:3192)
at
com.ibm.ws.wmm.objectimpl.MemberServiceBeanBase.ge tMember(MemberServiceBeanBase.java:583)
at
com.ibm.websphere.wmm.objects.EJSRemoteStatelessMe mberService_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.r un(SystemWMMAccessBean.java:711)
at
com.ibm.ws.security.auth.distContextManagerImpl.ru nAs(distContextManagerImpl.java:2782)
at
com.ibm.ws.security.auth.distContextManagerImpl.ru nAsSystem(distContextManagerImpl.java:2659)
at
com.ibm.wps.services.puma.SystemWMMAccessBean.getM ember(SystemWMMAccessBean.java:717)
at
com.ibm.wps.services.puma.DefaultURManager.fetch(D efaultURManager.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.(Unknown Source)
at db2j.ax.e.(Unknown Source)
at db2j.aw.b.(Unknown Source)
at
com.ibm.db2j.jdbc.EmbeddedDriver30.newLocalPrepare dStatement(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.pmiPrep areStatement(WSJdbcConnection.java(Compiled
Code))
at
com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepare Statement(WSJdbcConnection.java(Compiled
Code))
at
com.ibm.ws.wmm.lookaside.db.LookAsideAdapter.retri eveAllAttributesForMember(LookAsideAdapter.java:42 16)
at
com.ibm.ws.wmm.lookaside.db.LookAsideAdapter.get(L ookAsideAdapter.java:1147)
... 70 more