View Issue Details

IDProjectCategoryView StatusLast Update
0003537SymmetricDSImprovementpublic2018-12-05 14:58
ReportervibhorejairathAssigned To 
Priorityhigh 
Status acknowledgedResolutionopen 
Product Version3.8.34 
Target Version3.9.16Fixed in Version 
Summary0003537: initial load create: Cascade Delete rule is not syncing as part of the create DDL
DescriptionSymmetric is not syncing the Cascade delete rule from Central node to Store node level and hence cascade delete is not working at the store level.
Steps To ReproduceRegister the store node to central node and allow schema and data to sync with store node. Open the table that has cascade rule set in Explore mode in Central and Store node and compare the delete rule for the same table.

See the attached files for the screen shots taken for the same table in Central and Store nodes

Relationships

has duplicate 0003409 closed Cascade clause is not being exported in the SQL DDL when syncing table DDL. 

Activities

vibhorejairath

2018-05-01 22:01

reporter  

Screen Shot Central Node.png (731,760 bytes)
Screen Shot Store Node.png (398,900 bytes)

vibhorejairath

2018-05-04 09:19

reporter   ~0001177

Any updates on the ticket.

vibhorejairath

2018-05-15 21:02

reporter   ~0001184

Kindly provide guidance as this is causing issue in production now

elong

2018-05-16 12:49

developer   ~0001185

The issue is that it is missing the "on delete cascade" clause when creating application tables during the initial load on a PostgreSQL database. Did I understand correctly?

vibhorejairath

2018-05-16 13:59

reporter   ~0001186

That is correct, It is happening during initial load

Issue History

Date Modified Username Field Change
2018-05-01 22:01 vibhorejairath New Issue
2018-05-01 22:01 vibhorejairath File Added: Screen Shot Central Node.png
2018-05-01 22:01 vibhorejairath File Added: Screen Shot Store Node.png
2018-05-04 09:19 vibhorejairath Note Added: 0001177
2018-05-15 21:02 vibhorejairath Note Added: 0001184
2018-05-16 12:49 elong Note Added: 0001185
2018-05-16 13:59 vibhorejairath Note Added: 0001186
2018-10-17 15:38 hanes Category Bug => Improvement
2018-10-17 15:38 hanes Target Version => 3.9.15
2018-10-17 15:39 hanes Status new => acknowledged
2018-10-31 14:20 admin Target Version 3.9.15 => 3.9.16
2018-12-05 14:52 hanes Summary Delete rule are not syncing from central node to store node => initial load create: Cascade Delete rule is not syncing as part of the create DDL
2018-12-05 14:58 hanes Relationship added has duplicate 0003409