In the input CSV-file for one of our Role-collectors, one of the Role-names had a special character in it (ë) that in one way corrupted that role. Now every time this result is loaded (e.g. when opening the containing roleset, when trying to open te role) a request error is given.
How can we resolve this, and what checks can we incorporate in order to prevent this read error?
We're running version 7.0.1.116052, See below the lines that are generated after the error.
"Node","Level","Timestamp","Message",
"...internalcorp.net","ERROR","Monday, December 5, 2016 3:46:20 PM CET","<IP> invalid request: http://url.internalcorp.net/aveksa/main?Oid=41&ReqType=GetPage&ObjectClass=com.aveksa.gui.objects.globalRoleSet.GuiGlobalRoleSet",
"....linux.internalcorp.net","ERROR","Monday, December 5, 2016 3:46:20 PM CET","null
org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2545)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)
at com.aveksa.server.core.globalroleset.GlobalRoleSet.getPendingRoles(GlobalRoleSet.java:467)
at com.aveksa.server.core.globalroleset.GlobalRoleSet.getPendingRoles(GlobalRoleSet.java:451)
at com.aveksa.server.core.globalroleset.GlobalRoleSet.areChangesPendingToBeApplied(GlobalRoleSet.java:559)
at com.aveksa.gui.pages.admin.globalRoleSet.detail.GlobalRoleSetMainPageData.makeButtons(GlobalRoleSetMainPageData.java:76)
at com.aveksa.gui.pages.base.data.PageData.getButtons(PageData.java:268)
at com.aveksa.gui.pages.base.view.MainPageView.printActionButtons(MainPageView.java:1179)
at com.aveksa.gui.pages.base.view.MainPageView.handleRequest(MainPageView.java:263)
at com.aveksa.gui.pages.base.data.PageData.drawView(PageData.java:132)
at com.aveksa.gui.pages.base.data.PageData.handleRequest(PageData.java:114)
at com.aveksa.gui.pages.base.data.main.MainPageData.handleRequest(MainPageData.java:44)
at com.aveksa.gui.pages.admin.globalRoleSet.detail.GlobalRoleSetBasePageData.handleRequest(GlobalRoleSetBasePageData.java:122)
at com.aveksa.gui.pages.admin.globalRoleSet.detail.GlobalRoleSetMainPageData.handleRequest(GlobalRoleSetMainPageData.java:59)
at com.aveksa.gui.pages.PageManager.forwardRequest(PageManager.java:577)
at com.aveksa.gui.pages.PageManager.handleRequest(PageManager.java:402)
at com.aveksa.gui.pages.PageManager.handleRequest(PageManager.java:272)
at com.aveksa.gui.core.MainManager.handleRequest(MainManager.java:179)
at com.aveksa.gui.core.MainManager.doGet(MainManager.java:128)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:575)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1232)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:781)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:480)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
at com.aveksa.gui.core.filters.LoginFilter.doFilter(LoginFilter.java:53)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
at com.aveksa.gui.util.security.XSSFilter.doFilter(XSSFilter.java:20)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:967)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1107)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:940)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)
Caused by:
java.sql.SQLException: Invalid character encountered in
at oracle.sql.CharacterSet.failUTFConversion(CharacterSet.java:2865)
at oracle.sql.CharacterSetAL32UTF8.toString(CharacterSetAL32UTF8.java:186)
at oracle.xdb.XMLType.processString(XMLType.java:3300)
at oracle.xdb.XMLType.processThin(XMLType.java:3425)
at oracle.xdb.XMLType.<init>(XMLType.java:1542)
at oracle.xdb.XMLType.createXML(XMLType.java:927)
at oracle.xdb.XMLType.createXML(XMLType.java:901)
at com.aveksa.server.db.StringToXMLTypeMapper.nullSafeGet(StringToXMLTypeMapper.java:98)
at org.hibernate.type.CustomType.nullSafeGet(CustomType.java:109)
at org.hibernate.type.AbstractType.hydrate(AbstractType.java:104)
at org.hibernate.persister.entity.AbstractEntityPersister.hydrate(AbstractEntityPersister.java:2283)
at org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1527)
at org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1455)
at org.hibernate.loader.Loader.getRow(Loader.java:1355)
at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:611)
at org.hibernate.loader.Loader.doQuery(Loader.java:829)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
... 55 more
",
"....linux.internalcorp.net","ERROR","Monday, December 5, 2016 3:46:20 PM CET","Invalid character encountered in",
"....linux.internalcorp.net","WARN","Monday, December 5, 2016 3:46:20 PM CET","SQL Error: 17055, SQLState: 99999",
Hi Boris,
Does this give you any clue?
Regards,
Justin
Hi,
What version of the product are you using?
Can you share a screenshot of the error? And also aveksaServer.log?