根据分析下来 应该是title=16.0passport=KIMI33gameId=7 中的16.0在调用存储过程的时候出了问题。大概的数据库存储过程如下:
Procedure platform_user_event_acc(p_s_user_account In Varchar2,
p_n_app_id Number,
p_s_event_name Varchar2,
p_n_event_value Number,
p_get_efforts Out Varchar2, --返回获得成就ID,逗号分隔
p_n_state Out Number) Is
vn_user_id Number;
Begin
p_n_state := 0;
Begin
Select t.nuser_id
Into vn_user_id
From d1xn_user.user_account_info t
Where t.saccount_woniu = upper(p_s_user_account);
Exception
When no_data_found Then
p_n_state := 99901; -- 用户不存在
Return;
End;
platform_user_event(vn_user_id,
p_n_app_id,
p_s_event_name,
p_n_event_value,
p_get_efforts,
p_n_state);
End;
这的16.0对应的是 p_n_event_value 也就是number型 实在找不出哪错了。在线等高手。
ERROR Timer-0 EventDBServiceImpl:25 - -title=16.0passport=KIMI33gameId=7
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: hex to raw conversion error
ORA-06512: at line 1
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:954)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4245)
at com.woniu.dao.core.base.impl.BaseDAOImpl.execProcedure(BaseDAOImpl.java:177)
at com.woniu.dao.user.impl.UserEventDAOImpl.userPlantFormEventWithAccount(UserEventDAOImpl.java:160)
at com.woniu.platform.jms.service.imp.EventDBServiceImpl.saveUserPlantFormEventWithAccount(EventDBServiceImpl.java:23)
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 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy21.saveUserPlantFormEventWithAccount(Unknown Source)
at com.woniu.platform.jms.handle.task.Listen2QueueTask.run(Listen2QueueTask.java:49)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
Procedure platform_user_event_acc(p_s_user_account In Varchar2,
p_n_app_id Number,
p_s_event_name Varchar2,
p_n_event_value Number,
p_get_efforts Out Varchar2, --返回获得成就ID,逗号分隔
p_n_state Out Number) Is
vn_user_id Number;
Begin
p_n_state := 0;
Begin
Select t.nuser_id
Into vn_user_id
From d1xn_user.user_account_info t
Where t.saccount_woniu = upper(p_s_user_account);
Exception
When no_data_found Then
p_n_state := 99901; -- 用户不存在
Return;
End;
platform_user_event(vn_user_id,
p_n_app_id,
p_s_event_name,
p_n_event_value,
p_get_efforts,
p_n_state);
End;
这的16.0对应的是 p_n_event_value 也就是number型 实在找不出哪错了。在线等高手。
ERROR Timer-0 EventDBServiceImpl:25 - -title=16.0passport=KIMI33gameId=7
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: hex to raw conversion error
ORA-06512: at line 1
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:954)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4245)
at com.woniu.dao.core.base.impl.BaseDAOImpl.execProcedure(BaseDAOImpl.java:177)
at com.woniu.dao.user.impl.UserEventDAOImpl.userPlantFormEventWithAccount(UserEventDAOImpl.java:160)
at com.woniu.platform.jms.service.imp.EventDBServiceImpl.saveUserPlantFormEventWithAccount(EventDBServiceImpl.java:23)
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 org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy21.saveUserPlantFormEventWithAccount(Unknown Source)
at com.woniu.platform.jms.handle.task.Listen2QueueTask.run(Listen2QueueTask.java:49)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "RELEASEDEV.PKG_LIFE_PREM_CALC_PUB", line 2791
ORA-20100: -12345,select a.premium_rate
from t_premium_rate_ext a
where a.product_id =61302and a.day =0and a.athlete_official =Wand a.travel_type =0and a.elimination_period =0and a.social_security =W
ORA-06512: at "RELEASEDEV.PKG_LIFE_PREM_CALC_PUB", line 1034
ORA-06512: at "RELEASEDEV.PKG_LIFE_NEWBIZ", line 1010
ORA-06512: at "RELEASEDEV.PKG_LIFE_NEWBIZ", line 1439
ORA-06512: at "RELEASEDEV.PKG_LIFE_NEWBIZ_ENTRY", line 576
ORA-06512: at line 1 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:954)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3422)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4394)
at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:73)
at com.ebao.life.newbiz.policy.individual.LifePolicyDAOIndividualImpl.reCalcPolicyPrem(LifePolicyDAOIndividualImpl.java:1114)
at com.ebao.life.newbiz.policy.individual.IndividualLifePolicy.calcPremWithNoPkg(IndividualLifePolicy.java:390)
at com.ebao.life.newbiz.productpackage.ProductPackageDS.calcPrem(ProductPackageDS.java:81)
at com.ebao.life.newbiz.policy.individual.IndividualLifePolicy.reCalcPolicyPrem(IndividualLifePolicy.java:379)
at com.ebao.life.esb.listener.ecommerce.NewbizApproBean.doProcess(NewbizApproBean.java:123)
at com.ebao.life.esb.listener.ecommerce.ECommerceImpl.newbizAppro(ECommerceImpl.java:25)
at com.ebao.life.ebiz.ecommerce.NewBizAcceptService.AcceptPolicy(NewBizAcceptService.java:31)
at com.ebao.life.ebiz.ecommerce.NewBizAcceptService.service(NewBizAcceptService.java:25)
at com.ebao.life.ebiz.ElectronicBizServlet.submitData(ElectronicBizServlet.java:81)
at com.ebao.life.ebiz.ElectronicBizServlet.doProcess(ElectronicBizServlet.java:43)
at com.ebao.life.servlet.pub.common.RootServlet.service(RootServlet.java:275)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
at weblogic.servlet.ServletServlet.service(ServletServlet.java:47)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
at com.ebao.pub.framework.AppFilter.doFilter(AppFilter.java:63)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3242)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2010)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:1916)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1366)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:181)