WebSphere Application Server & Liberty

WebSphere Application Server & Liberty

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
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


Related Content