AutoSys Workload Automation

Expand all | Collapse all

WCC upgrade error on update derby database while using Oracle ?

  • 1.  WCC upgrade error on update derby database while using Oracle ?

    Posted 06-12-2018 05:47 AM

    Hello

     

    Before upgrade WCC from 11.4.4 to 11.4.6, I have migrated WCC derby database to Oracle

     

    To save space into WCC installation directory, I removed all datafiles from derby/DB_FILES/WCC_MAIN/seg0

     

    Then when I upgrade WCC, why is updating the derby database ?

    2018-06-12 11:11:30 : ApplyDBPatchAction::
    There was a problem with a database.

    2018-06-12 11:11:30 : ApplyDBPatchAction::
    ApplyDBPatchAction::DERBY SQL error: ERRORCODE: 40000, SQLSTATE: XJ040, SQLERRMC: Failed to start database 'WCC_MAIN' with class loader sun.misc.Launcher$AppClassLoader@5451c3a8, see the next exception for details.::SQLSTATE: 40XD2
    org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
    org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
    org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
    java.sql.DriverManager.getConnection(DriverManager.java:664)
    java.sql.DriverManager.getConnection(DriverManager.java:247)
    com.ca.wcc.install.utilities.DatabaseUtil.getConnectionForDb(DatabaseUtil.java:732)
    com.ca.wcc.install.utilities.DatabaseUtil.getConnection(DatabaseUtil.java:771)
    com.ca.wcc.install.utilities.DatabaseUtil.getReportingDBConnectionFromExistingWCCInstance(DatabaseUtil.java:1539)
    com.ca.wcc.install.actions.upgrade.ApplyDBPatchAction.install(ApplyDBPatchAction.java:80)
    com.zerog.ia.installer.actions.CustomAction.installSelf(Unknown Source)
    com.zerog.ia.installer.AAMgrBase.an(Unknown Source)

    ...

     

    Regards



  • 2.  Re: WCC upgrade error on update derby database while using Oracle ?

    Posted 06-12-2018 10:35 AM

    For info, I have restored WCC installation directory with all derby database files then I upgraded again WCC with success this time

    But I would know why WCC still needs a derby database while the installation was updated with an Oracle database ?