Faulty Service, Help

[dkblay]

I have this web service that obtains a customers balance by returning SHORT.TITLE, WORKING.BALANCE,which are valid FIELDS in T24 but am receiving this error

Caused by: javax.xml.stream.XMLStreamException: DS Fault Message: Error in 'StaticOutputElement.execute', cannot find Param with type:column name:WORKING.BALANCE

Source Data Service:-

Name: T24Test

Location: C:\wso2\WSO2DA~1.0\bin\..\repository\deployment\server\dataservices\T24test.dbs

Description: Test service

Default Namespace: http://my.namespace

Current Request Name: getBalancebyId

Current Params: {id=2000000208}

at org.wso2.carbon.dataservices.core.engine.DSOMDataSource.serialize(DSOMDataSource.java:97)

at org.apache.axiom.om.impl.llom.OMSourcedElementImpl.internalSerialize(OMSourcedElementImpl.java:691)

at org.apache.axiom.om.impl.llom.OMElementImpl.internalSerialize(OMElementImpl.java:965)

at org.apache.axiom.soap.impl.llom.SOAPEnvelopeImpl.serializeInternally(SOAPEnvelopeImpl.java:283)

at org.apache.axiom.soap.impl.llom.SOAPEnvelopeImpl.internalSerialize(SOAPEnvelopeImpl.java:245)

at org.apache.axiom.om.impl.llom.OMSerializableImpl.serializeAndConsume(OMSerializableImpl.java:193)

at org.apache.axis2.transport.http.SOAPMessageFormatter.writeTo(SOAPMessageFormatter.java:79)

... 30 more

!--================================= getBalancebyId ======================================-->

<operation name="getBalancebyId">

    <description>get customer account balance</description>

<call-query href="getBalancebyId">

<with-param name="id" query-param="id" />

</call-query>

</operation>

<query id="getBalancebyId" useConfig="t24">

        <sql>SELECT SENDOFS ENQUIRY.SELECT,,{{USER}}/{{PASS}},%ACCOUNT

                        @ID:EQ  =   set ?1

                 END

        </sql>

        <result element="getBalanceByIdResponse" rowName="account" >                           

                <element name="shortName"            column="SHORT.TITLE"/>

                <element name="workingbalance"       column="WORKING.BALANCE"/>

        </result>

        <param name="id"  sqlType="STRING" type="IN"  ordinal="1" />

</query>

[Dmitry Lukyanov]

It means that column WORKING.BALANCE is not present in resultset.
Set DEBUG level for "org.t24.driver" logger.
So, you can see the actual request and response from T24 server in the log.

Regards
Dmitry


--- Original message ---
From: "dkblay" <dkb...@gmail.com>
To: temenos-...@googlegroups.com
Date: 11 October 2012, 17:36:20
Subject: Faulty Service, Help




> I have this web service that obtains a customers balance by returningпїЅSHORT.TITLE,пїЅWORKING.BALANCE,which are valid FIELDS in T24 but am receiving this error

> @ID:EQ пїЅ= пїЅ set ?1
> END
> </sql>
>
> <result element="getBalanceByIdResponse" rowName="account" > пїЅ пїЅ пїЅ пїЅ пїЅ пїЅ пїЅ пїЅ пїЅ пїЅ пїЅ пїЅ пїЅпїЅ
> <element name="shortName" пїЅ пїЅ пїЅ пїЅ пїЅ пїЅcolumn="SHORT.TITLE"/>
> <element name="workingbalance" пїЅ пїЅ пїЅ column="WORKING.BALANCE"/>
> </result>
>
> <param name="id" пїЅsqlType="STRING" type="IN" пїЅordinal="1" />
> </query>