View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0004698 | SymmetricDS | Bug | public | 2020-12-10 14:00 | 2021-01-11 13:47 |
| Reporter | pmarzullo | Assigned To | pmarzullo | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.12.5 | ||||
| Target Version | 3.12.6 | Fixed in Version | 3.12.6 | ||
| Summary | 0004698: Sybase Quick Config fails to get schemas when changing catalog selection | ||||
| Description | When there are more than one catalog (database) defined in Sybase, and the catalog selection is changed during the Quick Config wizard, the retrieval of the schemas fails and removes the schema drop down field. If the tables desired to synch are in the dbo schema, they are available to select, but when the trigger is saved into sym_trigger, the source schema is not saved with it, and the creation of the triggers fails when synch triggers is run. We need a ChangeCatalogConnectionHandler to be created when using Sybase ASE. | ||||
| Steps To Reproduce | 1. Create more than one database to be made available from Sybase ASE. 2. Create more than one schema in the databases. 3. Run the Quick Config wizard against the Sybase ASE database. 4. Change the selected catalog to another catalog. 5. Schema drop down will be removed. 6. Save generated triggers from wizard. 7. Source schema will be empty and will cause the create trigger functionality to fail. | ||||
| Tags | dialect: sybase, trigger | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-12-10 14:00 | pmarzullo | New Issue | |
| 2020-12-10 14:00 | pmarzullo | Status | new => assigned |
| 2020-12-10 14:00 | pmarzullo | Assigned To | => pmarzullo |
| 2020-12-10 14:00 | pmarzullo | Tag Attached: dialect: sybase | |
| 2020-12-10 14:00 | pmarzullo | Tag Attached: trigger | |
| 2020-12-10 14:02 | pmarzullo | Status | assigned => resolved |
| 2020-12-10 14:02 | pmarzullo | Resolution | open => fixed |
| 2020-12-10 14:02 | pmarzullo | Fixed in Version | => 3.12.6 |
| 2020-12-10 15:00 | pmarzullo | Changeset attached | => SymmetricDS 3.12 6429d080 |
| 2021-01-11 13:47 | admin | Status | resolved => closed |