View Issue Details

IDProjectCategoryView StatusLast Update
0003644SymmetricDSBugpublic2018-08-03 10:12
ReportermmichalekAssigned Tommichalek 
Prioritynormal 
Status closedResolutionfixed 
Product Version3.9.10 
Target Version3.9.10Fixed in Version3.9.10 
Summary0003644: Deleting a trigger associated with an unextracted batch causes invalid CSV
DescriptionThe scenario with the demo set:
1) Create a batch that has both item and item_selling_price data in it.
2) Delete the sym_trigger_router and sym_trigger for item_selling_price.
3) Delete the batch file and click "show CSV" on the Pro, or pull the batch again with the community edition.

Invalid batch data is generated like this (note there should be a TABLE, declration between the 2 inserts)

nodeid,000
binary,BASE64
channel,item
batch,81
catalog,
schema,
table,item
keys,ITEM_ID
columns,ITEM_ID,NAME
insert,"11000002","Yummy Gum2"
insert,"11000002","002","0.30","0.20"
commit,81

Attempting to load batches like this may result in messages like the following:

The number of columns (%d) reported for table '%s' doesn't match up with the token count (%d) data: %s

This is the corrected CSV in this case:
nodeid,000
binary,BASE64
channel,item
batch,81
catalog,
schema,
table,item
keys,ITEM_ID
columns,ITEM_ID,NAME
insert,"11000002","Yummy Gum2"
catalog,
schema,
table,item_selling_price
keys,ITEM_ID,STORE_ID
columns,ITEM_ID,STORE_ID,PRICE,COST
insert,"11000002","002","0.30","0.20"
commit,81

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.9 fe8f0439

2018-07-23 15:24:37

mmichalek

Details Diff
0003644: Deleting a trigger associated with an unextracted batch causes
invalid CSV

0003644
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java Diff File

Issue History

Date Modified Username Field Change
2018-07-23 15:19 mmichalek New Issue
2018-07-23 15:19 mmichalek Status new => assigned
2018-07-23 15:19 mmichalek Assigned To => mmichalek
2018-07-23 15:25 mmichalek Status assigned => resolved
2018-07-23 15:25 mmichalek Resolution open => fixed
2018-07-23 15:25 mmichalek Fixed in Version => 3.9.10
2018-07-23 16:00 mmichalek Changeset attached => SymmetricDS 3.9 fe8f0439
2018-08-03 10:12 chenson Status resolved => closed