View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006445 | SymmetricDS | Bug | public | 2024-05-23 11:38 | 2024-05-23 11:53 |
| Reporter | mraseem | Assigned To | |||
| Priority | urgent | ||||
| Status | new | Resolution | open | ||
| Product Version | 3.15.3 | ||||
| Summary | 0006445: JSON payload for kafka is not in correct format (missing comma at the end of row on bulk update,delete and single insert,update | ||||
| Description | Hi Team Am working on symmetricds 3.15.3 version. replicating the data from sybase to kafka. i have noticed the following things on kafka. i did a 20 rows insert from sybase to kafka, i can see each in each row end it given a comma to sepearate it. for e.g :- {"statuscode":{"event type":"INSERT","data":{"status":"0","status_desc":"AVAILABLE"}}}, {"statuscode":{"event type":"INSERT","data":{"status":"1","status_desc":"NOT AVAILABLE"}}}, {"statuscode":{"event type":"INSERT","data":{"status":"2","status_desc":"LOST"}}}, {"statuscode":{"event type":"INSERT","data":{"status":"3","status_desc":"RECEIVED"}}}, over here you can see at the end all row are seperated by a comma but when i do a bulk update or delete or manually insert, update and delete one row , comma is not showing. is there a way i can provide a comma after each row, when a DML operation happend(insert,update,delete). Please find the below screenshot for the reference | ||||
| Tags | No tags attached. | ||||
|
|
Hi Team, am using symadmin module kafka to publish the sybase database to kafka. when am doing the one single insert,update,delete and bulk update/delete, we have noticed there is JSON message which come from kafka publisher is not in a correct format.(ie :- we are missing comma at the end of each row) {"statuscode":{"event type":"delete","data":{"status":"1","status_desc":"NOT AVAILABLE"}}} {"statuscode":{"event type":"INSERT","data":{"status":"1","status_desc":"NOT AVAILABLE"}}} but when i do it on bulk insert transaction on sybase DB we can see a comma is coming in the kafka publisher messages. {"statuscode":{"event type":"INSERT","data":{"status":"0","status_desc":"AVAILABLE"}}}, {"statuscode":{"event type":"INSERT","data":{"status":"1","status_desc":"NOT AVAILABLE"}}}, {"statuscode":{"event type":"INSERT","data":{"status":"2","status_desc":"LOST"}}}, {"statuscode":{"event type":"INSERT","data":{"status":"3","status_desc":"RECEIVED"}}}, Could you please let me know, how to fix the issues |
|
|
|