Aps.bat Does Not Run from command line (Doc ID 1556462.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.3.1.4 and later
Information in this document applies to any platform.

Goal

Customer is on 7.3.1.4
When they try to run the aps.bat from the command line (APS.BAT EXPORT_DATA HDZ_EXPORT_AP HDZ_EXPORT_AP), they get the following error


2013-04-29 11:56:14,127 CDT main FATAL appserver.fatal: The system had failed to establish connection to the configured datadase settings (in the DataSource.properties configuration file). Please verify database details settings.
java.sql.SQLException: The Network Adapter could not establish the connection
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:525)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:508)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:275)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:206)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:156)
at com.demantra.applicationServer.connection.DBConnectionFactory.createConnection(DBConnectionFactory.java:169)
at com.demantra.applicationServer.connection.DBConnectionFactory.createConnection(DBConnectionFactory.java:147)
at com.demantra.applicationServer.connection.JDBCConnection.getConnection(JDBCConnection.java:75)
at com.demantra.applicationServer.system.apsparams.ApsParamsLoaderDBImpl.buildParamsMap(ApsParamsLoaderDBImpl.java:1458)
at com.demantra.applicationServer.system.apsparams.ApsParamsLoaderDBImpl.reloadParams(ApsParamsLoaderDBImpl.java:245)
at com.demantra.applicationServer.system.apsparams.ApsParamsLoaderDBImpl.initParams(ApsParamsLoaderDBImpl.java:219)
at com.demantra.applicationServer.services.CommonProp.(CommonProp.java:1242)
at com.demantra.applicationServer.metaDataObjects.component.ComponentsList.(ComponentsList.java:210)
at com.demantra.applicationServer.metaDataObjects.component.ComponentsList.loadObjects(ComponentsList.java:1822)
at com.demantra.applicationServer.metaDataObjects.component.ComponentsList.getInstance(ComponentsList.java:191)
at com.demantra.applicationServer.start.main.StartIntegration.startComponent(StartIntegration.java:182)
at com.demantra.applicationServer.start.main.APSStandalone.main(APSStandalone.java:88)
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:328)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:421)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:630)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:206)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)
... 19 more
Caused by: java.net.UnknownHostException: dmdesarrollo


The Data source is configured properly and with the same set up and credentials one can connect to the DB with SQLPlus and SQL Developper. SP_CONFIG.BAT also connects allowing the user to change the Table Space Settings, Mail Settings and General Settings.

The customer is able to run the same integration interface through a workflow with a Transfer step. It is only when they run it from the command line that the issue occurs
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms