WebSphere Application Server & Liberty

 View Only
Expand all | Collapse all

WebSphere Extreme Scale console startup issue

  • 1.  WebSphere Extreme Scale console startup issue

    Posted Thu January 19, 2023 02:34 AM
    I just installed and configured WebSphere Extreme Scale v8.6.1.5 on RHEL8. And I'm trying to use the Web Console. But it's failing to start.

    [root@armless1 WebSphere]# ./eXtremeScaleStandalone/ObjectGrid/bin/startConsoleServer.sh 
CWPZT0600I: Command resolve was successful
CWPZC9020E: Could not begin local transaction
[error]Error migrating to the latest database schema.  See the following log file for more details /opt/IBM/WebSphere/eXtremeScaleStandalone/ObjectGrid/console/logs/startConsoleServer.log.

    In the log file, I saw the failure below.
    2023-01-16 23:00:33:344 :: Creating new XS database using schema version: 1.0.0.2
2023-01-16 23:00:34:257 :: Error migrating to the latest database schema.  See the following log file for more details /opt/IBM/WebSphere/eXtremeScaleStandalone/ObjectGrid/console/logs/startConsoleServer.log.
2023-01-16 23:00:34:261 :: java.lang.RuntimeException: ERROR XBM0X: Supplied territory description 'c.u_US' is invalid, expecting ln[_CO[_variant]]
ln=lower-case two-letter ISO-639 language code, CO=upper-case two-letter ISO-3166 country codes, see java.util.Locale.
:

    Strangely when I tried to start the console again, the error message was changed as below.

    [root@armless1 WebSphere]# ./eXtremeScaleStandalone/ObjectGrid/bin/startConsoleServer.sh
    CWPZT0600I: Command resolve was successful
CWZCO1011E: Could not retrieve resource: [pdq][0][2.7.116] CWPZC9001E: Could not obtain Connection from org.apache.derby.jdbc.EmbeddedDataSource;  Caused by: java.sql.SQLException: Failed to create database '/opt/IBM/WebSphere/eXtremeScaleStandalone/ObjectGrid/console/databases/rainmaker-db', see the next exception for details.
com.ibm.pdq.runtime.exception.DataRuntimeException: [pdq][0][2.7.116] CWPZC9001E: Could not obtain Connection from org.apache.derby.jdbc.EmbeddedDataSource;  Caused by: java.sql.SQLException: Failed to create database '/opt/IBM/WebSphere/eXtremeScaleStandalone/ObjectGrid/console/databases/rainmaker-db', see the next exception for details.
    
    zero.data.internal.DataRuntimeExceptionFactory.create(DataRuntimeExceptionFactory.java:14)
CWPZC9020E: Could not begin local transaction
[error]Error migrating to the latest database schema.  See the following log file for more details /opt/IBM/WebSphere/eXtremeScaleStandalone/ObjectGrid/console/logs/startConsoleServer.log.

    Because I got the apache derby message "XBM0X", I doubted the locale (C.utf8) and tried en_US.utf8. But still we get the failure below.

    [root@armless1 WebSphere]# export LANG=en_US.utf8
[root@armless1 WebSphere]# export LC_ALL=en_US.utf8
[root@armless1 WebSphere]# ./eXtremeScaleStandalone/ObjectGrid/bin/stopConsoleServer.sh 
[info]WebSphere eXtreme Scale console server stopped successfully
[root@armless1 WebSphere]# ./eXtremeScaleStandalone/ObjectGrid/bin/startConsoleServer.sh 
CWPZT0600I: Command resolve was successful
CWZCO1011E: Could not retrieve resource: [pdq][10101][2.7.116] An error prevented the SQL query from completing successfully.;  Caused by: java.sql.SQLSyntaxErrorException: Table/View 'VERSION' does not exist.
com.ibm.pdq.runtime.exception.DataRuntimeException: [pdq][10101][2.7.116] An error prevented the SQL query from completing successfully.;  Caused by: java.sql.SQLSyntaxErrorException: Table/View 'VERSION' does not exist.
    
    com.ibm.pdq.runtime.internal.db.JdbcData.queryResultsInternal_(JdbcData.java:158)
:
CWPZC9021E: <Local transaction: 76f23019-57a0-45f9-9c2d-6cd124f38418> failed
[error]Error migrating to the latest database schema.  See the following log file for more details /opt/IBM/WebSphere/eXtremeScaleStandalone/ObjectGrid/console/logs/startConsoleServer.log.

    How can I fix this?

    ------------------------------
    Yoshiki Yamada
    IBM Japan
    ------------------------------


  • 2.  RE: WebSphere Extreme Scale console startup issue

    Posted Thu January 19, 2023 02:41 AM
    This is a known issue that the apace derby doesn't accept a certain format of locale like C.utf8. As a tentative workaround, you can simply delete the following directory after taking the backup. Then, you can start the console after setting the acceptable locale like en_US.utf8
    <WXS_ROOT>/ObjectGrid/console/databases
    The deletion ofrainmaker-db under the databases is not sufficient. If the databases directory exists, the product code still assumes the database should be there.

    ------------------------------
    Yoshiki Yamada
    IBM Japan
    ------------------------------

    Original Message