cat_gon Respected Contributor.
Respected Contributor.
452 views

Unable to read FS from Webservice

Jump to solution

Hi All,

 

We are using a webservice to update FS, however just for one project we are getting an error and not able to read the FS based on the serverlog.

 

Other FS are fine but not this particular project. Therefor I think it is something in the project setting that is causing the problem. Any suggestion is much appreciated.

 

ReadFinancialSummaryResponseDocument responseDoc = stub.readFinancialSummary(requestDoc)

And there is no server response, instead we get this from server log:

 

ERROR JSESSIONID=6C09B826C702403692BAAD0EF8018D66.Staging_Primary_UserNode3,USERNAME=:http-0.0.0.0-8082-Processor15:(FinanceExceptionHandler.java:35):2017/06/23-22:54:53.780 EST: Unknown
java.lang.NullPointerException
 at com.mercury.itg.ws.fm.util.BeanUtils.convert(BeanUtils.java:457)
 at com.mercury.itg.ws.fm.FSAbstractReadOperation.readBenefit(FSAbstractReadOperation.java:97)
 at com.mercury.itg.ws.fm.FSReadOperation.execute(FSReadOperation.java:55)
 at com.mercury.itg.ws.fm.FinanceService.readFinancialSummary(FinanceService.java:65)
 at com.mercury.itg.ws.fm.FinanceServiceMessageReceiverInOut.jibxReceiver11(FinanceServiceMessageReceiverInOut.java:955)
 at com.mercury.itg.ws.fm.FinanceServiceMessageReceiverInOut.invokeBusinessLogic(FinanceServiceMessageReceiverInOut.java:154)
 at org.apache.axis2.receivers.AbstractInOutSyncMessageReceiver.receive(AbstractInOutSyncMessageReceiver.java:39)
 at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:497)
 at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:328)
 at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:254)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.mercury.itg.servlet.WebServicesFilter.doFilter(WebServicesFilter.java:84)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.kintana.core.web.filter.BrowserCompatibilityFilter.applyFilter(BrowserCompatibilityFilter.java:34)
 at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:68)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.kintana.core.web.filter.MLUFilter.applyFilter(MLUFilter.java:115)
 at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:68)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.kintana.core.web.filter.stinger.ValidationFilter.applyFilter(ValidationFilter.java:217)
 at com.kintana.core.web.filter.stinger.ValidationFilter.doFilter(ValidationFilter.java:118)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.kintana.core.web.filter.MultipartRequestFilter.applyFilter(MultipartRequestFilter.java:81)
 at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:68)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.kintana.core.web.filter.ControlFilter.applyFilter(ControlFilter.java:723)
 at com.kintana.core.web.filter.ControlFilter.doFilter(ControlFilter.java:1584)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.mercury.itg.servlet.I18NFilter.doFilter(I18NFilter.java:46)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.kintana.core.web.filter.SchemeBasedRedirectFilter.doFilter(SchemeBasedRedirectFilter.java:75)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.kintana.core.web.filter.Log4jFilter.applyFilter(Log4jFilter.java:56)
 at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:68)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
 at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
 at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
 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:174)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)
 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:689)
 at java.lang.Thread.run(Thread.java:745)

 

Thanks.

 

Cath

0 Likes
1 Solution

Accepted Solutions
Established Member.. von Thadden
Established Member..

Re: Unable to read FS from Webservice

Jump to solution

Dear Cath,

the exception sound like something happens when it reads benefit data from the database and packs it into the XML structure. I'd suspect a database integrity issue, e.g., that the benefit record for this financial summary does not exist.

The following query should not return any records if your DB is consistent here. If it returns the FS that throughs the error then work with product support to get your DB consistent again.

select *
from
FM_FINANCIAL_SUMMARY fs,
FM_BENEFITS ben
where
fs.BENEFIT_ID = ben.BENEFIT_ID (+)
and ben.BENEFIT_ID is null
;

Best regards

Kai

0 Likes
2 Replies
Established Member.. von Thadden
Established Member..

Re: Unable to read FS from Webservice

Jump to solution

Dear Cath,

the exception sound like something happens when it reads benefit data from the database and packs it into the XML structure. I'd suspect a database integrity issue, e.g., that the benefit record for this financial summary does not exist.

The following query should not return any records if your DB is consistent here. If it returns the FS that throughs the error then work with product support to get your DB consistent again.

select *
from
FM_FINANCIAL_SUMMARY fs,
FM_BENEFITS ben
where
fs.BENEFIT_ID = ben.BENEFIT_ID (+)
and ben.BENEFIT_ID is null
;

Best regards

Kai

0 Likes
cat_gon Respected Contributor.
Respected Contributor.

Re: Unable to read FS from Webservice

Jump to solution

Hello Kai,

Thank you for your time on this.

The query you provided returned no result. However, since you mentioned that issue could be related to benefit I focused on that area.

The WS works fine when I load/open the benefit before calling the WS. Looks like something is getting refreshed at the backend. I did not investigate further on why is there such behaviour but still my main issue is now resolved.

Thanks for your inputs.

Cath

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.