View Issue Details

IDProjectCategoryView StatusLast Update
0002324SymmetricDSBugpublic2019-04-23 19:36
Reporterwoehrl01 Assigned Tochenson  
Prioritynormal 
Status closedResolutionno change required 
Product Version3.7.19 
Target Version3.7.21Fixed in Version3.7.21 
Summary0002324: Creation of varchar(max) column fails with Error 2717
DescriptionA table with a varchar(max) columns fails to sync, because it can't create/alter the table.

The reported error is:
Error 2717: The size (2147483647) given to the column ‘column1 exceeds the maximum allowed (8000).

it seams the produced statement is

alter table add column1 varchar(2147483647)

instead of varchar(max) or text for size > 8000

maybe there is a relation to 0002200

the xml shows that the definiton is "longvarchar" and the size is 2147483647
TagsNo tags attached.

Relationships

related to 0002423 closedemiller Create table with max varchar supported by target 

Activities

chenson

2015-06-20 15:25

administrator   ~0000692

What are the source and target database types?

woehrl01

2015-06-20 23:22

reporter   ~0000693

Both are sqlserver 2008 r2

woehrl01

2015-09-11 12:42

reporter   ~0000717

It seams that I have used a bad build. I compiled from the latest sources and the problem is resolved.

chenson

2015-09-11 12:48

administrator   ~0000718

The fix is in 3.8.21 which isn't released yet. It was checked in as part of 0002377

chenson

2015-09-11 12:49

administrator   ~0000719

fixed as part of 0002377

Issue History

Date Modified Username Field Change
2015-06-19 13:15 woehrl01 New Issue
2015-06-20 15:25 chenson Note Added: 0000692
2015-06-20 23:22 woehrl01 Note Added: 0000693
2015-09-11 12:42 woehrl01 Note Added: 0000717
2015-09-11 12:48 chenson Note Added: 0000718
2015-09-11 12:49 chenson Assigned To => chenson
2015-09-11 12:49 chenson Status new => assigned
2015-09-11 12:49 chenson Fixed in Version => 3.7.21
2015-09-11 12:49 chenson Target Version => 3.7.21
2015-09-11 12:49 chenson Note Added: 0000719
2015-09-11 12:49 chenson Status assigned => resolved
2015-09-11 12:49 chenson Resolution open => no change required
2015-09-11 20:14 chenson Status resolved => closed
2019-04-23 19:36 elong Relationship added related to 0002423