Support #12043: [SCP ID :##5907##] : Error when calling API - PayNet RPPBO Support - Penril Support System

Support #12043

[SCP ID :##5907##] : Error when calling API

Added by Zahir Abd Latif about 3 years ago. Updated about 3 years ago.

Status:

Closed - End of life cycle

Start date:

June 29, 2021

Priority:

Normal

Due date:

Assignee:

Zahir Abd Latif

% Done:

100%

Category:

Spent time:

12.00 hours

Target version:

Description

Hi,
Kindly attend below request:-

When we are calling for the API from BO portal, we hit below error.

2021/06/29 12:04:58:769 ERROR stderr: javax.xml.ws.soap.SOAPFaultException: Unmarshalling Error: For input string: ""
2021/06/29 12:04:58:773 ERROR stderr: at org.apache.cxf.jaxws.JaxWsClientProxy.invoke(JaxWsClientProxy.java:161)
2021/06/29 12:04:58:773 ERROR stderr: at com.sun.proxy.$Proxy72.queryLiquidityTotals(Unknown Source)
2021/06/29 12:04:58:774 ERROR stderr: at net.penril.liquidity.service.ESBQueryLiquidityTotalsService.invokeWsOperation(ESBQueryLiquidityTotalsService.java:117)
2021/06/29 12:04:58:774 ERROR stderr: at net.penril.liquidity.service.ESBQueryLiquidityTotalsService.invokeWsOperation(ESBQueryLiquidityTotalsService.java:26)
2021/06/29 12:04:58:774 ERROR stderr: at com.ib.enterprise.services.integration.WsIntegrationService.retrieve(WsIntegrationService.java:98)
2021/06/29 12:04:58:774 ERROR stderr: at com.rpp.enterprise.services.ss110_settlement_status.RPPSettlementStatusMainServices.execute(RPPSettlementStatusMainServices.java:128)
2021/06/29 12:04:58:775 ERROR stderr: at com.rpp.controller.actions.ss110_settlement_status.RPPSettlementStatusMainAction.execute(RPPSettlementStatusMainAction.java:97)
2021/06/29 12:04:58:775 ERROR stderr: at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
2021/06/29 12:04:58:775 ERROR stderr: at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
2021/06/29 12:04:58:776 ERROR stderr: at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
2021/06/29 12:04:58:776 ERROR stderr: at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
2021/06/29 12:04:58:776 ERROR stderr: at com.rpp.common.utils.RPPActionServlet.doPost(RPPActionServlet.java:81)
2021/06/29 12:04:58:776 ERROR stderr: at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
2021/06/29 12:04:58:777 ERROR stderr: at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
2021/06/29 12:04:58:777 ERROR stderr: at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
2021/06/29 12:04:58:777 ERROR stderr: at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
2021/06/29 12:04:58:778 ERROR stderr: at com.rpp.common.utils.SetSessionTimeout.doFilter(SetSessionTimeout.java:71)
2021/06/29 12:04:58:778 ERROR stderr: at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
2021/06/29 12:04:58:778 ERROR stderr: at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
2021/06/29 12:04:58:778 ERROR stderr: at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
2021/06/29 12:04:58:779 ERROR stderr: at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
2021/06/29 12:04:58:779 ERROR stderr: at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:64)
2021/06/29 12:04:58:779 ERROR stderr: at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
2021/06/29 12:04:58:780 ERROR stderr: at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
2021/06/29 12:04:58:781 ERROR stderr: at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
2021/06/29 12:04:58:781 ERROR stderr: at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)
2021/06/29 12:04:58:782 ERROR stderr: at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
2021/06/29 12:04:58:782 ERROR stderr: at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
2021/06/29 12:04:58:783 ERROR stderr: at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
2021/06/29 12:04:58:783 ERROR stderr: at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
2021/06/29 12:04:58:783 ERROR stderr: at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
2021/06/29 12:04:58:783 ERROR stderr: at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
2021/06/29 12:04:58:784 ERROR stderr: at io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50)
2021/06/29 12:04:58:784 ERROR stderr: at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
2021/06/29 12:04:58:784 ERROR stderr: at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
2021/06/29 12:04:58:785 ERROR stderr: at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
2021/06/29 12:04:58:785 ERROR stderr: at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
2021/06/29 12:04:58:785 ERROR stderr: at org.wildfly.extension.undertow.deployment.GlobalRequestControllerHandler.handleRequest(GlobalRequestControllerHandler.java:68)
2021/06/29 12:04:58:786 ERROR stderr: at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
2021/06/29 12:04:58:786 ERROR stderr: at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292)
2021/06/29 12:04:58:787 ERROR stderr: at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81)
2021/06/29 12:04:58:787 ERROR stderr: at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138)
2021/06/29 12:04:58:787 ERROR stderr: at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)
2021/06/29 12:04:58:788 ERROR stderr: at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
2021/06/29 12:04:58:788 ERROR stderr: at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
2021/06/29 12:04:58:788 ERROR stderr: at org.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda$create$0(SecurityContextThreadSetupAction.java:105)
2021/06/29 12:04:58:788 ERROR stderr: at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1508)
2021/06/29 12:04:58:789 ERROR stderr: at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1508)
2021/06/29 12:04:58:789 ERROR stderr: at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1508)
2021/06/29 12:04:58:791 ERROR stderr: at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1508)
2021/06/29 12:04:58:791 ERROR stderr: at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272)
2021/06/29 12:04:58:791 ERROR stderr: at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81)
2021/06/29 12:04:58:792 ERROR stderr: at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104)
2021/06/29 12:04:58:792 ERROR stderr: at io.undertow.server.Connectors.executeRootHandler(Connectors.java:330)
2021/06/29 12:04:58:792 ERROR stderr: at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:812)
2021/06/29 12:04:58:793 ERROR stderr: at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
2021/06/29 12:04:58:793 ERROR stderr: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
2021/06/29 12:04:58:793 ERROR stderr: at java.lang.Thread.run(Thread.java:748)
2021/06/29 12:04:58:794 ERROR stderr: Caused by: javax.xml.bind.UnmarshalException
2021/06/29 12:04:58:794 ERROR stderr: - with linked exception:
2021/06/29 12:04:58:794 ERROR stderr: [com.sun.istack.SAXParseException2; lineNumber: 1; columnNumber: 724; For input string: ""]
2021/06/29 12:04:58:794 ERROR stderr: at com.sun.xml.bind.v2.runtime.unmarshaller.UnmarshallerImpl.handleStreamException(UnmarshallerImpl.java:483)
2021/06/29 12:04:58:795 ERROR stderr: at com.sun.xml.bind.v2.runtime.unmarshaller.UnmarshallerImpl.unmarshal0(UnmarshallerImpl.java:417)
2021/06/29 12:04:58:795 ERROR stderr: at com.sun.xml.bind.v2.runtime.unmarshaller.UnmarshallerImpl.unmarshal(UnmarshallerImpl.java:394)
2021/06/29 12:04:58:795 ERROR stderr: at org.apache.cxf.jaxb.JAXBEncoderDecoder.doUnmarshal(JAXBEncoderDecoder.java:857)
2021/06/29 12:04:58:797 ERROR stderr: at org.apache.cxf.jaxb.JAXBEncoderDecoder.access$100(JAXBEncoderDecoder.java:102)
2021/06/29 12:04:58:797 ERROR stderr: at org.apache.cxf.jaxb.JAXBEncoderDecoder$2.run(JAXBEncoderDecoder.java:896)
2021/06/29 12:04:58:797 ERROR stderr: at java.security.AccessController.doPrivileged(Native Method)
2021/06/29 12:04:58:798 ERROR stderr: at org.apache.cxf.jaxb.JAXBEncoderDecoder.unmarshall(JAXBEncoderDecoder.java:894)
2021/06/29 12:04:58:798 ERROR stderr: at org.apache.cxf.jaxb.JAXBEncoderDecoder.unmarshall(JAXBEncoderDecoder.java:714)
2021/06/29 12:04:58:798 ERROR stderr: at org.apache.cxf.jaxb.io.DataReaderImpl.read(DataReaderImpl.java:179)
2021/06/29 12:04:58:798 ERROR stderr: at org.apache.cxf.wsdl.interceptors.DocLiteralInInterceptor.handleMessage(DocLiteralInInterceptor.java:194)
2021/06/29 12:04:58:799 ERROR stderr: at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308)
2021/06/29 12:04:58:799 ERROR stderr: at org.apache.cxf.endpoint.ClientImpl.onMessage(ClientImpl.java:805)
2021/06/29 12:04:58:799 ERROR stderr: at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.handleResponseInternal(HTTPConduit.java:1684)
2021/06/29 12:04:58:800 ERROR stderr: at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.handleResponse(HTTPConduit.java:1560)
2021/06/29 12:04:58:800 ERROR stderr: at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.close(HTTPConduit.java:1361)
2021/06/29 12:04:58:800 ERROR stderr: at org.apache.cxf.transport.AbstractConduit.close(AbstractConduit.java:56)
2021/06/29 12:04:58:800 ERROR stderr: at org.apache.cxf.transport.http.HTTPConduit.close(HTTPConduit.java:658)
2021/06/29 12:04:58:801 ERROR stderr: at org.apache.cxf.interceptor.MessageSenderInterceptor$MessageSenderEndingInterceptor.handleMessage(MessageSenderInterceptor.java:62)
2021/06/29 12:04:58:801 ERROR stderr: at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308)
2021/06/29 12:04:58:802 ERROR stderr: at org.apache.cxf.endpoint.ClientImpl.doInvoke(ClientImpl.java:518)
2021/06/29 12:04:58:802 ERROR stderr: at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:427)
2021/06/29 12:04:58:802 ERROR stderr: at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:328)
2021/06/29 12:04:58:803 ERROR stderr: at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:281)
2021/06/29 12:04:58:803 ERROR stderr: at org.apache.cxf.frontend.ClientProxy.invokeSync(ClientProxy.java:96)
2021/06/29 12:04:58:803 ERROR stderr: at org.apache.cxf.jaxws.JaxWsClientProxy.invoke(JaxWsClientProxy.java:139)
2021/06/29 12:04:58:804 ERROR stderr: ... 57 more
2021/06/29 12:04:58:804 ERROR stderr: Caused by: com.sun.istack.SAXParseException2; lineNumber: 1; columnNumber: 724; For input string: ""
2021/06/29 12:04:58:804 ERROR stderr: at com.sun.xml.bind.v2.runtime.unmarshaller.UnmarshallingContext.handleEvent(UnmarshallingContext.java:743)
2021/06/29 12:04:58:805 ERROR stderr: at com.sun.xml.bind.v2.runtime.unmarshaller.UnmarshallingContext.handleError(UnmarshallingContext.java:770)
2021/06/29 12:04:58:805 ERROR stderr: at com.sun.xml.bind.v2.runtime.unmarshaller.UnmarshallingContext.handleError(UnmarshallingContext.java:766)
2021/06/29 12:04:58:805 ERROR stderr: at com.sun.xml.bind.v2.runtime.unmarshaller.Loader.handleParseConversionException(Loader.java:275)
2021/06/29 12:04:58:806 ERROR stderr: at com.sun.xml.bind.v2.runtime.unmarshaller.TextLoader.text(TextLoader.java:73)
2021/06/29 12:04:58:806 ERROR stderr: at com.sun.xml.bind.v2.runtime.unmarshaller.UnmarshallingContext.text(UnmarshallingContext.java:589)
2021/06/29 12:04:58:806 ERROR stderr: at com.sun.xml.bind.v2.runtime.unmarshaller.StAXStreamConnector.processText(StAXStreamConnector.java:338)
2021/06/29 12:04:58:806 ERROR stderr: at com.sun.xml.bind.v2.runtime.unmarshaller.StAXStreamConnector.handleEndElement(StAXStreamConnector.java:216)
2021/06/29 12:04:58:807 ERROR stderr: at com.sun.xml.bind.v2.runtime.unmarshaller.StAXStreamConnector.bridge(StAXStreamConnector.java:185)
2021/06/29 12:04:58:807 ERROR stderr: at com.sun.xml.bind.v2.runtime.unmarshaller.UnmarshallerImpl.unmarshal0(UnmarshallerImpl.java:415)
2021/06/29 12:04:58:807 ERROR stderr: ... 81 more
2021/06/29 12:04:58:808 ERROR stderr: Caused by: javax.xml.bind.UnmarshalException: For input string: ""
2021/06/29 12:04:58:808 ERROR stderr: - with linked exception:
2021/06/29 12:04:58:808 ERROR stderr: [java.lang.NumberFormatException: For input string: ""]
2021/06/29 12:04:58:809 ERROR stderr: ... 91 more
2021/06/29 12:04:58:809 ERROR stderr: Caused by: java.lang.NumberFormatException: For input string: ""
2021/06/29 12:04:58:809 ERROR stderr: at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
2021/06/29 12:04:58:810 ERROR stderr: at java.lang.Long.parseLong(Long.java:601)
2021/06/29 12:04:58:810 ERROR stderr: at java.lang.Long.valueOf(Long.java:803)
2021/06/29 12:04:58:810 ERROR stderr: at com.sun.xml.bind.DatatypeConverterImpl._parseLong(DatatypeConverterImpl.java:132)
2021/06/29 12:04:58:811 ERROR stderr: at com.sun.xml.bind.v2.model.impl.RuntimeBuiltinLeafInfoImpl$18.parse(RuntimeBuiltinLeafInfoImpl.java:751)
2021/06/29 12:04:58:811 ERROR stderr: at com.sun.xml.bind.v2.model.impl.RuntimeBuiltinLeafInfoImpl$18.parse(RuntimeBuiltinLeafInfoImpl.java:749)
2021/06/29 12:04:58:811 ERROR stderr: at com.sun.xml.bind.v2.runtime.unmarshaller.TextLoader.text(TextLoader.java:69)
2021/06/29 12:04:58:811 ERROR stderr: ... 86 more
2021/06/29 12:04:58:812 ERROR enterprise.services.integration.WsIntegrationService: javax.xml.ws.soap.SOAPFaultException: Unmarshalling Error: For input string: ""

