OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » XDOLoader error for eTEXT template download

Home » Applications » Oracle Fusion Apps & E-Business Suite » XDOLoader error for eTEXT template download (Oracle EBS R12.2.8 Windows server 2012R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

XDOLoader error for eTEXT template download [message #686986]

Fri, 10 February 2023 09:43

ccpCCP88
Messages: 11
Registered: January 2023

Junior Member

I am getting an exception on using XDOLoader utility to downlaodan data template

java oracle.apps.xdo.oa.util.XDOLoader DOWNLOAD -DB_USERNAME apps -DB_PASSWORD devapps -JDBC_CONNECTION "devcgffinapp01.xx.com:PORT=1521:prod" -LOB_TYPEDATA_TEMPLATE -APPS_SHORT_NAME "oks" -LOB_CODE <lob_code> -LANGUAGE us -TERRITORY GB -LOG_FILE d.log -DEBUG true

and got error:
XDOLoader started: Fri Feb 10 10:13:51 EST 2023

Parameters passed to XDOLoader...
[DB_USERNAME] [apps]
[LOB_CODE] [XXOKS_BALANCE_REPORT]
[DOWNLOAD] [DOWNLOAD]
[JDBC_CONNECTION] ['(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=devcgffinapp01.flexjetnet.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=prod)))']
[LANGUAGE] [en]
[DB_PASSWORD] [******]
[LOB_TYPE] [DATA_TEMPLATE]
[LOG_FILE] [XXOKS_BALANCE_REPORT_DLOG]
[lct_FILE] [E:\ebs122\fs1\EBSapps\appl\xdo\12.0.0/patch/115/import/xdotmpl.lct]
[APPS_SHORT_NAME] [oks]

java.sql.SQLRecoverableException: IO Error: SO Exception was generated
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:490)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:678)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:235)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at oracle.apps.xdo.oa.util.XDOLoader.initAppsContext(XDOLoader.java:582)
at oracle.apps.xdo.oa.util.XDOLoader.init(XDOLoader.java:474)
at oracle.apps.xdo.oa.util.XDOLoader.<init>(XDOLoader.java:432)
at oracle.apps.xdo.oa.util.XDOLoader.main(XDOLoader.java:2421)
Caused by: oracle.net.ns.NetException: SO Exception was generated
at oracle.net.resolver.AddrResolution.resolveAddrTree(AddrResolution.java:635)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:427)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:732)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:259)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1230)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:327)
... 10 more

Can anyone help me to fix this error? Thanks

Report message to a moderator