10:50:00.184 ERROR [bwEngThread:In-Memory Process Worker-2] com.tibco.bw.core -
<Data>
<ns0:JDBCConnectionNotFoundException xmlns:ns0="http://schemas.tibco.com/bw/plugins/jdbc/5.0/jdbcExceptions">
    <msg>Could not create Connection to server using Shared Resource [jdbcProperty].-{ActivityName=JDBCQuery, ProcessName=sql_server.Process, ModuleName=sql_server}</msg>
    <msgCode>TIBCO-BW-PALETTE-JDBC-500011</msgCode>
    <jdbcConnection>jdbcProperty</jdbcConnection>
</ns0:JDBCConnectionNotFoundException>
</Data>
TIBCO-BW-CORE-500050: The BW process [sql_server.Process] instance faulted, JobId [bw0a100], ProcessInstanceId [bw0a100], ParentProcessInstanceId [-], Module [sql_server:1.0.0.20180327150642], Application [sql_server.application:1.0].
   <CausedBy> TIBCO-BW-CORE-500051: Activity [JDBCQuery] fault.
   <CausedBy> com.tibco.bw.palette.jdbc.runtime.faults.JDBCConnectionNotFoundFault: Could not create Connection to server using Shared Resource [jdbcProperty].-{ActivityName=JDBCQuery, ProcessName=sql_server.Process, ModuleName=sql_server}
   <CausedBy> com.tibco.bw.sharedresource.jdbc.runtime.exceptions.ConnectionCreateException: tibcosoftwareinc.jdbc.sqlserverbase.dden: [tibcosoftwareinc][SQLServer JDBC Driver]Error establishing socket. Unknown host: vpalkar-z200
   <CausedBy> tibcosoftwareinc.jdbc.sqlserverbase.dden: [tibcosoftwareinc][SQLServer JDBC Driver]Error establishing socket. Unknown host: vpalkar-z200

Error establishing socket. Unknown host: vpalkar-z200

docker

The reason could be that the docker container may not able to resolve the hostname properly. This can be resolved by adding hostname and IP address in host file of the docker container.

Use below docker run command to make hostname and IP address entry in container's host file:

sudo docker run --add-host vpalkar-z200:10.97.122.140 -e "BW_PROFILE=docker" -e "DBURL=jdbc:tibcosoftwareinc:sqlserver://vpalkar-z200:1433;DatabaseName=master" sql_db_test