Looks like mediation summary is broken?

[2009-11-23 08:17:17,703] ERROR -  DS Fault Message: Error in
'createProcessedPreparedStatement'
Source Data Service:-
Name: BAMSummaryGenerationDS
Location:
E:\testing\WSO2BA~1.0-S\bin\..\repository\dataservices\BAMSummaryGenerationDS.dbs
Description: N/A
Default Namespace: http://ws.wso2.org/dataservice
Current Request Name: getLatestProxyStatYearlySummaryYearId
Current Params: {direction=Out, proxyName=OrderFulfillment, serverId=1}
Nested Exception:-
org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement SELECT
BAM_YEAR_ID FROM BAM_PROXY_STAT_YEAR_FACT WHERE BAM_ID=(SELECT MAX(BAM_ID)
FROM BAM_PROXY_STAT_Y
EAR_FACT WHERE BAM_SERVER_ID=? AND BAM_PROXY_NAME=? BAM_DIRECTION[*]=?);
expected ); SQL statement:
SELECT BAM_YEAR_ID FROM BAM_PROXY_STAT_YEAR_FACT WHERE BAM_ID=(SELECT
MAX(BAM_ID) FROM BAM_PROXY_STAT_YEAR_FACT WHERE BAM_SERVER_ID=? AND
BAM_PROXY_NAME=? BAM_DIRE
CTION=?) [42001-112]
        at org.h2.message.Message.getSQLException(Message.java:107)
        at org.h2.message.Message.getSQLException(Message.java:118)
        at org.h2.message.Message.getSyntaxError(Message.java:143)
        at org.h2.command.Parser.read(Parser.java:2522)
        at org.h2.command.Parser.readTerm(Parser.java:2311)
        at org.h2.command.Parser.readFactor(Parser.java:1847)
        at org.h2.command.Parser.readSum(Parser.java:1834)
        at org.h2.command.Parser.readConcat(Parser.java:1807)
        at org.h2.command.Parser.readCondition(Parser.java:1764)
        at org.h2.command.Parser.readAnd(Parser.java:1655)
        at org.h2.command.Parser.readExpression(Parser.java:1647)
        at org.h2.command.Parser.parseSelectSimple(Parser.java:1604)
        at org.h2.command.Parser.parseSelectSub(Parser.java:1497)
        at org.h2.command.Parser.parseSelectUnion(Parser.java:1342)
        at org.h2.command.Parser.parseSelect(Parser.java:1330)
        at org.h2.command.Parser.parsePrepared(Parser.java:392)
        at org.h2.command.Parser.parse(Parser.java:288)
        at org.h2.command.Parser.parse(Parser.java:260)
        at org.h2.command.Parser.prepareCommand(Parser.java:232)
        at org.h2.engine.Session.prepareLocal(Session.java:410)
        at org.h2.engine.Session.prepareCommand(Session.java:371)
        at
org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1045)
        at
org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:74)
        at
org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:227)
        at
org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:248)
        at
org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:302)
        at
org.wso2.carbon.dataservices.dispatch.query.SQLQuery.createProcessedPreparedStatement(SQLQuery.java:424)
        at
org.wso2.carbon.dataservices.dispatch.query.SQLQuery.processNormalQuery(SQLQuery.java:331)
        at
org.wso2.carbon.dataservices.dispatch.query.SQLQuery.runQuery(SQLQuery.java:1086)
        at
org.wso2.carbon.dataservices.dispatch.query.Query.execute(Query.java:110)
        at
org.wso2.carbon.dataservices.dispatch.CallQuery.execute(CallQuery.java:72)
        at
org.wso2.carbon.dataservices.dispatch.operation.Operation.execute(Operation.java:50)
        at
org.wso2.carbon.dataservices.dispatch.DataService.invoke(DataService.java:186)
        at
org.wso2.carbon.dataservices.dispatch.DSOMDataSource.serialize(DSOMDataSource.java:87)
        at
org.apache.axiom.om.impl.llom.OMSourcedElementImpl.internalSerializeAndConsume(OMSourcedElementImpl.java:738)
        at
org.apache.axiom.om.impl.llom.OMElementImpl.internalSerialize(OMElementImpl.java:966)
        at
org.apache.axiom.om.impl.llom.OMElementImpl.internalSerializeAndConsume(OMElementImpl.java:995)
        at
org.apache.axiom.soap.impl.llom.SOAPEnvelopeImpl.serializeInternally(SOAPEnvelopeImpl.java:254)
        at
org.apache.axiom.soap.impl.llom.SOAPEnvelopeImpl.internalSerialize(SOAPEnvelopeImpl.java:242)
        at
org.apache.axiom.om.impl.llom.OMElementImpl.internalSerializeAndConsume(OMElementImpl.java:995)
        at
org.apache.axiom.om.impl.llom.OMNodeImpl.serializeAndConsume(OMNodeImpl.java:486)
        at
org.apache.axis2.transport.http.SOAPMessageFormatter.writeTo(SOAPMessageFormatter.java:79)
        at
org.apache.axis2.transport.http.CommonsHTTPTransportSender.sendUsingOutputStream(CommonsHTTPTransportSender.java:355)
        at
org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:232)
        at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:440)
        at
org.apache.axis2.receivers.AbstractInOutSyncMessageReceiver.invokeBusinessLogic(AbstractInOutSyncMessageReceiver.java:45)
        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.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:167)
        at
org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:142)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at
org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
        at
org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
        at
org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:67)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at
org.wso2.carbon.bridge.BridgeServlet.service(BridgeServlet.java:135)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
        at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
        at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
        at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
        at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
        at java.lang.Thread.run(Thread.java:619)


Samisa...

On Mon, Nov 23, 2009 at 8:51 AM, Samisa Abeysinghe <[email protected]> wrote:

> Guys,
>     Where is the pack?
>
> Thanks,
> Samisa...
>
> On Sat, Nov 21, 2009 at 7:08 AM, Dumindu Pallewela <[email protected]>wrote:
>
>>
>>
>> On Sat, Nov 21, 2009 at 6:32 AM, Tyrell Perera <[email protected]> wrote:
>>
>>>
>>>
>>> On Fri, Nov 20, 2009 at 5:50 PM, Dumindu Pallewela <[email protected]>wrote:
>>>
>>>>
>>>>
>>>> On Fri, Nov 20, 2009 at 4:57 PM, Sanjiva Weerawarana 
>>>> <[email protected]>wrote:
>>>>
>>>>> Guys please fix the code to be not sensitive to white space like that!
>>>>> People will die with stuff like that ..
>>>>
>>>>
>>>> It is actually a registry dump that is used in populating the gadgets in
>>>> the dashboard. Thus formatting that file would result in failures.
>>>>
>>>> It is used only at the first server start and is not meant to be edited
>>>> by the user.
>>>>
>>>>
>>> This is true. But we need to get the parser fixed since you have to edit
>>> this file to add gadgets, tabs and settings at design time. We should be
>>> able to nicely format this file in an editor without breaking everything in
>>> the process :)
>>>
>>>
>> +1 it'll be really nice to have.
>> Dumidnu.
>> _______________________________________________
>> Carbon-dev mailing list
>> [email protected]
>> https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
>>
>>
>
>
> --
> Samisa Abeysinghe
> Director, Engineering - WSO2 Inc.
>
>
> http://www.wso2.com/ - "The Open Source SOA Company"
>



-- 
Samisa Abeysinghe
Director, Engineering - WSO2 Inc.

http://www.wso2.com/ - "The Open Source SOA Company"
_______________________________________________
Carbon-dev mailing list
[email protected]
https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev

Reply via email to