wso2 esb sending dss error

Question

I have a proxy inside wso2 esb. I used call and I want to send response from call to my outSequence. But it gives me Dss error.I do not use dss at all. Can anyone tell why this error happens and how can I solve this? this is my proxy code:

<proxy xmlns="http://ws.apache.org/ns/synapse"
   name="FinaltestProxy"
   startOnLoad="true"
   statistics="disable"
   trace="enable"
   transports="https,http,vfs">
<target>
  <inSequence>
        <input type="text"/>
        <output type="xml"/>
     </smooks>
     <iterate attachPath="//csv-set"
              continueParent="true"
              expression="//csv-set/search"
              preservePayload="true"
              sequential="true">
        <target>
           <sequence>
              <call>
                 <endpoint>
                    <address format="soap11"
                             uri="MyEndpoint"/>
                 </endpoint>
              </call>
              <respond/>
           </sequence>
        </target>
     </iterate>
  </inSequence>
  <outSequence>
     <property name="OUT_ONLY" value="true"/>
     <aggregate>
        <completeCondition>
           <messageCount max="100000" min="0"/>
        </completeCondition>
        <onComplete xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope"
                    expression="//Guest">
           <log level="full"/>
           <send>
              <endpoint name="FileEpr">
                 <address format="soap11"
                          uri="MyEndpoint"/>
                 <property name="ContentType" scope="axis2" value="text/xml"/>
              </endpoint>
           </send>
        </onComplete>
     </aggregate>
  </outSequence>
</target>
 /* some code*/
</proxy>

and this is my Error:

DS Code: DATABASE_ERROR
Nested Exception:-
javax.xml.stream.XMLStreamException: DS Fault Message: Error in    'SQLQuery.processNormalQuery'
DS Code: DATABASE_ERROR
Source Data Service:-
Name: GuestIdentityService
Location: /ss.dbs
Description: N/A
Default Namespace: http://soa.ut.ac.ir/GuestIdentityService
Current Request Name: searchGuestIdentity
Current Params: {ID=}
Nested Exception:-
java.lang.NumberFormatException: For input string: ""

score 0 · Answer 1 · answered Feb 04 '17 at 10:43

0

Looks like you have a dataservice called ss, and it's being called somehow. Remove it if you don't want it. You can remove it from either UI or file system. It's located in repository/deployment/server/dataservices/

answered Feb 04 '17 at 10:43

Bee

12,251
11
46
73

thanks for your reply but when I checked the location I can not see dataservices and there is no ss.dbs at all – Fateme Shahrabi Feb 04 '17 at 10:51
do you have installed any car files? – Bee Feb 04 '17 at 11:35
No I didn't install any car file – Fateme Shahrabi Feb 04 '17 at 11:39

score 0 · Accepted Answer · answered Feb 05 '17 at 13:55

0

there was a blank line in my input and that cause the problem.

answered Feb 05 '17 at 13:55

Fateme Shahrabi

95
1
11

Hi @Fateme Shahrabi, How can we handle this blank input? In my case i am having int as datatype for the DB Column called "year", when input is empty it shows the same error, because i set this param type as "Integer" in my DSS Query – Justin Aug 05 '20 at 21:30

wso2 esb sending dss error

2 Answers2