[Carbon-jira] [jira] Assigned: (BAM-61) Failed to generate server stat summary.
Vijayaratha Vijayasingam (JIRA)
jira at wso2.org
Sun Jun 6 22:55:18 PDT 2010
[ https://wso2.org/jira/browse/BAM-61?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vijayaratha Vijayasingam reassigned BAM-61:
-------------------------------------------
Assignee: Krishantha Samaraweera (was: Dumindu Pallewela)
> Failed to generate server stat summary.
> ---------------------------------------
>
> Key: BAM-61
> URL: https://wso2.org/jira/browse/BAM-61
> Project: WSO2 Business Activity Monitor
> Issue Type: Bug
> Affects Versions: 1.1.0
> Environment: RC19
> Reporter: Krishantha Samaraweera
> Assignee: Krishantha Samaraweera
> Priority: Highest
>
> Following exception appears when the system is creating stat summaries.
> Exception
> =======
> [2010-06-02 17:48:12,149] ERROR - DS Fault Message: Error in 'SQLQuery.processNormalQuery'
> Source Data Service:-
> Name: BAMSummaryGenerationDS
> Location: /home/krishantha/Desktop/rc19/wso2bam-1.1.0/repository/deployment/server/dataservices/BAMSummaryGenerationDS.dbs
> Description: N/A
> Default Namespace: http://ws.wso2.org/dataservice
> Current Request Name: addServerStatMonthlySummary
> Current Params: {minResTime=0.0, avgResTime=0.0, monthId=2, serverId=1, faultCount=0, reqCount=0, resCount=0, maxResTime=0.0}
> Nested Exception:-
> org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: BAM_SERVER_STAT_MONTH_FACT_IBFK_1: PUBLIC.BAM_SERVER_STAT_MONTH_FACT FOREIGN KEY(BAM_SERVER_ID) REFERENCES PUBLIC.BAM_SERVER(BAM_SERVER_ID); SQL statement:
> INSERT INTO BAM_SERVER_STAT_MONTH_FACT (BAM_SERVER_ID, BAM_MONTH_ID, BAM_AVG_RES_TIME, BAM_MAX_RES_TIME, BAM_MIN_RES_TIME, BAM_REQ_COUNT, BAM_RES_COUNT, BAM_FAULT_COUNT) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [23002-112]
> at org.h2.message.Message.getSQLException(Message.java:107)
> at org.h2.message.Message.getSQLException(Message.java:118)
> at org.h2.message.Message.getSQLException(Message.java:77)
> at org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:347)
> at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:289)
> at org.h2.table.Table.fireConstraints(Table.java:760)
> at org.h2.table.Table.fireAfterRow(Table.java:775)
> at org.h2.command.dml.Insert.update(Insert.java:103)
> at org.h2.command.CommandContainer.update(CommandContainer.java:71)
> at org.h2.command.Command.executeUpdate(Command.java:207)
> at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:139)
> at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:128)
> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
> at org.wso2.carbon.dataservices.core.description.query.SQLQuery.processNormalQuery(SQLQuery.java:474)
> at org.wso2.carbon.dataservices.core.description.query.SQLQuery.runQuery(SQLQuery.java:1412)
> at org.wso2.carbon.dataservices.core.description.query.Query.execute(Query.java:214)
> at org.wso2.carbon.dataservices.core.engine.CallQuery.execute(CallQuery.java:150)
> at org.wso2.carbon.dataservices.core.engine.CallQueryGroup.execute(CallQueryGroup.java:108)
> at org.wso2.carbon.dataservices.core.description.operation.Operation.execute(Operation.java:64)
> at org.wso2.carbon.dataservices.core.engine.DataService.invoke(DataService.java:318)
> at org.wso2.carbon.dataservices.core.engine.DSOMDataSource.serialize(DSOMDataSource.java:90)
> at org.wso2.carbon.dataservices.core.DBUtils.executeSingleRequest(DBUtils.java:413)
> at org.wso2.carbon.dataservices.core.DBUtils.dispatchSingleRequest(DBUtils.java:277)
> at org.wso2.carbon.dataservices.core.DBUtils.invoke(DBUtils.java:213)
> at org.wso2.carbon.dataservices.core.DBInOnlyMessageReceiver.invokeBusinessLogic(DBInOnlyMessageReceiver.java:46)
> at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:114)
> at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:178)
> at org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:122)
> at org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:64)
> at org.apache.axis2.transport.local.LocalTransportSender.finalizeSendWithToAddress(LocalTransportSender.java:104)
> at org.apache.axis2.transport.local.LocalTransportSender.invoke(LocalTransportSender.java:79)
> at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:443)
> at org.apache.axis2.description.OutOnlyAxisOperationClient.executeImpl(OutOnlyAxisOperation.java:272)
> at org.apache.axis2.client.OperationClient.execute(OperationClient.java:165)
> at org.wso2.carbon.bam.core.client.stub.bamsummarygenerationds.BAMSummaryGenerationDSStub.addServerStatMonthlySummary(BAMSummaryGenerationDSStub.java:8934)
> at org.wso2.carbon.bam.core.client.BAMSummaryGenerationDSClient.addServerStatMonthlySummary(BAMSummaryGenerationDSClient.java:538)
> at org.wso2.carbon.bam.core.summary.SummaryPersistenceManager.addServerStatMonthlySummary(SummaryPersistenceManager.java:197)
> at org.wso2.carbon.bam.core.summary.generators.ServerSummaryGenerator.summarizeMonthly(ServerSummaryGenerator.java:107)
> at org.wso2.carbon.bam.core.summary.generators.AbstractSummaryGenerator.summarize(AbstractSummaryGenerator.java:106)
> at org.wso2.carbon.bam.core.summary.generators.AbstractSummaryGenerator.generateSummary(AbstractSummaryGenerator.java:64)
> at org.wso2.carbon.bam.core.summary.SummaryGenerationTask.generateServerSummaries(SummaryGenerationTask.java:269)
> at org.wso2.carbon.bam.core.summary.SummaryGenerationTask.generateServiceStatSummaries(SummaryGenerationTask.java:103)
> at org.wso2.carbon.bam.core.summary.SummaryGenerationTask.run(SummaryGenerationTask.java:43)
> at java.util.TimerThread.mainLoop(Timer.java:512)
> at java.util.TimerThread.run(Timer.java:462)
> [2010-06-02 17:48:12,150] ERROR - DS Fault Message: Error in DS non result invoke.
> Nested Exception:-
> javax.xml.stream.XMLStreamException: DS Fault Message: Error in 'SQLQuery.processNormalQuery'
> Source Data Service:-
> Name: BAMSummaryGenerationDS
> Location: /home/krishantha/Desktop/rc19/wso2bam-1.1.0/repository/deployment/server/dataservices/BAMSummaryGenerationDS.dbs
> Description: N/A
> Default Namespace: http://ws.wso2.org/dataservice
> Current Request Name: addServerStatMonthlySummary
> Current Params: {minResTime=0.0, avgResTime=0.0, monthId=2, serverId=1, faultCount=0, reqCount=0, resCount=0, maxResTime=0.0}
> Nested Exception:-
> org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: BAM_SERVER_STAT_MONTH_FACT_IBFK_1: PUBLIC.BAM_SERVER_STAT_MONTH_FACT FOREIGN KEY(BAM_SERVER_ID) REFERENCES PUBLIC.BAM_SERVER(BAM_SERVER_ID); SQL statement:
> INSERT INTO BAM_SERVER_STAT_MONTH_FACT (BAM_SERVER_ID, BAM_MONTH_ID, BAM_AVG_RES_TIME, BAM_MAX_RES_TIME, BAM_MIN_RES_TIME, BAM_REQ_COUNT, BAM_RES_COUNT, BAM_FAULT_COUNT) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [23002-112]
> at org.h2.message.Message.getSQLException(Message.java:107)
> at org.h2.message.Message.getSQLException(Message.java:118)
> at org.h2.message.Message.getSQLException(Message.java:77)
> at org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:347)
> at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:289)
> at org.h2.table.Table.fireConstraints(Table.java:760)
> at org.h2.table.Table.fireAfterRow(Table.java:775)
> at org.h2.command.dml.Insert.update(Insert.java:103)
> at org.h2.command.CommandContainer.update(CommandContainer.java:71)
> at org.h2.command.Command.executeUpdate(Command.java:207)
> at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:139)
> at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:128)
> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
> at org.wso2.carbon.dataservices.core.description.query.SQLQuery.processNormalQuery(SQLQuery.java:474)
> at org.wso2.carbon.dataservices.core.description.query.SQLQuery.runQuery(SQLQuery.java:1412)
> at org.wso2.carbon.dataservices.core.description.query.Query.execute(Query.java:214)
> at org.wso2.carbon.dataservices.core.engine.CallQuery.execute(CallQuery.java:150)
> at org.wso2.carbon.dataservices.core.engine.CallQueryGroup.execute(CallQueryGroup.java:108)
> at org.wso2.carbon.dataservices.core.description.operation.Operation.execute(Operation.java:64)
> at org.wso2.carbon.dataservices.core.engine.DataService.invoke(DataService.java:318)
> at org.wso2.carbon.dataservices.core.engine.DSOMDataSource.serialize(DSOMDataSource.java:90)
> at org.wso2.carbon.dataservices.core.DBUtils.executeSingleRequest(DBUtils.java:413)
> at org.wso2.carbon.dataservices.core.DBUtils.dispatchSingleRequest(DBUtils.java:277)
> at org.wso2.carbon.dataservices.core.DBUtils.invoke(DBUtils.java:213)
> at org.wso2.carbon.dataservices.core.DBInOnlyMessageReceiver.invokeBusinessLogic(DBInOnlyMessageReceiver.java:46)
> at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:114)
> at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:178)
> at org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:122)
> at org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:64)
> at org.apache.axis2.transport.local.LocalTransportSender.finalizeSendWithToAddress(LocalTransportSender.java:104)
> at org.apache.axis2.transport.local.LocalTransportSender.invoke(LocalTransportSender.java:79)
> at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:443)
> at org.apache.axis2.description.OutOnlyAxisOperationClient.executeImpl(OutOnlyAxisOperation.java:272)
> at org.apache.axis2.client.OperationClient.execute(OperationClient.java:165)
> at org.wso2.carbon.bam.core.client.stub.bamsummarygenerationds.BAMSummaryGenerationDSStub.addServerStatMonthlySummary(BAMSummaryGenerationDSStub.java:8934)
> at org.wso2.carbon.bam.core.client.BAMSummaryGenerationDSClient.addServerStatMonthlySummary(BAMSummaryGenerationDSClient.java:538)
> at org.wso2.carbon.bam.core.summary.SummaryPersistenceManager.addServerStatMonthlySummary(SummaryPersistenceManager.java:197)
> at org.wso2.carbon.bam.core.summary.generators.ServerSummaryGenerator.summarizeMonthly(ServerSummaryGenerator.java:107)
> at org.wso2.carbon.bam.core.summary.generators.AbstractSummaryGenerator.summarize(AbstractSummaryGenerator.java:106)
> at org.wso2.carbon.bam.core.summary.generators.AbstractSummaryGenerator.generateSummary(AbstractSummaryGenerator.java:64)
> at org.wso2.carbon.bam.core.summary.SummaryGenerationTask.generateServerSummaries(SummaryGenerationTask.java:269)
> at org.wso2.carbon.bam.core.summary.SummaryGenerationTask.generateServiceStatSummaries(SummaryGenerationTask.java:103)
> at org.wso2.carbon.bam.core.summary.SummaryGenerationTask.run(SummaryGenerationTask.java:43)
> at java.util.TimerThread.mainLoop(Timer.java:512)
> at java.util.TimerThread.run(Timer.java:462)
> at org.wso2.carbon.dataservices.core.engine.DSOMDataSource.serialize(DSOMDataSource.java:97)
> at org.wso2.carbon.dataservices.core.DBUtils.executeSingleRequest(DBUtils.java:413)
> at org.wso2.carbon.dataservices.core.DBUtils.dispatchSingleRequest(DBUtils.java:277)
> at org.wso2.carbon.dataservices.core.DBUtils.invoke(DBUtils.java:213)
> at org.wso2.carbon.dataservices.core.DBInOnlyMessageReceiver.invokeBusinessLogic(DBInOnlyMessageReceiver.java:46)
> at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:114)
> at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:178)
> at org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:122)
> at org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:64)
> at org.apache.axis2.transport.local.LocalTransportSender.finalizeSendWithToAddress(LocalTransportSender.java:104)
> at org.apache.axis2.transport.local.LocalTransportSender.invoke(LocalTransportSender.java:79)
> at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:443)
> at org.apache.axis2.description.OutOnlyAxisOperationClient.executeImpl(OutOnlyAxisOperation.java:272)
> at org.apache.axis2.client.OperationClient.execute(OperationClient.java:165)
> at org.wso2.carbon.bam.core.client.stub.bamsummarygenerationds.BAMSummaryGenerationDSStub.addServerStatMonthlySummary(BAMSummaryGenerationDSStub.java:8934)
> at org.wso2.carbon.bam.core.client.BAMSummaryGenerationDSClient.addServerStatMonthlySummary(BAMSummaryGenerationDSClient.java:538)
> at org.wso2.carbon.bam.core.summary.SummaryPersistenceManager.addServerStatMonthlySummary(SummaryPersistenceManager.java:197)
> at org.wso2.carbon.bam.core.summary.generators.ServerSummaryGenerator.summarizeMonthly(ServerSummaryGenerator.java:107)
> at org.wso2.carbon.bam.core.summary.generators.AbstractSummaryGenerator.summarize(AbstractSummaryGenerator.java:106)
> at org.wso2.carbon.bam.core.summary.generators.AbstractSummaryGenerator.generateSummary(AbstractSummaryGenerator.java:64)
> at org.wso2.carbon.bam.core.summary.SummaryGenerationTask.generateServerSummaries(SummaryGenerationTask.java:269)
> at org.wso2.carbon.bam.core.summary.SummaryGenerationTask.generateServiceStatSummaries(SummaryGenerationTask.java:103)
> at org.wso2.carbon.bam.core.summary.SummaryGenerationTask.run(SummaryGenerationTask.java:43)
> at java.util.TimerThread.mainLoop(Timer.java:512)
> at java.util.TimerThread.run(Timer.java:462)
> [2010-06-02 17:48:12,151] ERROR - org.apache.axis2.AxisFault: javax.xml.stream.XMLStreamException: DS Fault Message: Error in 'SQLQuery.processNormalQuery'
> Source Data Service:-
> Name: BAMSummaryGenerationDS
> Location: /home/krishantha/Desktop/rc19/wso2bam-1.1.0/repository/deployment/server/dataservices/BAMSummaryGenerationDS.dbs
> Description: N/A
> Default Namespace: http://ws.wso2.org/dataservice
> Current Request Name: addServerStatMonthlySummary
> Current Params: {minResTime=0.0, avgResTime=0.0, monthId=2, serverId=1, faultCount=0, reqCount=0, resCount=0, maxResTime=0.0}
> Nested Exception:-
> org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: BAM_SERVER_STAT_MONTH_FACT_IBFK_1: PUBLIC.BAM_SERVER_STAT_MONTH_FACT FOREIGN KEY(BAM_SERVER_ID) REFERENCES PUBLIC.BAM_SERVER(BAM_SERVER_ID); SQL statement:
> INSERT INTO BAM_SERVER_STAT_MONTH_FACT (BAM_SERVER_ID, BAM_MONTH_ID, BAM_AVG_RES_TIME, BAM_MAX_RES_TIME, BAM_MIN_RES_TIME, BAM_REQ_COUNT, BAM_RES_COUNT, BAM_FAULT_COUNT) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [23002-112]
> at org.h2.message.Message.getSQLException(Message.java:107)
> at org.h2.message.Message.getSQLException(Message.java:118)
> at org.h2.message.Message.getSQLException(Message.java:77)
> at org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:347)
> at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:289)
> at org.h2.table.Table.fireConstraints(Table.java:760)
> at org.h2.table.Table.fireAfterRow(Table.java:775)
> at org.h2.command.dml.Insert.update(Insert.java:103)
> at org.h2.command.CommandContainer.update(CommandContainer.java:71)
> at org.h2.command.Command.executeUpdate(Command.java:207)
> at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:139)
> at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:128)
> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
> at org.wso2.carbon.dataservices.core.description.query.SQLQuery.processNormalQuery(SQLQuery.java:474)
> at org.wso2.carbon.dataservices.core.description.query.SQLQuery.runQuery(SQLQuery.java:1412)
> at org.wso2.carbon.dataservices.core.description.query.Query.execute(Query.java:214)
> at org.wso2.carbon.dataservices.core.engine.CallQuery.execute(CallQuery.java:150)
> at org.wso2.carbon.dataservices.core.engine.CallQueryGroup.execute(CallQueryGroup.java:108)
> at org.wso2.carbon.dataservices.core.description.operation.Operation.execute(Operation.java:64)
> at org.wso2.carbon.dataservices.core.engine.DataService.invoke(DataService.java:318)
> at org.wso2.carbon.dataservices.core.engine.DSOMDataSource.serialize(DSOMDataSource.java:90)
> at org.wso2.carbon.dataservices.core.DBUtils.executeSingleRequest(DBUtils.java:413)
> at org.wso2.carbon.dataservices.core.DBUtils.dispatchSingleRequest(DBUtils.java:277)
> at org.wso2.carbon.dataservices.core.DBUtils.invoke(DBUtils.java:213)
> at org.wso2.carbon.dataservices.core.DBInOnlyMessageReceiver.invokeBusinessLogic(DBInOnlyMessageReceiver.java:46)
> at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:114)
> at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:178)
> at org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:122)
> at org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:64)
> at org.apache.axis2.transport.local.LocalTransportSender.finalizeSendWithToAddress(LocalTransportSender.java:104)
> at org.apache.axis2.transport.local.LocalTransportSender.invoke(LocalTransportSender.java:79)
> at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:443)
> at org.apache.axis2.description.OutOnlyAxisOperationClient.executeImpl(OutOnlyAxisOperation.java:272)
> at org.apache.axis2.client.OperationClient.execute(OperationClient.java:165)
> at org.wso2.carbon.bam.core.client.stub.bamsummarygenerationds.BAMSummaryGenerationDSStub.addServerStatMonthlySummary(BAMSummaryGenerationDSStub.java:8934)
> at org.wso2.carbon.bam.core.client.BAMSummaryGenerationDSClient.addServerStatMonthlySummary(BAMSummaryGenerationDSClient.java:538)
> at org.wso2.carbon.bam.core.summary.SummaryPersistenceManager.addServerStatMonthlySummary(SummaryPersistenceManager.java:197)
> at org.wso2.carbon.bam.core.summary.generators.ServerSummaryGenerator.summarizeMonthly(ServerSummaryGenerator.java:107)
> at org.wso2.carbon.bam.core.summary.generators.AbstractSummaryGenerator.summarize(AbstractSummaryGenerator.java:106)
> at org.wso2.carbon.bam.core.summary.generators.AbstractSummaryGenerator.generateSummary(AbstractSummaryGenerator.java:64)
> at org.wso2.carbon.bam.core.summary.SummaryGenerationTask.generateServerSummaries(SummaryGenerationTask.java:269)
> at org.wso2.carbon.bam.core.summary.SummaryGenerationTask.generateServiceStatSummaries(SummaryGenerationTask.java:103)
> at org.wso2.carbon.bam.core.summary.SummaryGenerationTask.run(SummaryGenerationTask.java:43)
> at java.util.TimerThread.mainLoop(Timer.java:512)
> at java.util.TimerThread.run(Timer.java:462)
> [2010-06-02 17:48:12,467] ERROR - DS Fault Message: Error in 'SQLQuery.processNormalQuery'
> Source Data Service:-
> Name: BAMSummaryGenerationDS
> Location: /home/krishantha/Desktop/rc19/wso2bam-1.1.0/repository/deployment/server/dataservices/BAMSummaryGenerationDS.dbs
> Description: N/A
> Default Namespace: http://ws.wso2.org/dataservice
> Current Request Name: addServerStatQuarterlySummary
> Current Params: {minResTime=0.0, avgResTime=0.0, quarterId=2, serverId=1, faultCount=0, reqCount=0, resCount=0, maxResTime=0.0}
> Nested Exception:-
> org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: BAM_SERVER_STAT_QTR_FACT_IBFK_1: PUBLIC.BAM_SERVER_STAT_QTR_FACT FOREIGN KEY(BAM_SERVER_ID) REFERENCES PUBLIC.BAM_SERVER(BAM_SERVER_ID); SQL statement:
> INSERT INTO BAM_SERVER_STAT_QTR_FACT (BAM_SERVER_ID, BAM_QTR_ID, BAM_AVG_RES_TIME, BAM_MAX_RES_TIME, BAM_MIN_RES_TIME, BAM_REQ_COUNT, BAM_RES_COUNT, BAM_FAULT_COUNT) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [23002-112]
> at org.h2.message.Message.getSQLException(Message.java:107)
> at org.h2.message.Message.getSQLException(Message.java:118)
> at org.h2.message.Message.getSQLException(Message.java:77)
> at org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:347)
> at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:289)
> at org.h2.table.Table.fireConstraints(Table.java:760)
> at org.h2.table.Table.fireAfterRow(Table.java:775)
> at org.h2.command.dml.Insert.update(Insert.java:103)
> at org.h2.command.CommandContainer.update(CommandContainer.java:71)
> at org.h2.command.Command.executeUpdate(Command.java:207)
> at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:139)
> at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:128)
> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
> at org.wso2.carbon.dataservices.core.description.query.SQLQuery.processNormalQuery(SQLQuery.java:474)
> at org.wso2.carbon.dataservices.core.description.query.SQLQuery.runQuery(SQLQuery.java:1412)
> at org.wso2.carbon.dataservices.core.description.query.Query.execute(Query.java:214)
> at org.wso2.carbon.dataservices.core.engine.CallQuery.execute(CallQuery.java:150)
> at org.wso2.carbon.dataservices.core.engine.CallQueryGroup.execute(CallQueryGroup.java:108)
> at org.wso2.carbon.dataservices.core.description.operation.Operation.execute(Operation.java:64)
> at org.wso2.carbon.dataservices.core.engine.DataService.invoke(DataService.java:318)
> at org.wso2.carbon.dataservices.core.engine.DSOMDataSource.serialize(DSOMDataSource.java:90)
> at org.wso2.carbon.dataservices.core.DBUtils.executeSingleRequest(DBUtils.java:413)
> at org.wso2.carbon.dataservices.core.DBUtils.dispatchSingleRequest(DBUtils.java:277)
> at org.wso2.carbon.dataservices.core.DBUtils.invoke(DBUtils.java:213)
> at org.wso2.carbon.dataservices.core.DBInOnlyMessageReceiver.invokeBusinessLogic(DBInOnlyMessageReceiver.java:46)
> at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:114)
> at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:178)
> at org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:122)
> at org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:64)
> at org.apache.axis2.transport.local.LocalTransportSender.finalizeSendWithToAddress(LocalTransportSender.java:104)
> at org.apache.axis2.transport.local.LocalTransportSender.invoke(LocalTransportSender.java:79)
> at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:443)
> at org.apache.axis2.description.OutOnlyAxisOperationClient.executeImpl(OutOnlyAxisOperation.java:272)
> at org.apache.axis2.client.OperationClient.execute(OperationClient.java:165)
> at org.wso2.carbon.bam.core.client.stub.bamsummarygenerationds.BAMSummaryGenerationDSStub.addServerStatQuarterlySummary(BAMSummaryGenerationDSStub.java:8994)
> at org.wso2.carbon.bam.core.client.BAMSummaryGenerationDSClient.addServerStatQuarterlySummary(BAMSummaryGenerationDSClient.java:548)
> at org.wso2.carbon.bam.core.summary.SummaryPersistenceManager.addServerStatQuarterlySummary(SummaryPersistenceManager.java:206)
> at org.wso2.carbon.bam.core.summary.generators.ServerSummaryGenerator.summarizeQuarterly(ServerSummaryGenerator.java:129)
> at org.wso2.carbon.bam.core.summary.generators.AbstractSummaryGenerator.summarize(AbstractSummaryGenerator.java:109)
> at org.wso2.carbon.bam.core.summary.generators.AbstractSummaryGenerator.generateSummary(AbstractSummaryGenerator.java:64)
> at org.wso2.carbon.bam.core.summary.SummaryGenerationTask.generateServerSummaries(SummaryGenerationTask.java:269)
> at org.wso2.carbon.bam.core.summary.SummaryGenerationTask.generateServiceStatSummaries(SummaryGenerationTask.java:103)
> at org.wso2.carbon.bam.core.summary.SummaryGenerationTask.run(SummaryGenerationTask.java:43)
> at java.util.TimerThread.mainLoop(Timer.java:512)
> at java.util.TimerThread.run(Timer.java:462)
> [2010-06-02 17:48:12,468] ERROR - DS Fault Message: Error in DS non result invoke.
> Nested Exception:-
> javax.xml.stream.XMLStreamException: DS Fault Message: Error in 'SQLQuery.processNormalQuery'
> Source Data Service:-
> Name: BAMSummaryGenerationDS
> Location: /home/krishantha/Desktop/rc19/wso2bam-1.1.0/repository/deployment/server/dataservices/BAMSummaryGenerationDS.dbs
> Description: N/A
> Default Namespace: http://ws.wso2.org/dataservice
> Current Request Name: addServerStatQuarterlySummary
> Current Params: {minResTime=0.0, avgResTime=0.0, quarterId=2, serverId=1, faultCount=0, reqCount=0, resCount=0, maxResTime=0.0}
> Nested Exception:-
> org.h2.jdbc.JdbcSQLException: Referential integrity constraint violation: BAM_SERVER_STAT_QTR_FACT_IBFK_1: PUBLIC.BAM_SERVER_STAT_QTR_FACT FOREIGN KEY(BAM_SERVER_ID) REFERENCES PUBLIC.BAM_SERVER(BAM_SERVER_ID); SQL statement:
> INSERT INTO BAM_SERVER_STAT_QTR_FACT (BAM_SERVER_ID, BAM_QTR_ID, BAM_AVG_RES_TIME, BAM_MAX_RES_TIME, BAM_MIN_RES_TIME, BAM_REQ_COUNT, BAM_RES_COUNT, BAM_FAULT_COUNT) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [23002-112]
> at org.h2.message.Message.getSQLException(Message.java:107)
> at org.h2.message.Message.getSQLException(Message.java:118)
> at org.h2.message.Message.getSQLException(Message.java:77)
> at org.h2.constraint.ConstraintReferential.checkRowOwnTable(ConstraintReferential.java:347)
> at org.h2.constraint.ConstraintReferential.checkRow(ConstraintReferential.java:289)
> at org.h2.table.Table.fireConstraints(Table.java:760)
> at org.h2.table.Table.fireAfterRow(Table.java:775)
> at org.h2.command.dml.Insert.update(Insert.java:103)
> at org.h2.command.CommandContainer.update(CommandContainer.java:71)
> at org.h2.command.Command.executeUpdate(Command.java:207)
> at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:139)
> at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:128)
> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
> at org.wso2.carbon.dataservices.core.description.query.SQLQuery.processNormalQuery(SQLQuery.java:474)
> at org.wso2.carbon.dataservices.core.description.query.SQLQuery.runQuery(SQLQuery.java:1412)
> at org.wso2.carbon.dataservices.core.description.query.Query.execute(Query.java:214)
> at org.wso2.carbon.dataservices.core.engine.CallQuery.execute(CallQuery.java:150)
> at org.wso2.carbon.dataservices.core.engine.CallQueryGroup.execute(CallQueryGroup.java:108)
> at org.wso2.carbon.dataservices.core.description.operation.Operation.execute(Operation.java:64)
> at org.wso2.carbon.dataservices.core.engine.DataService.invoke(DataService.java:318)
> at org.wso2.carbon.dataservices.core.engine.DSOMDataSource.serialize(DSOMDataSource.java:90)
> at org.wso2.carbon.dataservices.core.DBUtils.executeSingleRequest(DBUtils.java:413)
> at org.wso2.carbon.dataservices.core.DBUtils.dispatchSingleRequest(DBUtils.java:277)
> at org.wso2.carbon.dataservices.core.DBUtils.invoke(DBUtils.java:213)
> at org.wso2.carbon.dataservices.core.DBInOnlyMessageReceiver.invokeBusinessLogic(DBInOnlyMessageReceiver.java:46)
> at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:114)
> at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:178)
> at org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:122)
> at org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:64)
> at org.apache.axis2.transport.local.LocalTransportSender.finalizeSendWithToAddress(LocalTransportSender.java:104)
> at org.apache.axis2.transport.local.LocalTransportSender.invoke(LocalTransportSender.java:79)
> at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:443)
> at org.apache.axis2.description.OutOnlyAxisOperationClient.executeImpl(OutOnlyAxisOperation.java:272)
> at org.apache.axis2.client.OperationClient.execute(OperationClient.java:165)
> at org.wso2.carbon.bam.core.client.stub.bamsummarygenerationds.BAMSummaryGenerationDSStub.addServerStatQuarterlySummary(BAMSummaryGenerationDSStub.java:8994)
> at org.wso2.carbon.bam.core.client.BAMSummaryGenerationDSClient.addServerStatQuarterlySummary(BAMSummaryGenerationDSClient.java:548)
> at org.wso2.carbon.bam.core.summary.SummaryPersistenceManager.addServerStatQuarterlySummary(SummaryPersistenceManager.java:206)
> at org.wso2.carbon.bam.core.summary.generators.ServerSummaryGenerator.summarizeQuarterly(ServerSummaryGenerator.java:129)
> at org.wso2.carbon.bam.core.summary.generators.AbstractSummaryGenerator.summarize(AbstractSummaryGenerator.java:109)
> at org.wso2.carbon.bam.core.summary.generators.AbstractSummaryGenerator.generateSummary(AbstractSummaryGenerator.java:64)
> at org.wso2.carbon.bam.core.summary.SummaryGenerationTask.generateServerSummaries(SummaryGenerationTask.java:269)
> at org.wso2.carbon.bam.core.summary.SummaryGenerationTask.generateServiceStatSummaries(SummaryGenerationTask.java:103)
> at org.wso2.carbon.bam.core.summary.SummaryGenerationTask.run(SummaryGenerationTask.java:43)
> at java.util.TimerThread.mainLoop(Timer.java:512)
> at java.util.TimerThread.run(Timer.java:462)
> at org.wso2.carbon.dataservices.core.engine.DSOMDataSource.serialize(DSOMDataSource.java:97)
> at org.wso2.carbon.dataservices.core.DBUtils.executeSingleRequest(DBUtils.java:413)
> at org.wso2.carbon.dataservices.core.DBUtils.dispatchSingleRequest(DBUtils.java:277)
> at org.wso2.carbon.dataservices.core.DBUtils.invoke(DBUtils.java:213)
> at org.wso2.carbon.dataservices.core.DBInOnlyMessageReceiver.invokeBusinessLogic(DBInOnlyMessageReceiver.java:46)
> at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:114)
> at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:178)
> at org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:122)
> at org.apache.axis2.transport.local.LocalTransportReceiver.processMessage(LocalTransportReceiver.java:64)
> at org.apache.axis2.transport.local.LocalTransportSender.finalizeSendWithToAddress(LocalTransportSender.java:104)
> at org.apache.axis2.transport.local.LocalTransportSender.invoke(LocalTransportSender.java:79)
> at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:443)
> at org.apache.axis2.description.OutOnlyAxisOperationClient.executeImpl(OutOnlyAxisOperation.java:272)
> at org.apache.axis2.client.OperationClient.execute(OperationClient.java:165)
> at org.wso2.carbon.bam.core.client.stub.bamsummarygenerationds.BAMSummaryGenerationDSStub.addServerStatQuarterlySummary(BAMSummaryGenerationDSStub.java:8994)
> at org.wso2.carbon.bam.core.client.BAMSummaryGenerationDSClient.addServerStatQuarterlySummary(BAMSummaryGenerationDSClient.java:548)
> at org.wso2.carbon.bam.core.summary.SummaryPersistenceManager.addServerStatQuarterlySummary(SummaryPersistenceManager.java:206)
> at org.wso2.carbon.bam.core.summary.generators.ServerSummaryGenerator.summarizeQuarterly(ServerSummaryGenerator.java:129)
> at org.wso2.carbon.bam.core.summary.generators.AbstractSummaryGenerator.summarize(AbstractSummaryGenerator.java:109)
> at org.wso2.carbon.bam.core.summary.generators.AbstractSummaryGenerator.generateSummary(AbstractSummaryGenerator.java:64)
> at org.wso2.carbon.bam.core.summary.SummaryGenerationTask.generateServerSummaries(SummaryGenerationTask.java:269)
> at org.wso2.carbon.bam.core.summary.SummaryGenerationTask.generateServiceStatSummaries(SummaryGenerationTask.java:103)
> at org.wso2.carbon.bam.core.summary.SummaryGenerationTask.run(SummaryGenerationTask.java:43)
> at java.util.TimerThread.mainLoop(Timer.java:512)
> at java.util.TimerThread.run(Timer.java:462)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://wso2.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the Carbon-jira
mailing list