When we call direct to the API, we able to get the data as below.
return code = 00-Success
Liquidity Actual = 50000000
Liquidity Calculated Settled = 999998446.9
Liquidity Calculated Available = 99998446.9
Time Liquidity Actual = Thu Jan 01 07:30:00 SGT 1970
Time Liquidity Settled = Thu Nov 19 18:05:51 SGT 2020
Time Liquidity AvailableThu Nov 19 18:05:50 SGT 2020

After checking with ACI, ACI mentioned the LastmodifiedLiquidityActual is optional field.
Why is portal hitting javax.xml.ws.soap.SOAPFaultException: Unmarshalling Error: For input string: "" ?

History

#1 Updated by Ngoh Chee Ping about 3 years ago

Status changed from New - Begin Life Cycle to Investigation
Assignee changed from Ngoh Chee Onn to Ngoh Chee Ping

#2 Updated by Ngoh Chee Ping about 3 years ago

Assignee changed from Ngoh Chee Ping to Zahir Abd Latif
% Done changed from 0 to 100

Fixed the issues with root cause and solution below:

Release:
server 172.16.100.122 under the "/logs/backoffice/release/20210630" folder.

Root Cause:
Due to lastmodified_liquidity_actual field return by ACI is in empty string format "", causing cxf not able to parse it to Long.

Solution:
Update lastmodified_liquidity_actual field mapping to be String data type and update the lastmodified_liquidity_actual field in xsd that provided by ACI to string data type also.

#3 Updated by Zahir Abd Latif about 3 years ago

Status changed from Investigation to Development / Work In Progress

#4 Updated by Zahir Abd Latif about 3 years ago

Status changed from Development / Work In Progress to Closed - End of life cycle

Issue closed in SCP.

Also available in: Atom PDF

B - Production Support » PayNet RPPBO Support

Issues