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 Error : 1722, Position : 316, 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 = :1 AND CAT_D.LOCALE_ID = :2 AND CAT_NODE.CATALOG_ID = :3 , OriginalSql = 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 = ?, Error Msg = 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
Error : 1722, Position : 316, 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 = :1 AND CAT_D.LOCALE_ID = :2 AND CAT_NODE.CATALOG_ID = :3 , OriginalSql = 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 = ?, Error Msg = 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.loadNewLookCategory(BaseController.java:668)
sun.reflect.GeneratedMethodAccessor552.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
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:686)
javax.servlet.http.HttpServlet.service(HttpServlet.java:791)
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1255)
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:743)
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:440)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:182)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:93)
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:201)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
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:201)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:996)
com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1134)
com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1005)
com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:75)
com.ibm.ws.webcontainer40.servlet.CacheServletWrapper40.handleRequest(CacheServletWrapper40.java:83)
com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:927)
com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2.run(DynamicVirtualHost.java:279)
com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink$TaskWrapper.run(HttpDispatcherLink.java:1011)
com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.wrapHandlerAndExecute(HttpDispatcherLink.java:414)
com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.ready(HttpDispatcherLink.java:373)
com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:532)
com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleNewRequest(HttpInboundLink.java:466)
com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.processRequest(HttpInboundLink.java:331)
com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.ready(HttpInboundLink.java:302)
com.ibm.ws.channel.ssl.internal.SSLConnectionLink.determineNextChannel(SSLConnectionLink.java:1059)
com.ibm.ws.channel.ssl.internal.SSLConnectionLink$MyReadCompletedCallback.complete(SSLConnectionLink.java:644)
com.ibm.ws.channel.ssl.internal.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1803)
com.ibm.ws.tcpchannel.internal.WorkQueueManager.requestComplete(WorkQueueManager.java:501)
com.ibm.ws.tcpchannel.internal.WorkQueueManager.attemptIO(WorkQueueManager.java:571)
com.ibm.ws.tcpchannel.internal.WorkQueueManager.workerRun(WorkQueueManager.java:926)
com.ibm.ws.tcpchannel.internal.WorkQueueManager$Worker.run(WorkQueueManager.java:1015)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
java.lang.Thread.run(Thread.java:748)

Cause stack trace

Error : 1722, Position : 316, 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 = :1 AND CAT_D.LOCALE_ID = :2 AND CAT_NODE.CATALOG_ID = :3 , OriginalSql = 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 = ?, Error Msg = ORA-01722: invalid number
oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747)
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822)
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165)
com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:476)
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.loadNewLookCategory(BaseController.java:668)
sun.reflect.GeneratedMethodAccessor552.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:498)
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:686)
javax.servlet.http.HttpServlet.service(HttpServlet.java:791)
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1255)
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:743)
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:440)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:182)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:93)
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:201)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
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:201)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:996)
com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1134)
com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1005)
com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:75)
com.ibm.ws.webcontainer40.servlet.CacheServletWrapper40.handleRequest(CacheServletWrapper40.java:83)
com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:927)
com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2.run(DynamicVirtualHost.java:279)
com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink$TaskWrapper.run(HttpDispatcherLink.java:1011)
com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.wrapHandlerAndExecute(HttpDispatcherLink.java:414)
com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.ready(HttpDispatcherLink.java:373)
com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:532)
com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleNewRequest(HttpInboundLink.java:466)
com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.processRequest(HttpInboundLink.java:331)
com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.ready(HttpInboundLink.java:302)
com.ibm.ws.channel.ssl.internal.SSLConnectionLink.determineNextChannel(SSLConnectionLink.java:1059)
com.ibm.ws.channel.ssl.internal.SSLConnectionLink$MyReadCompletedCallback.complete(SSLConnectionLink.java:644)
com.ibm.ws.channel.ssl.internal.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1803)
com.ibm.ws.tcpchannel.internal.WorkQueueManager.requestComplete(WorkQueueManager.java:501)
com.ibm.ws.tcpchannel.internal.WorkQueueManager.attemptIO(WorkQueueManager.java:571)
com.ibm.ws.tcpchannel.internal.WorkQueueManager.workerRun(WorkQueueManager.java:926)
com.ibm.ws.tcpchannel.internal.WorkQueueManager$Worker.run(WorkQueueManager.java:1015)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
java.lang.Thread.run(Thread.java:748)