shweta agarwal created CLOUDSTACK-4280:
------------------------------------------
Summary: java.sql.SQLException: Parameter index out of range (18 >
number of parameters, which is 17) in usage manager
Key: CLOUDSTACK-4280
URL: https://issues.apache.org/jira/browse/CLOUDSTACK-4280
Project: CloudStack
Issue Type: Bug
Security Level: Public (Anyone can view this level - this is the default.)
Components: Usage
Affects Versions: 4.2.0
Reporter: shweta agarwal
Priority: Blocker
Fix For: 4.2.0
usage server failing with following exception
java.sql.SQLException: Parameter index out of range (18 > number of parameters,
which is 17) in usage manager
2013-08-13 00:00:01,631 ERROR [usage.dao.UsageDaoImpl] (Usage-Job-1:null) error
saving usage records to cloud_usage db
java.sql.SQLException: Parameter index out of range (18 > number of parameters,
which is 17).
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
at
com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3805)
at
com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3787)
at
com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3832)
at com.mysql.jdbc.PreparedStatement.setNull(PreparedStatement.java:3872)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.setNull(DelegatingPreparedStatement.java:108)
at
com.cloud.usage.dao.UsageDaoImpl.saveUsageRecords(UsageDaoImpl.java:436)
at
com.cloud.usage.dao.UsageDaoImpl_EnhancerByCloudStack_50cf8aaa.CGLIB$saveUsageRecords$12(<generated>)
at
com.cloud.usage.dao.UsageDaoImpl_EnhancerByCloudStack_50cf8aaa_FastClassByCloudStack_90525759.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
at
com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
at
com.cloud.usage.dao.UsageDaoImpl_EnhancerByCloudStack_50cf8aaa.saveUsageRecords(<generated>)
at
com.cloud.usage.parser.NetworkUsageParser.parse(NetworkUsageParser.java:133)
at
com.cloud.usage.UsageManagerImpl.parseHelperTables(UsageManagerImpl.java:795)
at com.cloud.usage.UsageManagerImpl.parse(UsageManagerImpl.java:695)
at com.cloud.usage.UsageManagerImpl.run(UsageManagerImpl.java:334)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at
java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:351)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:178)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:165)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:267)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:679)
2013-08-13 00:00:01,632 ERROR [usage.parser.NetworkUsageParser]
(Usage-Job-1:null) Exception in usage manager
com.cloud.utils.exception.CloudRuntimeException: Parameter index out of range
(18 > number of parameters, which is 17).
at
com.cloud.usage.dao.UsageDaoImpl.saveUsageRecords(UsageDaoImpl.java:445)
at
com.cloud.usage.dao.UsageDaoImpl_EnhancerByCloudStack_50cf8aaa.CGLIB$saveUsageRecords$12(<generated>)
at
com.cloud.usage.dao.UsageDaoImpl_EnhancerByCloudStack_50cf8aaa_FastClassByCloudStack_90525759.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
at
com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
at
com.cloud.usage.dao.UsageDaoImpl_EnhancerByCloudStack_50cf8aaa.saveUsageRecords(<generated>)
at
com.cloud.usage.parser.NetworkUsageParser.parse(NetworkUsageParser.java:133)
at
com.cloud.usage.UsageManagerImpl.parseHelperTables(UsageManagerImpl.java:795)
at com.cloud.usage.UsageManagerImpl.parse(UsageManagerImpl.java:695)
at com.cloud.usage.UsageManagerImpl.run(UsageManagerImpl.java:334)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
