View Revisions: Issue #6901
| Summary | 0006901: Init of engine fails to query non-existent sym_parameter table on DB2 for i (AS400) | ||
|---|---|---|---|
| Revision | 2025-05-23 19:43 by elong | ||
| Description | The init() method of AbstractSymmetricEngine fails when SYM_PARAMETER table has not yet been created. The sym_parameter table is found in another library, so it tries to query SYM_PARAMETER and gets an error about the table missing. Also, this prevents users of the symadmin utility from creating new SymmetricDS tables on a new database endpoint. The platform gets the default schema by checking which library is assigned to the user. If no library is assigned, then the lookup for SYM_PARAMETER table scans any library for the table. The workaround is to assign a library to the user. The platform should check "CURRENT SCHEMA" if the schema is blank, and warn about missing assignment. |
||
| Revision | 2025-05-22 12:44 by pbelov | ||
| Description | The init() method of AbstractSymmetricEngine fails when SYM_PARAMETER table hod not yet been created. This crashes installation of a new engine, when joining existing (remote) replication server. Also, this prevents users of the symadmin utility from creating new SymmetricDS tables on a new database endpoint. |
||