Announcement

Collapse
No announcement yet.

run dbpatch_55.sql catch IO exception

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • chrisplough
    replied
    Re: run dbpatch_55.sql catch IO exception

    Catherine,

    This error indicates that the Java code that the OTM script runs is not able to make a connection with the database server. This code is used to update the OTM DB content from CSV files.

    This error could be caused by:
    • Incorrect DB parameters entered during the OTM installation, including hostname, port and/or SID. These are located in D:\otm55\glog\config\glog.properties
    • The Oracle DB is not running
    • A firewall is between the OTM App and DB server, which is blocking the traffic
    --Chris

    Leave a comment:


  • pjh1029
    started a topic run dbpatch_55.sql catch IO exception

    run dbpatch_55.sql catch IO exception

    Hi,
    When I run the SQL: @dbpatch_55.sql after I run . ./gc3env.cmd
    I find exception: java.sql.SQLException: Io Exception: The Network Adapter could not establish the connection. Please give me some advice. Thank you very much.
    The following update_content.log is
    --------------------------------------------------
    update_content_otmdb_252007_1546.log
    ECHO is off.
    ECHO is off.
    Parameters:
    Properties directory: D:\otm55\glog\config
    Connection ID for GLOGOWNER: dbaglogowner
    Connection ID for REPORTOWNER: dbareportowner
    Version: V55P
    ECHO is off.
    csv_update_glogowner.cmd
    ECHO is off.
    Parameters:
    Properties directory: D:\otm55\glog\config
    Connection ID for GLOGOWNER: dbaglogowner
    Version: V55P
    ECHO is off.
    ECHO is off.
    V55P_PARTITION_KEY_FORMULA
    Caught exception: java.sql.SQLException: Io Exception: The Network Adapter could not establish the connection
    ECHO is off.
    V55P_BN_CONTEXT
    Caught exception: java.sql.SQLException: Io Exception: The Network Adapter could not establish the connection
    ECHO is off.
    V55P_BN_TYPE
    Caught exception: java.sql.SQLException: Io Exception: The Network Adapter could not establish the connection
    .......

    regards
    Catherine
Working...
X