Hi Fathima, It is difficult to give you a solution without knowing the exact scenario. therefore, Can you attach the dbs file please ? What is the version of your dss server ? is it DSS 3.5.0 ?
Thanks, Madhawa On Wed, Aug 24, 2016 at 6:02 PM, Fathima Dilhasha <[email protected]> wrote: > Hi All. > > I'm getting the following error while calling a data service. > I have the data service successfully deployed in the server and > datasources are referenced correctly in the data service as well. > > *TID: [0] [AS] [2016-08-21 11:57:00,299] ERROR > {org.wso2.carbon.dataservices.core.description.query.SQLQuery} - > {org.wso2.carbon.dataservices.core.description.query.SQLQuery}* > *java.lang.NullPointerException* > *TID: [0] [AS] [2016-08-21 11:57:00,300] ERROR > {org.wso2.carbon.dataservices.core.description.query.SQLQuery} - DS Fault > Message: Error in 'SQLQuery.processNormalQuery'* > *DS Code: DATABASE_ERROR* > *Nested Exception:-* > *java.lang.NullPointerException* > * {org.wso2.carbon.dataservices.core.description.query.SQLQuery}* > *DS Fault Message: Error in 'SQLQuery.processNormalQuery'* > *DS Code: DATABASE_ERROR* > *Nested Exception:-* > *java.lang.NullPointerException* > > * at > org.wso2.carbon.dataservices.core.description.query.SQLQuery.processNormalQuery(SQLQuery.java:863)* > * at > org.wso2.carbon.dataservices.core.description.query.SQLQuery.runQuery(SQLQuery.java:2247)* > * at > org.wso2.carbon.dataservices.core.description.query.Query.execute(Query.java:259)* > * at > org.wso2.carbon.dataservices.core.engine.CallQuery.executeElement(CallQuery.java:179)* > * at > org.wso2.carbon.dataservices.core.engine.CallQueryGroup.executeElement(CallQueryGroup.java:111)* > * at > org.wso2.carbon.dataservices.core.engine.OutputElement.execute(OutputElement.java:89)* > * at > org.wso2.carbon.dataservices.core.engine.OutputElementGroup.executeElement(OutputElementGroup.java:106)* > * at > org.wso2.carbon.dataservices.core.engine.OutputElement.execute(OutputElement.java:89)* > * at > org.wso2.carbon.dataservices.core.description.query.Query.writeResultEntry(Query.java:342)* > * at > org.wso2.carbon.dataservices.core.description.query.SQLQuery.processNormalQuery(SQLQuery.java:857)* > * at > org.wso2.carbon.dataservices.core.description.query.SQLQuery.runQuery(SQLQuery.java:2247)* > * at > org.wso2.carbon.dataservices.core.description.query.Query.execute(Query.java:259)* > * at > org.wso2.carbon.dataservices.core.engine.CallQuery.executeElement(CallQuery.java:179)* > * at > org.wso2.carbon.dataservices.core.engine.CallQueryGroup.executeElement(CallQueryGroup.java:111)* > * at > org.wso2.carbon.dataservices.core.engine.OutputElement.execute(OutputElement.java:89)* > * at > org.wso2.carbon.dataservices.core.engine.OutputElementGroup.executeElement(OutputElementGroup.java:106)* > * at > org.wso2.carbon.dataservices.core.engine.OutputElement.execute(OutputElement.java:89)* > * at > org.wso2.carbon.dataservices.core.description.query.Query.writeResultEntry(Query.java:342)* > * at > org.wso2.carbon.dataservices.core.description.query.SQLQuery.processNormalQuery(SQLQuery.java:857)* > * at > org.wso2.carbon.dataservices.core.description.query.SQLQuery.runQuery(SQLQuery.java:2247)* > * at > org.wso2.carbon.dataservices.core.description.query.Query.execute(Query.java:259)* > * at > org.wso2.carbon.dataservices.core.engine.CallQuery.executeElement(CallQuery.java:179)* > * at > org.wso2.carbon.dataservices.core.engine.CallQueryGroup.executeElement(CallQueryGroup.java:111)* > * at > org.wso2.carbon.dataservices.core.engine.OutputElement.execute(OutputElement.java:89)* > * at > org.wso2.carbon.dataservices.core.description.resource.Resource.execute(Resource.java:66)* > * at > org.wso2.carbon.dataservices.core.engine.DataService.invoke(DataService.java:548)* > * at > org.wso2.carbon.dataservices.core.engine.DSOMDataSource.execute(DSOMDataSource.java:101)* > * at > org.wso2.carbon.dataservices.core.engine.DSOMDataSource.serialize(DSOMDataSource.java:112)* > * at > org.wso2.carbon.dataservices.core.engine.DSOMDataSource.serialize(DSOMDataSource.java:85)* > * at > org.apache.axiom.om.impl.llom.OMSourcedElementImpl.serializeAndConsume(OMSourcedElementImpl.java:800)* > * at > org.apache.axis2.transport.http.ApplicationXMLFormatter.writeTo(ApplicationXMLFormatter.java:143)* > * at > org.apache.axis2.transport.http.CommonsHTTPTransportSender.sendUsingOutputStream(CommonsHTTPTransportSender.java:411)* > * at > org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:288)* > * at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:442)* > * at > org.apache.axis2.receivers.AbstractInOutSyncMessageReceiver.invokeBusinessLogic(AbstractInOutSyncMessageReceiver.java:45)* > * at > org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:110)* > * at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:180)* > * at > org.apache.axis2.transport.http.util.RESTUtil.invokeAxisEngine(RESTUtil.java:144)* > * at > org.apache.axis2.transport.http.util.RESTUtil.processURLRequest(RESTUtil.java:139)* > * at > org.apache.axis2.transport.http.AxisServlet$RestRequestProcessor.processURLRequest(AxisServlet.java:837)* > * at > org.wso2.carbon.core.transports.CarbonServlet.handleRestRequest(CarbonServlet.java:303)* > * at > org.wso2.carbon.core.transports.CarbonServlet.doGet(CarbonServlet.java:152)* > * at javax.servlet.http.HttpServlet.service(HttpServlet.java:735)* > * at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)* > * at > org.eclipse.equinox.http.helper.FilterServletAdaptor$FilterChainImpl.doFilter(FilterServletAdaptor.java:56)* > * at > org.wso2.carbon.mashup.jsservices.custom.ui.CustomUIServletFilter.doFilter(CustomUIServletFilter.java:233)* > * at > org.eclipse.equinox.http.helper.FilterServletAdaptor.service(FilterServletAdaptor.java:37)* > * at > org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)* > * at > org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:128)* > * at > org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:68)* > * at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)* > * at > org.wso2.carbon.tomcat.ext.servlet.DelegationServlet.service(DelegationServlet.java:68)* > * at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)* > * at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)* > * at > org.wso2.carbon.tomcat.ext.filter.CharacterSetFilter.doFilter(CharacterSetFilter.java:61)* > * at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)* > * at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)* > * at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)* > * at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)* > * at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)* > * at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)* > * at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)* > * at org.wso2.carbon.ui.valve.XSSValve.invoke(XSSValve.java:118)* > * at org.wso2.carbon.ui.valve.CSRFValve.invoke(CSRFValve.java:72)* > * at > org.wso2.carbon.tomcat.ext.valves.CompositeValve.continueInvocation(CompositeValve.java:178)* > * at > org.wso2.carbon.tomcat.ext.valves.CarbonTomcatValve$1.invoke(CarbonTomcatValve.java:47)* > * at > org.wso2.carbon.webapp.mgt.TenantLazyLoaderValve.invoke(TenantLazyLoaderValve.java:56)* > * at > org.wso2.carbon.tomcat.ext.valves.TomcatValveContainer.invokeValves(TomcatValveContainer.java:47)* > * at > org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:141)* > * at > org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:156)* > * at > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)* > * at > org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:52)* > * at > org.wso2.carbon.tomcat.ext.valves.CarbonTomcatSessionReplicationValve.invoke(CarbonTomcatSessionReplicationValve.java:39)* > * at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)* > * at > org.apache.catalina.ha.tcp.ReplicationValve.invoke(ReplicationValve.java:333)* > * at > org.apache.catalina.ha.session.JvmRouteBinderValve.invoke(JvmRouteBinderValve.java:219)* > * at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)* > * at > org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)* > * at > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)* > * at org.apache.tomcat.util.net > <http://org.apache.tomcat.util.net>.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1653)* > * at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)* > * at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)* > * at java.lang.Thread.run(Thread.java:745)* > *Caused by: java.lang.NullPointerException* > > Any idea on the root cause for such an issue? > > Thanks. > Regards, > Dilhasha > > -- > Fathima Dilhasha > *Software Engineer* > Mobile : +94 (0) 771663314 <%2B94%20%280%29%20773655496> > <%2B94%20%280%29%20773%20451194> > [email protected] <[email protected]> > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- *Madhawa Gunasekara* Software Engineer WSO2 Inc.; http://wso2.com lean.enterprise.middleware mobile: +94 71941102 <+94+71941102> blog: *http://madhawa-gunasekara.blogspot.com <http://madhawa-gunasekara.blogspot.com>* linkedin: *http://lk.linkedin.com/in/mgunasekara <http://lk.linkedin.com/in/mgunasekara>*
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
