Date: Login Id:

Problem type Servlet Exception
PreparedStatementCallback; SQL [SELECT CAT.CATEGORY_ID, CAT_D.DESCRIPTION, CAT_D.EXTENDEDDESCRIPTION, CAT_D.LONGDESCRIPTION, CAT.PICTURE_ORIG_BLOB, CAT_NODE.COUNT FROM CATALOG_NODE_COUNT CAT_NODE, CATEGORY CAT, CATEGORY_DESCRIPTION CAT_D WHERE CAT.CATEGORY_ID = CAT_D.CATEGORY_ID AND CAT_NODE.CATEGORY_ID = CAT.CATEGORY_ID AND CAT.CATEGORY_ID = ? AND CAT_D.LOCALE_ID = ? AND CAT_NODE.CATALOG_ID = ?]; ORA-01722: invalid number ; nested exception is java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
PreparedStatementCallback; SQL [SELECT CAT.CATEGORY_ID, CAT_D.DESCRIPTION, CAT_D.EXTENDEDDESCRIPTION, CAT_D.LONGDESCRIPTION, CAT.PICTURE_ORIG_BLOB, CAT_NODE.COUNT FROM CATALOG_NODE_COUNT CAT_NODE, CATEGORY CAT, CATEGORY_DESCRIPTION CAT_D WHERE CAT.CATEGORY_ID = CAT_D.CATEGORY_ID AND CAT_NODE.CATEGORY_ID = CAT.CATEGORY_ID AND CAT.CATEGORY_ID = ? AND CAT_D.LOCALE_ID = ? AND CAT_NODE.CATALOG_ID = ?]; ORA-01722: invalid number ; nested exception is java.sql.SQLSyntaxErrorException: ORA-01722: invalid number   Caused by java.sql.SQLSyntaxErrorException: ORA-01722: invalid number Cause details ORA-01722: invalid number

System problem

A system error has occured. If the problem persists, please contact the User Helpdesk.
Problem type
Servlet Exception
Problem details
PreparedStatementCallback; SQL [SELECT CAT.CATEGORY_ID, CAT_D.DESCRIPTION, CAT_D.EXTENDEDDESCRIPTION, CAT_D.LONGDESCRIPTION, CAT.PICTURE_ORIG_BLOB, CAT_NODE.COUNT FROM CATALOG_NODE_COUNT CAT_NODE, CATEGORY CAT, CATEGORY_DESCRIPTION CAT_D WHERE CAT.CATEGORY_ID = CAT_D.CATEGORY_ID AND CAT_NODE.CATEGORY_ID = CAT.CATEGORY_ID AND CAT.CATEGORY_ID = ? AND CAT_D.LOCALE_ID = ? AND CAT_NODE.CATALOG_ID = ?]; ORA-01722: invalid number ; nested exception is java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
PreparedStatementCallback; SQL [SELECT CAT.CATEGORY_ID, CAT_D.DESCRIPTION, CAT_D.EXTENDEDDESCRIPTION, CAT_D.LONGDESCRIPTION, CAT.PICTURE_ORIG_BLOB, CAT_NODE.COUNT FROM CATALOG_NODE_COUNT CAT_NODE, CATEGORY CAT, CATEGORY_DESCRIPTION CAT_D WHERE CAT.CATEGORY_ID = CAT_D.CATEGORY_ID AND CAT_NODE.CATEGORY_ID = CAT.CATEGORY_ID AND CAT.CATEGORY_ID = ? AND CAT_D.LOCALE_ID = ? AND CAT_NODE.CATALOG_ID = ?]; ORA-01722: invalid number ; nested exception is java.sql.SQLSyntaxErrorException: ORA-01722: invalid number  
Caused by
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
Cause details
ORA-01722: invalid number  
[ Show details ]
[ Hide details ]

Exception stack trace

org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [SELECT CAT.CATEGORY_ID, CAT_D.DESCRIPTION, CAT_D.EXTENDEDDESCRIPTION, CAT_D.LONGDESCRIPTION, CAT.PICTURE_ORIG_BLOB, CAT_NODE.COUNT FROM CATALOG_NODE_COUNT CAT_NODE, CATEGORY CAT, CATEGORY_DESCRIPTION CAT_D WHERE CAT.CATEGORY_ID = CAT_D.CATEGORY_ID AND CAT_NODE.CATEGORY_ID = CAT.CATEGORY_ID AND CAT.CATEGORY_ID = ? AND CAT_D.LOCALE_ID = ? AND CAT_NODE.CATALOG_ID = ?]; ORA-01722: invalid number ; nested exception is java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:245)
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673)
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:728)
com.baxter.ecatalog.dao.impl.CategoryDaoImpl.loadCategory(CategoryDaoImpl.java:128)
com.baxter.ecatalog.service.impl.CategoryServiceImpl.loadCategory(CategoryServiceImpl.java:63)
com.baxter.ecatalog.web.controller.BaseController.loadNewBaseDetails(BaseController.java:442)
com.baxter.ecatalog.web.controller.BaseController.loadNewSubCategory(BaseController.java:556)
sun.reflect.GeneratedMethodAccessor886.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:174)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:421)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:409)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:771)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549)
javax.servlet.http.HttpServlet.service(HttpServlet.java:575)
javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1232)
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:781)
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:480)
com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
com.baxter.ecatalog.util.RequestProcessorHelper.doFilterInternal(RequestProcessorHelper.java:323)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:964)
com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1104)
com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:935)
com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:456)
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:518)
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:309)
com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:84)
com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:558)
com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:608)
com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:985)
com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1074)
com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1731)

Cause stack trace

java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1110)
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:712)
org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:643)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673)
org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:728)
com.baxter.ecatalog.dao.impl.CategoryDaoImpl.loadCategory(CategoryDaoImpl.java:128)
com.baxter.ecatalog.service.impl.CategoryServiceImpl.loadCategory(CategoryServiceImpl.java:63)
com.baxter.ecatalog.web.controller.BaseController.loadNewBaseDetails(BaseController.java:442)
com.baxter.ecatalog.web.controller.BaseController.loadNewSubCategory(BaseController.java:556)
sun.reflect.GeneratedMethodAccessor886.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:174)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:421)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:409)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:771)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549)
javax.servlet.http.HttpServlet.service(HttpServlet.java:575)
javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1232)
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:781)
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:480)
com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
com.baxter.ecatalog.util.RequestProcessorHelper.doFilterInternal(RequestProcessorHelper.java:323)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:964)
com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1104)
com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:935)
com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:456)
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:518)
com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:309)
com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:84)
com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:558)
com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:608)
com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:985)
com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1074)
com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1731)