"Unable to open the multiplex database. The database can only be opened by starting the Coordinator server using single node mode switch '-iqmpx_sn 1'. %1"
Item | Description |
---|---|
SQLCode |
-1010059L |
Constant |
EMSG_MPX_OPEN_OLDDB_NEED_SINGLE |
SQLState |
QXA58 |
ODBC 2 State |
ERROR |
ODBC 3 State |
ERROR |
Sybase Error Code |
22023 |
Severity Code |
|
Parameter 1 |
location of the exception |
An older version of multiplex database can only be opened bystarting the server in single node mode. If you upgraded the database when server was started using '-iqro 1', then database still needs to be opened by booting the coordinator server in single node mode but without '-iqro 1'. This is because internal IQ on-disk structures could not be upgraded earlier. To complete the upgrade, open the database by starting the coordinator server using single node mode switch '-iqmpx_sn 1', but without '-iqro 1'. After a clean shutdown, the database can then be started normally.