2 Replies Latest reply: Mar 11, 2013 6:35 AM by Haifeng Hu RSS

Trex exception attribute value is not a number

Vaishnavi PE
Currently Being Moderated

Hi,

 

In one of the applications on the portal (which is on NW 7.3), we are using Trex and when we try to search for anything, it gives the following exception:

 

com.sapportals.trex.TrexException: attribute value is not a number;index=dealerinventorytrader_index,location=epdidc02:30203 (Errorcode 6930)

 

I am not familiar with KM and Trex and am trying to find out what is causing the issue. I have checked the status of the index in the system administration and it shows green. Also, in the queue status, it shows idle for this index.

 

Thanks & Regards,

Vaishnavi

  • Re: Trex exception attribute value is not a number
    Vaishnavi PE
    Currently Being Moderated

    Hi,

     

    Moreover, the search is successful when i give a search string with an an asterisk. For example 'class', 'TE' etc. Without the asterisk, the error is as below. Can someone tell me why is it that it would work only with as asterisk?

     

    In the logs and traces, I find the following:

     

    Error on filling search event - Error during search occurred - com.sapportals.wcm.WcmException: com.sapportals.trex.TrexException: attribute value is not a number;index=dealerinventorytrader_index,location=npqidc01:30203 (Errorcode 6930) - com.sapportals.wcm.control.base.CommonSearchException: Error during search occurred - com.sapportals.wcm.WcmException: com.sapportals.trex.TrexException: attribute value is not a number;index=dealerinventorytrader_index,location=npqidc01:30203 (Errorcode 6930)

    at com.sapportals.wcm.control.util.search.SearchSessionBuilder.doSearchWithSession(SearchSessionBuilder.java:1527)

    at com.sapportals.wcm.control.util.search.SearchSessionBuilder.buildSearchSession(SearchSessionBuilder.java:688)

    at com.sapportals.wcm.control.util.search.SearchSessionBuilder.buildSearchSession(SearchSessionBuilder.java:669)

    at com.sapportals.wcm.control.search.SearchDialogControl.executeSearch(SearchDialogControl.java:1461)

    at com.sapportals.wcm.control.search.SearchDialogControl.onSearch(SearchDialogControl.java:1130)

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

    at com.sapportals.wdf.stack.Control.dispatchHtmlbEvent(Control.java:386)

    at com.sapportals.wdf.WdfEventDispatcher.dispatch(WdfEventDispatcher.java:176)

    at com.sapportals.wdf.WdfCompositeController.onWdfEvent(WdfCompositeController.java:549)

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

    at com.sapportals.htmlb.page.DynPage.doProcessCompositeEvent(DynPage.java:205)

    at com.sapportals.htmlb.page.DynPage.doProcessCurrentEvent(DynPage.java:143)

    at com.sapportals.htmlb.page.PageProcessor.handleRequest(PageProcessor.java:106)

    at com.sapportals.portal.htmlb.page.PageProcessorComponent.doContent(PageProcessorComponent.java:134)

    at com.sapportals.wcm.portal.component.base.ControllerComponent.doContent(ControllerComponent.java:87)

    at com.sapportals.portal.prt.component.AbstractPortalComponent.serviceDeprecated(AbstractPortalComponent.java:205)

    at com.sapportals.portal.prt.component.AbstractPortalComponent.service(AbstractPortalComponent.java:121)

    at com.sap.portal.prt.core.RequestDispatcherFactory$PortalComponentRequestDispatcher$5.service(RequestDispatcherFactory.java:308)

    at com.sap.engine.services.servlets_jsp.server.deploy.impl.module.IRequestDispatcherImpl.dispatch(IRequestDispatcherImpl.java:270)

    at com.sap.portal.prt.core.RequestDispatcherFactory$PortalComponentRequestDispatcher.service(RequestDispatcherFactory.java:298)

    at com.sap.portal.prt.core.PortalRequestManager.callPortalComponent(PortalRequestManager.java:229)

    at com.sap.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:107)

    at com.sap.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:141)

    at com.sap.portal.prt.component.PortalComponentResponse.include(PortalComponentResponse.java:206)

    at com.sap.portal.prt.pom.PortalNode.service(PortalNode.java:588)

    at com.sap.portal.prt.core.PortalRequestManager.callPortalComponent(PortalRequestManager.java:233)

    at com.sap.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:107)

    at com.sap.portal.prt.core.PortalRequestManager.dispatchRequest(PortalRequestManager.java:141)

    at com.sap.portal.prt.core.PortalRequestManager.runRequestCycle(PortalRequestManager.java:520)

    at com.sapportals.portal.prt.connection.ServletConnection.handleRequest(ServletConnection.java:203)

    at com.sap.portal.prt.dispatcher.DispatcherServlet.service(DispatcherServlet.java:132)

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

    at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.runServlet(FilterChainImpl.java:202)

    at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.doFilter(FilterChainImpl.java:103)

    at com.sap.portal.http.EnrichNavRequestFilter.doFilter(EnrichNavRequestFilter.java:49)

    at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.doFilter(FilterChainImpl.java:79)

    at com.sap.portal.http.EnrichNavRequestFilter.doFilter(EnrichNavRequestFilter.java:49)

    at com.sap.engine.services.servlets_jsp.server.runtime.FilterChainImpl.doFilter(FilterChainImpl.java:79)

    at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:432)

    at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:210)

    at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:441)

    at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:430)

    at com.sap.engine.services.servlets_jsp.filters.DSRWebContainerFilter.process(DSRWebContainerFilter.java:38)

    at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

    at com.sap.engine.services.servlets_jsp.filters.ServletSelector.process(ServletSelector.java:81)

    at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

    at com.sap.engine.services.servlets_jsp.filters.ApplicationSelector.process(ApplicationSelector.java:276)

    at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

    at com.sap.engine.services.httpserver.filters.WebContainerInvoker.process(WebContainerInvoker.java:81)

    at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)

    at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

    at com.sap.engine.services.httpserver.filters.ResponseLogWriter.process(ResponseLogWriter.java:60)

    at com.sap.engine.services.httpserver.chain.HostFilter.process(HostFilter.java:9)

    at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

    at com.sap.engine.services.httpserver.filters.DefineHostFilter.process(DefineHostFilter.java:27)

    at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

    at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

    at com.sap.engine.services.httpserver.filters.MonitoringFilter.process(MonitoringFilter.java:29)

    at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

    at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

    at com.sap.engine.services.httpserver.filters.SessionSizeFilter.process(SessionSizeFilter.java:26)

    at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

    at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

    at com.sap.engine.services.httpserver.filters.MemoryStatisticFilter.process(MemoryStatisticFilter.java:57)

    at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

    at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

    at com.sap.engine.services.httpserver.filters.DSRHttpFilter.process(DSRHttpFilter.java:43)

    at com.sap.engine.services.httpserver.chain.ServerFilter.process(ServerFilter.java:12)

    at com.sap.engine.services.httpserver.chain.AbstractChain.process(AbstractChain.java:78)

    at com.sap.engine.services.httpserver.server.Processor.chainedRequest(Processor.java:475)

    at com.sap.engine.services.httpserver.server.Processor$FCAProcessorThread.process(Processor.java:269)

    at com.sap.engine.services.httpserver.server.rcm.RequestProcessorThread.run(RequestProcessorThread.java:56)

    at com.sap.engine.core.thread.execution.Executable.run(Executable.java:122)

    at com.sap.engine.core.thread.execution.Executable.run(Executable.java:101)

    at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:328)

     

    Thanks & Regards,

    Vaishnavi

  • Re: Trex exception attribute value is not a number
    Haifeng Hu
    Currently Being Moderated

    Hello,

    It seems SAP note 1800724 describes this issue.

    ------------------------------------------------------------------------------------------------

    Problem between Join Engine and SQL layer sorting columns.

    The trace file contains the entry:

    "Could not execute 'select aaa.bbbb, aaa.xxx, aaa.zzzz, from

    aaa left outer join aaa on aaa.ccc ...' in 1.289 seconds . SAP

    DBTech JDBC: [2048]: column store error: [6930] attribute value is

    not a number;<sourceType=string>;<value=AA01>; "

    -------------------------------------------------------------------------------------------------

     

    Haifeng

Actions