View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005943 | SymmetricDS | Bug | public | 2023-08-03 13:58 | 2024-12-31 18:11 |
| Reporter | achintya.de@uk.daiwacm.com | Assigned To | pmarzullo | ||
| Priority | high | ||||
| Status | assigned | Resolution | open | ||
| Product Version | 3.14.7 | ||||
| Summary | 0005943: JZ0NK: Generated keys are not available because either the Statement.NO_GENERATED_KEYS was used or no keys were automatically ge | ||||
| Description | SymDS is chucking "JZ0NK: Generated keys are not available because either the Statement.NO_GENERATED_KEYS was used or no keys were automatically generated" errors in the errorlog and replication is stand still. The source DBMS is; Microsoft SQL Server Target DBMS is: SAP Sybase ASE Using jConn4.jar file for Sybase ASE by the way It is setup using database level replication ie one channel for all tables and also using transactional mode it is a bi-directional replication which is working from Sybase To SQL Server If i take the data from the sym_data table from SQL Server and run in Sybase it works but SymDS isnt doing it automatically and chucking that error This is stopping my project to go-live as this errors are appearing on UAT/Test environment Please let me know your thought and remedies | ||||
| Tags | dialect: sybase | ||||
|
|
What version of SymmetricDS are you using? What version of Sybase ASE are you using? What JDBC driver version are you using? |
|
|
thank you for looking into it, here these are: What version of SymmetricDS are you using? 3.14 What version of Sybase ASE are you using? 16.0 SP03 PL11 What JDBC driver version are you using? symds server has jre 8, ive copied sybase jConn4.jar file jConnect-7_0/ BTW, what do you recommend to use instead, if you pls let me know i can make sure I'll comply those. thanks again |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-08-03 13:58 | achintya.de@uk.daiwacm.com | New Issue | |
| 2023-08-09 17:43 | pmarzullo | Assigned To | => pmarzullo |
| 2023-08-09 17:43 | pmarzullo | Status | new => feedback |
| 2023-08-09 17:43 | pmarzullo | Note Added: 0002369 | |
| 2023-08-10 09:21 | achintya.de@uk.daiwacm.com | Note Added: 0002372 | |
| 2023-08-10 09:21 | achintya.de@uk.daiwacm.com | Status | feedback => assigned |
| 2024-12-31 18:11 | emiller | Tag Attached: dialect: sybase |