Hi All,
I have developed a write back integration using Data Management to load budget values from PBCS to Oracle Financial cloud. But the Export step is failing with below error. I can see some connection timed out error. But not sure why I am getting it. My source and target applications are configured perfectly.
Can any one help me in resolving this issue.
2017-06-15 14:24:33,045 INFO [AIF]: Standard Error: com.sun.xml.ws.streaming.XMLStreamReaderException: XML reader error: com.ctc.wstx.exc.WstxIOException: Connection timed out (Connection timed out)
at com.sun.xml.ws.streaming.XMLStreamReaderUtil.wrapException(XMLStreamReaderUtil.java:267)
at com.sun.xml.ws.streaming.XMLStreamReaderUtil.next(XMLStreamReaderUtil.java:95)
at com.sun.xml.ws.streaming.XMLStreamReaderUtil.nextContent(XMLStreamReaderUtil.java:110)
at com.sun.xml.ws.streaming.XMLStreamReaderUtil.nextElementContent(XMLStreamReaderUtil.java:100)
at com.sun.xml.ws.wsdl.parser.RuntimeWSDLParser.hasWSDLDefinitions(RuntimeWSDLParser.java:232)
at com.sun.xml.ws.wsdl.parser.RuntimeWSDLParser.parse(RuntimeWSDLParser.java:139)
at com.sun.xml.ws.client.WSServiceDelegate.parseWSDL(WSServiceDelegate.java:284)
at com.sun.xml.ws.client.WSServiceDelegate.<init>(WSServiceDelegate.java:246)
at com.sun.xml.ws.client.WSServiceDelegate.<init>(WSServiceDelegate.java:197)
at com.sun.xml.ws.client.WSServiceDelegate.<init>(WSServiceDelegate.java:187)
at weblogic.wsee.jaxws.spi.WLSServiceDelegate.<init>(WLSServiceDelegate.java:86)
at weblogic.wsee.jaxws.spi.WLSProvider$ServiceDelegate.<init>(WLSProvider.java:632)
at weblogic.wsee.jaxws.spi.WLSProvider.createServiceDelegate(WLSProvider.java:143)
at weblogic.wsee.jaxws.spi.WLSProvider.createServiceDelegate(WLSProvider.java:117)
at weblogic.wsee.jaxws.spi.WLSProvider.createServiceDelegate(WLSProvider.java:88)
at javax.xml.ws.Service.<init>(Service.java:77)
at com.hyperion.aif.ws.client.ErpIntegrationService.ErpIntegrationService_Service.<init>(ErpIntegrationService_Service.java:74)
at com.hyperion.aif.fusion.FusionAdapter.<init>(FusionAdapter.java:548)
at com.hyperion.aif.fusion.FusionAdapter.main(FusionAdapter.java:106)
Caused by: com.ctc.wstx.exc.WstxIOException: Connection timed out (Connection timed out)
at com.ctc.wstx.sr.StreamScanner.throwFromIOE(StreamScanner.java:672)
at com.ctc.wstx.sr.ValidatingStreamReader.findDtdExtSubset(ValidatingStreamReader.java:472)
at com.ctc.wstx.sr.ValidatingStreamReader.finishDTD(ValidatingStreamReader.java:336)
at com.ctc.wstx.sr.BasicStreamReader.skipToken(BasicStreamReader.java:3327)
at com.ctc.wstx.sr.BasicStreamReader.nextFromProlog(BasicStreamReader.java:1950)
at com.ctc.wstx.sr.BasicStreamReader.next(BasicStreamReader.java:1106)
at com.sun.xml.ws.util.xml.XMLStreamReaderFilter.next(XMLStreamReaderFilter.java:92)
at com.sun.xml.ws.streaming.XMLStreamReaderUtil.next(XMLStreamReaderUtil.java:89)
... 17 more
Caused by: java.net.ConnectException: Connection timed out (Connection timed out)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at java.net.Socket.connect(Socket.java:538)
at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:463)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:558)
at sun.net.www.http.HttpClient.<init>(HttpClient.java:242)
at sun.net.www.http.HttpClient.New(HttpClient.java:339)
at sun.net.www.http.HttpClient.New(HttpClient.java:357)
at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:1202)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect0(HttpURLConnection.java:1138)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:1032)
at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:966)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream0(HttpURLConnection.java:1546)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1474)
at java.net.URL.openStream(URL.java:1045)
at com.ctc.wstx.util.URLUtil.inputStreamFromURL(URLUtil.java:119)
at com.ctc.wstx.io.DefaultInputResolver.sourceFromURL(DefaultInputResolver.java:254)
at com.ctc.wstx.io.DefaultInputResolver.resolveEntity(DefaultInputResolver.java:92)
at com.ctc.wstx.sr.ValidatingStreamReader.findDtdExtSubset(ValidatingStreamReader.java:463)
... 23 more
2017-06-15 14:24:33,046 ERROR [AIF]: The script has failed to execute:
2017-06-15 14:24:33,050 FATAL [AIF]: Error in Comm.executeJythonScript
Traceback (most recent call last):
File "<string>", line 557, in executeJythonScript
File "/u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py", line 154, in <module>
fusionCloudAdapter.exportDataToFusion()
File "/u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py", line 60, in exportDataToFusion
self.fusionCloudHelper("exportDataToFusion")
File "/u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py", line 120, in fusionCloudHelper
raise RuntimeError
RuntimeError
2017-06-15 14:24:33,051 FATAL [AIF]: Error in CommData.exportData
Traceback (most recent call last):
File "<string>", line 4007, in exportData
File "<string>", line 475, in executeFusionService
File "<string>", line 557, in executeJythonScript
File "/u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py", line 154, in <module>
fusionCloudAdapter.exportDataToFusion()
File "/u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py", line 60, in exportDataToFusion
self.fusionCloudHelper("exportDataToFusion")
File "/u02/Oracle/Middleware/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py", line 120, in fusionCloudHelper
raise RuntimeError
RuntimeError
2017-06-15 14:24:33,052 DEBUG [AIF]: CommData.updateWorkflow - START
2017-06-15 14:24:33,052 DEBUG [AIF]:
UPDATE TLOGPROCESS
SET PROCESSENDTIME=CURRENT_TIMESTAMP
,PROCESSSTATUS=22,PROCESSEXP=0
,PROCESSEXPNOTE='AIF_WF_EXP_EXPORT_ERR'
WHERE PARTITIONKEY=14 AND CATKEY=6 AND PERIODKEY='2017-05-31' AND RULE_ID=10
2017-06-15 14:24:33,056 DEBUG [AIF]: CommData.updateWorkflow - END
2017-06-15 14:24:33,156 DEBUG [AIF]: Comm.finalizeProcess - START
2017-06-15 14:24:33,156 DEBUG [AIF]: CommData.updateRuleStatus - START
2017-06-15 14:24:33,156 DEBUG [AIF]:
UPDATE AIF_BALANCE_RULES
SET STATUS = CASE 'FAILED'
WHEN 'SUCCESS' THEN
CASE ( SELECT COUNT(*) FROM AIF_PROCESS_DETAILS pd WHERE pd.PROCESS_ID = 272 AND pd.STATUS IN ('FAILED','WARNING') )
WHEN 0 THEN 'SUCCESS'
ELSE ( SELECT MIN(pd.STATUS) FROM AIF_PROCESS_DETAILS pd WHERE pd.PROCESS_ID = 272 AND pd.STATUS IN ('FAILED','WARNING') ) END
ELSE 'FAILED' END
WHERE RULE_ID = 10
2017-06-15 14:24:33,162 DEBUG [AIF]: CommData.updateRuleStatus - END
2017-06-15 14:24:33,162 FATAL [AIF]: Error in COMM Export Data
2017-06-15 14:24:33,162 DEBUG [AIF]: Comm.updateProcess - START
2017-06-15 14:24:33,165 DEBUG [AIF]: Comm.updateProcess - END
2017-06-15 14:24:33,167 DEBUG [AIF]: The fdmAPI connection has been closed.
2017-06-15 14:24:33,167 INFO [AIF]: FDMEE Process End, Process ID: 272
Thanks
Sri