Data Access Failure

### Error querying database. Cause: com.edb.util.PSQLException: ERROR: OCI error: ORA-12543: TNS:destination host unreachable ### The error may exist in URL [jar:file:/engn001/lena/1.3/servers/doctor-prod-pri-was-svr-01/webapps/ROOT/WEB-INF/lib/dr-core-1.0-SNAPSHOT.jar!/mappers/dr/stats/StatsSQL.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: with TEMP_TABLE AS (SELECT UNION_CD_NM, UNION_CD FROM VCS_FULL_COUNTRY_LIST) SELECT A.CFMT_NTN_CD, tt.UNION_CD_NM AS CFMT_NTN_NM, A.TOTAL, ROUND(100 * A.TOTAL / NULLIF(SUM(A.TOTAL) OVER (), 0), 2) AS AVG FROM ( SELECT CFMT_NTN_CD, COUNT(*) AS TOTAL FROM( SELECT CFMT_NTN_CD FROM TDI_DR_DGR_DCL WHERE PRS_STATUS_CD IN ('90', '02', '12', '19') AND CFMT_NTN_CD IS NOT NULL )GROUP BY CFMT_NTN_CD ORDER BY TOTAL DESC ) A LEFT OUTER JOIN TEMP_TABLE tt ON tt.UNION_CD = A.CFMT_NTN_CD WHERE A.CFMT_NTN_CD IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? ) ### Cause: com.edb.util.PSQLException: ERROR: OCI error: ORA-12543: TNS:destination host unreachable ; uncategorized SQLException for SQL []; SQL state [25000]; error code [0]; ERROR: OCI error: ORA-12543: TNS:destination host unreachable ; nested exception is com.edb.util.PSQLException: ERROR: OCI error: ORA-12543: TNS:destination host unreachable

« Back